( values (lower('0x7507c1dc16935B82698e4C63f2746A2fCf994dF8'),'Wrapped Bera','18'),

(lower('0xd6D83aF58a19Cd14eF3CF6fe848C9A4d21e5727c'),'USDC','6'),

(lower('0x0E4aaF1351de4c0264C5c7056Ef3777b41BD8e03'),'Honey','18'),

(lower('0x05D0dD5135E3eF3aDE32a9eF9Cb06e8D37A6795D'),'USDT','6'),

(lower('0x806Ef538b228844c73E8E692ADCFa8Eb2fCF729c'),'DAI','18'),

(lower('0x286F1C3f0323dB9c91D1E8f45c8DF2d065AB5fae'),'WBTC','8'),

(lower('0x6E1E9896e93F7A71ECB33d4386b49DeeD67a231A'),'WETH','18'),

(lower('0xD08391c5977ebF1a09bB5915908EF5cd95Edb7E0'),'aHoney','18'),

(lower('0x1306D3c36eC7E38dd2c128fBe3097C2C2449af64'),'bHoney','18')

as a (address,token_name, decimal))

,

amount_out as ( select block_timestamp,

tx_hash,

origin_from_address as user_address,

livequery.utils.udf_hex_to_int(data) as amount_out_raw,

contract_address as token_out_address

FROM berachain.testnet.fact_event_logs

where origin_function_signature = '0x0b2f6f3f'

and origin_from_address = '0x' || SUBSTRING(topics[2], 27, 40)

and origin_to_address = '0x21e2c0afd058a89fcf7caf3aea3cb84ae977b73d'

and topics [0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

,

amount_in as (select block_timestamp,

tx_hash,

livequery.utils.udf_hex_to_int(data) as amount_in_raw,

contract_address as token_in_address

FROM berachain.testnet.fact_event_logs

where SUBSTRING(topics[2], 27, 40) = 'ab827b1cc3535a9e549ee387a6e9c3f02f481b49'

and origin_function_signature = '0x0b2f6f3f'

and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef')

,

final as ( select a.block_timestamp::date as day,

a.tx_hash,