Query editor
WITHinputs_value AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(i.value) AS spent_valueFROM bitcoin.transactionsCROSS JOIN UNNEST(input) AS iWHERE block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1),outputs_value AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(o.value) AS output_valueFROM bitcoin.transactionsCROSS JOIN UNNEST(output) AS oWHERE block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1)SELECTi.day,i.spent_value / o.output_value AS soprFROM inputs_value iJOIN outputs_value o ON i.day = o.dayORDER BY i.day DESC