PREVIEW / stock_5min / 2021-03-01
file: by_date/stock_5min/2021/2021-03-01.parquet size: 8.3 MB rows: 511,193 symbols: 2,864
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-01 04:00:00 | AAPL | Stock | 124.3 | 124.6 | 123.72 | 124.0 | 23606.0 |
| 2021-03-01 04:05:00 | AAPL | Stock | 124.0 | 124.29 | 123.9 | 124.1 | 20534.0 |
| 2021-03-01 04:10:00 | AAPL | Stock | 124.1 | 124.1 | 123.94 | 124.05 | 17630.0 |
| 2021-03-01 04:15:00 | AAPL | Stock | 124.05 | 124.11 | 123.78 | 123.9 | 12830.0 |
| 2021-03-01 04:20:00 | AAPL | Stock | 123.85 | 123.97 | 123.83 | 123.83 | 2431.0 |
| 2021-03-01 04:25:00 | AAPL | Stock | 123.78 | 123.82 | 123.7 | 123.82 | 2454.0 |
| 2021-03-01 04:30:00 | AAPL | Stock | 123.9 | 123.96 | 123.86 | 123.86 | 2567.0 |
| 2021-03-01 04:35:00 | AAPL | Stock | 123.85 | 123.94 | 123.8 | 123.93 | 3021.0 |
| 2021-03-01 04:40:00 | AAPL | Stock | 123.98 | 124.19 | 123.98 | 124.05 | 3495.0 |
| 2021-03-01 04:45:00 | AAPL | Stock | 123.99 | 124.0 | 123.97 | 124.0 | 4232.0 |
| 2021-03-01 04:50:00 | AAPL | Stock | 124.01 | 124.1 | 124.01 | 124.1 | 2484.0 |
| 2021-03-01 04:55:00 | AAPL | Stock | 124.11 | 124.18 | 124.1 | 124.18 | 510.0 |
| 2021-03-01 05:00:00 | AAPL | Stock | 124.11 | 124.2 | 124.1 | 124.19 | 5163.0 |
| 2021-03-01 05:05:00 | AAPL | Stock | 124.19 | 124.2 | 124.18 | 124.18 | 1513.0 |
| 2021-03-01 05:10:00 | AAPL | Stock | 124.2 | 124.34 | 124.16 | 124.16 | 5536.0 |
| 2021-03-01 05:15:00 | AAPL | Stock | 124.16 | 124.22 | 124.11 | 124.19 | 5734.0 |
| 2021-03-01 05:20:00 | AAPL | Stock | 124.2 | 124.27 | 124.2 | 124.25 | 1263.0 |
| 2021-03-01 05:25:00 | AAPL | Stock | 124.2 | 124.2 | 123.93 | 123.94 | 7708.0 |
| 2021-03-01 05:30:00 | AAPL | Stock | 124.0 | 124.03 | 123.95 | 124.0 | 8138.0 |
| 2021-03-01 05:35:00 | AAPL | Stock | 124.0 | 124.03 | 123.98 | 124.0 | 3378.0 |
| 2021-03-01 05:40:00 | AAPL | Stock | 123.99 | 124.1 | 123.9 | 124.0 | 5088.0 |
| 2021-03-01 05:45:00 | AAPL | Stock | 124.0 | 124.1 | 123.9 | 124.01 | 8443.0 |
| 2021-03-01 05:50:00 | AAPL | Stock | 124.1 | 124.1 | 124.04 | 124.04 | 2429.0 |
| 2021-03-01 05:55:00 | AAPL | Stock | 124.02 | 124.02 | 123.95 | 124.0 | 14012.0 |
| 2021-03-01 06:00:00 | AAPL | Stock | 124.0 | 124.1 | 124.0 | 124.1 | 9838.0 |
| 2021-03-01 06:05:00 | AAPL | Stock | 124.1 | 124.16 | 123.91 | 124.16 | 9317.0 |
| 2021-03-01 06:10:00 | AAPL | Stock | 124.11 | 124.16 | 123.98 | 123.98 | 6283.0 |
| 2021-03-01 06:15:00 | AAPL | Stock | 123.96 | 124.01 | 123.96 | 124.01 | 1523.0 |
| 2021-03-01 06:20:00 | AAPL | Stock | 124.0 | 124.0 | 123.71 | 123.77 | 3241.0 |
| 2021-03-01 06:25:00 | AAPL | Stock | 123.81 | 123.89 | 123.56 | 123.63 | 6618.0 |
| 2021-03-01 06:30:00 | AAPL | Stock | 123.66 | 123.8 | 123.56 | 123.8 | 4712.0 |
| 2021-03-01 06:35:00 | AAPL | Stock | 123.86 | 123.94 | 123.85 | 123.94 | 2743.0 |
| 2021-03-01 06:40:00 | AAPL | Stock | 123.92 | 124.02 | 123.92 | 124.02 | 9345.0 |
| 2021-03-01 06:45:00 | AAPL | Stock | 124.0 | 124.0 | 123.8 | 123.8 | 5629.0 |
| 2021-03-01 06:50:00 | AAPL | Stock | 123.71 | 123.71 | 123.5 | 123.56 | 15204.0 |
| 2021-03-01 06:55:00 | AAPL | Stock | 123.57 | 123.63 | 123.43 | 123.63 | 3496.0 |
| 2021-03-01 07:00:00 | AAPL | Stock | 123.6 | 123.76 | 123.44 | 123.5 | 70481.0 |
| 2021-03-01 07:05:00 | AAPL | Stock | 123.46 | 123.56 | 123.34 | 123.39 | 47891.0 |
| 2021-03-01 07:10:00 | AAPL | Stock | 123.46 | 123.52 | 123.4 | 123.47 | 33373.0 |
| 2021-03-01 07:15:00 | AAPL | Stock | 123.48 | 123.63 | 123.48 | 123.53 | 45032.0 |
| 2021-03-01 07:20:00 | AAPL | Stock | 123.52 | 123.649 | 123.51 | 123.56 | 16456.0 |
| 2021-03-01 07:25:00 | AAPL | Stock | 123.57 | 123.75 | 123.52 | 123.55 | 36893.0 |
| 2021-03-01 07:30:00 | AAPL | Stock | 123.55 | 123.56 | 123.33 | 123.43 | 26778.0 |
| 2021-03-01 07:35:00 | AAPL | Stock | 123.41 | 123.5 | 123.4 | 123.43 | 17461.0 |
| 2021-03-01 07:40:00 | AAPL | Stock | 123.46 | 123.46 | 123.17 | 123.29 | 39795.0 |
| 2021-03-01 07:45:00 | AAPL | Stock | 123.26 | 123.49 | 123.26 | 123.45 | 24966.0 |
| 2021-03-01 07:50:00 | AAPL | Stock | 123.41 | 123.53 | 123.4 | 123.5 | 19006.0 |
| 2021-03-01 07:55:00 | AAPL | Stock | 123.52 | 123.55 | 123.42 | 123.52 | 38817.0 |
| 2021-03-01 08:00:00 | AAPL | Stock | 123.59 | 123.69 | 121.563 | 123.5699 | 188197.0 |
| 2021-03-01 08:05:00 | AAPL | Stock | 123.56 | 123.56 | 123.29 | 123.44 | 26326.0 |
> showing 50 of 511,193 rows — these rows as CSV