tutela-app/scripts/bq_commands.sh

# get txs from 1 week
bq --location=US query --destination_table lexical-theory-329617:crypto_ethereum.transactions_1week --use_legacy_sql=false "select from_address, to_address, value, block_timestamp, block_number from bigquery-public-data.crypto_ethereum.transactions where (block_number >= 13285098) and (block_number <= 13330090)"

# get txs from 1 month
bq --location=US query --destination_table lexical-theory-329617:crypto_ethereum.transactions_1month --use_legacy_sql=false "select from_address, to_address, value, block_timestamp, block_number from bigquery-public-data.crypto_ethereum.transactions where (block_number >= 13136427) and (block_number <= 13330090)"

# get txs from 1 year
bq --location=US query --destination_table lexical-theory-329617:crypto_ethereum.transactions_1year --use_legacy_sql=false "select from_address, to_address, value, block_timestamp, block_number from bigquery-public-data.crypto_ethereum.transactions where (block_number >= 10966874) and (block_number <= 13330090)"

# get all txs before date
bq --location=US query --destination_table lexical-theory-329617:crypto_ethereum.transactions3 --use_legacy_sql=false "select b.from_address, b.to_address, b.hash as transaction, b.value, b.block_timestamp, b.block_number from bigquery-public-data.crypto_ethereum.transactions as b where b.block_number <= 13330090"

# get blocks before date
bq --location=US query --destination_table lexical-theory-329617:crypto_ethereum.blocks --use_legacy_sql=false "select * from bigquery-public-data.crypto_ethereum.blocks where block_number <= 13330090"