spacebarStar Sweeper - total tx
Updated 2024-12-04
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
›
⌄
WITH getTransactions AS (
SELECT
date_trunc('day', block_timestamp) AS date,
COUNT(*) AS total_transactions
FROM
blast.core.fact_event_logs
WHERE
LOWER(contract_address) = LOWER('0x8bD974b03f3F1b6cd0d0F3e09f93653c462fed37')
AND topics[0] = LOWER('0xbaae4dcb1deae23b0ac7b4d0ff7004c107413a4c0ca0c74fc9476dbf68e78005')
AND utils.udf_hex_to_int (topics[3]) = 11
GROUP BY
date_trunc('day', block_timestamp)
)
SELECT
DATE(date) AS "Date",
total_transactions AS "Total Transactions",
SUM(total_transactions) OVER (
ORDER BY
date ASC ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW
) AS "Accumulated Transactions"
FROM
getTransactions
WHERE
"Date" IS NOT NULL
ORDER BY
1 DESC;
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived