spacebarSquare Bulletin Board - 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
›
⌄
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('0x27DDf2B87beFee25a7724EE39D87A2Cc7C356100')
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 24 hours
QueryRunArchived: QueryRun has been archived