flyingfishUSDC.e received
Updated 2023-10-10
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
›
⌄
⌄
/* with open_pear AS (
SELECT
origin_from_address
, origin_to_address
, event_name
, decoded_log:account pear_new_account
, decoded_log:amountIn / pow(10, 6) AS collateral
, decoded_log:sizeDelta / pow(10, 30) AS open_size
, round(open_size / collateral, 2) AS leverage
, decoded_log:isLong::boolean AS isLong
, decoded_log:indexToken AS indexToken
, decoded_log
, tx_hash
FROM arbitrum.core.ez_decoded_event_logs
WHERE block_timestamp::date = '2023-10-04'
AND origin_to_address = '0x75f688604a58c720e7e4496139765498a2563c78' -- Pear Contract Address
-- AND contract_address = lower('0x75f688604a58c720e7e4496139765498a2563c78')
-- AND tx_hash = '0x9c591e61ea9678dbddc5f5a3c50dee169b81d37417f0f222f028e172fd8efd80'
AND event_name = 'CreateIncreasePosition'
AND tx_status = 'SUCCESS'
AND NOT event_removed
)
*/
with close_events AS (
SELECT
origin_from_address -- user
, decoded_log:receiver -- should be the user
, decoded_log:account AS pear_new_account -- the pear account created when opening the position
, event_name
, decoded_log:sizeDelta / pow(10, 30) as close_size
, decoded_log:isLong::boolean AS isLong
, decoded_log:indexToken AS index_token
, decoded_log
, tx_hash
FROM arbitrum.core.ez_decoded_event_logs
Run a query to Download Data