PREVIEW / stock_30min / 2022-11-11
file: by_date/stock_30min/2022/2022-11-11.parquet size: 2.1 MB rows: 104,602 symbols: 2,071
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-11-11 04:00:00 | AAPL | Stock | 148.06 | 148.74 | 147.74 | 148.0 | 76905.0 |
| 2022-11-11 04:30:00 | AAPL | Stock | 147.93 | 148.02 | 147.82 | 147.97 | 11384.0 |
| 2022-11-11 05:00:00 | AAPL | Stock | 147.97 | 147.99 | 147.6 | 147.6 | 59002.0 |
| 2022-11-11 05:30:00 | AAPL | Stock | 147.69 | 147.78 | 147.4 | 147.52 | 48804.0 |
| 2022-11-11 06:00:00 | AAPL | Stock | 147.5 | 147.64 | 147.34 | 147.51 | 38730.0 |
| 2022-11-11 06:30:00 | AAPL | Stock | 147.53 | 147.58 | 147.29 | 147.39 | 36341.0 |
| 2022-11-11 07:00:00 | AAPL | Stock | 147.43 | 147.47 | 146.9 | 147.0 | 87318.0 |
| 2022-11-11 07:30:00 | AAPL | Stock | 147.0 | 147.52 | 146.93 | 147.43 | 95528.0 |
| 2022-11-11 08:00:00 | AAPL | Stock | 147.35 | 148.33 | 146.91 | 147.49 | 191384.0 |
| 2022-11-11 08:30:00 | AAPL | Stock | 147.5058 | 147.52 | 147.12 | 147.25 | 216208.0 |
| 2022-11-11 09:00:00 | AAPL | Stock | 147.22 | 147.22 | 145.35 | 145.78 | 462121.0 |
| 2022-11-11 09:30:00 | AAPL | Stock | 145.82 | 146.47 | 144.37 | 145.44 | 10453140.0 |
| 2022-11-11 10:00:00 | AAPL | Stock | 145.42 | 148.0225 | 144.7501 | 147.6 | 7624323.0 |
| 2022-11-11 10:30:00 | AAPL | Stock | 147.6 | 148.57 | 147.07 | 148.115 | 5595851.0 |
| 2022-11-11 11:00:00 | AAPL | Stock | 148.12 | 148.75 | 146.7 | 146.7 | 5304361.0 |
| 2022-11-11 11:30:00 | AAPL | Stock | 146.715 | 147.65 | 146.43 | 147.38 | 4515965.0 |
| 2022-11-11 12:00:00 | AAPL | Stock | 147.38 | 148.225 | 147.17 | 148.2057 | 3715462.0 |
| 2022-11-11 12:30:00 | AAPL | Stock | 148.21 | 148.52 | 147.91 | 148.2501 | 3036986.0 |
| 2022-11-11 13:00:00 | AAPL | Stock | 148.255 | 149.3 | 148.22 | 149.2 | 3932952.0 |
| 2022-11-11 13:30:00 | AAPL | Stock | 149.19 | 149.74 | 149.02 | 149.605 | 3938891.0 |
| 2022-11-11 14:00:00 | AAPL | Stock | 149.6039 | 150.01 | 149.44 | 149.61 | 4125022.0 |
| 2022-11-11 14:30:00 | AAPL | Stock | 149.645 | 150.0 | 149.51 | 149.98 | 3592449.0 |
| 2022-11-11 15:00:00 | AAPL | Stock | 149.99 | 150.0 | 148.7603 | 149.3017 | 5510866.0 |
| 2022-11-11 15:30:00 | AAPL | Stock | 149.3 | 149.93 | 149.0 | 149.7 | 8907861.0 |
| 2022-11-11 16:00:00 | AAPL | Stock | 149.63 | 149.7 | 149.4 | 149.43 | 11527223.0 |
| 2022-11-11 16:30:00 | AAPL | Stock | 149.47 | 149.7 | 149.37 | 149.42 | 110423.0 |
| 2022-11-11 17:00:00 | AAPL | Stock | 149.39 | 149.7 | 149.39 | 149.48 | 57614.0 |
| 2022-11-11 17:30:00 | AAPL | Stock | 149.47 | 149.49 | 149.43 | 149.43 | 14845.0 |
| 2022-11-11 18:00:00 | AAPL | Stock | 149.48 | 149.48 | 149.43 | 149.44 | 18928.0 |
| 2022-11-11 18:30:00 | AAPL | Stock | 149.46 | 149.46 | 149.37 | 149.37 | 15744.0 |
| 2022-11-11 19:00:00 | AAPL | Stock | 149.3999 | 149.44 | 149.37 | 149.41 | 15027.0 |
| 2022-11-11 19:30:00 | AAPL | Stock | 149.38 | 149.45 | 149.37 | 149.44 | 19606.0 |
| 2022-11-11 04:00:00 | MSFT | Stock | 244.86 | 245.5 | 244.61 | 244.61 | 2935.0 |
| 2022-11-11 04:30:00 | MSFT | Stock | 244.7 | 244.7 | 244.62 | 244.7 | 1300.0 |
| 2022-11-11 05:00:00 | MSFT | Stock | 244.71 | 244.85 | 244.4 | 244.4 | 1914.0 |
| 2022-11-11 05:30:00 | MSFT | Stock | 244.4 | 244.4 | 244.01 | 244.01 | 2280.0 |
| 2022-11-11 06:00:00 | MSFT | Stock | 244.03 | 244.2 | 244.01 | 244.2 | 2873.0 |
| 2022-11-11 06:30:00 | MSFT | Stock | 244.1 | 244.1 | 243.35 | 243.4 | 4174.0 |
| 2022-11-11 07:00:00 | MSFT | Stock | 243.7 | 243.75 | 243.4 | 243.69 | 9089.0 |
| 2022-11-11 07:30:00 | MSFT | Stock | 243.53 | 244.21 | 243.5 | 244.2 | 14388.0 |
| 2022-11-11 08:00:00 | MSFT | Stock | 243.5198 | 244.47 | 243.2103 | 244.4 | 29953.0 |
| 2022-11-11 08:30:00 | MSFT | Stock | 244.17 | 244.4 | 243.5 | 243.5 | 37137.0 |
| 2022-11-11 09:00:00 | MSFT | Stock | 243.5 | 243.64 | 241.18 | 243.1 | 101409.0 |
| 2022-11-11 09:30:00 | MSFT | Stock | 242.99 | 244.98 | 241.93 | 243.675 | 2755761.0 |
| 2022-11-11 10:00:00 | MSFT | Stock | 243.62 | 246.3 | 242.4705 | 245.7149 | 2007728.0 |
| 2022-11-11 10:30:00 | MSFT | Stock | 245.71 | 246.62 | 244.9038 | 245.695 | 1327924.0 |
| 2022-11-11 11:00:00 | MSFT | Stock | 245.7 | 246.09 | 242.485 | 242.81 | 1839294.0 |
| 2022-11-11 11:30:00 | MSFT | Stock | 242.7697 | 244.65 | 242.42 | 244.505 | 1186321.0 |
| 2022-11-11 12:00:00 | MSFT | Stock | 244.49 | 246.21 | 243.9 | 246.055 | 1315715.0 |
| 2022-11-11 12:30:00 | MSFT | Stock | 246.07 | 247.08 | 245.54 | 246.4655 | 936160.0 |
> showing 50 of 104,602 rows — these rows as CSV