SELECT DISTINCT(date_trunc('week',date_day)) AS DATE

FROM ethereum.core.dim_dates

WHERE date >= CURRENT_DATE - 90

AND date <= CURRENT_DATE

),

t1 AS (

SELECT DATE_TRUNC('week',BLOCK_TIMESTAMP) AS Dt1,

SUM(RAW_AMOUNT/1e9) AS Amount_to_f,

IFF(ORIGIN_FROM_ADDRESS = FROM_ADDRESS, 'Swap Floor token to another asset', IFF(ORIGIN_FROM_ADDRESS = TO_ADDRESS,'Swap an asset to Floor Token','Router')) AS Swap_status

FROM ethereum.core.fact_token_transfers

WHERE ORIGIN_FUNCTION_SIGNATURE IN ('0x5f575529','0xe449022e','0x7c025200','0xc04b8d59','0x5ae401dc','0x13d79a0b')

AND CONTRACT_ADDRESS = '0xf59257e961883636290411c11ec5ae622d19455e'

AND block_timestamp::date >= CURRENT_DATE - 90

AND Swap_status != 'Router'

AND Swap_status='Swap an asset to Floor Token'

GROUP BY 1,3

),

t11 AS(

SELECT DATE_TRUNC('week',BLOCK_TIMESTAMP) AS Dt11,

SUM(RAW_AMOUNT/1e9) AS Amount_from_f,

IFF(ORIGIN_FROM_ADDRESS = FROM_ADDRESS, 'Swap Floor token to another asset', IFF(ORIGIN_FROM_ADDRESS = TO_ADDRESS,'Swap an asset to Floor Token','Router')) AS Swap_status

FROM ethereum.core.fact_token_transfers

WHERE ORIGIN_FUNCTION_SIGNATURE IN ('0x5f575529','0xe449022e','0x7c025200','0xc04b8d59','0x5ae401dc','0x13d79a0b')

AND CONTRACT_ADDRESS = '0xf59257e961883636290411c11ec5ae622d19455e'

AND block_timestamp::date >= CURRENT_DATE - 90

AND Swap_status != 'Router'

AND Swap_status='Swap Floor token to another asset'

GROUP BY 1,3