PREVIEW / stock_1min / 2008-07-08
file: by_date/stock_1min/2008/2008-07-08.parquet size: 13.5 MB rows: 1,071,625 symbols: 2,723
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-08 04:15:00 | AAPL | Stock | 6.2393 | 6.2393 | 6.2179 | 6.2179 | 5600.0 |
| 2008-07-08 04:20:00 | AAPL | Stock | 6.2179 | 6.2179 | 6.2179 | 6.2179 | 2800.0 |
| 2008-07-08 04:37:00 | AAPL | Stock | 6.2179 | 6.2179 | 6.2179 | 6.2179 | 5600.0 |
| 2008-07-08 07:23:00 | AAPL | Stock | 6.2268 | 6.2268 | 6.2268 | 6.2268 | 21000.0 |
| 2008-07-08 07:34:00 | AAPL | Stock | 6.2318 | 6.2318 | 6.2318 | 6.2318 | 11200.0 |
| 2008-07-08 07:45:00 | AAPL | Stock | 6.2375 | 6.2393 | 6.2375 | 6.2375 | 30800.0 |
| 2008-07-08 07:46:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2321 | 6.2321 | 10528.0 |
| 2008-07-08 07:54:00 | AAPL | Stock | 6.225 | 6.225 | 6.2225 | 6.2225 | 14000.0 |
| 2008-07-08 07:55:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2214 | 6.2214 | 47600.0 |
| 2008-07-08 07:56:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2179 | 6.2179 | 16800.0 |
| 2008-07-08 07:57:00 | AAPL | Stock | 6.2196 | 6.2196 | 6.2196 | 6.2196 | 2800.0 |
| 2008-07-08 07:58:00 | AAPL | Stock | 6.2196 | 6.2196 | 6.2161 | 6.2161 | 20300.0 |
| 2008-07-08 08:00:00 | AAPL | Stock | 6.2196 | 6.2375 | 6.2179 | 6.2321 | 303240.0 |
| 2008-07-08 08:01:00 | AAPL | Stock | 6.2293 | 6.2357 | 6.2293 | 6.2357 | 94136.0 |
| 2008-07-08 08:02:00 | AAPL | Stock | 6.2357 | 6.2357 | 6.2286 | 6.2307 | 39200.0 |
| 2008-07-08 08:03:00 | AAPL | Stock | 6.2286 | 6.2321 | 6.2286 | 6.2321 | 53984.0 |
| 2008-07-08 08:04:00 | AAPL | Stock | 6.2321 | 6.235 | 6.2257 | 6.235 | 66192.0 |
| 2008-07-08 08:05:00 | AAPL | Stock | 6.2304 | 6.2321 | 6.2279 | 6.2279 | 11200.0 |
| 2008-07-08 08:06:00 | AAPL | Stock | 6.2286 | 6.2321 | 6.2282 | 6.2321 | 64400.0 |
| 2008-07-08 08:07:00 | AAPL | Stock | 6.2343 | 6.2411 | 6.2343 | 6.2393 | 77700.0 |
| 2008-07-08 08:08:00 | AAPL | Stock | 6.2393 | 6.2393 | 6.2357 | 6.2357 | 44520.0 |
| 2008-07-08 08:09:00 | AAPL | Stock | 6.2339 | 6.2357 | 6.2339 | 6.2354 | 16800.0 |
| 2008-07-08 08:10:00 | AAPL | Stock | 6.2393 | 6.2429 | 6.2393 | 6.2429 | 35000.0 |
| 2008-07-08 08:11:00 | AAPL | Stock | 6.2429 | 6.2429 | 6.2414 | 6.2414 | 30800.0 |
| 2008-07-08 08:12:00 | AAPL | Stock | 6.2429 | 6.2464 | 6.2429 | 6.2464 | 58800.0 |
| 2008-07-08 08:13:00 | AAPL | Stock | 6.25 | 6.2536 | 6.25 | 6.2536 | 8400.0 |
| 2008-07-08 08:14:00 | AAPL | Stock | 6.25 | 6.2607 | 6.2482 | 6.2604 | 85960.0 |
| 2008-07-08 08:15:00 | AAPL | Stock | 6.2586 | 6.2621 | 6.2582 | 6.2582 | 94472.0 |
| 2008-07-08 08:16:00 | AAPL | Stock | 6.2604 | 6.2607 | 6.2571 | 6.2589 | 46200.0 |
| 2008-07-08 08:17:00 | AAPL | Stock | 6.2589 | 6.26 | 6.2557 | 6.26 | 70980.0 |
| 2008-07-08 08:18:00 | AAPL | Stock | 6.2557 | 6.2557 | 6.2496 | 6.2496 | 16800.0 |
| 2008-07-08 08:19:00 | AAPL | Stock | 6.2496 | 6.25 | 6.2493 | 6.2496 | 64400.0 |
| 2008-07-08 08:20:00 | AAPL | Stock | 6.25 | 6.2536 | 6.25 | 6.25 | 56000.0 |
| 2008-07-08 08:21:00 | AAPL | Stock | 6.25 | 6.2504 | 6.25 | 6.25 | 19544.0 |
| 2008-07-08 08:22:00 | AAPL | Stock | 6.2511 | 6.2518 | 6.2432 | 6.245 | 67592.0 |
| 2008-07-08 08:23:00 | AAPL | Stock | 6.2457 | 6.2518 | 6.2457 | 6.2514 | 265608.0 |
| 2008-07-08 08:24:00 | AAPL | Stock | 6.2518 | 6.2586 | 6.2518 | 6.2586 | 5600.0 |
| 2008-07-08 08:25:00 | AAPL | Stock | 6.2589 | 6.2589 | 6.2561 | 6.2589 | 81200.0 |
| 2008-07-08 08:26:00 | AAPL | Stock | 6.2586 | 6.2611 | 6.2564 | 6.2564 | 33600.0 |
| 2008-07-08 08:27:00 | AAPL | Stock | 6.2589 | 6.2618 | 6.2589 | 6.2614 | 37800.0 |
| 2008-07-08 08:28:00 | AAPL | Stock | 6.2618 | 6.2668 | 6.2596 | 6.2661 | 87360.0 |
| 2008-07-08 08:29:00 | AAPL | Stock | 6.2654 | 6.2657 | 6.2639 | 6.2643 | 96460.0 |
| 2008-07-08 08:30:00 | AAPL | Stock | 6.2643 | 6.2679 | 6.2643 | 6.2675 | 242340.0 |
| 2008-07-08 08:31:00 | AAPL | Stock | 6.2675 | 6.2711 | 6.2675 | 6.2696 | 87108.0 |
| 2008-07-08 08:32:00 | AAPL | Stock | 6.2696 | 6.2768 | 6.2682 | 6.2768 | 133000.0 |
| 2008-07-08 08:33:00 | AAPL | Stock | 6.2768 | 6.2768 | 6.2721 | 6.275 | 23800.0 |
| 2008-07-08 08:34:00 | AAPL | Stock | 6.275 | 6.2804 | 6.2732 | 6.2746 | 156072.0 |
| 2008-07-08 08:35:00 | AAPL | Stock | 6.2732 | 6.2786 | 6.2707 | 6.2786 | 86800.0 |
| 2008-07-08 08:36:00 | AAPL | Stock | 6.2768 | 6.2768 | 6.2768 | 6.2768 | 10836.0 |
| 2008-07-08 08:37:00 | AAPL | Stock | 6.2764 | 6.2764 | 6.2764 | 6.2764 | 5600.0 |
> showing 50 of 1,071,625 rows — these rows as CSV