PREVIEW / stock_5min / 2017-02-10
file: by_date/stock_5min/2017/2017-02-10.parquet size: 5.4 MB rows: 349,454 symbols: 3,108
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-10 04:00:00 | AAPL | Stock | 33.12 | 33.12 | 33.12 | 33.12 | 800.0 |
| 2017-02-10 04:05:00 | AAPL | Stock | 33.1875 | 33.1875 | 33.1875 | 33.1875 | 800.0 |
| 2017-02-10 04:15:00 | AAPL | Stock | 33.175 | 33.175 | 33.175 | 33.175 | 800.0 |
| 2017-02-10 04:20:00 | AAPL | Stock | 33.1475 | 33.15 | 33.13 | 33.13 | 2272.0 |
| 2017-02-10 04:25:00 | AAPL | Stock | 33.125 | 33.125 | 33.125 | 33.125 | 400.0 |
| 2017-02-10 04:30:00 | AAPL | Stock | 33.1125 | 33.1125 | 32.9625 | 33.1 | 17104.0 |
| 2017-02-10 04:40:00 | AAPL | Stock | 33.075 | 33.075 | 33.0625 | 33.075 | 2380.0 |
| 2017-02-10 04:50:00 | AAPL | Stock | 33.0375 | 33.0375 | 33.0375 | 33.0375 | 756.0 |
| 2017-02-10 04:55:00 | AAPL | Stock | 33.025 | 33.025 | 33.025 | 33.025 | 480.0 |
| 2017-02-10 05:00:00 | AAPL | Stock | 33.015 | 33.015 | 33.0075 | 33.0075 | 3200.0 |
| 2017-02-10 05:10:00 | AAPL | Stock | 33.0125 | 33.0125 | 33.0125 | 33.0125 | 1460.0 |
| 2017-02-10 05:15:00 | AAPL | Stock | 33.0375 | 33.0375 | 33.0375 | 33.0375 | 1620.0 |
| 2017-02-10 05:20:00 | AAPL | Stock | 33.0375 | 33.0375 | 33.0375 | 33.0375 | 640.0 |
| 2017-02-10 05:30:00 | AAPL | Stock | 33.0375 | 33.0375 | 33.0375 | 33.0375 | 3600.0 |
| 2017-02-10 05:35:00 | AAPL | Stock | 33.025 | 33.025 | 32.9625 | 33.0 | 18516.0 |
| 2017-02-10 05:40:00 | AAPL | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 4828.0 |
| 2017-02-10 05:45:00 | AAPL | Stock | 33.025 | 33.0375 | 33.02 | 33.0375 | 7528.0 |
| 2017-02-10 06:00:00 | AAPL | Stock | 33.0325 | 33.0475 | 33.015 | 33.0475 | 10000.0 |
| 2017-02-10 06:05:00 | AAPL | Stock | 33.0075 | 33.0075 | 32.9925 | 32.9925 | 8684.0 |
| 2017-02-10 06:10:00 | AAPL | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 4000.0 |
| 2017-02-10 06:15:00 | AAPL | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 9816.0 |
| 2017-02-10 06:20:00 | AAPL | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 4800.0 |
| 2017-02-10 06:25:00 | AAPL | Stock | 32.9875 | 33.0 | 32.9825 | 33.0 | 5296.0 |
| 2017-02-10 06:30:00 | AAPL | Stock | 33.0 | 33.0 | 33.0 | 33.0 | 1900.0 |
| 2017-02-10 06:55:00 | AAPL | Stock | 33.025 | 33.025 | 33.025 | 33.025 | 4000.0 |
| 2017-02-10 07:00:00 | AAPL | Stock | 33.0375 | 33.0475 | 33.0375 | 33.0475 | 2000.0 |
| 2017-02-10 07:05:00 | AAPL | Stock | 33.045 | 33.0625 | 33.045 | 33.0625 | 9912.0 |
| 2017-02-10 07:10:00 | AAPL | Stock | 33.0625 | 33.0725 | 33.0625 | 33.0725 | 5400.0 |
| 2017-02-10 07:20:00 | AAPL | Stock | 33.0575 | 33.0575 | 33.0575 | 33.0575 | 3288.0 |
| 2017-02-10 07:35:00 | AAPL | Stock | 33.07 | 33.0725 | 33.07 | 33.0725 | 8712.0 |
| 2017-02-10 07:40:00 | AAPL | Stock | 33.0725 | 33.0725 | 33.07 | 33.07 | 1500.0 |
| 2017-02-10 07:45:00 | AAPL | Stock | 33.075 | 33.075 | 33.0625 | 33.0625 | 2600.0 |
| 2017-02-10 07:55:00 | AAPL | Stock | 33.065 | 33.065 | 33.065 | 33.065 | 1200.0 |
| 2017-02-10 08:00:00 | AAPL | Stock | 33.0875 | 33.1175 | 33.0 | 33.02 | 106712.0 |
| 2017-02-10 08:05:00 | AAPL | Stock | 33.05 | 33.065 | 33.05 | 33.065 | 1200.0 |
| 2017-02-10 08:10:00 | AAPL | Stock | 33.0675 | 33.075 | 33.045 | 33.045 | 28216.0 |
| 2017-02-10 08:15:00 | AAPL | Stock | 33.045 | 33.0625 | 33.04 | 33.0625 | 10144.0 |
| 2017-02-10 08:20:00 | AAPL | Stock | 33.0475 | 33.06 | 33.0475 | 33.05 | 3644.0 |
| 2017-02-10 08:25:00 | AAPL | Stock | 33.0475 | 33.07 | 33.0475 | 33.07 | 18960.0 |
| 2017-02-10 08:30:00 | AAPL | Stock | 33.0625 | 33.095 | 33.0625 | 33.095 | 11872.0 |
| 2017-02-10 08:35:00 | AAPL | Stock | 33.0875 | 33.0975 | 33.0775 | 33.0925 | 8144.0 |
| 2017-02-10 08:40:00 | AAPL | Stock | 33.0975 | 33.0975 | 33.0975 | 33.0975 | 1856.0 |
| 2017-02-10 08:45:00 | AAPL | Stock | 33.0975 | 33.1 | 33.09 | 33.09 | 30116.0 |
| 2017-02-10 08:50:00 | AAPL | Stock | 33.0975 | 33.1 | 33.08 | 33.0825 | 11076.0 |
| 2017-02-10 08:55:00 | AAPL | Stock | 33.09 | 33.1 | 33.09 | 33.1 | 4620.0 |
| 2017-02-10 09:00:00 | AAPL | Stock | 33.1 | 33.1125 | 33.085 | 33.105 | 27428.0 |
| 2017-02-10 09:05:00 | AAPL | Stock | 33.1175 | 33.125 | 33.105 | 33.1125 | 20212.0 |
| 2017-02-10 09:10:00 | AAPL | Stock | 33.1125 | 33.1225 | 33.095 | 33.095 | 30376.0 |
| 2017-02-10 09:15:00 | AAPL | Stock | 33.0925 | 33.1025 | 33.0925 | 33.1025 | 6360.0 |
| 2017-02-10 09:20:00 | AAPL | Stock | 33.1 | 33.1125 | 33.0975 | 33.1025 | 15892.0 |
> showing 50 of 349,454 rows — these rows as CSV