PREVIEW / stock_5min / 2020-11-05
file: by_date/stock_5min/2020/2020-11-05.parquet size: 6.7 MB rows: 416,736 symbols: 2,524
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-11-05 04:00:00 | AAPL | Stock | 117.7 | 118.01 | 117.5 | 117.61 | 29280.0 |
| 2020-11-05 04:05:00 | AAPL | Stock | 117.61 | 117.97 | 117.61 | 117.9 | 10051.0 |
| 2020-11-05 04:10:00 | AAPL | Stock | 117.87 | 117.87 | 117.8 | 117.83 | 4937.0 |
| 2020-11-05 04:15:00 | AAPL | Stock | 117.81 | 118.17 | 117.81 | 118.17 | 7131.0 |
| 2020-11-05 04:20:00 | AAPL | Stock | 118.17 | 118.17 | 117.97 | 117.97 | 4462.0 |
| 2020-11-05 04:25:00 | AAPL | Stock | 118.01 | 118.05 | 117.85 | 118.0 | 3788.0 |
| 2020-11-05 04:30:00 | AAPL | Stock | 118.0 | 118.0 | 117.88 | 117.9 | 11240.0 |
| 2020-11-05 04:35:00 | AAPL | Stock | 117.93 | 118.0 | 117.9 | 117.99 | 4863.0 |
| 2020-11-05 04:40:00 | AAPL | Stock | 117.99 | 118.4 | 117.98 | 118.19 | 11253.0 |
| 2020-11-05 04:45:00 | AAPL | Stock | 118.19 | 118.2 | 118.01 | 118.02 | 1620.0 |
| 2020-11-05 04:50:00 | AAPL | Stock | 118.02 | 118.2 | 118.02 | 118.2 | 3142.0 |
| 2020-11-05 04:55:00 | AAPL | Stock | 118.26 | 118.26 | 118.09 | 118.1 | 6812.0 |
| 2020-11-05 05:00:00 | AAPL | Stock | 118.22 | 118.5 | 118.22 | 118.42 | 5096.0 |
| 2020-11-05 05:05:00 | AAPL | Stock | 118.41 | 118.49 | 117.96 | 118.18 | 20378.0 |
| 2020-11-05 05:10:00 | AAPL | Stock | 118.15 | 118.2 | 118.15 | 118.2 | 3152.0 |
| 2020-11-05 05:15:00 | AAPL | Stock | 118.17 | 118.47 | 118.17 | 118.47 | 11012.0 |
| 2020-11-05 05:20:00 | AAPL | Stock | 118.45 | 119.0 | 118.45 | 118.7 | 9404.0 |
| 2020-11-05 05:25:00 | AAPL | Stock | 118.7 | 118.7 | 118.55 | 118.55 | 6806.0 |
| 2020-11-05 05:30:00 | AAPL | Stock | 118.55 | 118.55 | 118.43 | 118.48 | 2537.0 |
| 2020-11-05 05:35:00 | AAPL | Stock | 118.5 | 118.55 | 118.42 | 118.43 | 7199.0 |
| 2020-11-05 05:40:00 | AAPL | Stock | 118.54 | 118.75 | 118.41 | 118.41 | 1715.0 |
| 2020-11-05 05:45:00 | AAPL | Stock | 118.41 | 118.55 | 118.41 | 118.55 | 2370.0 |
| 2020-11-05 05:50:00 | AAPL | Stock | 118.6 | 118.61 | 118.44 | 118.5 | 16831.0 |
| 2020-11-05 05:55:00 | AAPL | Stock | 118.46 | 118.65 | 118.44 | 118.65 | 19977.0 |
| 2020-11-05 06:00:00 | AAPL | Stock | 118.65 | 118.65 | 118.53 | 118.53 | 15468.0 |
| 2020-11-05 06:05:00 | AAPL | Stock | 118.6 | 118.6 | 118.45 | 118.45 | 3494.0 |
| 2020-11-05 06:10:00 | AAPL | Stock | 118.44 | 118.59 | 118.41 | 118.55 | 3359.0 |
| 2020-11-05 06:15:00 | AAPL | Stock | 118.59 | 118.95 | 118.55 | 118.74 | 11072.0 |
| 2020-11-05 06:20:00 | AAPL | Stock | 118.74 | 118.74 | 118.7 | 118.73 | 2270.0 |
| 2020-11-05 06:25:00 | AAPL | Stock | 118.65 | 118.7 | 118.48 | 118.6 | 3796.0 |
| 2020-11-05 06:30:00 | AAPL | Stock | 118.55 | 118.59 | 118.51 | 118.51 | 3287.0 |
| 2020-11-05 06:35:00 | AAPL | Stock | 118.52 | 118.52 | 118.41 | 118.41 | 3577.0 |
| 2020-11-05 06:40:00 | AAPL | Stock | 118.42 | 118.57 | 118.42 | 118.56 | 8096.0 |
| 2020-11-05 06:45:00 | AAPL | Stock | 118.6 | 118.6 | 118.54 | 118.55 | 2048.0 |
| 2020-11-05 06:50:00 | AAPL | Stock | 118.46 | 118.46 | 118.13 | 118.24 | 9481.0 |
| 2020-11-05 06:55:00 | AAPL | Stock | 118.2 | 118.5 | 118.15 | 118.21 | 5979.0 |
| 2020-11-05 07:00:00 | AAPL | Stock | 118.17 | 118.4 | 117.57 | 118.12 | 156798.0 |
| 2020-11-05 07:05:00 | AAPL | Stock | 118.14 | 118.25 | 118.01 | 118.14 | 44952.0 |
| 2020-11-05 07:10:00 | AAPL | Stock | 118.14 | 118.17 | 118.02 | 118.13 | 34928.0 |
| 2020-11-05 07:15:00 | AAPL | Stock | 118.15 | 118.3 | 118.15 | 118.26 | 53686.0 |
| 2020-11-05 07:20:00 | AAPL | Stock | 118.25 | 118.25 | 118.09 | 118.149 | 24108.0 |
| 2020-11-05 07:25:00 | AAPL | Stock | 118.11 | 118.15 | 117.97 | 118.05 | 40103.0 |
| 2020-11-05 07:30:00 | AAPL | Stock | 118.07 | 118.1 | 117.97 | 118.02 | 28871.0 |
| 2020-11-05 07:35:00 | AAPL | Stock | 118.0 | 118.06 | 117.87 | 117.87 | 22897.0 |
| 2020-11-05 07:40:00 | AAPL | Stock | 117.87 | 118.06 | 117.82 | 118.06 | 24747.0 |
| 2020-11-05 07:45:00 | AAPL | Stock | 118.02 | 118.03 | 117.81 | 117.96 | 20349.0 |
| 2020-11-05 07:50:00 | AAPL | Stock | 117.98 | 118.17 | 117.88 | 118.17 | 52743.0 |
| 2020-11-05 07:55:00 | AAPL | Stock | 118.18 | 118.22 | 118.13 | 118.21 | 23615.0 |
| 2020-11-05 08:00:00 | AAPL | Stock | 117.98 | 118.29 | 115.23 | 118.01 | 357677.0 |
| 2020-11-05 08:05:00 | AAPL | Stock | 118.0 | 118.02 | 117.9 | 117.95 | 60097.0 |
> showing 50 of 416,736 rows — these rows as CSV