FT tx copy

Updated 2024-05-13

-- forked from FT tx @ https://flipsidecrypto.xyz/edit/queries/0bed858b-17a5-4832-b34c-a965c35e2c25

SELECT DATE_TRUNC('hour', BLOCK_TIMESTAMP) AS HOUR,

COUNT(*) AS Tx

FROM base.core.fact_transactions

WHERE TO_ADDRESS = lower('0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4')

GROUP BY 1

ORDER BY 1 ASC;

-- WITH TransactionCounts AS (

-- SELECT

-- STATUS,

-- COUNT(*) AS Tx

-- FROM

-- base.core.fact_transactions

-- WHERE

-- TO_ADDRESS = LOWER('0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4')

-- GROUP BY

-- STATUS

-- )

-- SELECT

-- STATUS,

-- Tx,

-- ROUND((Tx * 100.0) / SUM(Tx) OVER (), 2) AS PercentageOfTotal

-- FROM

-- TransactionCounts

-- ORDER BY

-- STATUS ASC;

QueryRunArchived: QueryRun has been archived