PREVIEW / stock_1hour / 2001-03-30
file: by_date/stock_1hour/2001/2001-03-30.parquet size: 372 KB rows: 17,481 symbols: 1,292
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-03-30 08:00:00 | AAPL | Stock | 0.4021 | 0.4034 | 0.4018 | 0.402 | 543200.0 |
| 2001-03-30 09:00:00 | AAPL | Stock | 0.4036 | 0.4063 | 0.3857 | 0.3884 | 56112000.0 |
| 2001-03-30 10:00:00 | AAPL | Stock | 0.3884 | 0.3934 | 0.3843 | 0.385 | 68157600.0 |
| 2001-03-30 11:00:00 | AAPL | Stock | 0.385 | 0.3886 | 0.3811 | 0.3863 | 46088000.0 |
| 2001-03-30 12:00:00 | AAPL | Stock | 0.3866 | 0.3918 | 0.3859 | 0.387 | 12532800.0 |
| 2001-03-30 13:00:00 | AAPL | Stock | 0.3871 | 0.3964 | 0.3839 | 0.3963 | 49890400.0 |
| 2001-03-30 14:00:00 | AAPL | Stock | 0.3964 | 0.4057 | 0.3946 | 0.4027 | 63212800.0 |
| 2001-03-30 15:00:00 | AAPL | Stock | 0.4027 | 0.4029 | 0.3936 | 0.3938 | 48294400.0 |
| 2001-03-30 16:00:00 | AAPL | Stock | 0.3943 | 0.3948 | 0.393 | 0.3941 | 21554400.0 |
| 2001-03-30 17:00:00 | AAPL | Stock | 0.3941 | 0.4018 | 0.392 | 0.4009 | 795200.0 |
| 2001-03-30 18:00:00 | AAPL | Stock | 0.3991 | 0.4009 | 0.3941 | 0.3941 | 235200.0 |
| 2001-03-30 08:00:00 | MSFT | Stock | 27.8125 | 27.9688 | 27.7188 | 27.8125 | 148200.0 |
| 2001-03-30 09:00:00 | MSFT | Stock | 27.8438 | 28.0938 | 27.5 | 27.75 | 13577600.0 |
| 2001-03-30 10:00:00 | MSFT | Stock | 27.75 | 27.9062 | 27.125 | 27.2188 | 13464800.0 |
| 2001-03-30 11:00:00 | MSFT | Stock | 27.1875 | 27.5312 | 27.0312 | 27.5 | 7816000.0 |
| 2001-03-30 12:00:00 | MSFT | Stock | 27.5 | 27.6875 | 27.2812 | 27.4688 | 5317600.0 |
| 2001-03-30 13:00:00 | MSFT | Stock | 27.4688 | 27.625 | 27.2188 | 27.5625 | 7336400.0 |
| 2001-03-30 14:00:00 | MSFT | Stock | 27.625 | 28.0312 | 27.5312 | 27.75 | 12880800.0 |
| 2001-03-30 15:00:00 | MSFT | Stock | 27.75 | 27.875 | 26.9375 | 27.3438 | 22498000.0 |
| 2001-03-30 16:00:00 | MSFT | Stock | 27.3438 | 27.5 | 27.1875 | 27.3438 | 5349400.0 |
| 2001-03-30 17:00:00 | MSFT | Stock | 27.3438 | 27.5 | 27.1875 | 27.375 | 160000.0 |
| 2001-03-30 18:00:00 | MSFT | Stock | 27.375 | 27.4688 | 27.3438 | 27.3438 | 142400.0 |
| 2001-03-30 08:00:00 | NVDA | Stock | 0.288 | 0.288 | 0.2878 | 0.288 | 360000.0 |
| 2001-03-30 09:00:00 | NVDA | Stock | 0.288 | 0.2914 | 0.2823 | 0.2844 | 161016000.0 |
| 2001-03-30 10:00:00 | NVDA | Stock | 0.2849 | 0.2883 | 0.2766 | 0.2776 | 280320000.0 |
| 2001-03-30 11:00:00 | NVDA | Stock | 0.2776 | 0.2823 | 0.276 | 0.2797 | 158328000.0 |
| 2001-03-30 12:00:00 | NVDA | Stock | 0.2794 | 0.2831 | 0.2768 | 0.2779 | 84936000.0 |
| 2001-03-30 13:00:00 | NVDA | Stock | 0.2779 | 0.2833 | 0.2766 | 0.2831 | 114816000.0 |
| 2001-03-30 14:00:00 | NVDA | Stock | 0.2831 | 0.2875 | 0.2792 | 0.2794 | 112896000.0 |
| 2001-03-30 15:00:00 | NVDA | Stock | 0.2793 | 0.2813 | 0.2688 | 0.2708 | 369192000.0 |
| 2001-03-30 16:00:00 | NVDA | Stock | 0.2706 | 0.2854 | 0.269 | 0.2714 | 84168000.0 |
| 2001-03-30 17:00:00 | NVDA | Stock | 0.2701 | 0.2745 | 0.2701 | 0.2745 | 3528000.0 |
| 2001-03-30 08:00:00 | AMZN | Stock | 0.5075 | 0.5075 | 0.5075 | 0.5075 | 18000.0 |
| 2001-03-30 09:00:00 | AMZN | Stock | 0.51 | 0.5125 | 0.505 | 0.508 | 8218000.0 |
| 2001-03-30 10:00:00 | AMZN | Stock | 0.508 | 0.51 | 0.4985 | 0.499 | 13048000.0 |
| 2001-03-30 11:00:00 | AMZN | Stock | 0.499 | 0.505 | 0.4955 | 0.505 | 9476000.0 |
| 2001-03-30 12:00:00 | AMZN | Stock | 0.5045 | 0.5085 | 0.5025 | 0.506 | 4554000.0 |
| 2001-03-30 13:00:00 | AMZN | Stock | 0.5075 | 0.537 | 0.501 | 0.535 | 5718000.0 |
| 2001-03-30 14:00:00 | AMZN | Stock | 0.5375 | 0.542 | 0.5 | 0.522 | 7394000.0 |
| 2001-03-30 15:00:00 | AMZN | Stock | 0.522 | 0.5275 | 0.508 | 0.512 | 10330000.0 |
| 2001-03-30 16:00:00 | AMZN | Stock | 0.512 | 0.535 | 0.509 | 0.509 | 6140000.0 |
| 2001-03-30 17:00:00 | AMZN | Stock | 0.5115 | 0.5175 | 0.5115 | 0.5175 | 94000.0 |
| 2001-03-30 18:00:00 | AMZN | Stock | 0.5115 | 0.5115 | 0.5115 | 0.5115 | 232000.0 |
| 2001-03-30 09:00:00 | CL | Stock | 27.1 | 27.125 | 27.05 | 27.11 | 252200.0 |
| 2001-03-30 10:00:00 | CL | Stock | 27.12 | 27.15 | 27.0 | 27.025 | 429200.0 |
| 2001-03-30 11:00:00 | CL | Stock | 27.025 | 27.275 | 26.885 | 27.24 | 191800.0 |
| 2001-03-30 12:00:00 | CL | Stock | 27.24 | 27.725 | 27.24 | 27.56 | 240200.0 |
| 2001-03-30 13:00:00 | CL | Stock | 27.555 | 27.75 | 27.35 | 27.63 | 229600.0 |
| 2001-03-30 14:00:00 | CL | Stock | 27.635 | 27.79 | 27.605 | 27.75 | 331000.0 |
| 2001-03-30 15:00:00 | CL | Stock | 27.75 | 27.785 | 27.525 | 27.63 | 521600.0 |
> showing 50 of 17,481 rows — these rows as CSV