PREVIEW / stock_1min / 2011-11-22
file: by_date/stock_1min/2011/2011-11-22.parquet size: 12.7 MB rows: 958,160 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 |
|---|---|---|---|---|---|---|---|
| 2011-11-22 04:12:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 19600.0 |
| 2011-11-22 04:15:00 | AAPL | Stock | 13.2104 | 13.2104 | 13.2104 | 13.2104 | 7000.0 |
| 2011-11-22 04:17:00 | AAPL | Stock | 13.2071 | 13.2071 | 13.2071 | 13.2071 | 18200.0 |
| 2011-11-22 04:48:00 | AAPL | Stock | 13.225 | 13.225 | 13.225 | 13.225 | 2800.0 |
| 2011-11-22 04:49:00 | AAPL | Stock | 13.225 | 13.225 | 13.225 | 13.225 | 4508.0 |
| 2011-11-22 04:51:00 | AAPL | Stock | 13.225 | 13.225 | 13.225 | 13.225 | 12292.0 |
| 2011-11-22 04:52:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2107 | 13.2107 | 25200.0 |
| 2011-11-22 05:10:00 | AAPL | Stock | 13.2482 | 13.2482 | 13.2482 | 13.2482 | 2800.0 |
| 2011-11-22 06:46:00 | AAPL | Stock | 13.2925 | 13.2925 | 13.2925 | 13.2925 | 2800.0 |
| 2011-11-22 06:56:00 | AAPL | Stock | 13.2814 | 13.2814 | 13.2786 | 13.2786 | 67116.0 |
| 2011-11-22 07:01:00 | AAPL | Stock | 13.2661 | 13.2661 | 13.2661 | 13.2661 | 4200.0 |
| 2011-11-22 07:03:00 | AAPL | Stock | 13.2679 | 13.2679 | 13.2679 | 13.2679 | 5600.0 |
| 2011-11-22 07:04:00 | AAPL | Stock | 13.2679 | 13.2679 | 13.2679 | 13.2679 | 5600.0 |
| 2011-11-22 07:05:00 | AAPL | Stock | 13.2679 | 13.2679 | 13.2679 | 13.2679 | 5600.0 |
| 2011-11-22 07:08:00 | AAPL | Stock | 13.2679 | 13.2714 | 13.2679 | 13.2714 | 19600.0 |
| 2011-11-22 07:11:00 | AAPL | Stock | 13.2857 | 13.2857 | 13.2857 | 13.2857 | 2800.0 |
| 2011-11-22 07:12:00 | AAPL | Stock | 13.2836 | 13.2857 | 13.2836 | 13.2836 | 13440.0 |
| 2011-11-22 07:14:00 | AAPL | Stock | 13.2782 | 13.2782 | 13.2782 | 13.2782 | 2800.0 |
| 2011-11-22 07:15:00 | AAPL | Stock | 13.275 | 13.2786 | 13.275 | 13.2786 | 28000.0 |
| 2011-11-22 07:16:00 | AAPL | Stock | 13.2786 | 13.2786 | 13.2786 | 13.2786 | 3080.0 |
| 2011-11-22 07:17:00 | AAPL | Stock | 13.2589 | 13.2589 | 13.2429 | 13.2429 | 114716.0 |
| 2011-11-22 07:18:00 | AAPL | Stock | 13.2425 | 13.2425 | 13.2425 | 13.2425 | 2800.0 |
| 2011-11-22 07:19:00 | AAPL | Stock | 13.2589 | 13.2625 | 13.2589 | 13.2625 | 28000.0 |
| 2011-11-22 07:20:00 | AAPL | Stock | 13.2643 | 13.2643 | 13.2643 | 13.2643 | 2800.0 |
| 2011-11-22 07:21:00 | AAPL | Stock | 13.2625 | 13.2625 | 13.2625 | 13.2625 | 11200.0 |
| 2011-11-22 07:23:00 | AAPL | Stock | 13.2625 | 13.2625 | 13.2625 | 13.2625 | 28000.0 |
| 2011-11-22 07:30:00 | AAPL | Stock | 13.2439 | 13.25 | 13.2439 | 13.25 | 15400.0 |
| 2011-11-22 07:31:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 2800.0 |
| 2011-11-22 07:33:00 | AAPL | Stock | 13.2393 | 13.2393 | 13.2393 | 13.2393 | 2800.0 |
| 2011-11-22 07:34:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 2800.0 |
| 2011-11-22 07:36:00 | AAPL | Stock | 13.25 | 13.25 | 13.25 | 13.25 | 12320.0 |
| 2011-11-22 07:37:00 | AAPL | Stock | 13.25 | 13.2586 | 13.25 | 13.2586 | 16800.0 |
| 2011-11-22 07:38:00 | AAPL | Stock | 13.2543 | 13.2543 | 13.2543 | 13.2543 | 2800.0 |
| 2011-11-22 07:39:00 | AAPL | Stock | 13.2646 | 13.2646 | 13.2646 | 13.2646 | 4200.0 |
| 2011-11-22 07:40:00 | AAPL | Stock | 13.2504 | 13.2504 | 13.2504 | 13.2504 | 5600.0 |
| 2011-11-22 07:42:00 | AAPL | Stock | 13.2375 | 13.2375 | 13.2321 | 13.2321 | 5600.0 |
| 2011-11-22 07:44:00 | AAPL | Stock | 13.2143 | 13.2182 | 13.2143 | 13.2182 | 17136.0 |
| 2011-11-22 07:45:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 5600.0 |
| 2011-11-22 07:46:00 | AAPL | Stock | 13.2339 | 13.2357 | 13.2143 | 13.2143 | 16800.0 |
| 2011-11-22 07:47:00 | AAPL | Stock | 13.2282 | 13.2282 | 13.2282 | 13.2282 | 2800.0 |
| 2011-11-22 07:49:00 | AAPL | Stock | 13.2332 | 13.2375 | 13.2332 | 13.2375 | 75600.0 |
| 2011-11-22 07:55:00 | AAPL | Stock | 13.2404 | 13.2404 | 13.2389 | 13.2389 | 8400.0 |
| 2011-11-22 07:56:00 | AAPL | Stock | 13.2386 | 13.2386 | 13.2386 | 13.2386 | 2800.0 |
| 2011-11-22 07:58:00 | AAPL | Stock | 13.25 | 13.25 | 13.2482 | 13.25 | 19600.0 |
| 2011-11-22 07:59:00 | AAPL | Stock | 13.2482 | 13.2482 | 13.2482 | 13.2482 | 2800.0 |
| 2011-11-22 08:00:00 | AAPL | Stock | 13.24 | 13.2582 | 13.2336 | 13.2482 | 121996.0 |
| 2011-11-22 08:01:00 | AAPL | Stock | 13.25 | 13.2539 | 13.2321 | 13.2321 | 305284.0 |
| 2011-11-22 08:02:00 | AAPL | Stock | 13.2446 | 13.2446 | 13.2296 | 13.2296 | 14000.0 |
| 2011-11-22 08:04:00 | AAPL | Stock | 13.2268 | 13.2268 | 13.2214 | 13.2232 | 48160.0 |
| 2011-11-22 08:05:00 | AAPL | Stock | 13.2214 | 13.2214 | 13.2214 | 13.2214 | 2800.0 |
> showing 50 of 958,160 rows — these rows as CSV