PREVIEW / stock_5min / 2019-08-15
file: by_date/stock_5min/2019/2019-08-15.parquet size: 5.7 MB rows: 363,086 symbols: 2,556
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-08-15 04:00:00 | AAPL | Stock | 50.9175 | 50.92 | 50.8975 | 50.8975 | 2788.0 |
| 2019-08-15 04:10:00 | AAPL | Stock | 50.8925 | 50.9 | 50.825 | 50.825 | 5968.0 |
| 2019-08-15 04:15:00 | AAPL | Stock | 50.8325 | 50.9175 | 50.83 | 50.9175 | 1200.0 |
| 2019-08-15 04:20:00 | AAPL | Stock | 50.925 | 50.925 | 50.9 | 50.9 | 3840.0 |
| 2019-08-15 04:25:00 | AAPL | Stock | 50.95 | 50.95 | 50.95 | 50.95 | 400.0 |
| 2019-08-15 04:35:00 | AAPL | Stock | 51.025 | 51.05 | 51.025 | 51.05 | 8576.0 |
| 2019-08-15 04:45:00 | AAPL | Stock | 51.0425 | 51.0425 | 51.03 | 51.03 | 1508.0 |
| 2019-08-15 04:50:00 | AAPL | Stock | 51.05 | 51.05 | 51.0 | 51.0 | 1952.0 |
| 2019-08-15 04:55:00 | AAPL | Stock | 50.9 | 50.9 | 50.9 | 50.9 | 800.0 |
| 2019-08-15 05:00:00 | AAPL | Stock | 50.9 | 50.9 | 50.6 | 50.6 | 14852.0 |
| 2019-08-15 05:05:00 | AAPL | Stock | 50.65 | 50.65 | 50.535 | 50.535 | 3516.0 |
| 2019-08-15 05:10:00 | AAPL | Stock | 50.65 | 50.65 | 50.65 | 50.65 | 800.0 |
| 2019-08-15 05:15:00 | AAPL | Stock | 50.6875 | 50.6875 | 50.6625 | 50.6625 | 800.0 |
| 2019-08-15 05:20:00 | AAPL | Stock | 50.675 | 50.7 | 50.65 | 50.65 | 1200.0 |
| 2019-08-15 05:25:00 | AAPL | Stock | 50.6525 | 50.6525 | 50.54 | 50.54 | 3572.0 |
| 2019-08-15 05:40:00 | AAPL | Stock | 50.465 | 50.465 | 50.465 | 50.465 | 400.0 |
| 2019-08-15 05:45:00 | AAPL | Stock | 50.375 | 50.375 | 50.13 | 50.13 | 2964.0 |
| 2019-08-15 05:50:00 | AAPL | Stock | 50.15 | 50.2 | 50.15 | 50.2 | 2000.0 |
| 2019-08-15 06:05:00 | AAPL | Stock | 50.1925 | 50.1925 | 50.15 | 50.15 | 4720.0 |
| 2019-08-15 06:10:00 | AAPL | Stock | 50.1975 | 50.25 | 50.1975 | 50.25 | 4400.0 |
| 2019-08-15 06:15:00 | AAPL | Stock | 50.1375 | 50.1375 | 50.0275 | 50.0275 | 4716.0 |
| 2019-08-15 06:20:00 | AAPL | Stock | 50.0275 | 50.0275 | 50.0275 | 50.0275 | 400.0 |
| 2019-08-15 06:25:00 | AAPL | Stock | 50.075 | 50.1 | 50.0 | 50.0 | 9672.0 |
| 2019-08-15 06:30:00 | AAPL | Stock | 49.9675 | 49.99 | 49.9675 | 49.97 | 2628.0 |
| 2019-08-15 06:35:00 | AAPL | Stock | 49.95 | 49.9775 | 49.845 | 49.845 | 15660.0 |
| 2019-08-15 06:40:00 | AAPL | Stock | 49.7825 | 49.8875 | 49.7825 | 49.8875 | 9412.0 |
| 2019-08-15 06:45:00 | AAPL | Stock | 49.8425 | 49.87 | 49.8325 | 49.85 | 3336.0 |
| 2019-08-15 06:50:00 | AAPL | Stock | 49.85 | 49.8675 | 49.845 | 49.8675 | 1200.0 |
| 2019-08-15 06:55:00 | AAPL | Stock | 49.9475 | 50.005 | 49.9475 | 50.005 | 19680.0 |
| 2019-08-15 07:00:00 | AAPL | Stock | 50.05 | 50.1325 | 49.9075 | 50.125 | 46548.0 |
| 2019-08-15 07:05:00 | AAPL | Stock | 50.1 | 50.3225 | 50.1 | 50.2375 | 63028.0 |
| 2019-08-15 07:10:00 | AAPL | Stock | 50.25 | 50.3125 | 50.1825 | 50.1825 | 46048.0 |
| 2019-08-15 07:15:00 | AAPL | Stock | 50.155 | 50.25 | 50.13 | 50.2375 | 45648.0 |
| 2019-08-15 07:20:00 | AAPL | Stock | 50.155 | 50.3725 | 50.15 | 50.2875 | 78000.0 |
| 2019-08-15 07:25:00 | AAPL | Stock | 50.24 | 50.685 | 50.1125 | 50.5575 | 89364.0 |
| 2019-08-15 07:30:00 | AAPL | Stock | 50.5575 | 50.915 | 50.485 | 50.555 | 83668.0 |
| 2019-08-15 07:35:00 | AAPL | Stock | 50.5325 | 50.6 | 50.425 | 50.5475 | 28776.0 |
| 2019-08-15 07:40:00 | AAPL | Stock | 50.5425 | 50.6875 | 50.5425 | 50.675 | 51832.0 |
| 2019-08-15 07:45:00 | AAPL | Stock | 50.7325 | 50.9625 | 50.7125 | 50.95 | 77004.0 |
| 2019-08-15 07:50:00 | AAPL | Stock | 50.9375 | 50.945 | 50.8025 | 50.92 | 65028.0 |
| 2019-08-15 07:55:00 | AAPL | Stock | 50.92 | 50.95 | 50.705 | 50.875 | 105788.0 |
| 2019-08-15 08:00:00 | AAPL | Stock | 50.0202 | 51.2025 | 49.9625 | 51.0 | 288460.0 |
| 2019-08-15 08:05:00 | AAPL | Stock | 51.0375 | 51.0575 | 50.8775 | 50.925 | 32712.0 |
| 2019-08-15 08:10:00 | AAPL | Stock | 50.8875 | 50.8875 | 50.675 | 50.75 | 58332.0 |
| 2019-08-15 08:15:00 | AAPL | Stock | 50.8725 | 50.8725 | 50.7575 | 50.8125 | 14140.0 |
| 2019-08-15 08:20:00 | AAPL | Stock | 50.8175 | 50.8475 | 50.6875 | 50.7025 | 41344.0 |
| 2019-08-15 08:25:00 | AAPL | Stock | 50.755 | 50.8225 | 50.6875 | 50.7 | 51672.0 |
| 2019-08-15 08:30:00 | AAPL | Stock | 50.7 | 50.9475 | 50.7 | 50.82 | 38436.0 |
| 2019-08-15 08:35:00 | AAPL | Stock | 50.8 | 50.8835 | 50.7625 | 50.875 | 33648.0 |
| 2019-08-15 08:40:00 | AAPL | Stock | 50.8775 | 50.9325 | 50.775 | 50.875 | 17892.0 |
> showing 50 of 363,086 rows — these rows as CSV