jackguyCRV_1_1
Updated 2023-06-15
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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('0xDcEF968d416a41Cdac0ED8702fAC8128A64241A2')
AND block_timestamp > '2023-03-01'
--LIMIT 100
GROUP BY 1
Run a query to Download Data