PREVIEW / stock_5min / 2012-12-10
file: by_date/stock_5min/2012/2012-12-10.parquet size: 4.7 MB rows: 321,079 symbols: 3,504
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-10 04:05:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.0832 | 19.0846 | 17584.0 |
| 2012-12-10 04:20:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.075 | 19.075 | 11200.0 |
| 2012-12-10 04:40:00 | AAPL | Stock | 19.0696 | 19.0696 | 19.0696 | 19.0696 | 5600.0 |
| 2012-12-10 04:45:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0607 | 19.0607 | 2800.0 |
| 2012-12-10 05:10:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0193 | 19.0193 | 2800.0 |
| 2012-12-10 05:20:00 | AAPL | Stock | 19.0314 | 19.0314 | 19.0004 | 19.0004 | 5600.0 |
| 2012-12-10 05:50:00 | AAPL | Stock | 18.9775 | 18.9775 | 18.975 | 18.975 | 5600.0 |
| 2012-12-10 05:55:00 | AAPL | Stock | 19.0 | 19.0 | 18.9696 | 18.9696 | 29400.0 |
| 2012-12-10 06:00:00 | AAPL | Stock | 18.9696 | 18.9821 | 18.9696 | 18.9696 | 16800.0 |
| 2012-12-10 06:05:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9464 | 18.9464 | 39200.0 |
| 2012-12-10 06:15:00 | AAPL | Stock | 18.9675 | 18.9675 | 18.9639 | 18.9639 | 8400.0 |
| 2012-12-10 06:20:00 | AAPL | Stock | 18.9375 | 18.9464 | 18.9375 | 18.9464 | 5600.0 |
| 2012-12-10 06:30:00 | AAPL | Stock | 18.9764 | 18.9764 | 18.9764 | 18.9764 | 5600.0 |
| 2012-12-10 06:35:00 | AAPL | Stock | 18.9475 | 18.9475 | 18.9475 | 18.9475 | 2800.0 |
| 2012-12-10 06:45:00 | AAPL | Stock | 18.9482 | 18.9554 | 18.9482 | 18.9554 | 5600.0 |
| 2012-12-10 06:50:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 5600.0 |
| 2012-12-10 07:00:00 | AAPL | Stock | 18.9571 | 18.9571 | 18.9361 | 18.9361 | 16800.0 |
| 2012-12-10 07:05:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.8929 | 18.8932 | 236208.0 |
| 2012-12-10 07:10:00 | AAPL | Stock | 18.8929 | 18.9464 | 18.875 | 18.9321 | 144200.0 |
| 2012-12-10 07:15:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.8846 | 18.8929 | 54152.0 |
| 2012-12-10 07:20:00 | AAPL | Stock | 18.8929 | 18.9107 | 18.8929 | 18.9071 | 28336.0 |
| 2012-12-10 07:25:00 | AAPL | Stock | 18.9207 | 18.9207 | 18.9207 | 18.9207 | 3640.0 |
| 2012-12-10 07:30:00 | AAPL | Stock | 18.9286 | 18.9821 | 18.9286 | 18.9821 | 100800.0 |
| 2012-12-10 07:35:00 | AAPL | Stock | 18.9857 | 18.9943 | 18.9643 | 18.9714 | 86800.0 |
| 2012-12-10 07:40:00 | AAPL | Stock | 18.9661 | 18.9661 | 18.9554 | 18.9607 | 32340.0 |
| 2012-12-10 07:45:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.94 | 18.94 | 86800.0 |
| 2012-12-10 07:50:00 | AAPL | Stock | 18.94 | 18.9498 | 18.94 | 18.94 | 35980.0 |
| 2012-12-10 07:55:00 | AAPL | Stock | 18.9464 | 18.9554 | 18.9464 | 18.9554 | 14000.0 |
| 2012-12-10 08:00:00 | AAPL | Stock | 18.9643 | 18.9964 | 18.8654 | 18.875 | 597604.0 |
| 2012-12-10 08:05:00 | AAPL | Stock | 18.875 | 18.875 | 18.8029 | 18.82 | 462504.0 |
| 2012-12-10 08:10:00 | AAPL | Stock | 18.8089 | 18.8214 | 18.7907 | 18.8054 | 480088.0 |
| 2012-12-10 08:15:00 | AAPL | Stock | 18.8036 | 18.8382 | 18.7975 | 18.7975 | 399084.0 |
| 2012-12-10 08:20:00 | AAPL | Stock | 18.8089 | 18.8543 | 18.8036 | 18.8543 | 254856.0 |
| 2012-12-10 08:25:00 | AAPL | Stock | 18.8429 | 18.8525 | 18.8339 | 18.8429 | 137424.0 |
| 2012-12-10 08:30:00 | AAPL | Stock | 18.84 | 18.8421 | 18.8096 | 18.8246 | 310968.0 |
| 2012-12-10 08:35:00 | AAPL | Stock | 18.8184 | 18.8207 | 18.7675 | 18.78 | 394520.0 |
| 2012-12-10 08:40:00 | AAPL | Stock | 18.7821 | 18.8096 | 18.7607 | 18.7793 | 1195880.0 |
| 2012-12-10 08:45:00 | AAPL | Stock | 18.7725 | 18.8214 | 18.7725 | 18.8214 | 285488.0 |
| 2012-12-10 08:50:00 | AAPL | Stock | 18.8214 | 18.8507 | 18.8146 | 18.8161 | 622468.0 |
| 2012-12-10 08:55:00 | AAPL | Stock | 18.815 | 18.8161 | 18.7857 | 18.8161 | 395080.0 |
| 2012-12-10 09:00:00 | AAPL | Stock | 18.8282 | 18.8711 | 18.8229 | 18.8482 | 325304.0 |
| 2012-12-10 09:05:00 | AAPL | Stock | 18.8489 | 18.8532 | 18.7964 | 18.7964 | 323232.0 |
| 2012-12-10 09:10:00 | AAPL | Stock | 18.7964 | 18.8143 | 18.7796 | 18.7804 | 336476.0 |
| 2012-12-10 09:15:00 | AAPL | Stock | 18.7789 | 18.8032 | 18.7761 | 18.7857 | 349076.0 |
| 2012-12-10 09:20:00 | AAPL | Stock | 18.7893 | 18.7893 | 18.7714 | 18.7793 | 474208.0 |
| 2012-12-10 09:25:00 | AAPL | Stock | 18.7771 | 18.7782 | 18.7357 | 18.7386 | 1925840.0 |
| 2012-12-10 09:30:00 | AAPL | Stock | 18.7439 | 18.8214 | 18.6279 | 18.8204 | 45629080.0 |
| 2012-12-10 09:35:00 | AAPL | Stock | 18.8204 | 18.8825 | 18.7257 | 18.7518 | 21435036.0 |
| 2012-12-10 09:40:00 | AAPL | Stock | 18.7518 | 18.8386 | 18.7039 | 18.8068 | 15321152.0 |
| 2012-12-10 09:45:00 | AAPL | Stock | 18.8129 | 19.0268 | 18.7618 | 19.0029 | 23503928.0 |
> showing 50 of 321,079 rows — these rows as CSV