with pear_opens AS (

-- get all tx initiated from the Pear app

-- contract address = '0x75f688604a58c720e7e4496139765498a2563c78'

SELECT

block_timestamp AS request_timestamp

, origin_from_address

, decoded_log:indexToken AS index_token

-- , name

-- , symbol

, origin_function_signature

, decoded_log:amountIn / pow(10, 6) AS request_collateral

, decoded_log:isLong::boolean AS is_long

, decoded_log:account AS new_pear_account

, tx_hash AS request_tx_hash

, decoded_log AS request_decoded_log

FROM arbitrum.core.ez_decoded_event_logs

-- LEFT JOIN arbitrum.core.dim_contracts on index_token = address

WHERE 1 = 1

--AND block_timestamp::date >= '2023-09-30' -- first Pear trade date

AND block_timestamp > '2023-11-26' -- first v0.5.1 trade

--AND origin_to_address = '0x75f688604a58c720e7e4496139765498a2563c78' -- Pear Contract Address