I saw this posting on stack overflow: How to get Historical Price from a specific time?
The second answer had this:
=ARRAYFORMULA(QUERY(GOOGLEFINANCE("GOOG","price","12/22/2020",30,1), "SELECT * WHERE Col1 matches '.* 13:.*|.* 16:.*'", 0))
and this
=ARRAYFORMULA(QUERY(GOOGLEFINANCE("GOOG","price","12/22/2020",30,1), "SELECT * WHERE Col1 matches '.* 13:.*'", 0))
I don't understand these formulas. What does the ""SELECT * WHERE Col1 matches '.* 13:.*'", 0))" section mean?
The second answer had this:
=ARRAYFORMULA(QUERY(GOOGLEFINANCE("GOOG","price","12/22/2020",30,1), "SELECT * WHERE Col1 matches '.* 13:.*|.* 16:.*'", 0))
and this
=ARRAYFORMULA(QUERY(GOOGLEFINANCE("GOOG","price","12/22/2020",30,1), "SELECT * WHERE Col1 matches '.* 13:.*'", 0))
I don't understand these formulas. What does the ""SELECT * WHERE Col1 matches '.* 13:.*'", 0))" section mean?