PREVIEW / stock_1min / 2004-08-10
file: by_date/stock_1min/2004/2004-08-10.parquet size: 5.9 MB rows: 490,663 symbols: 1,499
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-10 08:01:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 5600.0 |
| 2004-08-10 08:09:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5445 | 0.5445 | 14560.0 |
| 2004-08-10 08:10:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5445 | 0.5445 | 11200.0 |
| 2004-08-10 08:48:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5393 | 0.5413 | 95200.0 |
| 2004-08-10 08:55:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 28000.0 |
| 2004-08-10 09:27:00 | AAPL | Stock | 0.5416 | 0.5416 | 0.5391 | 0.5391 | 532000.0 |
| 2004-08-10 09:28:00 | AAPL | Stock | 0.5395 | 0.5395 | 0.5395 | 0.5395 | 22400.0 |
| 2004-08-10 09:29:00 | AAPL | Stock | 0.5395 | 0.5434 | 0.5395 | 0.5434 | 235200.0 |
| 2004-08-10 09:30:00 | AAPL | Stock | 0.5427 | 0.5441 | 0.5421 | 0.5434 | 1345176.0 |
| 2004-08-10 09:31:00 | AAPL | Stock | 0.5434 | 0.5438 | 0.5427 | 0.5429 | 520800.0 |
| 2004-08-10 09:32:00 | AAPL | Stock | 0.5432 | 0.5445 | 0.5425 | 0.5441 | 1112104.0 |
| 2004-08-10 09:33:00 | AAPL | Stock | 0.5441 | 0.5441 | 0.5422 | 0.543 | 722008.0 |
| 2004-08-10 09:34:00 | AAPL | Stock | 0.5432 | 0.5432 | 0.543 | 0.543 | 291200.0 |
| 2004-08-10 09:35:00 | AAPL | Stock | 0.543 | 0.5445 | 0.5429 | 0.5441 | 555520.0 |
| 2004-08-10 09:36:00 | AAPL | Stock | 0.5441 | 0.5446 | 0.5441 | 0.5445 | 534464.0 |
| 2004-08-10 09:37:00 | AAPL | Stock | 0.5445 | 0.5446 | 0.5443 | 0.5445 | 447104.0 |
| 2004-08-10 09:38:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5443 | 0.5445 | 415800.0 |
| 2004-08-10 09:39:00 | AAPL | Stock | 0.5443 | 0.5445 | 0.5441 | 0.5443 | 303912.0 |
| 2004-08-10 09:40:00 | AAPL | Stock | 0.5443 | 0.5445 | 0.5439 | 0.5443 | 441224.0 |
| 2004-08-10 09:41:00 | AAPL | Stock | 0.5445 | 0.5446 | 0.5439 | 0.5446 | 380800.0 |
| 2004-08-10 09:42:00 | AAPL | Stock | 0.5446 | 0.5459 | 0.5445 | 0.5459 | 1067976.0 |
| 2004-08-10 09:43:00 | AAPL | Stock | 0.5459 | 0.5471 | 0.5455 | 0.5468 | 531048.0 |
| 2004-08-10 09:44:00 | AAPL | Stock | 0.5468 | 0.5468 | 0.5457 | 0.5459 | 604576.0 |
| 2004-08-10 09:45:00 | AAPL | Stock | 0.5459 | 0.5459 | 0.5446 | 0.5446 | 377888.0 |
| 2004-08-10 09:46:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5443 | 0.5443 | 464800.0 |
| 2004-08-10 09:47:00 | AAPL | Stock | 0.5443 | 0.5445 | 0.5441 | 0.5443 | 380800.0 |
| 2004-08-10 09:48:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5438 | 0.5438 | 1102024.0 |
| 2004-08-10 09:49:00 | AAPL | Stock | 0.5438 | 0.5441 | 0.5438 | 0.5438 | 561232.0 |
| 2004-08-10 09:50:00 | AAPL | Stock | 0.5436 | 0.5439 | 0.5429 | 0.5434 | 1052800.0 |
| 2004-08-10 09:51:00 | AAPL | Stock | 0.5434 | 0.5434 | 0.5429 | 0.5429 | 1013600.0 |
| 2004-08-10 09:52:00 | AAPL | Stock | 0.5427 | 0.5432 | 0.5423 | 0.5425 | 1022448.0 |
| 2004-08-10 09:53:00 | AAPL | Stock | 0.5427 | 0.5429 | 0.542 | 0.5429 | 481600.0 |
| 2004-08-10 09:54:00 | AAPL | Stock | 0.5427 | 0.5441 | 0.5427 | 0.5438 | 1276800.0 |
| 2004-08-10 09:55:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5434 | 0.5438 | 428400.0 |
| 2004-08-10 09:56:00 | AAPL | Stock | 0.5436 | 0.5445 | 0.5436 | 0.5441 | 1035160.0 |
| 2004-08-10 09:57:00 | AAPL | Stock | 0.5439 | 0.5441 | 0.5438 | 0.5439 | 238000.0 |
| 2004-08-10 09:58:00 | AAPL | Stock | 0.5438 | 0.5439 | 0.5438 | 0.5438 | 383600.0 |
| 2004-08-10 09:59:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5434 | 0.5436 | 344008.0 |
| 2004-08-10 10:00:00 | AAPL | Stock | 0.5434 | 0.5439 | 0.5434 | 0.5439 | 425992.0 |
| 2004-08-10 10:01:00 | AAPL | Stock | 0.5436 | 0.5443 | 0.5436 | 0.5441 | 980952.0 |
| 2004-08-10 10:02:00 | AAPL | Stock | 0.5443 | 0.5444 | 0.5439 | 0.5444 | 674800.0 |
| 2004-08-10 10:03:00 | AAPL | Stock | 0.5441 | 0.5443 | 0.5439 | 0.5441 | 126000.0 |
| 2004-08-10 10:04:00 | AAPL | Stock | 0.5439 | 0.5441 | 0.5434 | 0.5434 | 405664.0 |
| 2004-08-10 10:05:00 | AAPL | Stock | 0.5434 | 0.5438 | 0.5432 | 0.5438 | 173600.0 |
| 2004-08-10 10:06:00 | AAPL | Stock | 0.5434 | 0.5443 | 0.5434 | 0.5438 | 924000.0 |
| 2004-08-10 10:07:00 | AAPL | Stock | 0.5434 | 0.5438 | 0.5434 | 0.5438 | 162400.0 |
| 2004-08-10 10:08:00 | AAPL | Stock | 0.5438 | 0.5441 | 0.5438 | 0.5439 | 431200.0 |
| 2004-08-10 10:09:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5434 | 0.5434 | 201600.0 |
| 2004-08-10 10:10:00 | AAPL | Stock | 0.5436 | 0.5438 | 0.5434 | 0.5436 | 473200.0 |
| 2004-08-10 10:11:00 | AAPL | Stock | 0.5436 | 0.5439 | 0.5432 | 0.5438 | 803320.0 |
> showing 50 of 490,663 rows — these rows as CSV