NUM_BRIDGES | NUM_BRIDGERS | BRIDGED_TO_APOTOS_VOLUME | BRIDGED_FROM_APOTOS_VOLUME | NET_BRIDGED_VOLUME | AVG_BRIDGED_VOLUME | |
|---|---|---|---|---|---|---|
1 | 2548568 | 340410 | 2332615008.90008 | 2242880906.05295 | 89734102.8471375 | 1795.42176457 |
saeedmznAPTOS bridge activity via Layerzero Total
Updated 2025-02-04
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 bridge_txns as (
select BLOCK_TIMESTAMP::date date ,
TX_HASH,
SENDER,
RECEIVER,
SOURCE_CHAIN_NAME,
DESTINATION_CHAIN_NAME,
TOKEN_ADDRESS,
AMOUNT_UNADJ,
direction,
from aptos.defi.fact_bridge_activity
where platform ='layerzero'
and BLOCK_TIMESTAMP ::date >= '2024-01-01'
),
prices as (
select date_trunc(day,HOUR)::date date ,
TOKEN_ADDRESS,
SYMBOL,
DECIMALS,
median (PRICE) price
from aptos.price.ez_prices_hourly
where DECIMALS is not NULL
and date_trunc(day,HOUR)::date >= '2024-01-01'
group by 1 ,2,3,4
union all
select
date_trunc(day,HOUR)::date date ,
'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDD' TOKEN_ADDRESS,
'USDC' symbol ,
DECIMALS,
median (PRICE) price
from aptos.price.ez_prices_hourly
where symbol='USDC'
and DECIMALS is not NULL
and date_trunc(day,HOUR)::date >= '2024-01-01'
group by 1 ,2,3,4
Last run: 3 months ago
1
83B
4s