PREVIEW / stock_5min / 2008-07-01
file: by_date/stock_5min/2008/2008-07-01.parquet size: 4.7 MB rows: 329,621 symbols: 3,342
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-01 04:55:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9286 | 5.9286 | 2800.0 |
| 2008-07-01 05:00:00 | AAPL | Stock | 5.9175 | 5.9175 | 5.9175 | 5.9175 | 8400.0 |
| 2008-07-01 07:10:00 | AAPL | Stock | 5.9107 | 5.9436 | 5.8929 | 5.8964 | 25200.0 |
| 2008-07-01 07:20:00 | AAPL | Stock | 5.9004 | 5.9004 | 5.9 | 5.9 | 11200.0 |
| 2008-07-01 07:40:00 | AAPL | Stock | 5.9107 | 5.9211 | 5.9107 | 5.9211 | 44156.0 |
| 2008-07-01 07:45:00 | AAPL | Stock | 5.9214 | 5.9214 | 5.9107 | 5.9107 | 5600.0 |
| 2008-07-01 07:50:00 | AAPL | Stock | 5.905 | 5.905 | 5.9036 | 5.9036 | 17416.0 |
| 2008-07-01 07:55:00 | AAPL | Stock | 5.8943 | 5.8943 | 5.8929 | 5.8929 | 54600.0 |
| 2008-07-01 08:00:00 | AAPL | Stock | 5.98 | 5.98 | 5.8929 | 5.8957 | 538608.0 |
| 2008-07-01 08:05:00 | AAPL | Stock | 5.8957 | 5.9107 | 5.8929 | 5.9018 | 317156.0 |
| 2008-07-01 08:10:00 | AAPL | Stock | 5.9 | 5.98 | 5.8986 | 5.9107 | 436016.0 |
| 2008-07-01 08:15:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9004 | 5.9068 | 138180.0 |
| 2008-07-01 08:20:00 | AAPL | Stock | 5.9071 | 5.9139 | 5.9036 | 5.9139 | 64120.0 |
| 2008-07-01 08:25:00 | AAPL | Stock | 5.9111 | 5.9207 | 5.9107 | 5.9161 | 58828.0 |
| 2008-07-01 08:30:00 | AAPL | Stock | 5.9161 | 5.9161 | 5.9029 | 5.9039 | 156492.0 |
| 2008-07-01 08:35:00 | AAPL | Stock | 5.9079 | 5.9079 | 5.8982 | 5.8996 | 137676.0 |
| 2008-07-01 08:40:00 | AAPL | Stock | 5.8996 | 5.8996 | 5.8879 | 5.8929 | 691908.0 |
| 2008-07-01 08:45:00 | AAPL | Stock | 5.8921 | 5.8921 | 5.8893 | 5.8904 | 136640.0 |
| 2008-07-01 08:50:00 | AAPL | Stock | 5.8904 | 5.8921 | 5.885 | 5.8857 | 470652.0 |
| 2008-07-01 08:55:00 | AAPL | Stock | 5.8879 | 5.8921 | 5.8836 | 5.8857 | 467460.0 |
| 2008-07-01 09:00:00 | AAPL | Stock | 5.8871 | 5.8875 | 5.8786 | 5.8825 | 308868.0 |
| 2008-07-01 09:05:00 | AAPL | Stock | 5.8818 | 5.8929 | 5.8757 | 5.8818 | 976304.0 |
| 2008-07-01 09:10:00 | AAPL | Stock | 5.8804 | 5.8929 | 5.8714 | 5.8904 | 1065568.0 |
| 2008-07-01 09:15:00 | AAPL | Stock | 5.8868 | 5.8896 | 5.8729 | 5.8732 | 223188.0 |
| 2008-07-01 09:20:00 | AAPL | Stock | 5.8775 | 5.8889 | 5.8754 | 5.8807 | 282576.0 |
| 2008-07-01 09:25:00 | AAPL | Stock | 5.8839 | 5.8929 | 5.8629 | 5.8671 | 1815856.0 |
| 2008-07-01 09:30:00 | AAPL | Stock | 5.8675 | 5.9104 | 5.8571 | 5.9038 | 29372644.0 |
| 2008-07-01 09:35:00 | AAPL | Stock | 5.9037 | 5.955 | 5.8861 | 5.9407 | 30651236.0 |
| 2008-07-01 09:40:00 | AAPL | Stock | 5.9396 | 5.9875 | 5.8968 | 5.9782 | 28525924.0 |
| 2008-07-01 09:45:00 | AAPL | Stock | 5.9779 | 6.0179 | 5.9768 | 6.0114 | 25464712.0 |
| 2008-07-01 09:50:00 | AAPL | Stock | 6.0083 | 6.1607 | 6.0 | 6.0396 | 22006964.0 |
| 2008-07-01 09:55:00 | AAPL | Stock | 6.0393 | 6.07 | 6.0386 | 6.045 | 21168196.0 |
| 2008-07-01 10:00:00 | AAPL | Stock | 6.045 | 6.1021 | 6.0396 | 6.1018 | 31181108.0 |
| 2008-07-01 10:05:00 | AAPL | Stock | 6.1021 | 6.1586 | 6.0864 | 6.1064 | 30672152.0 |
| 2008-07-01 10:10:00 | AAPL | Stock | 6.1064 | 6.1175 | 6.0639 | 6.0711 | 24098536.0 |
| 2008-07-01 10:15:00 | AAPL | Stock | 6.0711 | 6.0857 | 6.0586 | 6.0761 | 14312004.0 |
| 2008-07-01 10:20:00 | AAPL | Stock | 6.0779 | 6.1036 | 6.0693 | 6.0968 | 12817308.0 |
| 2008-07-01 10:25:00 | AAPL | Stock | 6.0971 | 6.1311 | 6.0971 | 6.1139 | 16671032.0 |
| 2008-07-01 10:30:00 | AAPL | Stock | 6.1126 | 6.1407 | 6.1126 | 6.1404 | 15008420.0 |
| 2008-07-01 10:35:00 | AAPL | Stock | 6.1393 | 6.1496 | 6.1329 | 6.1379 | 19768588.0 |
| 2008-07-01 10:40:00 | AAPL | Stock | 6.1379 | 6.1413 | 6.1161 | 6.1296 | 13276228.0 |
| 2008-07-01 10:45:00 | AAPL | Stock | 6.1296 | 6.1536 | 6.1232 | 6.1439 | 13693680.0 |
| 2008-07-01 10:50:00 | AAPL | Stock | 6.1454 | 6.15 | 6.1279 | 6.1411 | 9698304.0 |
| 2008-07-01 10:55:00 | AAPL | Stock | 6.1414 | 6.1571 | 6.1239 | 6.1568 | 12165020.0 |
| 2008-07-01 11:00:00 | AAPL | Stock | 6.1571 | 6.1693 | 6.1487 | 6.1554 | 20591452.0 |
| 2008-07-01 11:05:00 | AAPL | Stock | 6.1554 | 6.1714 | 6.1493 | 6.1511 | 15317316.0 |
| 2008-07-01 11:10:00 | AAPL | Stock | 6.1507 | 6.1636 | 6.1493 | 6.1625 | 12659080.0 |
| 2008-07-01 11:15:00 | AAPL | Stock | 6.1625 | 6.1657 | 6.1314 | 6.1368 | 13685532.0 |
| 2008-07-01 11:20:00 | AAPL | Stock | 6.1371 | 6.1625 | 6.1371 | 6.15 | 12709788.0 |
| 2008-07-01 11:25:00 | AAPL | Stock | 6.15 | 6.1657 | 6.1479 | 6.1612 | 8994720.0 |
> showing 50 of 329,621 rows — these rows as CSV