Date | Bridge Actions | Unique Users | Bridge Volume | Inflow Actions | Outflow Actions | Inflow Volume | Outflow Volume | Net Flow | Inflow Users | Outflow Users | Cumulative Bridge Volume | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-08-25 00:00:00.000 | 66 | 66 | 1072.658141952 | 66 | 0 | 1072.658141952 | 0 | 1072.658141952 | 66 | 0 | 1072.658141952 |
2 | 2024-08-26 00:00:00.000 | 70 | 69 | 722.767643646 | 70 | 0 | 722.767643646 | 0 | 722.767643646 | 69 | 0 | 1795.425785599 |
3 | 2024-08-27 00:00:00.000 | 116 | 108 | 3014.022677128 | 116 | 0 | 3014.022677128 | 0 | 3014.022677128 | 108 | 0 | 4809.448462727 |
4 | 2024-08-28 00:00:00.000 | 127 | 127 | 947.800292787 | 127 | 0 | 947.800292787 | 0 | 947.800292787 | 127 | 0 | 5757.248755514 |
5 | 2024-08-29 00:00:00.000 | 79 | 78 | 1636.016974874 | 79 | 0 | 1636.016974874 | 0 | 1636.016974874 | 78 | 0 | 7393.265730389 |
6 | 2024-08-30 00:00:00.000 | 61 | 61 | 2253.790024419 | 61 | 0 | 2253.790024419 | 0 | 2253.790024419 | 61 | 0 | 9647.055754808 |
7 | 2024-08-31 00:00:00.000 | 107 | 105 | 2015.33750809 | 107 | 0 | 2015.33750809 | 0 | 2015.33750809 | 105 | 0 | 11662.393262898 |
8 | 2024-09-01 00:00:00.000 | 108 | 107 | 1659.463573937 | 108 | 0 | 1659.463573937 | 0 | 1659.463573937 | 107 | 0 | 13321.856836834 |
9 | 2024-09-02 00:00:00.000 | 48 | 46 | 4561.35045628 | 48 | 0 | 4561.35045628 | 0 | 4561.35045628 | 46 | 0 | 17883.207293114 |
10 | 2024-09-03 00:00:00.000 | 139 | 138 | 4149.860205087 | 139 | 0 | 4149.860205087 | 0 | 4149.860205087 | 138 | 0 | 22033.067498201 |
11 | 2024-09-04 00:00:00.000 | 53 | 53 | 1103.480454967 | 53 | 0 | 1103.480454967 | 0 | 1103.480454967 | 53 | 0 | 23136.547953168 |
12 | 2024-09-05 00:00:00.000 | 44 | 43 | 1308.348124211 | 44 | 0 | 1308.348124211 | 0 | 1308.348124211 | 43 | 0 | 24444.896077379 |
13 | 2024-09-06 00:00:00.000 | 53 | 52 | 859.867697447 | 53 | 0 | 859.867697447 | 0 | 859.867697447 | 52 | 0 | 25304.763774826 |
14 | 2024-09-07 00:00:00.000 | 33 | 32 | 470.284388976 | 33 | 0 | 470.284388976 | 0 | 470.284388976 | 32 | 0 | 25775.048163802 |
15 | 2024-09-08 00:00:00.000 | 64 | 62 | 645.769274705 | 64 | 0 | 645.769274705 | 0 | 645.769274705 | 62 | 0 | 26420.817438507 |
16 | 2024-09-09 00:00:00.000 | 57 | 45 | 672.356559141 | 57 | 0 | 672.356559141 | 0 | 672.356559141 | 45 | 0 | 27093.173997648 |
17 | 2024-09-10 00:00:00.000 | 116 | 104 | 17746.802787057 | 116 | 0 | 17746.802787057 | 0 | 17746.802787057 | 104 | 0 | 44839.976784705 |
18 | 2024-09-11 00:00:00.000 | 108 | 105 | 2519.6580536 | 108 | 0 | 2519.6580536 | 0 | 2519.6580536 | 105 | 0 | 47359.634838305 |
19 | 2024-09-12 00:00:00.000 | 81 | 72 | 5113.713521025 | 81 | 0 | 5113.713521025 | 0 | 5113.713521025 | 72 | 0 | 52473.34835933 |
20 | 2024-09-13 00:00:00.000 | 72 | 70 | 1490.31625997 | 72 | 0 | 1490.31625997 | 0 | 1490.31625997 | 70 | 0 | 53963.6646193 |
hbd199405 - Daily Overview
Updated 2025-01-25
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: 2 months ago
...
158
21KB
417s