PREVIEW / stock_5min / 2008-07-23
file: by_date/stock_5min/2008/2008-07-23.parquet size: 4.6 MB rows: 320,677 symbols: 3,341
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-07-23 07:00:00 | AAPL | Stock | 5.7893 | 5.7896 | 5.7893 | 5.7896 | 42000.0 |
| 2008-07-23 07:05:00 | AAPL | Stock | 5.7893 | 5.7893 | 5.7889 | 5.7893 | 35000.0 |
| 2008-07-23 07:15:00 | AAPL | Stock | 5.84 | 5.84 | 5.84 | 5.84 | 66360.0 |
| 2008-07-23 07:20:00 | AAPL | Stock | 5.8396 | 5.8714 | 5.8232 | 5.8714 | 637280.0 |
| 2008-07-23 07:25:00 | AAPL | Stock | 5.8843 | 5.9086 | 5.8768 | 5.8929 | 757036.0 |
| 2008-07-23 07:30:00 | AAPL | Stock | 5.9064 | 5.9429 | 5.9036 | 5.9286 | 957348.0 |
| 2008-07-23 07:35:00 | AAPL | Stock | 5.92 | 5.9286 | 5.9018 | 5.9036 | 745612.0 |
| 2008-07-23 07:40:00 | AAPL | Stock | 5.9032 | 5.9229 | 5.8986 | 5.9071 | 271852.0 |
| 2008-07-23 07:45:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.8861 | 5.8861 | 421876.0 |
| 2008-07-23 07:50:00 | AAPL | Stock | 5.8861 | 5.8861 | 5.875 | 5.8857 | 211400.0 |
| 2008-07-23 07:55:00 | AAPL | Stock | 5.8857 | 5.9107 | 5.8857 | 5.9036 | 370916.0 |
| 2008-07-23 08:00:00 | AAPL | Stock | 5.8929 | 5.9036 | 5.8571 | 5.8589 | 853076.0 |
| 2008-07-23 08:05:00 | AAPL | Stock | 5.8582 | 5.8821 | 5.8571 | 5.875 | 846440.0 |
| 2008-07-23 08:10:00 | AAPL | Stock | 5.7864 | 5.9011 | 5.7864 | 5.8921 | 2079896.0 |
| 2008-07-23 08:15:00 | AAPL | Stock | 5.8921 | 5.9107 | 5.8921 | 5.9025 | 1335376.0 |
| 2008-07-23 08:20:00 | AAPL | Stock | 5.9029 | 5.9036 | 5.8864 | 5.8907 | 634004.0 |
| 2008-07-23 08:25:00 | AAPL | Stock | 5.8907 | 5.8907 | 5.8768 | 5.8861 | 1092392.0 |
| 2008-07-23 08:30:00 | AAPL | Stock | 5.8861 | 5.8904 | 5.8839 | 5.8839 | 241416.0 |
| 2008-07-23 08:35:00 | AAPL | Stock | 5.8843 | 5.8875 | 5.8757 | 5.8821 | 260400.0 |
| 2008-07-23 08:40:00 | AAPL | Stock | 5.8839 | 5.8961 | 5.8836 | 5.8921 | 786912.0 |
| 2008-07-23 08:45:00 | AAPL | Stock | 5.8893 | 5.9 | 5.8875 | 5.8964 | 674212.0 |
| 2008-07-23 08:50:00 | AAPL | Stock | 5.8968 | 5.9068 | 5.8964 | 5.9036 | 1002960.0 |
| 2008-07-23 08:55:00 | AAPL | Stock | 5.9036 | 5.9071 | 5.8943 | 5.8964 | 638092.0 |
| 2008-07-23 09:00:00 | AAPL | Stock | 5.8982 | 5.9018 | 5.875 | 5.8829 | 847140.0 |
| 2008-07-23 09:05:00 | AAPL | Stock | 5.8868 | 5.895 | 5.8839 | 5.8929 | 966224.0 |
| 2008-07-23 09:10:00 | AAPL | Stock | 5.8929 | 5.8964 | 5.8864 | 5.8871 | 930832.0 |
| 2008-07-23 09:15:00 | AAPL | Stock | 5.8868 | 5.9111 | 5.8861 | 5.9071 | 1246672.0 |
| 2008-07-23 09:20:00 | AAPL | Stock | 5.9086 | 5.9154 | 5.8911 | 5.9018 | 520520.0 |
| 2008-07-23 09:25:00 | AAPL | Stock | 5.9018 | 5.9032 | 5.8921 | 5.8929 | 934444.0 |
| 2008-07-23 09:30:00 | AAPL | Stock | 5.8911 | 5.9046 | 5.8268 | 5.8271 | 43185996.0 |
| 2008-07-23 09:35:00 | AAPL | Stock | 5.8282 | 5.8375 | 5.7875 | 5.8129 | 32309788.0 |
| 2008-07-23 09:40:00 | AAPL | Stock | 5.8132 | 5.8186 | 5.77 | 5.8107 | 32122972.0 |
| 2008-07-23 09:45:00 | AAPL | Stock | 5.8107 | 5.85 | 5.8107 | 5.8357 | 24440836.0 |
| 2008-07-23 09:50:00 | AAPL | Stock | 5.8357 | 5.8561 | 5.8146 | 5.8229 | 18281760.0 |
| 2008-07-23 09:55:00 | AAPL | Stock | 5.8229 | 5.8489 | 5.8214 | 5.8486 | 15441552.0 |
| 2008-07-23 10:00:00 | AAPL | Stock | 5.8486 | 5.8793 | 5.8268 | 5.8793 | 22016372.0 |
| 2008-07-23 10:05:00 | AAPL | Stock | 5.8793 | 5.8911 | 5.875 | 5.88 | 18066020.0 |
| 2008-07-23 10:10:00 | AAPL | Stock | 5.88 | 5.9164 | 5.8789 | 5.9071 | 21945532.0 |
| 2008-07-23 10:15:00 | AAPL | Stock | 5.9079 | 5.9696 | 5.8929 | 5.965 | 34794312.0 |
| 2008-07-23 10:20:00 | AAPL | Stock | 5.9654 | 6.0071 | 5.9618 | 5.9756 | 40993512.0 |
| 2008-07-23 10:25:00 | AAPL | Stock | 5.9764 | 5.9946 | 5.9696 | 5.9789 | 21531832.0 |
| 2008-07-23 10:30:00 | AAPL | Stock | 5.9786 | 5.9911 | 5.9743 | 5.9829 | 19375804.0 |
| 2008-07-23 10:35:00 | AAPL | Stock | 5.9836 | 5.9986 | 5.9607 | 5.9746 | 22419068.0 |
| 2008-07-23 10:40:00 | AAPL | Stock | 5.9764 | 6.0132 | 5.9761 | 5.9857 | 20831580.0 |
| 2008-07-23 10:45:00 | AAPL | Stock | 5.985 | 6.0004 | 5.9764 | 5.9982 | 16042768.0 |
| 2008-07-23 10:50:00 | AAPL | Stock | 5.9986 | 6.0 | 5.9589 | 5.9679 | 16641016.0 |
| 2008-07-23 10:55:00 | AAPL | Stock | 5.9679 | 5.9743 | 5.9457 | 5.9511 | 15002176.0 |
| 2008-07-23 11:00:00 | AAPL | Stock | 5.9504 | 5.9604 | 5.9221 | 5.9304 | 18246648.0 |
| 2008-07-23 11:05:00 | AAPL | Stock | 5.9304 | 5.9368 | 5.9125 | 5.9232 | 14205044.0 |
| 2008-07-23 11:10:00 | AAPL | Stock | 5.925 | 5.9296 | 5.9136 | 5.9257 | 8209404.0 |
> showing 50 of 320,677 rows — these rows as CSV