PREVIEW / stock_1min / 2001-11-07
file: by_date/stock_1min/2001/2001-11-07.parquet size: 3.5 MB rows: 281,571 symbols: 1,115
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-07 08:00:00 | AAPL | Stock | 0.347 | 0.347 | 0.347 | 0.347 | 39200.0 |
| 2001-11-07 08:02:00 | AAPL | Stock | 0.347 | 0.3489 | 0.347 | 0.3489 | 95200.0 |
| 2001-11-07 08:03:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.347 | 0.347 | 145600.0 |
| 2001-11-07 08:04:00 | AAPL | Stock | 0.347 | 0.347 | 0.347 | 0.347 | 22400.0 |
| 2001-11-07 08:07:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 28000.0 |
| 2001-11-07 08:10:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 22400.0 |
| 2001-11-07 08:12:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 22400.0 |
| 2001-11-07 08:18:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 5600.0 |
| 2001-11-07 08:26:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 95200.0 |
| 2001-11-07 08:28:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 28000.0 |
| 2001-11-07 08:31:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 5600.0 |
| 2001-11-07 08:33:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 28000.0 |
| 2001-11-07 08:43:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 168000.0 |
| 2001-11-07 08:47:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 44800.0 |
| 2001-11-07 08:48:00 | AAPL | Stock | 0.3477 | 0.3477 | 0.3473 | 0.3473 | 44800.0 |
| 2001-11-07 08:51:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 22400.0 |
| 2001-11-07 08:52:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3477 | 0.3477 | 240800.0 |
| 2001-11-07 08:56:00 | AAPL | Stock | 0.348 | 0.348 | 0.348 | 0.348 | 22400.0 |
| 2001-11-07 09:04:00 | AAPL | Stock | 0.348 | 0.3482 | 0.348 | 0.3482 | 112000.0 |
| 2001-11-07 09:05:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.348 | 0.348 | 16800.0 |
| 2001-11-07 09:15:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 112000.0 |
| 2001-11-07 09:17:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 56000.0 |
| 2001-11-07 09:19:00 | AAPL | Stock | 0.3466 | 0.3466 | 0.3466 | 0.3466 | 5600.0 |
| 2001-11-07 09:20:00 | AAPL | Stock | 0.3466 | 0.3466 | 0.3466 | 0.3466 | 39200.0 |
| 2001-11-07 09:21:00 | AAPL | Stock | 0.3468 | 0.3468 | 0.3468 | 0.3468 | 16800.0 |
| 2001-11-07 09:22:00 | AAPL | Stock | 0.3468 | 0.3468 | 0.3468 | 0.3468 | 28000.0 |
| 2001-11-07 09:24:00 | AAPL | Stock | 0.347 | 0.347 | 0.347 | 0.347 | 28000.0 |
| 2001-11-07 09:25:00 | AAPL | Stock | 0.347 | 0.347 | 0.347 | 0.347 | 509600.0 |
| 2001-11-07 09:26:00 | AAPL | Stock | 0.3466 | 0.3468 | 0.3466 | 0.3468 | 95200.0 |
| 2001-11-07 09:27:00 | AAPL | Stock | 0.3468 | 0.3468 | 0.3464 | 0.3464 | 50400.0 |
| 2001-11-07 09:28:00 | AAPL | Stock | 0.3468 | 0.3468 | 0.3468 | 0.3468 | 341600.0 |
| 2001-11-07 09:29:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3471 | 0.3471 | 56000.0 |
| 2001-11-07 09:30:00 | AAPL | Stock | 0.3475 | 0.3495 | 0.3475 | 0.3489 | 4748800.0 |
| 2001-11-07 09:31:00 | AAPL | Stock | 0.3482 | 0.3496 | 0.3475 | 0.3495 | 1590400.0 |
| 2001-11-07 09:32:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.348 | 0.3504 | 2828000.0 |
| 2001-11-07 09:33:00 | AAPL | Stock | 0.3482 | 0.3505 | 0.348 | 0.35 | 1215200.0 |
| 2001-11-07 09:34:00 | AAPL | Stock | 0.35 | 0.3502 | 0.3489 | 0.35 | 1204000.0 |
| 2001-11-07 09:35:00 | AAPL | Stock | 0.3498 | 0.3507 | 0.3493 | 0.3507 | 1433600.0 |
| 2001-11-07 09:36:00 | AAPL | Stock | 0.3507 | 0.3507 | 0.35 | 0.3505 | 515200.0 |
| 2001-11-07 09:37:00 | AAPL | Stock | 0.3507 | 0.3509 | 0.3502 | 0.3509 | 1036000.0 |
| 2001-11-07 09:38:00 | AAPL | Stock | 0.3509 | 0.3514 | 0.3509 | 0.3513 | 498400.0 |
| 2001-11-07 09:39:00 | AAPL | Stock | 0.3514 | 0.3521 | 0.3511 | 0.3511 | 1142400.0 |
| 2001-11-07 09:40:00 | AAPL | Stock | 0.3516 | 0.3518 | 0.3507 | 0.3509 | 1064000.0 |
| 2001-11-07 09:41:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.3504 | 0.3509 | 812000.0 |
| 2001-11-07 09:42:00 | AAPL | Stock | 0.3509 | 0.3509 | 0.3505 | 0.3509 | 1192800.0 |
| 2001-11-07 09:43:00 | AAPL | Stock | 0.3509 | 0.3511 | 0.3502 | 0.3511 | 2906400.0 |
| 2001-11-07 09:44:00 | AAPL | Stock | 0.3511 | 0.3513 | 0.3505 | 0.3505 | 694400.0 |
| 2001-11-07 09:45:00 | AAPL | Stock | 0.35 | 0.3504 | 0.3488 | 0.3488 | 1036000.0 |
| 2001-11-07 09:46:00 | AAPL | Stock | 0.3489 | 0.3507 | 0.3489 | 0.3502 | 812000.0 |
| 2001-11-07 09:47:00 | AAPL | Stock | 0.35 | 0.3507 | 0.3498 | 0.3504 | 560000.0 |
> showing 50 of 281,571 rows — these rows as CSV