DATE | SOURCE_CHAIN | RECEIVERS | AMOUNT | AMOUNT_USD | |
|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | Linea | 35 | 5.862784397 | 12399.702802739 |
2 | 2025-02-01 00:00:00.000 | B2 Network | 137 | 0.03156345629 | 3050.058175745 |
3 | 2025-04-01 00:00:00.000 | Optimism | 3 | 0.0314 | 58.991873381 |
4 | 2025-01-01 00:00:00.000 | Optimism | 913 | 177.262122073 | 601024.620560048 |
5 | 2024-12-01 00:00:00.000 | Blast | 33 | 64.482906469 | 225104.202189202 |
6 | 2025-03-01 00:00:00.000 | Blast | 7 | 8.304000612 | 16552.022439905 |
7 | 2025-01-01 00:00:00.000 | Arbitrum | 389 | 85.149907705 | 293685.326871421 |
8 | 2025-01-01 00:00:00.000 | B2 Network | 497 | 50.210705121 | 4725576.82745372 |
9 | 2025-03-01 00:00:00.000 | BSC | 19 | 2.912511073 | 6017.84545242 |
10 | 2025-02-01 00:00:00.000 | Optimism | 58 | 33.807995735 | 104827.874203744 |
11 | 2025-04-01 00:00:00.000 | Mode | 4 | 0.6536724256 | 1281.742406135 |
12 | 2025-02-01 00:00:00.000 | Ethereum | 27 | 640.175029467 | 1921674.03150752 |
13 | 2025-01-01 00:00:00.000 | BSC | 60 | 7.018881728 | 24138.38358085 |
14 | 2025-01-01 00:00:00.000 | Sei | 70 | 21.396779584 | 72634.678929181 |
15 | 2025-02-01 00:00:00.000 | Linea | 36 | 7.736582958 | 21842.242584163 |
16 | 2025-02-01 00:00:00.000 | Blast | 12 | 46.806019192 | 132863.515092964 |
17 | 2024-12-01 00:00:00.000 | Optimism | 166 | 155.906546862 | 563667.624150667 |
18 | 2025-04-01 00:00:00.000 | B2 Network | 5 | 0.0005051116 | 41.694015312 |
19 | 2025-04-01 00:00:00.000 | Zircuit | 2 | 0.05421 | 116.938396787 |
20 | 2025-04-01 00:00:00.000 | BSC | 1 | 0.00001 | 0.0187665369 |
Sbhn_NPvisible-emerald
Updated 2025-04-09
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
›
⌄
with price as (
select hour::date as datee,
symbol,
avg(price) as usdprice
from crosschain.price.ez_prices_hourly
where symbol in ('UBTC','EZETH','PZETH')
group by 1,2
)
select date_trunc('month',block_timestamp) as date,
case when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '223' then 'B2 Network'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '1' then 'Ethereum'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '48900' then 'Zircuit'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '42161' then 'Arbitrum'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '34443' then 'Mode'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '59144' then 'Linea'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '10' then 'Optimism'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '8453' then 'Base'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '81457' then 'Blast'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '1329' then 'Sei'
when ethereum.public.udf_hex_to_int(substr(topic_1,3,len(topic_1))) = '56' then 'BSC'
else 'Other' end as source_chain,
count(distinct concat('0x', right(topic_2,40))) as receivers,
sum(ethereum.public.udf_hex_to_int(substr(data,3,len(data))) / pow(10,18)) as amount,
sum((ethereum.public.udf_hex_to_int(substr(data,3,len(data))) / pow(10,18))*usdprice) as amount_usd
from swell.core.fact_event_logs
join price on block_timestamp::date =datee and symbol=case when contract_address = '0xa166219df110bda97b91e65d4bb4aae4159978b9' then 'EZETH'
when contract_address = '0x982abbb04f91acc47ad0cb0a11f29d50c5007934' then 'PZETH'
when contract_address = '0xfa3198ecf05303a6d96e57a45e6c815055d255b1' then 'UBTC' end
where topic_0 = '0xba20947a325f450d232530e5f5fce293e7963499d5309a07cee84a269f2f15a6'
and contract_address in ('0xfa3198ecf05303a6d96e57a45e6c815055d255b1','0x982abbb04f91acc47ad0cb0a11f29d50c5007934','0xa166219df110bda97b91e65d4bb4aae4159978b9')
and origin_to_address = '0x3a464f746d23ab22155710f44db16dca53e0775e'
group by 1,2
Last run: 12 days ago
58
4KB
34s