Query editor
withbase as (SELECTdate_trunc('day', block_time) as day--types to hex here https://dune.com/queries/1981638?d=11--uncaught types filtering here https://dune.com/queries/1981648?d=11, split(from_utf8(from_hex(--get the content type hashsubstr(cast(hex as varchar), regexp_position(cast(hex as varchar),'0063036f72640101') +18 --start from portion where standard ends, bytearray_to_integer('0x' || substr(cast(hex as varchar),regexp_position(cast(hex as varchar),'0063036f72640101') +16, 2))*2 --get bytes pushed as content type))) --convert from hex to utf8 again,'/')[1] --split by / and take just first part.as content_type, count(*) as ordinalsFROM bitcoin.transactions twhere block_height > 767429AND cast(hex as varchar) LIKE '%0063036f726401%' --OP_FALSE (0x00) OP_IF (0x63) OP_PUSHBYTES3 (0x03) "ord" (0x6f7264) OP_1 (0x01) https://docs.ordinals.com/inscriptions.html-- AND t.input[1].witness_data[2] LIKE '%0063036f726401%' AND t.input[1].type = 'witness_v1_taproot' --this doesn't work because of array length checksGROUP BY 1,2)SELECTday, case when content_type IN ('audio','image','text','model','application','video') then content_typeelse 'other' end as content_type, ordinalsFROM base