TOTAL_TRANSACTIONS | |
|---|---|
1 | 1785986 |
Flow AmbassadorsTransactions (EVM) - Number - Last 24 Hours
Updated 2025-03-25
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
›
⌄
WITH time_periods AS (
SELECT
CASE '{{Period}}'
WHEN 'all_time' THEN '2020-01-01'::DATE
WHEN 'last_year' THEN CURRENT_DATE - INTERVAL '1 YEAR'
WHEN 'last_3_months' THEN CURRENT_DATE - INTERVAL '3 MONTHS'
WHEN 'last_month' THEN CURRENT_DATE - INTERVAL '1 MONTH'
WHEN 'last_week' THEN CURRENT_DATE - INTERVAL '1 WEEK'
ELSE CURRENT_DATE - INTERVAL '1 DAY'
END AS start_date
),
transactions AS (
SELECT
count(distinct tx_hash) as total_transactions
FROM
flow.core_evm.fact_transactions t,
time_periods tp
WHERE
block_timestamp >= tp.start_date
)
SELECT
total_transactions
FROM
transactions
Last run: 14 days ago
1
11B
1s