flipside

    Volume by Token Address out of the pools
    nits Volume by Token Address out of the pools
    Updated 2022-05-26
    SELECT * from
    (SELECT token_address, sum(amount_usd) as total_volume
    from ethereum.dex_swaps
    where block_timestamp >= '2022-05-07' and block_timestamp<'2022-05-15' and amount_usd < pow(10,7) and direction = 'OUT'
    GROUP by 1 )
    inner join ethereum_core.dim_contracts on address = token_address
    order by 2 desc
    limit 10
    Run a query to Download Data