PREVIEW / stock_5min / 2008-07-18
file: by_date/stock_5min/2008/2008-07-18.parquet size: 4.4 MB rows: 314,777 symbols: 3,315
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-18 06:55:00 | AAPL | Stock | 6.0596 | 6.0714 | 6.0596 | 6.0714 | 7000.0 |
| 2008-07-18 07:00:00 | AAPL | Stock | 6.0536 | 6.0536 | 6.01 | 6.01 | 44800.0 |
| 2008-07-18 07:10:00 | AAPL | Stock | 6.0357 | 6.0489 | 6.035 | 6.0489 | 89600.0 |
| 2008-07-18 07:15:00 | AAPL | Stock | 6.0489 | 6.0536 | 6.0489 | 6.0536 | 69020.0 |
| 2008-07-18 07:20:00 | AAPL | Stock | 6.0546 | 6.0546 | 6.05 | 6.05 | 27300.0 |
| 2008-07-18 07:25:00 | AAPL | Stock | 6.0496 | 6.05 | 6.0496 | 6.05 | 23940.0 |
| 2008-07-18 07:30:00 | AAPL | Stock | 6.07 | 6.07 | 6.07 | 6.07 | 14000.0 |
| 2008-07-18 07:35:00 | AAPL | Stock | 6.0668 | 6.0668 | 6.0657 | 6.0668 | 111160.0 |
| 2008-07-18 07:40:00 | AAPL | Stock | 6.0625 | 6.0625 | 6.0625 | 6.0625 | 14000.0 |
| 2008-07-18 07:45:00 | AAPL | Stock | 6.0607 | 6.0696 | 6.0607 | 6.0696 | 156240.0 |
| 2008-07-18 07:50:00 | AAPL | Stock | 6.0693 | 6.0693 | 6.0571 | 6.0571 | 43400.0 |
| 2008-07-18 07:55:00 | AAPL | Stock | 6.0543 | 6.0543 | 6.0357 | 6.0429 | 154000.0 |
| 2008-07-18 08:00:00 | AAPL | Stock | 6.0389 | 6.0479 | 6.0182 | 6.0382 | 339864.0 |
| 2008-07-18 08:05:00 | AAPL | Stock | 6.0382 | 6.0479 | 6.0357 | 6.0429 | 716940.0 |
| 2008-07-18 08:10:00 | AAPL | Stock | 6.0432 | 6.0464 | 6.0382 | 6.0446 | 157080.0 |
| 2008-07-18 08:15:00 | AAPL | Stock | 6.0429 | 6.0582 | 6.0429 | 6.0536 | 308084.0 |
| 2008-07-18 08:20:00 | AAPL | Stock | 6.0586 | 6.0639 | 6.0539 | 6.0607 | 436408.0 |
| 2008-07-18 08:25:00 | AAPL | Stock | 6.0596 | 6.0707 | 6.0539 | 6.07 | 335440.0 |
| 2008-07-18 08:30:00 | AAPL | Stock | 6.0682 | 6.0696 | 6.0579 | 6.0593 | 505820.0 |
| 2008-07-18 08:35:00 | AAPL | Stock | 6.0579 | 6.065 | 6.0514 | 6.0536 | 300328.0 |
| 2008-07-18 08:40:00 | AAPL | Stock | 6.0557 | 6.0561 | 6.0429 | 6.0464 | 957040.0 |
| 2008-07-18 08:45:00 | AAPL | Stock | 6.0464 | 6.05 | 6.0436 | 6.0446 | 113400.0 |
| 2008-07-18 08:50:00 | AAPL | Stock | 6.0507 | 6.0507 | 6.0464 | 6.0504 | 206500.0 |
| 2008-07-18 08:55:00 | AAPL | Stock | 6.0504 | 6.0625 | 6.0504 | 6.0554 | 270060.0 |
| 2008-07-18 09:00:00 | AAPL | Stock | 6.0521 | 6.0571 | 6.0518 | 6.0536 | 61600.0 |
| 2008-07-18 09:05:00 | AAPL | Stock | 6.0557 | 6.0557 | 6.0464 | 6.0464 | 166040.0 |
| 2008-07-18 09:10:00 | AAPL | Stock | 6.0464 | 6.0464 | 6.0279 | 6.0282 | 437556.0 |
| 2008-07-18 09:15:00 | AAPL | Stock | 6.03 | 6.0357 | 6.03 | 6.03 | 235060.0 |
| 2008-07-18 09:20:00 | AAPL | Stock | 6.0307 | 6.0314 | 6.0307 | 6.0311 | 48160.0 |
| 2008-07-18 09:25:00 | AAPL | Stock | 6.0311 | 6.0314 | 6.0082 | 6.0107 | 1491056.0 |
| 2008-07-18 09:30:00 | AAPL | Stock | 6.0107 | 6.0314 | 5.9814 | 5.9904 | 81333924.0 |
| 2008-07-18 09:35:00 | AAPL | Stock | 5.9893 | 6.0286 | 5.9857 | 6.0157 | 20864648.0 |
| 2008-07-18 09:40:00 | AAPL | Stock | 6.0168 | 6.0468 | 6.0032 | 6.0443 | 15882300.0 |
| 2008-07-18 09:45:00 | AAPL | Stock | 6.0443 | 6.0589 | 6.0168 | 6.0468 | 15157772.0 |
| 2008-07-18 09:50:00 | AAPL | Stock | 6.0464 | 6.0507 | 6.0139 | 6.0143 | 13150676.0 |
| 2008-07-18 09:55:00 | AAPL | Stock | 6.0143 | 6.0179 | 5.9968 | 6.0082 | 14709632.0 |
| 2008-07-18 10:00:00 | AAPL | Stock | 6.0093 | 6.02 | 6.0018 | 6.02 | 8352512.0 |
| 2008-07-18 10:05:00 | AAPL | Stock | 6.02 | 6.0329 | 6.0025 | 6.0214 | 10530548.0 |
| 2008-07-18 10:10:00 | AAPL | Stock | 6.0218 | 6.0407 | 6.0175 | 6.0286 | 6914796.0 |
| 2008-07-18 10:15:00 | AAPL | Stock | 6.0268 | 6.0357 | 6.0189 | 6.0332 | 5782812.0 |
| 2008-07-18 10:20:00 | AAPL | Stock | 6.0318 | 6.0321 | 6.0125 | 6.0146 | 6798736.0 |
| 2008-07-18 10:25:00 | AAPL | Stock | 6.0143 | 6.025 | 6.0089 | 6.0218 | 8064840.0 |
| 2008-07-18 10:30:00 | AAPL | Stock | 6.0218 | 6.0254 | 6.0036 | 6.0075 | 9265060.0 |
| 2008-07-18 10:35:00 | AAPL | Stock | 6.0086 | 6.025 | 5.9925 | 6.0 | 13715464.0 |
| 2008-07-18 10:40:00 | AAPL | Stock | 5.9999 | 6.0107 | 5.9932 | 6.01 | 9626288.0 |
| 2008-07-18 10:45:00 | AAPL | Stock | 6.0096 | 6.0293 | 6.0071 | 6.0264 | 10370080.0 |
| 2008-07-18 10:50:00 | AAPL | Stock | 6.0254 | 6.03 | 6.0114 | 6.0148 | 10096800.0 |
| 2008-07-18 10:55:00 | AAPL | Stock | 6.0146 | 6.0147 | 5.9961 | 5.9986 | 6880468.0 |
| 2008-07-18 11:00:00 | AAPL | Stock | 5.9989 | 6.0079 | 5.9854 | 5.9879 | 8987636.0 |
| 2008-07-18 11:05:00 | AAPL | Stock | 5.9869 | 6.0082 | 5.9857 | 6.0011 | 8359736.0 |
> showing 50 of 314,777 rows — these rows as CSV