Query editor
-- This query used incompatible data types from Dune SQL alpha and may need to be updated.-- More details can be found on https://dune.com/docs/query/dunesql-changes/select date_trunc('day',s.tx_timestamp_dt) as day, fill_source, count(*) as sales, sum(price_decimal) as volumefrom reservoir.sales sjoin reservoir.tokens t on s.contract = t.contract and s.token_id = t.token_idjoin reservoir.collections c on t.collection_id = c.idwhere s.contract = '0x82c7a8f707110f5fbb16184a5933e9f78a34c6ab'and c.name = 'Bitcoin Punks'group by 1,2