PREVIEW / stock_5min / 2007-02-28
file: by_date/stock_5min/2007/2007-02-28.parquet size: 3.5 MB rows: 249,958 symbols: 2,532
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-28 04:15:00 | AAPL | Stock | 2.995 | 2.995 | 2.9946 | 2.9946 | 30800.0 |
| 2007-02-28 04:35:00 | AAPL | Stock | 3.0007 | 3.0007 | 3.0007 | 3.0007 | 8064.0 |
| 2007-02-28 04:40:00 | AAPL | Stock | 3.0014 | 3.0032 | 3.0014 | 3.0032 | 19600.0 |
| 2007-02-28 05:10:00 | AAPL | Stock | 3.0039 | 3.0039 | 3.0039 | 3.0039 | 22400.0 |
| 2007-02-28 05:15:00 | AAPL | Stock | 3.0039 | 3.0039 | 3.0039 | 3.0039 | 2800.0 |
| 2007-02-28 06:30:00 | AAPL | Stock | 3.0104 | 3.0104 | 3.0071 | 3.0104 | 49000.0 |
| 2007-02-28 06:35:00 | AAPL | Stock | 3.0104 | 3.0125 | 3.0104 | 3.0125 | 21532.0 |
| 2007-02-28 06:40:00 | AAPL | Stock | 3.0143 | 3.0161 | 3.0143 | 3.0161 | 41132.0 |
| 2007-02-28 06:45:00 | AAPL | Stock | 3.0179 | 3.0282 | 3.0143 | 3.0143 | 39200.0 |
| 2007-02-28 06:55:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 13468.0 |
| 2007-02-28 07:00:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 8400.0 |
| 2007-02-28 07:10:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0086 | 3.0121 | 112000.0 |
| 2007-02-28 07:15:00 | AAPL | Stock | 3.0089 | 3.0129 | 3.0057 | 3.0125 | 137732.0 |
| 2007-02-28 07:20:00 | AAPL | Stock | 3.0121 | 3.0143 | 3.0114 | 3.0129 | 151144.0 |
| 2007-02-28 07:25:00 | AAPL | Stock | 3.0143 | 3.0175 | 3.0143 | 3.0175 | 30800.0 |
| 2007-02-28 07:30:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0125 | 3.0125 | 28000.0 |
| 2007-02-28 07:35:00 | AAPL | Stock | 3.0143 | 3.0204 | 3.0143 | 3.0179 | 54600.0 |
| 2007-02-28 07:40:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 28000.0 |
| 2007-02-28 07:45:00 | AAPL | Stock | 3.0214 | 3.025 | 3.0179 | 3.0196 | 126448.0 |
| 2007-02-28 07:50:00 | AAPL | Stock | 3.0186 | 3.0232 | 3.0186 | 3.0232 | 71036.0 |
| 2007-02-28 08:00:00 | AAPL | Stock | 3.0232 | 3.0386 | 3.0196 | 3.0321 | 1274924.0 |
| 2007-02-28 08:05:00 | AAPL | Stock | 3.0357 | 3.0375 | 3.0232 | 3.0264 | 278600.0 |
| 2007-02-28 08:10:00 | AAPL | Stock | 3.0257 | 3.0314 | 3.0232 | 3.0236 | 304108.0 |
| 2007-02-28 08:15:00 | AAPL | Stock | 3.0229 | 3.0318 | 3.0229 | 3.0304 | 648088.0 |
| 2007-02-28 08:20:00 | AAPL | Stock | 3.0307 | 3.0332 | 3.0268 | 3.0286 | 436240.0 |
| 2007-02-28 08:25:00 | AAPL | Stock | 3.0304 | 3.0332 | 3.0271 | 3.0314 | 354340.0 |
| 2007-02-28 08:30:00 | AAPL | Stock | 3.0332 | 3.0375 | 3.0314 | 3.035 | 1104572.0 |
| 2007-02-28 08:35:00 | AAPL | Stock | 3.0314 | 3.0336 | 3.025 | 3.025 | 545048.0 |
| 2007-02-28 08:40:00 | AAPL | Stock | 3.0296 | 3.0304 | 3.0214 | 3.0286 | 1013600.0 |
| 2007-02-28 08:45:00 | AAPL | Stock | 3.0279 | 3.0279 | 3.0236 | 3.0243 | 254100.0 |
| 2007-02-28 08:50:00 | AAPL | Stock | 3.025 | 3.0264 | 3.0236 | 3.0246 | 294980.0 |
| 2007-02-28 08:55:00 | AAPL | Stock | 3.0257 | 3.0289 | 3.0239 | 3.025 | 262640.0 |
| 2007-02-28 09:00:00 | AAPL | Stock | 3.025 | 3.0257 | 3.0232 | 3.0257 | 178976.0 |
| 2007-02-28 09:05:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0246 | 3.0257 | 262024.0 |
| 2007-02-28 09:10:00 | AAPL | Stock | 3.0257 | 3.0296 | 3.025 | 3.0293 | 381640.0 |
| 2007-02-28 09:15:00 | AAPL | Stock | 3.0286 | 3.0311 | 3.0275 | 3.0279 | 184800.0 |
| 2007-02-28 09:20:00 | AAPL | Stock | 3.0279 | 3.0286 | 3.0232 | 3.025 | 734272.0 |
| 2007-02-28 09:25:00 | AAPL | Stock | 3.0254 | 3.0254 | 3.0125 | 3.0204 | 1223740.0 |
| 2007-02-28 09:30:00 | AAPL | Stock | 3.0196 | 3.0268 | 2.9643 | 3.0232 | 33854324.0 |
| 2007-02-28 09:35:00 | AAPL | Stock | 3.0232 | 3.0325 | 3.0179 | 3.02 | 28265412.0 |
| 2007-02-28 09:40:00 | AAPL | Stock | 3.0193 | 3.0254 | 3.0025 | 3.0075 | 28683788.0 |
| 2007-02-28 09:45:00 | AAPL | Stock | 3.0075 | 3.0196 | 2.9975 | 3.0111 | 32869536.0 |
| 2007-02-28 09:50:00 | AAPL | Stock | 3.0121 | 3.0161 | 3.0011 | 3.0121 | 18963588.0 |
| 2007-02-28 09:55:00 | AAPL | Stock | 3.0114 | 3.025 | 3.0057 | 3.0175 | 20150816.0 |
| 2007-02-28 10:00:00 | AAPL | Stock | 3.0175 | 3.0182 | 3.0036 | 3.0107 | 18773076.0 |
| 2007-02-28 10:05:00 | AAPL | Stock | 3.0104 | 3.0196 | 3.0046 | 3.0079 | 16954056.0 |
| 2007-02-28 10:10:00 | AAPL | Stock | 3.0071 | 3.0179 | 3.0004 | 3.0164 | 19494776.0 |
| 2007-02-28 10:15:00 | AAPL | Stock | 3.0168 | 3.0321 | 3.0129 | 3.0257 | 20933444.0 |
| 2007-02-28 10:20:00 | AAPL | Stock | 3.0254 | 3.0296 | 3.0154 | 3.0214 | 17568824.0 |
| 2007-02-28 10:25:00 | AAPL | Stock | 3.0211 | 3.0329 | 3.0143 | 3.03 | 21284480.0 |
> showing 50 of 249,958 rows — these rows as CSV