PREVIEW / stock_1min / 2008-06-30
file: by_date/stock_1min/2008/2008-06-30.parquet size: 13.3 MB rows: 1,067,951 symbols: 2,727
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-30 04:23:00 | AAPL | Stock | 6.0664 | 6.0664 | 6.0664 | 6.0664 | 2800.0 |
| 2008-06-30 05:21:00 | AAPL | Stock | 6.0239 | 6.0239 | 6.0239 | 6.0239 | 8400.0 |
| 2008-06-30 06:52:00 | AAPL | Stock | 6.0211 | 6.0336 | 6.0211 | 6.0336 | 39200.0 |
| 2008-06-30 06:56:00 | AAPL | Stock | 6.0364 | 6.0364 | 6.0364 | 6.0364 | 80472.0 |
| 2008-06-30 07:01:00 | AAPL | Stock | 6.0318 | 6.0364 | 6.0318 | 6.0364 | 20328.0 |
| 2008-06-30 07:04:00 | AAPL | Stock | 6.0311 | 6.0311 | 6.0311 | 6.0311 | 2800.0 |
| 2008-06-30 07:05:00 | AAPL | Stock | 6.0261 | 6.0261 | 6.0261 | 6.0261 | 5600.0 |
| 2008-06-30 07:18:00 | AAPL | Stock | 6.0332 | 6.0332 | 6.0332 | 6.0332 | 2800.0 |
| 2008-06-30 07:21:00 | AAPL | Stock | 6.0221 | 6.0568 | 6.0221 | 6.0568 | 22400.0 |
| 2008-06-30 07:24:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 9240.0 |
| 2008-06-30 07:26:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 14000.0 |
| 2008-06-30 07:52:00 | AAPL | Stock | 6.0418 | 6.0418 | 6.0418 | 6.0418 | 5600.0 |
| 2008-06-30 07:53:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 19600.0 |
| 2008-06-30 07:56:00 | AAPL | Stock | 6.0211 | 6.0211 | 6.0211 | 6.0211 | 12040.0 |
| 2008-06-30 08:00:00 | AAPL | Stock | 6.0357 | 6.0464 | 6.0232 | 6.025 | 34384.0 |
| 2008-06-30 08:01:00 | AAPL | Stock | 6.0389 | 6.0389 | 6.0389 | 6.0389 | 5600.0 |
| 2008-06-30 08:02:00 | AAPL | Stock | 6.0393 | 6.0393 | 6.0271 | 6.0271 | 32480.0 |
| 2008-06-30 08:03:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 3220.0 |
| 2008-06-30 08:04:00 | AAPL | Stock | 6.0375 | 6.0432 | 6.0375 | 6.0432 | 5600.0 |
| 2008-06-30 08:05:00 | AAPL | Stock | 6.0375 | 6.0389 | 6.0368 | 6.0389 | 31472.0 |
| 2008-06-30 08:06:00 | AAPL | Stock | 6.0439 | 6.0439 | 6.0429 | 6.0429 | 12600.0 |
| 2008-06-30 08:08:00 | AAPL | Stock | 6.0396 | 6.0396 | 6.0396 | 6.0396 | 12908.0 |
| 2008-06-30 08:09:00 | AAPL | Stock | 6.0436 | 6.0436 | 6.0393 | 6.0393 | 25452.0 |
| 2008-06-30 08:11:00 | AAPL | Stock | 6.0421 | 6.0421 | 6.0421 | 6.0421 | 28000.0 |
| 2008-06-30 08:13:00 | AAPL | Stock | 6.0386 | 6.0429 | 6.0379 | 6.0429 | 16800.0 |
| 2008-06-30 08:14:00 | AAPL | Stock | 6.0393 | 6.0464 | 6.0393 | 6.0464 | 66360.0 |
| 2008-06-30 08:15:00 | AAPL | Stock | 6.05 | 6.05 | 6.05 | 6.05 | 8400.0 |
| 2008-06-30 08:16:00 | AAPL | Stock | 6.0532 | 6.0532 | 6.0532 | 6.0532 | 30800.0 |
| 2008-06-30 08:17:00 | AAPL | Stock | 6.0525 | 6.0525 | 6.0525 | 6.0525 | 2800.0 |
| 2008-06-30 08:18:00 | AAPL | Stock | 6.0521 | 6.0521 | 6.0496 | 6.0521 | 30800.0 |
| 2008-06-30 08:19:00 | AAPL | Stock | 6.0532 | 6.0571 | 6.0521 | 6.0536 | 87808.0 |
| 2008-06-30 08:20:00 | AAPL | Stock | 6.0536 | 6.0625 | 6.0536 | 6.0625 | 76020.0 |
| 2008-06-30 08:21:00 | AAPL | Stock | 6.0625 | 6.0625 | 6.0579 | 6.0579 | 19600.0 |
| 2008-06-30 08:22:00 | AAPL | Stock | 6.0571 | 6.0636 | 6.0557 | 6.0561 | 16800.0 |
| 2008-06-30 08:23:00 | AAPL | Stock | 6.0604 | 6.0604 | 6.0604 | 6.0604 | 2800.0 |
| 2008-06-30 08:24:00 | AAPL | Stock | 6.0632 | 6.0632 | 6.0607 | 6.0607 | 11200.0 |
| 2008-06-30 08:25:00 | AAPL | Stock | 6.0607 | 6.0607 | 6.0593 | 6.0604 | 58800.0 |
| 2008-06-30 08:26:00 | AAPL | Stock | 6.0604 | 6.0607 | 6.0604 | 6.0607 | 22400.0 |
| 2008-06-30 08:27:00 | AAPL | Stock | 6.0607 | 6.0668 | 6.0536 | 6.0643 | 199584.0 |
| 2008-06-30 08:28:00 | AAPL | Stock | 6.0664 | 6.0675 | 6.0639 | 6.0675 | 47600.0 |
| 2008-06-30 08:29:00 | AAPL | Stock | 6.0679 | 6.085 | 6.0671 | 6.0786 | 250460.0 |
| 2008-06-30 08:30:00 | AAPL | Stock | 6.0711 | 6.0714 | 6.0711 | 6.0714 | 36400.0 |
| 2008-06-30 08:31:00 | AAPL | Stock | 6.0696 | 6.0714 | 6.0675 | 6.0675 | 16800.0 |
| 2008-06-30 08:33:00 | AAPL | Stock | 6.0675 | 6.0746 | 6.0607 | 6.0607 | 216272.0 |
| 2008-06-30 08:34:00 | AAPL | Stock | 6.0643 | 6.0675 | 6.0643 | 6.0643 | 14000.0 |
| 2008-06-30 08:36:00 | AAPL | Stock | 6.0643 | 6.0643 | 6.0643 | 6.0643 | 11732.0 |
| 2008-06-30 08:37:00 | AAPL | Stock | 6.0643 | 6.0746 | 6.0643 | 6.0746 | 47740.0 |
| 2008-06-30 08:38:00 | AAPL | Stock | 6.0711 | 6.0718 | 6.0696 | 6.0696 | 31080.0 |
| 2008-06-30 08:39:00 | AAPL | Stock | 6.0696 | 6.0711 | 6.0696 | 6.0711 | 8400.0 |
| 2008-06-30 08:41:00 | AAPL | Stock | 6.0689 | 6.075 | 6.0689 | 6.0714 | 111440.0 |
> showing 50 of 1,067,951 rows — these rows as CSV