KingTigerMafia-7mwRZbUntitled Query
    Updated 2022-09-15
    -- flow metrics
    with flow_price as (
    select timestamp::date as date, avg(price_usd) as price
    from flow.core.fact_prices
    where token_contract = 'A.1654653399040a61.FlowToken' and date >= '2022-04-20'
    group by 1
    order by 1 asc
    )
    select block_timestamp::date as date, count(DISTINCT BUYER) as num_buyer, sum(price) as total_sales_price_per_day, avg(price) as avg_sales_price_per_day, count(nft_collection) as num_nft_sell_per_day
    from flow.core.ez_nft_sales
    where date >= '2022-04-20' and tx_succeeded = 'TRUE'
    group by 1
    order by 1 asc



    -- NUM SELLER
    select block_timestamp::date as date, count(distinct seller) as num_seller
    from flow.core.ez_nft_sales
    where date >= '2022-04-20' and tx_succeeded = 'TRUE'
    group by 1
    order by 1 asc

    select block_timestamp::date as date, count(distinct seller_address) as num_seller
    from ethereum.core.ez_nft_sales
    where date >= '2022-04-20' and event_type = 'sale'
    group by 1
    order by 1

    select block_timestamp::date as date, count(distinct seller) as num_seller
    from solana.core.fact_nft_sales
    where date >= '2022-04-20' and succeeded = 'TRUE'
    group by 1
    order by 1 asc


    Run a query to Download Data