PREVIEW / stock_30min / 2005-06-01
file: by_date/stock_30min/2005/2005-06-01.parquet size: 846 KB rows: 45,582 symbols: 1,979
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-01 08:00:00 | AAPL | Stock | 1.4129 | 1.4221 | 1.4129 | 1.4221 | 80640.0 |
| 2005-06-01 08:30:00 | AAPL | Stock | 1.4196 | 1.4214 | 1.4196 | 1.4214 | 70980.0 |
| 2005-06-01 09:00:00 | AAPL | Stock | 1.4196 | 1.4293 | 1.4093 | 1.4279 | 2324392.0 |
| 2005-06-01 09:30:00 | AAPL | Stock | 1.4246 | 1.4386 | 1.4236 | 1.4371 | 51966348.0 |
| 2005-06-01 10:00:00 | AAPL | Stock | 1.4371 | 1.4557 | 1.4368 | 1.4511 | 80437448.0 |
| 2005-06-01 10:30:00 | AAPL | Stock | 1.4514 | 1.4543 | 1.4443 | 1.4464 | 38474828.0 |
| 2005-06-01 11:00:00 | AAPL | Stock | 1.4468 | 1.4532 | 1.4454 | 1.4518 | 30652748.0 |
| 2005-06-01 11:30:00 | AAPL | Stock | 1.4518 | 1.4532 | 1.4479 | 1.45 | 23832788.0 |
| 2005-06-01 12:00:00 | AAPL | Stock | 1.4496 | 1.4514 | 1.4475 | 1.4511 | 15936284.0 |
| 2005-06-01 12:30:00 | AAPL | Stock | 1.4511 | 1.4532 | 1.45 | 1.4525 | 14617540.0 |
| 2005-06-01 13:00:00 | AAPL | Stock | 1.4525 | 1.4532 | 1.45 | 1.4514 | 16457560.0 |
| 2005-06-01 13:30:00 | AAPL | Stock | 1.4511 | 1.4525 | 1.4439 | 1.4457 | 21392868.0 |
| 2005-06-01 14:00:00 | AAPL | Stock | 1.4457 | 1.4468 | 1.4357 | 1.4379 | 28470064.0 |
| 2005-06-01 14:30:00 | AAPL | Stock | 1.4382 | 1.4414 | 1.4275 | 1.4314 | 46009572.0 |
| 2005-06-01 15:00:00 | AAPL | Stock | 1.4314 | 1.4339 | 1.4296 | 1.4325 | 24646720.0 |
| 2005-06-01 15:30:00 | AAPL | Stock | 1.4321 | 1.4421 | 1.4321 | 1.4389 | 39778564.0 |
| 2005-06-01 16:00:00 | AAPL | Stock | 1.4382 | 1.4382 | 1.4357 | 1.4368 | 762440.0 |
| 2005-06-01 16:30:00 | AAPL | Stock | 1.4368 | 1.4368 | 1.4361 | 1.4361 | 50680.0 |
| 2005-06-01 17:00:00 | AAPL | Stock | 1.4371 | 1.4396 | 1.4371 | 1.4393 | 431200.0 |
| 2005-06-01 17:30:00 | AAPL | Stock | 1.4393 | 1.443 | 1.4386 | 1.4393 | 847840.0 |
| 2005-06-01 18:00:00 | AAPL | Stock | 1.4393 | 1.4426 | 1.4393 | 1.4426 | 252840.0 |
| 2005-06-01 07:00:00 | MSFT | Stock | 25.81 | 25.81 | 25.81 | 25.81 | 500.0 |
| 2005-06-01 07:30:00 | MSFT | Stock | 25.83 | 25.85 | 25.83 | 25.85 | 2300.0 |
| 2005-06-01 08:00:00 | MSFT | Stock | 25.84 | 25.84 | 25.83 | 25.83 | 4200.0 |
| 2005-06-01 08:30:00 | MSFT | Stock | 25.81 | 25.81 | 25.79 | 25.79 | 15705.0 |
| 2005-06-01 09:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.68 | 25.69 | 178696.0 |
| 2005-06-01 09:30:00 | MSFT | Stock | 25.73 | 25.73 | 25.61 | 25.62 | 5038502.0 |
| 2005-06-01 10:00:00 | MSFT | Stock | 25.622 | 25.9 | 25.62 | 25.84 | 7796600.0 |
| 2005-06-01 10:30:00 | MSFT | Stock | 25.84 | 25.88 | 25.81 | 25.82 | 3134877.0 |
| 2005-06-01 11:00:00 | MSFT | Stock | 25.82 | 26.0 | 25.81 | 25.96 | 5723029.0 |
| 2005-06-01 11:30:00 | MSFT | Stock | 25.96 | 26.0 | 25.9 | 25.912 | 2228073.0 |
| 2005-06-01 12:00:00 | MSFT | Stock | 25.91 | 25.92 | 25.81 | 25.82 | 2680589.0 |
| 2005-06-01 12:30:00 | MSFT | Stock | 25.83 | 25.87 | 25.82 | 25.84 | 1418252.0 |
| 2005-06-01 13:00:00 | MSFT | Stock | 25.848 | 25.91 | 25.83 | 25.86 | 1709404.0 |
| 2005-06-01 13:30:00 | MSFT | Stock | 25.85 | 25.88 | 25.82 | 25.85 | 1861745.0 |
| 2005-06-01 14:00:00 | MSFT | Stock | 25.86 | 25.87 | 25.79 | 25.79 | 2630583.0 |
| 2005-06-01 14:30:00 | MSFT | Stock | 25.79 | 25.85 | 25.72 | 25.83 | 6444191.0 |
| 2005-06-01 15:00:00 | MSFT | Stock | 25.83 | 25.852 | 25.78 | 25.8 | 5343503.0 |
| 2005-06-01 15:30:00 | MSFT | Stock | 25.8 | 25.86 | 25.79 | 25.81 | 4755433.0 |
| 2005-06-01 16:00:00 | MSFT | Stock | 25.82 | 25.87 | 25.8 | 25.83 | 178498.0 |
| 2005-06-01 16:30:00 | MSFT | Stock | 25.83 | 25.84 | 25.83 | 25.84 | 312207.0 |
| 2005-06-01 17:00:00 | MSFT | Stock | 25.83 | 25.84 | 25.83 | 25.84 | 25797.0 |
| 2005-06-01 17:30:00 | MSFT | Stock | 25.84 | 25.84 | 25.81 | 25.81 | 296400.0 |
| 2005-06-01 18:00:00 | MSFT | Stock | 25.84 | 25.84 | 25.81 | 25.84 | 62560.0 |
| 2005-06-01 08:30:00 | NVDA | Stock | 0.2262 | 0.2262 | 0.2262 | 0.2262 | 132000.0 |
| 2005-06-01 09:00:00 | NVDA | Stock | 0.2262 | 0.2262 | 0.2242 | 0.2242 | 300000.0 |
| 2005-06-01 09:30:00 | NVDA | Stock | 0.2243 | 0.225 | 0.2217 | 0.2232 | 103653720.0 |
| 2005-06-01 10:00:00 | NVDA | Stock | 0.2232 | 0.2265 | 0.2232 | 0.2262 | 145742880.0 |
| 2005-06-01 10:30:00 | NVDA | Stock | 0.2263 | 0.2287 | 0.2262 | 0.2279 | 82760040.0 |
| 2005-06-01 11:00:00 | NVDA | Stock | 0.228 | 0.2306 | 0.228 | 0.2304 | 82032960.0 |
> showing 50 of 45,582 rows — these rows as CSV