PREVIEW / stock_1hour / 2002-02-27
file: by_date/stock_1hour/2002/2002-02-27.parquet size: 379 KB rows: 17,869 symbols: 1,389
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-27 09:00:00 | AAPL | Stock | 0.4259 | 0.433 | 0.4259 | 0.4296 | 34624800.0 |
| 2002-02-27 10:00:00 | AAPL | Stock | 0.4295 | 0.4302 | 0.4161 | 0.4163 | 57775200.0 |
| 2002-02-27 11:00:00 | AAPL | Stock | 0.4161 | 0.4189 | 0.4002 | 0.4013 | 179508000.0 |
| 2002-02-27 12:00:00 | AAPL | Stock | 0.4009 | 0.4018 | 0.3923 | 0.3955 | 171992800.0 |
| 2002-02-27 13:00:00 | AAPL | Stock | 0.3957 | 0.3996 | 0.3925 | 0.3925 | 96482400.0 |
| 2002-02-27 14:00:00 | AAPL | Stock | 0.3927 | 0.3954 | 0.3825 | 0.3834 | 151244800.0 |
| 2002-02-27 15:00:00 | AAPL | Stock | 0.3834 | 0.3946 | 0.3739 | 0.3925 | 248836000.0 |
| 2002-02-27 16:00:00 | AAPL | Stock | 0.3925 | 0.4041 | 0.3914 | 0.3914 | 23363200.0 |
| 2002-02-27 17:00:00 | AAPL | Stock | 0.3914 | 0.3937 | 0.3914 | 0.3929 | 2884000.0 |
| 2002-02-27 18:00:00 | AAPL | Stock | 0.3913 | 0.3913 | 0.3902 | 0.3902 | 106400.0 |
| 2002-02-27 08:00:00 | MSFT | Stock | 29.325 | 29.5 | 29.325 | 29.495 | 31800.0 |
| 2002-02-27 09:00:00 | MSFT | Stock | 29.5 | 29.73 | 29.405 | 29.665 | 5190800.0 |
| 2002-02-27 10:00:00 | MSFT | Stock | 29.66 | 29.985 | 29.405 | 29.89 | 11699200.0 |
| 2002-02-27 11:00:00 | MSFT | Stock | 29.885 | 30.0 | 29.8 | 29.85 | 7900600.0 |
| 2002-02-27 12:00:00 | MSFT | Stock | 29.85 | 30.0 | 29.7 | 29.94 | 5941200.0 |
| 2002-02-27 13:00:00 | MSFT | Stock | 29.94 | 30.075 | 29.455 | 29.54 | 9325400.0 |
| 2002-02-27 14:00:00 | MSFT | Stock | 29.54 | 29.665 | 29.055 | 29.18 | 10886000.0 |
| 2002-02-27 15:00:00 | MSFT | Stock | 29.185 | 29.345 | 28.9995 | 29.195 | 10341600.0 |
| 2002-02-27 16:00:00 | MSFT | Stock | 29.24 | 29.975 | 29.19 | 29.25 | 2069800.0 |
| 2002-02-27 17:00:00 | MSFT | Stock | 29.195 | 29.375 | 29.195 | 29.235 | 96800.0 |
| 2002-02-27 18:00:00 | MSFT | Stock | 29.25 | 29.3 | 29.202 | 29.202 | 5800.0 |
| 2002-02-27 08:00:00 | NVDA | Stock | 0.4629 | 0.4657 | 0.4618 | 0.465 | 732000.0 |
| 2002-02-27 09:00:00 | NVDA | Stock | 0.4633 | 0.4707 | 0.4517 | 0.4559 | 187176000.0 |
| 2002-02-27 10:00:00 | NVDA | Stock | 0.4559 | 0.4626 | 0.4534 | 0.4616 | 252120000.0 |
| 2002-02-27 11:00:00 | NVDA | Stock | 0.4616 | 0.4637 | 0.4588 | 0.46 | 169272000.0 |
| 2002-02-27 12:00:00 | NVDA | Stock | 0.4603 | 0.4607 | 0.455 | 0.4575 | 162792000.0 |
| 2002-02-27 13:00:00 | NVDA | Stock | 0.4575 | 0.46 | 0.445 | 0.4492 | 276240000.0 |
| 2002-02-27 14:00:00 | NVDA | Stock | 0.4496 | 0.4537 | 0.4454 | 0.449 | 295140000.0 |
| 2002-02-27 15:00:00 | NVDA | Stock | 0.4492 | 0.4513 | 0.4417 | 0.4426 | 302004000.0 |
| 2002-02-27 16:00:00 | NVDA | Stock | 0.4426 | 0.4536 | 0.4417 | 0.4437 | 24240000.0 |
| 2002-02-27 17:00:00 | NVDA | Stock | 0.4426 | 0.4433 | 0.4426 | 0.4429 | 1068000.0 |
| 2002-02-27 18:00:00 | NVDA | Stock | 0.4428 | 0.4429 | 0.4417 | 0.4417 | 588000.0 |
| 2002-02-27 08:00:00 | AMZN | Stock | 0.723 | 0.725 | 0.7225 | 0.725 | 146000.0 |
| 2002-02-27 09:00:00 | AMZN | Stock | 0.7275 | 0.733 | 0.709 | 0.724 | 27692000.0 |
| 2002-02-27 10:00:00 | AMZN | Stock | 0.724 | 0.725 | 0.712 | 0.7225 | 26474000.0 |
| 2002-02-27 11:00:00 | AMZN | Stock | 0.7225 | 0.7365 | 0.72 | 0.7265 | 18462000.0 |
| 2002-02-27 12:00:00 | AMZN | Stock | 0.7265 | 0.7325 | 0.7215 | 0.725 | 13516000.0 |
| 2002-02-27 13:00:00 | AMZN | Stock | 0.725 | 0.7275 | 0.715 | 0.7214 | 19012000.0 |
| 2002-02-27 14:00:00 | AMZN | Stock | 0.7185 | 0.725 | 0.7125 | 0.7145 | 23916000.0 |
| 2002-02-27 15:00:00 | AMZN | Stock | 0.7145 | 0.718 | 0.706 | 0.715 | 31034000.0 |
| 2002-02-27 16:00:00 | AMZN | Stock | 0.7125 | 0.7175 | 0.7075 | 0.7075 | 3788000.0 |
| 2002-02-27 17:00:00 | AMZN | Stock | 0.7075 | 0.7135 | 0.705 | 0.71 | 394000.0 |
| 2002-02-27 09:00:00 | CL | Stock | 28.4 | 28.425 | 28.25 | 28.355 | 246200.0 |
| 2002-02-27 10:00:00 | CL | Stock | 28.35 | 28.35 | 28.19 | 28.2 | 427400.0 |
| 2002-02-27 11:00:00 | CL | Stock | 28.2 | 28.205 | 28.09 | 28.11 | 507800.0 |
| 2002-02-27 12:00:00 | CL | Stock | 28.11 | 28.215 | 28.095 | 28.18 | 277400.0 |
| 2002-02-27 13:00:00 | CL | Stock | 28.18 | 28.225 | 28.04 | 28.135 | 526200.0 |
| 2002-02-27 14:00:00 | CL | Stock | 28.135 | 28.19 | 28.025 | 28.035 | 431600.0 |
| 2002-02-27 15:00:00 | CL | Stock | 28.03 | 28.24 | 28.025 | 28.19 | 522200.0 |
| 2002-02-27 16:00:00 | CL | Stock | 28.19 | 28.2 | 28.19 | 28.2 | 44600.0 |
> showing 50 of 17,869 rows — these rows as CSV