TOKEN_NAME | BONK_SOLD | USERS | TXS | SWAP_TO_MINT | |
---|---|---|---|---|---|
1 | USDC | 3967496.268634 | 695 | 3596 | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v |
2 | Tether | 1130720.010868 | 213 | 1059 | Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB |
3 | Wrapped Solana | 1033377.771406 | 1613 | 4055 | So11111111111111111111111111111111111111112 |
4 | Jupiter | 232852.933923 | 340 | 595 | JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN |
5 | BlazeStake Staked SOL | 98065.427563 | 38 | 43 | bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1 |
6 | dogwifhat | 61649.775638 | 35 | 59 | EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm |
7 | Wrapped BTC (Wormhole) | 47347.437145 | 21 | 120 | 3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh |
8 | Ethereum (Wormhole) | 34112.995895 | 21 | 83 | 7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs |
9 | Render | 28222.425667 | 23 | 83 | rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof |
10 | Jito | 26467.928728 | 29 | 59 | jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL |
11 | Popcat | 26384.123041 | 4 | 101 | 7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr |
12 | Nosana | 23421.396725 | 28 | 62 | nosXBVoaCTtYdLvKY6Csb4AC8JCdQKKAaWYtx2ZMoo7 |
13 | Whales Market | 22858.583575 | 42 | 77 | GTH3wG3NErjwcf7VGCoXEXkgXSHvYhx5gtATeeM5JAS1 |
14 | Dither | 19930.024531 | 26 | 169 | E1kvzJNxShvvWTrudokpzuc789vRiDXfXG3duCuY6ooE |
15 | Pyth Network | 19226.221787 | 85 | 117 | HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3 |
16 | Shadow Token | 17585.086097 | 25 | 44 | SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y |
17 | Wen | 16094.591054 | 73 | 140 | WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk |
18 | Bonk | 15909.390873 | 80 | 104 | DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263 |
19 | Marinade staked SOL | 7449.834935 | 16 | 24 | mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So |
20 | tBTC | 7157.305472 | 3 | 3 | 6DNSN2BJsaPFdFFc1zP37kkeNe4Usc1Sqkzr9C9vPWcU |
greyswanbonk selling flows
Updated 2024-02-20
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
›
⌄
with raw as (
select
swap_to_mint,
sum(swap_from_amount) as bonk_sold,
count(distinct swapper) as users,
count (tx_id) as txs
from
solana.defi.fact_swaps
where
swap_from_mint = '27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'
and BLOCK_TIMESTAMP >= current_date - 5
group by
swap_to_mint
order by
sum(swap_from_amount) desc
),
raw1 as (
select
token_name,
swap_to_mint,
bonk_sold,
users,
txs
from
raw
left join solana.core.dim_tokens on swap_to_mint = TOKEN_ADDRESS
)
select
token_name,
--bonk_sold / sum(bonk_sold) as share,
bonk_sold,
users,
txs,
swap_to_mint
from
raw1
Last run: 12 months ago
...
212
15KB
10s