-- forked from StangFAST / part 2 - last price @ https://flipsidecrypto.xyz/StangFAST/q/fzcO88uwFk1s/part-2---last-price -- forked from part 1 - price @ https://flipsidecrypto.xyz/studio/queries/f4a97407-66a5-4c35-b921-7268003d55d9 -- $COQ — 0x420fca0121dc28039145009570975747295f2329 - fdd46b -- $TECH — 0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a - 3fa5c7 -- $WOLF - 0x4f94b8aef08c92fefe416af073f1df1e284438ec - fff600 -- $NOCHILL — 0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5 - 2a4163 -- $KIMBO 0x184ff13b3ebcb25be44e860163a5d8391dd568c1 - fa8f41 -- $HEFE - 0x18e3605b13f10016901eac609b9e188cf7c18973 - 7ac342 -- $MEOW — 0x8ad25b0083c9879942a64f00f20a70d3278f6187 - cf0508 -- $MAJIN - 0x73f49d00ac1b520f94d11248808c40774aeb0802 - e84142 select date_trunc( 'week' , a.hour ) as "weekly" , avg( a.price ) as "price" , a.name as "name" , a.symbol as "symbol" , a.decimals as "decimals" , case when a.symbol = 'COQ' then '

$COQ ' when a.symbol = 'TECH' then '

$TECH ' when a.symbol = 'WOLF' then '

$WOLF ' when a.symbol = 'NOCHILL' then '

$NOCHILL ' when a.symbol = 'KIMBO' then '

$KIMBO ' when a.symbol = 'HEFE' then '

$HEFE ' when a.symbol = 'MEOW' then '

$MEOW ' when a.symbol = 'MAJIN' then '

$MAJIN ' end as "image" from avalanche.price.ez_prices_hourly a where a.token_address in ( '0x420fca0121dc28039145009570975747295f2329' , '0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a' , '0x4f94b8aef08c92fefe416af073f1df1e284438ec' , '0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5' , '0x184ff13b3ebcb25be44e860163a5d8391dd568c1' , '0x18e3605b13f10016901eac609b9e188cf7c18973' , '0x8ad25b0083c9879942a64f00f20a70d3278f6187' , '0x73f49d00ac1b520f94d11248808c40774aeb0802' ) and date_trunc('month', a.hour) = date_trunc('month', current_date) group by 1 , 3 , 4 , 5 , 6 order by 1 DESC

Diamond