PREVIEW / stock_1hour / 2001-03-22
file: by_date/stock_1hour/2001/2001-03-22.parquet size: 360 KB rows: 16,836 symbols: 1,284
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-22 08:00:00 | AAPL | Stock | 0.3571 | 0.3638 | 0.3571 | 0.3605 | 487200.0 |
| 2001-03-22 09:00:00 | AAPL | Stock | 0.3638 | 0.3728 | 0.3627 | 0.3705 | 68028800.0 |
| 2001-03-22 10:00:00 | AAPL | Stock | 0.3694 | 0.3717 | 0.3605 | 0.3694 | 73785600.0 |
| 2001-03-22 11:00:00 | AAPL | Stock | 0.3694 | 0.3717 | 0.3638 | 0.365 | 73326400.0 |
| 2001-03-22 12:00:00 | AAPL | Stock | 0.365 | 0.3728 | 0.3638 | 0.3705 | 69204800.0 |
| 2001-03-22 13:00:00 | AAPL | Stock | 0.3694 | 0.3739 | 0.3694 | 0.3705 | 94651200.0 |
| 2001-03-22 14:00:00 | AAPL | Stock | 0.3705 | 0.3739 | 0.3661 | 0.3739 | 64736000.0 |
| 2001-03-22 15:00:00 | AAPL | Stock | 0.3739 | 0.3884 | 0.3705 | 0.3862 | 238683200.0 |
| 2001-03-22 16:00:00 | AAPL | Stock | 0.3867 | 0.3884 | 0.3756 | 0.3862 | 17718400.0 |
| 2001-03-22 17:00:00 | AAPL | Stock | 0.3884 | 0.3884 | 0.3862 | 0.3884 | 4071200.0 |
| 2001-03-22 18:00:00 | AAPL | Stock | 0.3873 | 0.3884 | 0.3873 | 0.3884 | 28000.0 |
| 2001-03-22 08:00:00 | MSFT | Stock | 24.75 | 25.5625 | 24.6875 | 25.5 | 1851000.0 |
| 2001-03-22 09:00:00 | MSFT | Stock | 25.5312 | 26.0938 | 24.875 | 25.8125 | 17759400.0 |
| 2001-03-22 10:00:00 | MSFT | Stock | 25.8125 | 25.8438 | 25.3125 | 25.7188 | 20260200.0 |
| 2001-03-22 11:00:00 | MSFT | Stock | 25.7188 | 26.0 | 25.4375 | 25.7656 | 11503200.0 |
| 2001-03-22 12:00:00 | MSFT | Stock | 25.75 | 26.3125 | 25.625 | 26.125 | 12854800.0 |
| 2001-03-22 13:00:00 | MSFT | Stock | 26.125 | 26.25 | 25.9688 | 26.0312 | 5171200.0 |
| 2001-03-22 14:00:00 | MSFT | Stock | 26.0312 | 26.625 | 25.6875 | 26.625 | 16294400.0 |
| 2001-03-22 15:00:00 | MSFT | Stock | 26.625 | 27.0312 | 26.5 | 26.9688 | 32258600.0 |
| 2001-03-22 16:00:00 | MSFT | Stock | 26.9688 | 27.0 | 26.0938 | 27.0 | 3369800.0 |
| 2001-03-22 17:00:00 | MSFT | Stock | 27.0 | 27.0938 | 25.75 | 27.0 | 669000.0 |
| 2001-03-22 18:00:00 | MSFT | Stock | 27.1094 | 27.125 | 27.0 | 27.125 | 5400.0 |
| 2001-03-22 08:00:00 | NVDA | Stock | 0.2531 | 0.2552 | 0.25 | 0.2552 | 6360000.0 |
| 2001-03-22 09:00:00 | NVDA | Stock | 0.2563 | 0.2661 | 0.2563 | 0.2651 | 252912000.0 |
| 2001-03-22 10:00:00 | NVDA | Stock | 0.2651 | 0.2664 | 0.2563 | 0.2628 | 329784000.0 |
| 2001-03-22 11:00:00 | NVDA | Stock | 0.2622 | 0.2652 | 0.2599 | 0.262 | 138000000.0 |
| 2001-03-22 12:00:00 | NVDA | Stock | 0.2617 | 0.2646 | 0.2596 | 0.2616 | 109584000.0 |
| 2001-03-22 13:00:00 | NVDA | Stock | 0.2617 | 0.2638 | 0.2604 | 0.2612 | 51192000.0 |
| 2001-03-22 14:00:00 | NVDA | Stock | 0.2612 | 0.2655 | 0.2578 | 0.2651 | 139248000.0 |
| 2001-03-22 15:00:00 | NVDA | Stock | 0.2648 | 0.2828 | 0.2635 | 0.2818 | 531744000.0 |
| 2001-03-22 16:00:00 | NVDA | Stock | 0.2815 | 0.2875 | 0.275 | 0.2839 | 40992000.0 |
| 2001-03-22 17:00:00 | NVDA | Stock | 0.2839 | 0.2854 | 0.2835 | 0.2836 | 1128000.0 |
| 2001-03-22 18:00:00 | NVDA | Stock | 0.2835 | 0.2844 | 0.2833 | 0.2833 | 360000.0 |
| 2001-03-22 08:00:00 | AMZN | Stock | 0.5031 | 0.5125 | 0.5031 | 0.5125 | 116000.0 |
| 2001-03-22 09:00:00 | AMZN | Stock | 0.5125 | 0.5125 | 0.4938 | 0.4953 | 9048000.0 |
| 2001-03-22 10:00:00 | AMZN | Stock | 0.4953 | 0.4969 | 0.4844 | 0.4844 | 17456000.0 |
| 2001-03-22 11:00:00 | AMZN | Stock | 0.4844 | 0.4906 | 0.4781 | 0.4844 | 23144000.0 |
| 2001-03-22 12:00:00 | AMZN | Stock | 0.4875 | 0.4922 | 0.4844 | 0.4906 | 16202000.0 |
| 2001-03-22 13:00:00 | AMZN | Stock | 0.4891 | 0.4906 | 0.4844 | 0.4859 | 12108000.0 |
| 2001-03-22 14:00:00 | AMZN | Stock | 0.4859 | 0.4906 | 0.4844 | 0.4875 | 10298000.0 |
| 2001-03-22 15:00:00 | AMZN | Stock | 0.4875 | 0.5125 | 0.4844 | 0.5094 | 31432000.0 |
| 2001-03-22 16:00:00 | AMZN | Stock | 0.5125 | 0.5297 | 0.5031 | 0.5125 | 5838000.0 |
| 2001-03-22 17:00:00 | AMZN | Stock | 0.5094 | 0.5094 | 0.5062 | 0.5062 | 662000.0 |
| 2001-03-22 09:00:00 | CL | Stock | 25.375 | 25.4 | 25.15 | 25.25 | 918800.0 |
| 2001-03-22 10:00:00 | CL | Stock | 25.2 | 25.2 | 24.725 | 24.8 | 1525000.0 |
| 2001-03-22 11:00:00 | CL | Stock | 24.8 | 24.875 | 24.25 | 24.395 | 948000.0 |
| 2001-03-22 12:00:00 | CL | Stock | 24.375 | 24.825 | 24.3 | 24.55 | 784000.0 |
| 2001-03-22 13:00:00 | CL | Stock | 24.575 | 24.945 | 24.525 | 24.945 | 387400.0 |
| 2001-03-22 14:00:00 | CL | Stock | 24.945 | 25.105 | 24.87 | 24.895 | 595800.0 |
| 2001-03-22 15:00:00 | CL | Stock | 24.895 | 25.625 | 24.84 | 25.5 | 801600.0 |
> showing 50 of 16,836 rows — these rows as CSV