PREVIEW / stock_1min / 2010-11-17
file: by_date/stock_1min/2010/2010-11-17.parquet size: 12.7 MB rows: 969,796 symbols: 2,840
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:01:00 | AAPL | Stock | 10.8036 | 10.8036 | 10.8036 | 10.8036 | 13860.0 |
| 2010-11-17 05:59:00 | AAPL | Stock | 10.7946 | 10.7946 | 10.7946 | 10.7946 | 2800.0 |
| 2010-11-17 06:28:00 | AAPL | Stock | 10.7871 | 10.7871 | 10.7871 | 10.7871 | 11200.0 |
| 2010-11-17 06:29:00 | AAPL | Stock | 10.7843 | 10.7843 | 10.7843 | 10.7843 | 2800.0 |
| 2010-11-17 06:51:00 | AAPL | Stock | 10.7864 | 10.7864 | 10.7864 | 10.7864 | 2800.0 |
| 2010-11-17 07:03:00 | AAPL | Stock | 10.8029 | 10.8029 | 10.8029 | 10.8029 | 2800.0 |
| 2010-11-17 07:07:00 | AAPL | Stock | 10.7786 | 10.7786 | 10.7754 | 10.7754 | 5600.0 |
| 2010-11-17 07:09:00 | AAPL | Stock | 10.7782 | 10.7782 | 10.7782 | 10.7782 | 2800.0 |
| 2010-11-17 07:13:00 | AAPL | Stock | 10.7996 | 10.7996 | 10.7996 | 10.7996 | 2800.0 |
| 2010-11-17 07:16: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.7714 | 10.7714 | 33600.0 |
| 2010-11-17 07:22:00 | AAPL | Stock | 10.7707 | 10.7711 | 10.7604 | 10.7604 | 18200.0 |
| 2010-11-17 07:24:00 | AAPL | Stock | 10.7711 | 10.7711 | 10.7711 | 10.7711 | 2800.0 |
| 2010-11-17 07:26:00 | AAPL | Stock | 10.7711 | 10.7711 | 10.7711 | 10.7711 | 2800.0 |
| 2010-11-17 07:28:00 | AAPL | Stock | 10.7711 | 10.7711 | 10.76 | 10.76 | 8400.0 |
| 2010-11-17 07:29:00 | AAPL | Stock | 10.7593 | 10.7593 | 10.7536 | 10.7561 | 29400.0 |
| 2010-11-17 07:31:00 | AAPL | Stock | 10.7529 | 10.7529 | 10.7464 | 10.7464 | 14000.0 |
| 2010-11-17 07:32:00 | AAPL | Stock | 10.7464 | 10.7464 | 10.7464 | 10.7464 | 8400.0 |
| 2010-11-17 07:35:00 | AAPL | Stock | 10.7461 | 10.7461 | 10.7461 | 10.7461 | 8400.0 |
| 2010-11-17 07:36:00 | AAPL | Stock | 10.75 | 10.75 | 10.7464 | 10.7464 | 58940.0 |
| 2010-11-17 07:37:00 | AAPL | Stock | 10.75 | 10.75 | 10.75 | 10.75 | 2800.0 |
| 2010-11-17 07:38:00 | AAPL | Stock | 10.7536 | 10.7536 | 10.7536 | 10.7536 | 9800.0 |
| 2010-11-17 07:40:00 | AAPL | Stock | 10.7536 | 10.7536 | 10.7536 | 10.7536 | 15400.0 |
| 2010-11-17 07:43:00 | AAPL | Stock | 10.7511 | 10.7511 | 10.7511 | 10.7511 | 5600.0 |
| 2010-11-17 07:44:00 | AAPL | Stock | 10.7589 | 10.7589 | 10.7589 | 10.7589 | 2800.0 |
| 2010-11-17 07:51:00 | AAPL | Stock | 10.7707 | 10.7707 | 10.7707 | 10.7707 | 4200.0 |
| 2010-11-17 07:52:00 | AAPL | Stock | 10.7707 | 10.7707 | 10.7707 | 10.7707 | 2800.0 |
| 2010-11-17 07:53:00 | AAPL | Stock | 10.7707 | 10.7707 | 10.7707 | 10.7707 | 5600.0 |
| 2010-11-17 07:58: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.7714 | 68012.0 |
| 2010-11-17 08:02:00 | AAPL | Stock | 10.7643 | 10.7679 | 10.7643 | 10.7671 | 25200.0 |
| 2010-11-17 08:03:00 | AAPL | Stock | 10.7707 | 10.7707 | 10.77 | 10.7707 | 11200.0 |
| 2010-11-17 08:04:00 | AAPL | Stock | 10.7721 | 10.7721 | 10.7679 | 10.7679 | 53200.0 |
| 2010-11-17 08:05:00 | AAPL | Stock | 10.7711 | 10.7729 | 10.7711 | 10.7729 | 72660.0 |
| 2010-11-17 08:06:00 | AAPL | Stock | 10.7729 | 10.7729 | 10.7729 | 10.7729 | 68880.0 |
| 2010-11-17 08:07:00 | AAPL | Stock | 10.7804 | 10.7804 | 10.7721 | 10.7786 | 35560.0 |
| 2010-11-17 08:08:00 | AAPL | Stock | 10.7771 | 10.7857 | 10.7771 | 10.7782 | 511588.0 |
| 2010-11-17 08:09:00 | AAPL | Stock | 10.7789 | 10.78 | 10.7754 | 10.7754 | 8400.0 |
| 2010-11-17 08:10:00 | AAPL | Stock | 10.7786 | 10.7814 | 10.7786 | 10.7814 | 16800.0 |
| 2010-11-17 08:11:00 | AAPL | Stock | 10.7821 | 10.7825 | 10.7821 | 10.7825 | 25200.0 |
| 2010-11-17 08:12:00 | AAPL | Stock | 10.7857 | 10.7911 | 10.7857 | 10.7911 | 38360.0 |
| 2010-11-17 08:13:00 | AAPL | Stock | 10.7871 | 10.7871 | 10.7854 | 10.7857 | 70000.0 |
| 2010-11-17 08:14:00 | AAPL | Stock | 10.7857 | 10.7857 | 10.7857 | 10.7857 | 12712.0 |
| 2010-11-17 08:15:00 | AAPL | Stock | 10.7854 | 10.7857 | 10.7839 | 10.7839 | 50400.0 |
| 2010-11-17 08:16:00 | AAPL | Stock | 10.7854 | 10.7854 | 10.7832 | 10.7832 | 5600.0 |
| 2010-11-17 08:17:00 | AAPL | Stock | 10.7836 | 10.7836 | 10.7811 | 10.7811 | 40600.0 |
| 2010-11-17 08:18:00 | AAPL | Stock | 10.7836 | 10.7836 | 10.7832 | 10.7832 | 8400.0 |
| 2010-11-17 08:19:00 | AAPL | Stock | 10.7839 | 10.7839 | 10.7839 | 10.7839 | 5600.0 |
| 2010-11-17 08:20:00 | AAPL | Stock | 10.7839 | 10.7839 | 10.7761 | 10.7821 | 59500.0 |
| 2010-11-17 08:21:00 | AAPL | Stock | 10.7814 | 10.7814 | 10.7814 | 10.7814 | 5600.0 |
> showing 50 of 969,796 rows — these rows as CSV