jackguyCRV_4_1 copy
Updated 2023-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
-- forked from c4de0d51-7505-496e-9394-ba4d6b7ec4a6
-- forked from b06293b5-c201-40c4-b52b-4ed5e381ea96
-- forked from 00efe27a-567c-4112-82eb-b3637037c23a
-- forked from a7b07f01-336a-44cb-9013-8e71e6842b4e
SELECT
date_trunc('hour', block_timestamp) as hour,
sum(amount_in_usd) as swap_volume_usd,
count(DISTINCT origin_from_address) as users,
count(DISTINCT tx_hash) as events
FROM ethereum.core.ez_dex_swaps
WHERE contract_address LIKE lower('0xA5407eAE9Ba41422680e2e00537571bcC53efBfD')
AND block_timestamp > '2023-03-01'
--LIMIT 100
GROUP BY 1
Run a query to Download Data