SalehSecondary Sales Activity-mint price
    Updated 2022-06-21
    select
    date_trunc(day, block_timestamp)::date as date,
    event_inputs:winner as winner,
    sum(event_inputs:amount/pow(10,18)) as mint_price,
    count(DISTINCT event_inputs:nounId) as tokenid_count
    from ethereum.core.fact_event_logs
    where contract_address = lower('0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e')
    and event_name = 'AuctionSettled'
    and tx_status = 'SUCCESS'
    group by 1, 2
    order by 1
    Run a query to Download Data