Pine AnalyticsEIGEN Token 1
Updated 2024-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date_trunc('hour', block_timestamp) as hour,
count(DISTINCT tx_hash) as events,
count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,
sum(case when AMOUNT_OUT is null then AMOUNT_IN else AMOUNT_OUT end) as volume_usd
from ethereum.defi.ez_dex_swaps
WHERE token_in LIKE lower('0xec53bF9167f50cDEB3Ae105f56099aaaB9061F83')
or token_out LIKE lower('0xec53bF9167f50cDEB3Ae105f56099aaaB9061F83')
GROUP BY 1
QueryRunArchived: QueryRun has been archived