spacebarBebob Challenge - 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('0xE7188280f92627c5b39E05D9D1e3315c966701D9')
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