PREVIEW / stock_1min / 2000-11-17
file: by_date/stock_1min/2000/2000-11-17.parquet size: 2.3 MB rows: 203,191 symbols: 1,017
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-17 08:38:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3404 | 0.3404 | 5600.0 |
| 2000-11-17 08:49:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 61600.0 |
| 2000-11-17 09:04:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 11200.0 |
| 2000-11-17 09:16:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 11200.0 |
| 2000-11-17 09:17:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 56000.0 |
| 2000-11-17 09:20:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 56000.0 |
| 2000-11-17 09:21:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 56000.0 |
| 2000-11-17 09:22:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 72800.0 |
| 2000-11-17 09:23:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 319200.0 |
| 2000-11-17 09:24:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 44800.0 |
| 2000-11-17 09:25:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3426 | 0.3438 | 207200.0 |
| 2000-11-17 09:26:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3426 | 0.3438 | 179200.0 |
| 2000-11-17 09:27:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3415 | 0.3438 | 347200.0 |
| 2000-11-17 09:28:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 408800.0 |
| 2000-11-17 09:29:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3415 | 0.3426 | 3914400.0 |
| 2000-11-17 09:30:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3404 | 0.3415 | 2391200.0 |
| 2000-11-17 09:31:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3393 | 0.3393 | 3259200.0 |
| 2000-11-17 09:32:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3393 | 0.3426 | 1024800.0 |
| 2000-11-17 09:33:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3426 | 0.3438 | 621600.0 |
| 2000-11-17 09:34:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3426 | 0.3432 | 408800.0 |
| 2000-11-17 09:35:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3426 | 0.3426 | 1198400.0 |
| 2000-11-17 09:36:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3415 | 0.3415 | 884800.0 |
| 2000-11-17 09:37:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3393 | 0.3393 | 1562400.0 |
| 2000-11-17 09:38:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3382 | 0.3393 | 935200.0 |
| 2000-11-17 09:39:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3371 | 0.3371 | 1019200.0 |
| 2000-11-17 09:40:00 | AAPL | Stock | 0.3371 | 0.3382 | 0.3371 | 0.3382 | 375200.0 |
| 2000-11-17 09:41:00 | AAPL | Stock | 0.3382 | 0.3382 | 0.3348 | 0.3371 | 1013600.0 |
| 2000-11-17 09:42:00 | AAPL | Stock | 0.3371 | 0.3382 | 0.3359 | 0.3371 | 644000.0 |
| 2000-11-17 09:43:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.3337 | 0.3348 | 1892800.0 |
| 2000-11-17 09:44:00 | AAPL | Stock | 0.3337 | 0.3348 | 0.3326 | 0.3337 | 1047200.0 |
| 2000-11-17 09:45:00 | AAPL | Stock | 0.3337 | 0.3359 | 0.3326 | 0.3337 | 1663200.0 |
| 2000-11-17 09:46:00 | AAPL | Stock | 0.3337 | 0.3348 | 0.3326 | 0.3337 | 2469600.0 |
| 2000-11-17 09:47:00 | AAPL | Stock | 0.3326 | 0.3337 | 0.3326 | 0.3337 | 1842400.0 |
| 2000-11-17 09:48:00 | AAPL | Stock | 0.3315 | 0.3337 | 0.3309 | 0.3315 | 1635200.0 |
| 2000-11-17 09:49:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3315 | 0.3315 | 784000.0 |
| 2000-11-17 09:50:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3315 | 0.3315 | 2447200.0 |
| 2000-11-17 09:51:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3315 | 0.3315 | 2262400.0 |
| 2000-11-17 09:52:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3304 | 0.3315 | 1321600.0 |
| 2000-11-17 09:53:00 | AAPL | Stock | 0.3315 | 0.3315 | 0.3304 | 0.3315 | 3124800.0 |
| 2000-11-17 09:54:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3304 | 0.3326 | 2251200.0 |
| 2000-11-17 09:55:00 | AAPL | Stock | 0.3326 | 0.3337 | 0.3304 | 0.3326 | 2066400.0 |
| 2000-11-17 09:56:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3315 | 0.3326 | 817600.0 |
| 2000-11-17 09:57:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3315 | 0.332 | 565600.0 |
| 2000-11-17 09:58:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3315 | 0.3326 | 963200.0 |
| 2000-11-17 09:59:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3315 | 0.3315 | 2010400.0 |
| 2000-11-17 10:00:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3315 | 0.3326 | 1388800.0 |
| 2000-11-17 10:01:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3315 | 0.3315 | 800800.0 |
| 2000-11-17 10:02:00 | AAPL | Stock | 0.332 | 0.3326 | 0.3315 | 0.3326 | 778400.0 |
| 2000-11-17 10:03:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3326 | 0.3326 | 599200.0 |
| 2000-11-17 10:04:00 | AAPL | Stock | 0.3315 | 0.3337 | 0.3315 | 0.332 | 2822400.0 |
> showing 50 of 203,191 rows — these rows as CSV