PREVIEW / stock_30min / 2022-12-06
file: by_date/stock_30min/2022/2022-12-06.parquet size: 2.1 MB rows: 101,818 symbols: 2,056
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-06 04:00:00 | AAPL | Stock | 147.05 | 147.35 | 146.91 | 147.35 | 36378.0 |
| 2022-12-06 04:30:00 | AAPL | Stock | 147.3 | 147.42 | 147.15 | 147.15 | 17447.0 |
| 2022-12-06 05:00:00 | AAPL | Stock | 147.07 | 147.16 | 146.88 | 146.88 | 20416.0 |
| 2022-12-06 05:30:00 | AAPL | Stock | 146.81 | 147.29 | 146.77 | 147.25 | 3316.0 |
| 2022-12-06 06:00:00 | AAPL | Stock | 147.2 | 147.25 | 147.06 | 147.2 | 4420.0 |
| 2022-12-06 06:30:00 | AAPL | Stock | 147.22 | 147.45 | 147.22 | 147.36 | 9272.0 |
| 2022-12-06 07:00:00 | AAPL | Stock | 147.32 | 147.59 | 147.2 | 147.5 | 30039.0 |
| 2022-12-06 07:30:00 | AAPL | Stock | 147.5 | 147.61 | 147.16 | 147.22 | 25624.0 |
| 2022-12-06 08:00:00 | AAPL | Stock | 147.4 | 147.6 | 146.264 | 147.14 | 85140.0 |
| 2022-12-06 08:30:00 | AAPL | Stock | 147.0936 | 147.45 | 146.91 | 147.21 | 40621.0 |
| 2022-12-06 09:00:00 | AAPL | Stock | 147.21 | 147.47 | 146.93 | 147.0 | 66273.0 |
| 2022-12-06 09:30:00 | AAPL | Stock | 147.06 | 147.3 | 145.11 | 145.1308 | 5947234.0 |
| 2022-12-06 10:00:00 | AAPL | Stock | 145.135 | 145.36 | 144.32 | 144.55 | 4491667.0 |
| 2022-12-06 10:30:00 | AAPL | Stock | 144.55 | 144.58 | 143.56 | 144.125 | 3964308.0 |
| 2022-12-06 11:00:00 | AAPL | Stock | 144.12 | 144.83 | 143.85 | 144.74 | 3449863.0 |
| 2022-12-06 11:30:00 | AAPL | Stock | 144.735 | 145.015 | 144.46 | 144.56 | 2743271.0 |
| 2022-12-06 12:00:00 | AAPL | Stock | 144.55 | 144.89 | 144.02 | 144.31 | 2461875.0 |
| 2022-12-06 12:30:00 | AAPL | Stock | 144.3 | 144.44 | 143.86 | 143.97 | 1874776.0 |
| 2022-12-06 13:00:00 | AAPL | Stock | 143.98 | 144.19 | 143.48 | 143.8195 | 3193854.0 |
| 2022-12-06 13:30:00 | AAPL | Stock | 143.82 | 143.965 | 143.11 | 143.57 | 3065257.0 |
| 2022-12-06 14:00:00 | AAPL | Stock | 143.5722 | 143.6 | 142.31 | 142.31 | 3446843.0 |
| 2022-12-06 14:30:00 | AAPL | Stock | 142.308 | 142.66 | 141.92 | 142.4599 | 3383880.0 |
| 2022-12-06 15:00:00 | AAPL | Stock | 142.47 | 142.91 | 141.98 | 142.09 | 3830104.0 |
| 2022-12-06 15:30:00 | AAPL | Stock | 142.0908 | 143.01 | 142.06 | 142.92 | 6882245.0 |
| 2022-12-06 16:00:00 | AAPL | Stock | 142.92 | 143.05 | 142.71 | 143.03 | 8359774.0 |
| 2022-12-06 16:30:00 | AAPL | Stock | 142.91 | 143.03 | 142.91 | 143.01 | 45389.0 |
| 2022-12-06 17:00:00 | AAPL | Stock | 143.0 | 143.02 | 142.9 | 143.01 | 53827.0 |
| 2022-12-06 17:30:00 | AAPL | Stock | 142.98 | 143.02 | 142.96 | 142.9615 | 13005.0 |
| 2022-12-06 18:00:00 | AAPL | Stock | 142.95 | 143.1 | 142.95 | 143.1 | 8791.0 |
| 2022-12-06 18:30:00 | AAPL | Stock | 143.1 | 143.15 | 143.09 | 143.11 | 8539.0 |
| 2022-12-06 19:00:00 | AAPL | Stock | 143.11 | 143.33 | 143.1 | 143.29 | 12535.0 |
| 2022-12-06 19:30:00 | AAPL | Stock | 143.12 | 143.19 | 143.07 | 143.07 | 13579.0 |
| 2022-12-06 04:00:00 | MSFT | Stock | 250.83 | 250.83 | 250.27 | 250.57 | 800.0 |
| 2022-12-06 04:30:00 | MSFT | Stock | 250.3 | 250.4 | 250.0 | 250.0 | 1925.0 |
| 2022-12-06 05:00:00 | MSFT | Stock | 250.17 | 250.38 | 250.0 | 250.0 | 1777.0 |
| 2022-12-06 05:30:00 | MSFT | Stock | 250.0 | 250.0 | 249.99 | 249.99 | 409.0 |
| 2022-12-06 06:00:00 | MSFT | Stock | 250.11 | 250.11 | 250.11 | 250.11 | 200.0 |
| 2022-12-06 06:30:00 | MSFT | Stock | 250.21 | 250.65 | 250.2 | 250.65 | 641.0 |
| 2022-12-06 07:00:00 | MSFT | Stock | 250.69 | 250.73 | 250.55 | 250.6 | 2346.0 |
| 2022-12-06 07:30:00 | MSFT | Stock | 250.55 | 250.55 | 250.21 | 250.21 | 4675.0 |
| 2022-12-06 08:00:00 | MSFT | Stock | 250.1525 | 250.8482 | 249.575 | 250.38 | 13048.0 |
| 2022-12-06 08:30:00 | MSFT | Stock | 250.84 | 250.89 | 250.3 | 250.89 | 6048.0 |
| 2022-12-06 09:00:00 | MSFT | Stock | 250.94 | 251.45 | 250.56 | 250.83 | 11361.0 |
| 2022-12-06 09:30:00 | MSFT | Stock | 250.82 | 251.86 | 248.23 | 248.23 | 2000149.0 |
| 2022-12-06 10:00:00 | MSFT | Stock | 248.25 | 248.3028 | 247.01 | 247.29 | 1048154.0 |
| 2022-12-06 10:30:00 | MSFT | Stock | 247.28 | 247.58 | 246.41 | 247.09 | 875210.0 |
| 2022-12-06 11:00:00 | MSFT | Stock | 247.115 | 247.28 | 246.21 | 246.68 | 696145.0 |
| 2022-12-06 11:30:00 | MSFT | Stock | 246.685 | 247.05 | 246.26 | 246.49 | 673468.0 |
| 2022-12-06 12:00:00 | MSFT | Stock | 246.5 | 246.76 | 245.55 | 246.09 | 868178.0 |
| 2022-12-06 12:30:00 | MSFT | Stock | 246.09 | 246.14 | 245.21 | 245.37 | 859234.0 |
> showing 50 of 101,818 rows — these rows as CSV