Stader Matic/MaticX BPT Mints/Burns

scottincryptoStader Matic/MaticX BPT Mints/Burns

Updated 2022-10-23

-- select

-- block_timestamp

-- , tx_hash

-- , event_inputs:from as tx_from

-- , event_inputs:to as tx_to

-- , event_inputs:value::int as tx_value

-- from polygon.core.fact_event_logs

-- where 1=1

-- and contract_address in (

-- '0xc17636e36398602dd37bb5d1b3a9008c7629005f' --Balancer Matic/MaticX

-- )

-- and event_name = 'Transfer'

-- and (event_inputs:from = '0x0000000000000000000000000000000000000000'

-- or event_inputs:to = '0x0000000000000000000000000000000000000000')

-- and block_timestamp >= '2022-04-28'

-- -- and block_timestamp < '2022-08-20'

-- select

-- *

-- from polygon.core.fact_event_logs

-- where 1=1

-- and tx_hash = '0x2fd546b9579d5950efcfa3643b3d7d3caf7ea4daafe0c886db2cb158e619e146'

-- and block_timestamp

-- select

-- *

-- from polygon.core.fact_event_logs

-- where topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

-- and event_name is null

-- and block_timestamp > '2022-08-04'

-- and block_timestamp < '2022-08-05'

-- select

-- event_name

-- , count(*)

Run a query to Download Data

flipside