PREVIEW / stock_5min / 2007-05-24
file: by_date/stock_5min/2007/2007-05-24.parquet size: 4.1 MB rows: 293,091 symbols: 3,012
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-24 09:30:00 | AAPL | Stock | 4.0289 | 4.0357 | 4.0125 | 4.0314 | 22722784.0 |
| 2007-05-24 09:35:00 | AAPL | Stock | 4.0318 | 4.0625 | 4.025 | 4.0317 | 21144732.0 |
| 2007-05-24 09:40:00 | AAPL | Stock | 4.0314 | 4.0425 | 4.0314 | 4.0386 | 14933828.0 |
| 2007-05-24 09:45:00 | AAPL | Stock | 4.0379 | 4.0589 | 4.0344 | 4.0554 | 13914208.0 |
| 2007-05-24 09:50:00 | AAPL | Stock | 4.055 | 4.0657 | 4.0493 | 4.0529 | 14348600.0 |
| 2007-05-24 09:55:00 | AAPL | Stock | 4.0525 | 4.0575 | 4.0496 | 4.055 | 8353912.0 |
| 2007-05-24 10:00:00 | AAPL | Stock | 4.055 | 4.0729 | 4.0529 | 4.0696 | 25673900.0 |
| 2007-05-24 10:05:00 | AAPL | Stock | 4.0696 | 4.0879 | 4.0664 | 4.0789 | 20580392.0 |
| 2007-05-24 10:10:00 | AAPL | Stock | 4.0793 | 4.0811 | 4.0664 | 4.0711 | 12570096.0 |
| 2007-05-24 10:15:00 | AAPL | Stock | 4.0711 | 4.0732 | 4.0675 | 4.0693 | 9477524.0 |
| 2007-05-24 10:20:00 | AAPL | Stock | 4.0694 | 4.0739 | 4.0611 | 4.0725 | 13132280.0 |
| 2007-05-24 10:25:00 | AAPL | Stock | 4.0729 | 4.0737 | 4.065 | 4.0704 | 7693084.0 |
| 2007-05-24 10:30:00 | AAPL | Stock | 4.0704 | 4.0732 | 4.0657 | 4.0704 | 8287272.0 |
| 2007-05-24 10:35:00 | AAPL | Stock | 4.0689 | 4.0711 | 4.0571 | 4.0579 | 8596644.0 |
| 2007-05-24 10:40:00 | AAPL | Stock | 4.0578 | 4.0714 | 4.0436 | 4.0454 | 22776964.0 |
| 2007-05-24 10:45:00 | AAPL | Stock | 4.0454 | 4.0593 | 4.0443 | 4.0582 | 11222372.0 |
| 2007-05-24 10:50:00 | AAPL | Stock | 4.0582 | 4.0582 | 4.0504 | 4.0544 | 7800100.0 |
| 2007-05-24 10:55:00 | AAPL | Stock | 4.055 | 4.0554 | 4.0289 | 4.0349 | 13792912.0 |
| 2007-05-24 11:00:00 | AAPL | Stock | 4.0354 | 4.0425 | 4.0321 | 4.0364 | 11753140.0 |
| 2007-05-24 11:05:00 | AAPL | Stock | 4.0364 | 4.0418 | 4.0343 | 4.039 | 8948016.0 |
| 2007-05-24 11:10:00 | AAPL | Stock | 4.0389 | 4.0407 | 4.02 | 4.02 | 10966508.0 |
| 2007-05-24 11:15:00 | AAPL | Stock | 4.02 | 4.0264 | 4.0075 | 4.0111 | 16963016.0 |
| 2007-05-24 11:20:00 | AAPL | Stock | 4.0114 | 4.0268 | 4.0093 | 4.0232 | 9780456.0 |
| 2007-05-24 11:25:00 | AAPL | Stock | 4.0229 | 4.0264 | 4.0132 | 4.0186 | 12241460.0 |
| 2007-05-24 11:30:00 | AAPL | Stock | 4.0186 | 4.0214 | 4.0129 | 4.0171 | 9969764.0 |
| 2007-05-24 11:35:00 | AAPL | Stock | 4.0171 | 4.0304 | 4.0164 | 4.0239 | 7361732.0 |
| 2007-05-24 11:40:00 | AAPL | Stock | 4.0239 | 4.0243 | 4.01 | 4.0179 | 7124908.0 |
| 2007-05-24 11:45:00 | AAPL | Stock | 4.0175 | 4.0232 | 4.015 | 4.0193 | 5933004.0 |
| 2007-05-24 11:50:00 | AAPL | Stock | 4.0196 | 4.0268 | 4.0189 | 4.0236 | 6417432.0 |
| 2007-05-24 11:55:00 | AAPL | Stock | 4.0236 | 4.0343 | 4.0232 | 4.0325 | 9410240.0 |
| 2007-05-24 12:00:00 | AAPL | Stock | 4.0321 | 4.0418 | 4.0321 | 4.0379 | 7699720.0 |
| 2007-05-24 12:05:00 | AAPL | Stock | 4.0379 | 4.0389 | 4.0289 | 4.0368 | 7461860.0 |
| 2007-05-24 12:10:00 | AAPL | Stock | 4.0368 | 4.0371 | 4.0293 | 4.0296 | 5240172.0 |
| 2007-05-24 12:15:00 | AAPL | Stock | 4.0296 | 4.0343 | 4.0168 | 4.0204 | 7533736.0 |
| 2007-05-24 12:20:00 | AAPL | Stock | 4.02 | 4.0211 | 4.0054 | 4.0125 | 11118072.0 |
| 2007-05-24 12:25:00 | AAPL | Stock | 4.0125 | 4.0221 | 4.0107 | 4.0139 | 5875856.0 |
| 2007-05-24 12:30:00 | AAPL | Stock | 4.0136 | 4.0175 | 4.0057 | 4.0118 | 7133616.0 |
| 2007-05-24 12:35:00 | AAPL | Stock | 4.0114 | 4.0152 | 4.0021 | 4.0054 | 8235164.0 |
| 2007-05-24 12:40:00 | AAPL | Stock | 4.0052 | 4.0054 | 3.9789 | 3.9918 | 23326744.0 |
| 2007-05-24 12:45:00 | AAPL | Stock | 3.9914 | 3.9993 | 3.9896 | 3.9971 | 8445024.0 |
| 2007-05-24 12:50:00 | AAPL | Stock | 3.9978 | 3.9978 | 3.9825 | 3.9893 | 7837368.0 |
| 2007-05-24 12:55:00 | AAPL | Stock | 3.99 | 3.9982 | 3.9864 | 3.9979 | 6698132.0 |
| 2007-05-24 13:00:00 | AAPL | Stock | 3.9975 | 4.0025 | 3.9936 | 3.9971 | 10963400.0 |
| 2007-05-24 13:05:00 | AAPL | Stock | 3.9968 | 4.0 | 3.9839 | 3.9854 | 6375236.0 |
| 2007-05-24 13:10:00 | AAPL | Stock | 3.9871 | 3.9925 | 3.9847 | 3.9886 | 4875136.0 |
| 2007-05-24 13:15:00 | AAPL | Stock | 3.9888 | 4.0043 | 3.9886 | 4.0 | 12621616.0 |
| 2007-05-24 13:20:00 | AAPL | Stock | 3.9996 | 4.0032 | 3.9964 | 4.0012 | 8744736.0 |
| 2007-05-24 13:25:00 | AAPL | Stock | 4.0011 | 4.0082 | 3.9968 | 3.9986 | 7007224.0 |
| 2007-05-24 13:30:00 | AAPL | Stock | 3.9986 | 4.0018 | 3.9957 | 3.9964 | 4043452.0 |
| 2007-05-24 13:35:00 | AAPL | Stock | 3.9957 | 3.9996 | 3.9857 | 3.9868 | 6316352.0 |
> showing 50 of 293,091 rows — these rows as CSV