headitmanagerTotal each day
Updated 2022-09-05
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
25
26
27
28
29
›
⌄
with t_v_sales as (select count(*),sum(price),block_timestamp::date from flow.core.ez_nft_sales inner join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id=flow.core.dim_allday_metadata.nft_id
group by block_timestamp::date)
,buyer as (select count(distinct buyer),block_timestamp::date from flow.core.ez_nft_sales
group by block_timestamp::date)
,seller as (select count(distinct seller),block_timestamp::date from flow.core.ez_nft_sales
group by block_timestamp::date)
,player as (select count(*),sum(price),player from flow.core.ez_nft_sales inner join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id=flow.core.dim_allday_metadata.nft_id
where player!='N/A'
group by player)
,player_overtime as (select count(*),sum(price),player,block_timestamp::date from flow.core.ez_nft_sales inner join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id=flow.core.dim_allday_metadata.nft_id
where player!='N/A'
group by player,block_timestamp::date)
,position as (select count(*),sum(price),MOMENT_STATS_FULL:metadata:playerPosition from flow.core.ez_nft_sales inner join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id=flow.core.dim_allday_metadata.nft_id
where MOMENT_STATS_FULL:metadata:playerPosition is not null
group by MOMENT_STATS_FULL:metadata:playerPosition)
,position_overtime as (select count(*),sum(price),MOMENT_STATS_FULL:metadata:playerPosition,block_timestamp::date from flow.core.ez_nft_sales inner join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id=flow.core.dim_allday_metadata.nft_id
where MOMENT_STATS_FULL:metadata:playerPosition is not null
group by MOMENT_STATS_FULL:metadata:playerPosition,block_timestamp::date )
,player_position as (select count(*),sum(price),player,MOMENT_STATS_FULL:metadata:playerPosition from flow.core.ez_nft_sales inner join flow.core.dim_allday_metadata
on flow.core.ez_nft_sales.nft_id=flow.core.dim_allday_metadata.nft_id
where player!='N/A'
group by player,MOMENT_STATS_FULL:metadata:playerPosition)
select * from t_v_sales
Run a query to Download Data