PREVIEW / stock_5min / 2009-10-30
file: by_date/stock_5min/2009/2009-10-30.parquet size: 5.0 MB rows: 333,232 symbols: 3,411
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-30 05:35:00 | AAPL | Stock | 7.0407 | 7.0407 | 7.0407 | 7.0407 | 2800.0 |
| 2009-10-30 06:30:00 | AAPL | Stock | 7.0407 | 7.0407 | 7.0407 | 7.0407 | 13468.0 |
| 2009-10-30 07:00:00 | AAPL | Stock | 7.0189 | 7.0189 | 7.0036 | 7.0071 | 79660.0 |
| 2009-10-30 07:05:00 | AAPL | Stock | 7.0111 | 7.0111 | 7.0071 | 7.0071 | 14000.0 |
| 2009-10-30 07:20:00 | AAPL | Stock | 7.0171 | 7.0171 | 7.0171 | 7.0171 | 2800.0 |
| 2009-10-30 07:30:00 | AAPL | Stock | 7.0089 | 7.0089 | 7.0 | 7.0 | 30800.0 |
| 2009-10-30 07:35:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 5600.0 |
| 2009-10-30 07:40:00 | AAPL | Stock | 6.9971 | 6.9971 | 6.9914 | 6.9914 | 5600.0 |
| 2009-10-30 07:45:00 | AAPL | Stock | 6.9911 | 7.0 | 6.9907 | 7.0 | 11200.0 |
| 2009-10-30 07:50:00 | AAPL | Stock | 7.0004 | 7.0004 | 7.0004 | 7.0004 | 2800.0 |
| 2009-10-30 08:00:00 | AAPL | Stock | 6.995 | 7.0179 | 6.995 | 7.0171 | 254072.0 |
| 2009-10-30 08:05:00 | AAPL | Stock | 7.0161 | 7.0179 | 7.0089 | 7.0089 | 146048.0 |
| 2009-10-30 08:10:00 | AAPL | Stock | 7.0079 | 7.0123 | 7.0071 | 7.0093 | 46088.0 |
| 2009-10-30 08:15:00 | AAPL | Stock | 7.0107 | 7.0168 | 7.0107 | 7.0168 | 44744.0 |
| 2009-10-30 08:20:00 | AAPL | Stock | 7.0171 | 7.0214 | 7.015 | 7.0214 | 118020.0 |
| 2009-10-30 08:25:00 | AAPL | Stock | 7.0204 | 7.0211 | 7.0125 | 7.0125 | 70000.0 |
| 2009-10-30 08:30:00 | AAPL | Stock | 7.0193 | 7.0214 | 7.0068 | 7.0132 | 176204.0 |
| 2009-10-30 08:35:00 | AAPL | Stock | 7.0132 | 7.0132 | 7.0071 | 7.0071 | 43820.0 |
| 2009-10-30 08:40:00 | AAPL | Stock | 7.0071 | 7.0139 | 7.0071 | 7.0139 | 68656.0 |
| 2009-10-30 08:45:00 | AAPL | Stock | 7.0107 | 7.0107 | 7.0011 | 7.0011 | 91280.0 |
| 2009-10-30 08:50:00 | AAPL | Stock | 7.0007 | 7.0007 | 6.9932 | 6.9964 | 141820.0 |
| 2009-10-30 08:55:00 | AAPL | Stock | 6.9964 | 6.9964 | 6.9893 | 6.9893 | 85540.0 |
| 2009-10-30 09:00:00 | AAPL | Stock | 6.9868 | 6.9918 | 6.9832 | 6.9918 | 231588.0 |
| 2009-10-30 09:05:00 | AAPL | Stock | 6.9921 | 6.9932 | 6.9875 | 6.9886 | 75404.0 |
| 2009-10-30 09:10:00 | AAPL | Stock | 6.9893 | 6.9896 | 6.9875 | 6.9875 | 61600.0 |
| 2009-10-30 09:15:00 | AAPL | Stock | 6.9879 | 6.9907 | 6.9879 | 6.9893 | 67200.0 |
| 2009-10-30 09:20:00 | AAPL | Stock | 6.9882 | 6.9896 | 6.9875 | 6.9893 | 73360.0 |
| 2009-10-30 09:25:00 | AAPL | Stock | 6.9911 | 7.0107 | 6.9911 | 6.9996 | 244328.0 |
| 2009-10-30 09:30:00 | AAPL | Stock | 6.9996 | 7.0286 | 6.9821 | 7.0161 | 15445752.0 |
| 2009-10-30 09:35:00 | AAPL | Stock | 7.0182 | 7.0239 | 6.9946 | 7.0029 | 11170040.0 |
| 2009-10-30 09:40:00 | AAPL | Stock | 7.0039 | 7.0146 | 6.9804 | 6.9964 | 15019676.0 |
| 2009-10-30 09:45:00 | AAPL | Stock | 6.9982 | 7.0014 | 6.9554 | 6.9707 | 16629340.0 |
| 2009-10-30 09:50:00 | AAPL | Stock | 6.9712 | 6.9854 | 6.9689 | 6.9814 | 11365788.0 |
| 2009-10-30 09:55:00 | AAPL | Stock | 6.9792 | 6.9996 | 6.9725 | 6.9839 | 7660660.0 |
| 2009-10-30 10:00:00 | AAPL | Stock | 6.9854 | 7.005 | 6.9832 | 6.9875 | 6823516.0 |
| 2009-10-30 10:05:00 | AAPL | Stock | 6.9882 | 6.9964 | 6.9821 | 6.9871 | 5638752.0 |
| 2009-10-30 10:10:00 | AAPL | Stock | 6.9882 | 6.9961 | 6.9754 | 6.9868 | 4561844.0 |
| 2009-10-30 10:15:00 | AAPL | Stock | 6.9879 | 6.9896 | 6.9771 | 6.9807 | 3518256.0 |
| 2009-10-30 10:20:00 | AAPL | Stock | 6.9807 | 6.99 | 6.9739 | 6.9754 | 4673284.0 |
| 2009-10-30 10:25:00 | AAPL | Stock | 6.9779 | 6.9779 | 6.965 | 6.9664 | 7955360.0 |
| 2009-10-30 10:30:00 | AAPL | Stock | 6.9657 | 6.9668 | 6.9521 | 6.9596 | 9751476.0 |
| 2009-10-30 10:35:00 | AAPL | Stock | 6.9589 | 6.9621 | 6.9364 | 6.9518 | 10174752.0 |
| 2009-10-30 10:40:00 | AAPL | Stock | 6.9525 | 6.9589 | 6.9486 | 6.9578 | 5335372.0 |
| 2009-10-30 10:45:00 | AAPL | Stock | 6.9564 | 6.9632 | 6.9536 | 6.9627 | 5055428.0 |
| 2009-10-30 10:50:00 | AAPL | Stock | 6.9636 | 6.9768 | 6.9593 | 6.9714 | 4733400.0 |
| 2009-10-30 10:55:00 | AAPL | Stock | 6.9707 | 6.9764 | 6.9643 | 6.9679 | 2370732.0 |
| 2009-10-30 11:00:00 | AAPL | Stock | 6.9689 | 6.9689 | 6.9607 | 6.9636 | 1927408.0 |
| 2009-10-30 11:05:00 | AAPL | Stock | 6.9632 | 6.9671 | 6.9471 | 6.9545 | 5457984.0 |
| 2009-10-30 11:10:00 | AAPL | Stock | 6.955 | 6.9571 | 6.9471 | 6.9525 | 3246460.0 |
| 2009-10-30 11:15:00 | AAPL | Stock | 6.9529 | 6.9564 | 6.944 | 6.9475 | 5837552.0 |
> showing 50 of 333,232 rows — these rows as CSV