PREVIEW / stock_5min / 2017-08-31
file: by_date/stock_5min/2017/2017-08-31.parquet size: 5.5 MB rows: 357,246 symbols: 3,006
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-08-31 04:00:00 | AAPL | Stock | 40.875 | 40.875 | 40.875 | 40.875 | 1152.0 |
| 2017-08-31 04:05:00 | AAPL | Stock | 40.815 | 40.815 | 40.8125 | 40.8125 | 800.0 |
| 2017-08-31 04:10:00 | AAPL | Stock | 40.875 | 40.875 | 40.825 | 40.825 | 4800.0 |
| 2017-08-31 04:15:00 | AAPL | Stock | 40.875 | 40.875 | 40.875 | 40.875 | 1712.0 |
| 2017-08-31 04:20:00 | AAPL | Stock | 40.875 | 40.875 | 40.875 | 40.875 | 512.0 |
| 2017-08-31 04:30:00 | AAPL | Stock | 40.875 | 40.875 | 40.875 | 40.875 | 992.0 |
| 2017-08-31 04:50:00 | AAPL | Stock | 40.9125 | 40.92 | 40.9125 | 40.92 | 3600.0 |
| 2017-08-31 05:00:00 | AAPL | Stock | 40.9275 | 40.9275 | 40.9275 | 40.9275 | 2600.0 |
| 2017-08-31 05:10:00 | AAPL | Stock | 40.925 | 40.925 | 40.925 | 40.925 | 800.0 |
| 2017-08-31 05:15:00 | AAPL | Stock | 40.9375 | 40.94 | 40.9375 | 40.9375 | 7720.0 |
| 2017-08-31 05:45:00 | AAPL | Stock | 40.9375 | 40.9375 | 40.925 | 40.925 | 980.0 |
| 2017-08-31 05:55:00 | AAPL | Stock | 40.975 | 40.975 | 40.975 | 40.975 | 800.0 |
| 2017-08-31 06:00:00 | AAPL | Stock | 40.95 | 40.95 | 40.95 | 40.95 | 5684.0 |
| 2017-08-31 06:05:00 | AAPL | Stock | 40.9375 | 40.9375 | 40.9375 | 40.9375 | 3360.0 |
| 2017-08-31 06:10:00 | AAPL | Stock | 40.9375 | 40.9375 | 40.9375 | 40.9375 | 800.0 |
| 2017-08-31 06:20:00 | AAPL | Stock | 40.9375 | 40.9375 | 40.9375 | 40.9375 | 4000.0 |
| 2017-08-31 06:35:00 | AAPL | Stock | 40.9125 | 40.9125 | 40.9125 | 40.9125 | 4980.0 |
| 2017-08-31 06:40:00 | AAPL | Stock | 40.9 | 40.9 | 40.9 | 40.9 | 2000.0 |
| 2017-08-31 06:45:00 | AAPL | Stock | 40.9 | 40.9 | 40.9 | 40.9 | 2000.0 |
| 2017-08-31 06:50:00 | AAPL | Stock | 40.9 | 40.9 | 40.9 | 40.9 | 4000.0 |
| 2017-08-31 06:55:00 | AAPL | Stock | 40.9 | 40.9 | 40.9 | 40.9 | 8400.0 |
| 2017-08-31 07:00:00 | AAPL | Stock | 40.9 | 40.9025 | 40.9 | 40.9 | 15100.0 |
| 2017-08-31 07:10:00 | AAPL | Stock | 40.9175 | 40.9175 | 40.9125 | 40.9175 | 4748.0 |
| 2017-08-31 07:15:00 | AAPL | Stock | 40.915 | 40.9175 | 40.9125 | 40.915 | 8324.0 |
| 2017-08-31 07:20:00 | AAPL | Stock | 40.91 | 40.91 | 40.895 | 40.895 | 8044.0 |
| 2017-08-31 07:30:00 | AAPL | Stock | 40.905 | 40.91 | 40.895 | 40.895 | 22436.0 |
| 2017-08-31 07:35:00 | AAPL | Stock | 40.9 | 40.9 | 40.8875 | 40.8975 | 6548.0 |
| 2017-08-31 07:40:00 | AAPL | Stock | 40.8975 | 40.905 | 40.8975 | 40.905 | 2300.0 |
| 2017-08-31 07:45:00 | AAPL | Stock | 40.8925 | 40.91 | 40.8925 | 40.91 | 1108.0 |
| 2017-08-31 07:50:00 | AAPL | Stock | 40.8875 | 40.905 | 40.885 | 40.885 | 7508.0 |
| 2017-08-31 07:55:00 | AAPL | Stock | 40.8775 | 40.8775 | 40.8775 | 40.8775 | 1820.0 |
| 2017-08-31 08:00:00 | AAPL | Stock | 40.9 | 40.91 | 40.8525 | 40.8825 | 60640.0 |
| 2017-08-31 08:05:00 | AAPL | Stock | 40.885 | 40.895 | 40.885 | 40.89 | 8380.0 |
| 2017-08-31 08:10:00 | AAPL | Stock | 40.895 | 40.915 | 40.895 | 40.915 | 33276.0 |
| 2017-08-31 08:15:00 | AAPL | Stock | 40.915 | 40.9175 | 40.9025 | 40.9075 | 43044.0 |
| 2017-08-31 08:20:00 | AAPL | Stock | 40.9075 | 40.9075 | 40.895 | 40.9 | 23824.0 |
| 2017-08-31 08:25:00 | AAPL | Stock | 40.9 | 40.9075 | 40.89 | 40.9 | 27992.0 |
| 2017-08-31 08:30:00 | AAPL | Stock | 40.9 | 40.9175 | 40.9 | 40.9175 | 61204.0 |
| 2017-08-31 08:35:00 | AAPL | Stock | 40.9125 | 40.9125 | 40.9125 | 40.9125 | 5324.0 |
| 2017-08-31 08:40:00 | AAPL | Stock | 40.9125 | 40.9175 | 40.9 | 40.9 | 7868.0 |
| 2017-08-31 08:45:00 | AAPL | Stock | 40.9 | 40.9175 | 40.9 | 40.9125 | 6580.0 |
| 2017-08-31 08:50:00 | AAPL | Stock | 40.9125 | 40.9125 | 40.8775 | 40.8925 | 28732.0 |
| 2017-08-31 08:55:00 | AAPL | Stock | 40.8825 | 40.89 | 40.8825 | 40.89 | 5060.0 |
| 2017-08-31 09:00:00 | AAPL | Stock | 40.8875 | 40.8875 | 40.865 | 40.8775 | 96000.0 |
| 2017-08-31 09:05:00 | AAPL | Stock | 40.8775 | 40.8775 | 40.8775 | 40.8775 | 2880.0 |
| 2017-08-31 09:10:00 | AAPL | Stock | 40.8775 | 40.8875 | 40.875 | 40.885 | 7800.0 |
| 2017-08-31 09:15:00 | AAPL | Stock | 40.8875 | 40.8875 | 40.88 | 40.885 | 5220.0 |
| 2017-08-31 09:20:00 | AAPL | Stock | 40.88 | 40.9 | 40.875 | 40.8875 | 35960.0 |
| 2017-08-31 09:25:00 | AAPL | Stock | 40.8875 | 40.91 | 40.8875 | 40.9075 | 32240.0 |
| 2017-08-31 09:30:00 | AAPL | Stock | 40.91 | 41.0025 | 40.89 | 40.9575 | 4598384.0 |
> showing 50 of 357,246 rows — these rows as CSV