FROM_RONIN_BRIDGE_TRANSACTIONS | FROM_RONIN_BRIDGERS | FROM_RONIN_AMOUNT_USD | FROM_RONIN_AVG_BRIDGE_USD | FROM_RONIN_LAST_24H_TRANSACTIONS | FROM_RONIN_LAST_24H_AMOUNT_USD | TO_RONIN_BRIDGE_TRANSACTIONS | TO_RONIN_BRIDGERS | TO_RONIN_AMOUNT_USD | TO_RONIN_AVG_BRIDGE_USD | TO_RONIN_LAST_24H_TRANSACTIONS | TO_RONIN_LAST_24H_AMOUNT_USD | TOTAL_BRIDGE_TRANSACTIONS | TOTAL_BRIDGERS | TOTAL_AMOUNT_USD | TOTAL_AVG_BRIDGE_USD | TOTAL_LAST_24H_TRANSACTIONS | TOTAL_LAST_24H_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 12308 | 6036 | 483094662.215489 | 39250.460043507 | 76 | 428931.718376238 | 9403 | 4704 | 166338920.762726 | 17689.98412876 | 47 | 152290.457993216 | 21711 | 9526 | 649433582.978215 | 29912.651788412 | 123 | 581222.176369455 |
datavortexFINAL
Updated 2025-03-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 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_from_ronin AS (
SELECT
t.tx_hash,
MAX(
CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_to, t.decoded_log:to)
END
) AS bridger,
MAX(
CASE
WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value)
END
) AS transfer_value_raw,
MAX(
CASE
WHEN t.event_name = 'Transfer' THEN t.contract_address
END
) AS contract_address,
MAX(t.block_timestamp) AS event_timestamp,
Last run: about 2 months ago
1
194B
63s