-- Parts of this query are forked and inspired from https://flipsidecrypto.xyz/optimus_prime/aptos-built-for-a-billion-people-rEKoh9 By Optimus_Prime
SELECT
'Ethereum' AS blockchain
, DATE_TRUNC('day', block_timestamp) AS transaction_day
, COUNT(*) AS total_transactions
FROM
ethereum.core.fact_transactions
WHERE 1=1
AND block_timestamp >= '2024-01-01'
GROUP BY
2
UNION ALL
SELECT
'Arbitrum' AS blockchain
, DATE_TRUNC('day', block_timestamp) AS transaction_day
, COUNT(*) AS total_transactions
FROM
arbitrum.core.fact_transactions
WHERE 1=1
AND block_timestamp >= '2024-01-01'
GROUP BY
2
UNION ALL
SELECT
'Base' AS blockchain
, DATE_TRUNC('day', block_timestamp) AS transaction_day
, COUNT(*) AS total_transactions
FROM
base.core.fact_transactions
WHERE 1=1
AND block_timestamp >= '2024-01-01'
GROUP BY