with tb as ( select trunc(block_timestamp,'day') as day,

'Fifa' as project_name,

tx_group_id as tx,

nft_asset_id as nft,

purchaser as buyer,

TOTAL_SALES_AMOUNT_USD as usd_volume

from algorand.nft.ez_nft_sales_fifa

where sale_type = 'secondary'

select trunc(block_timestamp,'day') as day,

'Laliga Golazos' as project_name,

tx_id as tx,

nft_id as nft,

buyer,

price as usd_volume

from flow.core.ez_nft_sales

where nft_collection = 'A.87ca73a41bb50ad5.Golazos'

and TX_SUCCEEDED = 'TRUE'

select trunc(block_timestamp,'day') as day,

'TopShot' as project_name,

tx_id as tx,

nft_id as nft,

buyer,

price as usd_volume

from flow.core.ez_nft_sales

where nft_collection ilike '%topshot%'

and TX_SUCCEEDED = 'TRUE'

select trunc(block_timestamp,'day') as day,

'AllDay' as project_name,

tx_id as tx,

a.nft_id as nft,

buyer,

price as usd_volume