PREVIEW / stock_5min / 2007-09-20
file: by_date/stock_5min/2007/2007-09-20.parquet size: 4.0 MB rows: 293,645 symbols: 3,123
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-09-20 09:30:00 | AAPL | Stock | 5.0054 | 5.0125 | 4.9821 | 4.9954 | 25356996.0 |
| 2007-09-20 09:35:00 | AAPL | Stock | 4.995 | 5.0154 | 4.9943 | 5.0118 | 14144844.0 |
| 2007-09-20 09:40:00 | AAPL | Stock | 5.0111 | 5.0154 | 4.9893 | 4.9957 | 16953720.0 |
| 2007-09-20 09:45:00 | AAPL | Stock | 4.9954 | 4.9982 | 4.9757 | 4.9875 | 14662088.0 |
| 2007-09-20 09:50:00 | AAPL | Stock | 4.9875 | 4.9957 | 4.9821 | 4.9879 | 10376968.0 |
| 2007-09-20 09:55:00 | AAPL | Stock | 4.9886 | 5.0 | 4.9836 | 4.9939 | 12831308.0 |
| 2007-09-20 10:00:00 | AAPL | Stock | 4.9943 | 5.0064 | 4.9896 | 5.0061 | 14808472.0 |
| 2007-09-20 10:05:00 | AAPL | Stock | 5.0061 | 5.0193 | 5.0043 | 5.0164 | 14885220.0 |
| 2007-09-20 10:10:00 | AAPL | Stock | 5.0164 | 5.0339 | 5.015 | 5.0325 | 20694912.0 |
| 2007-09-20 10:15:00 | AAPL | Stock | 5.0321 | 5.0339 | 5.0164 | 5.0175 | 13785268.0 |
| 2007-09-20 10:20:00 | AAPL | Stock | 5.0182 | 5.0264 | 5.0179 | 5.0229 | 6172404.0 |
| 2007-09-20 10:25:00 | AAPL | Stock | 5.0225 | 5.0246 | 5.0079 | 5.0096 | 9909788.0 |
| 2007-09-20 10:30:00 | AAPL | Stock | 5.0093 | 5.0225 | 5.0018 | 5.0221 | 12299028.0 |
| 2007-09-20 10:35:00 | AAPL | Stock | 5.02 | 5.025 | 5.0171 | 5.0232 | 7253848.0 |
| 2007-09-20 10:40:00 | AAPL | Stock | 5.0236 | 5.0357 | 5.0232 | 5.0246 | 10554348.0 |
| 2007-09-20 10:45:00 | AAPL | Stock | 5.0257 | 5.0279 | 5.0179 | 5.0257 | 6428716.0 |
| 2007-09-20 10:50:00 | AAPL | Stock | 5.0246 | 5.03 | 5.0239 | 5.0282 | 4381412.0 |
| 2007-09-20 10:55:00 | AAPL | Stock | 5.0275 | 5.0307 | 5.0225 | 5.0279 | 5337136.0 |
| 2007-09-20 11:00:00 | AAPL | Stock | 5.0282 | 5.0304 | 5.0196 | 5.0214 | 4838316.0 |
| 2007-09-20 11:05:00 | AAPL | Stock | 5.0214 | 5.0446 | 5.02 | 5.0429 | 12566316.0 |
| 2007-09-20 11:10:00 | AAPL | Stock | 5.0429 | 5.0571 | 5.0421 | 5.0507 | 16092440.0 |
| 2007-09-20 11:15:00 | AAPL | Stock | 5.0507 | 5.0639 | 5.0469 | 5.0531 | 10122588.0 |
| 2007-09-20 11:20:00 | AAPL | Stock | 5.0532 | 5.0539 | 5.0386 | 5.0411 | 8740508.0 |
| 2007-09-20 11:25:00 | AAPL | Stock | 5.0414 | 5.0511 | 5.0411 | 5.0507 | 7041972.0 |
| 2007-09-20 11:30:00 | AAPL | Stock | 5.05 | 5.0529 | 5.0311 | 5.0339 | 7376880.0 |
| 2007-09-20 11:35:00 | AAPL | Stock | 5.0341 | 5.0385 | 5.0286 | 5.0329 | 7457772.0 |
| 2007-09-20 11:40:00 | AAPL | Stock | 5.0321 | 5.0375 | 5.03 | 5.0339 | 4862676.0 |
| 2007-09-20 11:45:00 | AAPL | Stock | 5.0343 | 5.0375 | 5.0186 | 5.0204 | 8356152.0 |
| 2007-09-20 11:50:00 | AAPL | Stock | 5.0204 | 5.0286 | 5.0179 | 5.0243 | 4638368.0 |
| 2007-09-20 11:55:00 | AAPL | Stock | 5.025 | 5.0368 | 5.0236 | 5.0357 | 5625424.0 |
| 2007-09-20 12:00:00 | AAPL | Stock | 5.0361 | 5.0479 | 5.0354 | 5.0439 | 10679480.0 |
| 2007-09-20 12:05:00 | AAPL | Stock | 5.0443 | 5.0479 | 5.0393 | 5.0457 | 7171864.0 |
| 2007-09-20 12:10:00 | AAPL | Stock | 5.0453 | 5.0464 | 5.0389 | 5.0418 | 5733504.0 |
| 2007-09-20 12:15:00 | AAPL | Stock | 5.0418 | 5.0432 | 5.0311 | 5.0346 | 4919824.0 |
| 2007-09-20 12:20:00 | AAPL | Stock | 5.0346 | 5.0396 | 5.0321 | 5.0379 | 3544604.0 |
| 2007-09-20 12:25:00 | AAPL | Stock | 5.0375 | 5.0386 | 5.0282 | 5.0313 | 3597048.0 |
| 2007-09-20 12:30:00 | AAPL | Stock | 5.0304 | 5.0379 | 5.0279 | 5.0357 | 2861012.0 |
| 2007-09-20 12:35:00 | AAPL | Stock | 5.0357 | 5.0386 | 5.0314 | 5.0354 | 2866724.0 |
| 2007-09-20 12:40:00 | AAPL | Stock | 5.0354 | 5.04 | 5.0329 | 5.0346 | 3612420.0 |
| 2007-09-20 12:45:00 | AAPL | Stock | 5.0339 | 5.0375 | 5.025 | 5.0289 | 4994724.0 |
| 2007-09-20 12:50:00 | AAPL | Stock | 5.0286 | 5.0375 | 5.0257 | 5.0364 | 3187884.0 |
| 2007-09-20 12:55:00 | AAPL | Stock | 5.0368 | 5.04 | 5.0346 | 5.0357 | 2993088.0 |
| 2007-09-20 13:00:00 | AAPL | Stock | 5.0354 | 5.0371 | 5.0314 | 5.0318 | 2416764.0 |
| 2007-09-20 13:05:00 | AAPL | Stock | 5.0329 | 5.0332 | 5.0271 | 5.0289 | 2327388.0 |
| 2007-09-20 13:10:00 | AAPL | Stock | 5.0292 | 5.0325 | 5.0261 | 5.0321 | 2435440.0 |
| 2007-09-20 13:15:00 | AAPL | Stock | 5.0329 | 5.0343 | 5.0257 | 5.0286 | 2439024.0 |
| 2007-09-20 13:20:00 | AAPL | Stock | 5.0279 | 5.0304 | 5.0214 | 5.0221 | 3621464.0 |
| 2007-09-20 13:25:00 | AAPL | Stock | 5.0221 | 5.0225 | 5.0157 | 5.0189 | 6344744.0 |
| 2007-09-20 13:30:00 | AAPL | Stock | 5.0186 | 5.0225 | 5.0175 | 5.0204 | 2580732.0 |
| 2007-09-20 13:35:00 | AAPL | Stock | 5.0204 | 5.0207 | 5.0111 | 5.0207 | 6340936.0 |
> showing 50 of 293,645 rows — these rows as CSV