PREVIEW / stock_30min / 2002-01-23
file: by_date/stock_30min/2002/2002-01-23.parquet size: 591 KB rows: 30,656 symbols: 1,337
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-23 08:00:00 | AAPL | Stock | 0.3893 | 0.3929 | 0.3893 | 0.3929 | 61600.0 |
| 2002-01-23 08:30:00 | AAPL | Stock | 0.3911 | 0.3911 | 0.3911 | 0.3911 | 246400.0 |
| 2002-01-23 09:00:00 | AAPL | Stock | 0.3911 | 0.3911 | 0.3891 | 0.3891 | 543200.0 |
| 2002-01-23 09:30:00 | AAPL | Stock | 0.3893 | 0.3929 | 0.3855 | 0.3905 | 37290400.0 |
| 2002-01-23 10:00:00 | AAPL | Stock | 0.3902 | 0.3907 | 0.3877 | 0.3884 | 27972000.0 |
| 2002-01-23 10:30:00 | AAPL | Stock | 0.3881 | 0.3973 | 0.388 | 0.3973 | 30721600.0 |
| 2002-01-23 11:00:00 | AAPL | Stock | 0.3966 | 0.4021 | 0.3962 | 0.4013 | 53228000.0 |
| 2002-01-23 11:30:00 | AAPL | Stock | 0.4013 | 0.4057 | 0.4009 | 0.4018 | 34580000.0 |
| 2002-01-23 12:00:00 | AAPL | Stock | 0.4027 | 0.4028 | 0.3996 | 0.4013 | 15836800.0 |
| 2002-01-23 12:30:00 | AAPL | Stock | 0.4012 | 0.4036 | 0.4007 | 0.4032 | 22484000.0 |
| 2002-01-23 13:00:00 | AAPL | Stock | 0.4032 | 0.4079 | 0.4025 | 0.4068 | 32704000.0 |
| 2002-01-23 13:30:00 | AAPL | Stock | 0.4066 | 0.4104 | 0.4061 | 0.4089 | 23895200.0 |
| 2002-01-23 14:00:00 | AAPL | Stock | 0.4088 | 0.4107 | 0.4086 | 0.4095 | 34798400.0 |
| 2002-01-23 14:30:00 | AAPL | Stock | 0.4095 | 0.4105 | 0.4078 | 0.4084 | 37464000.0 |
| 2002-01-23 15:00:00 | AAPL | Stock | 0.408 | 0.41 | 0.408 | 0.41 | 20087200.0 |
| 2002-01-23 15:30:00 | AAPL | Stock | 0.41 | 0.4114 | 0.4069 | 0.4107 | 39726400.0 |
| 2002-01-23 16:00:00 | AAPL | Stock | 0.4107 | 0.4143 | 0.4021 | 0.4021 | 16632000.0 |
| 2002-01-23 16:30:00 | AAPL | Stock | 0.4111 | 0.412 | 0.4111 | 0.4111 | 901600.0 |
| 2002-01-23 17:00:00 | AAPL | Stock | 0.412 | 0.412 | 0.412 | 0.412 | 28000.0 |
| 2002-01-23 17:30:00 | AAPL | Stock | 0.4111 | 0.412 | 0.4111 | 0.412 | 515200.0 |
| 2002-01-23 08:00:00 | MSFT | Stock | 32.35 | 32.4 | 32.24 | 32.26 | 16800.0 |
| 2002-01-23 08:30:00 | MSFT | Stock | 32.25 | 32.35 | 32.18 | 32.18 | 21000.0 |
| 2002-01-23 09:00:00 | MSFT | Stock | 32.18 | 32.235 | 32.025 | 32.03 | 101200.0 |
| 2002-01-23 09:30:00 | MSFT | Stock | 32.025 | 32.07 | 31.6745 | 31.73 | 10958400.0 |
| 2002-01-23 10:00:00 | MSFT | Stock | 31.735 | 31.85 | 31.63 | 31.74 | 5850600.0 |
| 2002-01-23 10:30:00 | MSFT | Stock | 31.72 | 31.945 | 31.695 | 31.945 | 8103200.0 |
| 2002-01-23 11:00:00 | MSFT | Stock | 31.95 | 31.95 | 31.62 | 31.7255 | 4773000.0 |
| 2002-01-23 11:30:00 | MSFT | Stock | 31.7255 | 31.85 | 31.7 | 31.8 | 4036000.0 |
| 2002-01-23 12:00:00 | MSFT | Stock | 31.805 | 31.85 | 31.625 | 31.7755 | 3430400.0 |
| 2002-01-23 12:30:00 | MSFT | Stock | 31.755 | 31.9455 | 31.675 | 31.89 | 3840800.0 |
| 2002-01-23 13:00:00 | MSFT | Stock | 31.895 | 32.08 | 31.705 | 32.02 | 4724400.0 |
| 2002-01-23 13:30:00 | MSFT | Stock | 32.02 | 32.35 | 31.995 | 32.1475 | 6086600.0 |
| 2002-01-23 14:00:00 | MSFT | Stock | 32.14 | 32.275 | 32.0 | 32.13 | 4025800.0 |
| 2002-01-23 14:30:00 | MSFT | Stock | 32.13 | 32.17 | 31.83 | 31.9 | 7289600.0 |
| 2002-01-23 15:00:00 | MSFT | Stock | 31.9 | 32.06 | 31.86 | 31.98 | 4531400.0 |
| 2002-01-23 15:30:00 | MSFT | Stock | 31.975 | 32.025 | 31.73 | 31.865 | 6440800.0 |
| 2002-01-23 16:00:00 | MSFT | Stock | 31.85 | 32.2262 | 31.76 | 31.815 | 2097600.0 |
| 2002-01-23 16:30:00 | MSFT | Stock | 31.815 | 31.87 | 31.775 | 31.855 | 439600.0 |
| 2002-01-23 17:00:00 | MSFT | Stock | 31.855 | 31.8952 | 31.775 | 31.85 | 150000.0 |
| 2002-01-23 17:30:00 | MSFT | Stock | 31.92 | 31.92 | 31.805 | 31.825 | 59200.0 |
| 2002-01-23 18:00:00 | MSFT | Stock | 31.8 | 31.945 | 31.755 | 31.945 | 5800.0 |
| 2002-01-23 08:00:00 | NVDA | Stock | 0.5245 | 0.525 | 0.5233 | 0.5241 | 432000.0 |
| 2002-01-23 08:30:00 | NVDA | Stock | 0.5233 | 0.5233 | 0.5229 | 0.5229 | 132000.0 |
| 2002-01-23 09:00:00 | NVDA | Stock | 0.5225 | 0.5231 | 0.5208 | 0.5227 | 2904000.0 |
| 2002-01-23 09:30:00 | NVDA | Stock | 0.523 | 0.5268 | 0.5141 | 0.5199 | 99552000.0 |
| 2002-01-23 10:00:00 | NVDA | Stock | 0.5198 | 0.5203 | 0.5127 | 0.5149 | 85164000.0 |
| 2002-01-23 10:30:00 | NVDA | Stock | 0.5149 | 0.5204 | 0.5129 | 0.5198 | 74796000.0 |
| 2002-01-23 11:00:00 | NVDA | Stock | 0.5193 | 0.52 | 0.5154 | 0.5179 | 34872000.0 |
| 2002-01-23 11:30:00 | NVDA | Stock | 0.5183 | 0.5223 | 0.5133 | 0.5163 | 59772000.0 |
| 2002-01-23 12:00:00 | NVDA | Stock | 0.5163 | 0.5193 | 0.5146 | 0.5182 | 25932000.0 |
> showing 50 of 30,656 rows — these rows as CSV