headitmanagerTotal each day
    Updated 2022-09-05
    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