PREVIEW / stock_5min / 2010-10-19
file: by_date/stock_5min/2010/2010-10-19.parquet size: 4.8 MB rows: 327,791 symbols: 3,494
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-19 04:00:00 | AAPL | Stock | 10.7486 | 10.7789 | 10.7214 | 10.7789 | 29400.0 |
| 2010-10-19 04:05:00 | AAPL | Stock | 10.7929 | 10.8186 | 10.7929 | 10.8186 | 39200.0 |
| 2010-10-19 04:10:00 | AAPL | Stock | 10.8139 | 10.8139 | 10.8139 | 10.8139 | 2800.0 |
| 2010-10-19 04:15:00 | AAPL | Stock | 10.8107 | 10.8107 | 10.8107 | 10.8107 | 2800.0 |
| 2010-10-19 04:25:00 | AAPL | Stock | 10.7893 | 10.7893 | 10.7757 | 10.7757 | 61600.0 |
| 2010-10-19 04:35:00 | AAPL | Stock | 10.7629 | 10.7629 | 10.7629 | 10.7629 | 25200.0 |
| 2010-10-19 04:40:00 | AAPL | Stock | 10.7618 | 10.7618 | 10.7607 | 10.7618 | 11200.0 |
| 2010-10-19 05:00:00 | AAPL | Stock | 10.7957 | 10.7957 | 10.7957 | 10.7957 | 22400.0 |
| 2010-10-19 05:05:00 | AAPL | Stock | 10.7954 | 10.7954 | 10.7857 | 10.7857 | 5600.0 |
| 2010-10-19 05:15:00 | AAPL | Stock | 10.7786 | 10.7821 | 10.7786 | 10.7821 | 42616.0 |
| 2010-10-19 05:25:00 | AAPL | Stock | 10.7854 | 10.81 | 10.7854 | 10.81 | 14000.0 |
| 2010-10-19 05:30:00 | AAPL | Stock | 10.7964 | 10.81 | 10.7964 | 10.81 | 14000.0 |
| 2010-10-19 05:35:00 | AAPL | Stock | 10.8071 | 10.8071 | 10.8071 | 10.8071 | 2800.0 |
| 2010-10-19 05:45:00 | AAPL | Stock | 10.8 | 10.8 | 10.8 | 10.8 | 50400.0 |
| 2010-10-19 05:50:00 | AAPL | Stock | 10.8 | 10.8 | 10.8 | 10.8 | 2800.0 |
| 2010-10-19 05:55:00 | AAPL | Stock | 10.7925 | 10.8032 | 10.7925 | 10.8032 | 5600.0 |
| 2010-10-19 06:05:00 | AAPL | Stock | 10.7918 | 10.7918 | 10.7893 | 10.7893 | 18200.0 |
| 2010-10-19 06:10:00 | AAPL | Stock | 10.7893 | 10.7893 | 10.7857 | 10.7857 | 19600.0 |
| 2010-10-19 06:20:00 | AAPL | Stock | 10.7768 | 10.7768 | 10.7768 | 10.7768 | 28000.0 |
| 2010-10-19 06:25:00 | AAPL | Stock | 10.7746 | 10.7746 | 10.7746 | 10.7746 | 5600.0 |
| 2010-10-19 06:30:00 | AAPL | Stock | 10.7782 | 10.7782 | 10.7782 | 10.7782 | 2800.0 |
| 2010-10-19 06:35:00 | AAPL | Stock | 10.785 | 10.7943 | 10.7718 | 10.7943 | 100688.0 |
| 2010-10-19 06:45:00 | AAPL | Stock | 10.7768 | 10.7768 | 10.7768 | 10.7768 | 23520.0 |
| 2010-10-19 06:50:00 | AAPL | Stock | 10.7918 | 10.7936 | 10.7918 | 10.7925 | 39928.0 |
| 2010-10-19 06:55:00 | AAPL | Stock | 10.7939 | 10.7939 | 10.7939 | 10.7939 | 8400.0 |
| 2010-10-19 07:00:00 | AAPL | Stock | 10.7807 | 10.7939 | 10.7307 | 10.7307 | 254492.0 |
| 2010-10-19 07:05:00 | AAPL | Stock | 10.7307 | 10.7479 | 10.7 | 10.7289 | 305788.0 |
| 2010-10-19 07:10:00 | AAPL | Stock | 10.7304 | 10.7304 | 10.6986 | 10.7304 | 127680.0 |
| 2010-10-19 07:15:00 | AAPL | Stock | 10.7486 | 10.7486 | 10.7325 | 10.7325 | 14000.0 |
| 2010-10-19 07:20:00 | AAPL | Stock | 10.7479 | 10.7854 | 10.7479 | 10.7682 | 190316.0 |
| 2010-10-19 07:25:00 | AAPL | Stock | 10.7679 | 10.8054 | 10.7679 | 10.8054 | 371812.0 |
| 2010-10-19 07:30:00 | AAPL | Stock | 10.8036 | 10.8036 | 10.7679 | 10.7964 | 137396.0 |
| 2010-10-19 07:35:00 | AAPL | Stock | 10.7982 | 10.8086 | 10.7779 | 10.7854 | 167468.0 |
| 2010-10-19 07:40:00 | AAPL | Stock | 10.7821 | 10.7821 | 10.7482 | 10.75 | 309960.0 |
| 2010-10-19 07:45:00 | AAPL | Stock | 10.75 | 10.75 | 10.7304 | 10.7304 | 181552.0 |
| 2010-10-19 07:50:00 | AAPL | Stock | 10.7268 | 10.75 | 10.715 | 10.7482 | 92232.0 |
| 2010-10-19 07:55:00 | AAPL | Stock | 10.75 | 10.7679 | 10.75 | 10.75 | 459368.0 |
| 2010-10-19 08:00:00 | AAPL | Stock | 10.75 | 10.7964 | 10.7321 | 10.7807 | 2014460.0 |
| 2010-10-19 08:05:00 | AAPL | Stock | 10.7814 | 10.7943 | 10.7711 | 10.7846 | 1399020.0 |
| 2010-10-19 08:10:00 | AAPL | Stock | 10.7857 | 10.8018 | 10.7804 | 10.7968 | 1202236.0 |
| 2010-10-19 08:15:00 | AAPL | Stock | 10.7979 | 10.8286 | 10.795 | 10.8275 | 3397800.0 |
| 2010-10-19 08:20:00 | AAPL | Stock | 10.8271 | 10.8654 | 10.8179 | 10.8654 | 5406772.0 |
| 2010-10-19 08:25:00 | AAPL | Stock | 10.8654 | 10.9207 | 10.8414 | 10.9107 | 5282788.0 |
| 2010-10-19 08:30:00 | AAPL | Stock | 10.9114 | 11.0 | 10.9079 | 10.9964 | 8895600.0 |
| 2010-10-19 08:35:00 | AAPL | Stock | 10.9964 | 11.0207 | 10.9543 | 10.9643 | 7609028.0 |
| 2010-10-19 08:40:00 | AAPL | Stock | 10.9575 | 10.9596 | 10.9221 | 10.925 | 4584048.0 |
| 2010-10-19 08:45:00 | AAPL | Stock | 10.9246 | 10.9464 | 10.8964 | 10.9375 | 4823896.0 |
| 2010-10-19 08:50:00 | AAPL | Stock | 10.9382 | 10.9482 | 10.8964 | 10.9043 | 3702048.0 |
| 2010-10-19 08:55:00 | AAPL | Stock | 10.9004 | 10.9246 | 10.8964 | 10.8964 | 2589272.0 |
| 2010-10-19 09:00:00 | AAPL | Stock | 10.8971 | 10.8986 | 10.8346 | 10.8357 | 4233376.0 |
> showing 50 of 327,791 rows — these rows as CSV