Untitled Query

elsinaUntitled Query

Updated 2022-09-22

-- anker_polygon_stakers as (select

-- count(distinct MATIC_FROM_ADDRESS) as total_unique_stakers, count(MATIC_FROM_ADDRESS) as total_staking,

-- count(TX_HASH) , count(distinct TX_HASH) , sum(amount) as total_matic_staked

-- from polygon.core.ez_matic_transfers

-- where matic_to_address = '0x62a509ba95c75cabc7190469025e5abee4eddb2a'

-- and ORIGIN_TO_ADDRESS = '0x62a509ba95c75cabc7190469025e5abee4eddb2a'

-- and ORIGIN_FUNCTION_SIGNATURE = '0x4f6df21a'

-- and BLOCK_TIMESTAMP >= '2022-09-01)'

-- )

-- with lido_stakers as (

-- select

-- count(distinct FROM_ADDRESS) as total_unique_stakers, count(FROM_ADDRESS) as total_staking,

-- count(TX_HASH) , count(distinct TX_HASH) ,

-- sum(amount) as total_matic_staked

-- from ethereum.core.ez_token_transfers

-- where CONTRACT_ADDRESS = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'

-- and ORIGIN_TO_ADDRESS = '0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599'

-- and ORIGIN_FUNCTION_SIGNATURE in ('0xea99c2a6','0xe3dec8fb')

-- and TO_ADDRESS = '0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599'

-- and FROM_ADDRESS != '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

-- and BLOCK_TIMESTAMP > '2022-02-10'

-- ),lido_unstakers as (

-- select

-- count(distinct FROM_ADDRESS) as total_unique_stakers, count(FROM_ADDRESS) as total_staking, count(TX_HASH) , count(distinct TX_HASH) , sum(amount) as total_matic_staked

-- from ethereum.core.ez_token_transfers

-- where

-- ORIGIN_FUNCTION_SIGNATURE not in ('0xea99c2a6','0xe3dec8fb','0x23b872dd')

Run a query to Download Data

flipside

flipside