PREVIEW / stock_1hour / 2001-12-28
file: by_date/stock_1hour/2001/2001-12-28.parquet size: 393 KB rows: 18,621 symbols: 1,369
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-28 09:00:00 | AAPL | Stock | 0.3946 | 0.4007 | 0.392 | 0.3995 | 43047200.0 |
| 2001-12-28 10:00:00 | AAPL | Stock | 0.3995 | 0.4107 | 0.3995 | 0.4061 | 96555200.0 |
| 2001-12-28 11:00:00 | AAPL | Stock | 0.4061 | 0.4071 | 0.3975 | 0.4006 | 25603200.0 |
| 2001-12-28 12:00:00 | AAPL | Stock | 0.4005 | 0.4046 | 0.3991 | 0.4018 | 38304000.0 |
| 2001-12-28 13:00:00 | AAPL | Stock | 0.4009 | 0.4016 | 0.3964 | 0.4011 | 23990400.0 |
| 2001-12-28 14:00:00 | AAPL | Stock | 0.4006 | 0.4007 | 0.3984 | 0.3984 | 28728000.0 |
| 2001-12-28 15:00:00 | AAPL | Stock | 0.3986 | 0.4107 | 0.3979 | 0.4004 | 28403200.0 |
| 2001-12-28 16:00:00 | AAPL | Stock | 0.4005 | 0.4013 | 0.3975 | 0.4009 | 2665600.0 |
| 2001-12-28 17:00:00 | AAPL | Stock | 0.3996 | 0.3996 | 0.3973 | 0.3973 | 84000.0 |
| 2001-12-28 08:00:00 | MSFT | Stock | 33.4 | 34.4 | 33.4 | 34.125 | 29000.0 |
| 2001-12-28 09:00:00 | MSFT | Stock | 34.195 | 34.285 | 33.925 | 34.16 | 3449000.0 |
| 2001-12-28 10:00:00 | MSFT | Stock | 34.135 | 34.425 | 34.13 | 34.335 | 5128600.0 |
| 2001-12-28 11:00:00 | MSFT | Stock | 34.34 | 34.4 | 34.1 | 34.21 | 3547800.0 |
| 2001-12-28 12:00:00 | MSFT | Stock | 34.2155 | 34.31 | 34.2 | 34.2955 | 4034000.0 |
| 2001-12-28 13:00:00 | MSFT | Stock | 34.295 | 34.305 | 34.2 | 34.2155 | 1918000.0 |
| 2001-12-28 14:00:00 | MSFT | Stock | 34.22 | 34.23 | 33.8595 | 33.955 | 3256800.0 |
| 2001-12-28 15:00:00 | MSFT | Stock | 33.965 | 34.095 | 33.8505 | 33.935 | 4316400.0 |
| 2001-12-28 16:00:00 | MSFT | Stock | 33.935 | 34.319 | 33.875 | 33.94 | 1633800.0 |
| 2001-12-28 17:00:00 | MSFT | Stock | 34.115 | 34.115 | 33.925 | 33.925 | 5000.0 |
| 2001-12-28 18:00:00 | MSFT | Stock | 33.915 | 33.915 | 33.915 | 33.915 | 200.0 |
| 2001-12-28 08:00:00 | NVDA | Stock | 0.5792 | 0.5833 | 0.5783 | 0.5833 | 1212000.0 |
| 2001-12-28 09:00:00 | NVDA | Stock | 0.5836 | 0.585 | 0.5782 | 0.5813 | 109812000.0 |
| 2001-12-28 10:00:00 | NVDA | Stock | 0.5813 | 0.5854 | 0.5692 | 0.5701 | 176040000.0 |
| 2001-12-28 11:00:00 | NVDA | Stock | 0.57 | 0.571 | 0.5627 | 0.5641 | 132660000.0 |
| 2001-12-28 12:00:00 | NVDA | Stock | 0.5645 | 0.5657 | 0.5587 | 0.5604 | 88176000.0 |
| 2001-12-28 13:00:00 | NVDA | Stock | 0.5613 | 0.5658 | 0.559 | 0.5641 | 66984000.0 |
| 2001-12-28 14:00:00 | NVDA | Stock | 0.5642 | 0.5691 | 0.563 | 0.5676 | 83844000.0 |
| 2001-12-28 15:00:00 | NVDA | Stock | 0.5675 | 0.5707 | 0.5635 | 0.5642 | 76176000.0 |
| 2001-12-28 16:00:00 | NVDA | Stock | 0.5645 | 0.5693 | 0.564 | 0.5662 | 7608000.0 |
| 2001-12-28 17:00:00 | NVDA | Stock | 0.5662 | 0.5667 | 0.5662 | 0.5667 | 60000.0 |
| 2001-12-28 18:00:00 | NVDA | Stock | 0.5652 | 0.5652 | 0.5652 | 0.5652 | 48000.0 |
| 2001-12-28 08:00:00 | AMZN | Stock | 0.5335 | 0.555 | 0.5335 | 0.55 | 4126000.0 |
| 2001-12-28 09:00:00 | AMZN | Stock | 0.55 | 0.554 | 0.535 | 0.5415 | 31922000.0 |
| 2001-12-28 10:00:00 | AMZN | Stock | 0.5415 | 0.5485 | 0.54 | 0.5425 | 28436000.0 |
| 2001-12-28 11:00:00 | AMZN | Stock | 0.5425 | 0.5435 | 0.54 | 0.5405 | 11330000.0 |
| 2001-12-28 12:00:00 | AMZN | Stock | 0.541 | 0.5435 | 0.5405 | 0.5416 | 7448000.0 |
| 2001-12-28 13:00:00 | AMZN | Stock | 0.5415 | 0.543 | 0.536 | 0.542 | 13198000.0 |
| 2001-12-28 14:00:00 | AMZN | Stock | 0.542 | 0.5425 | 0.5375 | 0.54 | 28458000.0 |
| 2001-12-28 15:00:00 | AMZN | Stock | 0.5405 | 0.547 | 0.538 | 0.542 | 35652000.0 |
| 2001-12-28 16:00:00 | AMZN | Stock | 0.542 | 0.547 | 0.539 | 0.542 | 4190000.0 |
| 2001-12-28 17:00:00 | AMZN | Stock | 0.541 | 0.5425 | 0.541 | 0.541 | 90000.0 |
| 2001-12-28 18:00:00 | AMZN | Stock | 0.5425 | 0.5435 | 0.541 | 0.5435 | 90000.0 |
| 2001-12-28 09:00:00 | CL | Stock | 29.08 | 29.12 | 29.045 | 29.045 | 151600.0 |
| 2001-12-28 10:00:00 | CL | Stock | 29.04 | 29.15 | 28.905 | 28.95 | 308200.0 |
| 2001-12-28 11:00:00 | CL | Stock | 28.95 | 28.965 | 28.76 | 28.785 | 329800.0 |
| 2001-12-28 12:00:00 | CL | Stock | 28.79 | 28.88 | 28.76 | 28.855 | 206600.0 |
| 2001-12-28 13:00:00 | CL | Stock | 28.85 | 28.925 | 28.85 | 28.875 | 180800.0 |
| 2001-12-28 14:00:00 | CL | Stock | 28.89 | 29.02 | 28.875 | 28.95 | 424400.0 |
| 2001-12-28 15:00:00 | CL | Stock | 28.95 | 29.115 | 28.935 | 29.07 | 841400.0 |
| 2001-12-28 16:00:00 | CL | Stock | 29.07 | 29.07 | 29.07 | 29.07 | 67400.0 |
> showing 50 of 18,621 rows — these rows as CSV