TOKEN | volume (USD) | swaps | |
|---|---|---|---|
1 | SOL | 43369.528626863 | 1233 |
2 | tETH | 34156.256449407 | 1205 |
3 | ETH | 2420493.11880299 | 38786 |
4 | USDC | 84660.261008558 | 3853 |
Hessishlka - buy swap
Updated 2025-01-31
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
prices_major as
(SELECT date_trunc('day',hour) as day, avg(close) as pr, case
when ASSET_ID = 'ethereum' then 'ETH'
when ASSET_ID = 'usd-coin' then 'USDC'
when ASSET_ID = 'solana' then 'SOL'
end as Eclipse_cr
from crosschain.price.fact_prices_ohlc_hourly
where hour::date >= '2024-10-01' and
ASSET_ID in ('ethereum', 'solana', 'usd-coin')
and PROVIDER = 'coingecko'
GROUP by all),
teth_side_sell as
(select case
when mint = 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'
when mint = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'
when mint = 'Eth1111111111111111111111111111111111111111' then 'ETH'
when mint = 'So11111111111111111111111111111111111111112' then 'ETH'
else mint
end as token_sell,
AMOUNT/pow(10,decimal) as volume_sell,
a.TX_ID as hash,
SIGNERS[0] as trader,
a.BLOCK_TIMESTAMP as time
from eclipse.core.fact_transfers a
join eclipse.core.fact_transactions b
on SIGNERS[0]= TX_FROM and a.TX_ID = b.TX_ID
where MINT = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'
),
teth_side_buy as (select
'tETH' as token_buy,
AMOUNT/pow(10,decimal) as volume_buy,
a.TX_ID as hash_buy
from eclipse.core.fact_transfers a
Last run: 3 months ago
4
121B
473s