PREVIEW / stock_5min / 2005-09-19
file: by_date/stock_5min/2005/2005-09-19.parquet size: 2.8 MB rows: 202,527 symbols: 2,062
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-19 08:00:00 | AAPL | Stock | 1.8282 | 1.8286 | 1.8225 | 1.8286 | 177800.0 |
| 2005-09-19 08:05:00 | AAPL | Stock | 1.8225 | 1.8357 | 1.8225 | 1.8321 | 335300.0 |
| 2005-09-19 08:10:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8332 | 1.8357 | 204400.0 |
| 2005-09-19 08:15:00 | AAPL | Stock | 1.8361 | 1.8361 | 1.8325 | 1.8325 | 28000.0 |
| 2005-09-19 08:20:00 | AAPL | Stock | 1.8325 | 1.8354 | 1.8325 | 1.8354 | 16800.0 |
| 2005-09-19 08:25:00 | AAPL | Stock | 1.8325 | 1.8325 | 1.8321 | 1.8321 | 70000.0 |
| 2005-09-19 08:30:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8304 | 1.8304 | 43372.0 |
| 2005-09-19 08:35:00 | AAPL | Stock | 1.8304 | 1.8304 | 1.8304 | 1.8304 | 26600.0 |
| 2005-09-19 08:40:00 | AAPL | Stock | 1.8293 | 1.8304 | 1.8293 | 1.8304 | 81200.0 |
| 2005-09-19 08:45:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8293 | 1.8293 | 19600.0 |
| 2005-09-19 08:50:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8289 | 1.8289 | 14000.0 |
| 2005-09-19 08:55:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8289 | 1.8289 | 93800.0 |
| 2005-09-19 09:00:00 | AAPL | Stock | 1.8289 | 1.8307 | 1.8289 | 1.8307 | 77000.0 |
| 2005-09-19 09:05:00 | AAPL | Stock | 1.8293 | 1.8311 | 1.8293 | 1.8311 | 177184.0 |
| 2005-09-19 09:10:00 | AAPL | Stock | 1.8311 | 1.8321 | 1.8293 | 1.8293 | 81480.0 |
| 2005-09-19 09:15:00 | AAPL | Stock | 1.8289 | 1.8307 | 1.8289 | 1.8289 | 112000.0 |
| 2005-09-19 09:20:00 | AAPL | Stock | 1.8304 | 1.8321 | 1.8289 | 1.8321 | 51520.0 |
| 2005-09-19 09:25:00 | AAPL | Stock | 1.8289 | 1.8289 | 1.8232 | 1.8236 | 646520.0 |
| 2005-09-19 09:30:00 | AAPL | Stock | 1.8232 | 1.8479 | 1.8232 | 1.8468 | 23134076.0 |
| 2005-09-19 09:35:00 | AAPL | Stock | 1.8471 | 1.86 | 1.845 | 1.8546 | 34089440.0 |
| 2005-09-19 09:40:00 | AAPL | Stock | 1.855 | 1.8561 | 1.8493 | 1.8554 | 18324488.0 |
| 2005-09-19 09:45:00 | AAPL | Stock | 1.8554 | 1.8568 | 1.8446 | 1.8475 | 13424292.0 |
| 2005-09-19 09:50:00 | AAPL | Stock | 1.8471 | 1.8518 | 1.8457 | 1.8493 | 12689068.0 |
| 2005-09-19 09:55:00 | AAPL | Stock | 1.8493 | 1.85 | 1.8425 | 1.8432 | 11781924.0 |
| 2005-09-19 10:00:00 | AAPL | Stock | 1.8432 | 1.8511 | 1.8432 | 1.8457 | 10782128.0 |
| 2005-09-19 10:05:00 | AAPL | Stock | 1.8454 | 1.8489 | 1.8446 | 1.8454 | 11127088.0 |
| 2005-09-19 10:10:00 | AAPL | Stock | 1.845 | 1.8493 | 1.8443 | 1.8482 | 7775852.0 |
| 2005-09-19 10:15:00 | AAPL | Stock | 1.8482 | 1.8554 | 1.8461 | 1.8554 | 12186468.0 |
| 2005-09-19 10:20:00 | AAPL | Stock | 1.8554 | 1.8704 | 1.85 | 1.8661 | 29486212.0 |
| 2005-09-19 10:25:00 | AAPL | Stock | 1.8664 | 1.8696 | 1.8618 | 1.8689 | 17307220.0 |
| 2005-09-19 10:30:00 | AAPL | Stock | 1.8686 | 1.8729 | 1.865 | 1.8675 | 23087540.0 |
| 2005-09-19 10:35:00 | AAPL | Stock | 1.8675 | 1.8771 | 1.8664 | 1.8771 | 17522372.0 |
| 2005-09-19 10:40:00 | AAPL | Stock | 1.8771 | 1.8796 | 1.8725 | 1.8796 | 14898156.0 |
| 2005-09-19 10:45:00 | AAPL | Stock | 1.8796 | 1.8832 | 1.8779 | 1.8782 | 17282720.0 |
| 2005-09-19 10:50:00 | AAPL | Stock | 1.8782 | 1.8829 | 1.8757 | 1.8796 | 12361916.0 |
| 2005-09-19 10:55:00 | AAPL | Stock | 1.8796 | 1.88 | 1.8725 | 1.8736 | 10021928.0 |
| 2005-09-19 11:00:00 | AAPL | Stock | 1.8736 | 1.8789 | 1.8714 | 1.8721 | 10150336.0 |
| 2005-09-19 11:05:00 | AAPL | Stock | 1.8718 | 1.8732 | 1.8693 | 1.8732 | 9955400.0 |
| 2005-09-19 11:10:00 | AAPL | Stock | 1.8732 | 1.8757 | 1.8711 | 1.875 | 8326920.0 |
| 2005-09-19 11:15:00 | AAPL | Stock | 1.8757 | 1.8793 | 1.8732 | 1.8736 | 6860952.0 |
| 2005-09-19 11:20:00 | AAPL | Stock | 1.8736 | 1.8789 | 1.8725 | 1.8786 | 5566064.0 |
| 2005-09-19 11:25:00 | AAPL | Stock | 1.8786 | 1.8807 | 1.875 | 1.8771 | 7590576.0 |
| 2005-09-19 11:30:00 | AAPL | Stock | 1.8761 | 1.8789 | 1.8739 | 1.8779 | 4954600.0 |
| 2005-09-19 11:35:00 | AAPL | Stock | 1.8779 | 1.8782 | 1.8707 | 1.8746 | 10431792.0 |
| 2005-09-19 11:40:00 | AAPL | Stock | 1.8746 | 1.8771 | 1.8739 | 1.8739 | 3577980.0 |
| 2005-09-19 11:45:00 | AAPL | Stock | 1.8743 | 1.8754 | 1.8729 | 1.8732 | 3946880.0 |
| 2005-09-19 11:50:00 | AAPL | Stock | 1.8729 | 1.8739 | 1.8714 | 1.8732 | 5146260.0 |
| 2005-09-19 11:55:00 | AAPL | Stock | 1.8732 | 1.8736 | 1.8704 | 1.8725 | 3778544.0 |
| 2005-09-19 12:00:00 | AAPL | Stock | 1.8725 | 1.8732 | 1.8704 | 1.8707 | 2822260.0 |
| 2005-09-19 12:05:00 | AAPL | Stock | 1.8707 | 1.8736 | 1.8707 | 1.8736 | 2453136.0 |
> showing 50 of 202,527 rows — these rows as CSV