RamaharFPMMBuy WXDAI token
    Updated 2024-12-20
    With fpmm_txns as (select *
    from gnosis.core.ez_decoded_event_logs
    where
    -- tx_hash IN (
    -- '0xdadc35b46a1e0377b7ab7e31a4425caa771281720101a3ac43086da18118b984',
    -- '0x1f323d5927eb57929114b347c3c056336eb42353a2ea9031e814cc09018727fe',
    -- '0xb4a825232f13394d8503417fff4d5f899117a483cd02a7f2402d83f65a85b20a',)
    CONTRACT_ADDRESS = '0x113d61a74e276c85538d137edc9675c61db4e33c' --FPMM contract address
    ),

    buy_txns as (select
    a.*
    from gnosis.core.ez_decoded_event_logs a
    JOIN fpmm_txns b ON a.tx_hash = b.tx_hash
    where a.event_name = 'FPMMBuy'
    ),

    collateral_token as (select
    a.block_timestamp,
    a.tx_hash,
    a.origin_from_address,
    a.origin_to_address,
    a.tx_status,
    a.decoded_log:"amount" / POW(10, 18) AS collateral_token_amount,
    a.decoded_log:"collateralToken" as collateral_token_address
    from gnosis.core.ez_decoded_event_logs a
    join buy_txns b on a.tx_hash = b.tx_hash
    where a.event_name = 'PositionSplit'
    )

    select
    origin_from_address,
    collateral_token_address,
    sum(collateral_token_amount) as user_collateral_token_amount,
    sum(user_collateral_token_amount) over () as total_collateral_amount
    from collateral_token
    QueryRunArchived: QueryRun has been archived