PREVIEW / stock_30min / 2006-09-26
file: by_date/stock_30min/2006/2006-09-26.parquet size: 934 KB rows: 51,006 symbols: 2,380
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-09-26 04:30:00 | AAPL | Stock | 2.7057 | 2.7057 | 2.7057 | 2.7057 | 5600.0 |
| 2006-09-26 06:30:00 | AAPL | Stock | 2.7 | 2.7 | 2.7 | 2.7 | 2800.0 |
| 2006-09-26 07:30:00 | AAPL | Stock | 2.7057 | 2.7196 | 2.7057 | 2.7196 | 300832.0 |
| 2006-09-26 08:00:00 | AAPL | Stock | 2.7179 | 2.7279 | 2.7054 | 2.7271 | 4685380.0 |
| 2006-09-26 08:30:00 | AAPL | Stock | 2.7268 | 2.7271 | 2.7221 | 2.7232 | 2184924.0 |
| 2006-09-26 09:00:00 | AAPL | Stock | 2.7232 | 2.7264 | 2.7161 | 2.7204 | 2228520.0 |
| 2006-09-26 09:30:00 | AAPL | Stock | 2.7207 | 2.7389 | 2.7179 | 2.7296 | 132685308.0 |
| 2006-09-26 10:00:00 | AAPL | Stock | 2.73 | 2.76 | 2.73 | 2.7511 | 150383520.0 |
| 2006-09-26 10:30:00 | AAPL | Stock | 2.7511 | 2.7536 | 2.7243 | 2.7464 | 70625128.0 |
| 2006-09-26 11:00:00 | AAPL | Stock | 2.7464 | 2.7568 | 2.7429 | 2.7536 | 62525988.0 |
| 2006-09-26 11:30:00 | AAPL | Stock | 2.7536 | 2.765 | 2.7464 | 2.7464 | 78411088.0 |
| 2006-09-26 12:00:00 | AAPL | Stock | 2.7464 | 2.7625 | 2.7436 | 2.7568 | 69237532.0 |
| 2006-09-26 12:30:00 | AAPL | Stock | 2.7571 | 2.7575 | 2.7461 | 2.7532 | 32131708.0 |
| 2006-09-26 13:00:00 | AAPL | Stock | 2.7532 | 2.7746 | 2.7507 | 2.7736 | 85891288.0 |
| 2006-09-26 13:30:00 | AAPL | Stock | 2.7739 | 2.7757 | 2.7564 | 2.7568 | 78272908.0 |
| 2006-09-26 14:00:00 | AAPL | Stock | 2.7568 | 2.7614 | 2.745 | 2.7579 | 70172648.0 |
| 2006-09-26 14:30:00 | AAPL | Stock | 2.7579 | 2.7739 | 2.7564 | 2.7696 | 68994604.0 |
| 2006-09-26 15:00:00 | AAPL | Stock | 2.7693 | 2.7743 | 2.7621 | 2.7689 | 66449880.0 |
| 2006-09-26 15:30:00 | AAPL | Stock | 2.7696 | 2.7779 | 2.7618 | 2.7764 | 107147824.0 |
| 2006-09-26 16:00:00 | AAPL | Stock | 2.7761 | 2.7771 | 2.7729 | 2.775 | 4121964.0 |
| 2006-09-26 16:30:00 | AAPL | Stock | 2.775 | 2.775 | 2.7718 | 2.7729 | 382172.0 |
| 2006-09-26 17:00:00 | AAPL | Stock | 2.7732 | 2.7764 | 2.7721 | 2.7764 | 425600.0 |
| 2006-09-26 17:30:00 | AAPL | Stock | 2.7743 | 2.775 | 2.7711 | 2.7732 | 121660.0 |
| 2006-09-26 18:00:00 | AAPL | Stock | 2.7732 | 2.7764 | 2.7729 | 2.7761 | 212128.0 |
| 2006-09-26 18:30:00 | AAPL | Stock | 2.7761 | 2.7761 | 2.7761 | 2.7761 | 5600.0 |
| 2006-09-26 19:00:00 | AAPL | Stock | 2.7764 | 2.7775 | 2.7764 | 2.7768 | 52920.0 |
| 2006-09-26 19:30:00 | AAPL | Stock | 2.7768 | 2.7768 | 2.775 | 2.775 | 50400.0 |
| 2006-09-26 06:30:00 | MSFT | Stock | 26.93 | 26.94 | 26.93 | 26.94 | 800.0 |
| 2006-09-26 07:30:00 | MSFT | Stock | 26.93 | 26.95 | 26.92 | 26.92 | 600.0 |
| 2006-09-26 08:00:00 | MSFT | Stock | 26.87 | 26.95 | 26.87 | 26.95 | 1300.0 |
| 2006-09-26 08:30:00 | MSFT | Stock | 26.96 | 26.96 | 26.93 | 26.93 | 134500.0 |
| 2006-09-26 09:00:00 | MSFT | Stock | 26.94 | 26.94 | 26.86 | 26.9 | 84852.0 |
| 2006-09-26 09:30:00 | MSFT | Stock | 26.91 | 27.06 | 26.88 | 26.959 | 6232908.0 |
| 2006-09-26 10:00:00 | MSFT | Stock | 26.96 | 27.2 | 26.93 | 27.13 | 5879667.0 |
| 2006-09-26 10:30:00 | MSFT | Stock | 27.14 | 27.19 | 27.11 | 27.17 | 3619529.0 |
| 2006-09-26 11:00:00 | MSFT | Stock | 27.17 | 27.2 | 27.12 | 27.143 | 2342280.0 |
| 2006-09-26 11:30:00 | MSFT | Stock | 27.14 | 27.17 | 27.1 | 27.16 | 3164519.0 |
| 2006-09-26 12:00:00 | MSFT | Stock | 27.16 | 27.24 | 27.11 | 27.21 | 2671295.0 |
| 2006-09-26 12:30:00 | MSFT | Stock | 27.2 | 27.25 | 27.12 | 27.21 | 2027135.0 |
| 2006-09-26 13:00:00 | MSFT | Stock | 27.21 | 27.25 | 27.12 | 27.24 | 2459443.0 |
| 2006-09-26 13:30:00 | MSFT | Stock | 27.25 | 27.32 | 27.22 | 27.28 | 4010790.0 |
| 2006-09-26 14:00:00 | MSFT | Stock | 27.272 | 27.283 | 27.15 | 27.19 | 3695709.0 |
| 2006-09-26 14:30:00 | MSFT | Stock | 27.19 | 27.28 | 27.18 | 27.25 | 5392765.0 |
| 2006-09-26 15:00:00 | MSFT | Stock | 27.25 | 27.27 | 27.15 | 27.18 | 2896779.0 |
| 2006-09-26 15:30:00 | MSFT | Stock | 27.17 | 27.25 | 27.15 | 27.24 | 6746886.0 |
| 2006-09-26 16:00:00 | MSFT | Stock | 27.25 | 27.26 | 27.2 | 27.21 | 192799.0 |
| 2006-09-26 16:30:00 | MSFT | Stock | 27.2 | 27.25 | 27.2 | 27.21 | 89846.0 |
| 2006-09-26 17:00:00 | MSFT | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 2000.0 |
| 2006-09-26 17:30:00 | MSFT | Stock | 27.23 | 27.25 | 27.19 | 27.19 | 99701.0 |
| 2006-09-26 18:00:00 | MSFT | Stock | 27.19 | 27.19 | 27.19 | 27.19 | 100.0 |
> showing 50 of 51,006 rows — these rows as CSV