PREVIEW / stock_5min / 2020-02-07
file: by_date/stock_5min/2020/2020-02-07.parquet size: 5.9 MB rows: 363,608 symbols: 2,425
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 |
|---|---|---|---|---|---|---|---|
| 2020-02-07 04:00:00 | AAPL | Stock | 81.2225 | 81.2225 | 81.15 | 81.175 | 10528.0 |
| 2020-02-07 04:05:00 | AAPL | Stock | 81.135 | 81.1625 | 81.125 | 81.1625 | 12308.0 |
| 2020-02-07 04:10:00 | AAPL | Stock | 81.1625 | 81.165 | 81.125 | 81.125 | 11648.0 |
| 2020-02-07 04:15:00 | AAPL | Stock | 81.125 | 81.125 | 81.1 | 81.1 | 9908.0 |
| 2020-02-07 04:20:00 | AAPL | Stock | 81.125 | 81.1375 | 81.1125 | 81.1375 | 4000.0 |
| 2020-02-07 04:25:00 | AAPL | Stock | 81.0425 | 81.0425 | 81.0425 | 81.0425 | 1804.0 |
| 2020-02-07 04:30:00 | AAPL | Stock | 81.0325 | 81.0325 | 80.925 | 81.0225 | 72568.0 |
| 2020-02-07 04:35:00 | AAPL | Stock | 81.005 | 81.005 | 81.005 | 81.005 | 6180.0 |
| 2020-02-07 04:40:00 | AAPL | Stock | 80.995 | 81.0 | 80.995 | 81.0 | 3200.0 |
| 2020-02-07 04:50:00 | AAPL | Stock | 80.95 | 80.95 | 80.95 | 80.95 | 456.0 |
| 2020-02-07 05:10:00 | AAPL | Stock | 80.8775 | 80.8775 | 80.8275 | 80.85 | 85300.0 |
| 2020-02-07 05:15:00 | AAPL | Stock | 80.7875 | 80.825 | 80.7875 | 80.825 | 11400.0 |
| 2020-02-07 05:25:00 | AAPL | Stock | 80.84 | 80.875 | 80.84 | 80.87 | 4920.0 |
| 2020-02-07 05:30:00 | AAPL | Stock | 80.875 | 80.875 | 80.875 | 80.875 | 1880.0 |
| 2020-02-07 05:35:00 | AAPL | Stock | 80.875 | 80.875 | 80.7675 | 80.775 | 8344.0 |
| 2020-02-07 05:40:00 | AAPL | Stock | 80.7625 | 80.8 | 80.6825 | 80.69 | 17680.0 |
| 2020-02-07 05:45:00 | AAPL | Stock | 80.69 | 80.69 | 80.69 | 80.69 | 1524.0 |
| 2020-02-07 05:50:00 | AAPL | Stock | 80.69 | 80.69 | 80.6275 | 80.675 | 5620.0 |
| 2020-02-07 05:55:00 | AAPL | Stock | 80.675 | 80.6775 | 80.675 | 80.6775 | 4800.0 |
| 2020-02-07 06:00:00 | AAPL | Stock | 80.68 | 80.68 | 80.625 | 80.63 | 11204.0 |
| 2020-02-07 06:05:00 | AAPL | Stock | 80.635 | 80.635 | 80.5525 | 80.595 | 20480.0 |
| 2020-02-07 06:10:00 | AAPL | Stock | 80.6 | 80.675 | 80.6 | 80.675 | 2800.0 |
| 2020-02-07 06:15:00 | AAPL | Stock | 80.7125 | 80.75 | 80.7125 | 80.75 | 7120.0 |
| 2020-02-07 06:25:00 | AAPL | Stock | 80.73 | 80.7625 | 80.73 | 80.76 | 5200.0 |
| 2020-02-07 06:30:00 | AAPL | Stock | 80.7875 | 80.7875 | 80.7525 | 80.76 | 3400.0 |
| 2020-02-07 06:35:00 | AAPL | Stock | 80.7625 | 80.7625 | 80.7525 | 80.7525 | 1784.0 |
| 2020-02-07 06:40:00 | AAPL | Stock | 80.715 | 80.75 | 80.6775 | 80.6775 | 12256.0 |
| 2020-02-07 06:50:00 | AAPL | Stock | 80.7475 | 80.8 | 80.7475 | 80.8 | 5600.0 |
| 2020-02-07 06:55:00 | AAPL | Stock | 80.7525 | 80.875 | 80.7525 | 80.875 | 10472.0 |
| 2020-02-07 07:00:00 | AAPL | Stock | 80.845 | 80.95 | 80.7525 | 80.9275 | 61592.0 |
| 2020-02-07 07:05:00 | AAPL | Stock | 80.93 | 81.0 | 80.93 | 80.995 | 24096.0 |
| 2020-02-07 07:10:00 | AAPL | Stock | 80.9875 | 80.9925 | 80.87 | 80.8725 | 28808.0 |
| 2020-02-07 07:15:00 | AAPL | Stock | 80.8825 | 80.9425 | 80.8825 | 80.9425 | 6536.0 |
| 2020-02-07 07:20:00 | AAPL | Stock | 80.92 | 80.9225 | 80.895 | 80.9025 | 13388.0 |
| 2020-02-07 07:25:00 | AAPL | Stock | 80.905 | 80.905 | 80.85 | 80.85 | 6904.0 |
| 2020-02-07 07:30:00 | AAPL | Stock | 80.8525 | 80.95 | 80.8375 | 80.95 | 37980.0 |
| 2020-02-07 07:35:00 | AAPL | Stock | 80.975 | 80.975 | 80.875 | 80.875 | 26296.0 |
| 2020-02-07 07:40:00 | AAPL | Stock | 80.9225 | 80.925 | 80.9 | 80.925 | 14616.0 |
| 2020-02-07 07:45:00 | AAPL | Stock | 80.935 | 80.9375 | 80.9 | 80.9 | 4500.0 |
| 2020-02-07 07:50:00 | AAPL | Stock | 80.8775 | 80.9 | 80.875 | 80.9 | 11080.0 |
| 2020-02-07 07:55:00 | AAPL | Stock | 80.91 | 80.95 | 80.9 | 80.95 | 29172.0 |
| 2020-02-07 08:00:00 | AAPL | Stock | 80.975 | 81.0 | 80.7875 | 80.9225 | 177556.0 |
| 2020-02-07 08:05:00 | AAPL | Stock | 80.9225 | 80.936 | 80.88 | 80.88 | 16748.0 |
| 2020-02-07 08:10:00 | AAPL | Stock | 80.8925 | 80.9225 | 80.8925 | 80.9225 | 25776.0 |
| 2020-02-07 08:15:00 | AAPL | Stock | 80.95 | 80.975 | 80.925 | 80.975 | 9792.0 |
| 2020-02-07 08:20:00 | AAPL | Stock | 80.95 | 80.9625 | 80.9225 | 80.945 | 15228.0 |
| 2020-02-07 08:25:00 | AAPL | Stock | 80.9625 | 80.988 | 80.9375 | 80.9625 | 32616.0 |
| 2020-02-07 08:30:00 | AAPL | Stock | 80.9775 | 81.1 | 80.897 | 80.9225 | 126852.0 |
| 2020-02-07 08:35:00 | AAPL | Stock | 80.9302 | 80.9302 | 80.6875 | 80.885 | 151008.0 |
| 2020-02-07 08:40:00 | AAPL | Stock | 80.9225 | 80.9225 | 80.7 | 80.75 | 66724.0 |
> showing 50 of 363,608 rows — these rows as CSV