DAY | Daily Transactions | |
|---|---|---|
1 | 2024-02-28 00:00:00.000 | 1 |
2 | 2024-02-29 00:00:00.000 | 9608 |
3 | 2024-03-01 00:00:00.000 | 90395 |
4 | 2024-03-02 00:00:00.000 | 79659 |
5 | 2024-03-03 00:00:00.000 | 72000 |
6 | 2024-03-04 00:00:00.000 | 67750 |
7 | 2024-03-05 00:00:00.000 | 69953 |
8 | 2024-03-06 00:00:00.000 | 51686 |
9 | 2024-03-07 00:00:00.000 | 48765 |
10 | 2024-03-08 00:00:00.000 | 44519 |
11 | 2024-03-09 00:00:00.000 | 30853 |
12 | 2024-03-10 00:00:00.000 | 30232 |
13 | 2024-03-11 00:00:00.000 | 30473 |
14 | 2024-03-12 00:00:00.000 | 31423 |
15 | 2024-03-13 00:00:00.000 | 22545 |
16 | 2024-03-14 00:00:00.000 | 29068 |
17 | 2024-03-15 00:00:00.000 | 35214 |
18 | 2024-03-16 00:00:00.000 | 24316 |
19 | 2024-03-17 00:00:00.000 | 25740 |
20 | 2024-03-18 00:00:00.000 | 27841 |
yolo_gamesYOLOGames Daily Transactions
Updated 2025-02-17
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
›
⌄
SELECT day, COUNT(DISTINCT TX_HASH) as "Daily Transactions" FROM (
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE a.contract_address = LOWER('0x0000000000E14E87e5c80A8A90817308fFF715d3') -- yolo
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0xdCCD7560C173eC7043Ac15E52608e818746e4992') -- yoloplay
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0x00000000007FE8d7666BB0da2A5D13f72b8dABaB') -- transfermanager
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0x693B37a9859Ce9465Fb2aAdeB03811a26A0c37C0') -- eth mod
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0xA56A95F41e64Bc76CDE7423aB2A2ee1763bD8Bcc') -- btc mod
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0x63D758C3AD4c1BDF3279A3f8fEA04471462952E1') -- boost
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0x0000000000acc01064aa5280da3f1c41a35827bc') -- ptb
UNION ALL
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE a.contract_address = LOWER('0x28EF3eaE1AbB6D6e22e9bFc7a0944f707E4726b3') -- yololimited
)
GROUP BY 1
ORDER BY 1 ASC
Last run: 2 months ago
...
356
12KB
63s