PREVIEW / stock_5min / 2020-09-08
file: by_date/stock_5min/2020/2020-09-08.parquet size: 6.7 MB rows: 421,068 symbols: 2,481
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-09-08 04:00:00 | AAPL | Stock | 120.36 | 120.4 | 119.71 | 119.87 | 22855.0 |
| 2020-09-08 04:05:00 | AAPL | Stock | 119.84 | 119.86 | 119.2 | 119.47 | 9472.0 |
| 2020-09-08 04:10:00 | AAPL | Stock | 119.28 | 119.31 | 118.12 | 118.38 | 28700.0 |
| 2020-09-08 04:15:00 | AAPL | Stock | 118.16 | 118.28 | 117.17 | 117.25 | 27591.0 |
| 2020-09-08 04:20:00 | AAPL | Stock | 117.25 | 117.95 | 117.2 | 117.28 | 18268.0 |
| 2020-09-08 04:25:00 | AAPL | Stock | 117.3 | 117.5 | 116.55 | 117.45 | 24741.0 |
| 2020-09-08 04:30:00 | AAPL | Stock | 117.49 | 117.49 | 117.23 | 117.32 | 3618.0 |
| 2020-09-08 04:35:00 | AAPL | Stock | 117.31 | 117.99 | 116.83 | 117.99 | 9162.0 |
| 2020-09-08 04:40:00 | AAPL | Stock | 117.95 | 117.95 | 117.15 | 117.17 | 14048.0 |
| 2020-09-08 04:45:00 | AAPL | Stock | 117.38 | 117.49 | 116.53 | 117.24 | 21554.0 |
| 2020-09-08 04:50:00 | AAPL | Stock | 117.22 | 117.24 | 116.92 | 117.15 | 12477.0 |
| 2020-09-08 04:55:00 | AAPL | Stock | 117.16 | 117.4 | 117.0 | 117.3 | 2770.0 |
| 2020-09-08 05:00:00 | AAPL | Stock | 117.3 | 117.75 | 117.02 | 117.63 | 15710.0 |
| 2020-09-08 05:05:00 | AAPL | Stock | 117.7 | 117.88 | 117.59 | 117.81 | 8118.0 |
| 2020-09-08 05:10:00 | AAPL | Stock | 117.89 | 117.93 | 117.72 | 117.73 | 4259.0 |
| 2020-09-08 05:15:00 | AAPL | Stock | 117.88 | 117.89 | 117.29 | 117.68 | 9461.0 |
| 2020-09-08 05:20:00 | AAPL | Stock | 117.58 | 117.6 | 117.02 | 117.07 | 3512.0 |
| 2020-09-08 05:25:00 | AAPL | Stock | 117.09 | 117.43 | 116.91 | 117.43 | 5741.0 |
| 2020-09-08 05:30:00 | AAPL | Stock | 117.35 | 117.42 | 116.53 | 116.73 | 11552.0 |
| 2020-09-08 05:35:00 | AAPL | Stock | 116.66 | 117.0 | 116.66 | 117.0 | 4872.0 |
| 2020-09-08 05:40:00 | AAPL | Stock | 117.15 | 117.23 | 116.9 | 116.9 | 3269.0 |
| 2020-09-08 05:45:00 | AAPL | Stock | 116.82 | 117.0 | 116.65 | 116.87 | 7732.0 |
| 2020-09-08 05:50:00 | AAPL | Stock | 116.9 | 117.01 | 116.51 | 116.8 | 42050.0 |
| 2020-09-08 05:55:00 | AAPL | Stock | 116.6 | 117.0 | 116.49 | 116.74 | 36165.0 |
| 2020-09-08 06:00:00 | AAPL | Stock | 116.61 | 116.8 | 116.35 | 116.55 | 13264.0 |
| 2020-09-08 06:05:00 | AAPL | Stock | 116.55 | 116.59 | 116.19 | 116.47 | 8168.0 |
| 2020-09-08 06:10:00 | AAPL | Stock | 116.34 | 116.52 | 116.19 | 116.5 | 11663.0 |
| 2020-09-08 06:15:00 | AAPL | Stock | 116.4 | 116.7 | 116.4 | 116.51 | 3829.0 |
| 2020-09-08 06:20:00 | AAPL | Stock | 116.6 | 116.89 | 116.2 | 116.27 | 25774.0 |
| 2020-09-08 06:25:00 | AAPL | Stock | 116.27 | 116.27 | 115.87 | 115.9 | 5907.0 |
| 2020-09-08 06:30:00 | AAPL | Stock | 116.0 | 116.7 | 116.0 | 116.5 | 19943.0 |
| 2020-09-08 06:35:00 | AAPL | Stock | 116.31 | 116.9 | 116.3 | 116.73 | 20063.0 |
| 2020-09-08 06:40:00 | AAPL | Stock | 116.73 | 116.89 | 116.52 | 116.71 | 9121.0 |
| 2020-09-08 06:45:00 | AAPL | Stock | 116.79 | 116.79 | 116.5 | 116.6 | 12995.0 |
| 2020-09-08 06:50:00 | AAPL | Stock | 116.67 | 117.24 | 116.67 | 116.9 | 17285.0 |
| 2020-09-08 06:55:00 | AAPL | Stock | 116.82 | 117.5 | 116.81 | 117.45 | 15956.0 |
| 2020-09-08 07:00:00 | AAPL | Stock | 117.34 | 117.7 | 116.43 | 116.95 | 154248.0 |
| 2020-09-08 07:05:00 | AAPL | Stock | 116.9 | 117.13 | 116.65 | 116.7 | 58466.0 |
| 2020-09-08 07:10:00 | AAPL | Stock | 116.77 | 116.97 | 116.55 | 116.8 | 26314.0 |
| 2020-09-08 07:15:00 | AAPL | Stock | 116.78 | 116.85 | 116.11 | 116.3 | 100154.0 |
| 2020-09-08 07:20:00 | AAPL | Stock | 116.25 | 116.25 | 115.7 | 115.76 | 97089.0 |
| 2020-09-08 07:25:00 | AAPL | Stock | 115.8 | 116.45 | 115.63 | 115.81 | 54800.0 |
| 2020-09-08 07:30:00 | AAPL | Stock | 115.81 | 115.95 | 115.56 | 115.63 | 56359.0 |
| 2020-09-08 07:35:00 | AAPL | Stock | 115.63 | 115.68 | 115.33 | 115.55 | 62609.0 |
| 2020-09-08 07:40:00 | AAPL | Stock | 115.54 | 115.55 | 115.0 | 115.07 | 82431.0 |
| 2020-09-08 07:45:00 | AAPL | Stock | 115.09 | 115.38 | 115.0 | 115.38 | 107946.0 |
| 2020-09-08 07:50:00 | AAPL | Stock | 115.35 | 115.54 | 115.0 | 115.32 | 66067.0 |
| 2020-09-08 07:55:00 | AAPL | Stock | 115.39 | 115.6 | 115.16 | 115.25 | 52345.0 |
| 2020-09-08 08:00:00 | AAPL | Stock | 115.3 | 117.68 | 115.0 | 115.67 | 647924.0 |
| 2020-09-08 08:05:00 | AAPL | Stock | 115.67 | 115.7 | 114.9 | 114.9 | 167551.0 |
> showing 50 of 421,068 rows — these rows as CSV