PREVIEW / stock_1min / 2003-01-21
file: by_date/stock_1min/2003/2003-01-21.parquet size: 4.5 MB rows: 365,306 symbols: 1,263
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-21 08:23:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 33600.0 |
| 2003-01-21 08:44:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 56000.0 |
| 2003-01-21 08:55:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 56000.0 |
| 2003-01-21 09:08:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 16800.0 |
| 2003-01-21 09:25:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 274400.0 |
| 2003-01-21 09:26:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 100800.0 |
| 2003-01-21 09:27:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 22400.0 |
| 2003-01-21 09:29:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 33600.0 |
| 2003-01-21 09:30:00 | AAPL | Stock | 0.2538 | 0.2554 | 0.2532 | 0.255 | 2790144.0 |
| 2003-01-21 09:31:00 | AAPL | Stock | 0.2554 | 0.2563 | 0.2536 | 0.2555 | 4522000.0 |
| 2003-01-21 09:32:00 | AAPL | Stock | 0.2554 | 0.2559 | 0.2538 | 0.2557 | 1372000.0 |
| 2003-01-21 09:33:00 | AAPL | Stock | 0.2559 | 0.2568 | 0.2554 | 0.2568 | 3067232.0 |
| 2003-01-21 09:34:00 | AAPL | Stock | 0.2559 | 0.2571 | 0.2559 | 0.2563 | 2766400.0 |
| 2003-01-21 09:35:00 | AAPL | Stock | 0.257 | 0.2571 | 0.2563 | 0.257 | 1203664.0 |
| 2003-01-21 09:36:00 | AAPL | Stock | 0.2571 | 0.2573 | 0.2566 | 0.257 | 2626736.0 |
| 2003-01-21 09:37:00 | AAPL | Stock | 0.2568 | 0.257 | 0.2557 | 0.2561 | 1209600.0 |
| 2003-01-21 09:38:00 | AAPL | Stock | 0.2561 | 0.2563 | 0.2559 | 0.2563 | 789600.0 |
| 2003-01-21 09:39:00 | AAPL | Stock | 0.2561 | 0.2566 | 0.2559 | 0.2566 | 3007200.0 |
| 2003-01-21 09:40:00 | AAPL | Stock | 0.2566 | 0.2568 | 0.2563 | 0.2568 | 240800.0 |
| 2003-01-21 09:41:00 | AAPL | Stock | 0.2564 | 0.2568 | 0.2561 | 0.2568 | 2486400.0 |
| 2003-01-21 09:42:00 | AAPL | Stock | 0.2563 | 0.2568 | 0.2561 | 0.2563 | 627200.0 |
| 2003-01-21 09:43:00 | AAPL | Stock | 0.2563 | 0.2564 | 0.2561 | 0.2561 | 308000.0 |
| 2003-01-21 09:44:00 | AAPL | Stock | 0.2561 | 0.2561 | 0.2554 | 0.2557 | 1590400.0 |
| 2003-01-21 09:45:00 | AAPL | Stock | 0.2555 | 0.2557 | 0.2552 | 0.2557 | 782992.0 |
| 2003-01-21 09:46:00 | AAPL | Stock | 0.2557 | 0.2559 | 0.2554 | 0.2559 | 162400.0 |
| 2003-01-21 09:47:00 | AAPL | Stock | 0.2559 | 0.2559 | 0.2554 | 0.2559 | 341376.0 |
| 2003-01-21 09:48:00 | AAPL | Stock | 0.2559 | 0.2559 | 0.2555 | 0.2559 | 952000.0 |
| 2003-01-21 09:49:00 | AAPL | Stock | 0.2557 | 0.2561 | 0.2557 | 0.2557 | 515200.0 |
| 2003-01-21 09:50:00 | AAPL | Stock | 0.2561 | 0.2561 | 0.2555 | 0.2559 | 484176.0 |
| 2003-01-21 09:51:00 | AAPL | Stock | 0.2557 | 0.2561 | 0.2557 | 0.2561 | 547512.0 |
| 2003-01-21 09:52:00 | AAPL | Stock | 0.2561 | 0.2563 | 0.2555 | 0.2559 | 614880.0 |
| 2003-01-21 09:53:00 | AAPL | Stock | 0.2559 | 0.2559 | 0.2552 | 0.2552 | 811160.0 |
| 2003-01-21 09:54:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2548 | 0.2548 | 828800.0 |
| 2003-01-21 09:55:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2548 | 0.2554 | 648312.0 |
| 2003-01-21 09:56:00 | AAPL | Stock | 0.2554 | 0.2554 | 0.2546 | 0.2548 | 767200.0 |
| 2003-01-21 09:57:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2546 | 0.2552 | 414400.0 |
| 2003-01-21 09:58:00 | AAPL | Stock | 0.2554 | 0.2554 | 0.2548 | 0.2552 | 280000.0 |
| 2003-01-21 09:59:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2548 | 0.2552 | 274400.0 |
| 2003-01-21 10:00:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2545 | 0.2548 | 912800.0 |
| 2003-01-21 10:01:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2545 | 0.2548 | 229600.0 |
| 2003-01-21 10:02:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2541 | 0.2541 | 263200.0 |
| 2003-01-21 10:03:00 | AAPL | Stock | 0.2541 | 0.2543 | 0.2541 | 0.2543 | 823200.0 |
| 2003-01-21 10:04:00 | AAPL | Stock | 0.2543 | 0.2543 | 0.2539 | 0.2543 | 588000.0 |
| 2003-01-21 10:05:00 | AAPL | Stock | 0.2543 | 0.2543 | 0.2541 | 0.2543 | 212800.0 |
| 2003-01-21 10:06:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2541 | 0.2541 | 1469440.0 |
| 2003-01-21 10:07:00 | AAPL | Stock | 0.2542 | 0.2543 | 0.2542 | 0.2543 | 434560.0 |
| 2003-01-21 10:08:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2543 | 0.2543 | 1336944.0 |
| 2003-01-21 10:09:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2543 | 0.2543 | 604800.0 |
| 2003-01-21 10:10:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2543 | 0.2543 | 341600.0 |
| 2003-01-21 10:11:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2543 | 0.2545 | 100800.0 |
> showing 50 of 365,306 rows — these rows as CSV