select

tx.tx_hash

, tx.block_timestamp

, tx.to_address as user

, tx.raw_amount/power(10,18) as lp_amount

-- *

from

-- optimism.core.fact_transactions tx

optimism.core.fact_token_transfers tx

1=1

-- and tx.tx_hash = '0xbf32c6da134f8d3e6b03dc58eecd82351072c2b239273b6375289bb1b1841981'

and tx.from_address= '0x0000000000000000000000000000000000000000'

and tx.contract_address= '0xc899c4d73ed8df2ead1543ab915888b0bf7d57a2'

and tx.block_timestamp >= '{{start_time}}'::date

and tx.block_timestamp < add_months('{{start_time}}', {{duration_in_months}})

) , USDC_LP as (

SELECT

tx.tx_hash

, lp.block_timestamp

, user

, tx.raw_amount/power(10,6) as usdc_amount

, lp_amount

from

optimism.core.fact_token_transfers tx

inner join LP_TXs lp using(tx_hash)

where

1=1

and tx.contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'

and tx.to_address = '0xc899c4d73ed8df2ead1543ab915888b0bf7d57a2'

) , SONNE_LP as (