gigiokobaOverview of Top 100 Addresses copy
Updated 2024-10-18
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 hess / Overview of Top 100 Addresses @ https://flipsidecrypto.xyz/hess/q/fUrsGy4Ee4FV/overview-of-top-100-addresses
with swaps as ( select block_timestamp::date as date,
tx_hash,
origin_from_address as swapper,
amount_in_usd,
amount_out_usd,
amount_in,
amount_out,
token_in,
token_out,
symbol_in,
symbol_out
from kaia.defi.ez_dex_swaps
where platform = 'neopin')
,
final as ( select date as daily,
tx_hash,
swapper,
case when token_in in ('0x5c13e303a62fc5dedf5b52d66873f2e59fedadc2','0x608792deb376cce1c9fa4d0e6b7b44f507cffa6a','0x4e4a231e864219704ccc1acd81043129157c1901','0xe2053bcf56d2030d2470fb454574237cf9ee3d4b','0xcee8faf64bb97a73bb51e115aa89c17ffa8dd167','0x754288077d0ff82af7a5317c7cb8c444d421d103','0x7d8142a696ddbb8eaaa937696c35772190b234cb','0xcb2c7998696ef7a582dfd0aafadcd008d03e791a') then amount_in else amount_in_usd end as amount_1,
case when token_out in ('0x5c13e303a62fc5dedf5b52d66873f2e59fedadc2','0x608792deb376cce1c9fa4d0e6b7b44f507cffa6a','0x4e4a231e864219704ccc1acd81043129157c1901','0xe2053bcf56d2030d2470fb454574237cf9ee3d4b','0xcee8faf64bb97a73bb51e115aa89c17ffa8dd167','0x754288077d0ff82af7a5317c7cb8c444d421d103','0x7d8142a696ddbb8eaaa937696c35772190b234cb','0xcb2c7998696ef7a582dfd0aafadcd008d03e791a') then amount_out else amount_out_usd end as amount_2,
case WHEN token_in = '0x46db825593ca7c3fdfc9ccb5850ea96c39b79330' THEN 'NGIT'
WHEN token_in = '0x9d52704cd67d586ed2870d810b0cef2cc168ae42' THEN 'ZEMIT'
WHEN token_in = '0x275f942985503d8ce9558f8377cc526a3aba3566' THEN 'WIKEN'
WHEN token_in = '0x02e973155b1f5f60a1ff1c4e8e7f371c89526cbc' THEN 'IPV'
WHEN token_in = '0x19a16aa7c987fbda7dae021b05c1eb06524c7893' THEN 'nFNSA'
WHEN token_in = '0xdd483a970a7a7fef2b223c3510fac852799a88bf' THEN 'MIX'
WHEN token_in = '0x57d1a61e4fd09fbf16e35b04959e94dcf2032974' THEN 'WKLAY'
WHEN token_in = '0x8888888888885b073f3c81258c27e83db228d5f3' THEN 'SCNR'
WHEN token_in = '0xec47f42260438666cc88ce6ef770283f2d19d39b' THEN 'JOY'
WHEN token_in = '0xdcd62c57182e780e23d2313c4782709da85b9d6c' THEN 'SSX'
WHEN token_in = '0x79bb4d71f6c168531a259dd6d40a8d5de5a34427' THEN 'MARD'
WHEN token_in = '0xb0bb95ac3195a266ab924596ba32c2a10e245a95' THEN 'npKLAY'
WHEN token_in = '0xe5647cbd45b39673a0617ac707375515353bb057' THEN 'S2T'
WHEN token_in = '0xe06b40df899b9717b4e6b50711e1dc72d08184cf' THEN 'HIBS'
WHEN token_in = '0x3f99650d1cde590d0d4f968d125594e9b876c22c' THEN 'nETH'
QueryRunArchived: QueryRun has been archived