BLOCK_TIMESTAMP::DATE AS Date

, COUNT(*) AS TX_Number

, COUNT(DISTINCT FROM_ADDRESS) AS Users

, COUNT(DISTINCT TO_ADDRESS) AS Smart_Contracts

, COUNT(CASE WHEN TX_SUCCEEDED THEN 1 ELSE NULL END) / COUNT(*) AS Success_Rate

, AVG(GAS_USED) AS AVG_Gas_Used

, SUM(COUNT(*)) OVER (ORDER BY Date) AS Total_TX_Number

, AVG(GAS_PRICE) AS GAS_PRICE

FROM

swell.core.fact_transactions

GROUP BY 1

ORDER BY 1 DESC