Query editor
-- Lighter (LIT) Token Buybacks Analysis-- This query tracks LIT token buyback activity on Ethereum-- Buybacks are identified as purchases by the official buyback addressWITH buyback_transfers AS (SELECTdate_trunc('day', evt_block_time) as day,CAST(value AS DOUBLE) / 1e18 as lit_amount,"to" as recipient,"from" as sender,evt_tx_hash as tx_hashFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x232ce3bd40fcd6f80f3d55a522d03f25df784ee2AND evt_block_time >= TIMESTAMP '2023-01-01'AND "to" = 0xYOUR_BUYBACK_ADDRESS_HERE),daily_buybacks AS (SELECTday,SUM(lit_amount) as daily_lit_buybackFROM buyback_transfersGROUP BY day)SELECTday,daily_lit_buyback,SUM(daily_lit_buyback) OVER (ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cumulative_lit_buybackFROM daily_buybacksORDER BY day