-- WITH -- sales AS ( -- SELECT -- BLOCK_TIMESTAMP, -- tx_id -- FROM -- solana.core.fact_transactions -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND ( -- array_contains( -- parse_json( -- '{"pubkey":"M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- ME -- OR array_contains( -- parse_json( -- '{"pubkey":"HYPERfwdTjyJ2SCaKHmpF2MtrXqWxrsotYDsTrshHWq8","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- hyperspace -- OR array_contains( -- parse_json( -- '{"pubkey":"5SKmrbAxnHV2sgqyDXkGrLrokZYtWWVEEk5Soed7VLVN","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- yawww -- OR array_contains( -- parse_json( -- '{"pubkey":"CJsLwbP1iu5DuUikHEJnLfANgKy6stB2uFgvBBHoyxwz","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- solanart -- OR array_contains( -- parse_json( -- '{"pubkey":"hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- auction house -- OR array_contains( -- parse_json( -- '{"pubkey":"TSWAPaqyCSx2KABk68Shruf4rp7CxcNi8hAsbdwmHbN","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- tensorswap -- OR array_contains( -- parse_json( -- '{"pubkey":"hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- hadeswap -- OR array_contains( -- parse_json( -- '{"pubkey":"mmm3XBJg5gk8XJxEKBvdgptZz6SgK4tXvn36sodowMc","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- coral cube -- ) -- AND array_contains( -- to_variant('Program log: Instruction: Transfer'), -- log_messages -- ) -- AND succeeded = True -- ), -- fff_treasury AS ( -- SELECT -- tx_id, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '14 days' -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND tx_to = '3pMvTLUA9NzZQd4gi725p89mvND1wRNQM3C8XEv1hTdA' -- AND mint = 'So11111111111111111111111111111111111111112' -- ), -- tff_treasury AS ( -- SELECT -- tx_id, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '14 days' -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND tx_to = 'MwW2RfWAfGrKmh9QAkDELdEV7Ue39FoP885dhuHmqr9' -- AND mint = 'So11111111111111111111111111111111111111112' -- ), -- den_treasury AS ( -- SELECT -- tx_id, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '14 days' -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND tx_to = '3vedckD9AnCNp7vEEnTUzVK6bWHEQgSpPRB7A5aS67kj' -- AND mint = 'So11111111111111111111111111111111111111112' -- ), -- fff_royalties AS ( -- SELECT -- sales.BLOCK_TIMESTAMP, -- amount -- FROM -- sales -- JOIN fff_treasury using (tx_id) -- ), -- tff_royalties AS ( -- SELECT -- sales.BLOCK_TIMESTAMP, -- amount -- FROM -- sales -- JOIN tff_treasury using (tx_id) -- ), -- den_royalties AS ( -- SELECT -- sales.BLOCK_TIMESTAMP, -- amount -- FROM -- sales -- JOIN den_treasury using (tx_id) -- ), -- royalties_total AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- fff_royalties -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- tff_royalties -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- den_royalties -- ), -- raffles_program_interactions AS ( -- SELECT -- tx_id -- FROM -- solana.core.fact_transactions -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND ARRAY_CONTAINS( -- PARSE_JSON( -- '{"pubkey":"9ehXDD5bnhSpFVRf99veikjgq8VajtRH7e3D9aVPLqYd","signer":false,"source":"transaction","writable":false}' -- ), -- ACCOUNT_KEYS -- ) -- AND array_contains( -- to_variant('Program log: Instruction: CollectProceedsV2'), -- log_messages -- ) -- AND succeeded = True -- ), -- rafffle_treasury_account_activity AS ( -- SELECT -- tx_id, -- amount, -- BLOCK_TIMESTAMP -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND tx_to = 'GFDko6sYw96a3nUmPqNLZwq7YstQ1u1SNUaVhnoCPW7o' -- AND MINT = 'So11111111111111111111111111111111111111112' -- ), -- raffles_total AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- raffles_program_interactions -- JOIN rafffle_treasury_account_activity using (tx_id) -- ), -- tools AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- tx_to = '98Ni7vVRR1tggtWWruPVcfFXHTH11bPbNryJZGkCGvaD' -- AND BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND amount <= 0.012 -- AND amount > 0 -- ), -- tm_program_interactions AS ( -- SELECT -- tx_id -- FROM -- solana.core.fact_transactions -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND ARRAY_CONTAINS( -- PARSE_JSON( -- '{"pubkey":"8BYmYs3zsBhftNELJdiKsCN2WyCBbrTwXd6WG4AFPr6n","signer":false,"source":"transaction","writable":false}' -- ), -- ACCOUNT_KEYS -- ) -- AND array_contains( -- to_variant('Program log: Instruction: BuyItem'), -- log_messages -- ) -- AND succeeded = True -- ), -- tm_treasury_account_activity AS ( -- SELECT -- TX_ID, -- BLOCK_TIMESTAMP, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND TX_TO = '2x3yujqB7LCMdCxV7fiZxPZStNy7RTYqWLSvnqtqjHR6' -- AND amount >= 0 -- ), -- tm_revenue AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- tm_program_interactions -- JOIN tm_treasury_account_activity using (tx_id) -- ), -- ffflip AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (current_date - INTERVAL '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND TX_TO = 'Fz2tay9wmAhaz1GuEETorL55LBMECaT85DX9Tj5zqQKb' -- AND AMOUNT >= 0 -- AND AMOUNT <= 0.3 -- ), -- citrus as ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '14 days') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND TX_TO = '7e7qhwnJuLVDGBiLAGjB9FxfpizsPhQjoBxkNA5wVCCc' -- AND MINT = 'So11111111111111111111111111111111111111112' -- AND AMOUNT <= 100 -- ), -- total AS ( -- SELECT -- BLOCK_TIMESTAMP, -- sum(amount) as sol, -- 'royalties' as label -- FROM -- royalties_total -- GROUP BY -- BLOCK_TIMESTAMP -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount as sol, -- 'rafffles' as label -- FROM -- raffles_total -- GROUP BY -- BLOCK_TIMESTAMP, -- amount -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount as sol, -- 'token market' as label -- FROM -- tm_revenue -- GROUP BY -- BLOCK_TIMESTAMP, -- amount -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount as sol, -- 'ffflip' as label -- FROM -- ffflip -- GROUP BY -- BLOCK_TIMESTAMP, -- amount -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount as sol, -- 'tools' as label -- FROM -- tools -- GROUP BY -- BLOCK_TIMESTAMP, -- amount -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- amount as sol, -- 'Citrus' AS source -- FROM -- citrus -- GROUP BY -- BLOCK_TIMESTAMP, -- amount -- ), -- grand_total AS ( -- SELECT -- 'SOL' as token, -- date_trunc('day', BLOCK_TIMESTAMP) as blocktime, -- sum(sol) AS sol -- FROM -- total -- GROUP BY -- blocktime -- ), -- prices AS ( -- SELECT -- symbol, -- avg(close) AS close, -- date_trunc('day', RECORDED_HOUR) AS prices_blocktime -- FROM -- solana.price.fact_token_prices_hourly -- GROUP BY -- prices_blocktime, -- symbol -- ) -- SELECT -- blocktime, -- avg(sol * close) as usdc -- FROM -- grand_total -- JOIN prices ON ( -- TOKEN = SYMBOL -- AND blocktime = prices_blocktime -- ) -- GROUP BY -- blocktime -- WITH -- sales AS ( -- SELECT -- BLOCK_TIMESTAMP, -- tx_id -- FROM -- solana.core.fact_transactions -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND ( -- array_contains( -- parse_json( -- '{"pubkey":"M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- ME -- OR array_contains( -- parse_json( -- '{"pubkey":"HYPERfwdTjyJ2SCaKHmpF2MtrXqWxrsotYDsTrshHWq8","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- hyperspace -- OR array_contains( -- parse_json( -- '{"pubkey":"5SKmrbAxnHV2sgqyDXkGrLrokZYtWWVEEk5Soed7VLVN","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- yawww -- OR array_contains( -- parse_json( -- '{"pubkey":"CJsLwbP1iu5DuUikHEJnLfANgKy6stB2uFgvBBHoyxwz","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- solanart -- OR array_contains( -- parse_json( -- '{"pubkey":"hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- auction house -- OR array_contains( -- parse_json( -- '{"pubkey":"TSWAPaqyCSx2KABk68Shruf4rp7CxcNi8hAsbdwmHbN","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- tensorswap -- OR array_contains( -- parse_json( -- '{"pubkey":"5SKmrbAxnHV2sgqyDXkGrLrokZYtWWVEEk5Soed7VLVN","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- hadeswap -- OR array_contains( -- parse_json( -- '{"pubkey":"mmm3XBJg5gk8XJxEKBvdgptZz6SgK4tXvn36sodowMc","signer":false,"source":"transaction","writable":false}' -- ), -- account_keys -- ) -- coral cube -- ) -- ), -- fff_treasury AS ( -- SELECT -- tx_id, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND tx_to = '3pMvTLUA9NzZQd4gi725p89mvND1wRNQM3C8XEv1hTdA' -- AND mint = 'So11111111111111111111111111111111111111112' -- ), -- tff_treasury AS ( -- SELECT -- tx_id, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND tx_to = 'MwW2RfWAfGrKmh9QAkDELdEV7Ue39FoP885dhuHmqr9' -- AND mint = 'So11111111111111111111111111111111111111112' -- ), -- den_treasury AS ( -- SELECT -- tx_id, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND tx_to = '3vedckD9AnCNp7vEEnTUzVK6bWHEQgSpPRB7A5aS67kj' -- AND mint = 'So11111111111111111111111111111111111111112' -- ), -- fff_royalties AS ( -- SELECT -- sales.BLOCK_TIMESTAMP, -- tx_id, -- amount -- FROM -- sales -- JOIN fff_treasury using (tx_id) -- ), -- tff_royalties AS ( -- SELECT -- sales.BLOCK_TIMESTAMP, -- tx_id, -- amount -- FROM -- sales -- JOIN tff_treasury using (tx_id) -- ), -- den_royalties AS ( -- SELECT -- sales.BLOCK_TIMESTAMP, -- tx_id, -- amount -- FROM -- sales -- JOIN den_treasury using (tx_id) -- ), -- royalties_total AS ( -- SELECT -- BLOCK_TIMESTAMP, -- SUM(amount) AS sol -- FROM -- fff_royalties -- GROUP BY -- BLOCK_TIMESTAMP -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- SUM(amount) AS sol -- FROM -- tff_royalties -- GROUP BY -- BLOCK_TIMESTAMP -- UNION -- SELECT -- BLOCK_TIMESTAMP, -- SUM(amount) AS sol -- FROM -- den_royalties -- GROUP BY -- BLOCK_TIMESTAMP -- ), -- raffles_program_interactions AS ( -- SELECT -- BLOCK_TIMESTAMP as block_time -- FROM -- solana.core.fact_transactions -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND ARRAY_CONTAINS( -- PARSE_JSON( -- '{"pubkey":"9ehXDD5bnhSpFVRf99veikjgq8VajtRH7e3D9aVPLqYd","signer":false,"source":"transaction","writable":false}' -- ), -- ACCOUNT_KEYS -- ) -- AND array_contains( -- to_variant('Program log: Instruction: CollectProceedsV2'), -- log_messages -- ) -- AND succeeded = True -- ), -- rafffle_treasury_account_activity AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND tx_to = 'GFDko6sYw96a3nUmPqNLZwq7YstQ1u1SNUaVhnoCPW7o' -- AND MINT = 'So11111111111111111111111111111111111111112' -- ), -- raffles_total AS ( -- SELECT -- sum(amount) as amount -- FROM -- raffles_program_interactions -- JOIN rafffle_treasury_account_activity ON raffles_program_interactions.block_time = rafffle_treasury_account_activity.BLOCK_TIMESTAMP -- ), -- tools AS ( -- SELECT -- sum(amount) as amount -- FROM -- solana.core.fact_transfers -- WHERE -- tx_to = '98Ni7vVRR1tggtWWruPVcfFXHTH11bPbNryJZGkCGvaD' -- AND BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND amount <= 0.012 -- AND amount > 0 -- ), -- tm_program_interactions AS ( -- SELECT -- BLOCK_TIMESTAMP as block_time -- FROM -- solana.core.fact_transactions -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND ARRAY_CONTAINS( -- PARSE_JSON( -- '{"pubkey":"8BYmYs3zsBhftNELJdiKsCN2WyCBbrTwXd6WG4AFPr6n","signer":false,"source":"transaction","writable":false}' -- ), -- ACCOUNT_KEYS -- ) -- AND array_contains( -- to_variant('Program log: Instruction: BuyItem'), -- log_messages -- ) -- AND succeeded = True -- GROUP BY -- BLOCK_TIMESTAMP -- ), -- tm_treasury_account_activity AS ( -- SELECT -- BLOCK_TIMESTAMP, -- amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND TX_TO = '2x3yujqB7LCMdCxV7fiZxPZStNy7RTYqWLSvnqtqjHR6' -- AND amount >= 0 -- ), -- tm_revenue AS ( -- SELECT -- sum(amount) as amount -- FROM -- tm_program_interactions -- JOIN tm_treasury_account_activity ON tm_program_interactions.block_time = tm_treasury_account_activity.BLOCK_TIMESTAMP -- ), -- ffflip AS ( -- SELECT -- sum(amount) as amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND TX_TO = 'Fz2tay9wmAhaz1GuEETorL55LBMECaT85DX9Tj5zqQKb' -- AND AMOUNT >= 0 -- AND AMOUNT <= 0.3 -- ), -- citrus as ( -- SELECT -- sum(amount) as amount -- FROM -- solana.core.fact_transfers -- WHERE -- BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') -- AND BLOCK_TIMESTAMP < CURRENT_DATE -- AND TX_TO = '7e7qhwnJuLVDGBiLAGjB9FxfpizsPhQjoBxkNA5wVCCc' -- AND MINT = 'So11111111111111111111111111111111111111112' -- AND AMOUNT <= 100 -- ), -- total AS ( -- SELECT -- --'SOL' AS token, -- sum(sol) as sol, -- 'royalties' as label -- FROM -- royalties_total -- GROUP BY -- BLOCK_TIMESTAMP, -- sol -- UNION -- SELECT -- --'SOL' AS token, -- amount as sol, -- 'rafffles' as label -- FROM -- raffles_total -- UNION -- SELECT -- --'SOL' AS token, -- amount as sol, -- 'token market' as label -- FROM -- tm_revenue -- UNION -- SELECT -- --'SOL' AS token, -- amount as sol, -- 'ffflip' as label -- FROM -- ffflip -- UNION -- SELECT -- --'SOL' AS token, -- amount as sol, -- 'tools' as label -- FROM -- tools -- UNION -- SELECT -- amount as sol, -- 'citrus' as label -- FROM -- citrus -- ), -- grand_total AS ( -- SELECT -- 'SOL' as token, -- sum(sol) as sol -- FROM -- total -- ), -- prices AS ( -- SELECT -- symbol, -- avg(close) as close -- FROM -- solana.price.fact_token_prices_hourly -- WHERE -- RECORDED_HOUR >= CURRENT_TIMESTAMP - interval '12 months' -- GROUP BY -- symbol -- ) -- SELECT -- avg(close * sol) as total -- FROM -- grand_total -- JOIN prices ON TOKEN = SYMBOL with ffflip as ( SELECT BLOCK_TIMESTAMP, amount, 'ffflip' as label FROM solana.core.fact_transfers WHERE BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') AND BLOCK_TIMESTAMP <= CURRENT_DATE AND TX_TO = 'Fz2tay9wmAhaz1GuEETorL55LBMECaT85DX9Tj5zqQKb' AND AMOUNT >= 0 AND AMOUNT <= 0.3 AND mint = 'So11111111111111111111111111111111111111112' ), raffles as ( SELECT BLOCK_TIMESTAMP, amount, 'raffles' as label FROM solana.core.fact_transfers WHERE BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') AND BLOCK_TIMESTAMP < CURRENT_DATE AND tx_to = 'GFDko6sYw96a3nUmPqNLZwq7YstQ1u1SNUaVhnoCPW7o' AND MINT = 'So11111111111111111111111111111111111111112' ), royalties as ( SELECT BLOCK_TIMESTAMP, amount, 'royalties' as label from solana.core.fact_transfers where BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') and tx_to in ( '3vedckD9AnCNp7vEEnTUzVK6bWHEQgSpPRB7A5aS67kj', 'MwW2RfWAfGrKmh9QAkDELdEV7Ue39FoP885dhuHmqr9', '3pMvTLUA9NzZQd4gi725p89mvND1wRNQM3C8XEv1hTdA' ) AND mint = 'So11111111111111111111111111111111111111112' AND amount <= 10 ), token_market as ( SELECT BLOCK_TIMESTAMP, amount, 'token_market' as label FROM solana.core.fact_transfers WHERE BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') AND BLOCK_TIMESTAMP < CURRENT_DATE AND TX_TO = '2x3yujqB7LCMdCxV7fiZxPZStNy7RTYqWLSvnqtqjHR6' AND amount >= 0 AND mint = 'So11111111111111111111111111111111111111112' ), tools as ( SELECT BLOCK_TIMESTAMP, amount, 'tools' as label FROM solana.core.fact_transfers WHERE tx_to = '98Ni7vVRR1tggtWWruPVcfFXHTH11bPbNryJZGkCGvaD' AND BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') AND amount <= 0.012 AND amount > 0 AND mint = 'So11111111111111111111111111111111111111112' ), citrus as ( SELECT BLOCK_TIMESTAMP, amount, 'citrus' as label FROM solana.core.fact_transfers WHERE BLOCK_TIMESTAMP >= (CURRENT_DATE - interval '12 months') AND BLOCK_TIMESTAMP < CURRENT_DATE AND TX_TO = '7e7qhwnJuLVDGBiLAGjB9FxfpizsPhQjoBxkNA5wVCCc' AND MINT = 'So11111111111111111111111111111111111111112' ), total AS ( SELECT date_trunc('week', BLOCK_TIMESTAMP) as blocktime, 'SOL' as token, sum(amount) as sol, label FROM ( select * from citrus union select * from tools union select * from token_market union select * from royalties union select * from raffles union select * from ffflip ) GROUP BY LABEL, blocktime ), prices AS ( select date_trunc('week', recorded_hour) as blocktime, avg(close) as close from solana.price.fact_token_prices_hourly where id = 'solana' and recorded_hour >= (CURRENT_DATE - interval '12 months') group by blocktime ) SELECT blocktime, label, close * sol as total, sol FROM total JOIN prices using (blocktime)

Query	Creator	Created
Getting Started	draxxtssol-h1Ut3F	Nov 19, 2023
OTC KPI solana nft	draxxtssol-h1Ut3F	Nov 24, 2023
[FFF] Inflows dollarized (12 months) solana prices	draxxtssol-h1Ut3F	Nov 25, 2023
2023-11-19 09:32 AM	draxxtssol-h1Ut3F	Nov 19, 2023
2023-11-19 10:03 AM	draxxtssol-h1Ut3F	Nov 19, 2023

draxxtssol-h1Ut3F