flipside

    all sale information(monthly)
    ValiMohammadiall sale information(monthly)
    Updated 2023-01-30
    with t1 AS (
    select
    RECORDED_HOUR :: date as day,
    avg(close) as price_token
    from
    solana.core.fact_token_prices_hourly
    where
    SYMBOL = 'SOL'
    group by
    1
    )
    select
    date_trunc('month', BLOCK_TIMESTAMP) as date,
    count(distinct tx_id) as number_of_sale,
    count(distinct PURCHASER) as number_of_buyer,
    sum(SALES_AMOUNT) as volume,
    sum(SALES_AMOUNT * price_token) as volume_usd,
    avg(SALES_AMOUNT * price_token) as average_volume,
    Median(SALES_AMOUNT * price_token) as median_volume,
    avg(average_volume) OVER (
    ORDER BY
    date ROWS BETWEEN 6 PRECEDING
    AND CURRENT ROW
    ) as MA_7_Days,
    avg(average_volume) OVER (
    ORDER BY
    date ROWS BETWEEN 19 PRECEDING
    AND CURRENT ROW
    ) as MA_20_Days,
    min(SALES_AMOUNT * price_token) as floor_price,
    max(SALES_AMOUNT * price_token) as highest_price,
    sum(number_of_buyer) over (
    order by
    date
    ) as cum_buyers,
    sum(number_of_sale) over (
    Run a query to Download Data