{
  "Aela": "WITH raw_tx AS (\n  SELECT\n    date_trunc('hour', block_time) as block_hour,\n    1000 as amt,\n    gas_used / 1e18 * gas_price as gas\n  FROM arbitrum.transactions\n  WHERE\n    block_date >= TRY_CAST('2023-11-23' AS DATE)\n    AND block_number >= 153659479\n    AND \"from\" = to\n    AND FROM_UTF8(data) = 'data:,{\"p\":\"fair-20\",\"op\":\"mint\",\"tick\":\"fair\",\"amt\":\"1000\"}'\n    AND success = TRUE\n  ORDER BY\n    block_number,\n    index\n  LIMIT 10000000\n)\nselect\n  block_hour,\n  sum(amt) as minted_amt,\n  sum(gas) as minted_gas,\n  sum(sum(amt)) over (\n    order by\n      block_hour\n  ) as total_minted_amt,\n  sum(sum(gas)) over (\n    order by\n      block_hour\n  ) as total_minted_gas,\n  cast(\n    sum(sum(amt)) over (\n      order by\n        block_hour\n    ) as double\n  ) / 10000000000 as minted_per\nfrom\n  raw_tx\ngroup by\n  block_hour\norder by\n  block_hour desc"
}