Build PoC for byte data extraction

[viniabussafi]

No description provided.

[viniabussafi]

SELECT
contract_address,
evt_tx_hash,
varbinary_to_int256(BYTEARRAY_SUBSTRING(feeCache,1, 8)) AS unused,
varbinary_to_int256(BYTEARRAY_SUBSTRING(feeCache, 9, 16)) AS aum_fee,
varbinary_to_int256(BYTEARRAY_SUBSTRING(feeCache, 17, 24)) AS yield_fee,
varbinary_to_int256(BYTEARRAY_SUBSTRING(feeCache, 25, 32)) AS swap_fee
FROM defi_polygon.ManagedPool_evt_ProtocolFeePercentageCacheUpdated

[viniabussafi]

For 1x10ˆ18 balances

SELECT
varbinary_to_int256(BYTEARRAY_SUBSTRING(0x0000000000000000016345785d8a00000000000000000000016345785d8a0000
,1, 16)) AS underlying_balance,
varbinary_to_int256(BYTEARRAY_SUBSTRING(0x0000000000000000016345785d8a00000000000000000000016345785d8a0000
, 17, 32))
AS wrapped_balance

underlying_balance	wrapped_balance
100000000000000000	100000000000000000

For 1x10ˆ6 balances

SELECT
varbinary_to_int256(BYTEARRAY_SUBSTRING(0x000000000000000000000000000f4240000000000000000000000000000f4240
,1, 16)) AS underlying_balance,
varbinary_to_int256(BYTEARRAY_SUBSTRING(0x000000000000000000000000000f4240000000000000000000000000000f4240
, 17, 32))
AS wrapped_balance

underlying_balance	wrapped_balance
1000000	1000000

[viniabussafi]

all seems to work, will keep dealing with it on the specific buffer issues