nitsLast x days most value in $ transferring addresses
    Updated 2022-08-10
    with addr as
    (SELECT address as ad, address_name as name from crosschain.address_labels
    where address_name ilike '%tornado%eth%' and project_name = 'tornado cash'
    ),
    senders as
    (SELECT tx_hash as tx, origin_from_address as sender from ethereum.core.fact_event_logs
    where contract_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b' and event_name = 'EncryptedNote' and
    date(block_timestamp) >= CURRENT_DATE -{{last_days}}
    GROUP by 1,2)

    SELECT sender,sum(amount_usd) as total_amt from
    (SELECT block_timestamp, tx_hash, amount, amount_usd from ethereum.core.ez_eth_transfers
    where tx_hash in
    (SELECT tx_hash from ethereum.core.fact_event_logs
    where contract_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b' and event_name = 'EncryptedNote' and
    date(block_timestamp) >= CURRENT_DATE -{{last_days}} )
    GROUP by 1,2,3,4 )
    inner join senders
    on tx=tx_hash
    GROUP by 1
    order by 2 desc
    limit 10
    Run a query to Download Data