PREVIEW / stock_5min / 2004-07-19
file: by_date/stock_5min/2004/2004-07-19.parquet size: 2.4 MB rows: 177,034 symbols: 1,798
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-19 08:30:00 | AAPL | Stock | 0.5754 | 0.5754 | 0.5714 | 0.5714 | 195440.0 |
| 2004-07-19 08:35:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5732 | 0.5732 | 56000.0 |
| 2004-07-19 08:40:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5714 | 0.5714 | 190400.0 |
| 2004-07-19 08:45:00 | AAPL | Stock | 0.5723 | 0.5723 | 0.5723 | 0.5723 | 16800.0 |
| 2004-07-19 08:50:00 | AAPL | Stock | 0.5714 | 0.5732 | 0.5714 | 0.5714 | 84000.0 |
| 2004-07-19 08:55:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.57 | 0.5714 | 366800.0 |
| 2004-07-19 09:00:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 56000.0 |
| 2004-07-19 09:05:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 106400.0 |
| 2004-07-19 09:15:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5714 | 0.5714 | 336000.0 |
| 2004-07-19 09:20:00 | AAPL | Stock | 0.5716 | 0.5723 | 0.5714 | 0.5716 | 184240.0 |
| 2004-07-19 09:25:00 | AAPL | Stock | 0.5714 | 0.5734 | 0.5707 | 0.5723 | 2539824.0 |
| 2004-07-19 09:30:00 | AAPL | Stock | 0.5723 | 0.5723 | 0.5659 | 0.5705 | 30106328.0 |
| 2004-07-19 09:35:00 | AAPL | Stock | 0.5704 | 0.572 | 0.5695 | 0.57 | 20064912.0 |
| 2004-07-19 09:40:00 | AAPL | Stock | 0.5698 | 0.5702 | 0.5686 | 0.5696 | 19947144.0 |
| 2004-07-19 09:45:00 | AAPL | Stock | 0.5696 | 0.5716 | 0.5688 | 0.5714 | 18321128.0 |
| 2004-07-19 09:50:00 | AAPL | Stock | 0.5714 | 0.5714 | 0.5696 | 0.5698 | 8689576.0 |
| 2004-07-19 09:55:00 | AAPL | Stock | 0.5698 | 0.5704 | 0.5689 | 0.5698 | 9417072.0 |
| 2004-07-19 10:00:00 | AAPL | Stock | 0.5698 | 0.57 | 0.5695 | 0.5696 | 7104272.0 |
| 2004-07-19 10:05:00 | AAPL | Stock | 0.5696 | 0.5705 | 0.5693 | 0.5704 | 4466392.0 |
| 2004-07-19 10:10:00 | AAPL | Stock | 0.5705 | 0.5711 | 0.5698 | 0.5711 | 3674328.0 |
| 2004-07-19 10:15:00 | AAPL | Stock | 0.5709 | 0.5714 | 0.5705 | 0.5707 | 9617272.0 |
| 2004-07-19 10:20:00 | AAPL | Stock | 0.5708 | 0.5716 | 0.5705 | 0.5709 | 4185496.0 |
| 2004-07-19 10:25:00 | AAPL | Stock | 0.5711 | 0.5711 | 0.5698 | 0.57 | 10399984.0 |
| 2004-07-19 10:30:00 | AAPL | Stock | 0.57 | 0.5702 | 0.5686 | 0.5695 | 11488680.0 |
| 2004-07-19 10:35:00 | AAPL | Stock | 0.5696 | 0.5707 | 0.5689 | 0.57 | 5080768.0 |
| 2004-07-19 10:40:00 | AAPL | Stock | 0.5704 | 0.5707 | 0.5698 | 0.5705 | 3145912.0 |
| 2004-07-19 10:45:00 | AAPL | Stock | 0.57 | 0.5716 | 0.57 | 0.5713 | 4032448.0 |
| 2004-07-19 10:50:00 | AAPL | Stock | 0.5716 | 0.5723 | 0.5711 | 0.5716 | 7109872.0 |
| 2004-07-19 10:55:00 | AAPL | Stock | 0.5718 | 0.5732 | 0.5714 | 0.5727 | 8649480.0 |
| 2004-07-19 11:00:00 | AAPL | Stock | 0.573 | 0.5738 | 0.5725 | 0.5736 | 2758560.0 |
| 2004-07-19 11:05:00 | AAPL | Stock | 0.5732 | 0.5734 | 0.572 | 0.5732 | 5750528.0 |
| 2004-07-19 11:10:00 | AAPL | Stock | 0.5732 | 0.5741 | 0.573 | 0.5741 | 2464280.0 |
| 2004-07-19 11:15:00 | AAPL | Stock | 0.5741 | 0.575 | 0.5736 | 0.5748 | 6938680.0 |
| 2004-07-19 11:20:00 | AAPL | Stock | 0.575 | 0.5754 | 0.5739 | 0.5748 | 8610728.0 |
| 2004-07-19 11:25:00 | AAPL | Stock | 0.5748 | 0.575 | 0.5743 | 0.5743 | 3172904.0 |
| 2004-07-19 11:30:00 | AAPL | Stock | 0.5745 | 0.5748 | 0.5738 | 0.5743 | 3340344.0 |
| 2004-07-19 11:35:00 | AAPL | Stock | 0.5741 | 0.5743 | 0.573 | 0.5734 | 2586416.0 |
| 2004-07-19 11:40:00 | AAPL | Stock | 0.573 | 0.5732 | 0.5714 | 0.5714 | 5631640.0 |
| 2004-07-19 11:45:00 | AAPL | Stock | 0.5716 | 0.5724 | 0.5711 | 0.5718 | 26520200.0 |
| 2004-07-19 11:50:00 | AAPL | Stock | 0.5716 | 0.5725 | 0.5714 | 0.5723 | 3295712.0 |
| 2004-07-19 11:55:00 | AAPL | Stock | 0.5723 | 0.5727 | 0.5707 | 0.5713 | 2663640.0 |
| 2004-07-19 12:00:00 | AAPL | Stock | 0.5714 | 0.5723 | 0.5714 | 0.5718 | 4319728.0 |
| 2004-07-19 12:05:00 | AAPL | Stock | 0.5716 | 0.5725 | 0.5713 | 0.5721 | 4684680.0 |
| 2004-07-19 12:10:00 | AAPL | Stock | 0.5721 | 0.5725 | 0.5705 | 0.5716 | 13607104.0 |
| 2004-07-19 12:15:00 | AAPL | Stock | 0.5716 | 0.572 | 0.5711 | 0.5713 | 1335880.0 |
| 2004-07-19 12:20:00 | AAPL | Stock | 0.5711 | 0.5716 | 0.5705 | 0.5714 | 4833864.0 |
| 2004-07-19 12:25:00 | AAPL | Stock | 0.5707 | 0.5714 | 0.5707 | 0.5714 | 2147264.0 |
| 2004-07-19 12:30:00 | AAPL | Stock | 0.5713 | 0.5714 | 0.5698 | 0.5707 | 2857008.0 |
| 2004-07-19 12:35:00 | AAPL | Stock | 0.5705 | 0.5707 | 0.5691 | 0.57 | 8709288.0 |
| 2004-07-19 12:40:00 | AAPL | Stock | 0.57 | 0.5704 | 0.5696 | 0.5696 | 3497648.0 |
> showing 50 of 177,034 rows — these rows as CSV