PREVIEW / stock_30min / 2008-09-03
file: by_date/stock_30min/2008/2008-09-03.parquet size: 1.2 MB rows: 68,368 symbols: 3,290
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2008-09-03 07:30:00 | AAPL | Stock | 5.9496 | 5.9496 | 5.9357 | 5.9371 | 53200.0 |
| 2008-09-03 08:00:00 | AAPL | Stock | 5.9414 | 5.9696 | 5.9393 | 5.9571 | 955108.0 |
| 2008-09-03 08:30:00 | AAPL | Stock | 5.9504 | 5.9679 | 5.9464 | 5.9639 | 1001000.0 |
| 2008-09-03 09:00:00 | AAPL | Stock | 5.9629 | 5.9696 | 5.9471 | 5.9618 | 772492.0 |
| 2008-09-03 09:30:00 | AAPL | Stock | 5.9618 | 5.9989 | 5.9354 | 5.9782 | 87138184.0 |
| 2008-09-03 10:00:00 | AAPL | Stock | 5.9771 | 5.995 | 5.9579 | 5.9739 | 59801364.0 |
| 2008-09-03 10:30:00 | AAPL | Stock | 5.9739 | 6.0243 | 5.965 | 5.9675 | 48140792.0 |
| 2008-09-03 11:00:00 | AAPL | Stock | 5.9671 | 5.9975 | 5.9464 | 5.9511 | 37764132.0 |
| 2008-09-03 11:30:00 | AAPL | Stock | 5.9511 | 5.9539 | 5.8707 | 5.8939 | 66134208.0 |
| 2008-09-03 12:00:00 | AAPL | Stock | 5.8939 | 5.8975 | 5.8571 | 5.8768 | 36532832.0 |
| 2008-09-03 12:30:00 | AAPL | Stock | 5.8786 | 5.9093 | 5.8743 | 5.9029 | 23582636.0 |
| 2008-09-03 13:00:00 | AAPL | Stock | 5.9025 | 6.0007 | 5.8879 | 5.9546 | 48905724.0 |
| 2008-09-03 13:30:00 | AAPL | Stock | 5.9543 | 5.9768 | 5.9293 | 5.9696 | 50849456.0 |
| 2008-09-03 14:00:00 | AAPL | Stock | 5.9704 | 5.9911 | 5.9389 | 5.9496 | 81711336.0 |
| 2008-09-03 14:30:00 | AAPL | Stock | 5.9489 | 5.9789 | 5.9161 | 5.9311 | 51318148.0 |
| 2008-09-03 15:00:00 | AAPL | Stock | 5.9293 | 5.9554 | 5.8932 | 5.9396 | 57146460.0 |
| 2008-09-03 15:30:00 | AAPL | Stock | 5.9393 | 5.9729 | 5.9257 | 5.9607 | 58524648.0 |
| 2008-09-03 16:00:00 | AAPL | Stock | 5.9636 | 5.9864 | 5.9435 | 5.9661 | 14275772.0 |
| 2008-09-03 16:30:00 | AAPL | Stock | 5.9661 | 5.9668 | 5.9629 | 5.9629 | 1612884.0 |
| 2008-09-03 17:00:00 | AAPL | Stock | 5.9643 | 5.9654 | 5.9643 | 5.9643 | 31500.0 |
| 2008-09-03 17:30:00 | AAPL | Stock | 5.9643 | 5.9661 | 5.9629 | 5.9632 | 68488.0 |
| 2008-09-03 18:00:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9632 | 5.9643 | 44856.0 |
| 2008-09-03 18:30:00 | AAPL | Stock | 5.9643 | 5.9729 | 5.9643 | 5.9729 | 47740.0 |
| 2008-09-03 19:00:00 | AAPL | Stock | 5.9732 | 5.9743 | 5.9661 | 5.9743 | 33096.0 |
| 2008-09-03 19:30:00 | AAPL | Stock | 5.9711 | 5.9711 | 5.9711 | 5.9711 | 13972.0 |
| 2008-09-03 06:00:00 | MSFT | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 100.0 |
| 2008-09-03 07:00:00 | MSFT | Stock | 26.86 | 27.0 | 26.86 | 26.87 | 1000.0 |
| 2008-09-03 07:30:00 | MSFT | Stock | 26.8 | 26.8 | 26.79 | 26.8 | 3720.0 |
| 2008-09-03 08:00:00 | MSFT | Stock | 26.88 | 27.1 | 26.86 | 27.1 | 766357.0 |
| 2008-09-03 08:30:00 | MSFT | Stock | 27.0 | 27.03 | 26.93 | 27.03 | 3992.0 |
| 2008-09-03 09:00:00 | MSFT | Stock | 27.0 | 27.05 | 27.0 | 27.0 | 91375.0 |
| 2008-09-03 09:30:00 | MSFT | Stock | 27.0 | 27.07 | 26.89 | 27.0 | 5942533.0 |
| 2008-09-03 10:00:00 | MSFT | Stock | 27.0 | 27.18 | 26.9 | 26.9 | 5675296.0 |
| 2008-09-03 10:30:00 | MSFT | Stock | 26.9 | 27.08 | 26.9 | 26.98 | 3665849.0 |
| 2008-09-03 11:00:00 | MSFT | Stock | 26.99 | 27.04 | 26.89 | 26.96 | 3698007.0 |
| 2008-09-03 11:30:00 | MSFT | Stock | 26.96 | 27.02 | 26.89 | 26.95 | 4967287.0 |
| 2008-09-03 12:00:00 | MSFT | Stock | 26.95 | 26.96 | 26.89 | 26.942 | 3361466.0 |
| 2008-09-03 12:30:00 | MSFT | Stock | 26.942 | 26.95 | 26.9 | 26.91 | 2459330.0 |
| 2008-09-03 13:00:00 | MSFT | Stock | 26.915 | 26.95 | 26.84 | 26.91 | 4228242.0 |
| 2008-09-03 13:30:00 | MSFT | Stock | 26.901 | 27.02 | 26.87 | 26.98 | 3052103.0 |
| 2008-09-03 14:00:00 | MSFT | Stock | 26.99 | 27.08 | 26.88 | 26.96 | 4067779.0 |
| 2008-09-03 14:30:00 | MSFT | Stock | 26.96 | 27.04 | 26.9 | 26.91 | 2538227.0 |
| 2008-09-03 15:00:00 | MSFT | Stock | 26.92 | 27.06 | 26.89 | 26.91 | 4603612.0 |
| 2008-09-03 15:30:00 | MSFT | Stock | 26.91 | 26.95 | 26.88 | 26.93 | 5459789.0 |
| 2008-09-03 16:00:00 | MSFT | Stock | 26.94 | 27.06 | 26.9 | 26.944 | 1581998.0 |
| 2008-09-03 16:30:00 | MSFT | Stock | 26.9 | 26.9 | 26.9 | 26.9 | 578925.0 |
| 2008-09-03 17:30:00 | MSFT | Stock | 26.91 | 26.94 | 26.91 | 26.92 | 747.0 |
| 2008-09-03 18:00:00 | MSFT | Stock | 26.92 | 26.92 | 26.92 | 26.92 | 215.0 |
| 2008-09-03 18:30:00 | MSFT | Stock | 26.93 | 26.93 | 26.93 | 26.93 | 100.0 |
| 2008-09-03 19:00:00 | MSFT | Stock | 26.94 | 26.94 | 26.94 | 26.94 | 320.0 |
> showing 50 of 68,368 rows — these rows as CSV