DATE | EVM_TRANSACTIONS | NON_EVM_TRANSACTIONS | EVM_SUCCESSFUL_TRANSACTIONS | NON_EVM_SUCCESSFUL_TRANSACTIONS | EVM_SUCCESS_RATE | NON_EVM_SUCCESS_RATE | EVM_TOTAL_FEES | NON_EVM_TOTAL_FEES | EVM_AVG_TX_FEE | NON_EVM_AVG_TX_FEE | EVM_UNIQUE_USERS | NON_EVM_UNIQUE_USERS | EVM_LATENCY | NON_EVM_LATENCY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-30 00:00:00.000 | 42736 | 42424 | 0.992699 | 0.898669365 | 0.00002102839211 | 522 | -56.154437 | |||||||
2 | 2025-03-29 00:00:00.000 | 100739 | 100124 | 0.993895 | 1.981390454 | 0.00001966855393 | 4047 | -55.553996 | |||||||
3 | 2025-03-28 00:00:00.000 | 99737 | 119067 | 99205 | 86611 | 0.994666 | 0.727414 | 2.653280528 | 3.36346341 | 0.00002660277057 | 0.00002824849379 | 3496 | 364 | -55.592067 | -52.03886 |
4 | 2025-03-27 00:00:00.000 | 92602 | 305805 | 92176 | 219851 | 0.9954 | 0.718925 | 1.536317117 | 8.32265695 | 0.00001659053927 | 0.00002721556858 | 2811 | 801 | -55.204736 | -386.673707 |
5 | 2025-03-26 00:00:00.000 | 94076 | 240172 | 93744 | 178845 | 0.996471 | 0.744654 | 1.602518048 | 7.09945307 | 0.00001703429194 | 0.00002955986988 | 2428 | 368 | -55.236128 | -1137.481459 |
6 | 2025-03-25 00:00:00.000 | 91459 | 345579 | 91342 | 260356 | 0.998721 | 0.753391 | 1.13101452 | 9.45397721 | 0.00001236635564 | 0.00002735692044 | 3308 | 275 | -55.257908 | -43.135807 |
7 | 2025-03-24 00:00:00.000 | 89375 | 295225 | 89229 | 216509 | 0.998366 | 0.733369 | 1.123067396 | 7.84568783 | 0.00001256578904 | 0.00002657528268 | 2075 | 286 | -55.103038 | -44.290687 |
8 | 2025-03-23 00:00:00.000 | 75373 | 306946 | 75275 | 218809 | 0.9987 | 0.712858 | 1.271529388 | 7.65803143 | 0.0000168698259 | 0.00002494911623 | 1230 | 221 | -55.982872 | -42.537528 |
9 | 2025-03-22 00:00:00.000 | 81518 | 297330 | 81212 | 209918 | 0.996246 | 0.70601 | 2.207135994 | 8.03652634 | 0.00002707544339 | 0.00002702897905 | 1153 | 256 | -54.198214 | -46.090233 |
10 | 2025-03-21 00:00:00.000 | 84643 | 304715 | 83808 | 222526 | 0.990135 | 0.730276 | 2.042296233 | 9.2379682 | 0.00002412835359 | 0.00003031674909 | 1892 | 288 | -56.523989 | -46.150777 |
11 | 2025-03-20 00:00:00.000 | 47103 | 245604 | 46558 | 203487 | 0.98843 | 0.828517 | 0.994696751 | 7.41257759 | 0.00002111748192 | 0.0000301810133 | 1195 | 320 | -54.693756 | -46.965029 |
12 | 2025-03-19 00:00:00.000 | 54656 | 257727 | 54399 | 235059 | 0.995298 | 0.912046 | 0.8994817059 | 8.23068532 | 0.0000164571448 | 0.00003193567348 | 1044 | 857 | -54.664886 | -48.165093 |
13 | 2025-03-18 00:00:00.000 | 30852 | 218404 | 30620 | 182410 | 0.99248 | 0.835195 | 0.8968564732 | 8.11710497 | 0.00002906963805 | 0.00003716555086 | 541 | 364 | -56.557695 | -47.885515 |
14 | 2025-03-17 00:00:00.000 | 20530 | 181997 | 20463 | 141392 | 0.996736 | 0.776892 | 0.4329370683 | 4.11547584 | 0.00002108802086 | 0.00002261287736 | 260 | 272 | -56.245202 | -43.17914 |
15 | 2025-03-16 00:00:00.000 | 19333 | 196673 | 19288 | 145467 | 0.997672 | 0.739639 | 0.4420589509 | 3.90881116 | 0.00002286551238 | 0.00001987467095 | 271 | 387 | -57.148451 | -42.080769 |
16 | 2025-03-15 00:00:00.000 | 18381 | 472960 | 18333 | 440986 | 0.997389 | 0.932396 | 0.5364154155 | 6.08476446 | 0.00002918314648 | 0.00001286528345 | 220 | 68950 | -54.896796 | -43.515805 |
17 | 2025-03-14 00:00:00.000 | 25580 | 478838 | 25421 | 441803 | 0.993784 | 0.922657 | 1.605760537 | 6.6744303 | 0.00006277406323 | 0.00001393880665 | 305 | 66730 | -54.628499 | -43.646603 |
18 | 2025-03-13 00:00:00.000 | 28661 | 489956 | 28418 | 440022 | 0.991522 | 0.898085 | 2.19349184 | 7.15327181 | 0.00007653228568 | 0.0000145998249 | 193 | 66632 | -55.25055 | -45.70441 |
19 | 2025-03-12 00:00:00.000 | 34204 | 516984 | 33989 | 461393 | 0.993714 | 0.892471 | 1.665311604 | 8.22191452 | 0.00004868762729 | 0.00001590361504 | 177 | 67439 | -53.496813 | -46.743292 |
20 | 2025-03-11 00:00:00.000 | 38925 | 515960 | 38164 | 476636 | 0.98045 | 0.923785 | 1.907891578 | 8.09414336 | 0.00004901455562 | 0.00001568754043 | 199 | 67168 | -59.641207 | -47.767075 |
adriaparcerisasflow evm vs non-evm activity
Updated 5 days ago
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 evm_data AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(TX_HASH) AS total_transactions,
SUM(CASE WHEN TX_SUCCEEDED = 'TRUE' THEN 1 ELSE 0 END) AS successful_transactions,
successful_transactions/total_transactions as success_rate,
SUM(tx_fee) AS fees,
AVG(tx_fee) AS avg_tx_fee,
COUNT(DISTINCT FROM_ADDRESS) AS unique_users,
avg(DATEDIFF(MINUTE, INSERTED_TIMESTAMP, BLOCK_TIMESTAMP)) AS latency_MINUTEs
FROM
flow.core_evm.fact_transactions
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE) and block_timestamp<current_date
GROUP BY
1
),
non_evm_data AS (
SELECT
DATE_TRUNC('day', x.BLOCK_TIMESTAMP) AS date,
COUNT(distinct x.TX_ID) AS total_transactions,
SUM(CASE WHEN x.TX_SUCCEEDED = 'TRUE' THEN 1 ELSE 0 END) AS successful_transactions,
successful_transactions/total_transactions as success_rate,
SUM(y.event_data:amount) AS fees,
AVG(y.event_data:amount) AS avg_tx_fee,
COUNT(DISTINCT x.PAYER) AS unique_users,
avg(DATEDIFF(MINUTE, x.INSERTED_TIMESTAMP, x.BLOCK_TIMESTAMP)) AS latency_MINUTEs
FROM
flow.core.fact_transactions x
join flow.core.fact_events y on x.tx_id=y.tx_id
WHERE
x.BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE) and event_contract='A.f919ee77447b7497.FlowFees'
and event_Type='FeesDeducted' and x.block_timestamp<current_date
GROUP BY
1
)
Last run: 5 days ago
30
5KB
107s