blocmates researchVolume dominance
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
CAST(Date AS DATE) AS date,
CAST(sum(total_volume) AS NUMBER) AS volume,
CAST(project AS VARCHAR) AS project,
'Solana' as chain
FROM
$query('031cbd70-8165-4955-9500-d4378a46d14d')
where
date >= DATEADD(DAY, -90, CURRENT_DATE)
and total_volume>0
group by date,project,chain
union all
SELECT
CAST(Date AS DATE) AS date,
CAST(sum(total_volume) AS NUMBER) AS volume,
CAST(project AS VARCHAR) AS project,
'Base' as chain
FROM
$query('d7b9c130-5d37-4f3b-8837-630e55bbb4bd')
where
date >= DATEADD(DAY, -90, CURRENT_DATE)
and total_volume>0
group by date,project,chain