hrst79op nft
    Updated 2022-12-25
    with tab1 as (
    SELECT
    date_trunc('day', block_timestamp) as day ,
    count(DISTINCT tx_hash) as sales_events,
    sum(price) as sales_volume,
    median(price) as median_price
    FROM optimism.core.ez_nft_sales
    WHERE currency_symbol LIKE 'ETH'
    and day >= '2022-11-1'
    GROUP BY day)
    ,
    tab2 as (select
    date_trunc('day',hour) as day ,
    avg(price) as op_price
    from optimism.core.fact_hourly_token_prices
    where symbol = 'OP'
    and day >= '2022-11-1'
    group by day
    )
    ,
    tab3 as (SELECT date_trunc('day', block_timestamp) as day,
    count(DISTINCT from_Address) as n_users,
    count(DISTINCT tx_hash) as n_txns,
    sum(eth_value) as volume
    FROM optimism.core.fact_transactions
    WHERE day >= '2022-11-1'
    group by day)
    ,
    tab4 as (select
    date_trunc('day',block_timestamp) as day,
    LABEL_TYPE ,
    sum(RAW_AMOUNT)/1e18 as volume_OP,
    avg(RAW_AMOUNT)/1e18 as avg_volume_OP,
    FROM optimism.core.fact_token_transfers a
    Run a query to Download Data