PREVIEW / stock_1min / 2006-06-07
file: by_date/stock_1min/2006/2006-06-07.parquet size: 8.7 MB rows: 710,455 symbols: 1,867
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-06-07 07:46:00 | AAPL | Stock | 2.1375 | 2.1375 | 2.1375 | 2.1375 | 2800.0 |
| 2006-06-07 08:01:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1393 | 2.1393 | 22036.0 |
| 2006-06-07 08:03:00 | AAPL | Stock | 2.1393 | 2.1393 | 2.1393 | 2.1393 | 2800.0 |
| 2006-06-07 08:04:00 | AAPL | Stock | 2.1393 | 2.1429 | 2.1393 | 2.1421 | 39396.0 |
| 2006-06-07 08:06:00 | AAPL | Stock | 2.1439 | 2.1439 | 2.1429 | 2.1429 | 35952.0 |
| 2006-06-07 08:07:00 | AAPL | Stock | 2.1439 | 2.1461 | 2.1439 | 2.1461 | 11200.0 |
| 2006-06-07 08:08:00 | AAPL | Stock | 2.1461 | 2.1468 | 2.1461 | 2.1468 | 39200.0 |
| 2006-06-07 08:09:00 | AAPL | Stock | 2.1468 | 2.1468 | 2.1443 | 2.1443 | 131600.0 |
| 2006-06-07 08:10:00 | AAPL | Stock | 2.1443 | 2.1443 | 2.1443 | 2.1443 | 14000.0 |
| 2006-06-07 08:11:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 11200.0 |
| 2006-06-07 08:13:00 | AAPL | Stock | 2.1468 | 2.1543 | 2.1468 | 2.1543 | 5600.0 |
| 2006-06-07 08:16:00 | AAPL | Stock | 2.1496 | 2.15 | 2.1493 | 2.15 | 108164.0 |
| 2006-06-07 08:17:00 | AAPL | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 22400.0 |
| 2006-06-07 08:18:00 | AAPL | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 8400.0 |
| 2006-06-07 08:19:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 14000.0 |
| 2006-06-07 08:21:00 | AAPL | Stock | 2.1479 | 2.1482 | 2.1479 | 2.1482 | 25200.0 |
| 2006-06-07 08:24:00 | AAPL | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 44800.0 |
| 2006-06-07 08:26:00 | AAPL | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 61600.0 |
| 2006-06-07 08:27:00 | AAPL | Stock | 2.1507 | 2.1507 | 2.15 | 2.15 | 5600.0 |
| 2006-06-07 08:30:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1482 | 2.1482 | 5600.0 |
| 2006-06-07 08:31:00 | AAPL | Stock | 2.1454 | 2.1454 | 2.1454 | 2.1454 | 10528.0 |
| 2006-06-07 08:32:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 28000.0 |
| 2006-06-07 08:33:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 3500.0 |
| 2006-06-07 08:34:00 | AAPL | Stock | 2.1457 | 2.1457 | 2.1457 | 2.1457 | 21756.0 |
| 2006-06-07 08:35:00 | AAPL | Stock | 2.1461 | 2.1461 | 2.1461 | 2.1461 | 22344.0 |
| 2006-06-07 08:37:00 | AAPL | Stock | 2.1461 | 2.1461 | 2.1461 | 2.1461 | 8456.0 |
| 2006-06-07 08:40:00 | AAPL | Stock | 2.1446 | 2.1446 | 2.1446 | 2.1446 | 5600.0 |
| 2006-06-07 08:45:00 | AAPL | Stock | 2.1471 | 2.1471 | 2.1471 | 2.1471 | 11872.0 |
| 2006-06-07 08:47:00 | AAPL | Stock | 2.1468 | 2.1468 | 2.1468 | 2.1468 | 22400.0 |
| 2006-06-07 08:48:00 | AAPL | Stock | 2.1479 | 2.1479 | 2.1464 | 2.1464 | 100800.0 |
| 2006-06-07 08:49:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 5600.0 |
| 2006-06-07 08:50:00 | AAPL | Stock | 2.1468 | 2.1482 | 2.1468 | 2.1482 | 131600.0 |
| 2006-06-07 08:51:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1482 | 2.1482 | 36400.0 |
| 2006-06-07 08:52:00 | AAPL | Stock | 2.1489 | 2.15 | 2.1479 | 2.15 | 75544.0 |
| 2006-06-07 08:53:00 | AAPL | Stock | 2.1486 | 2.1486 | 2.1464 | 2.1464 | 95648.0 |
| 2006-06-07 08:54:00 | AAPL | Stock | 2.1475 | 2.1475 | 2.1475 | 2.1475 | 44800.0 |
| 2006-06-07 08:55:00 | AAPL | Stock | 2.1475 | 2.1475 | 2.1475 | 2.1475 | 5600.0 |
| 2006-06-07 08:56:00 | AAPL | Stock | 2.1471 | 2.1471 | 2.1471 | 2.1471 | 8400.0 |
| 2006-06-07 08:58:00 | AAPL | Stock | 2.1479 | 2.1479 | 2.1479 | 2.1479 | 8400.0 |
| 2006-06-07 08:59:00 | AAPL | Stock | 2.1464 | 2.1479 | 2.1464 | 2.1471 | 44800.0 |
| 2006-06-07 09:05:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 11088.0 |
| 2006-06-07 09:07:00 | AAPL | Stock | 2.1461 | 2.1461 | 2.1461 | 2.1461 | 28000.0 |
| 2006-06-07 09:09:00 | AAPL | Stock | 2.1471 | 2.1471 | 2.1471 | 2.1471 | 14000.0 |
| 2006-06-07 09:10:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1464 | 2.1464 | 36400.0 |
| 2006-06-07 09:11:00 | AAPL | Stock | 2.1464 | 2.1471 | 2.1464 | 2.1471 | 11200.0 |
| 2006-06-07 09:12:00 | AAPL | Stock | 2.1471 | 2.1471 | 2.1471 | 2.1471 | 2800.0 |
| 2006-06-07 09:13:00 | AAPL | Stock | 2.1471 | 2.1471 | 2.1471 | 2.1471 | 2800.0 |
| 2006-06-07 09:15:00 | AAPL | Stock | 2.1479 | 2.1479 | 2.1479 | 2.1479 | 2800.0 |
| 2006-06-07 09:17:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1482 | 2.1482 | 15596.0 |
| 2006-06-07 09:18:00 | AAPL | Stock | 2.1482 | 2.1482 | 2.1482 | 2.1482 | 12516.0 |
> showing 50 of 710,455 rows — these rows as CSV