(SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs, sum(total_txs) over (order by day) as cumulative_txs , 'flow' as type

from flow.core.fact_nft_sales

where price >= '1000' and block_timestamp >= CURRENT_DATE -30

GROUP by 1)

, solana as

(SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs, sum(total_txs) over (order by day) as cumulative_txs , 'sol' as type

from solana.core.fact_nft_sales

where sales_amount >= '100' and block_timestamp >= CURRENT_DATE -30 and SUCCEEDED = 'TRUE'

GROUP by 1),

eth as

(SELECT date(block_timestamp) as day, count(DISTINCT tx_hash) as total_txs, sum(total_txs) over (order by day) as cumulative_txs , 'eth' as type

from ethereum.core.ez_nft_sales

where price >= '10' and block_timestamp >= CURRENT_DATE -30 and event_type = 'sale' and currency_symbol = 'ETH'

GROUP by 1)

SELECT * from eth

UNION ALL

SELECT * FROM flow

UNION ALL

SELECT * from solana