PREVIEW / stock_1min / 2011-09-06
file: by_date/stock_1min/2011/2011-09-06.parquet size: 13.9 MB rows: 1,049,448 symbols: 2,834
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-06 04:00:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.165 | 13.1914 | 30660.0 |
| 2011-09-06 04:02:00 | AAPL | Stock | 13.2414 | 13.2811 | 13.2414 | 13.2811 | 5600.0 |
| 2011-09-06 04:03:00 | AAPL | Stock | 13.225 | 13.225 | 13.225 | 13.225 | 11200.0 |
| 2011-09-06 04:04:00 | AAPL | Stock | 13.25 | 13.2586 | 13.25 | 13.2586 | 5600.0 |
| 2011-09-06 04:06:00 | AAPL | Stock | 13.2811 | 13.2821 | 13.2811 | 13.2818 | 22400.0 |
| 2011-09-06 04:07:00 | AAPL | Stock | 13.3025 | 13.3025 | 13.3025 | 13.3025 | 2800.0 |
| 2011-09-06 04:08:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 8400.0 |
| 2011-09-06 04:09:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 8400.0 |
| 2011-09-06 04:10:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 22400.0 |
| 2011-09-06 04:11:00 | AAPL | Stock | 13.2857 | 13.2971 | 13.2857 | 13.2857 | 53200.0 |
| 2011-09-06 04:22:00 | AAPL | Stock | 13.2243 | 13.2243 | 13.2243 | 13.2243 | 2800.0 |
| 2011-09-06 04:23:00 | AAPL | Stock | 13.2329 | 13.2329 | 13.2329 | 13.2329 | 2800.0 |
| 2011-09-06 04:24:00 | AAPL | Stock | 13.2357 | 13.2457 | 13.2357 | 13.2457 | 5600.0 |
| 2011-09-06 04:25:00 | AAPL | Stock | 13.2357 | 13.2357 | 13.2357 | 13.2357 | 2800.0 |
| 2011-09-06 04:26:00 | AAPL | Stock | 13.2357 | 13.2357 | 13.2357 | 13.2357 | 2800.0 |
| 2011-09-06 04:34:00 | AAPL | Stock | 13.2296 | 13.2296 | 13.2296 | 13.2296 | 2800.0 |
| 2011-09-06 05:01:00 | AAPL | Stock | 13.24 | 13.24 | 13.24 | 13.24 | 2800.0 |
| 2011-09-06 05:07:00 | AAPL | Stock | 13.2171 | 13.2171 | 13.2171 | 13.2171 | 5600.0 |
| 2011-09-06 05:12:00 | AAPL | Stock | 13.2379 | 13.2379 | 13.2379 | 13.2379 | 2800.0 |
| 2011-09-06 05:14:00 | AAPL | Stock | 13.2514 | 13.2514 | 13.2514 | 13.2514 | 2800.0 |
| 2011-09-06 05:36:00 | AAPL | Stock | 13.2346 | 13.2346 | 13.2346 | 13.2346 | 2800.0 |
| 2011-09-06 05:38:00 | AAPL | Stock | 13.2339 | 13.2339 | 13.2339 | 13.2339 | 2800.0 |
| 2011-09-06 05:56:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 8400.0 |
| 2011-09-06 06:02:00 | AAPL | Stock | 13.2661 | 13.2661 | 13.2661 | 13.2661 | 2800.0 |
| 2011-09-06 06:50:00 | AAPL | Stock | 13.2686 | 13.2696 | 13.2686 | 13.2696 | 5600.0 |
| 2011-09-06 06:52:00 | AAPL | Stock | 13.2679 | 13.2679 | 13.2679 | 13.2679 | 2800.0 |
| 2011-09-06 06:58:00 | AAPL | Stock | 13.2554 | 13.2554 | 13.2554 | 13.2554 | 2940.0 |
| 2011-09-06 07:00:00 | AAPL | Stock | 13.2636 | 13.2636 | 13.245 | 13.245 | 12600.0 |
| 2011-09-06 07:02:00 | AAPL | Stock | 13.2589 | 13.2589 | 13.2589 | 13.2589 | 2800.0 |
| 2011-09-06 07:03:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 6580.0 |
| 2011-09-06 07:04:00 | AAPL | Stock | 13.2589 | 13.2589 | 13.2589 | 13.2589 | 8400.0 |
| 2011-09-06 07:06:00 | AAPL | Stock | 13.2589 | 13.2589 | 13.2589 | 13.2589 | 2800.0 |
| 2011-09-06 07:07:00 | AAPL | Stock | 13.2589 | 13.2589 | 13.2571 | 13.2571 | 14000.0 |
| 2011-09-06 07:08:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 8400.0 |
| 2011-09-06 07:09:00 | AAPL | Stock | 13.2464 | 13.2464 | 13.2464 | 13.2464 | 2800.0 |
| 2011-09-06 07:10:00 | AAPL | Stock | 13.2464 | 13.2464 | 13.245 | 13.245 | 35000.0 |
| 2011-09-06 07:11:00 | AAPL | Stock | 13.235 | 13.235 | 13.235 | 13.235 | 2800.0 |
| 2011-09-06 07:12:00 | AAPL | Stock | 13.2143 | 13.225 | 13.2057 | 13.225 | 28000.0 |
| 2011-09-06 07:13:00 | AAPL | Stock | 13.1789 | 13.1789 | 13.1786 | 13.1786 | 14000.0 |
| 2011-09-06 07:14:00 | AAPL | Stock | 13.1832 | 13.1832 | 13.1832 | 13.1832 | 2800.0 |
| 2011-09-06 07:15:00 | AAPL | Stock | 13.1982 | 13.1982 | 13.1982 | 13.1982 | 14000.0 |
| 2011-09-06 07:16:00 | AAPL | Stock | 13.2 | 13.2 | 13.1843 | 13.1843 | 22960.0 |
| 2011-09-06 07:17:00 | AAPL | Stock | 13.1861 | 13.1918 | 13.1861 | 13.1871 | 16800.0 |
| 2011-09-06 07:18:00 | AAPL | Stock | 13.1929 | 13.1929 | 13.1911 | 13.1911 | 22400.0 |
| 2011-09-06 07:19:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1964 | 13.1964 | 2800.0 |
| 2011-09-06 07:20:00 | AAPL | Stock | 13.2032 | 13.2032 | 13.2032 | 13.2032 | 2800.0 |
| 2011-09-06 07:21:00 | AAPL | Stock | 13.2032 | 13.2032 | 13.2032 | 13.2032 | 8400.0 |
| 2011-09-06 07:22:00 | AAPL | Stock | 13.1968 | 13.1968 | 13.1929 | 13.1929 | 14000.0 |
| 2011-09-06 07:23:00 | AAPL | Stock | 13.1914 | 13.1914 | 13.1911 | 13.1911 | 15764.0 |
| 2011-09-06 07:25:00 | AAPL | Stock | 13.1804 | 13.1804 | 13.1721 | 13.1721 | 11200.0 |
> showing 50 of 1,049,448 rows — these rows as CSV