Updated 2023-05-13
    with all_transfers AS (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    from_address,
    to_address,
    contract_address,
    symbol,
    amount,
    amount_usd
    from ethereum.core.ez_token_transfers
    WHERE block_timestamp > '2022-11-00'-- '2022-11-01'
    union
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    eth_from_address,
    eth_to_address,
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' as contract_address, -- take weth price
    'ETH' as symbol, -- 'ETH' but actually eth / for pricing missing tables
    amount,
    amount_usd
    from ethereum.core.ez_eth_transfers
    WHERE block_timestamp > '{{date}}'
    )
    SELECT * FROM all_transfers;


    Run a query to Download Data