DAY | ODOS_SOURCE | VOLUME | AMOUNT | |
|---|---|---|---|---|
1 | 2025-01-28 00:00:00.000 | lfj_all_pools | 4369790 | 1634 |
2 | 2025-01-28 00:00:00.000 | others_all_pools | 13538665.81 | 4468 |
3 | 2025-01-28 00:00:00.000 | lfj_lfj_pools | 2070939.48 | 1144 |
4 | 2025-01-28 00:00:00.000 | others_lfj_pools | 4858922.17 | 2419 |
5 | 2025-01-27 00:00:00.000 | lfj_all_pools | 6422835.72 | 2878 |
6 | 2025-01-27 00:00:00.000 | lfj_lfj_pools | 2594703.83 | 2409 |
7 | 2025-01-27 00:00:00.000 | others_lfj_pools | 9676984.85 | 4325 |
8 | 2025-01-27 00:00:00.000 | others_all_pools | 21939441.16 | 7343 |
9 | 2025-01-26 00:00:00.000 | others_all_pools | 16088368.53 | 5875 |
10 | 2025-01-26 00:00:00.000 | lfj_lfj_pools | 3412126.66 | 2258 |
11 | 2025-01-26 00:00:00.000 | others_lfj_pools | 6859000.95 | 3934 |
12 | 2025-01-26 00:00:00.000 | lfj_all_pools | 5981430.73 | 2624 |
13 | 2025-01-25 00:00:00.000 | others_all_pools | 14679892.32 | 5424 |
14 | 2025-01-25 00:00:00.000 | lfj_all_pools | 5033997.75 | 2436 |
15 | 2025-01-25 00:00:00.000 | lfj_lfj_pools | 2389767.75 | 2159 |
16 | 2025-01-25 00:00:00.000 | others_lfj_pools | 6294864.28 | 3548 |
17 | 2025-01-24 00:00:00.000 | lfj_all_pools | 6204970.1 | 3273 |
18 | 2025-01-24 00:00:00.000 | others_all_pools | 14424413.62 | 5973 |
19 | 2025-01-24 00:00:00.000 | others_lfj_pools | 5640341.31 | 4120 |
20 | 2025-01-24 00:00:00.000 | lfj_lfj_pools | 2448907.7 | 2876 |
pecio222odos share
Updated 2025-01-28
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
›
⌄
⌄
/*select
DECODED_LOG ['referralCode'],
count(tx_hash) as amount
from
avalanche.core.ez_decoded_event_logs
where
contract_address = '0x88de50b233052e4fb783d4f6db78cc34fea3e9fc'
group by
1
*/
with lfj_frontend_odos as (
select
tx_hash
from
avalanche.core.ez_decoded_event_logs
where
contract_address = '0x88de50b233052e4fb783d4f6db78cc34fea3e9fc'
and DECODED_LOG ['referralCode'] = 1061215132
),
all_swaps as (
select
date_trunc('day', block_timestamp) as Day,
case
when tx_hash in (
select
tx_hash
from
lfj_frontend_odos
) then 'lfj_all_pools'
else 'others_all_pools'
end as odos_source,
sum(coalesce(amount_out_usd, amount_in_usd, 0)) as volume,
count(DISTINCT tx_hash) as amount
from
avalanche.defi.ez_dex_swaps
Last run: 3 months ago
76
5KB
10s