PREVIEW / stock_1min / 2006-07-05
file: by_date/stock_1min/2006/2006-07-05.parquet size: 8.8 MB rows: 725,482 symbols: 1,893
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-05 06:26:00 | AAPL | Stock | 2.0518 | 2.0696 | 2.0429 | 2.0696 | 12600.0 |
| 2006-07-05 08:00:00 | AAPL | Stock | 2.0664 | 2.0664 | 2.0664 | 2.0664 | 15960.0 |
| 2006-07-05 08:04:00 | AAPL | Stock | 2.0646 | 2.0646 | 2.0646 | 2.0646 | 5600.0 |
| 2006-07-05 08:06:00 | AAPL | Stock | 2.0636 | 2.0636 | 2.0636 | 2.0636 | 5600.0 |
| 2006-07-05 08:08:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0575 | 2.0575 | 5600.0 |
| 2006-07-05 08:09:00 | AAPL | Stock | 2.0579 | 2.0579 | 2.0579 | 2.0579 | 8400.0 |
| 2006-07-05 08:10:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0575 | 2.0575 | 18200.0 |
| 2006-07-05 08:11:00 | AAPL | Stock | 2.0579 | 2.0579 | 2.0571 | 2.0571 | 190176.0 |
| 2006-07-05 08:12:00 | AAPL | Stock | 2.0561 | 2.0561 | 2.0546 | 2.0546 | 49000.0 |
| 2006-07-05 08:13:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 28000.0 |
| 2006-07-05 08:14:00 | AAPL | Stock | 2.0579 | 2.0579 | 2.0579 | 2.0579 | 2800.0 |
| 2006-07-05 08:18:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0575 | 2.0575 | 18200.0 |
| 2006-07-05 08:21:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0575 | 2.0575 | 2800.0 |
| 2006-07-05 08:24:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 5600.0 |
| 2006-07-05 08:25:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 14000.0 |
| 2006-07-05 08:26:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 36400.0 |
| 2006-07-05 08:27:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 39200.0 |
| 2006-07-05 08:28:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 16800.0 |
| 2006-07-05 08:29:00 | AAPL | Stock | 2.0536 | 2.0536 | 2.0536 | 2.0536 | 11788.0 |
| 2006-07-05 08:30:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 28000.0 |
| 2006-07-05 08:31:00 | AAPL | Stock | 2.0554 | 2.0575 | 2.0554 | 2.0575 | 36400.0 |
| 2006-07-05 08:33:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 28000.0 |
| 2006-07-05 08:34:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0536 | 2.0554 | 33600.0 |
| 2006-07-05 08:35:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 8400.0 |
| 2006-07-05 08:36:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 8400.0 |
| 2006-07-05 08:37:00 | AAPL | Stock | 2.0536 | 2.0554 | 2.0536 | 2.0554 | 22988.0 |
| 2006-07-05 08:45:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 19600.0 |
| 2006-07-05 08:49:00 | AAPL | Stock | 2.0554 | 2.0554 | 2.0554 | 2.0554 | 8148.0 |
| 2006-07-05 08:50:00 | AAPL | Stock | 2.0557 | 2.0557 | 2.0557 | 2.0557 | 14000.0 |
| 2006-07-05 08:54:00 | AAPL | Stock | 2.055 | 2.055 | 2.055 | 2.055 | 8400.0 |
| 2006-07-05 08:57:00 | AAPL | Stock | 2.0546 | 2.0546 | 2.05 | 2.05 | 76188.0 |
| 2006-07-05 08:58:00 | AAPL | Stock | 2.05 | 2.05 | 2.05 | 2.05 | 36400.0 |
| 2006-07-05 09:00:00 | AAPL | Stock | 2.05 | 2.05 | 2.05 | 2.05 | 27300.0 |
| 2006-07-05 09:02:00 | AAPL | Stock | 2.05 | 2.05 | 2.05 | 2.05 | 11200.0 |
| 2006-07-05 09:03:00 | AAPL | Stock | 2.05 | 2.05 | 2.0464 | 2.0464 | 86828.0 |
| 2006-07-05 09:04:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 56000.0 |
| 2006-07-05 09:05:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0464 | 2.0464 | 58800.0 |
| 2006-07-05 09:07:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 7280.0 |
| 2006-07-05 09:08:00 | AAPL | Stock | 2.0482 | 2.05 | 2.0482 | 2.05 | 5852.0 |
| 2006-07-05 09:09:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 33600.0 |
| 2006-07-05 09:10:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 5768.0 |
| 2006-07-05 09:11:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 7000.0 |
| 2006-07-05 09:12:00 | AAPL | Stock | 2.0471 | 2.0471 | 2.0468 | 2.0468 | 12348.0 |
| 2006-07-05 09:13:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 13300.0 |
| 2006-07-05 09:14:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0464 | 2.0464 | 42000.0 |
| 2006-07-05 09:15:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 249200.0 |
| 2006-07-05 09:17:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 42000.0 |
| 2006-07-05 09:19:00 | AAPL | Stock | 2.0464 | 2.0464 | 2.0464 | 2.0464 | 15148.0 |
| 2006-07-05 09:20:00 | AAPL | Stock | 2.0468 | 2.0468 | 2.0407 | 2.0425 | 152600.0 |
| 2006-07-05 09:21:00 | AAPL | Stock | 2.0421 | 2.0461 | 2.0421 | 2.0446 | 120400.0 |
> showing 50 of 725,482 rows — these rows as CSV