flipside

    User Perps Trading History copy
    magindigoUser Perps Trading History copy
    Updated 2025-01-14
    -- 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{{address}}%22%2C%22limit%22%3A{__{trades_count}}%2C%22offset%22%3A0%7D%7D%7D') as resp
    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{{address}}%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,
    Last run: about 2 months ago
    SYMBOL
    TIMESTAMP
    ACTION
    ORDER_TYPE
    DEPOSIT_WITHDRAWAL
    PRICE
    SIZE_USD
    PNL
    FEE_USD
    LIQUIDATION_FEE_USD
    TX_ID
    1
    		sol2024-05-29 17:22:21.732Decrease Long
    Market
    		145996.036395169.819166529166.884543-23815.02146592.665320
    3dJJGh6nxuTCWUPGUKt9tQozW6BqScNeL8aM4P2kdsurawf7iFjMFZFt93JDzhh7kzRPH2GFZK7V3m9oWAw6xorH
    2
    		eth2024-05-27 18:25:29.837Decrease Long
    Market
    		19606.3570443932.105146085.4851237920.0636922042.5126180
    3PiwmuiGNQEzKGykrzQ1DF5H6cS56wFeGqYHpprbMo4PLeAB1szQUFuVsj58MmDRsS2Drs1rmHonKqR46W2Yzq1H
    3
    		eth2024-05-22 00:30:16.053Increase Long
    Market
    		-890.4975573796.93580961.1175740177.4409150
    4FwuuYvD4rNtP3yw2XEkmKhJv2NgCVQhjUmvHtM5PEfHMcNqmHDC1vTdEJzn6ghi1LfXoJbYEeCwnftf6auYQ39n
    4
    		sol2024-05-21 18:06:53.488Increase Long
    Market
    		-176932.89177.822529166.8845430529.1668850
    3zrq9tqXdqvWfeoKhpEHWEbNFJVeowFKQeuaLMHuB8LM8NvCwtgPYrtjiNCGH7ougLNLnqQ29bUoVm1oRPxjNPhK
    5
    		eth2024-05-20 22:22:14.218Increase Long
    Market
    		-13080.8736963649.76762265124.367549065.1243680
    3uEhQ4Lep4WKUxMDQQhLFnC36YSFpG2Zv7QX5jTWbHubAYzKUhs5uDFEJ9Xn3Ei938SjUgT451MPon6L31CCRiqF
    6
    		eth2024-05-20 19:31:47.365Decrease Long
    Trigger
    		12230.037959337591283.7208026626.61809599.8150980
    5Uit6TNuRCapd7qKNxCEArDzjdm8NwuXyJzvyqRxLG2CEz2ER4TdfwZWQJQCrRpK13jget68qJyapqnDFNbZPMnG
    7
    		eth2024-05-20 18:03:21.061Increase Long
    Market
    		-5794.5186833146.57840291283.720802091.2837210
    5v7ZnTSgeEatBt9YaP27XtJuCrySVGUYHaRw2EVRzWzvHT8VjPsFtTjq6gnieuBxdAAWP6Dm732gqwuwHmDabyQF
    8
    		sol2024-05-10 16:12:54.708Decrease Long
    Market
    		94361.301343147.855025276477.9513782653.81573279.1017280
    3oz7DMDUrkW3SRRGkDvopdSSceXyvVPcNaiacgj4dGUx7dJcYnBtLNL4UG7EvtxLghyQ8f6jjqPH17TLSd6biihL
    9
    		sol2024-05-10 16:02:04.675Increase Long
    Market
    		-92263.065293146.449309276477.9513780276.4779520
    3PgcuVqC7iGpU6c7f9Wmy4w9RnFxFjQDmXM7wrnTJ7NR1DjksncTDzxT3itUn6sANfyvfJ9asktjjPbYMxLfqzRS
    10
    		sol2024-05-08 09:09:23.126Decrease Long
    Market
    		92134.249116146.005296812.71946-6301.793918466.6284780
    5uScShHumRgTM7DYw985T4z4fgmUs5b9wfeBHTnYfDGBGYBpefieh1nEWTx7Ap4uDgEDyKkjJUUArLyemtqHp6Yp
    11
    		sol2024-05-08 00:19:57.756Increase Long
    Market
    		-99199.484232149.172156296812.719460296.812720
    5m3mGXuPQKtYhTRAeqfr6dAfgDSFTULBfDVoC3NYWTdbXoNdNQNsnzYLNvVRT42e3j5wS4gxn5dBh2cs82XgrVaB
    12
    		sol2024-05-06 15:08:52.002Decrease Long
    Market
    		101179.94076152.147607220984.17921229180.5920421699.8184840
    5uDeMeBCXMuXYmnGEh6ffrmAjnRgkm7ZvaFP6X1nYKTj2xrQL7FUMXs71T9XzDwkBHRn84kure1yGhiQhuULcKc4
    13
    		sol2024-05-02 00:03:20.980Increase Long
    Market
    		-73920.151382134.400275220984.1792120220.984180
    2zHgnuPivoUE9shmwvBTFJodMBZkgHV9yXKExDr8f8Xifis2aAjAKrVRGca2gS5meS2yy6VU7nQw2Y8kTXEQbK62
    14
    		sol2024-05-01 19:04:31.848Decrease Long
    Market
    		90147.911586133.524423214913.89178319139.852398501.1871480
    4Y85Q9MBMSq3yZnQCKT5GHHdsgRGBTV6CqiKFJgLs19q6fgUobkzuWQ53Dvb8PvVs4KMTztiDrT7UPUDy4GoPB68
    15
    		sol2024-04-30 19:50:32.866Increase Long
    Market
    		-71724.160228122.605402214913.8917830214.9138920
    23eaeHeaFhv1vSFLyQVpon6vtzYrfo3oJgL5jwy6yRy1JtUt8VJm3HSsWo5D2G7TTQt4TGSzhPj6PnPFfPZgFmpP
    16
    		sol2024-03-15 03:16:53.492Decrease Long
    Market
    		878701.142069180.0745441478492.209581144587.032082556.6028160
    51jDiECZqTJTEeiudAiC2CjXAjWvN4XWGpUeEWfhp2a9ZJL7ZLpbUckh3quwaSvDPDKgHrYiDXKdowdKSrA69cUC
    17
    		sol2024-03-14 18:58:46.894Increase Long
    Market
    		-738149.205015164.0331561478492.20958101478.492210
    3s4K8vq2pdeMp6jdV796QcVLTRTF8GayvZ7FCNRVUoq7oMTefgFdpqzn4bgXCX2Xr7ohb6pppTH2nGNaRM9s31CX
    18
    		sol2024-03-13 13:13:43.696Decrease Long
    Market
    		894695.221637153.0682771487637.765269159494.3502269842.2664990
    2ggjqL3osFSG5FJLu5g7jvzHHkg2nGZdv3V36WPRe3xewxcMPhUH7sz3cm4M9m3tzQZ4mqWRxDHSe7xHiVQvpdQs
    19
    		sol2024-03-11 01:41:50.069Increase Long
    Market
    		-746530.775676138.2464391487637.76526901487.6377660
    GybgLERM2E3GDJkxbdtQ76gS1YqTBJJPAyvdaiuy71unqUfPcZsKVXsLnFmzN3u5cH1NhDmk1BSKRzjHrcZzyzt
    20
    		sol2024-03-10 23:24:19.759Decrease Long
    Market
    		844694.872655143.700361440456.378244140071.48361314244.5895790
    5fuH2deLwLXu6eaVn9csf723XKkpugPgz2r5WGs7Fr4EMxv9ZEdsYU5LTdCsAMyjRGZ1FwSr5AXibYTm1ReDJuhZ
    46
    9KB
    24s