PREVIEW / stock_1min / 2000-01-20
file: by_date/stock_1min/2000/2000-01-20.parquet size: 2.4 MB rows: 212,004 symbols: 917
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-01-20 09:30:00 | AAPL | Stock | 1.0313 | 1.0379 | 1.0313 | 1.0352 | 6843200.0 |
| 2000-01-20 09:31:00 | AAPL | Stock | 1.0354 | 1.0357 | 1.0313 | 1.0324 | 8836800.0 |
| 2000-01-20 09:32:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0313 | 1.0324 | 7963200.0 |
| 2000-01-20 09:33:00 | AAPL | Stock | 1.0332 | 1.0385 | 1.0313 | 1.0352 | 16139200.0 |
| 2000-01-20 09:34:00 | AAPL | Stock | 1.0335 | 1.0402 | 1.0329 | 1.0374 | 15825600.0 |
| 2000-01-20 09:35:00 | AAPL | Stock | 1.0363 | 1.0424 | 1.0313 | 1.0396 | 28067200.0 |
| 2000-01-20 09:36:00 | AAPL | Stock | 1.0396 | 1.0424 | 1.0329 | 1.0396 | 15176000.0 |
| 2000-01-20 09:37:00 | AAPL | Stock | 1.0385 | 1.0491 | 1.0385 | 1.0488 | 9934400.0 |
| 2000-01-20 09:38:00 | AAPL | Stock | 1.0446 | 1.0491 | 1.0368 | 1.0469 | 17270400.0 |
| 2000-01-20 09:39:00 | AAPL | Stock | 1.0474 | 1.0491 | 1.0413 | 1.0435 | 17348800.0 |
| 2000-01-20 09:40:00 | AAPL | Stock | 1.0435 | 1.0469 | 1.0368 | 1.0407 | 28492800.0 |
| 2000-01-20 09:41:00 | AAPL | Stock | 1.0407 | 1.0446 | 1.0379 | 1.0402 | 13787200.0 |
| 2000-01-20 09:42:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0313 | 1.0379 | 17348800.0 |
| 2000-01-20 09:43:00 | AAPL | Stock | 1.0385 | 1.0446 | 1.0335 | 1.0352 | 20563200.0 |
| 2000-01-20 09:44:00 | AAPL | Stock | 1.0352 | 1.0379 | 1.034 | 1.0352 | 13888000.0 |
| 2000-01-20 09:45:00 | AAPL | Stock | 1.0377 | 1.0379 | 1.0352 | 1.0357 | 5880000.0 |
| 2000-01-20 09:46:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0346 | 1.0352 | 9508800.0 |
| 2000-01-20 09:47:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0318 | 1.0318 | 6540800.0 |
| 2000-01-20 09:48:00 | AAPL | Stock | 1.0301 | 1.0352 | 1.0301 | 1.0318 | 5969600.0 |
| 2000-01-20 09:49:00 | AAPL | Stock | 1.0329 | 1.0343 | 1.0313 | 1.0313 | 3584000.0 |
| 2000-01-20 09:50:00 | AAPL | Stock | 1.0335 | 1.0338 | 1.0313 | 1.0318 | 15422400.0 |
| 2000-01-20 09:51:00 | AAPL | Stock | 1.0313 | 1.0335 | 1.0296 | 1.0301 | 10180800.0 |
| 2000-01-20 09:52:00 | AAPL | Stock | 1.0296 | 1.0329 | 1.0268 | 1.0301 | 9094400.0 |
| 2000-01-20 09:53:00 | AAPL | Stock | 1.0301 | 1.0318 | 1.029 | 1.0301 | 5846400.0 |
| 2000-01-20 09:54:00 | AAPL | Stock | 1.0301 | 1.0335 | 1.029 | 1.0335 | 12667200.0 |
| 2000-01-20 09:55:00 | AAPL | Stock | 1.0335 | 1.0379 | 1.0301 | 1.0357 | 9721600.0 |
| 2000-01-20 09:56:00 | AAPL | Stock | 1.0357 | 1.0407 | 1.0346 | 1.0396 | 7616000.0 |
| 2000-01-20 09:57:00 | AAPL | Stock | 1.0357 | 1.0402 | 1.0313 | 1.0368 | 13440000.0 |
| 2000-01-20 09:58:00 | AAPL | Stock | 1.0368 | 1.0396 | 1.0357 | 1.0363 | 8120000.0 |
| 2000-01-20 09:59:00 | AAPL | Stock | 1.0363 | 1.0402 | 1.0363 | 1.0368 | 7582400.0 |
| 2000-01-20 10:00:00 | AAPL | Stock | 1.0379 | 1.0402 | 1.0377 | 1.0402 | 8803200.0 |
| 2000-01-20 10:01:00 | AAPL | Stock | 1.0402 | 1.0452 | 1.0379 | 1.0435 | 14515200.0 |
| 2000-01-20 10:02:00 | AAPL | Stock | 1.0402 | 1.0446 | 1.0402 | 1.043 | 3606400.0 |
| 2000-01-20 10:03:00 | AAPL | Stock | 1.0446 | 1.048 | 1.0413 | 1.0469 | 14392000.0 |
| 2000-01-20 10:04:00 | AAPL | Stock | 1.048 | 1.0513 | 1.0424 | 1.0508 | 14302400.0 |
| 2000-01-20 10:05:00 | AAPL | Stock | 1.0491 | 1.0513 | 1.0446 | 1.0485 | 7694400.0 |
| 2000-01-20 10:06:00 | AAPL | Stock | 1.048 | 1.0502 | 1.0458 | 1.0463 | 17472000.0 |
| 2000-01-20 10:07:00 | AAPL | Stock | 1.0463 | 1.0513 | 1.0463 | 1.0497 | 7884800.0 |
| 2000-01-20 10:08:00 | AAPL | Stock | 1.048 | 1.0513 | 1.048 | 1.0502 | 13249600.0 |
| 2000-01-20 10:09:00 | AAPL | Stock | 1.0502 | 1.0513 | 1.0474 | 1.0474 | 8366400.0 |
| 2000-01-20 10:10:00 | AAPL | Stock | 1.0491 | 1.0502 | 1.0452 | 1.0458 | 3057600.0 |
| 2000-01-20 10:11:00 | AAPL | Stock | 1.0463 | 1.0485 | 1.0435 | 1.0435 | 7336000.0 |
| 2000-01-20 10:12:00 | AAPL | Stock | 1.0438 | 1.0469 | 1.0435 | 1.046 | 7515200.0 |
| 2000-01-20 10:13:00 | AAPL | Stock | 1.0441 | 1.0463 | 1.0441 | 1.0463 | 2710400.0 |
| 2000-01-20 10:14:00 | AAPL | Stock | 1.0458 | 1.0463 | 1.043 | 1.0441 | 3796800.0 |
| 2000-01-20 10:15:00 | AAPL | Stock | 1.0446 | 1.048 | 1.0441 | 1.0463 | 8892800.0 |
| 2000-01-20 10:16:00 | AAPL | Stock | 1.048 | 1.0491 | 1.0463 | 1.048 | 6876800.0 |
| 2000-01-20 10:17:00 | AAPL | Stock | 1.048 | 1.0491 | 1.0458 | 1.0458 | 6574400.0 |
| 2000-01-20 10:18:00 | AAPL | Stock | 1.0474 | 1.0485 | 1.0463 | 1.0463 | 3248000.0 |
| 2000-01-20 10:19:00 | AAPL | Stock | 1.0463 | 1.0485 | 1.0446 | 1.0446 | 2363200.0 |
> showing 50 of 212,004 rows — these rows as CSV