PREVIEW / stock_5min / 2010-11-17
file: by_date/stock_5min/2010/2010-11-17.parquet size: 4.7 MB rows: 328,087 symbols: 3,504
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-11-17 05:00:00 | AAPL | Stock | 10.8036 | 10.8036 | 10.8036 | 10.8036 | 13860.0 |
| 2010-11-17 05:55:00 | AAPL | Stock | 10.7946 | 10.7946 | 10.7946 | 10.7946 | 2800.0 |
| 2010-11-17 06:25:00 | AAPL | Stock | 10.7871 | 10.7871 | 10.7843 | 10.7843 | 14000.0 |
| 2010-11-17 06:50:00 | AAPL | Stock | 10.7864 | 10.7864 | 10.7864 | 10.7864 | 2800.0 |
| 2010-11-17 07:00:00 | AAPL | Stock | 10.8029 | 10.8029 | 10.8029 | 10.8029 | 2800.0 |
| 2010-11-17 07:05:00 | AAPL | Stock | 10.7786 | 10.7786 | 10.7754 | 10.7782 | 8400.0 |
| 2010-11-17 07:10:00 | AAPL | Stock | 10.7996 | 10.7996 | 10.7996 | 10.7996 | 2800.0 |
| 2010-11-17 07:15:00 | AAPL | Stock | 10.7964 | 10.7964 | 10.7964 | 10.7964 | 2800.0 |
| 2010-11-17 07:20:00 | AAPL | Stock | 10.7736 | 10.7736 | 10.7604 | 10.7711 | 54600.0 |
| 2010-11-17 07:25:00 | AAPL | Stock | 10.7711 | 10.7711 | 10.7536 | 10.7561 | 40600.0 |
| 2010-11-17 07:30:00 | AAPL | Stock | 10.7529 | 10.7529 | 10.7464 | 10.7464 | 22400.0 |
| 2010-11-17 07:35:00 | AAPL | Stock | 10.7461 | 10.7536 | 10.7461 | 10.7536 | 79940.0 |
| 2010-11-17 07:40:00 | AAPL | Stock | 10.7536 | 10.7589 | 10.7511 | 10.7589 | 23800.0 |
| 2010-11-17 07:50:00 | AAPL | Stock | 10.7707 | 10.7707 | 10.7707 | 10.7707 | 12600.0 |
| 2010-11-17 07:55:00 | AAPL | Stock | 10.7682 | 10.7682 | 10.7682 | 10.7682 | 7000.0 |
| 2010-11-17 08:00:00 | AAPL | Stock | 10.7746 | 10.7832 | 10.7618 | 10.7679 | 157612.0 |
| 2010-11-17 08:05:00 | AAPL | Stock | 10.7711 | 10.7857 | 10.7711 | 10.7754 | 697088.0 |
| 2010-11-17 08:10:00 | AAPL | Stock | 10.7786 | 10.7911 | 10.7786 | 10.7857 | 163072.0 |
| 2010-11-17 08:15:00 | AAPL | Stock | 10.7854 | 10.7857 | 10.7811 | 10.7839 | 110600.0 |
| 2010-11-17 08:20:00 | AAPL | Stock | 10.7839 | 10.7839 | 10.7761 | 10.7804 | 112140.0 |
| 2010-11-17 08:25:00 | AAPL | Stock | 10.7779 | 10.7875 | 10.7689 | 10.7821 | 305480.0 |
| 2010-11-17 08:30:00 | AAPL | Stock | 10.7821 | 10.8007 | 10.7821 | 10.7893 | 365820.0 |
| 2010-11-17 08:35:00 | AAPL | Stock | 10.7943 | 10.7964 | 10.7911 | 10.7911 | 213640.0 |
| 2010-11-17 08:40:00 | AAPL | Stock | 10.7907 | 10.7943 | 10.7896 | 10.7943 | 91280.0 |
| 2010-11-17 08:45:00 | AAPL | Stock | 10.7929 | 10.7936 | 10.7821 | 10.7829 | 322840.0 |
| 2010-11-17 08:50:00 | AAPL | Stock | 10.7875 | 10.7879 | 10.7814 | 10.7857 | 290640.0 |
| 2010-11-17 08:55:00 | AAPL | Stock | 10.7793 | 10.7821 | 10.7707 | 10.7714 | 237664.0 |
| 2010-11-17 09:00:00 | AAPL | Stock | 10.775 | 10.7814 | 10.7743 | 10.7786 | 125580.0 |
| 2010-11-17 09:05:00 | AAPL | Stock | 10.78 | 10.7821 | 10.78 | 10.7811 | 204988.0 |
| 2010-11-17 09:10:00 | AAPL | Stock | 10.7814 | 10.7857 | 10.7693 | 10.7718 | 238980.0 |
| 2010-11-17 09:15:00 | AAPL | Stock | 10.7693 | 10.7704 | 10.7679 | 10.77 | 159880.0 |
| 2010-11-17 09:20:00 | AAPL | Stock | 10.7693 | 10.775 | 10.7604 | 10.765 | 277200.0 |
| 2010-11-17 09:25:00 | AAPL | Stock | 10.7675 | 10.775 | 10.7536 | 10.7554 | 297752.0 |
| 2010-11-17 09:30:00 | AAPL | Stock | 10.755 | 10.7875 | 10.7232 | 10.775 | 19786200.0 |
| 2010-11-17 09:35:00 | AAPL | Stock | 10.775 | 10.8136 | 10.7746 | 10.7832 | 14990108.0 |
| 2010-11-17 09:40:00 | AAPL | Stock | 10.7832 | 10.8 | 10.75 | 10.7586 | 8647156.0 |
| 2010-11-17 09:45:00 | AAPL | Stock | 10.7596 | 10.7893 | 10.7371 | 10.77 | 9734228.0 |
| 2010-11-17 09:50:00 | AAPL | Stock | 10.7714 | 10.7911 | 10.7536 | 10.7757 | 6649524.0 |
| 2010-11-17 09:55:00 | AAPL | Stock | 10.775 | 10.7768 | 10.7286 | 10.7543 | 9552396.0 |
| 2010-11-17 10:00:00 | AAPL | Stock | 10.7532 | 10.7786 | 10.7532 | 10.7668 | 6683544.0 |
| 2010-11-17 10:05:00 | AAPL | Stock | 10.7675 | 10.8057 | 10.7659 | 10.7764 | 12501188.0 |
| 2010-11-17 10:10:00 | AAPL | Stock | 10.7764 | 10.7929 | 10.7596 | 10.7925 | 7728588.0 |
| 2010-11-17 10:15:00 | AAPL | Stock | 10.7932 | 10.8214 | 10.7718 | 10.7779 | 10011316.0 |
| 2010-11-17 10:20:00 | AAPL | Stock | 10.7789 | 10.8071 | 10.7775 | 10.7818 | 5471956.0 |
| 2010-11-17 10:25:00 | AAPL | Stock | 10.7818 | 10.8089 | 10.7814 | 10.8082 | 4652396.0 |
| 2010-11-17 10:30:00 | AAPL | Stock | 10.8089 | 10.8211 | 10.7929 | 10.8143 | 6846728.0 |
| 2010-11-17 10:35:00 | AAPL | Stock | 10.8154 | 10.8371 | 10.7971 | 10.8368 | 9126740.0 |
| 2010-11-17 10:40:00 | AAPL | Stock | 10.8365 | 10.8568 | 10.8271 | 10.8454 | 9236360.0 |
| 2010-11-17 10:45:00 | AAPL | Stock | 10.8454 | 10.8536 | 10.8222 | 10.8325 | 4638256.0 |
| 2010-11-17 10:50:00 | AAPL | Stock | 10.8321 | 10.8506 | 10.8146 | 10.8293 | 6976928.0 |
> showing 50 of 328,087 rows — these rows as CSV