PREVIEW / stock_5min / 2007-09-11
file: by_date/stock_5min/2007/2007-09-11.parquet size: 3.9 MB rows: 293,043 symbols: 3,125
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-09-11 09:30:00 | AAPL | Stock | 4.925 | 4.9393 | 4.89 | 4.89 | 31168928.0 |
| 2007-09-11 09:35:00 | AAPL | Stock | 4.89 | 4.8936 | 4.8436 | 4.8668 | 37020116.0 |
| 2007-09-11 09:40:00 | AAPL | Stock | 4.8668 | 4.8996 | 4.8661 | 4.8779 | 25476808.0 |
| 2007-09-11 09:45:00 | AAPL | Stock | 4.8768 | 4.8804 | 4.8482 | 4.8571 | 30083004.0 |
| 2007-09-11 09:50:00 | AAPL | Stock | 4.8571 | 4.8693 | 4.8421 | 4.8446 | 19120304.0 |
| 2007-09-11 09:55:00 | AAPL | Stock | 4.8446 | 4.8714 | 4.8446 | 4.8564 | 16941596.0 |
| 2007-09-11 10:00:00 | AAPL | Stock | 4.8568 | 4.8643 | 4.8436 | 4.8486 | 15002148.0 |
| 2007-09-11 10:05:00 | AAPL | Stock | 4.8489 | 4.8546 | 4.8368 | 4.8439 | 20589352.0 |
| 2007-09-11 10:10:00 | AAPL | Stock | 4.8439 | 4.8596 | 4.8357 | 4.8579 | 18742808.0 |
| 2007-09-11 10:15:00 | AAPL | Stock | 4.8571 | 4.8679 | 4.8514 | 4.8618 | 15118768.0 |
| 2007-09-11 10:20:00 | AAPL | Stock | 4.8625 | 4.8689 | 4.8575 | 4.8579 | 11280192.0 |
| 2007-09-11 10:25:00 | AAPL | Stock | 4.8575 | 4.8754 | 4.8575 | 4.8714 | 17337124.0 |
| 2007-09-11 10:30:00 | AAPL | Stock | 4.87 | 4.8725 | 4.8618 | 4.865 | 8051400.0 |
| 2007-09-11 10:35:00 | AAPL | Stock | 4.8646 | 4.8661 | 4.8511 | 4.8529 | 12065452.0 |
| 2007-09-11 10:40:00 | AAPL | Stock | 4.8536 | 4.8571 | 4.8464 | 4.8504 | 10040156.0 |
| 2007-09-11 10:45:00 | AAPL | Stock | 4.85 | 4.8554 | 4.8414 | 4.8464 | 11020464.0 |
| 2007-09-11 10:50:00 | AAPL | Stock | 4.8457 | 4.8496 | 4.8368 | 4.8432 | 10417904.0 |
| 2007-09-11 10:55:00 | AAPL | Stock | 4.8436 | 4.8489 | 4.8421 | 4.8454 | 6493900.0 |
| 2007-09-11 11:00:00 | AAPL | Stock | 4.8454 | 4.8468 | 4.8268 | 4.8321 | 17353056.0 |
| 2007-09-11 11:05:00 | AAPL | Stock | 4.8318 | 4.8368 | 4.8229 | 4.834 | 12297768.0 |
| 2007-09-11 11:10:00 | AAPL | Stock | 4.8343 | 4.8482 | 4.8332 | 4.8432 | 11491592.0 |
| 2007-09-11 11:15:00 | AAPL | Stock | 4.8432 | 4.8468 | 4.8364 | 4.8411 | 6310556.0 |
| 2007-09-11 11:20:00 | AAPL | Stock | 4.8418 | 4.8532 | 4.8411 | 4.8525 | 8662052.0 |
| 2007-09-11 11:25:00 | AAPL | Stock | 4.8521 | 4.8579 | 4.85 | 4.8557 | 11018896.0 |
| 2007-09-11 11:30:00 | AAPL | Stock | 4.8561 | 4.8575 | 4.8493 | 4.8549 | 8066352.0 |
| 2007-09-11 11:35:00 | AAPL | Stock | 4.8543 | 4.8629 | 4.8414 | 4.8475 | 9121924.0 |
| 2007-09-11 11:40:00 | AAPL | Stock | 4.8475 | 4.8529 | 4.8368 | 4.8375 | 6559084.0 |
| 2007-09-11 11:45:00 | AAPL | Stock | 4.8371 | 4.8443 | 4.835 | 4.8404 | 7001288.0 |
| 2007-09-11 11:50:00 | AAPL | Stock | 4.8407 | 4.8504 | 4.8404 | 4.8461 | 4973948.0 |
| 2007-09-11 11:55:00 | AAPL | Stock | 4.8464 | 4.8479 | 4.8411 | 4.8454 | 3426472.0 |
| 2007-09-11 12:00:00 | AAPL | Stock | 4.8461 | 4.8461 | 4.8375 | 4.8404 | 5165664.0 |
| 2007-09-11 12:05:00 | AAPL | Stock | 4.84 | 4.8446 | 4.8361 | 4.8404 | 4465020.0 |
| 2007-09-11 12:10:00 | AAPL | Stock | 4.8405 | 4.8446 | 4.8307 | 4.8311 | 5784716.0 |
| 2007-09-11 12:15:00 | AAPL | Stock | 4.8321 | 4.8411 | 4.8307 | 4.8379 | 7027664.0 |
| 2007-09-11 12:20:00 | AAPL | Stock | 4.8371 | 4.8418 | 4.835 | 4.8393 | 4797968.0 |
| 2007-09-11 12:25:00 | AAPL | Stock | 4.8396 | 4.8404 | 4.8279 | 4.8307 | 6913872.0 |
| 2007-09-11 12:30:00 | AAPL | Stock | 4.8311 | 4.8382 | 4.8261 | 4.8364 | 6522600.0 |
| 2007-09-11 12:35:00 | AAPL | Stock | 4.8368 | 4.8571 | 4.8364 | 4.8546 | 10329340.0 |
| 2007-09-11 12:40:00 | AAPL | Stock | 4.8546 | 4.8564 | 4.8493 | 4.8529 | 7334236.0 |
| 2007-09-11 12:45:00 | AAPL | Stock | 4.8536 | 4.8554 | 4.8504 | 4.8525 | 5180252.0 |
| 2007-09-11 12:50:00 | AAPL | Stock | 4.8529 | 4.855 | 4.8454 | 4.8525 | 7283668.0 |
| 2007-09-11 12:55:00 | AAPL | Stock | 4.8521 | 4.8568 | 4.8507 | 4.8561 | 5775280.0 |
| 2007-09-11 13:00:00 | AAPL | Stock | 4.8568 | 4.8661 | 4.8536 | 4.8561 | 11501672.0 |
| 2007-09-11 13:05:00 | AAPL | Stock | 4.8557 | 4.8604 | 4.8517 | 4.8536 | 4550672.0 |
| 2007-09-11 13:10:00 | AAPL | Stock | 4.8535 | 4.8554 | 4.8471 | 4.8539 | 5173672.0 |
| 2007-09-11 13:15:00 | AAPL | Stock | 4.8539 | 4.8539 | 4.8429 | 4.8429 | 5894308.0 |
| 2007-09-11 13:20:00 | AAPL | Stock | 4.8429 | 4.8525 | 4.8404 | 4.8518 | 5205592.0 |
| 2007-09-11 13:25:00 | AAPL | Stock | 4.8521 | 4.8554 | 4.8486 | 4.8514 | 5001332.0 |
| 2007-09-11 13:30:00 | AAPL | Stock | 4.8514 | 4.8561 | 4.8482 | 4.8546 | 5782084.0 |
| 2007-09-11 13:35:00 | AAPL | Stock | 4.8546 | 4.8571 | 4.8518 | 4.8543 | 5196380.0 |
> showing 50 of 293,043 rows — these rows as CSV