samUntitled Query
    Updated 2022-08-05
    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