PREVIEW / stock_5min / 2021-01-04
file: by_date/stock_5min/2021/2021-01-04.parquet size: 7.7 MB rows: 475,586 symbols: 2,673
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-01-04 04:00:00 | AAPL | Stock | 133.31 | 133.77 | 133.02 | 133.72 | 28114.0 |
| 2021-01-04 04:05:00 | AAPL | Stock | 133.71 | 133.98 | 133.71 | 133.98 | 7393.0 |
| 2021-01-04 04:10:00 | AAPL | Stock | 133.98 | 134.0 | 133.74 | 133.74 | 5404.0 |
| 2021-01-04 04:15:00 | AAPL | Stock | 133.98 | 134.01 | 133.94 | 133.95 | 23026.0 |
| 2021-01-04 04:20:00 | AAPL | Stock | 133.9 | 133.95 | 133.83 | 133.83 | 1275.0 |
| 2021-01-04 04:25:00 | AAPL | Stock | 133.89 | 134.0 | 133.88 | 134.0 | 2345.0 |
| 2021-01-04 04:30:00 | AAPL | Stock | 134.0 | 134.0 | 133.91 | 133.91 | 2677.0 |
| 2021-01-04 04:35:00 | AAPL | Stock | 133.96 | 133.96 | 133.9 | 133.9 | 1157.0 |
| 2021-01-04 04:40:00 | AAPL | Stock | 133.9 | 133.9 | 133.55 | 133.85 | 2659.0 |
| 2021-01-04 04:45:00 | AAPL | Stock | 133.86 | 133.86 | 133.5 | 133.58 | 7809.0 |
| 2021-01-04 04:50:00 | AAPL | Stock | 133.6 | 133.6 | 133.5 | 133.6 | 4028.0 |
| 2021-01-04 04:55:00 | AAPL | Stock | 133.58 | 133.6 | 133.58 | 133.6 | 2074.0 |
| 2021-01-04 05:00:00 | AAPL | Stock | 133.6 | 133.95 | 133.6 | 133.9 | 20753.0 |
| 2021-01-04 05:05:00 | AAPL | Stock | 133.8 | 133.86 | 133.8 | 133.81 | 2183.0 |
| 2021-01-04 05:10:00 | AAPL | Stock | 133.69 | 133.69 | 133.6 | 133.6 | 8347.0 |
| 2021-01-04 05:15:00 | AAPL | Stock | 133.68 | 133.68 | 133.53 | 133.54 | 5319.0 |
| 2021-01-04 05:20:00 | AAPL | Stock | 133.5 | 133.54 | 133.43 | 133.53 | 2814.0 |
| 2021-01-04 05:25:00 | AAPL | Stock | 133.54 | 133.55 | 133.53 | 133.53 | 8296.0 |
| 2021-01-04 05:30:00 | AAPL | Stock | 133.59 | 133.8 | 133.59 | 133.8 | 2456.0 |
| 2021-01-04 05:35:00 | AAPL | Stock | 133.77 | 134.29 | 133.77 | 134.23 | 34792.0 |
| 2021-01-04 05:40:00 | AAPL | Stock | 134.15 | 134.43 | 134.05 | 134.31 | 17631.0 |
| 2021-01-04 05:45:00 | AAPL | Stock | 134.31 | 134.41 | 134.24 | 134.41 | 7949.0 |
| 2021-01-04 05:50:00 | AAPL | Stock | 134.4 | 134.4 | 134.24 | 134.27 | 32037.0 |
| 2021-01-04 05:55:00 | AAPL | Stock | 134.29 | 134.42 | 134.29 | 134.3 | 5351.0 |
| 2021-01-04 06:00:00 | AAPL | Stock | 134.22 | 134.32 | 134.17 | 134.3 | 3903.0 |
| 2021-01-04 06:05:00 | AAPL | Stock | 134.3 | 134.35 | 134.3 | 134.35 | 2115.0 |
| 2021-01-04 06:10:00 | AAPL | Stock | 134.25 | 134.35 | 134.22 | 134.22 | 1282.0 |
| 2021-01-04 06:15:00 | AAPL | Stock | 134.2 | 134.2 | 134.08 | 134.16 | 1450.0 |
| 2021-01-04 06:20:00 | AAPL | Stock | 134.15 | 134.15 | 134.05 | 134.05 | 545.0 |
| 2021-01-04 06:25:00 | AAPL | Stock | 134.1 | 134.1 | 134.1 | 134.1 | 531.0 |
| 2021-01-04 06:30:00 | AAPL | Stock | 134.19 | 134.35 | 134.19 | 134.35 | 3978.0 |
| 2021-01-04 06:35:00 | AAPL | Stock | 134.34 | 134.34 | 134.25 | 134.25 | 1986.0 |
| 2021-01-04 06:40:00 | AAPL | Stock | 134.2 | 134.2 | 134.15 | 134.15 | 782.0 |
| 2021-01-04 06:45:00 | AAPL | Stock | 134.19 | 134.19 | 134.1 | 134.1 | 1175.0 |
| 2021-01-04 06:50:00 | AAPL | Stock | 134.11 | 134.19 | 134.1 | 134.17 | 4300.0 |
| 2021-01-04 06:55:00 | AAPL | Stock | 134.15 | 134.17 | 133.6 | 133.99 | 10896.0 |
| 2021-01-04 07:00:00 | AAPL | Stock | 133.92 | 134.0 | 133.65 | 133.8 | 76620.0 |
| 2021-01-04 07:05:00 | AAPL | Stock | 133.73 | 133.79 | 133.7 | 133.75 | 58889.0 |
| 2021-01-04 07:10:00 | AAPL | Stock | 133.74 | 133.77 | 133.69 | 133.75 | 56330.0 |
| 2021-01-04 07:15:00 | AAPL | Stock | 133.75 | 133.75 | 133.54 | 133.72 | 56659.0 |
| 2021-01-04 07:20:00 | AAPL | Stock | 133.7 | 133.75 | 133.65 | 133.7 | 16049.0 |
| 2021-01-04 07:25:00 | AAPL | Stock | 133.7 | 133.76 | 133.66 | 133.74 | 18339.0 |
| 2021-01-04 07:30:00 | AAPL | Stock | 133.75 | 133.98 | 133.75 | 133.96 | 35077.0 |
| 2021-01-04 07:35:00 | AAPL | Stock | 133.97 | 133.98 | 133.85 | 133.9 | 39808.0 |
| 2021-01-04 07:40:00 | AAPL | Stock | 133.9 | 133.96 | 133.85 | 133.85 | 11085.0 |
| 2021-01-04 07:45:00 | AAPL | Stock | 133.86 | 133.9 | 133.75 | 133.86 | 18611.0 |
| 2021-01-04 07:50:00 | AAPL | Stock | 133.86 | 133.97 | 133.86 | 133.92 | 22518.0 |
| 2021-01-04 07:55:00 | AAPL | Stock | 133.91 | 133.96 | 133.9 | 133.95 | 14269.0 |
| 2021-01-04 08:00:00 | AAPL | Stock | 133.93 | 133.99 | 133.53 | 133.87 | 153500.0 |
| 2021-01-04 08:05:00 | AAPL | Stock | 133.89 | 134.1 | 133.89 | 134.03 | 116528.0 |
> showing 50 of 475,586 rows — these rows as CSV