sakineh5021-nIQRzBThe Meme's game (volume)
Updated 2022-03-22
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 shib as ( SELECT cast(block_timestamp as date) as date_swap , sum(amount_usd) as shiba
from ethereum.dex_swaps
where token_address = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'
and platform LIKE '%sushiswap%'
group by 1
) ,
kish as ( SELECT cast(block_timestamp as date) as date_swap , sum(amount_usd) as kishu
from ethereum.dex_swaps
where token_address = '0xa2b4c0af19cc16a6cfacce81f192b024d625817d'
and platform LIKE '%sushiswap%'
group by 1
) ,
Elo as ( SELECT cast(block_timestamp as date) as date_swap , sum(amount_usd) as Elon
from ethereum.dex_swaps
where token_address = '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'
and platform LIKE '%sushiswap%'
group by 1
) ,
Hog as ( SELECT cast(block_timestamp as date) as date_swap , sum(amount_usd) as Hoge
from ethereum.dex_swaps
where token_address = '0xfad45e47083e4607302aa43c65fb3106f1cd7607'
and platform LIKE '%sushiswap%'
group by 1
) ,
woof as ( SELECT cast(block_timestamp as date) as date_swap , sum(amount_usd) as Woofy
from ethereum.dex_swaps
where token_address = '0xd0660cd418a64a1d44e9214ad8e459324d8157f1'
and platform LIKE '%sushiswap%'
group by 1
)
SELECT S.date_swap as swap_date , Shiba ,Woofy, Hoge , Elon , kishu
Run a query to Download Data