SectorFull List w/ Metrics v1.1
Updated 2023-04-04
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
›
⌄
--v1.1
--Notes
-- Look into labels table and make sure we're not removing users with labels.
-- Look into sportsbet.io #2 wallet to ensure it's a standard funnel wallet
--List of main wallets
with main_wallets as (
select * from (
values
(lower('0x094b4cf43908F0AdB3dBDb5025F52470AAc3B160')), -- Sportsbet.io #1
(lower('0xC94eBB328aC25b95DB0E0AA968371885Fa516215')), -- Roobet
(lower('0xCBD6832Ebc203e49E2B771897067fce3c58575ac')), -- Rollbit
(lower('0x8FfcC8863C590674544B1bbE0D194C2Aa5111127')), -- BCGame
(lower('0x974CaA59e49682CdA0AD2bbe82983419A2ECC400')), -- Stake
(lower('0x019D0706D65c4768ec8081eD7CE41F59Eef9b86c')), -- Stake
(lower('0xFa500178de024BF43CFA69B7e636A28AB68F2741')), -- Stake
(lower('0x5BCbdfB6cc624b959c39A2D16110D1f2D9204F72')), --Sportsbet.io #2
(lower('0x4E80744fa23cEC76e1621ce0DfACeB4B1D532e12')) --Dualbits
) as t(address)
)
-- to improve speed convert to static table
,ERC20_tokens as (
select
row_number() over(order by sum(AMOUNT_IN_USD) desc) as volume_rank,
TOKEN_IN,
SYMBOL_IN
from ethereum.core.ez_dex_swaps
where BLOCK_TIMESTAMP >= DATEADD(day, -30, GETDATE())
group by 2,3
having sum(amount_in_usd) is not null
order by 1
limit 20
)
Run a query to Download Data