tx_data as (

with

eth_deposits as (

select

block_timestamp,

block_number,

tx_hash,

event_index,

'deposit' as action,

decoded_log:sender as user,

decoded_log:amount as underlying_amount_raw,

null as lst_amount_raw

from ethereum.core.ez_decoded_event_logs

where block_timestamp >= '2020-12-17'

and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

and topics[0] = '0x96a25c8ce0baabc1fdefd93e9ed25d8e092a3332f3aa9a41722b5697231d1d1a'

-- Submitted

),

steth_mints as (

select

block_timestamp,

block_number,

tx_hash,

event_index,

'mint' as action,

decoded_log:to as user,

null as underlying_amount_raw,

decoded_log:value as lst_amount_raw

from ethereum.core.ez_decoded_event_logs

where block_timestamp >= '2020-12-17'

and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and decoded_log:from = '0x0000000000000000000000000000000000000000'