NavidUntitled Query
Updated 2022-07-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with nft_transactions as (
SELECT
dtm.play_type,
date(fns.BLOCK_TIMESTAMP) as day,
count(distinct tx_id) as transactions_count
FROM
flow.core.fact_nft_sales fns join flow.core.dim_topshot_metadata dtm on fns.nft_id=dtm.nft_id
group by
dtm.play_type, date(fns.BLOCK_TIMESTAMP)
order by
dtm.play_type, date(fns.BLOCK_TIMESTAMP)
)
select
day,
play_type,
sum(transactions_count) as sum_transactions_count,
sum(sum_transactions_count) over (partition by play_type order by day asc) as volume
from
nft_transactions
group by
play_type, day
order by
day asc
Run a query to Download Data