banterlyticsFT tx
Updated 2023-10-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
SELECT DATE_TRUNC('day',BLOCK_TIMESTAMP) AS DATE, STATUS
, Count(*) as Tx , SUM(Count(*)) OVER (ORDER BY DATE_TRUNC('day',BLOCK_TIMESTAMP)) AS Cumulative_Tx
from base.core.fact_transactions
where TO_ADDRESS = lower('0xCF205808Ed36593aa40a44F10c7f7C2F67d4A4d4')
GROUP BY 1,2
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;
Run a query to Download Data