MLDZMNTotal Sale volume
Updated 2024-05-01
999
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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- #6574FF - Blue ETH
-- #EC5646 - Orange Solana
-- #972EFF - Purple Polygon
-- #FFAFCC - Light Pink Accent Avalanche
-- #B8A3FF - Light Purple Accent Flow
-- #8793FF - Light Blue Accent Arbitrum
-- #FFA599 - Dark Orange Accent Optimism
-- #4B5AFF - Dark Blue Accent Base
with sol_price as (
SELECT
RECORDED_HOUR :: date as day,
avg(close) as sol_price
from
solana.price.fact_token_prices_hourly
where
SYMBOL = 'SOL'
and day >= '{{Start_date}}'
group by
day
),
flow_price as (
SELECT
trunc(recorded_hour,'day') as day,
avg(close) as price_token
from flow.price.fact_hourly_prices
where token='Flow'
group by 1
)
-------------------------------------------------------------------------------------------
select
'Ethereum' as chain,
round(sum(price_usd), 2) as "Volume USD",
QueryRunArchived: QueryRun has been archived