PREVIEW / stock_30min / 2002-01-28
file: by_date/stock_30min/2002/2002-01-28.parquet size: 585 KB rows: 30,405 symbols: 1,348
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-28 08:30:00 | AAPL | Stock | 0.4157 | 0.4195 | 0.4157 | 0.4188 | 100800.0 |
| 2002-01-28 09:00:00 | AAPL | Stock | 0.4175 | 0.4179 | 0.4154 | 0.4175 | 218400.0 |
| 2002-01-28 09:30:00 | AAPL | Stock | 0.4179 | 0.4205 | 0.4154 | 0.4191 | 17539200.0 |
| 2002-01-28 10:00:00 | AAPL | Stock | 0.4193 | 0.4193 | 0.413 | 0.4138 | 11172000.0 |
| 2002-01-28 10:30:00 | AAPL | Stock | 0.4134 | 0.4188 | 0.4127 | 0.4188 | 16609600.0 |
| 2002-01-28 11:00:00 | AAPL | Stock | 0.4186 | 0.4191 | 0.4166 | 0.4189 | 7022400.0 |
| 2002-01-28 11:30:00 | AAPL | Stock | 0.4189 | 0.4191 | 0.4129 | 0.4129 | 16928800.0 |
| 2002-01-28 12:00:00 | AAPL | Stock | 0.4129 | 0.4143 | 0.4057 | 0.4089 | 33107200.0 |
| 2002-01-28 12:30:00 | AAPL | Stock | 0.4093 | 0.412 | 0.4089 | 0.4105 | 14033600.0 |
| 2002-01-28 13:00:00 | AAPL | Stock | 0.4104 | 0.4107 | 0.4073 | 0.4098 | 6759200.0 |
| 2002-01-28 13:30:00 | AAPL | Stock | 0.41 | 0.4113 | 0.4086 | 0.4088 | 6014400.0 |
| 2002-01-28 14:00:00 | AAPL | Stock | 0.4089 | 0.4114 | 0.408 | 0.4107 | 5258400.0 |
| 2002-01-28 14:30:00 | AAPL | Stock | 0.4111 | 0.4134 | 0.4102 | 0.4105 | 10158400.0 |
| 2002-01-28 15:00:00 | AAPL | Stock | 0.4104 | 0.4152 | 0.41 | 0.4143 | 15030400.0 |
| 2002-01-28 15:30:00 | AAPL | Stock | 0.4136 | 0.4173 | 0.4132 | 0.4159 | 12308800.0 |
| 2002-01-28 16:00:00 | AAPL | Stock | 0.4152 | 0.4186 | 0.4114 | 0.4184 | 4099200.0 |
| 2002-01-28 16:30:00 | AAPL | Stock | 0.4155 | 0.4155 | 0.4155 | 0.4155 | 106400.0 |
| 2002-01-28 17:00:00 | AAPL | Stock | 0.4155 | 0.4184 | 0.4155 | 0.4184 | 84000.0 |
| 2002-01-28 17:30:00 | AAPL | Stock | 0.4184 | 0.4184 | 0.4184 | 0.4184 | 56000.0 |
| 2002-01-28 08:00:00 | MSFT | Stock | 32.0 | 32.15 | 32.0 | 32.15 | 5200.0 |
| 2002-01-28 08:30:00 | MSFT | Stock | 32.175 | 32.2 | 32.125 | 32.175 | 14200.0 |
| 2002-01-28 09:00:00 | MSFT | Stock | 32.175 | 32.175 | 31.945 | 32.1195 | 116800.0 |
| 2002-01-28 09:30:00 | MSFT | Stock | 32.115 | 32.2 | 31.905 | 31.965 | 6703600.0 |
| 2002-01-28 10:00:00 | MSFT | Stock | 31.955 | 32.07 | 31.8855 | 32.05 | 3408200.0 |
| 2002-01-28 10:30:00 | MSFT | Stock | 32.04 | 32.075 | 31.945 | 32.0145 | 2734400.0 |
| 2002-01-28 11:00:00 | MSFT | Stock | 32.0 | 32.125 | 31.91 | 31.95 | 2936600.0 |
| 2002-01-28 11:30:00 | MSFT | Stock | 31.95 | 32.0 | 31.835 | 31.865 | 2768400.0 |
| 2002-01-28 12:00:00 | MSFT | Stock | 31.86 | 31.875 | 31.625 | 31.665 | 3364000.0 |
| 2002-01-28 12:30:00 | MSFT | Stock | 31.66 | 31.75 | 31.6295 | 31.6505 | 1824200.0 |
| 2002-01-28 13:00:00 | MSFT | Stock | 31.6595 | 31.71 | 31.55 | 31.6695 | 2395600.0 |
| 2002-01-28 13:30:00 | MSFT | Stock | 31.67 | 31.72 | 31.5 | 31.53 | 2195600.0 |
| 2002-01-28 14:00:00 | MSFT | Stock | 31.525 | 31.63 | 31.5 | 31.56 | 1695400.0 |
| 2002-01-28 14:30:00 | MSFT | Stock | 31.57 | 31.64 | 31.525 | 31.555 | 1794200.0 |
| 2002-01-28 15:00:00 | MSFT | Stock | 31.555 | 31.73 | 31.455 | 31.705 | 2922800.0 |
| 2002-01-28 15:30:00 | MSFT | Stock | 31.705 | 31.9605 | 31.69 | 31.905 | 3751600.0 |
| 2002-01-28 16:00:00 | MSFT | Stock | 31.905 | 32.075 | 31.575 | 31.985 | 1285400.0 |
| 2002-01-28 16:30:00 | MSFT | Stock | 31.8375 | 32.0 | 31.8375 | 31.91 | 282200.0 |
| 2002-01-28 17:00:00 | MSFT | Stock | 31.95 | 31.995 | 31.91 | 31.95 | 41400.0 |
| 2002-01-28 17:30:00 | MSFT | Stock | 31.95 | 31.95 | 31.95 | 31.95 | 2400.0 |
| 2002-01-28 18:00:00 | MSFT | Stock | 32.0 | 32.005 | 32.0 | 32.005 | 1400.0 |
| 2002-01-28 08:00:00 | NVDA | Stock | 0.547 | 0.5542 | 0.547 | 0.5542 | 4272000.0 |
| 2002-01-28 08:30:00 | NVDA | Stock | 0.5525 | 0.5561 | 0.5519 | 0.5554 | 1800000.0 |
| 2002-01-28 09:00:00 | NVDA | Stock | 0.5542 | 0.5583 | 0.5542 | 0.5564 | 10500000.0 |
| 2002-01-28 09:30:00 | NVDA | Stock | 0.5562 | 0.5617 | 0.5507 | 0.5582 | 184404000.0 |
| 2002-01-28 10:00:00 | NVDA | Stock | 0.558 | 0.5599 | 0.5528 | 0.5572 | 88452000.0 |
| 2002-01-28 10:30:00 | NVDA | Stock | 0.5572 | 0.5604 | 0.5555 | 0.5595 | 89808000.0 |
| 2002-01-28 11:00:00 | NVDA | Stock | 0.5597 | 0.5621 | 0.5585 | 0.5587 | 67500000.0 |
| 2002-01-28 11:30:00 | NVDA | Stock | 0.5588 | 0.56 | 0.5552 | 0.5577 | 57900000.0 |
| 2002-01-28 12:00:00 | NVDA | Stock | 0.5576 | 0.5583 | 0.5552 | 0.5562 | 32808000.0 |
| 2002-01-28 12:30:00 | NVDA | Stock | 0.5563 | 0.5597 | 0.556 | 0.5577 | 29040000.0 |
> showing 50 of 30,405 rows — these rows as CSV