WALLET_TYPE_1K | SWAP_CATEGORY_1K | WALLET_TYPE_5K | SWAP_CATEGORY_5K | WALLET_TYPE_50K | SWAP_CATEGORY_50K | WALLET_TYPE_100K | SWAP_CATEGORY_100K | WALLET_TYPE_150K | SWAP_CATEGORY_150K | WALLET_TYPE_200K | SWAP_CATEGORY_200K | WALLET_TYPE_250K | SWAP_CATEGORY_250K | WALLET_TYPE_OVER_250K | SWAP_CATEGORY_OVER_250K | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1) Guppy - <1k | 3477 | 1) Guppy - <1k | 0 | 1) Guppy - <1k | 0 | 1) Guppy - <1k | 0 | 1) Guppy - <1k | 0 | 1) Guppy - <1k | 0 | 1) Guppy - <1k | 0 | 1) Guppy - <1k | 0 |
2 | 2) Minnow - 1k to 10k | 95 | 2) Minnow - 1k to 10k | 102 | 2) Minnow - 1k to 10k | 16 | 2) Minnow - 1k to 10k | 0 | 2) Minnow - 1k to 10k | 0 | 2) Minnow - 1k to 10k | 0 | 2) Minnow - 1k to 10k | 0 | 2) Minnow - 1k to 10k | 0 |
3 | 3) Trout - 10k to 100k | 19 | 3) Trout - 10k to 100k | 18 | 3) Trout - 10k to 100k | 31 | 3) Trout - 10k to 100k | 5 | 3) Trout - 10k to 100k | 0 | 3) Trout - 10k to 100k | 0 | 3) Trout - 10k to 100k | 0 | 3) Trout - 10k to 100k | 0 |
4 | 4) Dolphin - 100k to 1m | 4 | 4) Dolphin - 100k to 1m | 6 | 4) Dolphin - 100k to 1m | 5 | 4) Dolphin - 100k to 1m | 3 | 4) Dolphin - 100k to 1m | 2 | 4) Dolphin - 100k to 1m | 0 | 4) Dolphin - 100k to 1m | 0 | 4) Dolphin - 100k to 1m | 1 |
5 | 5) Whale - >1m | 1 | 5) Whale - >1m | 1 | 5) Whale - >1m | 0 | 5) Whale - >1m | 0 | 5) Whale - >1m | 0 | 5) Whale - >1m | 0 | 5) Whale - >1m | 0 | 5) Whale - >1m | 1 |
RayyykBase Code - (Wallet Type by Swap Category) - Arbitrum, Optimism, Gnosis & Avalanche
Updated 7 days ago
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 table_1 as (select origin_from_address, tx_hash, decoded_log, block_timestamp, event_name, contract_address, 'Arbitrum' as chain
from arbitrum.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted', 'FeesCollected')
and block_timestamp >= '2023-10-01'
union ALL
select origin_from_address, tx_hash, decoded_log, block_timestamp, event_name, contract_address, 'Optimism' as chain
from optimism.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted', 'FeesCollected')
and block_timestamp >= '2023-06-29'
union ALL
select origin_from_address, tx_hash, decoded_log, block_timestamp, event_name, contract_address, 'Gnosis' as chain
from gnosis.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted', 'FeesCollected')
and block_timestamp >= '2023-07-15'
union ALL
select origin_from_address, tx_hash, decoded_log, block_timestamp, event_name, contract_address, 'Avalanche' as chain
from avalanche.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted', 'FeesCollected')
and block_timestamp >= '2023-06-29'),
prices as (select date_trunc('day', hour) as day,
avg(price) as price,
decimals,
symbol,
iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address,
'Arbitrum' as chain
from arbitrum.price.ez_prices_hourly
where hour >= '2023-10-01'
group by 1,3,4,5
union ALL
select date_trunc('day', hour) as day,
avg(price) as price,
decimals,
symbol,
iff(is_native,'0x0000000000000000000000000000000000000000', token_address),
'Optimism' as chain
Last run: 7 days ago
5
973B
191s