PREVIEW / stock_5min / 2009-10-14
file: by_date/stock_5min/2009/2009-10-14.parquet size: 4.8 MB rows: 328,974 symbols: 3,403
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-10-14 04:15:00 | AAPL | Stock | 6.8168 | 6.8168 | 6.8168 | 6.8168 | 2800.0 |
| 2009-10-14 05:35:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 2800.0 |
| 2009-10-14 06:20:00 | AAPL | Stock | 6.8479 | 6.8479 | 6.8479 | 6.8479 | 2800.0 |
| 2009-10-14 06:35:00 | AAPL | Stock | 6.8539 | 6.8539 | 6.8539 | 6.8539 | 2800.0 |
| 2009-10-14 06:40:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.8536 | 6.8536 | 12600.0 |
| 2009-10-14 06:50:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 2800.0 |
| 2009-10-14 06:55:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 111244.0 |
| 2009-10-14 07:00:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8482 | 6.8564 | 71484.0 |
| 2009-10-14 07:05:00 | AAPL | Stock | 6.8564 | 6.8571 | 6.8564 | 6.8571 | 58800.0 |
| 2009-10-14 07:10:00 | AAPL | Stock | 6.8571 | 6.8625 | 6.8571 | 6.8625 | 62272.0 |
| 2009-10-14 07:15:00 | AAPL | Stock | 6.8646 | 6.8646 | 6.8571 | 6.8571 | 63700.0 |
| 2009-10-14 07:20:00 | AAPL | Stock | 6.8571 | 6.8646 | 6.8571 | 6.8646 | 30660.0 |
| 2009-10-14 07:35:00 | AAPL | Stock | 6.8646 | 6.8646 | 6.8646 | 6.8646 | 23240.0 |
| 2009-10-14 07:40:00 | AAPL | Stock | 6.8643 | 6.8643 | 6.8643 | 6.8643 | 162400.0 |
| 2009-10-14 07:45:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 11032.0 |
| 2009-10-14 07:50:00 | AAPL | Stock | 6.8639 | 6.8643 | 6.8564 | 6.8643 | 446572.0 |
| 2009-10-14 08:00:00 | AAPL | Stock | 6.8639 | 6.8646 | 6.8568 | 6.8618 | 751940.0 |
| 2009-10-14 08:05:00 | AAPL | Stock | 6.86 | 6.8643 | 6.8571 | 6.8607 | 113204.0 |
| 2009-10-14 08:10:00 | AAPL | Stock | 6.8571 | 6.8639 | 6.8571 | 6.8636 | 95200.0 |
| 2009-10-14 08:15:00 | AAPL | Stock | 6.8607 | 6.8646 | 6.8607 | 6.8643 | 292320.0 |
| 2009-10-14 08:20:00 | AAPL | Stock | 6.8643 | 6.8714 | 6.8643 | 6.8704 | 353024.0 |
| 2009-10-14 08:25:00 | AAPL | Stock | 6.8679 | 6.8739 | 6.8679 | 6.8682 | 173880.0 |
| 2009-10-14 08:30:00 | AAPL | Stock | 6.8679 | 6.8821 | 6.865 | 6.8807 | 722484.0 |
| 2009-10-14 08:35:00 | AAPL | Stock | 6.8821 | 6.8879 | 6.8786 | 6.8875 | 567392.0 |
| 2009-10-14 08:40:00 | AAPL | Stock | 6.8879 | 6.8889 | 6.8779 | 6.8857 | 483840.0 |
| 2009-10-14 08:45:00 | AAPL | Stock | 6.8839 | 6.8907 | 6.8839 | 6.8907 | 436548.0 |
| 2009-10-14 08:50:00 | AAPL | Stock | 6.8911 | 6.8989 | 6.8911 | 6.895 | 973980.0 |
| 2009-10-14 08:55:00 | AAPL | Stock | 6.8946 | 6.9 | 6.8929 | 6.9 | 247324.0 |
| 2009-10-14 09:00:00 | AAPL | Stock | 6.8964 | 6.9007 | 6.8893 | 6.8946 | 894572.0 |
| 2009-10-14 09:05:00 | AAPL | Stock | 6.8929 | 6.8943 | 6.8821 | 6.8911 | 253904.0 |
| 2009-10-14 09:10:00 | AAPL | Stock | 6.8893 | 6.8907 | 6.8796 | 6.8846 | 249900.0 |
| 2009-10-14 09:15:00 | AAPL | Stock | 6.8821 | 6.8832 | 6.8807 | 6.8811 | 138964.0 |
| 2009-10-14 09:20:00 | AAPL | Stock | 6.8804 | 6.8854 | 6.8786 | 6.8804 | 282436.0 |
| 2009-10-14 09:25:00 | AAPL | Stock | 6.8818 | 6.8818 | 6.8639 | 6.8661 | 1142736.0 |
| 2009-10-14 09:30:00 | AAPL | Stock | 6.8661 | 6.8686 | 6.8129 | 6.85 | 26789252.0 |
| 2009-10-14 09:35:00 | AAPL | Stock | 6.85 | 6.8525 | 6.8214 | 6.8261 | 15682996.0 |
| 2009-10-14 09:40:00 | AAPL | Stock | 6.8261 | 6.8439 | 6.8229 | 6.8264 | 10080756.0 |
| 2009-10-14 09:45:00 | AAPL | Stock | 6.8257 | 6.8261 | 6.8046 | 6.8068 | 15455636.0 |
| 2009-10-14 09:50:00 | AAPL | Stock | 6.8075 | 6.8161 | 6.7939 | 6.8107 | 12308688.0 |
| 2009-10-14 09:55:00 | AAPL | Stock | 6.8111 | 6.8179 | 6.7996 | 6.8132 | 9634296.0 |
| 2009-10-14 10:00:00 | AAPL | Stock | 6.8129 | 6.8346 | 6.8057 | 6.8321 | 8386840.0 |
| 2009-10-14 10:05:00 | AAPL | Stock | 6.8324 | 6.8346 | 6.8221 | 6.8254 | 7963200.0 |
| 2009-10-14 10:10:00 | AAPL | Stock | 6.8257 | 6.8318 | 6.8196 | 6.8282 | 4572988.0 |
| 2009-10-14 10:15:00 | AAPL | Stock | 6.8275 | 6.8379 | 6.8259 | 6.8325 | 5367460.0 |
| 2009-10-14 10:20:00 | AAPL | Stock | 6.8318 | 6.8354 | 6.8179 | 6.8179 | 5522608.0 |
| 2009-10-14 10:25:00 | AAPL | Stock | 6.8189 | 6.8275 | 6.818 | 6.8271 | 4668608.0 |
| 2009-10-14 10:30:00 | AAPL | Stock | 6.8271 | 6.8382 | 6.8236 | 6.8375 | 4342716.0 |
| 2009-10-14 10:35:00 | AAPL | Stock | 6.8371 | 6.8382 | 6.8321 | 6.8332 | 3492748.0 |
| 2009-10-14 10:40:00 | AAPL | Stock | 6.8329 | 6.835 | 6.8286 | 6.8314 | 2287684.0 |
| 2009-10-14 10:45:00 | AAPL | Stock | 6.8314 | 6.8357 | 6.8271 | 6.8332 | 2541084.0 |
> showing 50 of 328,974 rows — these rows as CSV