select
to_varchar(parse_json(parameters [0]) :value) as "from_address",
to_varchar(parse_json(parameters [1]) :value) as "to_address",
timestamp,
(
to_varchar(parse_json(parameters [2]) :value [0] :value) + to_varchar(parse_json(parameters [2]) :value [1] :value) * pow(2, 128)
) / 1e18 as "amount",
tx_hash
from
external.tokenflow_starknet.decoded_events
where
chain_id = 'mainnet'
and name = 'Transfer'
and contract = '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7'
and (
"to_address" = REGEXP_REPLACE('0x393206415f09bd94bfd1645e4a8298a762575e7162fada5124cd2e7e0601d07','0x0+','0x')
or "from_address" = REGEXP_REPLACE('0x393206415f09bd94bfd1645e4a8298a762575e7162fada5124cd2e7e0601d07','0x0+','0x')
)