Abbas_ra21meme trading Total
Updated 2023-05-15
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
›
⌄
select
case
when TOKEN_IN in (
'0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce',
'0x6982508145454ce325ddbe47a25d4ec3d2311933',
'0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3',
'0x12970e6868f88f6557b76120662c1b3e50a646bf',
'0xa35923162c49cf95e6bf26623385eb431ad920d3',
'0x5026f006b85729a8b14553fae6af249ad16c9aab',
'0x7d8146cf21e8d7cbe46054e01588207b51198729',
'0x6b89b97169a797d94f057f4a0b01e2ca303155e4'
) then SYMBOL_IN
else SYMBOL_OUT
end AS Symbol,
sum(
case
when TOKEN_IN in (
'0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce',
'0x6982508145454ce325ddbe47a25d4ec3d2311933',
'0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3',
'0x12970e6868f88f6557b76120662c1b3e50a646bf',
'0xa35923162c49cf95e6bf26623385eb431ad920d3',
'0x5026f006b85729a8b14553fae6af249ad16c9aab',
'0x7d8146cf21e8d7cbe46054e01588207b51198729',
'0x6b89b97169a797d94f057f4a0b01e2ca303155e4'
) then AMOUNT_IN_USD
else AMOUNT_OUT_USD
end
) AS Volume,
count(DISTINCT ORIGIN_FROM_ADDRESS) AS "Traders Number",
avg(
case
when TOKEN_IN in (
'0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce',
'0x6982508145454ce325ddbe47a25d4ec3d2311933',
'0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3',
Run a query to Download Data