PREVIEW / stock_5min / 2020-09-04
file: by_date/stock_5min/2020/2020-09-04.parquet size: 6.7 MB rows: 414,673 symbols: 2,467
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-04 04:00:00 | AAPL | Stock | 116.0 | 120.98 | 116.0 | 119.34 | 77437.0 |
| 2020-09-04 04:05:00 | AAPL | Stock | 119.32 | 119.6 | 118.78 | 119.55 | 24662.0 |
| 2020-09-04 04:10:00 | AAPL | Stock | 119.6 | 119.9 | 119.21 | 119.66 | 14220.0 |
| 2020-09-04 04:15:00 | AAPL | Stock | 119.64 | 120.03 | 119.5 | 119.7 | 19424.0 |
| 2020-09-04 04:20:00 | AAPL | Stock | 119.65 | 120.05 | 119.4 | 119.5 | 11287.0 |
| 2020-09-04 04:25:00 | AAPL | Stock | 119.48 | 119.64 | 119.3 | 119.45 | 9790.0 |
| 2020-09-04 04:30:00 | AAPL | Stock | 119.55 | 120.33 | 119.4 | 120.33 | 10364.0 |
| 2020-09-04 04:35:00 | AAPL | Stock | 120.15 | 120.52 | 119.75 | 120.14 | 10146.0 |
| 2020-09-04 04:40:00 | AAPL | Stock | 119.99 | 120.43 | 119.89 | 120.02 | 15322.0 |
| 2020-09-04 04:45:00 | AAPL | Stock | 120.02 | 120.5 | 120.0 | 120.35 | 18686.0 |
| 2020-09-04 04:50:00 | AAPL | Stock | 120.4 | 120.45 | 120.02 | 120.1 | 27772.0 |
| 2020-09-04 04:55:00 | AAPL | Stock | 120.04 | 120.3 | 119.97 | 120.3 | 9974.0 |
| 2020-09-04 05:00:00 | AAPL | Stock | 120.47 | 120.47 | 119.73 | 120.0 | 15598.0 |
| 2020-09-04 05:05:00 | AAPL | Stock | 119.82 | 119.9 | 119.6 | 119.74 | 8000.0 |
| 2020-09-04 05:10:00 | AAPL | Stock | 119.74 | 119.95 | 119.54 | 119.7 | 8732.0 |
| 2020-09-04 05:15:00 | AAPL | Stock | 119.7 | 119.9 | 119.03 | 119.1 | 15111.0 |
| 2020-09-04 05:20:00 | AAPL | Stock | 119.0 | 119.58 | 119.0 | 119.3 | 6806.0 |
| 2020-09-04 05:25:00 | AAPL | Stock | 119.47 | 120.04 | 119.46 | 120.0 | 6960.0 |
| 2020-09-04 05:30:00 | AAPL | Stock | 119.81 | 120.01 | 119.64 | 119.73 | 2551.0 |
| 2020-09-04 05:35:00 | AAPL | Stock | 119.85 | 120.2 | 119.85 | 120.2 | 9854.0 |
| 2020-09-04 05:40:00 | AAPL | Stock | 120.27 | 120.31 | 120.09 | 120.31 | 8425.0 |
| 2020-09-04 05:45:00 | AAPL | Stock | 120.3 | 120.41 | 120.01 | 120.4 | 8598.0 |
| 2020-09-04 05:50:00 | AAPL | Stock | 120.4 | 121.1 | 120.4 | 121.02 | 16032.0 |
| 2020-09-04 05:55:00 | AAPL | Stock | 121.02 | 121.4 | 120.9 | 121.14 | 20709.0 |
| 2020-09-04 06:00:00 | AAPL | Stock | 121.11 | 121.5 | 120.75 | 121.17 | 33453.0 |
| 2020-09-04 06:05:00 | AAPL | Stock | 120.9 | 121.09 | 120.65 | 120.72 | 19685.0 |
| 2020-09-04 06:10:00 | AAPL | Stock | 120.73 | 121.43 | 120.5 | 121.36 | 24960.0 |
| 2020-09-04 06:15:00 | AAPL | Stock | 121.26 | 121.37 | 120.3 | 120.55 | 24075.0 |
| 2020-09-04 06:20:00 | AAPL | Stock | 120.58 | 120.8 | 120.06 | 120.12 | 15826.0 |
| 2020-09-04 06:25:00 | AAPL | Stock | 120.03 | 120.3 | 119.9 | 120.3 | 15006.0 |
| 2020-09-04 06:30:00 | AAPL | Stock | 120.34 | 120.64 | 120.16 | 120.44 | 8940.0 |
| 2020-09-04 06:35:00 | AAPL | Stock | 120.5 | 120.63 | 120.5 | 120.5 | 8070.0 |
| 2020-09-04 06:40:00 | AAPL | Stock | 120.5 | 120.59 | 120.4 | 120.58 | 4835.0 |
| 2020-09-04 06:45:00 | AAPL | Stock | 120.58 | 120.58 | 119.95 | 120.3 | 7914.0 |
| 2020-09-04 06:50:00 | AAPL | Stock | 120.15 | 120.26 | 120.0 | 120.0 | 18871.0 |
| 2020-09-04 06:55:00 | AAPL | Stock | 120.18 | 120.24 | 120.0 | 120.0 | 9406.0 |
| 2020-09-04 07:00:00 | AAPL | Stock | 120.25 | 120.27 | 118.81 | 119.1 | 221438.0 |
| 2020-09-04 07:05:00 | AAPL | Stock | 119.06 | 119.2 | 118.55 | 118.55 | 79524.0 |
| 2020-09-04 07:10:00 | AAPL | Stock | 118.6 | 118.87 | 118.11 | 118.6 | 110848.0 |
| 2020-09-04 07:15:00 | AAPL | Stock | 118.5 | 118.7 | 118.0 | 118.03 | 114086.0 |
| 2020-09-04 07:20:00 | AAPL | Stock | 118.01 | 118.5 | 117.88 | 118.4 | 112156.0 |
| 2020-09-04 07:25:00 | AAPL | Stock | 118.4 | 118.48 | 118.0 | 118.13 | 43693.0 |
| 2020-09-04 07:30:00 | AAPL | Stock | 118.17 | 118.3 | 117.75 | 117.75 | 143082.0 |
| 2020-09-04 07:35:00 | AAPL | Stock | 117.73 | 118.09 | 117.61 | 117.61 | 132198.0 |
| 2020-09-04 07:40:00 | AAPL | Stock | 117.61 | 117.84 | 117.25 | 117.66 | 107233.0 |
| 2020-09-04 07:45:00 | AAPL | Stock | 117.66 | 117.82 | 117.35 | 117.75 | 61471.0 |
| 2020-09-04 07:50:00 | AAPL | Stock | 117.75 | 117.8 | 117.25 | 117.62 | 99202.0 |
| 2020-09-04 07:55:00 | AAPL | Stock | 117.51 | 117.94 | 117.19 | 117.75 | 68268.0 |
| 2020-09-04 08:00:00 | AAPL | Stock | 117.67 | 119.92 | 117.18 | 118.4 | 714455.0 |
| 2020-09-04 08:05:00 | AAPL | Stock | 118.4 | 118.4 | 117.8 | 117.81 | 121609.0 |
> showing 50 of 414,673 rows — these rows as CSV