WEEKLY | FROM_RONIN_BRIDGE_TRANSACTIONS | FROM_RONIN_BRIDGERS | TO_RONIN_BRIDGE_TRANSACTIONS | TO_RONIN_BRIDGERS | TOTAL_BRIDGE_TRANSACTIONS | TOTAL_BRIDGERS | |
|---|---|---|---|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | 3 | 3 | 11 | 2 | 14 | 5 |
2 | 2025-03-10 00:00:00.000 | 33 | 13 | 36 | 7 | 69 | 18 |
3 | 2025-03-03 00:00:00.000 | 15 | 11 | 20 | 15 | 35 | 24 |
4 | 2025-02-24 00:00:00.000 | 28 | 12 | 23 | 4 | 51 | 15 |
5 | 2025-02-17 00:00:00.000 | 20 | 13 | 31 | 12 | 51 | 22 |
6 | 2025-02-10 00:00:00.000 | 13 | 7 | 11 | 4 | 24 | 10 |
7 | 2025-02-03 00:00:00.000 | 8 | 8 | 4 | 4 | 12 | 10 |
8 | 2025-01-27 00:00:00.000 | 11 | 6 | 5 | 5 | 16 | 11 |
9 | 2025-01-20 00:00:00.000 | 3 | 2 | 4 | 4 | 7 | 6 |
10 | 2025-01-13 00:00:00.000 | 13 | 9 | 2 | 2 | 15 | 11 |
11 | 2025-01-06 00:00:00.000 | 7 | 6 | 6 | 6 | 13 | 11 |
12 | 2024-12-30 00:00:00.000 | 5 | 5 | 10 | 8 | 15 | 12 |
13 | 2024-12-23 00:00:00.000 | 2 | 2 | 6 | 5 | 8 | 6 |
14 | 2024-12-16 00:00:00.000 | 6 | 6 | 5 | 4 | 11 | 9 |
15 | 2024-12-09 00:00:00.000 | 5 | 5 | 17 | 9 | 22 | 13 |
16 | 2024-12-02 00:00:00.000 | 6 | 5 | 8 | 6 | 14 | 10 |
17 | 2024-11-25 00:00:00.000 | 7 | 6 | 11 | 9 | 18 | 13 |
18 | 2024-11-18 00:00:00.000 | 7 | 6 | 14 | 10 | 21 | 16 |
19 | 2024-11-11 00:00:00.000 | 4 | 4 | 19 | 10 | 23 | 14 |
20 | 2024-11-04 00:00:00.000 | 6 | 5 | 24 | 7 | 30 | 11 |
datavortexWeekly bridges
Updated 2025-03-19
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 weekly_nft_transfers_from_ronin AS (
SELECT
DATE_TRUNC('week', t.block_timestamp) AS weekly,
t.tx_hash,
MAX(t.decoded_log:to) AS bridger,
MAX(t.contract_address) AS contract_address,
MAX(t.block_timestamp) AS event_timestamp
FROM
ronin.core.ez_decoded_event_logs t
WHERE
t.event_name = 'Transfer'
AND t.ORIGIN_FUNCTION_SIGNATURE = '0xb9afa177'
AND t.decoded_log:from = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df'
AND t.contract_address IN (
'0xf083289535052e8449d69e6dc41c0ae064d8e3f6',
'0x241a81fc0d6692707dad2b5025a3a7cf2cf25acf',
'0x1f7c16fce4fc894143afb5545bf04f676bf7dcf3'
)
GROUP BY
1, 2
),
weekly_nft_transfers_to_ronin AS (
SELECT
DATE_TRUNC('week', t.block_timestamp) AS weekly,
t.tx_hash,
MAX(t.decoded_log:from) AS bridger,
MAX(t.contract_address) AS contract_address,
MAX(t.block_timestamp) AS event_timestamp
FROM
ronin.core.ez_decoded_event_logs t
WHERE
t.event_name = 'Transfer'
AND t.ORIGIN_FUNCTION_SIGNATURE = '0x0b1ff17f'
AND t.decoded_log:to = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df'
AND t.contract_address IN (
'0xf083289535052e8449d69e6dc41c0ae064d8e3f6',
Last run: 3 months ago
25
1KB
2s