PREVIEW / stock_5min / 2009-08-19
file: by_date/stock_5min/2009/2009-08-19.parquet size: 4.5 MB rows: 309,818 symbols: 3,354
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-19 04:30:00 | AAPL | Stock | 5.79 | 5.79 | 5.79 | 5.79 | 14000.0 |
| 2009-08-19 05:20:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 8400.0 |
| 2009-08-19 05:35:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 8400.0 |
| 2009-08-19 06:00:00 | AAPL | Stock | 5.7875 | 5.7875 | 5.7875 | 5.7875 | 2800.0 |
| 2009-08-19 06:05:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 11200.0 |
| 2009-08-19 06:10:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 16800.0 |
| 2009-08-19 06:50:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8107 | 5.8107 | 3360.0 |
| 2009-08-19 07:00:00 | AAPL | Stock | 5.8061 | 5.8107 | 5.8061 | 5.8107 | 29960.0 |
| 2009-08-19 07:10:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.8179 | 5.8179 | 16800.0 |
| 2009-08-19 07:20:00 | AAPL | Stock | 5.8125 | 5.8125 | 5.8075 | 5.8075 | 22400.0 |
| 2009-08-19 07:25:00 | AAPL | Stock | 5.8068 | 5.8068 | 5.8068 | 5.8068 | 2800.0 |
| 2009-08-19 07:35:00 | AAPL | Stock | 5.8 | 5.8 | 5.8 | 5.8 | 14000.0 |
| 2009-08-19 07:40:00 | AAPL | Stock | 5.8036 | 5.8071 | 5.8036 | 5.8071 | 18144.0 |
| 2009-08-19 07:45:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8004 | 5.8004 | 8400.0 |
| 2009-08-19 07:50:00 | AAPL | Stock | 5.8 | 5.8071 | 5.8 | 5.8043 | 196000.0 |
| 2009-08-19 07:55:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 25200.0 |
| 2009-08-19 08:00:00 | AAPL | Stock | 5.8036 | 5.8196 | 5.8036 | 5.8071 | 483476.0 |
| 2009-08-19 08:05:00 | AAPL | Stock | 5.8086 | 5.8111 | 5.8018 | 5.8039 | 264824.0 |
| 2009-08-19 08:10:00 | AAPL | Stock | 5.8043 | 5.8054 | 5.8036 | 5.8036 | 51716.0 |
| 2009-08-19 08:15:00 | AAPL | Stock | 5.8032 | 5.8071 | 5.8029 | 5.8036 | 404096.0 |
| 2009-08-19 08:20:00 | AAPL | Stock | 5.8018 | 5.8036 | 5.8014 | 5.8036 | 295820.0 |
| 2009-08-19 08:25:00 | AAPL | Stock | 5.8018 | 5.8036 | 5.8018 | 5.8018 | 69748.0 |
| 2009-08-19 08:30:00 | AAPL | Stock | 5.8018 | 5.8089 | 5.8018 | 5.8089 | 207984.0 |
| 2009-08-19 08:35:00 | AAPL | Stock | 5.8089 | 5.8089 | 5.805 | 5.8071 | 218120.0 |
| 2009-08-19 08:40:00 | AAPL | Stock | 5.8082 | 5.8096 | 5.8079 | 5.8079 | 46732.0 |
| 2009-08-19 08:45:00 | AAPL | Stock | 5.8093 | 5.8104 | 5.8089 | 5.8104 | 81928.0 |
| 2009-08-19 08:50:00 | AAPL | Stock | 5.81 | 5.8136 | 5.8096 | 5.81 | 118328.0 |
| 2009-08-19 08:55:00 | AAPL | Stock | 5.8096 | 5.8121 | 5.8093 | 5.8121 | 83636.0 |
| 2009-08-19 09:00:00 | AAPL | Stock | 5.8107 | 5.8118 | 5.8107 | 5.8118 | 50400.0 |
| 2009-08-19 09:05:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8093 | 5.8104 | 33600.0 |
| 2009-08-19 09:10:00 | AAPL | Stock | 5.8104 | 5.8111 | 5.8071 | 5.8093 | 238952.0 |
| 2009-08-19 09:15:00 | AAPL | Stock | 5.8089 | 5.8125 | 5.8089 | 5.8125 | 237048.0 |
| 2009-08-19 09:20:00 | AAPL | Stock | 5.8125 | 5.8143 | 5.8107 | 5.8107 | 205800.0 |
| 2009-08-19 09:25:00 | AAPL | Stock | 5.8107 | 5.8179 | 5.8107 | 5.8143 | 422800.0 |
| 2009-08-19 09:30:00 | AAPL | Stock | 5.8125 | 5.8268 | 5.8018 | 5.8161 | 18011392.0 |
| 2009-08-19 09:35:00 | AAPL | Stock | 5.8159 | 5.8214 | 5.8054 | 5.81 | 11236960.0 |
| 2009-08-19 09:40:00 | AAPL | Stock | 5.81 | 5.8357 | 5.81 | 5.8357 | 9635920.0 |
| 2009-08-19 09:45:00 | AAPL | Stock | 5.8354 | 5.8493 | 5.8354 | 5.8407 | 13454980.0 |
| 2009-08-19 09:50:00 | AAPL | Stock | 5.8423 | 5.8529 | 5.8418 | 5.8496 | 7662116.0 |
| 2009-08-19 09:55:00 | AAPL | Stock | 5.8479 | 5.8636 | 5.8479 | 5.8575 | 10550736.0 |
| 2009-08-19 10:00:00 | AAPL | Stock | 5.8586 | 5.8914 | 5.8575 | 5.8871 | 12265736.0 |
| 2009-08-19 10:05:00 | AAPL | Stock | 5.8875 | 5.9036 | 5.8869 | 5.8879 | 14921592.0 |
| 2009-08-19 10:10:00 | AAPL | Stock | 5.8879 | 5.8946 | 5.8793 | 5.8825 | 8177876.0 |
| 2009-08-19 10:15:00 | AAPL | Stock | 5.8821 | 5.8889 | 5.8689 | 5.8693 | 7871668.0 |
| 2009-08-19 10:20:00 | AAPL | Stock | 5.8689 | 5.8768 | 5.8679 | 5.8696 | 5937596.0 |
| 2009-08-19 10:25:00 | AAPL | Stock | 5.8696 | 5.8746 | 5.8657 | 5.8721 | 6260212.0 |
| 2009-08-19 10:30:00 | AAPL | Stock | 5.8721 | 5.8839 | 5.8657 | 5.8707 | 8048684.0 |
| 2009-08-19 10:35:00 | AAPL | Stock | 5.8704 | 5.8829 | 5.8675 | 5.875 | 6233416.0 |
| 2009-08-19 10:40:00 | AAPL | Stock | 5.8757 | 5.8786 | 5.8704 | 5.8775 | 4055016.0 |
| 2009-08-19 10:45:00 | AAPL | Stock | 5.8768 | 5.8774 | 5.8668 | 5.8711 | 4444748.0 |
> showing 50 of 309,818 rows — these rows as CSV