PREVIEW / stock_5min / 2009-08-03
file: by_date/stock_5min/2009/2009-08-03.parquet size: 4.8 MB rows: 332,194 symbols: 3,367
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-03 05:50:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 5600.0 |
| 2009-08-03 07:10:00 | AAPL | Stock | 5.9 | 5.9 | 5.9 | 5.9 | 5600.0 |
| 2009-08-03 07:25:00 | AAPL | Stock | 5.8907 | 5.8911 | 5.8907 | 5.8911 | 16240.0 |
| 2009-08-03 07:30:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8929 | 5.8929 | 26600.0 |
| 2009-08-03 07:35:00 | AAPL | Stock | 5.8982 | 5.8982 | 5.8982 | 5.8982 | 12152.0 |
| 2009-08-03 07:40:00 | AAPL | Stock | 5.895 | 5.895 | 5.895 | 5.895 | 2800.0 |
| 2009-08-03 07:45:00 | AAPL | Stock | 5.895 | 5.9071 | 5.895 | 5.9071 | 19600.0 |
| 2009-08-03 07:50:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9071 | 5.9071 | 7980.0 |
| 2009-08-03 07:55:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 69748.0 |
| 2009-08-03 08:00:00 | AAPL | Stock | 5.9071 | 5.9121 | 5.8354 | 5.8964 | 353752.0 |
| 2009-08-03 08:05:00 | AAPL | Stock | 5.9 | 5.9043 | 5.8964 | 5.9043 | 199892.0 |
| 2009-08-03 08:10:00 | AAPL | Stock | 5.9 | 5.905 | 5.9 | 5.905 | 99316.0 |
| 2009-08-03 08:15:00 | AAPL | Stock | 5.9036 | 5.905 | 5.8989 | 5.9007 | 136948.0 |
| 2009-08-03 08:20:00 | AAPL | Stock | 5.9029 | 5.9071 | 5.9018 | 5.9071 | 118216.0 |
| 2009-08-03 08:25:00 | AAPL | Stock | 5.9093 | 5.9193 | 5.9071 | 5.9193 | 228060.0 |
| 2009-08-03 08:30:00 | AAPL | Stock | 5.9193 | 5.9214 | 5.9096 | 5.9214 | 371700.0 |
| 2009-08-03 08:35:00 | AAPL | Stock | 5.9218 | 5.9268 | 5.9107 | 5.9125 | 256928.0 |
| 2009-08-03 08:40:00 | AAPL | Stock | 5.9125 | 5.9143 | 5.9107 | 5.9107 | 119504.0 |
| 2009-08-03 08:45:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.8946 | 5.8996 | 368508.0 |
| 2009-08-03 08:50:00 | AAPL | Stock | 5.8996 | 5.8996 | 5.8875 | 5.8875 | 305032.0 |
| 2009-08-03 08:55:00 | AAPL | Stock | 5.8907 | 5.9093 | 5.8907 | 5.9068 | 102900.0 |
| 2009-08-03 09:00:00 | AAPL | Stock | 5.9036 | 5.9068 | 5.9018 | 5.905 | 125580.0 |
| 2009-08-03 09:05:00 | AAPL | Stock | 5.9054 | 5.9071 | 5.9054 | 5.9057 | 65800.0 |
| 2009-08-03 09:10:00 | AAPL | Stock | 5.9079 | 5.9107 | 5.9043 | 5.9057 | 204372.0 |
| 2009-08-03 09:15:00 | AAPL | Stock | 5.9075 | 5.9107 | 5.9036 | 5.9107 | 318136.0 |
| 2009-08-03 09:20:00 | AAPL | Stock | 5.9096 | 5.9143 | 5.9096 | 5.9107 | 109200.0 |
| 2009-08-03 09:25:00 | AAPL | Stock | 5.9107 | 5.9125 | 5.8961 | 5.9025 | 611688.0 |
| 2009-08-03 09:30:00 | AAPL | Stock | 5.9004 | 5.9464 | 5.8929 | 5.9421 | 27299748.0 |
| 2009-08-03 09:35:00 | AAPL | Stock | 5.9425 | 5.9464 | 5.9214 | 5.9321 | 13318144.0 |
| 2009-08-03 09:40:00 | AAPL | Stock | 5.9325 | 5.9361 | 5.9164 | 5.9336 | 10412304.0 |
| 2009-08-03 09:45:00 | AAPL | Stock | 5.9336 | 5.9336 | 5.9146 | 5.93 | 9364376.0 |
| 2009-08-03 09:50:00 | AAPL | Stock | 5.93 | 5.9339 | 5.9143 | 5.9282 | 9565304.0 |
| 2009-08-03 09:55:00 | AAPL | Stock | 5.9282 | 5.9357 | 5.925 | 5.9264 | 6328224.0 |
| 2009-08-03 10:00:00 | AAPL | Stock | 5.9264 | 5.9514 | 5.9264 | 5.9404 | 15090012.0 |
| 2009-08-03 10:05:00 | AAPL | Stock | 5.9404 | 5.9461 | 5.9196 | 5.9196 | 10105956.0 |
| 2009-08-03 10:10:00 | AAPL | Stock | 5.9196 | 5.9446 | 5.9171 | 5.9439 | 7133280.0 |
| 2009-08-03 10:15:00 | AAPL | Stock | 5.9443 | 5.9461 | 5.925 | 5.9282 | 7389564.0 |
| 2009-08-03 10:20:00 | AAPL | Stock | 5.9286 | 5.9346 | 5.9154 | 5.9157 | 6027112.0 |
| 2009-08-03 10:25:00 | AAPL | Stock | 5.9157 | 5.9357 | 5.9143 | 5.9289 | 6718236.0 |
| 2009-08-03 10:30:00 | AAPL | Stock | 5.9296 | 5.9411 | 5.9235 | 5.9243 | 7164248.0 |
| 2009-08-03 10:35:00 | AAPL | Stock | 5.9236 | 5.9282 | 5.915 | 5.9232 | 5973072.0 |
| 2009-08-03 10:40:00 | AAPL | Stock | 5.92 | 5.9254 | 5.9111 | 5.9204 | 6461308.0 |
| 2009-08-03 10:45:00 | AAPL | Stock | 5.9193 | 5.9286 | 5.9182 | 5.9193 | 4673284.0 |
| 2009-08-03 10:50:00 | AAPL | Stock | 5.92 | 5.9229 | 5.9121 | 5.9132 | 5032860.0 |
| 2009-08-03 10:55:00 | AAPL | Stock | 5.9139 | 5.9171 | 5.9054 | 5.9096 | 6983676.0 |
| 2009-08-03 11:00:00 | AAPL | Stock | 5.9086 | 5.9186 | 5.9082 | 5.9157 | 3173296.0 |
| 2009-08-03 11:05:00 | AAPL | Stock | 5.9161 | 5.9179 | 5.9114 | 5.9168 | 3295572.0 |
| 2009-08-03 11:10:00 | AAPL | Stock | 5.9175 | 5.9179 | 5.9093 | 5.9096 | 2459324.0 |
| 2009-08-03 11:15:00 | AAPL | Stock | 5.9096 | 5.91 | 5.8904 | 5.8904 | 9409876.0 |
| 2009-08-03 11:20:00 | AAPL | Stock | 5.8904 | 5.9139 | 5.8882 | 5.9071 | 10064208.0 |
> showing 50 of 332,194 rows — these rows as CSV