No Data to Display
flyingfishOpen DCA orders
Updated 2024-12-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
›
⌄
select
value:id as id
, value:createdAt as createdAt
, value:status as status
, value:userClosed as userClosed
, t_in.symbol as symbol_in
, t_out.symbol as symbol_out
, value:inputMint as inputMint
, value:outputMint as outputMint
, value:inDeposited as inDeposited
, value:outWithdrawn as outWithdrawn
, value:inAmountPerCycle as inAmountPerCycle
, value:inWithdrawn as inWithdrawn
, value:unfilledAmount as unfilledAmount
, value:cycleFrequency as cycleFrequency
, value:userKey as userKey
, value:dcaKey as dcaKey
, value:openTxHash as openTxHash
, value:closeTxHash as closeTxHash
from (
select
value
from (
select
live.udf_api('https://dca-api.jup.ag/user/{{user_address}}/dca?status=0&limit={{records_count}}') as resp
)
, lateral flatten (input => resp:data:data:dcaAccounts)
)
left join solana.price.ez_asset_metadata t_in on inputMint = t_in.token_address
left join solana.price.ez_asset_metadata t_out on outputMint = t_out.token_address
Last run: 2 months ago
0
2B
3s