PREVIEW / stock_30min / 2007-02-02
file: by_date/stock_30min/2007/2007-02-02.parquet size: 975 KB rows: 52,752 symbols: 2,493
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-02 06:30:00 | AAPL | Stock | 3.0204 | 3.0204 | 3.0146 | 3.0146 | 56000.0 |
| 2007-02-02 07:00:00 | AAPL | Stock | 3.0257 | 3.0257 | 3.0257 | 3.0257 | 2800.0 |
| 2007-02-02 07:30:00 | AAPL | Stock | 3.0175 | 3.0175 | 3.0143 | 3.015 | 50456.0 |
| 2007-02-02 08:00:00 | AAPL | Stock | 3.0143 | 3.0179 | 2.9911 | 2.9982 | 4277336.0 |
| 2007-02-02 08:30:00 | AAPL | Stock | 2.9979 | 3.0068 | 2.9979 | 3.0014 | 3175004.0 |
| 2007-02-02 09:00:00 | AAPL | Stock | 3.0007 | 3.0071 | 2.9968 | 3.0043 | 4775428.0 |
| 2007-02-02 09:30:00 | AAPL | Stock | 3.005 | 3.0225 | 2.9893 | 3.0136 | 139278524.0 |
| 2007-02-02 10:00:00 | AAPL | Stock | 3.0132 | 3.0393 | 3.0118 | 3.0307 | 101895696.0 |
| 2007-02-02 10:30:00 | AAPL | Stock | 3.0311 | 3.0446 | 3.0257 | 3.0286 | 69712944.0 |
| 2007-02-02 11:00:00 | AAPL | Stock | 3.0286 | 3.0357 | 3.0239 | 3.0282 | 31398556.0 |
| 2007-02-02 11:30:00 | AAPL | Stock | 3.0279 | 3.0285 | 3.0146 | 3.0268 | 44579276.0 |
| 2007-02-02 12:00:00 | AAPL | Stock | 3.0268 | 3.0307 | 3.0215 | 3.0221 | 22149792.0 |
| 2007-02-02 12:30:00 | AAPL | Stock | 3.0221 | 3.0307 | 3.0221 | 3.0275 | 14868784.0 |
| 2007-02-02 13:00:00 | AAPL | Stock | 3.0275 | 3.0325 | 3.0264 | 3.0282 | 18368812.0 |
| 2007-02-02 13:30:00 | AAPL | Stock | 3.0282 | 3.0325 | 3.0232 | 3.0246 | 16562728.0 |
| 2007-02-02 14:00:00 | AAPL | Stock | 3.0246 | 3.0304 | 3.0118 | 3.0147 | 30645804.0 |
| 2007-02-02 14:30:00 | AAPL | Stock | 3.015 | 3.0196 | 3.0111 | 3.0171 | 29745352.0 |
| 2007-02-02 15:00:00 | AAPL | Stock | 3.0175 | 3.0211 | 3.0121 | 3.0204 | 31885588.0 |
| 2007-02-02 15:30:00 | AAPL | Stock | 3.0204 | 3.0282 | 3.0196 | 3.0282 | 42465360.0 |
| 2007-02-02 16:00:00 | AAPL | Stock | 3.0279 | 3.0282 | 3.0143 | 3.0171 | 3057656.0 |
| 2007-02-02 16:30:00 | AAPL | Stock | 3.0171 | 3.0186 | 3.0143 | 3.0179 | 309428.0 |
| 2007-02-02 17:00:00 | AAPL | Stock | 3.0171 | 3.0175 | 3.0154 | 3.0171 | 54628.0 |
| 2007-02-02 17:30:00 | AAPL | Stock | 3.0171 | 3.0189 | 3.0154 | 3.0189 | 174496.0 |
| 2007-02-02 18:00:00 | AAPL | Stock | 3.0171 | 3.0196 | 3.0161 | 3.0196 | 80108.0 |
| 2007-02-02 18:30:00 | AAPL | Stock | 3.0179 | 3.0196 | 3.0171 | 3.0196 | 50148.0 |
| 2007-02-02 19:00:00 | AAPL | Stock | 3.0196 | 3.0196 | 3.0154 | 3.0164 | 85932.0 |
| 2007-02-02 19:30:00 | AAPL | Stock | 3.0164 | 3.0189 | 3.0154 | 3.0182 | 143472.0 |
| 2007-02-02 06:00:00 | MSFT | Stock | 30.85 | 30.85 | 30.85 | 30.85 | 4600.0 |
| 2007-02-02 06:30:00 | MSFT | Stock | 30.85 | 30.85 | 30.85 | 30.85 | 300.0 |
| 2007-02-02 07:00:00 | MSFT | Stock | 30.85 | 30.85 | 30.8 | 30.8 | 1400.0 |
| 2007-02-02 07:30:00 | MSFT | Stock | 30.85 | 30.86 | 30.85 | 30.86 | 3000.0 |
| 2007-02-02 08:00:00 | MSFT | Stock | 30.86 | 30.88 | 30.81 | 30.85 | 38452.0 |
| 2007-02-02 08:30:00 | MSFT | Stock | 30.85 | 30.87 | 30.8 | 30.85 | 55052.0 |
| 2007-02-02 09:00:00 | MSFT | Stock | 30.85 | 30.89 | 30.56 | 30.82 | 1562596.0 |
| 2007-02-02 09:30:00 | MSFT | Stock | 30.82 | 30.84 | 30.45 | 30.48 | 7458648.0 |
| 2007-02-02 10:00:00 | MSFT | Stock | 30.48 | 30.53 | 30.45 | 30.46 | 4189114.0 |
| 2007-02-02 10:30:00 | MSFT | Stock | 30.46 | 30.601 | 30.45 | 30.58 | 4932643.0 |
| 2007-02-02 11:00:00 | MSFT | Stock | 30.58 | 30.58 | 30.51 | 30.52 | 3255873.0 |
| 2007-02-02 11:30:00 | MSFT | Stock | 30.53 | 30.53 | 30.448 | 30.49 | 2339246.0 |
| 2007-02-02 12:00:00 | MSFT | Stock | 30.48 | 30.51 | 30.46 | 30.46 | 1980716.0 |
| 2007-02-02 12:30:00 | MSFT | Stock | 30.46 | 30.49 | 30.4 | 30.41 | 2144089.0 |
| 2007-02-02 13:00:00 | MSFT | Stock | 30.41 | 30.47 | 30.38 | 30.39 | 2405131.0 |
| 2007-02-02 13:30:00 | MSFT | Stock | 30.39 | 30.41 | 30.3 | 30.32 | 4264872.0 |
| 2007-02-02 14:00:00 | MSFT | Stock | 30.32 | 30.33 | 30.16 | 30.17 | 7142326.0 |
| 2007-02-02 14:30:00 | MSFT | Stock | 30.17 | 30.21 | 30.13 | 30.18 | 4136724.0 |
| 2007-02-02 15:00:00 | MSFT | Stock | 30.18 | 30.24 | 30.16 | 30.2 | 3938061.0 |
| 2007-02-02 15:30:00 | MSFT | Stock | 30.19 | 30.24 | 30.15 | 30.17 | 5744718.0 |
| 2007-02-02 16:00:00 | MSFT | Stock | 30.19 | 30.19 | 30.16 | 30.19 | 125770.0 |
| 2007-02-02 16:30:00 | MSFT | Stock | 30.19 | 30.19 | 30.15 | 30.17 | 1649444.0 |
| 2007-02-02 17:00:00 | MSFT | Stock | 30.17 | 30.2 | 30.16 | 30.2 | 6073.0 |
> showing 50 of 52,752 rows — these rows as CSV