DIRECTION | TOTAL_BRIDGE_TRANSACTIONS | TOTAL_BRIDGERS | TOTAL_AMOUNT_USD | |
|---|---|---|---|---|
1 | To Ronin | 9263 | 4664 | 166097211.880538 |
2 | From Ronin | 0 | 0 | |
3 | Overall | 9263 | 4664 | 166097211.880538 |
datavortexcheck bridge type
Updated 2025-03-18
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 daily_prices AS (
SELECT
TOKEN_ADDRESS,
DATE_TRUNC('day', hour) AS price_date,
SYMBOL,
NAME,
DECIMALS,
AVG(PRICE) AS avg_daily_price
FROM ronin.price.ez_prices_hourly
GROUP BY
TOKEN_ADDRESS,
DATE_TRUNC('day', hour),
SYMBOL,
NAME,
DECIMALS
),
transfer_data AS (
SELECT
t.tx_hash,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_from, t.decoded_log:from)
ELSE NULL
END) AS bridger,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_to, t.decoded_log:to)
ELSE NULL
END) AS bridge,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value)
ELSE NULL
END) AS transfer_value_raw,
MAX(CASE
WHEN t.event_name = 'Transfer' THEN t.contract_address
ELSE NULL
END) AS contract_address,
Last run: about 2 months ago
3
104B
10s