bachiflow nfl
    Updated 2022-07-03
    with symbol as (
    select event_contract, contract_name from flow.core.dim_contract_labels
    )

    select count(distinct nft_id) as nfts_count, count(distinct buyer) as total_wallets, sum(price) as total_sales_volume
    from flow.core.fact_nft_sales a join symbol b on a.currency = b.event_contract
    where tx_succeeded = True and nft_collection = 'A.e4cf4bdc1751c65d.AllDay'


    --DapperUtilityCoin

    Run a query to Download Data