StangFASTpart 2.2 - overview
Updated 2024-09-17
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
›
⌄
-- forked from part 2 - overview @ https://flipsidecrypto.xyz/studio/queries/3b0c596e-000e-456e-8053-fddf1375f52f
-- $COQ — 0x420fca0121dc28039145009570975747295f2329 - fdd46b
-- $TECH — 0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a - 3fa5c7
-- $WOLF - 0x4f94b8aef08c92fefe416af073f1df1e284438ec - fff600
-- $NOCHILL — 0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5 - 2a4163
-- $KIMBO 0x184ff13b3ebcb25be44e860163a5d8391dd568c1 - fa8f41
-- $HEFE - 0x18e3605b13f10016901eac609b9e188cf7c18973 - 7ac342
-- $MEOW — 0x8ad25b0083c9879942a64f00f20a70d3278f6187 - cf0508
-- $MAJIN - 0x73f49d00ac1b520f94d11248808c40774aeb0802 - e84142
with
table_1 as (
select
count( distinct a.origin_from_address ) as "traders"
, count( distinct a.tx_hash ) as "swap counts"
, sum( a.amount_in_usd ) as "USD volume"
, a.symbol_out as "symbols from"
, case
when a.symbol_out = 'BAWLS' then '<img src="https://assets.coingecko.com/coins/images/34219/standard/IMG_6155.png?1705600045" style="width: 15px; border-radius: 100%;"> <span style="color: #ff3ca0;">$BAWLS</span>'
when a.symbol_out = 'WAVAX' then '<img src="https://assets.coingecko.com/coins/images/15075/standard/wrapped-avax.png?1696514734" style="width: 15px; border-radius: 100%;"> <span style="color: #e84142;">$WAVAX</span>'
when a.symbol_out = 'GURS' then '<img src="https://assets.coingecko.com/coins/images/34281/standard/200x200.jpg?1704452874" style="width: 15px; border-radius: 100%;"> <span style="color: #cccccc;">$GURS</span>'
when a.symbol_out = 'KOVIN' then '<img src="https://assets.coingecko.com/coins/images/35978/standard/image_%282%29.png?1710306425" style="width: 15px; border-radius: 100%;"> <span style="color: #cc9b61;">$KOVIN</span>'
when a.symbol_out = 'ZUM' then '<img src="https://assets.coingecko.com/coins/images/9721/standard/zum256x256.png?1696509787" style="width: 15px; border-radius: 100%;"> <span style="color: #aa77b2;">$ZUM</span>'
when a.symbol_out = 'USDt' then '<img src="https://assets.coingecko.com/coins/images/325/standard/Tether.png?1696501661" style="width: 15px; border-radius: 100%;"> <span style="color: #009393;">$USDt</span>'
when a.symbol_out = 'MEAT' then '<img src="https://assets.coingecko.com/coins/images/33554/standard/logo.png?1702429098" style="width: 15px; border-radius: 100%;"> <span style="color: #df2a11;">$MEAT</span>'
when a.symbol_out = 'EGG' then '<img src="https://s2.coinmarketcap.com/static/img/coins/64x64/16330.png" style="width: 15px; border-radius: 100%;"> <span style="color: #f33b47;">$EGG</span>'
when a.symbol_out = 'sAVAX' then '<img src="https://assets.coingecko.com/coins/images/23657/standard/savax_blue.png?1696522860" style="width: 15px; border-radius: 100%;"> <span style="color: #00b3ed;">$sAVAX</span>'
when a.symbol_out = 'DWC' then '<img src="https://assets.coingecko.com/coins/images/34207/standard/DOGwifCrocs.png?1704275865" style="width: 15px; border-radius: 100%;"> <span style="color: #884d39;">$DWC</span>'
when a.symbol_out = 'DWC' then '<img src="https://s2.coinmarketcap.com/static/cloud/img/dex/default-icon-day-v3.svg?_=ea4bc2c" style="width: 15px; border-radius: 100%;"> <span style="color: #b0f8d8;">Other</span>'
when a.symbol_out = 'BINGO' then '<img src="https://assets.coingecko.com/coins/images/34237/standard/BingoDogCoin.png?1704456630" style="width: 15px; border-radius: 100%;"> <span style="color: #f6c1a0;">$BINGO</span>'
when a.symbol_out = 'EGS' then '<img src="https://assets.coingecko.com/coins/images/34557/standard/coingecko.png?1705371524" style="width: 15px; border-radius: 100%;"> <span style="color: #f44236;">$EGS</span>'
when a.symbol_out = 'TECH' then '<img src="https://assets.coingecko.com/coins/images/35785/standard/TECH_COIN_-_200x200.png?1710943527" style="width: 15px; border-radius: 100%;"> <span style="color: #3fa5c7;">$TECH</span>'
QueryRunArchived: QueryRun has been archived