PREVIEW / stock_30min / 2003-10-20
file: by_date/stock_30min/2003/2003-10-20.parquet size: 695 KB rows: 37,737 symbols: 1,635
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-20 08:00:00 | AAPL | Stock | 0.4091 | 0.4091 | 0.4089 | 0.4089 | 28000.0 |
| 2003-10-20 08:30:00 | AAPL | Stock | 0.4107 | 0.4107 | 0.4089 | 0.4089 | 115640.0 |
| 2003-10-20 09:00:00 | AAPL | Stock | 0.4093 | 0.4093 | 0.4004 | 0.4046 | 2293200.0 |
| 2003-10-20 09:30:00 | AAPL | Stock | 0.4036 | 0.408 | 0.3996 | 0.4039 | 48391448.0 |
| 2003-10-20 10:00:00 | AAPL | Stock | 0.4038 | 0.4061 | 0.4015 | 0.4019 | 20948816.0 |
| 2003-10-20 10:30:00 | AAPL | Stock | 0.402 | 0.4061 | 0.4016 | 0.4046 | 17565856.0 |
| 2003-10-20 11:00:00 | AAPL | Stock | 0.4046 | 0.4059 | 0.4039 | 0.4048 | 5721296.0 |
| 2003-10-20 11:30:00 | AAPL | Stock | 0.4048 | 0.4054 | 0.4036 | 0.4045 | 6797336.0 |
| 2003-10-20 12:00:00 | AAPL | Stock | 0.4045 | 0.4054 | 0.4034 | 0.405 | 10160472.0 |
| 2003-10-20 12:30:00 | AAPL | Stock | 0.405 | 0.4086 | 0.4046 | 0.408 | 31308592.0 |
| 2003-10-20 13:00:00 | AAPL | Stock | 0.408 | 0.4107 | 0.4073 | 0.4102 | 15037400.0 |
| 2003-10-20 13:30:00 | AAPL | Stock | 0.4107 | 0.412 | 0.4093 | 0.4111 | 19298944.0 |
| 2003-10-20 14:00:00 | AAPL | Stock | 0.4112 | 0.4139 | 0.4102 | 0.4109 | 19882352.0 |
| 2003-10-20 14:30:00 | AAPL | Stock | 0.4113 | 0.4125 | 0.4096 | 0.4118 | 11466672.0 |
| 2003-10-20 15:00:00 | AAPL | Stock | 0.4118 | 0.4129 | 0.4109 | 0.4121 | 8064336.0 |
| 2003-10-20 15:30:00 | AAPL | Stock | 0.412 | 0.4168 | 0.412 | 0.4161 | 42469616.0 |
| 2003-10-20 16:00:00 | AAPL | Stock | 0.4168 | 0.4168 | 0.4143 | 0.4161 | 2779784.0 |
| 2003-10-20 16:30:00 | AAPL | Stock | 0.4164 | 0.4196 | 0.4161 | 0.4195 | 1643320.0 |
| 2003-10-20 17:00:00 | AAPL | Stock | 0.4195 | 0.4196 | 0.4161 | 0.4167 | 375200.0 |
| 2003-10-20 17:30:00 | AAPL | Stock | 0.4171 | 0.4171 | 0.4171 | 0.4171 | 28000.0 |
| 2003-10-20 18:00:00 | AAPL | Stock | 0.4193 | 0.4196 | 0.4163 | 0.4163 | 84000.0 |
| 2003-10-20 08:00:00 | MSFT | Stock | 29.0 | 29.09 | 28.999 | 29.05 | 26100.0 |
| 2003-10-20 08:30:00 | MSFT | Stock | 29.02 | 29.05 | 28.93 | 28.962 | 67125.0 |
| 2003-10-20 09:00:00 | MSFT | Stock | 28.95 | 29.05 | 28.88 | 28.94 | 401835.0 |
| 2003-10-20 09:30:00 | MSFT | Stock | 28.95 | 28.98 | 28.82 | 28.95 | 3977563.0 |
| 2003-10-20 10:00:00 | MSFT | Stock | 28.96 | 29.003 | 28.8 | 28.9 | 3604651.0 |
| 2003-10-20 10:30:00 | MSFT | Stock | 28.91 | 28.95 | 28.82 | 28.89 | 2891936.0 |
| 2003-10-20 11:00:00 | MSFT | Stock | 28.89 | 28.96 | 28.88 | 28.94 | 1851754.0 |
| 2003-10-20 11:30:00 | MSFT | Stock | 28.95 | 29.07 | 28.91 | 29.04 | 2430034.0 |
| 2003-10-20 12:00:00 | MSFT | Stock | 29.03 | 29.19 | 29.02 | 29.13 | 2858054.0 |
| 2003-10-20 12:30:00 | MSFT | Stock | 29.14 | 29.231 | 29.12 | 29.219 | 1744309.0 |
| 2003-10-20 13:00:00 | MSFT | Stock | 29.22 | 29.27 | 29.169 | 29.21 | 2333446.0 |
| 2003-10-20 13:30:00 | MSFT | Stock | 29.21 | 29.2248 | 29.13 | 29.21 | 2361707.0 |
| 2003-10-20 14:00:00 | MSFT | Stock | 29.21 | 29.23 | 29.11 | 29.12 | 1627444.0 |
| 2003-10-20 14:30:00 | MSFT | Stock | 29.111 | 29.21 | 29.05 | 29.17 | 2019007.0 |
| 2003-10-20 15:00:00 | MSFT | Stock | 29.18 | 29.24 | 29.17 | 29.24 | 1957303.0 |
| 2003-10-20 15:30:00 | MSFT | Stock | 29.24 | 29.37 | 29.21 | 29.37 | 5578442.0 |
| 2003-10-20 16:00:00 | MSFT | Stock | 29.37 | 29.37 | 29.18 | 29.34 | 554952.0 |
| 2003-10-20 16:30:00 | MSFT | Stock | 29.35 | 29.46 | 29.3318 | 29.46 | 106940.0 |
| 2003-10-20 17:00:00 | MSFT | Stock | 29.46 | 29.5 | 29.43 | 29.5 | 28948.0 |
| 2003-10-20 17:30:00 | MSFT | Stock | 29.5 | 29.51 | 29.0872 | 29.51 | 124361.0 |
| 2003-10-20 18:00:00 | MSFT | Stock | 29.51 | 29.52 | 29.5 | 29.52 | 11905.0 |
| 2003-10-20 08:00:00 | NVDA | Stock | 0.1389 | 0.1402 | 0.1388 | 0.1402 | 264000.0 |
| 2003-10-20 08:30:00 | NVDA | Stock | 0.1402 | 0.1402 | 0.1396 | 0.1396 | 120000.0 |
| 2003-10-20 09:00:00 | NVDA | Stock | 0.1392 | 0.1392 | 0.1387 | 0.139 | 1074600.0 |
| 2003-10-20 09:30:00 | NVDA | Stock | 0.1389 | 0.141 | 0.1387 | 0.1402 | 37151520.0 |
| 2003-10-20 10:00:00 | NVDA | Stock | 0.1403 | 0.1412 | 0.1381 | 0.139 | 62436720.0 |
| 2003-10-20 10:30:00 | NVDA | Stock | 0.139 | 0.1406 | 0.1382 | 0.1401 | 54511320.0 |
| 2003-10-20 11:00:00 | NVDA | Stock | 0.1401 | 0.1405 | 0.1397 | 0.1402 | 22821480.0 |
| 2003-10-20 11:30:00 | NVDA | Stock | 0.1402 | 0.1404 | 0.1397 | 0.1402 | 38322600.0 |
> showing 50 of 37,737 rows — these rows as CSV