PREVIEW / stock_5min / 2008-01-04
file: by_date/stock_5min/2008/2008-01-04.parquet size: 4.5 MB rows: 327,190 symbols: 3,260
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-04 04:15:00 | AAPL | Stock | 6.9957 | 6.9993 | 6.9814 | 6.9993 | 42000.0 |
| 2008-01-04 05:05:00 | AAPL | Stock | 7.0211 | 7.0211 | 7.0211 | 7.0211 | 2800.0 |
| 2008-01-04 05:15:00 | AAPL | Stock | 7.0214 | 7.0214 | 7.0214 | 7.0214 | 11200.0 |
| 2008-01-04 05:20:00 | AAPL | Stock | 7.0286 | 7.0357 | 7.0286 | 7.0357 | 28000.0 |
| 2008-01-04 05:25:00 | AAPL | Stock | 7.0446 | 7.0446 | 7.0446 | 7.0446 | 2800.0 |
| 2008-01-04 05:30:00 | AAPL | Stock | 7.0482 | 7.0482 | 7.0425 | 7.0425 | 5600.0 |
| 2008-01-04 05:35:00 | AAPL | Stock | 7.0471 | 7.0471 | 7.0471 | 7.0471 | 16800.0 |
| 2008-01-04 06:10:00 | AAPL | Stock | 7.0375 | 7.0375 | 7.0368 | 7.0368 | 18424.0 |
| 2008-01-04 06:15:00 | AAPL | Stock | 7.0375 | 7.0375 | 7.0357 | 7.0357 | 35868.0 |
| 2008-01-04 06:40:00 | AAPL | Stock | 7.0296 | 7.0296 | 7.0296 | 7.0296 | 2800.0 |
| 2008-01-04 06:55:00 | AAPL | Stock | 7.0268 | 7.035 | 7.0268 | 7.035 | 5600.0 |
| 2008-01-04 07:00:00 | AAPL | Stock | 7.0179 | 7.0179 | 7.0 | 7.0 | 28000.0 |
| 2008-01-04 07:05:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 14000.0 |
| 2008-01-04 07:10:00 | AAPL | Stock | 7.0014 | 7.0014 | 7.0014 | 7.0014 | 8120.0 |
| 2008-01-04 07:15:00 | AAPL | Stock | 6.9957 | 6.9957 | 6.9957 | 6.9957 | 11200.0 |
| 2008-01-04 07:20:00 | AAPL | Stock | 6.9993 | 6.9993 | 6.9993 | 6.9993 | 14000.0 |
| 2008-01-04 07:25:00 | AAPL | Stock | 7.0 | 7.0036 | 7.0 | 7.0036 | 35000.0 |
| 2008-01-04 07:30:00 | AAPL | Stock | 6.9957 | 7.0 | 6.9957 | 6.9964 | 65520.0 |
| 2008-01-04 07:40:00 | AAPL | Stock | 6.9964 | 6.9964 | 6.9964 | 6.9964 | 28000.0 |
| 2008-01-04 07:50:00 | AAPL | Stock | 6.9964 | 7.0 | 6.9964 | 7.0 | 17528.0 |
| 2008-01-04 07:55:00 | AAPL | Stock | 7.0 | 7.0 | 6.9946 | 6.9946 | 69272.0 |
| 2008-01-04 08:00:00 | AAPL | Stock | 6.9946 | 6.9996 | 6.9618 | 6.9782 | 949984.0 |
| 2008-01-04 08:05:00 | AAPL | Stock | 6.9818 | 6.9821 | 6.9614 | 6.9614 | 642684.0 |
| 2008-01-04 08:10:00 | AAPL | Stock | 6.9621 | 6.9643 | 6.9571 | 6.9607 | 362320.0 |
| 2008-01-04 08:15:00 | AAPL | Stock | 6.9636 | 6.9639 | 6.9518 | 6.9571 | 322196.0 |
| 2008-01-04 08:20:00 | AAPL | Stock | 6.9571 | 6.9607 | 6.9464 | 6.9571 | 401296.0 |
| 2008-01-04 08:25:00 | AAPL | Stock | 6.9571 | 6.9696 | 6.9504 | 6.9643 | 861196.0 |
| 2008-01-04 08:30:00 | AAPL | Stock | 6.9575 | 6.9646 | 6.875 | 6.8921 | 2516612.0 |
| 2008-01-04 08:35:00 | AAPL | Stock | 6.8921 | 6.9054 | 6.8636 | 6.8643 | 1703576.0 |
| 2008-01-04 08:40:00 | AAPL | Stock | 6.8643 | 6.8796 | 6.8532 | 6.8764 | 1804376.0 |
| 2008-01-04 08:45:00 | AAPL | Stock | 6.8714 | 6.8786 | 6.865 | 6.87 | 839300.0 |
| 2008-01-04 08:50:00 | AAPL | Stock | 6.8714 | 6.8714 | 6.8482 | 6.8486 | 1341284.0 |
| 2008-01-04 08:55:00 | AAPL | Stock | 6.85 | 6.8714 | 6.8214 | 6.8321 | 1905288.0 |
| 2008-01-04 09:00:00 | AAPL | Stock | 6.8375 | 6.8429 | 6.7971 | 6.8246 | 1560272.0 |
| 2008-01-04 09:05:00 | AAPL | Stock | 6.825 | 6.8389 | 6.82 | 6.8304 | 831460.0 |
| 2008-01-04 09:10:00 | AAPL | Stock | 6.8286 | 6.8371 | 6.8268 | 6.8289 | 673400.0 |
| 2008-01-04 09:15:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8154 | 6.8221 | 540708.0 |
| 2008-01-04 09:20:00 | AAPL | Stock | 6.8189 | 6.8232 | 6.8146 | 6.8189 | 935564.0 |
| 2008-01-04 09:25:00 | AAPL | Stock | 6.8211 | 6.85 | 6.8179 | 6.8382 | 1596336.0 |
| 2008-01-04 09:30:00 | AAPL | Stock | 6.8371 | 6.8511 | 6.7902 | 6.7918 | 35902188.0 |
| 2008-01-04 09:35:00 | AAPL | Stock | 6.7929 | 6.7982 | 6.7629 | 6.7839 | 49083636.0 |
| 2008-01-04 09:40:00 | AAPL | Stock | 6.7836 | 6.8332 | 6.7829 | 6.8289 | 26188260.0 |
| 2008-01-04 09:45:00 | AAPL | Stock | 6.8289 | 6.8429 | 6.8082 | 6.8329 | 23618700.0 |
| 2008-01-04 09:50:00 | AAPL | Stock | 6.8329 | 6.8571 | 6.8314 | 6.8361 | 22925000.0 |
| 2008-01-04 09:55:00 | AAPL | Stock | 6.8364 | 6.8929 | 6.8168 | 6.8289 | 15377292.0 |
| 2008-01-04 10:00:00 | AAPL | Stock | 6.8291 | 6.8446 | 6.8036 | 6.8196 | 21332528.0 |
| 2008-01-04 10:05:00 | AAPL | Stock | 6.8168 | 6.8393 | 6.8121 | 6.8379 | 15176280.0 |
| 2008-01-04 10:10:00 | AAPL | Stock | 6.8386 | 6.8429 | 6.8004 | 6.8079 | 13783560.0 |
| 2008-01-04 10:15:00 | AAPL | Stock | 6.8082 | 6.8161 | 6.7832 | 6.7836 | 14714868.0 |
| 2008-01-04 10:20:00 | AAPL | Stock | 6.7839 | 6.8043 | 6.78 | 6.7857 | 15196748.0 |
> showing 50 of 327,190 rows — these rows as CSV