DATE | DAILY_TRANSACTIONS | |
|---|---|---|
1 | 2025-02-19 00:00:00.000 | 488928 |
2 | 2025-02-18 00:00:00.000 | 1009412 |
3 | 2025-02-17 00:00:00.000 | 992310 |
4 | 2025-02-16 00:00:00.000 | 1003579 |
5 | 2025-02-15 00:00:00.000 | 971220 |
6 | 2025-02-14 00:00:00.000 | 960516 |
7 | 2025-02-13 00:00:00.000 | 928099 |
8 | 2025-02-12 00:00:00.000 | 1005890 |
9 | 2025-02-11 00:00:00.000 | 1015445 |
10 | 2025-02-10 00:00:00.000 | 998869 |
11 | 2025-02-09 00:00:00.000 | 1047250 |
12 | 2025-02-08 00:00:00.000 | 1077157 |
13 | 2025-02-07 00:00:00.000 | 1328750 |
14 | 2025-02-06 00:00:00.000 | 1162074 |
15 | 2025-02-05 00:00:00.000 | 1239639 |
16 | 2025-02-04 00:00:00.000 | 1201012 |
17 | 2025-02-03 00:00:00.000 | 1145365 |
18 | 2025-02-02 00:00:00.000 | 1112066 |
19 | 2025-02-01 00:00:00.000 | 1124291 |
20 | 2025-01-31 00:00:00.000 | 1128042 |
yasmineach chain
Updated 2025-02-19
999
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 all_tx AS (
-- SELECT
-- 'base' AS blockchain,
-- block_timestamp::date AS date,
-- tx_hash AS tx,
-- from_address AS user
-- FROM base.core.fact_transactions
-- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- AND TX_SUCCEEDED = 'TRUE'
-- -- UNION ALL
-- -- SELECT
-- -- 'Polygon' AS blockchain,
-- -- block_timestamp::date AS date,
-- -- tx_hash AS tx,
-- -- from_address AS user
-- -- FROM polygon.core.fact_transactions
-- -- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- -- AND status = 'SUCCESS'
-- -- UNION ALL
-- -- SELECT
-- -- 'Solana' AS blockchain,
-- -- block_timestamp::date AS date,
-- -- tx_id AS tx,
-- -- signers[0] AS user
-- -- FROM solana.core.fact_transactions
-- -- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- -- AND succeeded = true
-- UNION ALL
-- SELECT
-- 'ronin' AS blockchain,
-- block_timestamp::date AS date,
-- TX_HASH AS tx,
-- FROM_ADDRESS AS user
-- FROM ronin.core.fact_transactions
-- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- AND TX_SUCCEEDED = true
Last run: 26 days ago
...
205
7KB
3s