Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
bat9go
/
tutela-app
zrkadlo https://github.com/TutelaLabs/tutela-app
Pridať medzi pozorované 1
Hviezda 0
Fork 0
Súbory Issues 0 Wiki
Strom: 42c41730fa
Branche Tagy
tutela-app
/
scripts
/
tornadocash
/
bq_commands.sh

bq_commands.sh 1.1 KB
História Raw

12345678910111213 
  1. #!/bin/bash
    2. 

  2. 

  3. # load contract table into bigquery (to be run once)
    4. 

  4. bq load lexical-theory-329617:tornado_transactions.tornadocontracts ./data/static/tcash/tornadocontracts.csv ./data/static/tcash/tornadocontracts_schema.json
    5. 

  5. # make (empty) traces and transactions table
    6. 

  6. bq mk --schema ./data/static/tcash/traces_schema.json lexical-theory-329617:tornado_transactions.traces
    7. 

  7. bq mk --schema ./data/static/tcash/transactions_schema.json lexical-theory-329617:tornado_transactions.transactions
    8. 

  8. 

  9. # make tornado traces table
    10. 

  10. bq query --destination_table lexical-theory-329617:tornado_transactions.traces --use_legacy_sql=false 'select * from bigquery-public-data.crypto_ethereum.traces where (to_address in (select address from lexical-theory-329617.tornado_transactions.tornadocontracts)) and substr(input, 1, 10) in ("0xb214faa5", "0x21a0adb6")'
    11. 

  11. # make tornado transactions table
    12. 

  12. bq query --destination_table lexical-theory-329617:tornado_transactions.transactions --use_legacy_sql=false 'select * from bigquery-public-data.crypto_ethereum.transactions as b where b.hash in (select transaction_hash from lexical-theory-329617.tornado_transactions.traces)'
    13. 

  13.