0xaimanUntitled Query
    Updated 2022-06-30
    Select t as dt, avg(usd_val) as avg_spent_usd

    from (select date(block_timestamp) as t, from_address, sum(amount_usd) as usd_val
    from ethereum.dex_swaps

    where --tx_id='0x7cb81dc0fb135d3eefdfac0afdbf397206af74950a6cea6951bd06e1d01eea08' and
    token_address='0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b' and direction='OUT'

    group by 1,2 order by 1)
    group by 1 order by 1

    limit 1000

    Run a query to Download Data