PREVIEW / stock_1min / 2012-03-15
file: by_date/stock_1min/2012/2012-03-15.parquet size: 13.2 MB rows: 983,815 symbols: 2,841
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-15 04:00:00 | AAPL | Stock | 21.3036 | 21.3568 | 21.2496 | 21.3568 | 42000.0 |
| 2012-03-15 04:01:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 2800.0 |
| 2012-03-15 04:03:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3214 | 21.3214 | 25200.0 |
| 2012-03-15 04:04:00 | AAPL | Stock | 21.3214 | 21.3393 | 21.2896 | 21.3393 | 16800.0 |
| 2012-03-15 04:05:00 | AAPL | Stock | 21.3393 | 21.3393 | 21.3393 | 21.3393 | 2800.0 |
| 2012-03-15 04:06:00 | AAPL | Stock | 21.3075 | 21.3214 | 21.2857 | 21.2857 | 25060.0 |
| 2012-03-15 04:09:00 | AAPL | Stock | 21.2939 | 21.2939 | 21.2939 | 21.2939 | 5600.0 |
| 2012-03-15 04:10:00 | AAPL | Stock | 21.2904 | 21.2904 | 21.2879 | 21.2879 | 14000.0 |
| 2012-03-15 04:11:00 | AAPL | Stock | 21.2868 | 21.2879 | 21.2868 | 21.2879 | 8400.0 |
| 2012-03-15 04:12:00 | AAPL | Stock | 21.2893 | 21.2929 | 21.2893 | 21.2929 | 25200.0 |
| 2012-03-15 04:13:00 | AAPL | Stock | 21.2893 | 21.2893 | 21.2893 | 21.2893 | 2800.0 |
| 2012-03-15 04:15:00 | AAPL | Stock | 21.2714 | 21.2854 | 21.2714 | 21.2854 | 18368.0 |
| 2012-03-15 04:16:00 | AAPL | Stock | 21.2643 | 21.2643 | 21.2607 | 21.2607 | 16968.0 |
| 2012-03-15 04:17:00 | AAPL | Stock | 21.2854 | 21.2857 | 21.2854 | 21.2857 | 8400.0 |
| 2012-03-15 04:19:00 | AAPL | Stock | 21.2696 | 21.2696 | 21.2679 | 21.2679 | 8400.0 |
| 2012-03-15 04:20:00 | AAPL | Stock | 21.2818 | 21.2818 | 21.2818 | 21.2818 | 5600.0 |
| 2012-03-15 04:22:00 | AAPL | Stock | 21.2807 | 21.2807 | 21.2807 | 21.2807 | 2800.0 |
| 2012-03-15 04:23:00 | AAPL | Stock | 21.28 | 21.28 | 21.28 | 21.28 | 2800.0 |
| 2012-03-15 04:24:00 | AAPL | Stock | 21.2714 | 21.2714 | 21.2679 | 21.2679 | 25480.0 |
| 2012-03-15 04:27:00 | AAPL | Stock | 21.2589 | 21.2589 | 21.2589 | 21.2589 | 2800.0 |
| 2012-03-15 04:30:00 | AAPL | Stock | 21.2625 | 21.2625 | 21.2621 | 21.2621 | 5600.0 |
| 2012-03-15 04:32:00 | AAPL | Stock | 21.2714 | 21.2714 | 21.2714 | 21.2714 | 2800.0 |
| 2012-03-15 04:33:00 | AAPL | Stock | 21.2589 | 21.2589 | 21.1857 | 21.1857 | 70000.0 |
| 2012-03-15 04:34:00 | AAPL | Stock | 21.2071 | 21.2071 | 21.2071 | 21.2071 | 2800.0 |
| 2012-03-15 04:35:00 | AAPL | Stock | 21.2346 | 21.2346 | 21.2346 | 21.2346 | 5600.0 |
| 2012-03-15 04:42:00 | AAPL | Stock | 21.2839 | 21.2839 | 21.2839 | 21.2839 | 5600.0 |
| 2012-03-15 04:46:00 | AAPL | Stock | 21.2804 | 21.2836 | 21.2804 | 21.2836 | 10500.0 |
| 2012-03-15 04:47:00 | AAPL | Stock | 21.2832 | 21.2832 | 21.2832 | 21.2832 | 8148.0 |
| 2012-03-15 04:52:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 2800.0 |
| 2012-03-15 04:53:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 2800.0 |
| 2012-03-15 04:55:00 | AAPL | Stock | 21.2861 | 21.2861 | 21.2857 | 21.2857 | 5600.0 |
| 2012-03-15 04:56:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 5600.0 |
| 2012-03-15 05:03:00 | AAPL | Stock | 21.2875 | 21.2875 | 21.2875 | 21.2875 | 4200.0 |
| 2012-03-15 05:04:00 | AAPL | Stock | 21.2875 | 21.2875 | 21.2875 | 21.2875 | 3640.0 |
| 2012-03-15 05:12:00 | AAPL | Stock | 21.3107 | 21.3107 | 21.3107 | 21.3107 | 2800.0 |
| 2012-03-15 05:14:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 2800.0 |
| 2012-03-15 05:17:00 | AAPL | Stock | 21.3168 | 21.3168 | 21.3168 | 21.3168 | 2800.0 |
| 2012-03-15 05:25:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 30800.0 |
| 2012-03-15 05:26:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 19600.0 |
| 2012-03-15 05:27:00 | AAPL | Stock | 21.3 | 21.3 | 21.295 | 21.295 | 8400.0 |
| 2012-03-15 05:28:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 2800.0 |
| 2012-03-15 05:29:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 5040.0 |
| 2012-03-15 05:31:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 2800.0 |
| 2012-03-15 05:34:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 22400.0 |
| 2012-03-15 05:37:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 4340.0 |
| 2012-03-15 05:38:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 14000.0 |
| 2012-03-15 05:39:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 14000.0 |
| 2012-03-15 05:40:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 2800.0 |
| 2012-03-15 05:41:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 14000.0 |
| 2012-03-15 05:44:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 5880.0 |
> showing 50 of 983,815 rows — these rows as CSV