PREVIEW / stock_5min / 2009-07-31
file: by_date/stock_5min/2009/2009-07-31.parquet size: 4.6 MB rows: 320,496 symbols: 3,355
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-31 07:05:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 5572.0 |
| 2009-07-31 07:25:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 3024.0 |
| 2009-07-31 07:30:00 | AAPL | Stock | 5.8339 | 5.8339 | 5.8339 | 5.8339 | 2800.0 |
| 2009-07-31 07:40:00 | AAPL | Stock | 5.8286 | 5.8289 | 5.8286 | 5.8289 | 33320.0 |
| 2009-07-31 07:45:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 10808.0 |
| 2009-07-31 07:50:00 | AAPL | Stock | 5.8418 | 5.8418 | 5.8418 | 5.8418 | 5600.0 |
| 2009-07-31 07:55:00 | AAPL | Stock | 5.8425 | 5.8425 | 5.8425 | 5.8425 | 5600.0 |
| 2009-07-31 08:00:00 | AAPL | Stock | 5.8218 | 5.8286 | 5.8214 | 5.8214 | 141848.0 |
| 2009-07-31 08:05:00 | AAPL | Stock | 5.8214 | 5.8286 | 5.8214 | 5.8286 | 39564.0 |
| 2009-07-31 08:10:00 | AAPL | Stock | 5.8282 | 5.8321 | 5.8282 | 5.8321 | 39200.0 |
| 2009-07-31 08:15:00 | AAPL | Stock | 5.8321 | 5.8375 | 5.8321 | 5.8375 | 65436.0 |
| 2009-07-31 08:20:00 | AAPL | Stock | 5.8368 | 5.8389 | 5.8361 | 5.8375 | 57400.0 |
| 2009-07-31 08:25:00 | AAPL | Stock | 5.8379 | 5.8393 | 5.8357 | 5.8393 | 97412.0 |
| 2009-07-31 08:30:00 | AAPL | Stock | 5.8393 | 5.8479 | 5.8161 | 5.8179 | 537180.0 |
| 2009-07-31 08:35:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.7996 | 5.7996 | 455336.0 |
| 2009-07-31 08:40:00 | AAPL | Stock | 5.7989 | 5.8025 | 5.7964 | 5.7964 | 133140.0 |
| 2009-07-31 08:45:00 | AAPL | Stock | 5.7968 | 5.8121 | 5.795 | 5.8093 | 285908.0 |
| 2009-07-31 08:50:00 | AAPL | Stock | 5.8086 | 5.8086 | 5.7982 | 5.7989 | 178360.0 |
| 2009-07-31 08:55:00 | AAPL | Stock | 5.8007 | 5.8007 | 5.7857 | 5.7914 | 229544.0 |
| 2009-07-31 09:00:00 | AAPL | Stock | 5.7929 | 5.8011 | 5.7907 | 5.7964 | 58800.0 |
| 2009-07-31 09:05:00 | AAPL | Stock | 5.7961 | 5.7971 | 5.7911 | 5.7911 | 39200.0 |
| 2009-07-31 09:10:00 | AAPL | Stock | 5.7911 | 5.7914 | 5.79 | 5.7911 | 110320.0 |
| 2009-07-31 09:15:00 | AAPL | Stock | 5.7911 | 5.7946 | 5.79 | 5.7946 | 96880.0 |
| 2009-07-31 09:20:00 | AAPL | Stock | 5.7946 | 5.8036 | 5.7946 | 5.8036 | 58800.0 |
| 2009-07-31 09:25:00 | AAPL | Stock | 5.8036 | 5.8229 | 5.8036 | 5.8214 | 566608.0 |
| 2009-07-31 09:30:00 | AAPL | Stock | 5.8214 | 5.8529 | 5.8182 | 5.8489 | 17799068.0 |
| 2009-07-31 09:35:00 | AAPL | Stock | 5.8482 | 5.8668 | 5.8414 | 5.8543 | 19711412.0 |
| 2009-07-31 09:40:00 | AAPL | Stock | 5.8545 | 5.8593 | 5.8429 | 5.8564 | 9877672.0 |
| 2009-07-31 09:45:00 | AAPL | Stock | 5.8564 | 5.8696 | 5.8496 | 5.8589 | 12413240.0 |
| 2009-07-31 09:50:00 | AAPL | Stock | 5.8596 | 5.8643 | 5.8482 | 5.8564 | 9300620.0 |
| 2009-07-31 09:55:00 | AAPL | Stock | 5.8557 | 5.8636 | 5.8521 | 5.8568 | 6750436.0 |
| 2009-07-31 10:00:00 | AAPL | Stock | 5.8564 | 5.8568 | 5.8339 | 5.8443 | 13307140.0 |
| 2009-07-31 10:05:00 | AAPL | Stock | 5.8446 | 5.8611 | 5.8411 | 5.8564 | 8363124.0 |
| 2009-07-31 10:10:00 | AAPL | Stock | 5.8568 | 5.8725 | 5.8564 | 5.8682 | 8609580.0 |
| 2009-07-31 10:15:00 | AAPL | Stock | 5.8675 | 5.8832 | 5.8661 | 5.8746 | 10940748.0 |
| 2009-07-31 10:20:00 | AAPL | Stock | 5.8743 | 5.8929 | 5.8725 | 5.89 | 10626252.0 |
| 2009-07-31 10:25:00 | AAPL | Stock | 5.89 | 5.8911 | 5.8743 | 5.8777 | 6413932.0 |
| 2009-07-31 10:30:00 | AAPL | Stock | 5.8768 | 5.8793 | 5.8721 | 5.8764 | 3563784.0 |
| 2009-07-31 10:35:00 | AAPL | Stock | 5.8768 | 5.8775 | 5.8661 | 5.8693 | 3669652.0 |
| 2009-07-31 10:40:00 | AAPL | Stock | 5.8696 | 5.8893 | 5.8675 | 5.8893 | 5198676.0 |
| 2009-07-31 10:45:00 | AAPL | Stock | 5.8896 | 5.8929 | 5.8779 | 5.8814 | 9311008.0 |
| 2009-07-31 10:50:00 | AAPL | Stock | 5.8814 | 5.8843 | 5.8775 | 5.8836 | 2538676.0 |
| 2009-07-31 10:55:00 | AAPL | Stock | 5.8843 | 5.8882 | 5.8736 | 5.8775 | 3265416.0 |
| 2009-07-31 11:00:00 | AAPL | Stock | 5.8773 | 5.8854 | 5.8768 | 5.8821 | 2965760.0 |
| 2009-07-31 11:05:00 | AAPL | Stock | 5.8821 | 5.8857 | 5.8796 | 5.8818 | 1993012.0 |
| 2009-07-31 11:10:00 | AAPL | Stock | 5.8821 | 5.8857 | 5.8793 | 5.8818 | 2426312.0 |
| 2009-07-31 11:15:00 | AAPL | Stock | 5.8811 | 5.8814 | 5.8693 | 5.8693 | 3439996.0 |
| 2009-07-31 11:20:00 | AAPL | Stock | 5.8704 | 5.8768 | 5.8673 | 5.8704 | 3453828.0 |
| 2009-07-31 11:25:00 | AAPL | Stock | 5.8711 | 5.8804 | 5.87 | 5.8736 | 2314956.0 |
| 2009-07-31 11:30:00 | AAPL | Stock | 5.8732 | 5.8775 | 5.8664 | 5.8754 | 3457356.0 |
> showing 50 of 320,496 rows — these rows as CSV