PREVIEW / stock_1hour / 2001-03-28
file: by_date/stock_1hour/2001/2001-03-28.parquet size: 348 KB rows: 16,338 symbols: 1,277
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-28 08:00:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3905 | 0.3936 | 3500000.0 |
| 2001-03-28 09:00:00 | AAPL | Stock | 0.3955 | 0.3971 | 0.3891 | 0.3911 | 85478400.0 |
| 2001-03-28 10:00:00 | AAPL | Stock | 0.3911 | 0.392 | 0.3846 | 0.3855 | 96493600.0 |
| 2001-03-28 11:00:00 | AAPL | Stock | 0.3864 | 0.3905 | 0.3839 | 0.3877 | 132182400.0 |
| 2001-03-28 12:00:00 | AAPL | Stock | 0.3884 | 0.3939 | 0.3877 | 0.3929 | 70672000.0 |
| 2001-03-28 13:00:00 | AAPL | Stock | 0.3934 | 0.3938 | 0.3888 | 0.3932 | 37520000.0 |
| 2001-03-28 14:00:00 | AAPL | Stock | 0.3932 | 0.3982 | 0.3907 | 0.397 | 40969600.0 |
| 2001-03-28 15:00:00 | AAPL | Stock | 0.397 | 0.3971 | 0.3921 | 0.3959 | 72968000.0 |
| 2001-03-28 16:00:00 | AAPL | Stock | 0.3957 | 0.3968 | 0.3888 | 0.3911 | 31875200.0 |
| 2001-03-28 17:00:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3929 | 0.3959 | 128800.0 |
| 2001-03-28 18:00:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 425600.0 |
| 2001-03-28 08:00:00 | MSFT | Stock | 28.625 | 28.875 | 28.5625 | 28.7188 | 155400.0 |
| 2001-03-28 09:00:00 | MSFT | Stock | 28.6875 | 28.9688 | 28.5312 | 28.7812 | 10971600.0 |
| 2001-03-28 10:00:00 | MSFT | Stock | 28.75 | 28.9062 | 28.5312 | 28.5625 | 10677800.0 |
| 2001-03-28 11:00:00 | MSFT | Stock | 28.5625 | 28.6562 | 28.2188 | 28.3438 | 11375200.0 |
| 2001-03-28 12:00:00 | MSFT | Stock | 28.3125 | 28.5938 | 28.25 | 28.5 | 4396200.0 |
| 2001-03-28 13:00:00 | MSFT | Stock | 28.5312 | 28.6875 | 28.3438 | 28.375 | 4720400.0 |
| 2001-03-28 14:00:00 | MSFT | Stock | 28.375 | 28.4688 | 28.0938 | 28.0938 | 11850000.0 |
| 2001-03-28 15:00:00 | MSFT | Stock | 28.0938 | 28.125 | 27.6875 | 27.7812 | 18268200.0 |
| 2001-03-28 16:00:00 | MSFT | Stock | 27.7812 | 28.9531 | 27.5625 | 27.7188 | 3099600.0 |
| 2001-03-28 17:00:00 | MSFT | Stock | 27.6562 | 27.7812 | 27.625 | 27.75 | 41200.0 |
| 2001-03-28 18:00:00 | MSFT | Stock | 27.7812 | 27.7812 | 27.75 | 27.75 | 800.0 |
| 2001-03-28 08:00:00 | NVDA | Stock | 0.2792 | 0.2836 | 0.276 | 0.276 | 6792000.0 |
| 2001-03-28 09:00:00 | NVDA | Stock | 0.276 | 0.2876 | 0.2745 | 0.2836 | 300576000.0 |
| 2001-03-28 10:00:00 | NVDA | Stock | 0.2836 | 0.2911 | 0.2815 | 0.2828 | 311280000.0 |
| 2001-03-28 11:00:00 | NVDA | Stock | 0.2835 | 0.2885 | 0.2818 | 0.288 | 154704000.0 |
| 2001-03-28 12:00:00 | NVDA | Stock | 0.2872 | 0.2885 | 0.2862 | 0.288 | 70920000.0 |
| 2001-03-28 13:00:00 | NVDA | Stock | 0.2878 | 0.2883 | 0.2839 | 0.2844 | 68784000.0 |
| 2001-03-28 14:00:00 | NVDA | Stock | 0.2844 | 0.2904 | 0.2828 | 0.2872 | 227208000.0 |
| 2001-03-28 15:00:00 | NVDA | Stock | 0.2872 | 0.288 | 0.2828 | 0.2839 | 208536000.0 |
| 2001-03-28 16:00:00 | NVDA | Stock | 0.2839 | 0.288 | 0.2818 | 0.2839 | 13464000.0 |
| 2001-03-28 17:00:00 | NVDA | Stock | 0.2833 | 0.2841 | 0.2833 | 0.2841 | 288000.0 |
| 2001-03-28 18:00:00 | NVDA | Stock | 0.2844 | 0.2844 | 0.2844 | 0.2844 | 96000.0 |
| 2001-03-28 08:00:00 | AMZN | Stock | 0.5635 | 0.575 | 0.555 | 0.558 | 210000.0 |
| 2001-03-28 09:00:00 | AMZN | Stock | 0.555 | 0.567 | 0.5405 | 0.5445 | 13442000.0 |
| 2001-03-28 10:00:00 | AMZN | Stock | 0.5445 | 0.55 | 0.5405 | 0.545 | 11022000.0 |
| 2001-03-28 11:00:00 | AMZN | Stock | 0.5455 | 0.55 | 0.542 | 0.5465 | 8706000.0 |
| 2001-03-28 12:00:00 | AMZN | Stock | 0.546 | 0.5535 | 0.546 | 0.55 | 4240000.0 |
| 2001-03-28 13:00:00 | AMZN | Stock | 0.5495 | 0.555 | 0.5465 | 0.5515 | 11674000.0 |
| 2001-03-28 14:00:00 | AMZN | Stock | 0.552 | 0.554 | 0.543 | 0.5465 | 4342000.0 |
| 2001-03-28 15:00:00 | AMZN | Stock | 0.546 | 0.558 | 0.54 | 0.54 | 9376000.0 |
| 2001-03-28 16:00:00 | AMZN | Stock | 0.5405 | 0.545 | 0.54 | 0.54 | 1936000.0 |
| 2001-03-28 17:00:00 | AMZN | Stock | 0.54 | 0.5405 | 0.54 | 0.5405 | 10000.0 |
| 2001-03-28 09:00:00 | CL | Stock | 27.6 | 27.605 | 27.3 | 27.3 | 619000.0 |
| 2001-03-28 10:00:00 | CL | Stock | 27.28 | 27.395 | 27.175 | 27.18 | 515400.0 |
| 2001-03-28 11:00:00 | CL | Stock | 27.18 | 27.275 | 26.9 | 26.905 | 338600.0 |
| 2001-03-28 12:00:00 | CL | Stock | 26.88 | 27.2 | 26.875 | 27.2 | 186200.0 |
| 2001-03-28 13:00:00 | CL | Stock | 27.22 | 27.305 | 27.175 | 27.225 | 335400.0 |
| 2001-03-28 14:00:00 | CL | Stock | 27.225 | 27.49 | 27.225 | 27.48 | 338200.0 |
| 2001-03-28 15:00:00 | CL | Stock | 27.5 | 27.805 | 27.32 | 27.705 | 894000.0 |
> showing 50 of 16,338 rows — these rows as CSV