Stin00Untitled Query
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
›
⌄
--darvishi
SELECT
date_trunc('day', block_timestamp) as day,
CASE WHEN
block_timestamp > '2022-08-15' THEN 'post hack' ELSE 'pre_hack' END as time_period,
count(DISTINCT tx_hash) as transactions,
count(DISTINCT origin_from_address) as users,
sum(amount_in_usd) as volume
FROM optimism.velodrome.ez_swaps
GROUP BY 1,2