DIRECTION | TXS | RECEIVERS | SENDERS | AMOUNT_USD | |
|---|---|---|---|---|---|
1 | inbound | 821229 | 436633 | 16 | 1633908566 |
2 | outbound | 705744 | 331738 | 333946 | 1508208735 |
mamad-5XN3k3Aptos L0 3
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
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'
group by 1
order by 1 asc
Last run: about 2 months ago
2
86B
12s