tx | USER | Avg TPM | total tx fee FLOW$ | total tx fee usd | avg tx fee FLOW$ | avg tx fee usd | block count | avg tx per user | success rate | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1197359 | 4270 | 5.734477972414 | 79.007936982 | 448.784095868 | 0.00006598516985 | 0.0003748116445 | 15453735 | 280.411943794 | 99.31992 |
Updated 2025-01-26
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
30
31
32
33
34
35
36
›
⌄
WITH price_data AS (
SELECT
AVG(PRICE) AS avg_price
FROM
flow.price.ez_prices_hourly
WHERE
SYMBOL = 'FLOW'
),
transaction_data AS (
SELECT
BLOCK_NUMBER,
BLOCK_TIMESTAMP,
BLOCK_HASH,
TX_HASH,
NONCE,
POSITION,
ORIGIN_FUNCTION_SIGNATURE,
FROM_ADDRESS,
TO_ADDRESS,
VALUE,
VALUE_PRECISE_RAW,
VALUE_PRECISE,
TX_FEE,
TX_FEE_PRECISE,
STATUS
FROM
flow.core_evm.fact_transactions
),
daily_tpm AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,
COUNT(DISTINCT TX_HASH) / 1440 AS tpm
FROM
transaction_data
GROUP BY 1
),
Last run: 20 days ago
1
123B
3s