sinahosseinzadehUntitled Query
    Updated 2022-08-08
    with table1 as (
    select
    block_timestamp::date as date,
    symbol,
    amount_usd
    from ethereum.core.ez_token_transfers
    where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and block_timestamp >= '2022-07-01' and block_timestamp < '2022-08-01'
    and symbol is not null),

    table2 as (
    select block_timestamp::date as date,
    'ETH' as symbol,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and block_timestamp >= '2022-07-01' and block_timestamp < '2022-08-01'),

    maintable as (select * from table1 union all select * from table2)

    select symbol, sum(amount_usd) as total_volumes_usd
    from maintable
    where amounT_usd is not null
    group by 1
    order by 2 desc
    limit 10
    Run a query to Download Data