SOURCE | DESTINATION | TXS | RECEIVERS | SENDERS | AMOUNT_USD | |
|---|---|---|---|---|---|---|
1 | Arbitrum | Aptos | 225783 | 140318 | 2 | 247258821 |
2 | Avalanche | Aptos | 109571 | 71750 | 1 | 217028570 |
3 | BSC | Aptos | 176250 | 113380 | 2 | 524673967 |
4 | Base | Aptos | 175 | 135 | 1 | 79483 |
5 | Ethereum | Aptos | 11162 | 8153 | 7 | 366193619 |
6 | Optimism | Aptos | 144901 | 110343 | 1 | 152792085 |
7 | Polygon | Aptos | 153364 | 98414 | 1 | 125876270 |
8 | Polygon zkEVM | Aptos | 23 | 22 | 1 | 5751 |
mamad-5XN3k3Aptos L0 inbound
Updated 2025-01-14
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
›
⌄
-- forked from 0xham-d / in total @ https://flipsidecrypto.xyz/0xham-d/q/ugfze9yitufw/in-total
with pricet as (
select
hour::date as p_date,
symbol,
avg(price) as usd_price
from crosschain.price.ez_prices_hourly
where blockchain = 'ethereum'
group by 1 ,2
)
select
--date_trunc('day',block_timestamp) as date,
--distinct direction, --inbound/outbound
distinct source_chain_name as source,
destination_chain_name as destination,
count(distinct tx_hash) as txs,
count(distinct receiver) as receivers,
count(distinct sender) as senders,
--count(distinct source_chain_name) as sources,
--count(distinct destination_chain_name) as destinations,
--token_address,
--count(distinct b.symbol) as tokens
--(amount_unadj/pow(10, decimals)) as amount
round(sum((amount_unadj/pow(10, decimals))*usd_price),0) as amount_usd
from aptos.defi.fact_bridge_activity a
join aptos.core.dim_tokens b using(token_address)
join pricet c on block_timestamp::date = p_date::date and lower(b.symbol) = lower(c.symbol)
where platform = 'layerzero'
and block_timestamp::date >= '2024-01-01'
and direction = 'inbound'
group by 1,2
order by 1 asc
Last run: about 2 months ago
8
345B
49s