SELECT count (DISTINCT tx_hash) as "three-clp usdt/busd/usdc redeem transactions"

from polygon.core.fact_token_transfers

where contract_address ='0x17f1ef81707811ea15d9ee7c741179bbe2a63887' -- 3clp contract

and from_address='0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'

and to_address=origin_from_address

and date_trunc (minute ,block_timestamp) between '2023-02-10 15:00:00.000' AND '2023-02-10 16:00:00.000'

),

tbl2 AS

SELECT count (DISTINCT tx_hash) as "P-GYD mint from three-clp usdt/busd/usdc transactions"

from polygon.core.fact_token_transfers

where contract_address ='0x17f1ef81707811ea15d9ee7c741179bbe2a63887'-- 3clp contract

and from_address='0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'

and to_address='0x1e6aff38a1a908b71ad36834895515c9cf3b786b' --3clp vault contract

and date_trunc (minute ,block_timestamp) between '2023-02-10 15:00:00.000' AND '2023-02-10 16:00:00.000'

),

tbl3 AS

SELECT count (DISTINCT tx_hash) as "E-clp tusd/usdc redeem transactions"

from polygon.core.fact_token_transfers

where contract_address ='0x97469e6236bd467cd147065f77752b00efadce8a'-- eclp contract

and from_address='0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'

and to_address=origin_from_address

and date_trunc (minute ,block_timestamp) between '2023-02-10 15:00:00.000' AND '2023-02-10 16:00:00.000'

),

tbl4 AS

SELECT count (DISTINCT tx_hash) as "P-GYD mint from E-clp tusd/usdc transactions"

from polygon.core.fact_token_transfers

where contract_address ='0x97469e6236bd467cd147065f77752b00efadce8a'-- eclp contract

and from_address='0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'

and to_address='0x67d204645f4639abff0a91f45b3236a3d7541829' --eclp vault contract

and date_trunc (minute ,block_timestamp) between '2023-02-10 15:00:00.000' AND '2023-02-10 16:00:00.000'

),