DATE(B.BLOCK_TIMESTAMP) AS Date

, (SUM(B.SIZE))/(1024*1024) AS Total_Size_MB

, COUNT(B.BLOCK_NUMBER) AS Number_Of_Blocks

, ((SUM(B.SIZE))/(1024*1024)) / COUNT(B.BLOCK_NUMBER) AS Avg_Block_Size_MB

, SUM(TX_COUNT) AS Total_Transactions

, SUM(TX_COUNT) / COUNT(B.BLOCK_NUMBER) AS Avg_Transaction_Per_Block

, SUM(M.fees) AS Transaction_Fees

, SUM(T.input_count) AS Total_Inputs

, SUM(T.output_count) AS Total_Outputs

FROM

bitcoin.core.fact_blocks AS B

LEFT JOIN bitcoin.gov.ez_miner_rewards AS M

ON B.block_number = M.block_number

LEFT JOIN bitcoin.core.fact_transactions AS T

ON T.block_number = B.block_number

WHERE

DATE(B.BLOCK_TIMESTAMP) >= DATE(GETDATE())-{{Last_Days}}

GROUP BY

DATE(B.BLOCK_TIMESTAMP)

ORDER BY

DATE(B.BLOCK_TIMESTAMP) DESC