PREVIEW / stock_1min / 2005-05-16
file: by_date/stock_1min/2005/2005-05-16.parquet size: 6.8 MB rows: 566,050 symbols: 1,641
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-16 08:01:00 | AAPL | Stock | 1.2421 | 1.2446 | 1.2421 | 1.2446 | 105000.0 |
| 2005-05-16 08:09:00 | AAPL | Stock | 1.2446 | 1.2446 | 1.2446 | 1.2446 | 14000.0 |
| 2005-05-16 08:20:00 | AAPL | Stock | 1.2486 | 1.2486 | 1.2486 | 1.2486 | 2800.0 |
| 2005-05-16 08:22:00 | AAPL | Stock | 1.2486 | 1.2486 | 1.2486 | 1.2486 | 25200.0 |
| 2005-05-16 08:23:00 | AAPL | Stock | 1.2446 | 1.2446 | 1.2446 | 1.2446 | 58800.0 |
| 2005-05-16 08:30:00 | AAPL | Stock | 1.2446 | 1.2446 | 1.2446 | 1.2446 | 168000.0 |
| 2005-05-16 08:31:00 | AAPL | Stock | 1.2446 | 1.2446 | 1.2429 | 1.2429 | 53200.0 |
| 2005-05-16 08:32:00 | AAPL | Stock | 1.2411 | 1.2432 | 1.2411 | 1.2432 | 148400.0 |
| 2005-05-16 08:33:00 | AAPL | Stock | 1.2411 | 1.2446 | 1.2411 | 1.2446 | 50400.0 |
| 2005-05-16 08:34:00 | AAPL | Stock | 1.2464 | 1.2464 | 1.2464 | 1.2464 | 7000.0 |
| 2005-05-16 08:35:00 | AAPL | Stock | 1.2429 | 1.2464 | 1.2429 | 1.2464 | 22400.0 |
| 2005-05-16 08:37:00 | AAPL | Stock | 1.2411 | 1.2411 | 1.2411 | 1.2411 | 2800.0 |
| 2005-05-16 08:39:00 | AAPL | Stock | 1.2411 | 1.2411 | 1.2411 | 1.2411 | 28000.0 |
| 2005-05-16 08:46:00 | AAPL | Stock | 1.2411 | 1.2411 | 1.2411 | 1.2411 | 28000.0 |
| 2005-05-16 08:48:00 | AAPL | Stock | 1.2411 | 1.2429 | 1.2411 | 1.2429 | 28000.0 |
| 2005-05-16 08:55:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2368 | 1.2368 | 2800.0 |
| 2005-05-16 08:56:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2368 | 1.2368 | 5600.0 |
| 2005-05-16 08:57:00 | AAPL | Stock | 1.2364 | 1.2364 | 1.2357 | 1.2357 | 145600.0 |
| 2005-05-16 08:59:00 | AAPL | Stock | 1.2407 | 1.2407 | 1.2407 | 1.2407 | 14000.0 |
| 2005-05-16 09:05:00 | AAPL | Stock | 1.24 | 1.24 | 1.24 | 1.24 | 13300.0 |
| 2005-05-16 09:07:00 | AAPL | Stock | 1.24 | 1.24 | 1.24 | 1.24 | 13300.0 |
| 2005-05-16 09:18:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2357 | 1.2357 | 518000.0 |
| 2005-05-16 09:19:00 | AAPL | Stock | 1.2357 | 1.2357 | 1.2357 | 1.2357 | 2800.0 |
| 2005-05-16 09:20:00 | AAPL | Stock | 1.2357 | 1.2357 | 1.2357 | 1.2357 | 56000.0 |
| 2005-05-16 09:21:00 | AAPL | Stock | 1.2357 | 1.2357 | 1.2357 | 1.2357 | 36400.0 |
| 2005-05-16 09:25:00 | AAPL | Stock | 1.2382 | 1.2393 | 1.2382 | 1.2393 | 12376.0 |
| 2005-05-16 09:26:00 | AAPL | Stock | 1.2379 | 1.2379 | 1.2379 | 1.2379 | 2800.0 |
| 2005-05-16 09:27:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2368 | 1.2368 | 19600.0 |
| 2005-05-16 09:28:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2368 | 1.2368 | 19684.0 |
| 2005-05-16 09:29:00 | AAPL | Stock | 1.2368 | 1.2368 | 1.2357 | 1.2364 | 111188.0 |
| 2005-05-16 09:30:00 | AAPL | Stock | 1.2343 | 1.2439 | 1.2343 | 1.2407 | 4149096.0 |
| 2005-05-16 09:31:00 | AAPL | Stock | 1.2407 | 1.2411 | 1.2332 | 1.2375 | 2080540.0 |
| 2005-05-16 09:32:00 | AAPL | Stock | 1.2396 | 1.2754 | 1.2339 | 1.2368 | 1516984.0 |
| 2005-05-16 09:33:00 | AAPL | Stock | 1.2375 | 1.2414 | 1.2361 | 1.2414 | 1654184.0 |
| 2005-05-16 09:34:00 | AAPL | Stock | 1.2414 | 1.2418 | 1.2379 | 1.2379 | 865620.0 |
| 2005-05-16 09:35:00 | AAPL | Stock | 1.2379 | 1.24 | 1.2364 | 1.2396 | 1818096.0 |
| 2005-05-16 09:36:00 | AAPL | Stock | 1.2396 | 1.2432 | 1.2396 | 1.2411 | 3016468.0 |
| 2005-05-16 09:37:00 | AAPL | Stock | 1.2411 | 1.2486 | 1.2407 | 1.2482 | 3892280.0 |
| 2005-05-16 09:38:00 | AAPL | Stock | 1.2479 | 1.2518 | 1.2468 | 1.2507 | 4361168.0 |
| 2005-05-16 09:39:00 | AAPL | Stock | 1.2511 | 1.2529 | 1.2493 | 1.25 | 2075444.0 |
| 2005-05-16 09:40:00 | AAPL | Stock | 1.2507 | 1.2532 | 1.2507 | 1.2532 | 1735776.0 |
| 2005-05-16 09:41:00 | AAPL | Stock | 1.2529 | 1.2532 | 1.2496 | 1.2507 | 1503600.0 |
| 2005-05-16 09:42:00 | AAPL | Stock | 1.2511 | 1.2511 | 1.25 | 1.2507 | 596400.0 |
| 2005-05-16 09:43:00 | AAPL | Stock | 1.2507 | 1.2529 | 1.2504 | 1.2521 | 1654856.0 |
| 2005-05-16 09:44:00 | AAPL | Stock | 1.2521 | 1.2571 | 1.2514 | 1.2568 | 2852472.0 |
| 2005-05-16 09:45:00 | AAPL | Stock | 1.2571 | 1.26 | 1.2557 | 1.2589 | 4414200.0 |
| 2005-05-16 09:46:00 | AAPL | Stock | 1.2589 | 1.2625 | 1.2586 | 1.2621 | 3405640.0 |
| 2005-05-16 09:47:00 | AAPL | Stock | 1.2618 | 1.2625 | 1.2582 | 1.2582 | 2323104.0 |
| 2005-05-16 09:48:00 | AAPL | Stock | 1.2579 | 1.26 | 1.2579 | 1.259 | 2161124.0 |
| 2005-05-16 09:49:00 | AAPL | Stock | 1.2589 | 1.26 | 1.2543 | 1.255 | 3244360.0 |
> showing 50 of 566,050 rows — these rows as CSV