PREVIEW / stock_1min / 2011-07-05
file: by_date/stock_1min/2011/2011-07-05.parquet size: 13.1 MB rows: 1,000,001 symbols: 2,857
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-07-05 04:18:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 05:46:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 05:58:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 28000.0 |
| 2011-07-05 06:30:00 | AAPL | Stock | 12.225 | 12.225 | 12.225 | 12.225 | 5600.0 |
| 2011-07-05 06:41:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 06:45:00 | AAPL | Stock | 12.2196 | 12.2196 | 12.2196 | 12.2196 | 2800.0 |
| 2011-07-05 07:00:00 | AAPL | Stock | 12.2289 | 12.2386 | 12.2289 | 12.2386 | 11200.0 |
| 2011-07-05 07:01:00 | AAPL | Stock | 12.2404 | 12.2404 | 12.2404 | 12.2404 | 2800.0 |
| 2011-07-05 07:02:00 | AAPL | Stock | 12.2396 | 12.25 | 12.2396 | 12.25 | 14000.0 |
| 2011-07-05 07:03:00 | AAPL | Stock | 12.25 | 12.25 | 12.2496 | 12.2496 | 16800.0 |
| 2011-07-05 07:04:00 | AAPL | Stock | 12.2496 | 12.2496 | 12.2446 | 12.2446 | 5600.0 |
| 2011-07-05 07:05:00 | AAPL | Stock | 12.2429 | 12.25 | 12.2429 | 12.25 | 19600.0 |
| 2011-07-05 07:06:00 | AAPL | Stock | 12.25 | 12.2532 | 12.25 | 12.2532 | 10304.0 |
| 2011-07-05 07:07:00 | AAPL | Stock | 12.2532 | 12.2532 | 12.2532 | 12.2532 | 2800.0 |
| 2011-07-05 07:10:00 | AAPL | Stock | 12.2218 | 12.2218 | 12.2214 | 12.2214 | 8400.0 |
| 2011-07-05 07:14:00 | AAPL | Stock | 12.2286 | 12.2286 | 12.2286 | 12.2286 | 2800.0 |
| 2011-07-05 07:17:00 | AAPL | Stock | 12.2357 | 12.2357 | 12.2357 | 12.2357 | 12936.0 |
| 2011-07-05 07:18:00 | AAPL | Stock | 12.2357 | 12.2364 | 12.2357 | 12.2357 | 31864.0 |
| 2011-07-05 07:19:00 | AAPL | Stock | 12.2189 | 12.2189 | 12.2189 | 12.2189 | 2800.0 |
| 2011-07-05 07:23:00 | AAPL | Stock | 12.2329 | 12.2329 | 12.2329 | 12.2329 | 8400.0 |
| 2011-07-05 07:24:00 | AAPL | Stock | 12.2329 | 12.2329 | 12.2329 | 12.2329 | 8400.0 |
| 2011-07-05 07:35:00 | AAPL | Stock | 12.2446 | 12.2446 | 12.2311 | 12.2314 | 16800.0 |
| 2011-07-05 07:48:00 | AAPL | Stock | 12.2321 | 12.2464 | 12.2314 | 12.2314 | 33180.0 |
| 2011-07-05 07:58:00 | AAPL | Stock | 12.2404 | 12.2404 | 12.2404 | 12.2404 | 2800.0 |
| 2011-07-05 08:00:00 | AAPL | Stock | 12.2496 | 12.25 | 12.2414 | 12.2414 | 99932.0 |
| 2011-07-05 08:02:00 | AAPL | Stock | 12.2479 | 12.2536 | 12.2479 | 12.25 | 165704.0 |
| 2011-07-05 08:03:00 | AAPL | Stock | 12.25 | 12.2532 | 12.25 | 12.25 | 53200.0 |
| 2011-07-05 08:04:00 | AAPL | Stock | 12.2504 | 12.2504 | 12.2504 | 12.2504 | 2800.0 |
| 2011-07-05 08:05:00 | AAPL | Stock | 12.2504 | 12.2504 | 12.2489 | 12.2489 | 30100.0 |
| 2011-07-05 08:06:00 | AAPL | Stock | 12.2489 | 12.2489 | 12.2489 | 12.2489 | 8400.0 |
| 2011-07-05 08:07:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 2800.0 |
| 2011-07-05 08:08:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 2800.0 |
| 2011-07-05 08:16:00 | AAPL | Stock | 12.25 | 12.25 | 12.2496 | 12.2496 | 25200.0 |
| 2011-07-05 08:17:00 | AAPL | Stock | 12.2518 | 12.2518 | 12.2518 | 12.2518 | 12040.0 |
| 2011-07-05 08:21:00 | AAPL | Stock | 12.2539 | 12.2539 | 12.2518 | 12.2518 | 35700.0 |
| 2011-07-05 08:22:00 | AAPL | Stock | 12.2493 | 12.2493 | 12.2493 | 12.2493 | 2800.0 |
| 2011-07-05 08:23:00 | AAPL | Stock | 12.2461 | 12.2461 | 12.2461 | 12.2461 | 2800.0 |
| 2011-07-05 08:25:00 | AAPL | Stock | 12.2439 | 12.2439 | 12.2436 | 12.2436 | 10164.0 |
| 2011-07-05 08:28:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 5600.0 |
| 2011-07-05 08:32:00 | AAPL | Stock | 12.2482 | 12.2482 | 12.2432 | 12.2432 | 8960.0 |
| 2011-07-05 08:34:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 4900.0 |
| 2011-07-05 08:38:00 | AAPL | Stock | 12.2464 | 12.25 | 12.2464 | 12.25 | 11200.0 |
| 2011-07-05 08:40:00 | AAPL | Stock | 12.2436 | 12.2436 | 12.2425 | 12.2425 | 14448.0 |
| 2011-07-05 08:41:00 | AAPL | Stock | 12.2425 | 12.2425 | 12.2421 | 12.2421 | 8400.0 |
| 2011-07-05 08:42:00 | AAPL | Stock | 12.2446 | 12.2446 | 12.2404 | 12.2429 | 24472.0 |
| 2011-07-05 08:51:00 | AAPL | Stock | 12.2493 | 12.2493 | 12.2454 | 12.2454 | 5600.0 |
| 2011-07-05 08:52:00 | AAPL | Stock | 12.2464 | 12.2464 | 12.2464 | 12.2464 | 7000.0 |
| 2011-07-05 08:54:00 | AAPL | Stock | 12.2429 | 12.2429 | 12.2357 | 12.2357 | 13160.0 |
| 2011-07-05 08:55:00 | AAPL | Stock | 12.2429 | 12.2429 | 12.2429 | 12.2429 | 7000.0 |
| 2011-07-05 08:59:00 | AAPL | Stock | 12.2429 | 12.2429 | 12.2429 | 12.2429 | 7728.0 |
> showing 50 of 1,000,001 rows — these rows as CSV