No Data to Display
daphmelUser Perps Trading History copy copy
Updated 2025-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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
0
2B
34s