12203 rows yesterday at 4:36 PM
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
select
date_trunc('hour', timestamp) as chart_x,
avg(amounts['0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48']) as chart_y_usdc,
avg(amounts['0xdac17f958d2ee523a2206206994597c13d831ec7']) as chart_y_usdt,
avg(amounts['0x6b175474e89094c44da98b954eedeac495271d0f']) as chart_y_dai
from
defi_liquidity_snapshots_ethereum_mainnet_v1
where
contract = '0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7'
and chart_x >= '2023-08-01'
group by
chart_x
order by
chart_x asc