PREVIEW / stock_5min / 2007-12-12
file: by_date/stock_5min/2007/2007-12-12.parquet size: 4.5 MB rows: 323,609 symbols: 3,245
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-12 04:15:00 | AAPL | Stock | 6.7568 | 6.7675 | 6.7568 | 6.7675 | 14000.0 |
| 2007-12-12 04:40:00 | AAPL | Stock | 6.7704 | 6.7704 | 6.7704 | 6.7704 | 5600.0 |
| 2007-12-12 04:45:00 | AAPL | Stock | 6.7704 | 6.7704 | 6.7704 | 6.7704 | 2800.0 |
| 2007-12-12 05:00:00 | AAPL | Stock | 6.7725 | 6.7725 | 6.7725 | 6.7725 | 2800.0 |
| 2007-12-12 05:10:00 | AAPL | Stock | 6.7854 | 6.7854 | 6.7854 | 6.7854 | 42000.0 |
| 2007-12-12 05:25:00 | AAPL | Stock | 6.7825 | 6.7825 | 6.7786 | 6.7786 | 11200.0 |
| 2007-12-12 05:35:00 | AAPL | Stock | 6.8 | 6.8 | 6.8 | 6.8 | 22400.0 |
| 2007-12-12 05:45:00 | AAPL | Stock | 6.7968 | 6.7968 | 6.7968 | 6.7968 | 2800.0 |
| 2007-12-12 05:50:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7929 | 6.7929 | 2800.0 |
| 2007-12-12 06:00:00 | AAPL | Stock | 6.7929 | 6.8 | 6.7929 | 6.8 | 11200.0 |
| 2007-12-12 06:35:00 | AAPL | Stock | 6.8121 | 6.8121 | 6.8121 | 6.8121 | 14000.0 |
| 2007-12-12 06:45:00 | AAPL | Stock | 6.8121 | 6.8121 | 6.8121 | 6.8121 | 28000.0 |
| 2007-12-12 06:55:00 | AAPL | Stock | 6.8161 | 6.8161 | 6.8161 | 6.8161 | 14000.0 |
| 2007-12-12 07:00:00 | AAPL | Stock | 6.8204 | 6.8557 | 6.8204 | 6.8214 | 294476.0 |
| 2007-12-12 07:05:00 | AAPL | Stock | 6.8214 | 6.8304 | 6.7789 | 6.7789 | 78400.0 |
| 2007-12-12 07:10:00 | AAPL | Stock | 6.8007 | 6.8007 | 6.8 | 6.8 | 28000.0 |
| 2007-12-12 07:15:00 | AAPL | Stock | 6.8139 | 6.8139 | 6.8036 | 6.8036 | 5600.0 |
| 2007-12-12 07:20:00 | AAPL | Stock | 6.8089 | 6.8089 | 6.8 | 6.8 | 46200.0 |
| 2007-12-12 07:25:00 | AAPL | Stock | 6.8064 | 6.8064 | 6.8064 | 6.8064 | 2800.0 |
| 2007-12-12 07:30:00 | AAPL | Stock | 6.8064 | 6.8071 | 6.8018 | 6.8018 | 33600.0 |
| 2007-12-12 07:35:00 | AAPL | Stock | 6.8 | 6.8179 | 6.7968 | 6.8132 | 88200.0 |
| 2007-12-12 07:40:00 | AAPL | Stock | 6.8175 | 6.8239 | 6.8175 | 6.8236 | 87360.0 |
| 2007-12-12 07:45:00 | AAPL | Stock | 6.8232 | 6.8454 | 6.8179 | 6.825 | 455672.0 |
| 2007-12-12 07:50:00 | AAPL | Stock | 6.825 | 6.8357 | 6.825 | 6.8339 | 61880.0 |
| 2007-12-12 07:55:00 | AAPL | Stock | 6.8389 | 6.8393 | 6.825 | 6.8339 | 348572.0 |
| 2007-12-12 08:00:00 | AAPL | Stock | 6.8321 | 6.8411 | 6.8214 | 6.825 | 1851416.0 |
| 2007-12-12 08:05:00 | AAPL | Stock | 6.8221 | 6.835 | 6.8107 | 6.825 | 1504272.0 |
| 2007-12-12 08:10:00 | AAPL | Stock | 6.8289 | 6.8329 | 6.8143 | 6.8143 | 1549212.0 |
| 2007-12-12 08:15:00 | AAPL | Stock | 6.8179 | 6.8268 | 6.8104 | 6.8143 | 790664.0 |
| 2007-12-12 08:20:00 | AAPL | Stock | 6.8146 | 6.8211 | 6.8143 | 6.8168 | 772716.0 |
| 2007-12-12 08:25:00 | AAPL | Stock | 6.8154 | 6.8179 | 6.8071 | 6.8179 | 802788.0 |
| 2007-12-12 08:30:00 | AAPL | Stock | 6.8179 | 6.8186 | 6.8071 | 6.8143 | 819672.0 |
| 2007-12-12 08:35:00 | AAPL | Stock | 6.8161 | 6.8179 | 6.8143 | 6.8161 | 366380.0 |
| 2007-12-12 08:40:00 | AAPL | Stock | 6.8175 | 6.8229 | 6.8143 | 6.8229 | 570584.0 |
| 2007-12-12 08:45:00 | AAPL | Stock | 6.8204 | 6.8232 | 6.8161 | 6.8196 | 311864.0 |
| 2007-12-12 08:50:00 | AAPL | Stock | 6.8196 | 6.8236 | 6.8179 | 6.8214 | 286160.0 |
| 2007-12-12 08:55:00 | AAPL | Stock | 6.8239 | 6.8243 | 6.8179 | 6.8179 | 409052.0 |
| 2007-12-12 09:00:00 | AAPL | Stock | 6.8193 | 6.8982 | 6.8193 | 6.8804 | 7779156.0 |
| 2007-12-12 09:05:00 | AAPL | Stock | 6.8786 | 6.8982 | 6.875 | 6.8921 | 3302180.0 |
| 2007-12-12 09:10:00 | AAPL | Stock | 6.8904 | 6.9075 | 6.8846 | 6.8932 | 2686936.0 |
| 2007-12-12 09:15:00 | AAPL | Stock | 6.8932 | 6.9111 | 6.8868 | 6.9093 | 2554300.0 |
| 2007-12-12 09:20:00 | AAPL | Stock | 6.9089 | 6.9179 | 6.9 | 6.9168 | 2036720.0 |
| 2007-12-12 09:25:00 | AAPL | Stock | 6.9164 | 6.9232 | 6.8971 | 6.9093 | 4637808.0 |
| 2007-12-12 09:30:00 | AAPL | Stock | 6.9086 | 6.935 | 6.8889 | 6.9346 | 47750696.0 |
| 2007-12-12 09:35:00 | AAPL | Stock | 6.9346 | 6.9379 | 6.9071 | 6.9132 | 33099948.0 |
| 2007-12-12 09:40:00 | AAPL | Stock | 6.9132 | 6.9179 | 6.8896 | 6.91 | 25967536.0 |
| 2007-12-12 09:45:00 | AAPL | Stock | 6.9091 | 6.9168 | 6.8875 | 6.9132 | 24504200.0 |
| 2007-12-12 09:50:00 | AAPL | Stock | 6.9132 | 6.9457 | 6.9104 | 6.9257 | 26177844.0 |
| 2007-12-12 09:55:00 | AAPL | Stock | 6.9257 | 6.9371 | 6.9107 | 6.9346 | 16947028.0 |
| 2007-12-12 10:00:00 | AAPL | Stock | 6.9343 | 6.9357 | 6.9139 | 6.9286 | 15025696.0 |
> showing 50 of 323,609 rows — these rows as CSV