SocioAnalyticatoken breakdown
Updated 2024-07-18
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
›
⌄
with data as (
select
'perp' as type,
*
from blast.blitz.ez_perp_trades
-- union all
-- select
-- 'spot' as type,
-- *
-- from
)
select
date_trunc('d', block_timestamp) as date,
symbol,
sum(amount_usd) as volume,
sum(volume) over (partition by symbol order by date) as cum_volume
from data
where is_taker = 'TRUE'
group by 1 , 2
order by 1 desc
QueryRunArchived: QueryRun has been archived