jackguyCRV_4_2 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 d53dd8ad-c90c-4047-b24e-4f97f8a43bc3
-- forked from 57f093cd-4079-494d-a3bb-e6cc706cbe89
-- forked from 1f5f819f-9b6b-4743-95e2-f9c46d2c2b0a
-- forked from 5f7eba8b-f847-4ff0-b843-c52ea9ca4939
SELECT
-- date_trunc('day', block_timestamp) as day,
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