Sandeshnear-pink
Updated 2024-11-20
9
1
2
3
4
5
6
7
›
⌄
select date_trunc('minute',block_timestamp) as hour, '0xeb6d78148f001f3aa2f588997c5e102e489ad341' as token_address, avg(amount_out/amount_in) as price from base.defi.ez_dex_swaps
where token_in='0xeb6d78148f001f3aa2f588997c5e102e489ad341'
and token_out='0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'
and contract_address='0x58c5649e6bc93969f4530673e8892faf762cc7e7'
AND block_timestamp>= '2024-05-06'
group by hour
order by hour desc
QueryRunArchived: QueryRun has been archived