date_trunc('day', block_timestamp) as date,

case when swap_to_mint = 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac' -- MANGO contract

then swap_to_amount end) as mango_buying,

case when swap_from_mint = 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac'

then swap_from_amount end) as mango_selling,

when date < '2022-10-11' then 'before_hacked'

when date = '2022-10-11' then 'hacked'

when date > '2022-10-11' then 'after_hacked'

end period

from solana.core.fact_swaps

where date >= '2022-10-01'

and succeeded = 'TRUE'

and (swap_to_mint = 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac'

or swap_from_mint = 'MangoCzJ36AjZyKwVj3VnYU4GTonjfVEnJmvvWaxLac')

group by date