PREVIEW / stock_5min / 2021-12-02
file: by_date/stock_5min/2021/2021-12-02.parquet size: 7.8 MB rows: 482,045 symbols: 2,671
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-12-02 04:00:00 | AAPL | Stock | 163.2 | 163.45 | 162.33 | 163.3 | 73066.0 |
| 2021-12-02 04:05:00 | AAPL | Stock | 163.3 | 163.44 | 162.43 | 162.5 | 32990.0 |
| 2021-12-02 04:10:00 | AAPL | Stock | 162.52 | 162.7 | 162.4 | 162.65 | 14531.0 |
| 2021-12-02 04:15:00 | AAPL | Stock | 162.65 | 163.0 | 162.65 | 163.0 | 15745.0 |
| 2021-12-02 04:20:00 | AAPL | Stock | 162.96 | 163.35 | 162.9 | 163.25 | 10685.0 |
| 2021-12-02 04:25:00 | AAPL | Stock | 163.28 | 163.3 | 163.08 | 163.13 | 16231.0 |
| 2021-12-02 04:30:00 | AAPL | Stock | 163.04 | 163.09 | 162.55 | 162.6 | 2367.0 |
| 2021-12-02 04:35:00 | AAPL | Stock | 162.6 | 162.75 | 162.5 | 162.66 | 7967.0 |
| 2021-12-02 04:40:00 | AAPL | Stock | 162.68 | 162.68 | 162.41 | 162.41 | 18910.0 |
| 2021-12-02 04:45:00 | AAPL | Stock | 162.51 | 162.51 | 161.91 | 162.15 | 15854.0 |
| 2021-12-02 04:50:00 | AAPL | Stock | 162.07 | 162.28 | 161.98 | 161.98 | 17131.0 |
| 2021-12-02 04:55:00 | AAPL | Stock | 161.94 | 161.94 | 161.61 | 161.71 | 22281.0 |
| 2021-12-02 05:00:00 | AAPL | Stock | 161.71 | 161.88 | 161.7 | 161.8 | 2881.0 |
| 2021-12-02 05:05:00 | AAPL | Stock | 161.73 | 161.81 | 161.71 | 161.71 | 5521.0 |
| 2021-12-02 05:10:00 | AAPL | Stock | 161.55 | 161.55 | 161.15 | 161.25 | 14491.0 |
| 2021-12-02 05:15:00 | AAPL | Stock | 161.25 | 161.38 | 161.01 | 161.21 | 19850.0 |
| 2021-12-02 05:20:00 | AAPL | Stock | 161.22 | 161.25 | 161.0 | 161.25 | 18195.0 |
| 2021-12-02 05:25:00 | AAPL | Stock | 161.24 | 161.75 | 161.2 | 161.68 | 34910.0 |
| 2021-12-02 05:30:00 | AAPL | Stock | 161.6 | 161.61 | 161.2 | 161.35 | 6842.0 |
| 2021-12-02 05:35:00 | AAPL | Stock | 161.35 | 162.0 | 161.35 | 161.95 | 37507.0 |
| 2021-12-02 05:40:00 | AAPL | Stock | 161.88 | 161.9 | 161.52 | 161.75 | 4237.0 |
| 2021-12-02 05:45:00 | AAPL | Stock | 161.75 | 162.08 | 161.75 | 162.08 | 8443.0 |
| 2021-12-02 05:50:00 | AAPL | Stock | 162.08 | 162.26 | 161.82 | 161.9 | 15132.0 |
| 2021-12-02 05:55:00 | AAPL | Stock | 162.05 | 162.22 | 162.05 | 162.1 | 1943.0 |
| 2021-12-02 06:00:00 | AAPL | Stock | 162.06 | 162.14 | 162.0 | 162.0 | 8058.0 |
| 2021-12-02 06:05:00 | AAPL | Stock | 162.01 | 162.48 | 161.89 | 162.42 | 29086.0 |
| 2021-12-02 06:10:00 | AAPL | Stock | 162.36 | 162.47 | 162.2 | 162.2 | 4513.0 |
| 2021-12-02 06:15:00 | AAPL | Stock | 162.1 | 162.25 | 161.61 | 161.61 | 8500.0 |
| 2021-12-02 06:20:00 | AAPL | Stock | 161.68 | 161.78 | 161.6 | 161.7 | 13310.0 |
| 2021-12-02 06:25:00 | AAPL | Stock | 161.61 | 161.7 | 161.43 | 161.43 | 25297.0 |
| 2021-12-02 06:30:00 | AAPL | Stock | 161.44 | 161.6 | 161.39 | 161.59 | 16244.0 |
| 2021-12-02 06:35:00 | AAPL | Stock | 161.59 | 161.59 | 161.22 | 161.49 | 14963.0 |
| 2021-12-02 06:40:00 | AAPL | Stock | 161.5 | 161.59 | 161.37 | 161.43 | 7484.0 |
| 2021-12-02 06:45:00 | AAPL | Stock | 161.52 | 161.6 | 161.47 | 161.59 | 14386.0 |
| 2021-12-02 06:50:00 | AAPL | Stock | 161.58 | 161.6 | 161.48 | 161.48 | 22935.0 |
| 2021-12-02 06:55:00 | AAPL | Stock | 161.5 | 161.59 | 161.31 | 161.51 | 26574.0 |
| 2021-12-02 07:00:00 | AAPL | Stock | 161.54 | 161.57 | 160.9 | 160.91 | 122952.0 |
| 2021-12-02 07:05:00 | AAPL | Stock | 160.95 | 160.95 | 160.62 | 160.71 | 61317.0 |
| 2021-12-02 07:10:00 | AAPL | Stock | 160.69 | 160.79 | 160.36 | 160.37 | 72057.0 |
| 2021-12-02 07:15:00 | AAPL | Stock | 160.37 | 160.44 | 160.08 | 160.16 | 78480.0 |
| 2021-12-02 07:20:00 | AAPL | Stock | 160.15 | 160.2 | 159.75 | 160.0 | 81277.0 |
| 2021-12-02 07:25:00 | AAPL | Stock | 160.0 | 160.12 | 159.7 | 160.03 | 47946.0 |
| 2021-12-02 07:30:00 | AAPL | Stock | 160.02 | 160.16 | 159.6 | 159.89 | 38799.0 |
| 2021-12-02 07:35:00 | AAPL | Stock | 159.86 | 159.95 | 159.79 | 159.84 | 27584.0 |
| 2021-12-02 07:40:00 | AAPL | Stock | 159.835 | 159.86 | 159.59 | 159.8 | 37531.0 |
| 2021-12-02 07:45:00 | AAPL | Stock | 159.79 | 160.0 | 159.68 | 159.68 | 57577.0 |
| 2021-12-02 07:50:00 | AAPL | Stock | 159.68 | 159.83 | 159.4 | 159.83 | 94010.0 |
| 2021-12-02 07:55:00 | AAPL | Stock | 159.83 | 160.0 | 159.82 | 159.96 | 65693.0 |
| 2021-12-02 08:00:00 | AAPL | Stock | 159.7801 | 164.359 | 159.44 | 160.56 | 476492.0 |
| 2021-12-02 08:05:00 | AAPL | Stock | 160.56 | 160.69 | 160.36 | 160.5899 | 76551.0 |
> showing 50 of 482,045 rows — these rows as CSV