Polygon deUSDC Pool Activity

h4wkPolygon deUSDC Pool Activity

Updated 2024-02-14

-- forked from Polygon deUSDC Pool Activity @ https://flipsidecrypto.xyz/edit/queries/b0915419-d81f-45c8-96ce-a16e9d9caae7

-- forked from Arbitrum deUSDC Pool Activity @ https://flipsidecrypto.xyz/edit/queries/725db840-091c-4132-89b4-063b07e5a828

-- forked from arb stable pool @ https://flipsidecrypto.xyz/edit/queries/353c1e89-db1d-443d-9635-0e6f0dc08b93

with base_raw as (

select block_timestamp,

case when from_address = '0x0000000000000000000000000000000000000000' then 'Deposit'

else 'Withdrawal' end as type,

raw_amount_precise::float/1e18 as token_amount,

origin_from_address,

tx_hash

-- count(distinct tx_hash) as tx_count,

-- count(distinct origin_from_address) as user_count,

-- sum(case when from_address = '0x0000000000000000000000000000000000000000' then raw_amount_precise::float/1e18 else 0 end) as deposit_vol,

-- sum(case when to_address = '0x0000000000000000000000000000000000000000' then -raw_amount_precise::float/1e18 else 0 end) as withdrawal_vol,

-- deposit_vol + withdrawal_vol as net_vol,

-- sum(net_vol) over (order by date) as TVL

from polygon.core.fact_token_transfers

where 1 = 1

-- and tx_hash = '0xc3869010f5f9a85ccd3d252c7640f8c937fb5f787118c893687386245dd7d383'

and contract_address = lower('0xDa43Bfd7Ecc6835AA6f1761ced30b986A574c0d2')

and (from_address = '0x0000000000000000000000000000000000000000'

or to_address = '0x0000000000000000000000000000000000000000')

-- group by 1,2

-- order by date desc

)

, base as (

select block_timestamp,

type as action,

-- token,

token_amount,

origin_from_address as user,

tx_hash

from base_raw

-- where user = '0xfbfa52ee3a8c3ca813e9eeb6ab86af17cc1e0118'

Last run: about 1 year ago

...

290

22KB