mucrypto2023-06-20 05:19 PM
    Updated 2023-06-22
    select
    symbol,
    sum(amount_usd) as volume_usd
    from ethereum.core.ez_token_transfers
    where origin_from_address = '0x31f55d64752686d6b5a7d02d780370c58035226e'
    group by 1
    having volume_usd is not null
    order by 2 desc

    -- where tx_hash = '0x2515249075d8294f6a269c3cd587ad5fcec47a2c72808ed7465a252a5ceefdf1'
    -- and block_timestamp::date = '2023-06-22'

    -- and symbol = 'PEPE'
    -- where to_address like '0x31f5%'
    -- and block_timestamp::date = '2023-06-21'
    -- and symbol = 'PEPE'
    -- order by usd desc
    Run a query to Download Data