PREVIEW / stock_1hour / 2002-02-19
file: by_date/stock_1hour/2002/2002-02-19.parquet size: 390 KB rows: 18,768 symbols: 1,405
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-02-19 08:00:00 | AAPL | Stock | 0.4263 | 0.4286 | 0.4232 | 0.4232 | 364000.0 |
| 2002-02-19 09:00:00 | AAPL | Stock | 0.4241 | 0.4268 | 0.4221 | 0.4232 | 37374400.0 |
| 2002-02-19 10:00:00 | AAPL | Stock | 0.4232 | 0.4241 | 0.4161 | 0.4184 | 55613600.0 |
| 2002-02-19 11:00:00 | AAPL | Stock | 0.4188 | 0.4241 | 0.4175 | 0.4236 | 35526400.0 |
| 2002-02-19 12:00:00 | AAPL | Stock | 0.4236 | 0.4252 | 0.4163 | 0.4163 | 36976800.0 |
| 2002-02-19 13:00:00 | AAPL | Stock | 0.4164 | 0.4193 | 0.4143 | 0.415 | 48417600.0 |
| 2002-02-19 14:00:00 | AAPL | Stock | 0.4154 | 0.4154 | 0.4038 | 0.4088 | 66673600.0 |
| 2002-02-19 15:00:00 | AAPL | Stock | 0.4088 | 0.4096 | 0.4014 | 0.4039 | 83949600.0 |
| 2002-02-19 16:00:00 | AAPL | Stock | 0.4036 | 0.4143 | 0.4018 | 0.4039 | 19202400.0 |
| 2002-02-19 17:00:00 | AAPL | Stock | 0.4046 | 0.4088 | 0.4039 | 0.4039 | 218400.0 |
| 2002-02-19 08:00:00 | MSFT | Stock | 30.115 | 30.275 | 29.75 | 30.0 | 158600.0 |
| 2002-02-19 09:00:00 | MSFT | Stock | 30.0 | 30.175 | 29.82 | 29.925 | 8138400.0 |
| 2002-02-19 10:00:00 | MSFT | Stock | 29.925 | 30.025 | 29.7855 | 29.835 | 8003000.0 |
| 2002-02-19 11:00:00 | MSFT | Stock | 29.84 | 29.85 | 29.675 | 29.765 | 5991000.0 |
| 2002-02-19 12:00:00 | MSFT | Stock | 29.765 | 29.805 | 29.525 | 29.54 | 5520800.0 |
| 2002-02-19 13:00:00 | MSFT | Stock | 29.5595 | 29.675 | 29.505 | 29.615 | 5215600.0 |
| 2002-02-19 14:00:00 | MSFT | Stock | 29.62 | 29.72 | 29.56 | 29.69 | 5134000.0 |
| 2002-02-19 15:00:00 | MSFT | Stock | 29.69 | 29.705 | 29.3045 | 29.465 | 9540600.0 |
| 2002-02-19 16:00:00 | MSFT | Stock | 29.475 | 29.6095 | 29.375 | 29.58 | 2882400.0 |
| 2002-02-19 17:00:00 | MSFT | Stock | 29.575 | 29.625 | 29.465 | 29.6 | 178400.0 |
| 2002-02-19 18:00:00 | MSFT | Stock | 29.555 | 29.555 | 29.55 | 29.55 | 2600.0 |
| 2002-02-19 08:00:00 | NVDA | Stock | 0.4667 | 0.4776 | 0.4615 | 0.467 | 8052000.0 |
| 2002-02-19 09:00:00 | NVDA | Stock | 0.4675 | 0.4776 | 0.4442 | 0.4577 | 500352000.0 |
| 2002-02-19 10:00:00 | NVDA | Stock | 0.4577 | 0.4583 | 0.4526 | 0.4575 | 350856000.0 |
| 2002-02-19 11:00:00 | NVDA | Stock | 0.4577 | 0.4622 | 0.4557 | 0.4602 | 245904000.0 |
| 2002-02-19 12:00:00 | NVDA | Stock | 0.4602 | 0.4617 | 0.4564 | 0.4568 | 114564000.0 |
| 2002-02-19 13:00:00 | NVDA | Stock | 0.4572 | 0.4598 | 0.4552 | 0.4558 | 133968000.0 |
| 2002-02-19 14:00:00 | NVDA | Stock | 0.4558 | 0.4562 | 0.4469 | 0.4509 | 242196000.0 |
| 2002-02-19 15:00:00 | NVDA | Stock | 0.4508 | 0.4517 | 0.4426 | 0.4467 | 282744000.0 |
| 2002-02-19 16:00:00 | NVDA | Stock | 0.4467 | 0.4565 | 0.4446 | 0.4462 | 27876000.0 |
| 2002-02-19 17:00:00 | NVDA | Stock | 0.4462 | 0.4499 | 0.4447 | 0.4467 | 1248000.0 |
| 2002-02-19 18:00:00 | NVDA | Stock | 0.446 | 0.4494 | 0.446 | 0.4494 | 372000.0 |
| 2002-02-19 08:00:00 | AMZN | Stock | 0.655 | 0.655 | 0.6425 | 0.645 | 280000.0 |
| 2002-02-19 09:00:00 | AMZN | Stock | 0.649 | 0.663 | 0.6455 | 0.655 | 22714000.0 |
| 2002-02-19 10:00:00 | AMZN | Stock | 0.655 | 0.692 | 0.6545 | 0.6724 | 33608000.0 |
| 2002-02-19 11:00:00 | AMZN | Stock | 0.6724 | 0.6725 | 0.6625 | 0.6705 | 18040000.0 |
| 2002-02-19 12:00:00 | AMZN | Stock | 0.67 | 0.6725 | 0.659 | 0.6625 | 14176000.0 |
| 2002-02-19 13:00:00 | AMZN | Stock | 0.6605 | 0.662 | 0.6525 | 0.6585 | 27100000.0 |
| 2002-02-19 14:00:00 | AMZN | Stock | 0.6585 | 0.66 | 0.65 | 0.6575 | 11896000.0 |
| 2002-02-19 15:00:00 | AMZN | Stock | 0.6575 | 0.6575 | 0.64 | 0.6505 | 28950000.0 |
| 2002-02-19 16:00:00 | AMZN | Stock | 0.6495 | 0.655 | 0.6475 | 0.651 | 4404000.0 |
| 2002-02-19 17:00:00 | AMZN | Stock | 0.6505 | 0.6505 | 0.6445 | 0.6445 | 144000.0 |
| 2002-02-19 18:00:00 | AMZN | Stock | 0.648 | 0.648 | 0.648 | 0.648 | 30000.0 |
| 2002-02-19 09:00:00 | CL | Stock | 28.1 | 28.1 | 27.8 | 27.8 | 458000.0 |
| 2002-02-19 10:00:00 | CL | Stock | 27.815 | 27.85 | 27.735 | 27.75 | 270000.0 |
| 2002-02-19 11:00:00 | CL | Stock | 27.75 | 27.895 | 27.625 | 27.885 | 304000.0 |
| 2002-02-19 12:00:00 | CL | Stock | 27.885 | 27.905 | 27.72 | 27.78 | 233600.0 |
| 2002-02-19 13:00:00 | CL | Stock | 27.785 | 27.9 | 27.785 | 27.825 | 308600.0 |
| 2002-02-19 14:00:00 | CL | Stock | 27.83 | 27.92 | 27.825 | 27.885 | 326800.0 |
| 2002-02-19 15:00:00 | CL | Stock | 27.89 | 27.925 | 27.765 | 27.785 | 507800.0 |
> showing 50 of 18,768 rows — these rows as CSV