PREVIEW / stock_5min / 2007-05-22
file: by_date/stock_5min/2007/2007-05-22.parquet size: 4.0 MB rows: 293,841 symbols: 3,019
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-05-22 09:30:00 | AAPL | Stock | 4.0175 | 4.0189 | 4.0071 | 4.0086 | 18356800.0 |
| 2007-05-22 09:35:00 | AAPL | Stock | 4.0086 | 4.0179 | 4.0079 | 4.0157 | 7758408.0 |
| 2007-05-22 09:40:00 | AAPL | Stock | 4.0145 | 4.025 | 4.0132 | 4.0196 | 14634060.0 |
| 2007-05-22 09:45:00 | AAPL | Stock | 4.0196 | 4.0314 | 4.0189 | 4.0261 | 13657924.0 |
| 2007-05-22 09:50:00 | AAPL | Stock | 4.0264 | 4.0264 | 4.0143 | 4.0211 | 13874896.0 |
| 2007-05-22 09:55:00 | AAPL | Stock | 4.0214 | 4.025 | 4.0186 | 4.02 | 6832616.0 |
| 2007-05-22 10:00:00 | AAPL | Stock | 4.02 | 4.0204 | 4.0121 | 4.0168 | 9905000.0 |
| 2007-05-22 10:05:00 | AAPL | Stock | 4.0171 | 4.0246 | 4.015 | 4.0214 | 9125928.0 |
| 2007-05-22 10:10:00 | AAPL | Stock | 4.0211 | 4.0268 | 4.0179 | 4.0229 | 7582568.0 |
| 2007-05-22 10:15:00 | AAPL | Stock | 4.023 | 4.0232 | 4.0143 | 4.0164 | 11240404.0 |
| 2007-05-22 10:20:00 | AAPL | Stock | 4.0164 | 4.0167 | 4.0057 | 4.0078 | 14558068.0 |
| 2007-05-22 10:25:00 | AAPL | Stock | 4.0075 | 4.0207 | 4.0064 | 4.0196 | 7560224.0 |
| 2007-05-22 10:30:00 | AAPL | Stock | 4.0193 | 4.0236 | 4.0171 | 4.0218 | 9270016.0 |
| 2007-05-22 10:35:00 | AAPL | Stock | 4.0218 | 4.0218 | 4.0136 | 4.0175 | 5401592.0 |
| 2007-05-22 10:40:00 | AAPL | Stock | 4.0175 | 4.0232 | 4.0164 | 4.0225 | 6248844.0 |
| 2007-05-22 10:45:00 | AAPL | Stock | 4.0221 | 4.0264 | 4.0182 | 4.0203 | 6905528.0 |
| 2007-05-22 10:50:00 | AAPL | Stock | 4.0206 | 4.0232 | 4.0179 | 4.02 | 4085144.0 |
| 2007-05-22 10:55:00 | AAPL | Stock | 4.0196 | 4.0268 | 4.0179 | 4.0261 | 4906076.0 |
| 2007-05-22 11:00:00 | AAPL | Stock | 4.0261 | 4.0286 | 4.0182 | 4.0236 | 9578380.0 |
| 2007-05-22 11:05:00 | AAPL | Stock | 4.0239 | 4.0271 | 4.0236 | 4.026 | 4007472.0 |
| 2007-05-22 11:10:00 | AAPL | Stock | 4.0261 | 4.0261 | 4.0204 | 4.0204 | 3810296.0 |
| 2007-05-22 11:15:00 | AAPL | Stock | 4.0207 | 4.0218 | 4.0164 | 4.0164 | 5729612.0 |
| 2007-05-22 11:20:00 | AAPL | Stock | 4.0167 | 4.0196 | 4.0121 | 4.0154 | 6943272.0 |
| 2007-05-22 11:25:00 | AAPL | Stock | 4.0154 | 4.0168 | 4.0125 | 4.0164 | 3206392.0 |
| 2007-05-22 11:30:00 | AAPL | Stock | 4.0161 | 4.0193 | 4.0161 | 4.0168 | 4622464.0 |
| 2007-05-22 11:35:00 | AAPL | Stock | 4.0169 | 4.0186 | 4.0136 | 4.0154 | 3991316.0 |
| 2007-05-22 11:40:00 | AAPL | Stock | 4.0153 | 4.0161 | 4.0089 | 4.0107 | 5065872.0 |
| 2007-05-22 11:45:00 | AAPL | Stock | 4.0111 | 4.0154 | 4.01 | 4.0125 | 3167948.0 |
| 2007-05-22 11:50:00 | AAPL | Stock | 4.0125 | 4.0143 | 4.0004 | 4.0011 | 8947960.0 |
| 2007-05-22 11:55:00 | AAPL | Stock | 4.0011 | 4.0089 | 4.0004 | 4.0071 | 8007020.0 |
| 2007-05-22 12:00:00 | AAPL | Stock | 4.0064 | 4.0104 | 4.0057 | 4.0102 | 3657444.0 |
| 2007-05-22 12:05:00 | AAPL | Stock | 4.0104 | 4.0125 | 4.0093 | 4.0121 | 3960712.0 |
| 2007-05-22 12:10:00 | AAPL | Stock | 4.0114 | 4.0143 | 4.0111 | 4.0118 | 2332988.0 |
| 2007-05-22 12:15:00 | AAPL | Stock | 4.0118 | 4.0218 | 4.0118 | 4.0218 | 4682216.0 |
| 2007-05-22 12:20:00 | AAPL | Stock | 4.0218 | 4.0257 | 4.0161 | 4.0229 | 7177604.0 |
| 2007-05-22 12:25:00 | AAPL | Stock | 4.0232 | 4.0239 | 4.0179 | 4.0196 | 2716140.0 |
| 2007-05-22 12:30:00 | AAPL | Stock | 4.0196 | 4.0236 | 4.0196 | 4.0211 | 3436720.0 |
| 2007-05-22 12:35:00 | AAPL | Stock | 4.0207 | 4.0225 | 4.0193 | 4.0193 | 2872100.0 |
| 2007-05-22 12:40:00 | AAPL | Stock | 4.0193 | 4.0243 | 4.0171 | 4.0225 | 3249456.0 |
| 2007-05-22 12:45:00 | AAPL | Stock | 4.0225 | 4.0225 | 4.0136 | 4.0168 | 5289200.0 |
| 2007-05-22 12:50:00 | AAPL | Stock | 4.0164 | 4.0214 | 4.015 | 4.0193 | 3969980.0 |
| 2007-05-22 12:55:00 | AAPL | Stock | 4.0193 | 4.0289 | 4.0189 | 4.0282 | 10668336.0 |
| 2007-05-22 13:00:00 | AAPL | Stock | 4.0286 | 4.0296 | 4.0196 | 4.0218 | 6182288.0 |
| 2007-05-22 13:05:00 | AAPL | Stock | 4.0221 | 4.0339 | 4.0211 | 4.0325 | 7068768.0 |
| 2007-05-22 13:10:00 | AAPL | Stock | 4.0321 | 4.0382 | 4.0314 | 4.0321 | 9225020.0 |
| 2007-05-22 13:15:00 | AAPL | Stock | 4.0318 | 4.0364 | 4.0296 | 4.0304 | 6186628.0 |
| 2007-05-22 13:20:00 | AAPL | Stock | 4.0304 | 4.0332 | 4.0282 | 4.0318 | 3811864.0 |
| 2007-05-22 13:25:00 | AAPL | Stock | 4.0321 | 4.0357 | 4.0314 | 4.0318 | 5024824.0 |
| 2007-05-22 13:30:00 | AAPL | Stock | 4.0321 | 4.0425 | 4.0315 | 4.0404 | 10497284.0 |
| 2007-05-22 13:35:00 | AAPL | Stock | 4.04 | 4.0404 | 4.0243 | 4.0354 | 5475232.0 |
> showing 50 of 293,841 rows — these rows as CSV