SELECT origin_from_address AS user

, MIN(block_timestamp)::DATE AS date

FROM ethereum.core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000' -- mint staked ETH

AND contract_address = '0xfe2e637202056d30016725477c5da089ab0a043a'

GROUP BY 1

UNION ALL

SELECT from_address AS user

, MIN(block_timestamp)::DATE AS date

FROM ethereum.core.fact_transactions-- no ha sido siempre con el token aETHc/aETHb

WHERE to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670'--AND input_data IN ('0xeb834a2c', '0x9fa65c56') -- stake and claim aETHb or aETHc

GROUP BY 1

UNION ALL

SELECT origin_from_address AS user

, MIN(block_timestamp)::DATE AS date

FROM ethereum.core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000' -- mint staked ETH

AND contract_address = '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd'

GROUP BY 1

UNION ALL

SELECT origin_from_address AS user

, MIN(block_timestamp)::DATE AS date

FROM ethereum.core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000' -- mint staked ETH

AND origin_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58'--also allows non-liquid staking, but this won't be included

GROUP BY 1

UNION ALL

SELECT origin_from_address AS user

, MIN(block_timestamp)::DATE AS date

FROM ethereum.core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000' -- mint staked ETH

AND contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

GROUP BY 1

UNION ALL

SELECT from_address AS user