PREVIEW / stock_5min / 2001-01-19
file: by_date/stock_5min/2001/2001-01-19.parquet size: 1.3 MB rows: 100,799 symbols: 1,261
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-01-19 08:00:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3415 | 0.3415 | 117600.0 |
| 2001-01-19 08:05:00 | AAPL | Stock | 0.3504 | 0.3571 | 0.3504 | 0.3571 | 1601600.0 |
| 2001-01-19 08:10:00 | AAPL | Stock | 0.356 | 0.356 | 0.3516 | 0.3516 | 224000.0 |
| 2001-01-19 08:15:00 | AAPL | Stock | 0.3527 | 0.3571 | 0.3504 | 0.3527 | 705600.0 |
| 2001-01-19 08:20:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3504 | 0.3504 | 168000.0 |
| 2001-01-19 08:25:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3449 | 0.3527 | 688800.0 |
| 2001-01-19 08:30:00 | AAPL | Stock | 0.3488 | 0.3488 | 0.3438 | 0.3449 | 308000.0 |
| 2001-01-19 08:35:00 | AAPL | Stock | 0.3449 | 0.3449 | 0.3438 | 0.3438 | 632800.0 |
| 2001-01-19 08:40:00 | AAPL | Stock | 0.3449 | 0.346 | 0.3449 | 0.3449 | 145600.0 |
| 2001-01-19 08:45:00 | AAPL | Stock | 0.346 | 0.346 | 0.346 | 0.346 | 16800.0 |
| 2001-01-19 08:50:00 | AAPL | Stock | 0.346 | 0.3482 | 0.3449 | 0.3482 | 201600.0 |
| 2001-01-19 08:55:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3415 | 0.3504 | 599200.0 |
| 2001-01-19 09:00:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3471 | 0.3482 | 330400.0 |
| 2001-01-19 09:05:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3482 | 0.3504 | 196000.0 |
| 2001-01-19 09:10:00 | AAPL | Stock | 0.3504 | 0.3516 | 0.3504 | 0.3504 | 548800.0 |
| 2001-01-19 09:15:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3415 | 0.346 | 616000.0 |
| 2001-01-19 09:20:00 | AAPL | Stock | 0.3449 | 0.3449 | 0.3415 | 0.3438 | 1288000.0 |
| 2001-01-19 09:25:00 | AAPL | Stock | 0.3438 | 0.3482 | 0.3426 | 0.3471 | 1859200.0 |
| 2001-01-19 09:30:00 | AAPL | Stock | 0.3471 | 0.3493 | 0.3438 | 0.3449 | 35532000.0 |
| 2001-01-19 09:35:00 | AAPL | Stock | 0.346 | 0.3471 | 0.3426 | 0.3438 | 15741600.0 |
| 2001-01-19 09:40:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3415 | 0.3415 | 13221600.0 |
| 2001-01-19 09:45:00 | AAPL | Stock | 0.3415 | 0.346 | 0.3404 | 0.3426 | 24673600.0 |
| 2001-01-19 09:50:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3359 | 0.3371 | 31634400.0 |
| 2001-01-19 09:55:00 | AAPL | Stock | 0.3371 | 0.3404 | 0.3359 | 0.3404 | 13048000.0 |
| 2001-01-19 10:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3382 | 0.3393 | 14420000.0 |
| 2001-01-19 10:05:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3371 | 0.3382 | 12336800.0 |
| 2001-01-19 10:10:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3337 | 0.3348 | 15170400.0 |
| 2001-01-19 10:15:00 | AAPL | Stock | 0.3348 | 0.3359 | 0.3337 | 0.3348 | 7582400.0 |
| 2001-01-19 10:20:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3348 | 0.3359 | 16111200.0 |
| 2001-01-19 10:25:00 | AAPL | Stock | 0.3359 | 0.3393 | 0.3359 | 0.3393 | 9895200.0 |
| 2001-01-19 10:30:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3371 | 0.3404 | 4720800.0 |
| 2001-01-19 10:35:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3382 | 0.3393 | 15428000.0 |
| 2001-01-19 10:40:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3393 | 13070400.0 |
| 2001-01-19 10:45:00 | AAPL | Stock | 0.3398 | 0.3404 | 0.3371 | 0.3371 | 4827200.0 |
| 2001-01-19 10:50:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3371 | 0.3393 | 4894400.0 |
| 2001-01-19 10:55:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3371 | 0.3371 | 3662400.0 |
| 2001-01-19 11:00:00 | AAPL | Stock | 0.3371 | 0.3387 | 0.3371 | 0.3382 | 3096800.0 |
| 2001-01-19 11:05:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3359 | 0.3393 | 6339200.0 |
| 2001-01-19 11:10:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3404 | 3584000.0 |
| 2001-01-19 11:15:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3393 | 0.3404 | 14560000.0 |
| 2001-01-19 11:20:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3393 | 0.3404 | 5017600.0 |
| 2001-01-19 11:25:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3382 | 0.3393 | 5919200.0 |
| 2001-01-19 11:30:00 | AAPL | Stock | 0.3387 | 0.3404 | 0.3382 | 0.3382 | 9273600.0 |
| 2001-01-19 11:35:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3348 | 0.3371 | 9688000.0 |
| 2001-01-19 11:40:00 | AAPL | Stock | 0.3359 | 0.3382 | 0.3348 | 0.3382 | 4944800.0 |
| 2001-01-19 11:45:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3359 | 0.3382 | 7414400.0 |
| 2001-01-19 11:50:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3371 | 0.3382 | 5768000.0 |
| 2001-01-19 11:55:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3382 | 0.3393 | 5549600.0 |
| 2001-01-19 12:00:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3393 | 0.3404 | 5549600.0 |
| 2001-01-19 12:05:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3393 | 0.3404 | 397600.0 |
> showing 50 of 100,799 rows — these rows as CSV