prices copy

winnie-fsprices copy

Updated 2024-11-07

-- forked from SocioCrypto / prices @ https://flipsidecrypto.xyz/SocioCrypto/q/nKls1qsPFsM0/prices

-- MAGA / $MAGA ETH: '0xf211B655431c10E72C1CAeae37688Ae9f7F7A549' | #F4438C

-- Trog / $TROG ETH: '0x2077D81d0c5258230D5a195233941547cB5f0989' | #FFD6E7

-- BABYTRUMP / $BABYTRUMP ETH: '0x354c8cda7e3b737d360513a0dc5abcee8ee1cea3' | #FF88B0

-- Super Trump Coin / $STRUMP ETH: '0x7039cd6D7966672F194E8139074C3D5c4e6DCf65' | #FFA599

-- MAGA AGAIN / $MAGAA ETH: '0x9EBb0895bD9C7C9dFAB0d8d877c66bA613Ac98Ea' | #EC5646

-- MAGA VP / $MVP ETH: '0x766d2fcECe1E3eeF32aae8711ab886eE95fd5B2A' | #FFAFCC --

-- Baby Trump (BSC) / $BABYTRUMP BSC: '0xE66fD34c0f8726a5eb97f6d45C5A5Df4D57d39Fc' | #934d65

-- Make America Based Again / $MABA BASE: '0xD9eA93A38D1771C870128f9134D4622d331C04C8' | #E81B23

-- MAGA / $TRUMP 'HaP8r3ksG76PhQLTqR8FYBeNiQpejcFbQmiHbg787Ut1'; BASE: '0x57f5fbd3de65dfc0bd3630f732969e5fb97e6d37'; ETH: '0x576e2BeD8F7b46D34016198911Cdf9886f78bea7'; BSC: '0x4ea98c1999575aaadfb38237dd015c5e773f75a2' | #B31942

-- Daddy Trump / $TADDY 'Gp5PYbvVkF5LqqwwPP1UazFExvnnUekjqZG7x9vkpump' | #FFE7E5

-- Doland Tremp / $TREMP 'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv' | #aa181d

-- PEPE / $PTRUMP 'Gk2kRrwNMBU4Dn9JhC1Dks8G5X9nqi4ZE5jMvK6bdgEd' | #FFC2B7

-- Dark MAGA / $DMAGA '7D7BRcBYepfi77vxySapmeqRNN1wsBBxnFPJGbH5pump' | #5e0a0e

-- Fight to MAGA / $FIGHT 'KMnDBXcPXoz6oMJW5XG4tXdwSWpmWEP2RQM1Uujpump' | #fe040e

-- Jeo Boden / $BODEN '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o' | #4B5AFF

-- Kamala Harris / $HARRIS 'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump' | #DCC7FF

-- Kamala Horris / $KAMA 'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB' | #972EFF

-- Kumala Harris / $MAWA '8Sk1mazEDN1L6P6E9di4Xgza3icJw4Za9KUKqnUNEQrM' | #0A3161

-- MAGA / $PEOPLE BSC: '0xEa2F49A2e6E27b7B47cBEf50AFf5Af11350108D1'

-- Tooker Kurlson / $TOOKER '9EYScpiysGnEimnQPzazr7Jn9GVfxFYzgTEj85hV9L6U' | #8B77FF --

--Solana

with all_prices as (

-- Solana

select symbol,

date_trunc('d',hour) as date,

-- CASE WHEN token_address = 'HaP8r3ksG76PhQLTqR8FYBeNiQpejcFbQmiHbg787Ut1' THEN price end as MAGA_price,

-- CASE WHEN token_address = '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o' THEN price end as BODEN_price, /

-- CASE WHEN token_address = 'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump' THEN price end as HARRIS_price,

-- CASE WHEN token_address = 'Gp5PYbvVkF5LqqwwPP1UazFExvnnUekjqZG7x9vkpump' THEN price end as TADDY_price,

QueryRunArchived: QueryRun has been archived