DATE_TRUNC('day', block_timestamp) AS day,

AVG(tx_fee) AS avg_transaction_fee,

'Avalanche' AS blockchain

FROM

avalanche.core.fact_transactions

where block_timestamp >= '2024-07-01'

GROUP BY

day

UNION ALL

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

AVG(tx_fee) AS avg_transaction_fee,

'BNB Chain' AS blockchain

FROM

bsc.core.fact_transactions

where block_timestamp >= '2024-07-01'

GROUP BY

day

ORDER BY

day;