winnie-fsprices copy
Updated 2024-11-07
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 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