daphmelUser Perps Trading History copy copy
    Updated 2025-01-30
    -- forked from User Perps Trading History copy @ https://flipsidecrypto.xyz/studio/queries/1821be18-4f19-42dc-b44a-b413a59cb492

    -- forked from flyingfish / User Perps Trading History @ https://flipsidecrypto.xyz/flyingfish/q/J38q8EPtF1c2/user-perps-trading-history

    with get_data as (
    select
    --live.udf_api('https://perp-api.jup.ag/trpc/trades?batch=1&input=%7B%220%22%3A%7B%22json%22%3A%7B%22wallet%22%3A%22{{wallet}}%22%2C%22limit%22%3A{__{trades_count}}%2C%22offset%22%3A0%7D%7D%7D') as resp
    livequery.live.udf_api('https://perp-api.jup.ag/trpc/trades?batch=1&input=%7B%220%22%3A%7B%22json%22%3A%7B%22wallet%22%3A%22{{wallet}}%22%2C%22limit%22%3A10000%2C%22offset%22%3A0%7D%7D%7D') as resp
    )

    , date_filtered as (
    select
    iff('{{full_trade_history}}' = 'Yes', '2023-07-18', '{{start_date}}') as start_date_filter
    , iff('{{full_trade_history}}' = 'Yes', current_date, '{{end_date}}') as end_date_filter

    )

    , parsed_data as (

    select
    value:updatedAt::timestamp as timestamp
    , value:side as side
    , value:requestType as order_type
    , value:requestChange as request_change
    , value:custody as custody
    , value:mint as market
    , value:collateralMint as collateral_mint
    , value:collateralUsd / 1e6 as collateral_usd
    , zeroifnull(value:sizeUsd) / 1e6 as size_usd
    , zeroifnull(value:feeUsd) / 1e6 as fee_usd
    , zeroifnull(value:liquidationFeeUsd) / 1e6 as liquidation_fee_usd
    , value:price / 1e6 as price
    , value:priceSlippage as price_slippage
    , zeroifnull(value:pnlUsd) / 1e6 as pnl
    , value:positionKey as position_key
    , value:txId as tx_id
    Last run: about 1 month ago
    No Data to Display
    0
    2B
    34s