PREVIEW / stock_1hour / 2001-05-16
file: by_date/stock_1hour/2001/2001-05-16.parquet size: 365 KB rows: 17,316 symbols: 1,294
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-16 08:00:00 | AAPL | Stock | 0.4134 | 0.4143 | 0.4107 | 0.4134 | 498400.0 |
| 2001-05-16 09:00:00 | AAPL | Stock | 0.4125 | 0.4177 | 0.408 | 0.4143 | 40493600.0 |
| 2001-05-16 10:00:00 | AAPL | Stock | 0.4143 | 0.4234 | 0.4125 | 0.4186 | 37049600.0 |
| 2001-05-16 11:00:00 | AAPL | Stock | 0.4193 | 0.4266 | 0.417 | 0.4241 | 32552800.0 |
| 2001-05-16 12:00:00 | AAPL | Stock | 0.4241 | 0.4286 | 0.423 | 0.4284 | 16839200.0 |
| 2001-05-16 13:00:00 | AAPL | Stock | 0.4284 | 0.4334 | 0.4254 | 0.4286 | 41154400.0 |
| 2001-05-16 14:00:00 | AAPL | Stock | 0.4286 | 0.433 | 0.4282 | 0.4327 | 46872000.0 |
| 2001-05-16 15:00:00 | AAPL | Stock | 0.4329 | 0.4375 | 0.4293 | 0.4305 | 80707200.0 |
| 2001-05-16 16:00:00 | AAPL | Stock | 0.4305 | 0.4357 | 0.4261 | 0.4304 | 14638400.0 |
| 2001-05-16 17:00:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.425 | 0.425 | 112000.0 |
| 2001-05-16 08:00:00 | MSFT | Stock | 33.75 | 34.14 | 33.625 | 33.9 | 333000.0 |
| 2001-05-16 09:00:00 | MSFT | Stock | 33.85 | 34.05 | 33.25 | 33.955 | 9252400.0 |
| 2001-05-16 10:00:00 | MSFT | Stock | 33.955 | 34.8 | 33.9 | 34.7 | 16846400.0 |
| 2001-05-16 11:00:00 | MSFT | Stock | 34.705 | 34.865 | 34.6 | 34.68 | 9998800.0 |
| 2001-05-16 12:00:00 | MSFT | Stock | 34.68 | 34.77 | 34.545 | 34.555 | 6737200.0 |
| 2001-05-16 13:00:00 | MSFT | Stock | 34.555 | 34.785 | 34.5 | 34.725 | 9900600.0 |
| 2001-05-16 14:00:00 | MSFT | Stock | 34.725 | 34.92 | 34.67 | 34.905 | 13207600.0 |
| 2001-05-16 15:00:00 | MSFT | Stock | 34.895 | 34.94 | 34.515 | 34.575 | 16760200.0 |
| 2001-05-16 16:00:00 | MSFT | Stock | 34.56 | 34.715 | 33.85 | 34.58 | 2845000.0 |
| 2001-05-16 17:00:00 | MSFT | Stock | 34.55 | 34.625 | 34.39 | 34.6 | 87200.0 |
| 2001-05-16 18:00:00 | MSFT | Stock | 34.655 | 34.655 | 34.655 | 34.655 | 200.0 |
| 2001-05-16 08:00:00 | NVDA | Stock | 0.3348 | 0.3354 | 0.3308 | 0.3354 | 1608000.0 |
| 2001-05-16 09:00:00 | NVDA | Stock | 0.3354 | 0.3429 | 0.3314 | 0.3348 | 149592000.0 |
| 2001-05-16 10:00:00 | NVDA | Stock | 0.3348 | 0.3469 | 0.3303 | 0.3421 | 250512000.0 |
| 2001-05-16 11:00:00 | NVDA | Stock | 0.3417 | 0.3438 | 0.3375 | 0.3415 | 83592000.0 |
| 2001-05-16 12:00:00 | NVDA | Stock | 0.3415 | 0.3445 | 0.3388 | 0.3437 | 59376000.0 |
| 2001-05-16 13:00:00 | NVDA | Stock | 0.343 | 0.35 | 0.3427 | 0.3497 | 84504000.0 |
| 2001-05-16 14:00:00 | NVDA | Stock | 0.3495 | 0.354 | 0.3483 | 0.3527 | 121296000.0 |
| 2001-05-16 15:00:00 | NVDA | Stock | 0.3525 | 0.3583 | 0.3505 | 0.3562 | 153984000.0 |
| 2001-05-16 16:00:00 | NVDA | Stock | 0.3579 | 0.3604 | 0.3385 | 0.3562 | 14832000.0 |
| 2001-05-16 17:00:00 | NVDA | Stock | 0.3563 | 0.3563 | 0.3562 | 0.3562 | 792000.0 |
| 2001-05-16 18:00:00 | NVDA | Stock | 0.3577 | 0.3577 | 0.3577 | 0.3577 | 48000.0 |
| 2001-05-16 08:00:00 | AMZN | Stock | 0.66 | 0.665 | 0.65 | 0.66 | 296000.0 |
| 2001-05-16 09:00:00 | AMZN | Stock | 0.662 | 0.685 | 0.655 | 0.667 | 11218000.0 |
| 2001-05-16 10:00:00 | AMZN | Stock | 0.6685 | 0.695 | 0.659 | 0.687 | 15212000.0 |
| 2001-05-16 11:00:00 | AMZN | Stock | 0.687 | 0.6965 | 0.6805 | 0.6925 | 8546000.0 |
| 2001-05-16 12:00:00 | AMZN | Stock | 0.6925 | 0.6925 | 0.676 | 0.6855 | 6330000.0 |
| 2001-05-16 13:00:00 | AMZN | Stock | 0.6865 | 0.71 | 0.682 | 0.71 | 13420000.0 |
| 2001-05-16 14:00:00 | AMZN | Stock | 0.7095 | 0.715 | 0.698 | 0.7125 | 24092000.0 |
| 2001-05-16 15:00:00 | AMZN | Stock | 0.7125 | 0.719 | 0.705 | 0.705 | 29408000.0 |
| 2001-05-16 16:00:00 | AMZN | Stock | 0.7065 | 0.7085 | 0.7005 | 0.7065 | 32896000.0 |
| 2001-05-16 17:00:00 | AMZN | Stock | 0.7065 | 0.7065 | 0.7065 | 0.7065 | 18000.0 |
| 2001-05-16 18:00:00 | AMZN | Stock | 0.7195 | 0.7195 | 0.7175 | 0.7175 | 34000.0 |
| 2001-05-16 09:00:00 | CL | Stock | 28.45 | 28.55 | 28.175 | 28.175 | 793200.0 |
| 2001-05-16 10:00:00 | CL | Stock | 28.175 | 28.75 | 28.175 | 28.73 | 613000.0 |
| 2001-05-16 11:00:00 | CL | Stock | 28.72 | 28.865 | 28.665 | 28.775 | 700000.0 |
| 2001-05-16 12:00:00 | CL | Stock | 28.775 | 28.87 | 28.75 | 28.785 | 326800.0 |
| 2001-05-16 13:00:00 | CL | Stock | 28.795 | 28.95 | 28.75 | 28.9 | 435400.0 |
| 2001-05-16 14:00:00 | CL | Stock | 28.9 | 29.05 | 28.875 | 29.045 | 380200.0 |
| 2001-05-16 15:00:00 | CL | Stock | 29.05 | 29.295 | 28.965 | 29.245 | 750000.0 |
> showing 50 of 17,316 rows — these rows as CSV