PREVIEW / stock_5min / 2010-11-19
file: by_date/stock_5min/2010/2010-11-19.parquet size: 4.6 MB rows: 318,542 symbols: 3,525
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-11-19 04:00:00 | AAPL | Stock | 11.0357 | 11.0429 | 11.0357 | 11.0429 | 8400.0 |
| 2010-11-19 04:05:00 | AAPL | Stock | 11.0357 | 11.0357 | 11.0357 | 11.0357 | 2800.0 |
| 2010-11-19 04:35:00 | AAPL | Stock | 11.0093 | 11.0093 | 11.0093 | 11.0093 | 2800.0 |
| 2010-11-19 05:30:00 | AAPL | Stock | 11.0093 | 11.0139 | 10.9971 | 11.0139 | 14000.0 |
| 2010-11-19 05:45:00 | AAPL | Stock | 11.025 | 11.025 | 11.025 | 11.025 | 2800.0 |
| 2010-11-19 05:55:00 | AAPL | Stock | 11.0332 | 11.0332 | 11.0332 | 11.0332 | 2800.0 |
| 2010-11-19 06:00:00 | AAPL | Stock | 11.0429 | 11.0479 | 11.0429 | 11.0479 | 5600.0 |
| 2010-11-19 07:00:00 | AAPL | Stock | 11.0179 | 11.0379 | 11.0179 | 11.0182 | 11200.0 |
| 2010-11-19 07:05:00 | AAPL | Stock | 11.0182 | 11.0182 | 11.0064 | 11.0064 | 19600.0 |
| 2010-11-19 07:15:00 | AAPL | Stock | 11.0143 | 11.0143 | 11.0143 | 11.0143 | 8316.0 |
| 2010-11-19 07:20:00 | AAPL | Stock | 11.0143 | 11.0143 | 10.9857 | 10.9857 | 42084.0 |
| 2010-11-19 07:25:00 | AAPL | Stock | 10.9789 | 10.9789 | 10.9786 | 10.9786 | 15400.0 |
| 2010-11-19 07:30:00 | AAPL | Stock | 10.9579 | 10.9579 | 10.9579 | 10.9579 | 2800.0 |
| 2010-11-19 07:35:00 | AAPL | Stock | 10.9854 | 10.9854 | 10.9818 | 10.9818 | 11900.0 |
| 2010-11-19 07:45:00 | AAPL | Stock | 10.9893 | 10.9893 | 10.9893 | 10.9893 | 8400.0 |
| 2010-11-19 07:55:00 | AAPL | Stock | 10.9821 | 10.9864 | 10.9821 | 10.9864 | 16800.0 |
| 2010-11-19 08:00:00 | AAPL | Stock | 10.9857 | 10.9943 | 10.9754 | 10.9943 | 299600.0 |
| 2010-11-19 08:05:00 | AAPL | Stock | 10.9946 | 11.0082 | 10.9918 | 11.0021 | 157360.0 |
| 2010-11-19 08:10:00 | AAPL | Stock | 11.005 | 11.0179 | 11.0043 | 11.0171 | 264180.0 |
| 2010-11-19 08:15:00 | AAPL | Stock | 11.0161 | 11.0161 | 11.0089 | 11.0132 | 68880.0 |
| 2010-11-19 08:20:00 | AAPL | Stock | 11.0107 | 11.0157 | 11.0071 | 11.0071 | 79380.0 |
| 2010-11-19 08:25:00 | AAPL | Stock | 11.0018 | 11.0136 | 11.0018 | 11.0071 | 20860.0 |
| 2010-11-19 08:30:00 | AAPL | Stock | 11.0054 | 11.0139 | 11.0029 | 11.0139 | 43792.0 |
| 2010-11-19 08:35:00 | AAPL | Stock | 11.0157 | 11.0157 | 11.0082 | 11.01 | 25200.0 |
| 2010-11-19 08:40:00 | AAPL | Stock | 11.0132 | 11.0161 | 11.0118 | 11.0118 | 33600.0 |
| 2010-11-19 08:45:00 | AAPL | Stock | 11.0136 | 11.0179 | 11.0136 | 11.0154 | 66584.0 |
| 2010-11-19 08:50:00 | AAPL | Stock | 11.0143 | 11.0286 | 11.0143 | 11.0286 | 293412.0 |
| 2010-11-19 08:55:00 | AAPL | Stock | 11.0225 | 11.0293 | 11.0179 | 11.0179 | 151620.0 |
| 2010-11-19 09:00:00 | AAPL | Stock | 11.0182 | 11.0182 | 10.9936 | 10.9939 | 490448.0 |
| 2010-11-19 09:05:00 | AAPL | Stock | 10.995 | 10.9961 | 10.9871 | 10.9932 | 207228.0 |
| 2010-11-19 09:10:00 | AAPL | Stock | 10.9914 | 10.9946 | 10.9904 | 10.9932 | 117740.0 |
| 2010-11-19 09:15:00 | AAPL | Stock | 10.9936 | 10.9943 | 10.9839 | 10.9936 | 97580.0 |
| 2010-11-19 09:20:00 | AAPL | Stock | 10.9946 | 11.0 | 10.9918 | 10.9971 | 65128.0 |
| 2010-11-19 09:25:00 | AAPL | Stock | 10.99 | 11.0 | 10.9896 | 11.0 | 209496.0 |
| 2010-11-19 09:30:00 | AAPL | Stock | 10.9989 | 11.0143 | 10.9643 | 10.997 | 46789792.0 |
| 2010-11-19 09:35:00 | AAPL | Stock | 10.9968 | 11.0046 | 10.9597 | 10.9618 | 10682504.0 |
| 2010-11-19 09:40:00 | AAPL | Stock | 10.9629 | 10.9821 | 10.9586 | 10.9736 | 8668268.0 |
| 2010-11-19 09:45:00 | AAPL | Stock | 10.9739 | 10.9818 | 10.9579 | 10.9621 | 9075472.0 |
| 2010-11-19 09:50:00 | AAPL | Stock | 10.9607 | 10.9643 | 10.9464 | 10.9501 | 8700216.0 |
| 2010-11-19 09:55:00 | AAPL | Stock | 10.9521 | 10.9625 | 10.9482 | 10.9564 | 6611696.0 |
| 2010-11-19 10:00:00 | AAPL | Stock | 10.9579 | 10.9614 | 10.9364 | 10.9464 | 8815800.0 |
| 2010-11-19 10:05:00 | AAPL | Stock | 10.9461 | 10.9481 | 10.9214 | 10.9432 | 8190196.0 |
| 2010-11-19 10:10:00 | AAPL | Stock | 10.9414 | 10.9639 | 10.9336 | 10.955 | 7637084.0 |
| 2010-11-19 10:15:00 | AAPL | Stock | 10.9579 | 10.9664 | 10.9314 | 10.9532 | 6268220.0 |
| 2010-11-19 10:20:00 | AAPL | Stock | 10.9532 | 10.955 | 10.9304 | 10.9464 | 4235952.0 |
| 2010-11-19 10:25:00 | AAPL | Stock | 10.9457 | 10.9489 | 10.9268 | 10.9446 | 6049624.0 |
| 2010-11-19 10:30:00 | AAPL | Stock | 10.945 | 10.9457 | 10.9314 | 10.9411 | 3414516.0 |
| 2010-11-19 10:35:00 | AAPL | Stock | 10.9411 | 10.9514 | 10.9339 | 10.9486 | 4547312.0 |
| 2010-11-19 10:40:00 | AAPL | Stock | 10.9493 | 10.975 | 10.9457 | 10.9732 | 9125704.0 |
| 2010-11-19 10:45:00 | AAPL | Stock | 10.9736 | 10.9846 | 10.9714 | 10.9771 | 7591864.0 |
> showing 50 of 318,542 rows — these rows as CSV