PREVIEW / stock_1min / 2010-04-16
file: by_date/stock_1min/2010/2010-04-16.parquet size: 13.7 MB rows: 1,017,371 symbols: 2,830
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-16 04:32:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 3360.0 |
| 2010-04-16 04:33:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 2800.0 |
| 2010-04-16 04:35:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 14000.0 |
| 2010-04-16 04:46:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 5600.0 |
| 2010-04-16 05:13:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 4284.0 |
| 2010-04-16 05:22:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 2800.0 |
| 2010-04-16 06:02:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 2800.0 |
| 2010-04-16 06:17:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 2800.0 |
| 2010-04-16 06:37:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 2800.0 |
| 2010-04-16 07:04:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 2800.0 |
| 2010-04-16 07:06:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 28000.0 |
| 2010-04-16 07:16:00 | AAPL | Stock | 8.8661 | 8.8661 | 8.8661 | 8.8661 | 11900.0 |
| 2010-04-16 07:17:00 | AAPL | Stock | 8.8675 | 8.8675 | 8.8675 | 8.8675 | 5600.0 |
| 2010-04-16 07:18:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 2800.0 |
| 2010-04-16 07:21:00 | AAPL | Stock | 8.8675 | 8.8675 | 8.8675 | 8.8675 | 14000.0 |
| 2010-04-16 07:23:00 | AAPL | Stock | 8.8675 | 8.8675 | 8.8675 | 8.8675 | 8400.0 |
| 2010-04-16 07:24:00 | AAPL | Stock | 8.8675 | 8.8675 | 8.8675 | 8.8675 | 8680.0 |
| 2010-04-16 07:26:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8571 | 8.8571 | 2800.0 |
| 2010-04-16 07:33:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8632 | 8.8632 | 5600.0 |
| 2010-04-16 07:35:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8632 | 8.8632 | 2800.0 |
| 2010-04-16 07:38:00 | AAPL | Stock | 8.8536 | 8.8632 | 8.8536 | 8.8632 | 8400.0 |
| 2010-04-16 07:42:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8632 | 8.8632 | 2800.0 |
| 2010-04-16 07:50:00 | AAPL | Stock | 8.8625 | 8.8632 | 8.8625 | 8.8632 | 28000.0 |
| 2010-04-16 07:55:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8604 | 8.8604 | 2800.0 |
| 2010-04-16 07:56:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8604 | 8.8604 | 2800.0 |
| 2010-04-16 07:57:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8571 | 8.8571 | 8400.0 |
| 2010-04-16 07:58:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8571 | 8.8571 | 42000.0 |
| 2010-04-16 08:00:00 | AAPL | Stock | 8.8611 | 8.8632 | 8.8575 | 8.8625 | 29316.0 |
| 2010-04-16 08:01:00 | AAPL | Stock | 8.8586 | 8.8661 | 8.8582 | 8.8661 | 17360.0 |
| 2010-04-16 08:02:00 | AAPL | Stock | 8.8596 | 8.8636 | 8.8589 | 8.8636 | 29400.0 |
| 2010-04-16 08:03:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8607 | 8.8607 | 11200.0 |
| 2010-04-16 08:04:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 14000.0 |
| 2010-04-16 08:05:00 | AAPL | Stock | 8.865 | 8.8707 | 8.8639 | 8.8707 | 16800.0 |
| 2010-04-16 08:06:00 | AAPL | Stock | 8.8732 | 8.8754 | 8.8714 | 8.8714 | 173600.0 |
| 2010-04-16 08:07:00 | AAPL | Stock | 8.8714 | 8.8746 | 8.8679 | 8.8736 | 178192.0 |
| 2010-04-16 08:08:00 | AAPL | Stock | 8.875 | 8.875 | 8.8711 | 8.8711 | 114800.0 |
| 2010-04-16 08:09:00 | AAPL | Stock | 8.87 | 8.8732 | 8.8679 | 8.8679 | 25900.0 |
| 2010-04-16 08:10:00 | AAPL | Stock | 8.8679 | 8.8736 | 8.8679 | 8.8736 | 61432.0 |
| 2010-04-16 08:11:00 | AAPL | Stock | 8.8729 | 8.8729 | 8.8725 | 8.8725 | 5600.0 |
| 2010-04-16 08:12:00 | AAPL | Stock | 8.8729 | 8.8729 | 8.8725 | 8.8725 | 5600.0 |
| 2010-04-16 08:13:00 | AAPL | Stock | 8.8714 | 8.8721 | 8.8714 | 8.8721 | 5600.0 |
| 2010-04-16 08:14:00 | AAPL | Stock | 8.8721 | 8.8729 | 8.8696 | 8.8729 | 22204.0 |
| 2010-04-16 08:15:00 | AAPL | Stock | 8.8725 | 8.8725 | 8.8679 | 8.8721 | 84000.0 |
| 2010-04-16 08:16:00 | AAPL | Stock | 8.8711 | 8.8711 | 8.8711 | 8.8711 | 2800.0 |
| 2010-04-16 08:17:00 | AAPL | Stock | 8.8671 | 8.8671 | 8.8607 | 8.8614 | 51380.0 |
| 2010-04-16 08:18:00 | AAPL | Stock | 8.8607 | 8.8657 | 8.8571 | 8.8657 | 94500.0 |
| 2010-04-16 08:19:00 | AAPL | Stock | 8.8625 | 8.8625 | 8.8625 | 8.8625 | 2800.0 |
| 2010-04-16 08:20:00 | AAPL | Stock | 8.8661 | 8.8661 | 8.8661 | 8.8661 | 2800.0 |
| 2010-04-16 08:21:00 | AAPL | Stock | 8.8679 | 8.8679 | 8.8679 | 8.8679 | 2800.0 |
| 2010-04-16 08:22:00 | AAPL | Stock | 8.8689 | 8.8689 | 8.8679 | 8.8679 | 5600.0 |
> showing 50 of 1,017,371 rows — these rows as CSV