PREVIEW / stock_30min / 2021-01-08
file: by_date/stock_30min/2021/2021-01-08.parquet size: 2.3 MB rows: 112,743 symbols: 2,688
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-08 04:00:00 | AAPL | Stock | 131.72 | 132.14 | 131.55 | 131.55 | 17569.0 |
| 2021-01-08 04:30:00 | AAPL | Stock | 131.6 | 131.97 | 131.13 | 131.97 | 11496.0 |
| 2021-01-08 05:00:00 | AAPL | Stock | 131.98 | 132.13 | 131.96 | 132.05 | 25405.0 |
| 2021-01-08 05:30:00 | AAPL | Stock | 132.05 | 132.16 | 132.0 | 132.16 | 31717.0 |
| 2021-01-08 06:00:00 | AAPL | Stock | 132.13 | 132.15 | 131.83 | 132.02 | 11788.0 |
| 2021-01-08 06:30:00 | AAPL | Stock | 132.05 | 132.16 | 132.0 | 132.02 | 26367.0 |
| 2021-01-08 07:00:00 | AAPL | Stock | 132.03 | 132.849 | 132.0 | 132.59 | 378872.0 |
| 2021-01-08 07:30:00 | AAPL | Stock | 132.56 | 132.73 | 132.23 | 132.24 | 145938.0 |
| 2021-01-08 08:00:00 | AAPL | Stock | 132.15 | 132.85 | 132.01 | 132.45 | 466024.0 |
| 2021-01-08 08:30:00 | AAPL | Stock | 132.4 | 132.43 | 132.01 | 132.04 | 347906.0 |
| 2021-01-08 09:00:00 | AAPL | Stock | 132.04 | 132.64 | 132.03 | 132.41 | 402351.0 |
| 2021-01-08 09:30:00 | AAPL | Stock | 132.39 | 132.63 | 130.35 | 131.549 | 15669990.0 |
| 2021-01-08 10:00:00 | AAPL | Stock | 131.545 | 131.98 | 130.26 | 130.38 | 8057646.0 |
| 2021-01-08 10:30:00 | AAPL | Stock | 130.39 | 131.5 | 130.33 | 131.02 | 6307866.0 |
| 2021-01-08 11:00:00 | AAPL | Stock | 131.02 | 131.3 | 130.62 | 131.07 | 5341058.0 |
| 2021-01-08 11:30:00 | AAPL | Stock | 131.07 | 132.25 | 130.98 | 132.24 | 6450999.0 |
| 2021-01-08 12:00:00 | AAPL | Stock | 132.241 | 132.57 | 131.71 | 132.155 | 6404665.0 |
| 2021-01-08 12:30:00 | AAPL | Stock | 132.155 | 132.25 | 131.52 | 131.67 | 3901470.0 |
| 2021-01-08 13:00:00 | AAPL | Stock | 131.67 | 131.795 | 130.37 | 131.12 | 5345447.0 |
| 2021-01-08 13:30:00 | AAPL | Stock | 131.12 | 131.23 | 130.23 | 131.01 | 5072964.0 |
| 2021-01-08 14:00:00 | AAPL | Stock | 131.005 | 131.55 | 130.97 | 131.475 | 3919204.0 |
| 2021-01-08 14:30:00 | AAPL | Stock | 131.47 | 131.555 | 131.08 | 131.44 | 3223161.0 |
| 2021-01-08 15:00:00 | AAPL | Stock | 131.44 | 131.85 | 131.39 | 131.774 | 4158706.0 |
| 2021-01-08 15:30:00 | AAPL | Stock | 131.77 | 132.21 | 131.63 | 131.99 | 7784318.0 |
| 2021-01-08 16:00:00 | AAPL | Stock | 132.05 | 132.2 | 131.757 | 132.04 | 8321149.0 |
| 2021-01-08 16:30:00 | AAPL | Stock | 132.04 | 132.15 | 131.98 | 132.15 | 144344.0 |
| 2021-01-08 17:00:00 | AAPL | Stock | 132.13 | 132.13 | 131.97 | 132.0 | 71158.0 |
| 2021-01-08 17:30:00 | AAPL | Stock | 131.98 | 132.05 | 131.95 | 131.95 | 28794.0 |
| 2021-01-08 18:00:00 | AAPL | Stock | 131.99 | 132.0 | 131.93 | 131.99 | 27946.0 |
| 2021-01-08 18:30:00 | AAPL | Stock | 131.99 | 132.0 | 131.9 | 131.9 | 37777.0 |
| 2021-01-08 19:00:00 | AAPL | Stock | 131.93 | 131.93 | 131.75 | 131.76 | 37711.0 |
| 2021-01-08 19:30:00 | AAPL | Stock | 131.75 | 131.8 | 131.72 | 131.75 | 82987.0 |
| 2021-01-08 04:00:00 | MSFT | Stock | 218.7 | 218.7 | 218.5 | 218.5 | 890.0 |
| 2021-01-08 04:30:00 | MSFT | Stock | 218.31 | 218.51 | 218.02 | 218.51 | 907.0 |
| 2021-01-08 05:00:00 | MSFT | Stock | 218.69 | 218.69 | 218.3 | 218.3 | 929.0 |
| 2021-01-08 05:30:00 | MSFT | Stock | 218.33 | 218.4 | 217.63 | 218.16 | 3860.0 |
| 2021-01-08 06:00:00 | MSFT | Stock | 218.2 | 218.4 | 218.13 | 218.35 | 3803.0 |
| 2021-01-08 06:30:00 | MSFT | Stock | 218.62 | 218.62 | 217.83 | 217.88 | 3041.0 |
| 2021-01-08 07:00:00 | MSFT | Stock | 218.08 | 218.33 | 217.4 | 217.85 | 28884.0 |
| 2021-01-08 07:30:00 | MSFT | Stock | 217.85 | 217.99 | 217.58 | 217.6 | 11958.0 |
| 2021-01-08 08:00:00 | MSFT | Stock | 218.29 | 218.29 | 217.56 | 217.95 | 50444.0 |
| 2021-01-08 08:30:00 | MSFT | Stock | 217.95 | 218.3 | 217.77 | 218.1 | 13938.0 |
| 2021-01-08 09:00:00 | MSFT | Stock | 218.0 | 218.9 | 217.81 | 218.76 | 47748.0 |
| 2021-01-08 09:30:00 | MSFT | Stock | 218.75 | 220.58 | 218.13 | 218.886 | 2586549.0 |
| 2021-01-08 10:00:00 | MSFT | Stock | 218.9 | 219.96 | 217.93 | 218.165 | 1205246.0 |
| 2021-01-08 10:30:00 | MSFT | Stock | 218.17 | 219.29 | 218.05 | 218.83 | 1001097.0 |
| 2021-01-08 11:00:00 | MSFT | Stock | 218.84 | 219.4 | 217.723 | 218.02 | 917675.0 |
| 2021-01-08 11:30:00 | MSFT | Stock | 218.03 | 218.29 | 217.52 | 218.245 | 840945.0 |
| 2021-01-08 12:00:00 | MSFT | Stock | 218.255 | 218.94 | 217.79 | 218.372 | 888410.0 |
| 2021-01-08 12:30:00 | MSFT | Stock | 218.378 | 218.75 | 217.924 | 218.14 | 606847.0 |
> showing 50 of 112,743 rows — these rows as CSV