PREVIEW / stock_5min / 2010-06-22
file: by_date/stock_5min/2010/2010-06-22.parquet size: 4.8 MB rows: 331,450 symbols: 3,468
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-06-22 04:45:00 | AAPL | Stock | 9.7118 | 9.7118 | 9.7118 | 9.7118 | 2800.0 |
| 2010-06-22 05:25:00 | AAPL | Stock | 9.6832 | 9.6832 | 9.6786 | 9.6786 | 28000.0 |
| 2010-06-22 05:40:00 | AAPL | Stock | 9.6793 | 9.6793 | 9.6793 | 9.6793 | 2800.0 |
| 2010-06-22 06:00:00 | AAPL | Stock | 9.6832 | 9.6832 | 9.6832 | 9.6832 | 7952.0 |
| 2010-06-22 06:25:00 | AAPL | Stock | 9.6832 | 9.6832 | 9.6832 | 9.6832 | 2800.0 |
| 2010-06-22 06:40:00 | AAPL | Stock | 9.6896 | 9.6896 | 9.6896 | 9.6896 | 19152.0 |
| 2010-06-22 06:50:00 | AAPL | Stock | 9.6661 | 9.6661 | 9.6661 | 9.6661 | 12488.0 |
| 2010-06-22 06:55:00 | AAPL | Stock | 9.6664 | 9.6664 | 9.6661 | 9.6661 | 9800.0 |
| 2010-06-22 07:00:00 | AAPL | Stock | 9.6689 | 9.6779 | 9.6689 | 9.6696 | 52080.0 |
| 2010-06-22 07:10:00 | AAPL | Stock | 9.6793 | 9.6875 | 9.6793 | 9.6875 | 117600.0 |
| 2010-06-22 07:15:00 | AAPL | Stock | 9.6882 | 9.6957 | 9.6875 | 9.6929 | 78400.0 |
| 2010-06-22 07:20:00 | AAPL | Stock | 9.6925 | 9.7054 | 9.6925 | 9.7054 | 25200.0 |
| 2010-06-22 07:25:00 | AAPL | Stock | 9.7021 | 9.7139 | 9.6946 | 9.6946 | 83832.0 |
| 2010-06-22 07:30:00 | AAPL | Stock | 9.6975 | 9.6982 | 9.6789 | 9.6804 | 145544.0 |
| 2010-06-22 07:35:00 | AAPL | Stock | 9.6814 | 9.6946 | 9.6814 | 9.6946 | 87500.0 |
| 2010-06-22 07:40:00 | AAPL | Stock | 9.6861 | 9.6925 | 9.6861 | 9.6925 | 16800.0 |
| 2010-06-22 07:45:00 | AAPL | Stock | 9.6875 | 9.6936 | 9.67 | 9.6864 | 148456.0 |
| 2010-06-22 07:50:00 | AAPL | Stock | 9.6721 | 9.6832 | 9.6679 | 9.6807 | 351400.0 |
| 2010-06-22 07:55:00 | AAPL | Stock | 9.6811 | 9.6943 | 9.6811 | 9.6925 | 173012.0 |
| 2010-06-22 08:00:00 | AAPL | Stock | 9.6936 | 9.6982 | 9.6825 | 9.6964 | 409276.0 |
| 2010-06-22 08:05:00 | AAPL | Stock | 9.6964 | 9.7107 | 9.6911 | 9.7107 | 481460.0 |
| 2010-06-22 08:10:00 | AAPL | Stock | 9.7107 | 9.7143 | 9.7018 | 9.7075 | 418012.0 |
| 2010-06-22 08:15:00 | AAPL | Stock | 9.7071 | 9.7089 | 9.7021 | 9.7071 | 114744.0 |
| 2010-06-22 08:20:00 | AAPL | Stock | 9.7075 | 9.71 | 9.7054 | 9.7089 | 121800.0 |
| 2010-06-22 08:25:00 | AAPL | Stock | 9.71 | 9.7225 | 9.71 | 9.7161 | 463316.0 |
| 2010-06-22 08:30:00 | AAPL | Stock | 9.7161 | 9.7289 | 9.7161 | 9.7196 | 521752.0 |
| 2010-06-22 08:35:00 | AAPL | Stock | 9.7225 | 9.7307 | 9.7214 | 9.7286 | 365400.0 |
| 2010-06-22 08:40:00 | AAPL | Stock | 9.7296 | 9.7314 | 9.7171 | 9.7171 | 409920.0 |
| 2010-06-22 08:45:00 | AAPL | Stock | 9.7161 | 9.7179 | 9.7071 | 9.7139 | 400708.0 |
| 2010-06-22 08:50:00 | AAPL | Stock | 9.7139 | 9.7214 | 9.7139 | 9.7189 | 489832.0 |
| 2010-06-22 08:55:00 | AAPL | Stock | 9.7175 | 9.7275 | 9.7139 | 9.7271 | 322868.0 |
| 2010-06-22 09:00:00 | AAPL | Stock | 9.7264 | 9.7364 | 9.7236 | 9.7357 | 471548.0 |
| 2010-06-22 09:05:00 | AAPL | Stock | 9.7355 | 9.7536 | 9.7355 | 9.7429 | 1382724.0 |
| 2010-06-22 09:10:00 | AAPL | Stock | 9.7429 | 9.7482 | 9.7268 | 9.7286 | 724920.0 |
| 2010-06-22 09:15:00 | AAPL | Stock | 9.7286 | 9.7286 | 9.7193 | 9.7243 | 266700.0 |
| 2010-06-22 09:20:00 | AAPL | Stock | 9.7254 | 9.7321 | 9.7218 | 9.7321 | 290780.0 |
| 2010-06-22 09:25:00 | AAPL | Stock | 9.7339 | 9.7343 | 9.7125 | 9.7154 | 766024.0 |
| 2010-06-22 09:30:00 | AAPL | Stock | 9.7164 | 9.7414 | 9.7054 | 9.7414 | 21518336.0 |
| 2010-06-22 09:35:00 | AAPL | Stock | 9.7407 | 9.7703 | 9.7336 | 9.7429 | 19175184.0 |
| 2010-06-22 09:40:00 | AAPL | Stock | 9.7446 | 9.7761 | 9.7421 | 9.7746 | 15048880.0 |
| 2010-06-22 09:45:00 | AAPL | Stock | 9.775 | 9.8161 | 9.7711 | 9.8014 | 21388584.0 |
| 2010-06-22 09:50:00 | AAPL | Stock | 9.8014 | 9.8057 | 9.7807 | 9.7875 | 15417360.0 |
| 2010-06-22 09:55:00 | AAPL | Stock | 9.7849 | 9.7921 | 9.7729 | 9.7786 | 10130512.0 |
| 2010-06-22 10:00:00 | AAPL | Stock | 9.7796 | 9.7839 | 9.7325 | 9.745 | 20494096.0 |
| 2010-06-22 10:05:00 | AAPL | Stock | 9.7454 | 9.7607 | 9.7361 | 9.76 | 11574080.0 |
| 2010-06-22 10:10:00 | AAPL | Stock | 9.76 | 9.7614 | 9.7307 | 9.7468 | 11498732.0 |
| 2010-06-22 10:15:00 | AAPL | Stock | 9.745 | 9.7468 | 9.7118 | 9.7182 | 11471516.0 |
| 2010-06-22 10:20:00 | AAPL | Stock | 9.7164 | 9.7282 | 9.6964 | 9.7132 | 10970120.0 |
| 2010-06-22 10:25:00 | AAPL | Stock | 9.7121 | 9.7429 | 9.7082 | 9.7389 | 10674132.0 |
| 2010-06-22 10:30:00 | AAPL | Stock | 9.7389 | 9.74 | 9.7111 | 9.7111 | 7844452.0 |
> showing 50 of 331,450 rows — these rows as CSV