Query editor
SELECTdate_trunc('{{granularity}}', block_time) time, case when witness_data is null then 'legacy'else 'segwit' end as signed_type, count(*) as num_inputsFROM bitcoin.inputsGROUP BY 1,2order by 1 asc
Query editor
1SELECT2date_trunc('{{granularity}}', block_time) time3, case when witness_data is null then 'legacy'4else 'segwit' end as signed_type5, count(*) as num_inputs6FROM bitcoin.inputs7GROUP BY 1,28order by 1 asc9