cybergenlab$ Volume trading Lockin reformatted
Updated 2024-10-20
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
›
⌄
⌄
-- forked from $ Volume trading Lockin @ https://flipsidecrypto.xyz/studio/queries/7f41c8cc-46c4-4650-b7ae-abd97fdb5ef6
/* Memecoin trading Volume Scripts
Goal: Extract memecoins trading volume
Short listed memecoin addresses:
--------------------------------
Lockin: 8Ki8DpuWNxu9VsS3kQbarsCWMcFGWkzzA8pUPto9zBd5
Michi: 5mbK36SZ7J19An8jFochhQS4of8g6BwUjbeCSxBSoWdp
Samo: 7xKXtg2CW87d97TXJSDpbD5jBkheTqA83TZRuJosgAsU
Slerf: 7BgBvyjrZX1YKz4oh9mjb8ZScatkkwb8DzFx7LoiVkM3
Final Table schema:
-------------------
- Day
- Buyer Type
- Total_buy_usd_vol: Total $ Volume bought per day
- Seller Type
- Total_sell_usd_vol: Total $ volume sold per day
*/
with
--Determine first memecoin trading day for each trader
first_trade as (
select
swapper,
min(date(block_timestamp)) as first_trade_day
from solana.defi.ez_dex_swaps
where swap_to_mint in ('8Ki8DpuWNxu9VsS3kQbarsCWMcFGWkzzA8pUPto9zBd5') --lockin
group by 1
order by 2
)
--Formatting table compiling all $ swaps volume (buy side)
QueryRunArchived: QueryRun has been archived