WITH near_Price AS
(
SELECT
TIMESTAMP::date as day,
AVG(price_usd) as usd_Price
FROM
NEAR.CORE.FACT_PRICES
WHERE
TIMESTAMP >= '2022-11-01'
AND
SYMBOL = 'wNEAR'
GROUP BY
day
),
solana_Price AS
(
SELECT
RECORDED_HOUR::date as day,
AVG(CLOSE) as usd_Price
FROM
solana.core.fact_token_prices_hourly
WHERE
recorded_hour >= '2022-11-01'
AND
SYMBOL = 'SOL'
GROUP BY
day
)
SELECT
CASE WHEN BLOCK_TIMESTAMP >= '2022-11-11' then 'After Bankrupt'
ELSE 'Before Bankrupt' END AS Bankrupt,
'NEAR' as blockchain,
COUNT(distinct TX_HASH) as tx_Count,
COUNT(distinct TX_SIGNER) as users_Count,