samUntitled Query
Updated 2022-08-05Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
substr(input_data, 1, 10) as origin_function_signature,
tokenflow_eth.hextoint(substr(input_data, 11,64)::string), -- 64
tokenflow_eth.hextoint(substr(input_data, 75,64)::string),
tokenflow_eth.hextoint(substr(input_data, 139,64)::string),
tokenflow_eth.hextoint(substr(input_data, 203,64)::string) / 1e30 as position_size,
position_size / 1.02,
tokenflow_eth.hextoint(substr(input_data, 267,64)::string),
tokenflow_eth.hextoint(substr(input_data, 331,64)::string) / 1e30 as price_of_longed_asset_when_enter,
tokenflow_eth.hextoint(substr(input_data, 395,64)::string),
tokenflow_eth.hextoint(substr(input_data, 459,64)::string)
from avalanche.core.fact_transactions
-- where origin_function_signature = '0x332e0382'
where tx_hash = '0x837dfc833bab6670a027e120343e27284012147b542104b6452fada728894f14'
Run a query to Download Data