PREVIEW / stock_5min / 2005-09-29
file: by_date/stock_5min/2005/2005-09-29.parquet size: 2.8 MB rows: 203,138 symbols: 2,079
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-29 07:25:00 | AAPL | Stock | 1.8243 | 1.8243 | 1.8243 | 1.8243 | 5600.0 |
| 2005-09-29 07:35:00 | AAPL | Stock | 1.8243 | 1.8243 | 1.8243 | 1.8243 | 2800.0 |
| 2005-09-29 08:00:00 | AAPL | Stock | 1.8268 | 1.8314 | 1.8214 | 1.8214 | 716128.0 |
| 2005-09-29 08:05:00 | AAPL | Stock | 1.8236 | 1.825 | 1.8236 | 1.825 | 30800.0 |
| 2005-09-29 08:10:00 | AAPL | Stock | 1.8264 | 1.8268 | 1.8264 | 1.8268 | 70000.0 |
| 2005-09-29 08:15:00 | AAPL | Stock | 1.8304 | 1.8314 | 1.8304 | 1.8314 | 35000.0 |
| 2005-09-29 08:20:00 | AAPL | Stock | 1.8314 | 1.8314 | 1.8304 | 1.8304 | 37800.0 |
| 2005-09-29 08:25:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 28000.0 |
| 2005-09-29 08:30:00 | AAPL | Stock | 1.8304 | 1.8314 | 1.8293 | 1.8314 | 63000.0 |
| 2005-09-29 08:35:00 | AAPL | Stock | 1.8296 | 1.8304 | 1.8296 | 1.8304 | 105280.0 |
| 2005-09-29 08:40:00 | AAPL | Stock | 1.8307 | 1.8314 | 1.8286 | 1.83 | 92624.0 |
| 2005-09-29 08:45:00 | AAPL | Stock | 1.83 | 1.83 | 1.8286 | 1.8286 | 42000.0 |
| 2005-09-29 08:50:00 | AAPL | Stock | 1.8289 | 1.8307 | 1.8289 | 1.83 | 23240.0 |
| 2005-09-29 08:55:00 | AAPL | Stock | 1.83 | 1.8311 | 1.8289 | 1.8293 | 377720.0 |
| 2005-09-29 09:00:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 5600.0 |
| 2005-09-29 09:05:00 | AAPL | Stock | 1.8286 | 1.8289 | 1.8286 | 1.8286 | 99120.0 |
| 2005-09-29 09:10:00 | AAPL | Stock | 1.8286 | 1.8286 | 1.8286 | 1.8286 | 70000.0 |
| 2005-09-29 09:15:00 | AAPL | Stock | 1.8282 | 1.8286 | 1.8279 | 1.8279 | 72800.0 |
| 2005-09-29 09:20:00 | AAPL | Stock | 1.8282 | 1.8286 | 1.8279 | 1.8286 | 51100.0 |
| 2005-09-29 09:25:00 | AAPL | Stock | 1.8279 | 1.8296 | 1.8268 | 1.8296 | 411040.0 |
| 2005-09-29 09:30:00 | AAPL | Stock | 1.8296 | 1.8375 | 1.8271 | 1.8293 | 20639276.0 |
| 2005-09-29 09:35:00 | AAPL | Stock | 1.8293 | 1.83 | 1.8146 | 1.8246 | 21774564.0 |
| 2005-09-29 09:40:00 | AAPL | Stock | 1.825 | 1.835 | 1.8243 | 1.8254 | 17044636.0 |
| 2005-09-29 09:45:00 | AAPL | Stock | 1.8254 | 1.8321 | 1.8221 | 1.8293 | 13137320.0 |
| 2005-09-29 09:50:00 | AAPL | Stock | 1.8293 | 1.8343 | 1.8289 | 1.8336 | 15067024.0 |
| 2005-09-29 09:55:00 | AAPL | Stock | 1.8336 | 1.8414 | 1.8332 | 1.8364 | 20587280.0 |
| 2005-09-29 10:00:00 | AAPL | Stock | 1.8365 | 1.8464 | 1.8361 | 1.8443 | 18749108.0 |
| 2005-09-29 10:05:00 | AAPL | Stock | 1.8446 | 1.8496 | 1.8393 | 1.8475 | 14385896.0 |
| 2005-09-29 10:10:00 | AAPL | Stock | 1.8475 | 1.8511 | 1.845 | 1.8468 | 10938984.0 |
| 2005-09-29 10:15:00 | AAPL | Stock | 1.8468 | 1.8543 | 1.8464 | 1.8543 | 13873104.0 |
| 2005-09-29 10:20:00 | AAPL | Stock | 1.8539 | 1.8596 | 1.8536 | 1.8579 | 17605644.0 |
| 2005-09-29 10:25:00 | AAPL | Stock | 1.8579 | 1.8657 | 1.8579 | 1.8586 | 17140564.0 |
| 2005-09-29 10:30:00 | AAPL | Stock | 1.8586 | 1.86 | 1.8564 | 1.8582 | 18119724.0 |
| 2005-09-29 10:35:00 | AAPL | Stock | 1.8575 | 1.8621 | 1.8575 | 1.8604 | 8510068.0 |
| 2005-09-29 10:40:00 | AAPL | Stock | 1.8607 | 1.865 | 1.8579 | 1.8622 | 6688416.0 |
| 2005-09-29 10:45:00 | AAPL | Stock | 1.8629 | 1.8639 | 1.8564 | 1.8571 | 6722604.0 |
| 2005-09-29 10:50:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8525 | 1.8532 | 9430232.0 |
| 2005-09-29 10:55:00 | AAPL | Stock | 1.8529 | 1.8557 | 1.8443 | 1.8464 | 13563648.0 |
| 2005-09-29 11:00:00 | AAPL | Stock | 1.8464 | 1.855 | 1.8461 | 1.8546 | 11640748.0 |
| 2005-09-29 11:05:00 | AAPL | Stock | 1.8543 | 1.8543 | 1.8471 | 1.8479 | 8275932.0 |
| 2005-09-29 11:10:00 | AAPL | Stock | 1.8482 | 1.8554 | 1.8471 | 1.8554 | 5703656.0 |
| 2005-09-29 11:15:00 | AAPL | Stock | 1.8554 | 1.8554 | 1.8489 | 1.8536 | 5247732.0 |
| 2005-09-29 11:20:00 | AAPL | Stock | 1.8535 | 1.8539 | 1.8486 | 1.8514 | 7219800.0 |
| 2005-09-29 11:25:00 | AAPL | Stock | 1.8518 | 1.8539 | 1.8507 | 1.8532 | 5481868.0 |
| 2005-09-29 11:30:00 | AAPL | Stock | 1.8536 | 1.8571 | 1.8536 | 1.8557 | 5696712.0 |
| 2005-09-29 11:35:00 | AAPL | Stock | 1.8554 | 1.8564 | 1.8521 | 1.8532 | 5378744.0 |
| 2005-09-29 11:40:00 | AAPL | Stock | 1.8536 | 1.8543 | 1.8493 | 1.85 | 6359892.0 |
| 2005-09-29 11:45:00 | AAPL | Stock | 1.8496 | 1.8579 | 1.8496 | 1.8579 | 4513488.0 |
| 2005-09-29 11:50:00 | AAPL | Stock | 1.8579 | 1.8646 | 1.8571 | 1.8596 | 9474024.0 |
| 2005-09-29 11:55:00 | AAPL | Stock | 1.8596 | 1.8611 | 1.8564 | 1.8575 | 4545016.0 |
> showing 50 of 203,138 rows — these rows as CSV