SELECT LIQUIDITY_PROVIDER_ADDRESS AS "USER", BLOCK_TIMESTAMP AS "Date", TX_ID, 'lp' AS activity, (AMOUNT/pow(10, 6)) AS amounttt

FROM osmosis.core.fact_liquidity_provider_actions

WHERE CURRENCY = 'uosmo' AND "ACTION" = 'pool_joined' AND TX_STATUS = 'SUCCEEDED'

UNION ALL

SELECT TRADER AS "USER", BLOCK_TIMESTAMP AS "Date", TX_ID, 'swap' AS activity, (FROM_AMOUNT/pow(10, 6)) AS amounttt

FROM osmosis.core.fact_swaps

WHERE FROM_CURRENCY = 'uosmo'

),

alll AS

SELECT *

FROM sw_lps

UNION ALL

SELECT DELEGATOR_ADDRESS AS "USER", BLOCK_TIMESTAMP AS "Date", TX_ID, 'REstaking' AS activity, (AMOUNT/pow(10, 6)) AS amounttt

FROM osmosis.core.fact_staking

WHERE TX_STATUS = 'SUCCEEDED'

),

sw_lp AS

SELECT *

FROM alll

ORDER BY "Date", "USER"

),

us AS

SELECT COMPLETION_TIME AS "time", TX_CALLER_ADDRESS AS "USER", TX_ID

FROM osmosis.core.fact_staking

WHERE "ACTION" = 'undelegate'

ORDER BY 1