PREVIEW / stock_1hour / 2001-12-13
file: by_date/stock_1hour/2001/2001-12-13.parquet size: 378 KB rows: 17,969 symbols: 1,363
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-12-13 08:00:00 | AAPL | Stock | 0.3837 | 0.3837 | 0.3809 | 0.3809 | 61600.0 |
| 2001-12-13 09:00:00 | AAPL | Stock | 0.3832 | 0.3848 | 0.3766 | 0.3786 | 27367200.0 |
| 2001-12-13 10:00:00 | AAPL | Stock | 0.3786 | 0.3795 | 0.37 | 0.3795 | 37968000.0 |
| 2001-12-13 11:00:00 | AAPL | Stock | 0.3795 | 0.3804 | 0.3725 | 0.375 | 15360800.0 |
| 2001-12-13 12:00:00 | AAPL | Stock | 0.3755 | 0.38 | 0.372 | 0.3723 | 13669600.0 |
| 2001-12-13 13:00:00 | AAPL | Stock | 0.3721 | 0.3764 | 0.3716 | 0.3732 | 11032000.0 |
| 2001-12-13 14:00:00 | AAPL | Stock | 0.3732 | 0.3736 | 0.3677 | 0.3686 | 21968800.0 |
| 2001-12-13 15:00:00 | AAPL | Stock | 0.3684 | 0.3761 | 0.3661 | 0.3748 | 38432800.0 |
| 2001-12-13 16:00:00 | AAPL | Stock | 0.3748 | 0.3761 | 0.3688 | 0.3749 | 24572800.0 |
| 2001-12-13 17:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 229600.0 |
| 2001-12-13 08:00:00 | MSFT | Stock | 33.81 | 33.975 | 33.5 | 33.575 | 107200.0 |
| 2001-12-13 09:00:00 | MSFT | Stock | 33.575 | 34.09 | 33.5 | 33.91 | 7816200.0 |
| 2001-12-13 10:00:00 | MSFT | Stock | 33.91 | 34.04 | 33.59 | 33.805 | 7644400.0 |
| 2001-12-13 11:00:00 | MSFT | Stock | 33.75 | 33.925 | 33.67 | 33.84 | 6655200.0 |
| 2001-12-13 12:00:00 | MSFT | Stock | 33.845 | 33.9 | 33.485 | 33.55 | 4583200.0 |
| 2001-12-13 13:00:00 | MSFT | Stock | 33.555 | 33.715 | 33.425 | 33.525 | 4697600.0 |
| 2001-12-13 14:00:00 | MSFT | Stock | 33.53 | 33.62 | 33.16 | 33.25 | 6748200.0 |
| 2001-12-13 15:00:00 | MSFT | Stock | 33.25 | 33.37 | 33.0395 | 33.14 | 9521800.0 |
| 2001-12-13 16:00:00 | MSFT | Stock | 33.135 | 33.6148 | 32.935 | 33.05 | 4605000.0 |
| 2001-12-13 17:00:00 | MSFT | Stock | 33.4867 | 33.4867 | 32.945 | 33.025 | 120600.0 |
| 2001-12-13 18:00:00 | MSFT | Stock | 33.025 | 33.05 | 33.005 | 33.05 | 8200.0 |
| 2001-12-13 08:00:00 | NVDA | Stock | 0.5391 | 0.5391 | 0.525 | 0.5283 | 10296000.0 |
| 2001-12-13 09:00:00 | NVDA | Stock | 0.5267 | 0.5359 | 0.5248 | 0.5275 | 119076000.0 |
| 2001-12-13 10:00:00 | NVDA | Stock | 0.5278 | 0.5308 | 0.5217 | 0.5305 | 197592000.0 |
| 2001-12-13 11:00:00 | NVDA | Stock | 0.5308 | 0.5333 | 0.5275 | 0.5307 | 75456000.0 |
| 2001-12-13 12:00:00 | NVDA | Stock | 0.5305 | 0.5317 | 0.5283 | 0.5288 | 52920000.0 |
| 2001-12-13 13:00:00 | NVDA | Stock | 0.5287 | 0.5327 | 0.5278 | 0.5287 | 64884000.0 |
| 2001-12-13 14:00:00 | NVDA | Stock | 0.5288 | 0.5311 | 0.5221 | 0.5237 | 123348000.0 |
| 2001-12-13 15:00:00 | NVDA | Stock | 0.524 | 0.5267 | 0.5214 | 0.5242 | 146256000.0 |
| 2001-12-13 16:00:00 | NVDA | Stock | 0.5242 | 0.5272 | 0.5217 | 0.5234 | 80484000.0 |
| 2001-12-13 17:00:00 | NVDA | Stock | 0.5262 | 0.5262 | 0.5225 | 0.5233 | 312000.0 |
| 2001-12-13 18:00:00 | NVDA | Stock | 0.5233 | 0.5233 | 0.5233 | 0.5233 | 36000.0 |
| 2001-12-13 08:00:00 | AMZN | Stock | 0.5965 | 0.5965 | 0.585 | 0.5875 | 344000.0 |
| 2001-12-13 09:00:00 | AMZN | Stock | 0.585 | 0.587 | 0.575 | 0.5825 | 16376000.0 |
| 2001-12-13 10:00:00 | AMZN | Stock | 0.5825 | 0.59 | 0.5745 | 0.5765 | 21724000.0 |
| 2001-12-13 11:00:00 | AMZN | Stock | 0.5765 | 0.5775 | 0.5616 | 0.568 | 21558000.0 |
| 2001-12-13 12:00:00 | AMZN | Stock | 0.568 | 0.5695 | 0.5575 | 0.5575 | 15198000.0 |
| 2001-12-13 13:00:00 | AMZN | Stock | 0.557 | 0.571 | 0.5524 | 0.56 | 20144000.0 |
| 2001-12-13 14:00:00 | AMZN | Stock | 0.56 | 0.56 | 0.5465 | 0.553 | 24844000.0 |
| 2001-12-13 15:00:00 | AMZN | Stock | 0.5555 | 0.5605 | 0.5425 | 0.5425 | 29622000.0 |
| 2001-12-13 16:00:00 | AMZN | Stock | 0.5445 | 0.5634 | 0.54 | 0.545 | 4050000.0 |
| 2001-12-13 17:00:00 | AMZN | Stock | 0.5435 | 0.545 | 0.543 | 0.545 | 470000.0 |
| 2001-12-13 18:00:00 | AMZN | Stock | 0.543 | 0.549 | 0.543 | 0.545 | 34000.0 |
| 2001-12-13 09:00:00 | CL | Stock | 28.55 | 28.565 | 28.42 | 28.45 | 252800.0 |
| 2001-12-13 10:00:00 | CL | Stock | 28.45 | 28.745 | 28.45 | 28.68 | 443600.0 |
| 2001-12-13 11:00:00 | CL | Stock | 28.68 | 28.74 | 28.55 | 28.55 | 175200.0 |
| 2001-12-13 12:00:00 | CL | Stock | 28.555 | 28.61 | 28.51 | 28.51 | 127000.0 |
| 2001-12-13 13:00:00 | CL | Stock | 28.525 | 28.575 | 28.46 | 28.46 | 302600.0 |
| 2001-12-13 14:00:00 | CL | Stock | 28.49 | 28.575 | 28.45 | 28.495 | 287000.0 |
| 2001-12-13 15:00:00 | CL | Stock | 28.505 | 28.565 | 28.45 | 28.475 | 522000.0 |
> showing 50 of 17,969 rows — these rows as CSV