PREVIEW / stock_5min / 2009-08-07
file: by_date/stock_5min/2009/2009-08-07.parquet size: 4.7 MB rows: 325,833 symbols: 3,371
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-07 05:05:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 2800.0 |
| 2009-08-07 05:30:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 8400.0 |
| 2009-08-07 05:45:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 2800.0 |
| 2009-08-07 05:50:00 | AAPL | Stock | 5.7993 | 5.7993 | 5.7993 | 5.7993 | 14000.0 |
| 2009-08-07 06:35:00 | AAPL | Stock | 5.8304 | 5.8304 | 5.8304 | 5.8304 | 5600.0 |
| 2009-08-07 07:30:00 | AAPL | Stock | 5.8304 | 5.8304 | 5.8286 | 5.8286 | 5600.0 |
| 2009-08-07 07:45:00 | AAPL | Stock | 5.8307 | 5.8307 | 5.8307 | 5.8307 | 2800.0 |
| 2009-08-07 07:50:00 | AAPL | Stock | 5.8357 | 5.8386 | 5.8357 | 5.8386 | 42980.0 |
| 2009-08-07 07:55:00 | AAPL | Stock | 5.8429 | 5.8536 | 5.8429 | 5.8536 | 8400.0 |
| 2009-08-07 08:00:00 | AAPL | Stock | 5.8525 | 5.8539 | 5.8436 | 5.8468 | 123760.0 |
| 2009-08-07 08:05:00 | AAPL | Stock | 5.8561 | 5.8654 | 5.8561 | 5.8654 | 38080.0 |
| 2009-08-07 08:10:00 | AAPL | Stock | 5.8571 | 5.8579 | 5.8568 | 5.8571 | 135632.0 |
| 2009-08-07 08:15:00 | AAPL | Stock | 5.8571 | 5.8625 | 5.8571 | 5.8625 | 86800.0 |
| 2009-08-07 08:20:00 | AAPL | Stock | 5.8607 | 5.8661 | 5.8607 | 5.8661 | 39200.0 |
| 2009-08-07 08:25:00 | AAPL | Stock | 5.8746 | 5.875 | 5.8671 | 5.8696 | 251076.0 |
| 2009-08-07 08:30:00 | AAPL | Stock | 5.8746 | 5.9214 | 5.8746 | 5.9154 | 1303876.0 |
| 2009-08-07 08:35:00 | AAPL | Stock | 5.9171 | 5.9179 | 5.9111 | 5.9154 | 270368.0 |
| 2009-08-07 08:40:00 | AAPL | Stock | 5.9179 | 5.9211 | 5.9154 | 5.9164 | 381136.0 |
| 2009-08-07 08:45:00 | AAPL | Stock | 5.9164 | 5.9171 | 5.9114 | 5.9125 | 123760.0 |
| 2009-08-07 08:50:00 | AAPL | Stock | 5.9139 | 5.9214 | 5.9139 | 5.9182 | 424816.0 |
| 2009-08-07 08:55:00 | AAPL | Stock | 5.9207 | 5.9214 | 5.9125 | 5.9143 | 108080.0 |
| 2009-08-07 09:00:00 | AAPL | Stock | 5.9136 | 5.9161 | 5.9089 | 5.9146 | 364560.0 |
| 2009-08-07 09:05:00 | AAPL | Stock | 5.9129 | 5.9229 | 5.9129 | 5.9229 | 284368.0 |
| 2009-08-07 09:10:00 | AAPL | Stock | 5.9225 | 5.9246 | 5.9186 | 5.9186 | 115080.0 |
| 2009-08-07 09:15:00 | AAPL | Stock | 5.9214 | 5.9221 | 5.9136 | 5.9182 | 204064.0 |
| 2009-08-07 09:20:00 | AAPL | Stock | 5.9179 | 5.9196 | 5.9161 | 5.9196 | 170100.0 |
| 2009-08-07 09:25:00 | AAPL | Stock | 5.9114 | 5.9139 | 5.9018 | 5.9075 | 122472.0 |
| 2009-08-07 09:30:00 | AAPL | Stock | 5.9079 | 5.9304 | 5.9061 | 5.9204 | 13990676.0 |
| 2009-08-07 09:35:00 | AAPL | Stock | 5.9211 | 5.9268 | 5.9004 | 5.905 | 11680228.0 |
| 2009-08-07 09:40:00 | AAPL | Stock | 5.9039 | 5.9114 | 5.8943 | 5.8971 | 8068088.0 |
| 2009-08-07 09:45:00 | AAPL | Stock | 5.8971 | 5.9068 | 5.8864 | 5.9016 | 7910308.0 |
| 2009-08-07 09:50:00 | AAPL | Stock | 5.9011 | 5.9107 | 5.8964 | 5.9086 | 6576780.0 |
| 2009-08-07 09:55:00 | AAPL | Stock | 5.9089 | 5.9261 | 5.9036 | 5.9036 | 9939720.0 |
| 2009-08-07 10:00:00 | AAPL | Stock | 5.9036 | 5.9104 | 5.8986 | 5.9014 | 6961360.0 |
| 2009-08-07 10:05:00 | AAPL | Stock | 5.9014 | 5.9025 | 5.8857 | 5.9011 | 7176428.0 |
| 2009-08-07 10:10:00 | AAPL | Stock | 5.9011 | 5.9143 | 5.8982 | 5.9054 | 8824620.0 |
| 2009-08-07 10:15:00 | AAPL | Stock | 5.9046 | 5.9161 | 5.9039 | 5.9107 | 4298224.0 |
| 2009-08-07 10:20:00 | AAPL | Stock | 5.9104 | 5.9136 | 5.9004 | 5.9054 | 4909632.0 |
| 2009-08-07 10:25:00 | AAPL | Stock | 5.9054 | 5.91 | 5.8996 | 5.9089 | 4791500.0 |
| 2009-08-07 10:30:00 | AAPL | Stock | 5.9096 | 5.9218 | 5.9089 | 5.9143 | 7056168.0 |
| 2009-08-07 10:35:00 | AAPL | Stock | 5.915 | 5.9271 | 5.9121 | 5.9239 | 6686820.0 |
| 2009-08-07 10:40:00 | AAPL | Stock | 5.925 | 5.9254 | 5.9175 | 5.9232 | 4604936.0 |
| 2009-08-07 10:45:00 | AAPL | Stock | 5.9232 | 5.9368 | 5.9225 | 5.9261 | 8290352.0 |
| 2009-08-07 10:50:00 | AAPL | Stock | 5.9267 | 5.9304 | 5.9254 | 5.9279 | 3319904.0 |
| 2009-08-07 10:55:00 | AAPL | Stock | 5.9279 | 5.935 | 5.9236 | 5.9311 | 4831848.0 |
| 2009-08-07 11:00:00 | AAPL | Stock | 5.9318 | 5.9357 | 5.9268 | 5.9354 | 3897012.0 |
| 2009-08-07 11:05:00 | AAPL | Stock | 5.9357 | 5.9357 | 5.9207 | 5.9218 | 5116188.0 |
| 2009-08-07 11:10:00 | AAPL | Stock | 5.9211 | 5.9243 | 5.9175 | 5.9234 | 2963716.0 |
| 2009-08-07 11:15:00 | AAPL | Stock | 5.923 | 5.9257 | 5.9214 | 5.9246 | 3076892.0 |
| 2009-08-07 11:20:00 | AAPL | Stock | 5.9238 | 5.9307 | 5.9204 | 5.9286 | 3494708.0 |
> showing 50 of 325,833 rows — these rows as CSV