headitmanagerDaily Transactions on Flow
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with nft_sales as (select count(*),sum(price),block_timestamp::date from flow.core.fact_nft_sales
where block_timestamp::date >= '2022-04-16'
group by block_timestamp::date)
,nft_sales1 as (select count(*),sum(price),monthname(block_timestamp::date) from flow.core.fact_nft_sales
where block_timestamp::date >= '2022-04-16'
group by monthname(block_timestamp::date))
, flow_transactions as (select count(*),block_timestamp::date from flow.core.fact_transactions
where block_timestamp::date >= '2022-04-16'
group by block_timestamp::date)
, flow_swap as (select count(*),block_timestamp::date from flow.core.fact_swaps
where block_timestamp::date >'2022-04-16'
group by block_timestamp::date)
,shot as (select count(*),block_timestamp::date from flow.core.fact_nft_sales where nft_collection='A.0b2a3299cc857e29.TopShot'
and block_timestamp::date >'2022-04-16'
group by block_timestamp::date)
,shot1 as (select count(*),monthname(block_timestamp::date) from flow.core.fact_nft_sales where nft_collection='A.0b2a3299cc857e29.TopShot'
and block_timestamp::date >'2022-04-16'
group by monthname(block_timestamp::date))
select * from flow_transactions
Run a query to Download Data