Using Aggregate function to calculate Median of data based on certain condition

Just saw this video ...

It's very useful for stock/index fluctuation estimation.