Deebs-DeFi-j9fRbzRecently Listed Tokens DEX Swaps (Cross chain table) Deebs Data copy
Updated 2023-11-26
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 DEX Swaps (Cross chain table) Deebs Data @ https://flipsidecrypto.xyz/edit/queries/56180340-5a82-4aee-986d-41bdc9b8a600
-- forked from ALL TOKENS CEX and DEX NET FLOW on ETHEREUM (Smart Money Only) copy copy copy @ https://flipsidecrypto.xyz/edit/queries/fb84035a-5a54-4934-8010-af0c6e960e2e
WITH tokenlist AS(
SELECT DISTINCT
MIN(BLOCK_TIMESTAMP) as listing_date,
symbol_OUT as symbol,
lower(TOKEN_OUT) as contract_address
FROM crosschain.defi.ez_dex_swaps
Group by symbol, contract_address
Having listing_date > CURRENT_DATE -{{days}}
),
buys2 AS(
SELECT
date_trunc('month', BLOCK_TIMESTAMP) AS DATE,
symbol_out as symbol,
TOKEN_OUT as contract_address,
sum(Amount_OUT_USD) AS total_bought_USD2,
MIN(BLOCK_TIMESTAMP) as listing_date
FROM crosschain.defi.ez_dex_swaps
WHERE TRADER IN(lower('0x7d325a9c8f10758188641fe91cfd902499edc782')
,lower('0x66b870ddf78c975af5cd8edc6de25eca81791de1')
,lower('0x05E793cE0C6027323Ac150F6d45C2344d28B6019')
,lower('0xf93D43dBB6215963D8E3e3C2aC602bb8311C8503')
,lower('0x1442b96bfee50deee97c3d5804890adc053ea7d1')
,lower('0xb944020ec109f54b9899249661cfc09049834a95')
,lower('0x8608343b7987d903bb720d9425a8be54de48f1d3')
,lower('0x201d252fa4dd34744162d1dbc9063e2b6fc7ab01')
,lower('0x4c262bdb0ed4d40f1a7b85075762d6058a3b6fed')
,lower('0x98d3ed59c5b2ea49b91138890b5b4883f067be1b')
,lower('0x3c043dbcf713e9c96951815a8bf4b90427f424f7')
,lower('0x3e0d86c74380c90063724f4c490fddce4387d22b')
,lower('0x4fa9a9ca290dd01b688c9ed2c1cc61dff0b01bba')
,lower('0xe516d61ed4415f24606ddc14b3445dabf39d3498')
Run a query to Download Data