pandaCity Amidst the Storm | Unstaked - Before After
    Updated 2022-11-17
    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,
    Run a query to Download Data