Query editor
with ordi as (SELECT block_date as DateTime,Count(*) as Number_of_Inscription ,sum(output_value) as OutputBTC, sum(fee) as FeeFROM bitcoin.transactionsWHERE block_height > 779831--AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'AND cast(hex AS VARCHAR) LIKE '%6272632d3230%'--AND cast(hex AS VARCHAR) LIKE '%6d696e74%' --mintAND cast(hex AS VARCHAR) LIKE '%226f72646922%' --ordiGROUP BY 1ORDER BY 1 DESC),pepe as (SELECT block_date as DateTime,Count(*) as Number_of_Inscription ,sum(output_value) as OutputBTC, sum(fee) as FeeFROM bitcoin.transactionsWHERE block_height > 779831--AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'AND cast(hex AS VARCHAR) LIKE '%6272632d3230%'--AND cast(hex AS VARCHAR) LIKE '%6d696e74%' --mintAND cast(hex AS VARCHAR) LIKE '%227065706522%' --pepeGROUP BY 1ORDER BY 1 DESC),meme as (SELECT block_date as DateTime,Count(*) as Number_of_Inscription ,sum(output_value) as OutputBTC, sum(fee) as FeeFROM bitcoin.transactionsWHERE block_height > 779831--AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'AND cast(hex AS VARCHAR) LIKE '%6272632d3230%'--AND cast(hex AS VARCHAR) LIKE '%6d696e74%' --mintAND cast(hex AS VARCHAR) LIKE '%226d656d6522%' --memeGROUP BY 1ORDER BY 1 DESC),shib as (SELECT block_date as DateTime,Count(*) as Number_of_Inscription ,sum(output_value) as OutputBTC, sum(fee) as FeeFROM bitcoin.transactionsWHERE block_height > 779831--AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'AND cast(hex AS VARCHAR) LIKE '%6272632d3230%'--AND cast(hex AS VARCHAR) LIKE '%6d696e74%' --mintAND cast(hex AS VARCHAR) LIKE '%225348494222%' --SHIBGROUP BY 1ORDER BY 1 DESC),nals as (SELECT block_date as DateTime,Count(*) as Number_of_Inscription ,sum(output_value) as OutputBTC, sum(fee) as FeeFROM bitcoin.transactionsWHERE block_height > 779831--AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'AND cast(hex AS VARCHAR) LIKE '%6272632d3230%'--AND cast(hex AS VARCHAR) LIKE '%6d696e74%' --mintAND cast(hex AS VARCHAR) LIKE '%226e616c7322%' --nalsGROUP BY 1ORDER BY 1 DESC),domo as (SELECT block_date as DateTime,Count(*) as Number_of_Inscription ,sum(output_value) as OutputBTC, sum(fee) as FeeFROM bitcoin.transactionsWHERE block_height > 779831--AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'AND cast(hex AS VARCHAR) LIKE '%6272632d3230%'--AND cast(hex AS VARCHAR) LIKE '%6d696e74%' --mintAND cast(hex AS VARCHAR) LIKE '%22646f6d6f22%' --domoGROUP BY 1ORDER BY 1 DESC),