PREVIEW / stock_1min / 2006-08-11
file: by_date/stock_1min/2006/2006-08-11.parquet size: 7.9 MB rows: 653,870 symbols: 1,885
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-11 06:57:00 | AAPL | Stock | 2.2839 | 2.2839 | 2.2839 | 2.2839 | 2800.0 |
| 2006-08-11 07:00:00 | AAPL | Stock | 2.2786 | 2.2804 | 2.2786 | 2.2786 | 29680.0 |
| 2006-08-11 07:05:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 16800.0 |
| 2006-08-11 07:28:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 25200.0 |
| 2006-08-11 07:36:00 | AAPL | Stock | 2.2789 | 2.2789 | 2.2789 | 2.2789 | 2800.0 |
| 2006-08-11 07:49:00 | AAPL | Stock | 2.2786 | 2.2821 | 2.2696 | 2.2696 | 151200.0 |
| 2006-08-11 07:50:00 | AAPL | Stock | 2.2786 | 2.2786 | 2.2786 | 2.2786 | 2800.0 |
| 2006-08-11 07:52:00 | AAPL | Stock | 2.2793 | 2.2793 | 2.2793 | 2.2793 | 2800.0 |
| 2006-08-11 07:56:00 | AAPL | Stock | 2.2736 | 2.2736 | 2.2736 | 2.2736 | 5600.0 |
| 2006-08-11 08:00:00 | AAPL | Stock | 2.2818 | 2.2818 | 2.2739 | 2.2804 | 25200.0 |
| 2006-08-11 08:01:00 | AAPL | Stock | 2.2768 | 2.2821 | 2.2679 | 2.2679 | 372400.0 |
| 2006-08-11 08:02:00 | AAPL | Stock | 2.2679 | 2.2679 | 2.2625 | 2.265 | 93800.0 |
| 2006-08-11 08:03:00 | AAPL | Stock | 2.2625 | 2.2643 | 2.2571 | 2.2589 | 137200.0 |
| 2006-08-11 08:04:00 | AAPL | Stock | 2.2589 | 2.2607 | 2.2586 | 2.2586 | 121940.0 |
| 2006-08-11 08:05:00 | AAPL | Stock | 2.2543 | 2.2546 | 2.25 | 2.2543 | 179620.0 |
| 2006-08-11 08:06:00 | AAPL | Stock | 2.25 | 2.2518 | 2.25 | 2.25 | 273504.0 |
| 2006-08-11 08:07:00 | AAPL | Stock | 2.25 | 2.25 | 2.2429 | 2.2436 | 129136.0 |
| 2006-08-11 08:08:00 | AAPL | Stock | 2.2429 | 2.2439 | 2.2357 | 2.2429 | 377300.0 |
| 2006-08-11 08:09:00 | AAPL | Stock | 2.2393 | 2.2421 | 2.2389 | 2.2393 | 148400.0 |
| 2006-08-11 08:10:00 | AAPL | Stock | 2.2407 | 2.2454 | 2.24 | 2.24 | 263536.0 |
| 2006-08-11 08:11:00 | AAPL | Stock | 2.2396 | 2.2429 | 2.2325 | 2.2325 | 384860.0 |
| 2006-08-11 08:12:00 | AAPL | Stock | 2.2321 | 2.2321 | 2.2225 | 2.2246 | 302120.0 |
| 2006-08-11 08:13:00 | AAPL | Stock | 2.2243 | 2.2318 | 2.2214 | 2.2304 | 528220.0 |
| 2006-08-11 08:14:00 | AAPL | Stock | 2.2318 | 2.2411 | 2.2304 | 2.2346 | 256200.0 |
| 2006-08-11 08:15:00 | AAPL | Stock | 2.2343 | 2.2411 | 2.2343 | 2.2393 | 264600.0 |
| 2006-08-11 08:16:00 | AAPL | Stock | 2.2382 | 2.2411 | 2.2382 | 2.2411 | 179032.0 |
| 2006-08-11 08:17:00 | AAPL | Stock | 2.2411 | 2.2454 | 2.2386 | 2.2386 | 200200.0 |
| 2006-08-11 08:18:00 | AAPL | Stock | 2.2411 | 2.245 | 2.2411 | 2.245 | 22400.0 |
| 2006-08-11 08:19:00 | AAPL | Stock | 2.2432 | 2.2454 | 2.2429 | 2.2436 | 70000.0 |
| 2006-08-11 08:20:00 | AAPL | Stock | 2.2436 | 2.2436 | 2.2411 | 2.2429 | 364000.0 |
| 2006-08-11 08:21:00 | AAPL | Stock | 2.2446 | 2.2457 | 2.2439 | 2.2457 | 63924.0 |
| 2006-08-11 08:22:00 | AAPL | Stock | 2.2464 | 2.2482 | 2.2464 | 2.2482 | 75600.0 |
| 2006-08-11 08:23:00 | AAPL | Stock | 2.25 | 2.2568 | 2.2493 | 2.2518 | 306264.0 |
| 2006-08-11 08:24:00 | AAPL | Stock | 2.2546 | 2.2554 | 2.25 | 2.2532 | 228200.0 |
| 2006-08-11 08:25:00 | AAPL | Stock | 2.2529 | 2.2571 | 2.2511 | 2.2511 | 150080.0 |
| 2006-08-11 08:26:00 | AAPL | Stock | 2.2539 | 2.2589 | 2.2536 | 2.2575 | 356020.0 |
| 2006-08-11 08:27:00 | AAPL | Stock | 2.2582 | 2.2589 | 2.2518 | 2.2536 | 513352.0 |
| 2006-08-11 08:28:00 | AAPL | Stock | 2.2536 | 2.2571 | 2.2518 | 2.2571 | 267680.0 |
| 2006-08-11 08:29:00 | AAPL | Stock | 2.2571 | 2.2625 | 2.2571 | 2.26 | 170688.0 |
| 2006-08-11 08:30:00 | AAPL | Stock | 2.2596 | 2.2607 | 2.2586 | 2.2607 | 131600.0 |
| 2006-08-11 08:31:00 | AAPL | Stock | 2.2611 | 2.2611 | 2.2589 | 2.2589 | 1064000.0 |
| 2006-08-11 08:32:00 | AAPL | Stock | 2.2589 | 2.2589 | 2.2589 | 2.2589 | 218260.0 |
| 2006-08-11 08:33:00 | AAPL | Stock | 2.2607 | 2.2607 | 2.2589 | 2.2593 | 287000.0 |
| 2006-08-11 08:34:00 | AAPL | Stock | 2.2593 | 2.2593 | 2.2589 | 2.2593 | 89600.0 |
| 2006-08-11 08:35:00 | AAPL | Stock | 2.2589 | 2.2593 | 2.2589 | 2.2593 | 232400.0 |
| 2006-08-11 08:36:00 | AAPL | Stock | 2.2593 | 2.2604 | 2.2571 | 2.2582 | 249200.0 |
| 2006-08-11 08:37:00 | AAPL | Stock | 2.2589 | 2.2596 | 2.2582 | 2.2589 | 83160.0 |
| 2006-08-11 08:38:00 | AAPL | Stock | 2.2582 | 2.2643 | 2.2571 | 2.2643 | 789600.0 |
| 2006-08-11 08:39:00 | AAPL | Stock | 2.2636 | 2.2696 | 2.2636 | 2.2696 | 264600.0 |
| 2006-08-11 08:40:00 | AAPL | Stock | 2.2679 | 2.2693 | 2.2643 | 2.2643 | 401100.0 |
> showing 50 of 653,870 rows — these rows as CSV