0xaimanUntitled Query
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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