PREVIEW / stock_5min / 2019-05-17
file: by_date/stock_5min/2019/2019-05-17.parquet size: 5.6 MB rows: 353,040 symbols: 2,609
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-05-17 04:00:00 | AAPL | Stock | 47.375 | 47.375 | 47.305 | 47.3125 | 29288.0 |
| 2019-05-17 04:05:00 | AAPL | Stock | 47.3125 | 47.3125 | 47.275 | 47.275 | 34700.0 |
| 2019-05-17 04:10:00 | AAPL | Stock | 47.275 | 47.275 | 47.25 | 47.25 | 16804.0 |
| 2019-05-17 04:20:00 | AAPL | Stock | 47.345 | 47.345 | 47.345 | 47.345 | 400.0 |
| 2019-05-17 04:25:00 | AAPL | Stock | 47.3275 | 47.3275 | 47.195 | 47.195 | 13688.0 |
| 2019-05-17 04:30:00 | AAPL | Stock | 47.18 | 47.18 | 47.155 | 47.155 | 2460.0 |
| 2019-05-17 04:35:00 | AAPL | Stock | 47.155 | 47.155 | 47.155 | 47.155 | 400.0 |
| 2019-05-17 04:40:00 | AAPL | Stock | 47.1575 | 47.1575 | 47.1575 | 47.1575 | 3112.0 |
| 2019-05-17 04:50:00 | AAPL | Stock | 47.155 | 47.1925 | 47.15 | 47.15 | 11496.0 |
| 2019-05-17 04:55:00 | AAPL | Stock | 47.1425 | 47.1425 | 47.0625 | 47.07 | 6936.0 |
| 2019-05-17 05:00:00 | AAPL | Stock | 47.095 | 47.095 | 47.095 | 47.095 | 1200.0 |
| 2019-05-17 05:05:00 | AAPL | Stock | 47.1025 | 47.1025 | 47.1 | 47.1 | 2000.0 |
| 2019-05-17 05:10:00 | AAPL | Stock | 47.1 | 47.1025 | 47.1 | 47.1025 | 5164.0 |
| 2019-05-17 05:15:00 | AAPL | Stock | 47.09 | 47.125 | 47.0875 | 47.125 | 2400.0 |
| 2019-05-17 05:30:00 | AAPL | Stock | 47.145 | 47.15 | 47.145 | 47.15 | 1200.0 |
| 2019-05-17 05:35:00 | AAPL | Stock | 47.185 | 47.235 | 47.185 | 47.235 | 1600.0 |
| 2019-05-17 05:40:00 | AAPL | Stock | 47.24 | 47.245 | 47.24 | 47.245 | 1600.0 |
| 2019-05-17 05:45:00 | AAPL | Stock | 47.265 | 47.265 | 47.235 | 47.235 | 2796.0 |
| 2019-05-17 06:00:00 | AAPL | Stock | 47.2025 | 47.2025 | 47.1875 | 47.19 | 4220.0 |
| 2019-05-17 06:20:00 | AAPL | Stock | 47.1425 | 47.1425 | 47.1425 | 47.1425 | 400.0 |
| 2019-05-17 06:25:00 | AAPL | Stock | 47.0925 | 47.0925 | 47.0275 | 47.045 | 7124.0 |
| 2019-05-17 06:30:00 | AAPL | Stock | 47.05 | 47.05 | 47.035 | 47.045 | 3200.0 |
| 2019-05-17 06:35:00 | AAPL | Stock | 47.055 | 47.055 | 47.0 | 47.0 | 5152.0 |
| 2019-05-17 06:40:00 | AAPL | Stock | 47.0 | 47.0 | 46.905 | 46.905 | 3920.0 |
| 2019-05-17 06:45:00 | AAPL | Stock | 46.925 | 46.9725 | 46.925 | 46.9725 | 2240.0 |
| 2019-05-17 06:55:00 | AAPL | Stock | 47.0025 | 47.0025 | 47.0025 | 47.0025 | 580.0 |
| 2019-05-17 07:00:00 | AAPL | Stock | 47.05 | 47.1125 | 47.0025 | 47.075 | 29952.0 |
| 2019-05-17 07:05:00 | AAPL | Stock | 47.0325 | 47.0325 | 46.975 | 46.975 | 24236.0 |
| 2019-05-17 07:10:00 | AAPL | Stock | 46.975 | 46.9875 | 46.9375 | 46.95 | 14380.0 |
| 2019-05-17 07:15:00 | AAPL | Stock | 46.975 | 46.9975 | 46.9375 | 46.9375 | 33584.0 |
| 2019-05-17 07:20:00 | AAPL | Stock | 46.9375 | 46.9375 | 46.9 | 46.9375 | 15200.0 |
| 2019-05-17 07:25:00 | AAPL | Stock | 46.9325 | 46.9375 | 46.875 | 46.875 | 41940.0 |
| 2019-05-17 07:30:00 | AAPL | Stock | 46.8625 | 46.865 | 46.825 | 46.8375 | 59232.0 |
| 2019-05-17 07:35:00 | AAPL | Stock | 46.8425 | 46.905 | 46.815 | 46.905 | 8132.0 |
| 2019-05-17 07:40:00 | AAPL | Stock | 46.83 | 46.845 | 46.8025 | 46.845 | 16160.0 |
| 2019-05-17 07:45:00 | AAPL | Stock | 46.8625 | 46.8675 | 46.85 | 46.8625 | 9640.0 |
| 2019-05-17 07:50:00 | AAPL | Stock | 46.8525 | 46.8525 | 46.8 | 46.82 | 47276.0 |
| 2019-05-17 07:55:00 | AAPL | Stock | 46.82 | 46.86 | 46.805 | 46.86 | 3028.0 |
| 2019-05-17 08:00:00 | AAPL | Stock | 47.086 | 47.6375 | 46.8 | 46.805 | 119468.0 |
| 2019-05-17 08:05:00 | AAPL | Stock | 46.8325 | 46.8325 | 46.78 | 46.78 | 15152.0 |
| 2019-05-17 08:10:00 | AAPL | Stock | 46.7875 | 46.8225 | 46.7775 | 46.8075 | 8488.0 |
| 2019-05-17 08:15:00 | AAPL | Stock | 46.795 | 46.8325 | 46.7875 | 46.8325 | 27072.0 |
| 2019-05-17 08:20:00 | AAPL | Stock | 46.8375 | 46.8375 | 46.7625 | 46.7625 | 47988.0 |
| 2019-05-17 08:25:00 | AAPL | Stock | 46.755 | 46.755 | 46.625 | 46.6275 | 73688.0 |
| 2019-05-17 08:30:00 | AAPL | Stock | 46.625 | 46.675 | 46.595 | 46.635 | 77060.0 |
| 2019-05-17 08:35:00 | AAPL | Stock | 46.6375 | 46.7875 | 46.61 | 46.775 | 53488.0 |
| 2019-05-17 08:40:00 | AAPL | Stock | 46.7627 | 46.8 | 46.6875 | 46.775 | 56296.0 |
| 2019-05-17 08:45:00 | AAPL | Stock | 46.75 | 46.7825 | 46.7 | 46.725 | 37372.0 |
| 2019-05-17 08:50:00 | AAPL | Stock | 46.705 | 46.75 | 46.6875 | 46.6875 | 40680.0 |
| 2019-05-17 08:55:00 | AAPL | Stock | 46.6875 | 46.725 | 46.6875 | 46.725 | 14416.0 |
> showing 50 of 353,040 rows — these rows as CSV