PREVIEW / stock_1min / 2008-06-23
file: by_date/stock_1min/2008/2008-06-23.parquet size: 12.3 MB rows: 992,608 symbols: 2,698
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-06-23 07:11:00 | AAPL | Stock | 6.2707 | 6.2707 | 6.2707 | 6.2707 | 3920.0 |
| 2008-06-23 07:13:00 | AAPL | Stock | 6.2707 | 6.2707 | 6.2707 | 6.2707 | 2800.0 |
| 2008-06-23 07:29:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 11200.0 |
| 2008-06-23 07:30:00 | AAPL | Stock | 6.2707 | 6.2714 | 6.2707 | 6.2714 | 10080.0 |
| 2008-06-23 07:32:00 | AAPL | Stock | 6.2696 | 6.2714 | 6.2696 | 6.2714 | 30800.0 |
| 2008-06-23 07:35:00 | AAPL | Stock | 6.2729 | 6.2729 | 6.2729 | 6.2729 | 2800.0 |
| 2008-06-23 07:40:00 | AAPL | Stock | 6.2732 | 6.2732 | 6.2732 | 6.2732 | 14000.0 |
| 2008-06-23 07:41:00 | AAPL | Stock | 6.2732 | 6.2732 | 6.2732 | 6.2732 | 14000.0 |
| 2008-06-23 07:43:00 | AAPL | Stock | 6.2729 | 6.2729 | 6.2729 | 6.2729 | 2800.0 |
| 2008-06-23 07:48:00 | AAPL | Stock | 6.2686 | 6.2686 | 6.2671 | 6.2682 | 22400.0 |
| 2008-06-23 07:49:00 | AAPL | Stock | 6.2671 | 6.2679 | 6.2671 | 6.2679 | 5600.0 |
| 2008-06-23 07:50:00 | AAPL | Stock | 6.265 | 6.265 | 6.2646 | 6.2646 | 8400.0 |
| 2008-06-23 07:51:00 | AAPL | Stock | 6.2629 | 6.2646 | 6.2629 | 6.2646 | 58800.0 |
| 2008-06-23 07:53:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 14000.0 |
| 2008-06-23 07:55:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2511 | 6.2511 | 100800.0 |
| 2008-06-23 07:59:00 | AAPL | Stock | 6.2564 | 6.2568 | 6.2475 | 6.2475 | 18088.0 |
| 2008-06-23 08:00:00 | AAPL | Stock | 6.2564 | 6.2568 | 6.2189 | 6.2496 | 155092.0 |
| 2008-06-23 08:01:00 | AAPL | Stock | 6.2393 | 6.2454 | 6.2357 | 6.2364 | 72828.0 |
| 2008-06-23 08:03:00 | AAPL | Stock | 6.2411 | 6.2464 | 6.2357 | 6.2357 | 83804.0 |
| 2008-06-23 08:04:00 | AAPL | Stock | 6.2375 | 6.2411 | 6.2375 | 6.2411 | 42000.0 |
| 2008-06-23 08:05:00 | AAPL | Stock | 6.2357 | 6.2357 | 6.2239 | 6.2239 | 71680.0 |
| 2008-06-23 08:06:00 | AAPL | Stock | 6.2232 | 6.2304 | 6.2214 | 6.2304 | 22624.0 |
| 2008-06-23 08:07:00 | AAPL | Stock | 6.225 | 6.2339 | 6.2221 | 6.2232 | 51100.0 |
| 2008-06-23 08:08:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.225 | 6.225 | 29260.0 |
| 2008-06-23 08:09:00 | AAPL | Stock | 6.2232 | 6.2268 | 6.2232 | 6.2264 | 78400.0 |
| 2008-06-23 08:10:00 | AAPL | Stock | 6.2264 | 6.2271 | 6.2221 | 6.2271 | 183372.0 |
| 2008-06-23 08:11:00 | AAPL | Stock | 6.225 | 6.225 | 6.2232 | 6.225 | 16800.0 |
| 2008-06-23 08:12:00 | AAPL | Stock | 6.2286 | 6.2286 | 6.2286 | 6.2286 | 8400.0 |
| 2008-06-23 08:13:00 | AAPL | Stock | 6.2336 | 6.2343 | 6.2336 | 6.2343 | 16800.0 |
| 2008-06-23 08:14:00 | AAPL | Stock | 6.2318 | 6.2411 | 6.2289 | 6.2368 | 105084.0 |
| 2008-06-23 08:15:00 | AAPL | Stock | 6.24 | 6.2429 | 6.2375 | 6.2429 | 75600.0 |
| 2008-06-23 08:16:00 | AAPL | Stock | 6.2446 | 6.2536 | 6.2446 | 6.25 | 218400.0 |
| 2008-06-23 08:17:00 | AAPL | Stock | 6.25 | 6.2525 | 6.25 | 6.25 | 33600.0 |
| 2008-06-23 08:18:00 | AAPL | Stock | 6.2532 | 6.2532 | 6.2475 | 6.2504 | 36400.0 |
| 2008-06-23 08:19:00 | AAPL | Stock | 6.25 | 6.25 | 6.2464 | 6.2464 | 22400.0 |
| 2008-06-23 08:20:00 | AAPL | Stock | 6.2496 | 6.2614 | 6.2496 | 6.2604 | 256200.0 |
| 2008-06-23 08:21:00 | AAPL | Stock | 6.26 | 6.2696 | 6.26 | 6.2643 | 162400.0 |
| 2008-06-23 08:22:00 | AAPL | Stock | 6.2586 | 6.2654 | 6.2586 | 6.2593 | 61600.0 |
| 2008-06-23 08:23:00 | AAPL | Stock | 6.2593 | 6.2604 | 6.2593 | 6.2596 | 19600.0 |
| 2008-06-23 08:24:00 | AAPL | Stock | 6.2618 | 6.2621 | 6.2607 | 6.2607 | 15400.0 |
| 2008-06-23 08:25:00 | AAPL | Stock | 6.2586 | 6.2593 | 6.2571 | 6.2571 | 36400.0 |
| 2008-06-23 08:26:00 | AAPL | Stock | 6.2557 | 6.2589 | 6.2557 | 6.2571 | 9520.0 |
| 2008-06-23 08:27:00 | AAPL | Stock | 6.26 | 6.26 | 6.26 | 6.26 | 2800.0 |
| 2008-06-23 08:28:00 | AAPL | Stock | 6.26 | 6.26 | 6.26 | 6.26 | 5600.0 |
| 2008-06-23 08:30:00 | AAPL | Stock | 6.2554 | 6.2554 | 6.2554 | 6.2554 | 2800.0 |
| 2008-06-23 08:31:00 | AAPL | Stock | 6.2586 | 6.2586 | 6.2539 | 6.2586 | 16800.0 |
| 2008-06-23 08:32:00 | AAPL | Stock | 6.2561 | 6.2589 | 6.2561 | 6.2589 | 16800.0 |
| 2008-06-23 08:33:00 | AAPL | Stock | 6.2557 | 6.2557 | 6.2554 | 6.2554 | 14000.0 |
| 2008-06-23 08:34:00 | AAPL | Stock | 6.2596 | 6.2596 | 6.2596 | 6.2596 | 67816.0 |
| 2008-06-23 08:35:00 | AAPL | Stock | 6.2582 | 6.2582 | 6.2554 | 6.2554 | 8400.0 |
> showing 50 of 992,608 rows — these rows as CSV