select BLOCK_TIMESTAMP::date as date

,count(distinct BUYER) as nft_buyers

,count(distinct SELLER) as nft_sellers

,count(distinct TX_ID) as nft_sale_txs

from flow.core.ez_nft_sales

where date>='2023-03-01'

group by 1),

tab2 as (

select BLOCK_TIMESTAMP::date as date

,count(distinct FLOW_WALLET_ADDRESS) as bridgers

,count(distinct TX_ID) as bridge_txs

from flow.core.ez_bridge_transactions

where date>='2023-03-01'

group by 1 ),

tab3 as (

select BLOCK_TIMESTAMP::date as date

,count(distinct DELEGATOR) as delegators

,count(distinct TX_ID) as stake_txs

from flow.core.ez_staking_actions

where date>='2023-03-01'

group by 1 ),

tab4 as (

select BLOCK_TIMESTAMP::date as date

,count(distinct TRADER) as swappers

,count(distinct TX_ID) as swap_txs

from flow.core.ez_swaps

where date>='2023-03-01'

group by 1),

tab5 as (

select BLOCK_TIMESTAMP::date as date

,count(distinct SENDER) as transmitters

,count(distinct TX_ID) as transfer_txs

from flow.core.ez_token_transfers

where date>='2023-03-01'

group by 1)