PREVIEW / stock_5min / 2007-05-11
file: by_date/stock_5min/2007/2007-05-11.parquet size: 3.7 MB rows: 275,446 symbols: 2,730
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-05-11 09:40:00 | AAPL | Stock | 3.8479 | 3.8675 | 3.8476 | 3.8632 | 4589704.0 |
| 2007-05-11 09:45:00 | AAPL | Stock | 3.8632 | 3.8636 | 3.8443 | 3.8471 | 11621792.0 |
| 2007-05-11 09:50:00 | AAPL | Stock | 3.8475 | 3.8525 | 3.8096 | 3.8357 | 17710392.0 |
| 2007-05-11 09:55:00 | AAPL | Stock | 3.8357 | 3.8429 | 3.8286 | 3.8314 | 10489136.0 |
| 2007-05-11 10:00:00 | AAPL | Stock | 3.8318 | 3.845 | 3.8307 | 3.8343 | 13617604.0 |
| 2007-05-11 10:05:00 | AAPL | Stock | 3.8339 | 3.8343 | 3.8136 | 3.8279 | 18178496.0 |
| 2007-05-11 10:10:00 | AAPL | Stock | 3.8279 | 3.8389 | 3.8257 | 3.8379 | 8479660.0 |
| 2007-05-11 10:15:00 | AAPL | Stock | 3.8385 | 3.8429 | 3.8371 | 3.8411 | 8825936.0 |
| 2007-05-11 10:20:00 | AAPL | Stock | 3.8411 | 3.8429 | 3.8371 | 3.8396 | 9179240.0 |
| 2007-05-11 10:25:00 | AAPL | Stock | 3.8396 | 3.8475 | 3.8396 | 3.8461 | 8657768.0 |
| 2007-05-11 10:30:00 | AAPL | Stock | 3.8461 | 3.8532 | 3.8461 | 3.8468 | 11489632.0 |
| 2007-05-11 10:35:00 | AAPL | Stock | 3.8464 | 3.8561 | 3.8461 | 3.8518 | 10156328.0 |
| 2007-05-11 10:40:00 | AAPL | Stock | 3.8514 | 3.8568 | 3.85 | 3.8536 | 9229304.0 |
| 2007-05-11 10:45:00 | AAPL | Stock | 3.8539 | 3.8571 | 3.8529 | 3.8571 | 11418288.0 |
| 2007-05-11 10:50:00 | AAPL | Stock | 3.8571 | 3.8614 | 3.8557 | 3.8589 | 14296380.0 |
| 2007-05-11 10:55:00 | AAPL | Stock | 3.8586 | 3.8604 | 3.8482 | 3.8543 | 9785804.0 |
| 2007-05-11 11:00:00 | AAPL | Stock | 3.8546 | 3.8607 | 3.8518 | 3.8575 | 6995688.0 |
| 2007-05-11 11:05:00 | AAPL | Stock | 3.8582 | 3.865 | 3.8571 | 3.86 | 10683652.0 |
| 2007-05-11 11:10:00 | AAPL | Stock | 3.8596 | 3.865 | 3.8596 | 3.8639 | 8184260.0 |
| 2007-05-11 11:15:00 | AAPL | Stock | 3.8639 | 3.8711 | 3.8625 | 3.8693 | 10446996.0 |
| 2007-05-11 11:20:00 | AAPL | Stock | 3.8696 | 3.8696 | 3.8582 | 3.8593 | 10890936.0 |
| 2007-05-11 11:25:00 | AAPL | Stock | 3.8593 | 3.8593 | 3.8525 | 3.8571 | 9416092.0 |
| 2007-05-11 11:30:00 | AAPL | Stock | 3.8575 | 3.8643 | 3.8532 | 3.8532 | 6285860.0 |
| 2007-05-11 11:35:00 | AAPL | Stock | 3.8536 | 3.8571 | 3.8518 | 3.8539 | 7702212.0 |
| 2007-05-11 11:40:00 | AAPL | Stock | 3.8543 | 3.8554 | 3.8486 | 3.8525 | 4438364.0 |
| 2007-05-11 11:45:00 | AAPL | Stock | 3.8532 | 3.8564 | 3.85 | 3.8561 | 3540656.0 |
| 2007-05-11 11:50:00 | AAPL | Stock | 3.8557 | 3.8589 | 3.8521 | 3.8589 | 3752504.0 |
| 2007-05-11 11:55:00 | AAPL | Stock | 3.8589 | 3.8618 | 3.8568 | 3.8571 | 5897360.0 |
| 2007-05-11 12:00:00 | AAPL | Stock | 3.8571 | 3.8596 | 3.8568 | 3.8571 | 4295732.0 |
| 2007-05-11 12:05:00 | AAPL | Stock | 3.8575 | 3.86 | 3.8529 | 3.8554 | 5224996.0 |
| 2007-05-11 12:10:00 | AAPL | Stock | 3.8554 | 3.8564 | 3.8504 | 3.8518 | 3990224.0 |
| 2007-05-11 12:15:00 | AAPL | Stock | 3.8518 | 3.8539 | 3.8482 | 3.8525 | 5132568.0 |
| 2007-05-11 12:20:00 | AAPL | Stock | 3.8525 | 3.8657 | 3.8504 | 3.8643 | 9821280.0 |
| 2007-05-11 12:25:00 | AAPL | Stock | 3.8654 | 3.8689 | 3.8629 | 3.8657 | 6375236.0 |
| 2007-05-11 12:30:00 | AAPL | Stock | 3.8657 | 3.8696 | 3.8636 | 3.8664 | 6815816.0 |
| 2007-05-11 12:35:00 | AAPL | Stock | 3.8661 | 3.8739 | 3.8657 | 3.87 | 10457860.0 |
| 2007-05-11 12:40:00 | AAPL | Stock | 3.8696 | 3.875 | 3.8664 | 3.8722 | 8193108.0 |
| 2007-05-11 12:45:00 | AAPL | Stock | 3.8725 | 3.8739 | 3.865 | 3.8696 | 7530320.0 |
| 2007-05-11 12:50:00 | AAPL | Stock | 3.8693 | 3.8707 | 3.865 | 3.8668 | 6514228.0 |
| 2007-05-11 12:55:00 | AAPL | Stock | 3.8671 | 3.8732 | 3.8671 | 3.8728 | 5186300.0 |
| 2007-05-11 13:00:00 | AAPL | Stock | 3.8729 | 3.8732 | 3.8686 | 3.8689 | 5439476.0 |
| 2007-05-11 13:05:00 | AAPL | Stock | 3.8689 | 3.8725 | 3.8686 | 3.8714 | 2736076.0 |
| 2007-05-11 13:10:00 | AAPL | Stock | 3.8711 | 3.8721 | 3.8704 | 3.8707 | 2498748.0 |
| 2007-05-11 13:15:00 | AAPL | Stock | 3.8707 | 3.8714 | 3.87 | 3.8707 | 3233860.0 |
| 2007-05-11 13:20:00 | AAPL | Stock | 3.8704 | 3.8804 | 3.8704 | 3.8804 | 13171648.0 |
| 2007-05-11 13:25:00 | AAPL | Stock | 3.8804 | 3.8821 | 3.8782 | 3.8786 | 7142912.0 |
| 2007-05-11 13:30:00 | AAPL | Stock | 3.8782 | 3.8814 | 3.8739 | 3.8799 | 5115572.0 |
| 2007-05-11 13:35:00 | AAPL | Stock | 3.8793 | 3.88 | 3.8714 | 3.8739 | 7290864.0 |
| 2007-05-11 13:40:00 | AAPL | Stock | 3.8743 | 3.8814 | 3.8732 | 3.8807 | 7292796.0 |
| 2007-05-11 13:45:00 | AAPL | Stock | 3.8814 | 3.8839 | 3.8807 | 3.8821 | 9209900.0 |
> showing 50 of 275,446 rows — these rows as CSV