PREVIEW / stock_5min / 2010-04-19
file: by_date/stock_5min/2010/2010-04-19.parquet size: 4.9 MB rows: 331,404 symbols: 3,492
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-19 04:05:00 | AAPL | Stock | 8.8068 | 8.8068 | 8.8068 | 8.8068 | 11200.0 |
| 2010-04-19 04:10:00 | AAPL | Stock | 8.8064 | 8.8064 | 8.8064 | 8.8064 | 2800.0 |
| 2010-04-19 04:15:00 | AAPL | Stock | 8.8107 | 8.8107 | 8.8107 | 8.8107 | 14000.0 |
| 2010-04-19 05:10:00 | AAPL | Stock | 8.7743 | 8.7743 | 8.7743 | 8.7743 | 5236.0 |
| 2010-04-19 05:20:00 | AAPL | Stock | 8.7536 | 8.7536 | 8.7536 | 8.7536 | 5600.0 |
| 2010-04-19 05:40:00 | AAPL | Stock | 8.7679 | 8.7679 | 8.7679 | 8.7679 | 22204.0 |
| 2010-04-19 05:55:00 | AAPL | Stock | 8.7768 | 8.7768 | 8.7768 | 8.7768 | 2800.0 |
| 2010-04-19 06:05:00 | AAPL | Stock | 8.7554 | 8.7554 | 8.7554 | 8.7554 | 14000.0 |
| 2010-04-19 06:20:00 | AAPL | Stock | 8.7536 | 8.7536 | 8.7536 | 8.7536 | 2800.0 |
| 2010-04-19 06:25:00 | AAPL | Stock | 8.7625 | 8.7625 | 8.7504 | 8.7504 | 7000.0 |
| 2010-04-19 06:30:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 5880.0 |
| 2010-04-19 06:55:00 | AAPL | Stock | 8.7625 | 8.7625 | 8.7625 | 8.7625 | 5600.0 |
| 2010-04-19 07:00:00 | AAPL | Stock | 8.7625 | 8.7629 | 8.7625 | 8.7629 | 22848.0 |
| 2010-04-19 07:15:00 | AAPL | Stock | 8.775 | 8.775 | 8.7714 | 8.7714 | 22120.0 |
| 2010-04-19 07:20:00 | AAPL | Stock | 8.7679 | 8.7679 | 8.7679 | 8.7679 | 16800.0 |
| 2010-04-19 07:30:00 | AAPL | Stock | 8.7679 | 8.7679 | 8.7643 | 8.7643 | 5600.0 |
| 2010-04-19 07:35:00 | AAPL | Stock | 8.7643 | 8.7643 | 8.7625 | 8.7625 | 5600.0 |
| 2010-04-19 07:40:00 | AAPL | Stock | 8.7714 | 8.7714 | 8.7714 | 8.7714 | 2800.0 |
| 2010-04-19 07:45:00 | AAPL | Stock | 8.7736 | 8.7736 | 8.7736 | 8.7736 | 2800.0 |
| 2010-04-19 07:50:00 | AAPL | Stock | 8.775 | 8.7786 | 8.775 | 8.7786 | 7000.0 |
| 2010-04-19 07:55:00 | AAPL | Stock | 8.7814 | 8.8186 | 8.7789 | 8.8036 | 115080.0 |
| 2010-04-19 08:00:00 | AAPL | Stock | 8.7857 | 8.8193 | 8.7857 | 8.8143 | 381192.0 |
| 2010-04-19 08:05:00 | AAPL | Stock | 8.8107 | 8.8121 | 8.7893 | 8.7929 | 226604.0 |
| 2010-04-19 08:10:00 | AAPL | Stock | 8.7893 | 8.7893 | 8.7786 | 8.7857 | 253372.0 |
| 2010-04-19 08:15:00 | AAPL | Stock | 8.7875 | 8.7882 | 8.7821 | 8.7857 | 148316.0 |
| 2010-04-19 08:20:00 | AAPL | Stock | 8.7939 | 8.7971 | 8.7821 | 8.7821 | 217000.0 |
| 2010-04-19 08:25:00 | AAPL | Stock | 8.7804 | 8.7857 | 8.7804 | 8.7854 | 63000.0 |
| 2010-04-19 08:30:00 | AAPL | Stock | 8.7857 | 8.7861 | 8.7839 | 8.7857 | 162064.0 |
| 2010-04-19 08:35:00 | AAPL | Stock | 8.7857 | 8.7861 | 8.785 | 8.7857 | 117740.0 |
| 2010-04-19 08:40:00 | AAPL | Stock | 8.7857 | 8.7889 | 8.785 | 8.7889 | 33040.0 |
| 2010-04-19 08:45:00 | AAPL | Stock | 8.7893 | 8.8054 | 8.7893 | 8.8054 | 120400.0 |
| 2010-04-19 08:50:00 | AAPL | Stock | 8.8036 | 8.8129 | 8.8036 | 8.8104 | 174020.0 |
| 2010-04-19 08:55:00 | AAPL | Stock | 8.8075 | 8.845 | 8.8071 | 8.8396 | 648816.0 |
| 2010-04-19 09:00:00 | AAPL | Stock | 8.8396 | 8.8479 | 8.8257 | 8.8386 | 539112.0 |
| 2010-04-19 09:05:00 | AAPL | Stock | 8.8386 | 8.8443 | 8.8321 | 8.8411 | 118916.0 |
| 2010-04-19 09:10:00 | AAPL | Stock | 8.8411 | 8.8464 | 8.8393 | 8.8393 | 221732.0 |
| 2010-04-19 09:15:00 | AAPL | Stock | 8.8393 | 8.8404 | 8.8357 | 8.8375 | 39200.0 |
| 2010-04-19 09:20:00 | AAPL | Stock | 8.8329 | 8.8329 | 8.8329 | 8.8329 | 2800.0 |
| 2010-04-19 09:25:00 | AAPL | Stock | 8.835 | 8.8375 | 8.8214 | 8.8218 | 405076.0 |
| 2010-04-19 09:30:00 | AAPL | Stock | 8.8218 | 8.8532 | 8.8036 | 8.8493 | 17552108.0 |
| 2010-04-19 09:35:00 | AAPL | Stock | 8.8521 | 8.8525 | 8.8332 | 8.8479 | 11827228.0 |
| 2010-04-19 09:40:00 | AAPL | Stock | 8.8482 | 8.8511 | 8.8218 | 8.8332 | 9226392.0 |
| 2010-04-19 09:45:00 | AAPL | Stock | 8.8329 | 8.8386 | 8.8139 | 8.8236 | 8387316.0 |
| 2010-04-19 09:50:00 | AAPL | Stock | 8.825 | 8.8304 | 8.8182 | 8.8264 | 6693036.0 |
| 2010-04-19 09:55:00 | AAPL | Stock | 8.8264 | 8.8532 | 8.8254 | 8.8339 | 9956100.0 |
| 2010-04-19 10:00:00 | AAPL | Stock | 8.8339 | 8.8443 | 8.8258 | 8.8282 | 7587776.0 |
| 2010-04-19 10:05:00 | AAPL | Stock | 8.8282 | 8.8393 | 8.8239 | 8.8354 | 7673120.0 |
| 2010-04-19 10:10:00 | AAPL | Stock | 8.8361 | 8.8368 | 8.8282 | 8.8346 | 4814936.0 |
| 2010-04-19 10:15:00 | AAPL | Stock | 8.8339 | 8.8482 | 8.8304 | 8.8311 | 9348024.0 |
| 2010-04-19 10:20:00 | AAPL | Stock | 8.8311 | 8.8393 | 8.8196 | 8.8214 | 7262836.0 |
> showing 50 of 331,404 rows — these rows as CSV