PREVIEW / stock_5min / 2005-09-22
file: by_date/stock_5min/2005/2005-09-22.parquet size: 2.8 MB rows: 206,238 symbols: 2,078
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-22 08:00:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8536 | 1.8536 | 30800.0 |
| 2005-09-22 08:05:00 | AAPL | Stock | 1.8532 | 1.8532 | 1.8443 | 1.8482 | 173600.0 |
| 2005-09-22 08:10:00 | AAPL | Stock | 1.8475 | 1.8525 | 1.8471 | 1.8525 | 49280.0 |
| 2005-09-22 08:15:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 30800.0 |
| 2005-09-22 08:20:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 12600.0 |
| 2005-09-22 08:25:00 | AAPL | Stock | 1.8511 | 1.8518 | 1.8511 | 1.8518 | 37800.0 |
| 2005-09-22 08:35:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8518 | 1.8518 | 29400.0 |
| 2005-09-22 08:40:00 | AAPL | Stock | 1.8518 | 1.8571 | 1.8518 | 1.8571 | 97720.0 |
| 2005-09-22 08:50:00 | AAPL | Stock | 1.8536 | 1.8604 | 1.8536 | 1.8604 | 33600.0 |
| 2005-09-22 08:55:00 | AAPL | Stock | 1.8604 | 1.8604 | 1.8604 | 1.8604 | 16800.0 |
| 2005-09-22 09:00:00 | AAPL | Stock | 1.8539 | 1.8539 | 1.8539 | 1.8539 | 17780.0 |
| 2005-09-22 09:05:00 | AAPL | Stock | 1.8589 | 1.8589 | 1.8589 | 1.8589 | 14000.0 |
| 2005-09-22 09:10:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 28000.0 |
| 2005-09-22 09:15:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8571 | 1.8571 | 8400.0 |
| 2005-09-22 09:20:00 | AAPL | Stock | 1.8554 | 1.8554 | 1.8554 | 1.8554 | 16800.0 |
| 2005-09-22 09:25:00 | AAPL | Stock | 1.8571 | 1.8571 | 1.8521 | 1.8546 | 1788892.0 |
| 2005-09-22 09:30:00 | AAPL | Stock | 1.8529 | 1.8571 | 1.85 | 1.8546 | 14266308.0 |
| 2005-09-22 09:35:00 | AAPL | Stock | 1.8539 | 1.8561 | 1.8511 | 1.8532 | 8271676.0 |
| 2005-09-22 09:40:00 | AAPL | Stock | 1.8532 | 1.8536 | 1.8329 | 1.8382 | 18350444.0 |
| 2005-09-22 09:45:00 | AAPL | Stock | 1.8375 | 1.8479 | 1.8375 | 1.8425 | 8867236.0 |
| 2005-09-22 09:50:00 | AAPL | Stock | 1.8429 | 1.8554 | 1.84 | 1.8425 | 7832328.0 |
| 2005-09-22 09:55:00 | AAPL | Stock | 1.8425 | 1.8479 | 1.8421 | 1.8475 | 6048532.0 |
| 2005-09-22 10:00:00 | AAPL | Stock | 1.8479 | 1.8654 | 1.8479 | 1.8561 | 13154792.0 |
| 2005-09-22 10:05:00 | AAPL | Stock | 1.8564 | 1.8675 | 1.8557 | 1.8614 | 12522468.0 |
| 2005-09-22 10:10:00 | AAPL | Stock | 1.8614 | 1.8671 | 1.8593 | 1.8625 | 13725656.0 |
| 2005-09-22 10:15:00 | AAPL | Stock | 1.8629 | 1.865 | 1.8625 | 1.8632 | 8399356.0 |
| 2005-09-22 10:20:00 | AAPL | Stock | 1.8629 | 1.8664 | 1.8629 | 1.8639 | 7464268.0 |
| 2005-09-22 10:25:00 | AAPL | Stock | 1.8639 | 1.8664 | 1.8529 | 1.86 | 10008964.0 |
| 2005-09-22 10:30:00 | AAPL | Stock | 1.8596 | 1.8639 | 1.8564 | 1.8607 | 4373908.0 |
| 2005-09-22 10:35:00 | AAPL | Stock | 1.8607 | 1.8646 | 1.86 | 1.8639 | 3906308.0 |
| 2005-09-22 10:40:00 | AAPL | Stock | 1.8639 | 1.8643 | 1.86 | 1.8607 | 4628988.0 |
| 2005-09-22 10:45:00 | AAPL | Stock | 1.8604 | 1.8621 | 1.8586 | 1.8593 | 3857392.0 |
| 2005-09-22 10:50:00 | AAPL | Stock | 1.86 | 1.86 | 1.8511 | 1.8514 | 5349484.0 |
| 2005-09-22 10:55:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8471 | 1.8496 | 6943832.0 |
| 2005-09-22 11:00:00 | AAPL | Stock | 1.85 | 1.8561 | 1.8496 | 1.8525 | 6629308.0 |
| 2005-09-22 11:05:00 | AAPL | Stock | 1.8521 | 1.8543 | 1.8496 | 1.8514 | 11511024.0 |
| 2005-09-22 11:10:00 | AAPL | Stock | 1.8521 | 1.8554 | 1.8521 | 1.8546 | 2922080.0 |
| 2005-09-22 11:15:00 | AAPL | Stock | 1.8539 | 1.8575 | 1.8518 | 1.8561 | 2513140.0 |
| 2005-09-22 11:20:00 | AAPL | Stock | 1.8564 | 1.8568 | 1.8521 | 1.855 | 3045672.0 |
| 2005-09-22 11:25:00 | AAPL | Stock | 1.8554 | 1.8554 | 1.8504 | 1.8525 | 2265704.0 |
| 2005-09-22 11:30:00 | AAPL | Stock | 1.8525 | 1.8532 | 1.8439 | 1.8464 | 6333516.0 |
| 2005-09-22 11:35:00 | AAPL | Stock | 1.8464 | 1.8464 | 1.8421 | 1.8432 | 5196884.0 |
| 2005-09-22 11:40:00 | AAPL | Stock | 1.8432 | 1.8446 | 1.8411 | 1.8439 | 6490260.0 |
| 2005-09-22 11:45:00 | AAPL | Stock | 1.8439 | 1.8479 | 1.8432 | 1.8475 | 3638880.0 |
| 2005-09-22 11:50:00 | AAPL | Stock | 1.8475 | 1.85 | 1.8457 | 1.8461 | 3221484.0 |
| 2005-09-22 11:55:00 | AAPL | Stock | 1.8457 | 1.8504 | 1.8443 | 1.8482 | 3378844.0 |
| 2005-09-22 12:00:00 | AAPL | Stock | 1.8475 | 1.8479 | 1.8429 | 1.8443 | 3504844.0 |
| 2005-09-22 12:05:00 | AAPL | Stock | 1.8443 | 1.8454 | 1.8407 | 1.8418 | 3371844.0 |
| 2005-09-22 12:10:00 | AAPL | Stock | 1.8421 | 1.8429 | 1.8411 | 1.8429 | 2794036.0 |
| 2005-09-22 12:15:00 | AAPL | Stock | 1.8429 | 1.8439 | 1.8421 | 1.8436 | 2004156.0 |
> showing 50 of 206,238 rows — these rows as CSV