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')

origin_from_address as "User Address",

-- count(distinct case when type = 'Deposit' then tx_hash end) as deposit_txs,

-- count(distinct case when type = 'Withdrawal' then tx_hash end) as withdrawal_txs,

round(sum(case when type = 'Deposit' then token_amount else 0 end), 2) as deposit,

round(sum(case when type = 'Withdrawal' then token_amount else 0 end), 2) as withdraw,

deposit - withdraw as net_volume,

round(100 * RATIO_TO_REPORT(net_volume) OVER (), 2) || '%' AS percent_holding,

min(block_timestamp) as "First Deposit TX"