Total Bridge Actions | Unique Users | Bridge Volume | Inflow Actions | Outflow Actions | Inflow Volume | Outflow Volume | Net Flow | Inflow Users | Outflow Users | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 1366794 | 495511 | 611907231.793557 | 1076304 | 290490 | 395493388.154463 | 216413843.639094 | 179079544.515369 | 491090 | 120807 |
hbd199401 - Overview
Updated 2025-02-27
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 last_table as (
----------------------------------------------------- Adding Tokens and Symbols -----------------------------------------------------
with tokens as (
select *
from (values
('So11111111111111111111111111111111111111112', 'ETH'),('GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn', 'tETH') t(TOKEN, symbol))),
----------------------------------------------------- Pool Creations -----------------------------------------------------
pools as (
select
BLOCK_TIMESTAMP as creation_date,
INSTRUCTION:accounts[1] as tokenMintA,
b.symbol as tokenMintA_symbol,
INSTRUCTION:accounts[2] as tokenMintB,
c.symbol as tokenMintB_symbol,
tokenMintB_symbol || ' - ' || tokenMintA_symbol as pool_name,
INSTRUCTION:accounts[6] as pool_address
from eclipse.core.fact_events a
left join tokens b on b.TOKEN = a.INSTRUCTION:accounts[1]
left join tokens c on c.TOKEN = a.INSTRUCTION:accounts[2]
where substr(replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data),3,1000), ''),0,16) = 'cf2d57f21b3fcc43'
order by 1, INDEX),
----------------------------------------------------- Token Prices by CEX Price Tables -----------------------------------------------------
price as (
select
HOUR,
TOKEN_ADDRESS,
case when SYMBOL = 'STTIA' then 'stTIA' else symbol end as symbol,
PRICE
from crosschain.price.ez_prices_hourly
where TOKEN_ADDRESS in (
'7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs', -- ETH
Last run: about 1 month ago
1
115B
512s