PREVIEW / stock_5min / 2019-07-18
file: by_date/stock_5min/2019/2019-07-18.parquet size: 5.6 MB rows: 352,412 symbols: 2,583
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-18 04:00:00 | AAPL | Stock | 51.125 | 51.1725 | 51.0025 | 51.0125 | 27972.0 |
| 2019-07-18 04:05:00 | AAPL | Stock | 51.0375 | 51.095 | 51.0375 | 51.0775 | 3200.0 |
| 2019-07-18 04:15:00 | AAPL | Stock | 51.1 | 51.105 | 51.1 | 51.1 | 4160.0 |
| 2019-07-18 04:20:00 | AAPL | Stock | 51.0975 | 51.1325 | 51.0975 | 51.125 | 9712.0 |
| 2019-07-18 04:25:00 | AAPL | Stock | 51.1 | 51.1 | 51.1 | 51.1 | 1236.0 |
| 2019-07-18 04:35:00 | AAPL | Stock | 51.11 | 51.11 | 51.1025 | 51.1025 | 4000.0 |
| 2019-07-18 04:55:00 | AAPL | Stock | 51.115 | 51.115 | 51.115 | 51.115 | 608.0 |
| 2019-07-18 05:00:00 | AAPL | Stock | 51.075 | 51.1375 | 51.075 | 51.1375 | 3600.0 |
| 2019-07-18 05:05:00 | AAPL | Stock | 51.1375 | 51.15 | 51.1375 | 51.15 | 2828.0 |
| 2019-07-18 05:45:00 | AAPL | Stock | 51.0875 | 51.0875 | 51.035 | 51.035 | 3200.0 |
| 2019-07-18 05:50:00 | AAPL | Stock | 51.0375 | 51.0375 | 51.0275 | 51.0325 | 4840.0 |
| 2019-07-18 05:55:00 | AAPL | Stock | 51.0325 | 51.0325 | 51.025 | 51.025 | 4400.0 |
| 2019-07-18 06:00:00 | AAPL | Stock | 50.975 | 51.0325 | 50.975 | 50.98 | 10760.0 |
| 2019-07-18 06:05:00 | AAPL | Stock | 51.0375 | 51.0375 | 51.0375 | 51.0375 | 800.0 |
| 2019-07-18 06:15:00 | AAPL | Stock | 51.0375 | 51.0375 | 51.0375 | 51.0375 | 400.0 |
| 2019-07-18 06:20:00 | AAPL | Stock | 51.005 | 51.005 | 51.005 | 51.005 | 1188.0 |
| 2019-07-18 06:30:00 | AAPL | Stock | 51.025 | 51.025 | 51.025 | 51.025 | 3800.0 |
| 2019-07-18 06:35:00 | AAPL | Stock | 51.075 | 51.075 | 51.0625 | 51.0625 | 3440.0 |
| 2019-07-18 06:45:00 | AAPL | Stock | 51.075 | 51.0825 | 51.075 | 51.0825 | 4000.0 |
| 2019-07-18 06:50:00 | AAPL | Stock | 51.075 | 51.0875 | 51.075 | 51.0875 | 2992.0 |
| 2019-07-18 06:55:00 | AAPL | Stock | 51.0625 | 51.0625 | 51.0625 | 51.0625 | 400.0 |
| 2019-07-18 07:00:00 | AAPL | Stock | 51.0625 | 51.1125 | 50.875 | 51.0 | 104592.0 |
| 2019-07-18 07:05:00 | AAPL | Stock | 51.0 | 51.0 | 50.95 | 50.95 | 7140.0 |
| 2019-07-18 07:10:00 | AAPL | Stock | 50.95 | 51.0275 | 50.95 | 51.0275 | 28960.0 |
| 2019-07-18 07:15:00 | AAPL | Stock | 51.02 | 51.02 | 51.0025 | 51.0025 | 2592.0 |
| 2019-07-18 07:25:00 | AAPL | Stock | 50.9725 | 51.0125 | 50.9725 | 51.0125 | 5892.0 |
| 2019-07-18 07:30:00 | AAPL | Stock | 51.0125 | 51.0125 | 50.995 | 50.995 | 6736.0 |
| 2019-07-18 07:35:00 | AAPL | Stock | 50.98 | 50.98 | 50.95 | 50.975 | 8856.0 |
| 2019-07-18 07:40:00 | AAPL | Stock | 50.985 | 50.9875 | 50.985 | 50.9875 | 4400.0 |
| 2019-07-18 07:45:00 | AAPL | Stock | 50.995 | 51.025 | 50.995 | 51.025 | 3000.0 |
| 2019-07-18 07:50:00 | AAPL | Stock | 51.0175 | 51.0175 | 50.975 | 50.9875 | 5196.0 |
| 2019-07-18 07:55:00 | AAPL | Stock | 50.9875 | 50.9975 | 50.975 | 50.975 | 4800.0 |
| 2019-07-18 08:00:00 | AAPL | Stock | 51.02 | 51.045 | 50.925 | 50.9625 | 53156.0 |
| 2019-07-18 08:05:00 | AAPL | Stock | 50.995 | 51.01 | 50.995 | 51.0 | 8652.0 |
| 2019-07-18 08:10:00 | AAPL | Stock | 51.0 | 51.0275 | 51.0 | 51.01 | 23276.0 |
| 2019-07-18 08:15:00 | AAPL | Stock | 51.0125 | 51.0125 | 51.0125 | 51.0125 | 6496.0 |
| 2019-07-18 08:20:00 | AAPL | Stock | 51.0 | 51.0025 | 50.975 | 50.975 | 36368.0 |
| 2019-07-18 08:25:00 | AAPL | Stock | 50.9762 | 51.0125 | 50.975 | 51.0 | 8080.0 |
| 2019-07-18 08:30:00 | AAPL | Stock | 51.02 | 51.095 | 51.005 | 51.0875 | 64572.0 |
| 2019-07-18 08:35:00 | AAPL | Stock | 51.065 | 51.0725 | 51.025 | 51.0375 | 40752.0 |
| 2019-07-18 08:40:00 | AAPL | Stock | 51.0325 | 51.0325 | 51.0175 | 51.0175 | 18668.0 |
| 2019-07-18 08:45:00 | AAPL | Stock | 51.0225 | 51.03 | 51.0175 | 51.03 | 5180.0 |
| 2019-07-18 08:50:00 | AAPL | Stock | 51.0375 | 51.0375 | 51.015 | 51.015 | 20312.0 |
| 2019-07-18 08:55:00 | AAPL | Stock | 51.025 | 51.05 | 51.015 | 51.015 | 23896.0 |
| 2019-07-18 09:00:00 | AAPL | Stock | 51.015 | 51.015 | 50.9675 | 50.9675 | 14896.0 |
| 2019-07-18 09:05:00 | AAPL | Stock | 50.975 | 50.995 | 50.9675 | 50.9925 | 10160.0 |
| 2019-07-18 09:10:00 | AAPL | Stock | 50.98 | 50.9875 | 50.965 | 50.965 | 3956.0 |
| 2019-07-18 09:15:00 | AAPL | Stock | 50.975 | 50.975 | 50.9375 | 50.975 | 10728.0 |
| 2019-07-18 09:20:00 | AAPL | Stock | 50.965 | 50.965 | 50.95 | 50.9625 | 45492.0 |
| 2019-07-18 09:25:00 | AAPL | Stock | 50.9625 | 51.0225 | 50.925 | 51.0025 | 56448.0 |
> showing 50 of 352,412 rows — these rows as CSV