burn to draw transactions copy

Updated 2024-09-13

-- forked from themolt / burn to draw transactions @ https://flipsidecrypto.xyz/themolt/q/62JDcBE_5Z4i/burn-to-draw-transactions

select

--from_address,

date_trunc('day', block_timestamp) AS time,

COUNT(*) BurnToDraw,

max(block_timestamp) lastbtd

from

blast.core.fact_transactions

where

to_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828' --and tx_hash = '0x81c5cf0b7e797920b4ce2f90dc0b8cc3e8a6b84a7add660b6e7b69d5ce4afa11'

and ORIGIN_FUNCTION_SIGNATURE = '0x8094cee4' --burntodraw

--and time >= date_trunc('day', current_timestamp - interval '3 months')

-- and from_address = '0x31f849d0f4c2f5c7f2e7db0aad859203e4e93bc6'

--and block_timestamp > '2024-06-03 00:00:00.000' --exclude early test

and block_timestamp > '2024-07-01 00:00:00.000' --post tge

group by

order by

2 desc

QueryRunArchived: QueryRun has been archived