PREVIEW / stock_1min / 2001-08-06
file: by_date/stock_1min/2001/2001-08-06.parquet size: 2.9 MB rows: 237,759 symbols: 1,089
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-08-06 08:02:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 33600.0 |
| 2001-08-06 08:09:00 | AAPL | Stock | 0.3473 | 0.3473 | 0.3473 | 0.3473 | 5600.0 |
| 2001-08-06 08:57:00 | AAPL | Stock | 0.3429 | 0.3429 | 0.3429 | 0.3429 | 5600.0 |
| 2001-08-06 09:16:00 | AAPL | Stock | 0.3464 | 0.3464 | 0.3464 | 0.3464 | 56000.0 |
| 2001-08-06 09:18:00 | AAPL | Stock | 0.3463 | 0.3464 | 0.3463 | 0.3464 | 33600.0 |
| 2001-08-06 09:23:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 33600.0 |
| 2001-08-06 09:24:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 16800.0 |
| 2001-08-06 09:25:00 | AAPL | Stock | 0.3429 | 0.3463 | 0.3429 | 0.3429 | 168000.0 |
| 2001-08-06 09:26:00 | AAPL | Stock | 0.3429 | 0.3429 | 0.3429 | 0.3429 | 28000.0 |
| 2001-08-06 09:27:00 | AAPL | Stock | 0.3429 | 0.3429 | 0.342 | 0.342 | 302400.0 |
| 2001-08-06 09:29:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3398 | 0.3398 | 112000.0 |
| 2001-08-06 09:30:00 | AAPL | Stock | 0.34 | 0.3421 | 0.3393 | 0.3402 | 2654400.0 |
| 2001-08-06 09:31:00 | AAPL | Stock | 0.342 | 0.3443 | 0.3395 | 0.3443 | 1310400.0 |
| 2001-08-06 09:32:00 | AAPL | Stock | 0.3443 | 0.3461 | 0.3438 | 0.3461 | 1764000.0 |
| 2001-08-06 09:33:00 | AAPL | Stock | 0.3457 | 0.3457 | 0.3445 | 0.3457 | 403200.0 |
| 2001-08-06 09:34:00 | AAPL | Stock | 0.3457 | 0.3464 | 0.3457 | 0.3463 | 476000.0 |
| 2001-08-06 09:35:00 | AAPL | Stock | 0.3461 | 0.3464 | 0.3455 | 0.3464 | 369600.0 |
| 2001-08-06 09:36:00 | AAPL | Stock | 0.3461 | 0.3464 | 0.3454 | 0.3461 | 156800.0 |
| 2001-08-06 09:37:00 | AAPL | Stock | 0.3454 | 0.3459 | 0.3454 | 0.3454 | 207200.0 |
| 2001-08-06 09:38:00 | AAPL | Stock | 0.3459 | 0.347 | 0.3459 | 0.347 | 470400.0 |
| 2001-08-06 09:39:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3452 | 0.3464 | 235200.0 |
| 2001-08-06 09:40:00 | AAPL | Stock | 0.3454 | 0.3464 | 0.345 | 0.3464 | 296800.0 |
| 2001-08-06 09:41:00 | AAPL | Stock | 0.3464 | 0.3479 | 0.3464 | 0.3475 | 537600.0 |
| 2001-08-06 09:42:00 | AAPL | Stock | 0.3466 | 0.3507 | 0.3466 | 0.3507 | 935200.0 |
| 2001-08-06 09:43:00 | AAPL | Stock | 0.3507 | 0.3511 | 0.3491 | 0.3502 | 291200.0 |
| 2001-08-06 09:44:00 | AAPL | Stock | 0.35 | 0.3502 | 0.3466 | 0.3477 | 464800.0 |
| 2001-08-06 09:45:00 | AAPL | Stock | 0.3477 | 0.35 | 0.3477 | 0.3498 | 196000.0 |
| 2001-08-06 09:46:00 | AAPL | Stock | 0.3493 | 0.3496 | 0.3493 | 0.3493 | 72800.0 |
| 2001-08-06 09:47:00 | AAPL | Stock | 0.3498 | 0.35 | 0.3493 | 0.3498 | 392000.0 |
| 2001-08-06 09:48:00 | AAPL | Stock | 0.35 | 0.3502 | 0.3493 | 0.3495 | 207200.0 |
| 2001-08-06 09:49:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.3491 | 0.3493 | 151200.0 |
| 2001-08-06 09:50:00 | AAPL | Stock | 0.3491 | 0.3509 | 0.3491 | 0.3496 | 280000.0 |
| 2001-08-06 09:51:00 | AAPL | Stock | 0.3491 | 0.3498 | 0.3491 | 0.3493 | 123200.0 |
| 2001-08-06 09:52:00 | AAPL | Stock | 0.3489 | 0.3495 | 0.3486 | 0.3493 | 156800.0 |
| 2001-08-06 09:53:00 | AAPL | Stock | 0.3493 | 0.3495 | 0.3493 | 0.3495 | 67200.0 |
| 2001-08-06 09:54:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.348 | 0.348 | 252000.0 |
| 2001-08-06 09:55:00 | AAPL | Stock | 0.3477 | 0.3479 | 0.3471 | 0.3475 | 179200.0 |
| 2001-08-06 09:56:00 | AAPL | Stock | 0.3479 | 0.3484 | 0.3477 | 0.3484 | 67200.0 |
| 2001-08-06 09:57:00 | AAPL | Stock | 0.3482 | 0.3493 | 0.348 | 0.348 | 50400.0 |
| 2001-08-06 09:59:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3479 | 0.348 | 184800.0 |
| 2001-08-06 10:00:00 | AAPL | Stock | 0.3488 | 0.35 | 0.3482 | 0.3484 | 207200.0 |
| 2001-08-06 10:01:00 | AAPL | Stock | 0.3488 | 0.3495 | 0.3488 | 0.3495 | 28000.0 |
| 2001-08-06 10:02:00 | AAPL | Stock | 0.3489 | 0.3495 | 0.3489 | 0.3495 | 22400.0 |
| 2001-08-06 10:03:00 | AAPL | Stock | 0.3493 | 0.3498 | 0.3491 | 0.3495 | 532000.0 |
| 2001-08-06 10:04:00 | AAPL | Stock | 0.3495 | 0.3498 | 0.3491 | 0.3495 | 408800.0 |
| 2001-08-06 10:05:00 | AAPL | Stock | 0.3491 | 0.3498 | 0.3491 | 0.3498 | 84000.0 |
| 2001-08-06 10:06:00 | AAPL | Stock | 0.3498 | 0.3498 | 0.3495 | 0.3496 | 112000.0 |
| 2001-08-06 10:07:00 | AAPL | Stock | 0.3496 | 0.3498 | 0.3495 | 0.3496 | 285600.0 |
| 2001-08-06 10:08:00 | AAPL | Stock | 0.3495 | 0.3495 | 0.3486 | 0.3491 | 190400.0 |
| 2001-08-06 10:09:00 | AAPL | Stock | 0.3491 | 0.3495 | 0.3491 | 0.3495 | 67200.0 |
> showing 50 of 237,759 rows — these rows as CSV