-- forked from Results Statement @ https://flipsidecrypto.xyz/edit/queries/c390ef71-aef4-42e6-886c-e47205306792 -- forked from What is the price of A, if it had the market cap of B? @ https://flipsidecrypto.xyz/edit/queries/dae1b4f3-86c7-4733-a59a-024a16c3d8fa With data AS( -- Made by @JamesT0lan on Twitter SELECT FLATTENED.value:"name"::STRING AS name, FLATTENED.value:"id"::INTEGER AS id, FLATTENED.VALUE:"symbol"::STRING AS symbol, * -- Take my code for your own dashboards just give me a shoutout on Twitter FROM ( SELECT cmc.get('/v1/cryptocurrency/listings/latest', { 'limit': 3000 } ) as resp ), LATERAL FLATTEN(input => resp:data:data) AS FLATTENED ), all_mc AS( SELECT name, FLATTENED.value:"market_cap"::FLOAT AS market_cap, FLATTENED.value:"price"::FLOAT AS price, id, symbol FROM data, LATERAL FLATTEN(input => value:quote) AS FLATTENED ), a_data AS( SELECT symbol AS a_symbol, name AS a_name, market_cap AS a_mc, price AS a_price, 'Join' AS akey FROM all_mc WHERE id = {{A_ID}} ), b_data AS( SELECT symbol AS b_symbol, name AS b_name, market_cap AS b_mc, price AS b_price, 'Join' AS bkey FROM all_mc WHERE id = {{B_ID}} ) SELECT CASE WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 = 0 THEN 'How did you manage to get 0?' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 > 0 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 50 THEN 'Surely you could be a bit more imaginative. Those are rookie numbers.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 50 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 100 THEN 'Degen that just flipped their first token, congrats.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 100 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 500 THEN 'Degeneracy is truly established. The sophisticated degen. The degen with aLpHa.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 500 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 1500 THEN 'Complete and utter downward spiralling degeneracy. Definitely struggles with relationships.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 1500 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 5000 THEN 'Shills endless shitcoins. Probably exposed by ZachXBT for dumping on followers.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 5000 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 10000 THEN 'Demands friends & family to buy at cycle tops. Hooked on Monster energy drinks.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 10000 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 50000 THEN 'The deranged degen. Will shill VRA in bull run. Has never touched grass.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 50000 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 100000 THEN 'Barely functioning crypto addict. Checks CG/CMC minimum 100 times p/ day. Struggles in general.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 >= 100000 THEN 'Seek. Help.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 < 0 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 > -50 THEN 'The sad degen. Enters trade with no conviction. Exits at 20-40% loss every time.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 <= -50 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 > -100 THEN 'Degen that is just learning how to short. Can still be saved.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 <= 100 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 > 500 THEN 'Must be an experienced shorter. Calculating potential gains on the next trade.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 <= 500 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 > 1500 THEN 'It seems like you actually want to feel pain.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 <= 1500 AND ((b_mc/a_mc * a_price) - a_price)/a_price * 100 > 100000 THEN 'Please stop. Its over.' WHEN ((b_mc/a_mc * a_price) - a_price)/a_price * 100 <= -100000 THEN 'Who imagines losing this much money?' ELSE 'What did you even put in?' END AS "Degen Statement" FROM a_data INNER JOIN b_data ON akey=bkey

Price of token if it had Bitcoin market cap?