PREVIEW / stock_1hour / 2000-03-22
file: by_date/stock_1hour/2000/2000-03-22.parquet size: 288 KB rows: 14,568 symbols: 1,148
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-22 09:00:00 | AAPL | Stock | 1.1855 | 1.2355 | 1.1747 | 1.2254 | 72430400.0 |
| 2000-03-22 10:00:00 | AAPL | Stock | 1.2243 | 1.2612 | 1.2199 | 1.2344 | 114318400.0 |
| 2000-03-22 11:00:00 | AAPL | Stock | 1.2377 | 1.2405 | 1.2104 | 1.2188 | 43568000.0 |
| 2000-03-22 12:00:00 | AAPL | Stock | 1.2143 | 1.2165 | 1.1964 | 1.2121 | 27518400.0 |
| 2000-03-22 13:00:00 | AAPL | Stock | 1.2121 | 1.2243 | 1.2076 | 1.2221 | 25950400.0 |
| 2000-03-22 14:00:00 | AAPL | Stock | 1.2221 | 1.2556 | 1.221 | 1.2478 | 89566400.0 |
| 2000-03-22 15:00:00 | AAPL | Stock | 1.2475 | 1.2891 | 1.2467 | 1.2879 | 154929600.0 |
| 2000-03-22 16:00:00 | AAPL | Stock | 1.2874 | 1.2879 | 1.2874 | 1.2874 | 1332800.0 |
| 2000-03-22 09:00:00 | MSFT | Stock | 51.4062 | 51.6562 | 50.75 | 50.75 | 11436200.0 |
| 2000-03-22 10:00:00 | MSFT | Stock | 50.8125 | 52.5 | 50.5625 | 52.375 | 21038800.0 |
| 2000-03-22 11:00:00 | MSFT | Stock | 52.3594 | 52.4062 | 51.8125 | 52.3438 | 13687000.0 |
| 2000-03-22 12:00:00 | MSFT | Stock | 52.3125 | 52.4375 | 51.9375 | 52.3438 | 6984800.0 |
| 2000-03-22 13:00:00 | MSFT | Stock | 52.3438 | 52.4375 | 52.0625 | 52.0938 | 5033200.0 |
| 2000-03-22 14:00:00 | MSFT | Stock | 52.0938 | 52.5312 | 52.0938 | 52.3438 | 16500200.0 |
| 2000-03-22 15:00:00 | MSFT | Stock | 52.375 | 52.8125 | 51.375 | 51.6562 | 14751600.0 |
| 2000-03-22 16:00:00 | MSFT | Stock | 51.6406 | 51.6875 | 51.625 | 51.625 | 357600.0 |
| 2000-03-22 09:00:00 | NVDA | Stock | 0.1992 | 0.2052 | 0.1979 | 0.2 | 35328000.0 |
| 2000-03-22 10:00:00 | NVDA | Stock | 0.201 | 0.2039 | 0.1967 | 0.2004 | 41472000.0 |
| 2000-03-22 11:00:00 | NVDA | Stock | 0.1997 | 0.2021 | 0.1958 | 0.2013 | 35856000.0 |
| 2000-03-22 12:00:00 | NVDA | Stock | 0.2007 | 0.2021 | 0.1979 | 0.2018 | 20592000.0 |
| 2000-03-22 13:00:00 | NVDA | Stock | 0.2018 | 0.2052 | 0.1992 | 0.2018 | 36192000.0 |
| 2000-03-22 14:00:00 | NVDA | Stock | 0.2018 | 0.2038 | 0.1995 | 0.2017 | 16128000.0 |
| 2000-03-22 15:00:00 | NVDA | Stock | 0.202 | 0.2031 | 0.1969 | 0.1977 | 33840000.0 |
| 2000-03-22 16:00:00 | NVDA | Stock | 0.1992 | 0.1992 | 0.1991 | 0.1991 | 144000.0 |
| 2000-03-22 09:00:00 | AMZN | Stock | 3.5438 | 3.6688 | 3.525 | 3.5562 | 47894000.0 |
| 2000-03-22 10:00:00 | AMZN | Stock | 3.5656 | 3.6312 | 3.4625 | 3.625 | 44562000.0 |
| 2000-03-22 11:00:00 | AMZN | Stock | 3.6281 | 3.6844 | 3.55 | 3.5969 | 31360000.0 |
| 2000-03-22 12:00:00 | AMZN | Stock | 3.6 | 3.6062 | 3.5531 | 3.5844 | 11666000.0 |
| 2000-03-22 13:00:00 | AMZN | Stock | 3.5781 | 3.5875 | 3.5312 | 3.5531 | 11574000.0 |
| 2000-03-22 14:00:00 | AMZN | Stock | 3.5562 | 3.7 | 3.5531 | 3.6375 | 38830000.0 |
| 2000-03-22 15:00:00 | AMZN | Stock | 3.6281 | 3.6844 | 3.5188 | 3.5344 | 31654000.0 |
| 2000-03-22 16:00:00 | AMZN | Stock | 3.5406 | 3.5406 | 3.5312 | 3.5344 | 558000.0 |
| 2000-03-22 09:00:00 | CL | Stock | 24.9375 | 24.9375 | 24.625 | 24.6562 | 477200.0 |
| 2000-03-22 10:00:00 | CL | Stock | 24.625 | 24.625 | 24.375 | 24.5625 | 1053600.0 |
| 2000-03-22 11:00:00 | CL | Stock | 24.5625 | 24.5938 | 24.4688 | 24.4688 | 706400.0 |
| 2000-03-22 12:00:00 | CL | Stock | 24.4688 | 24.5312 | 24.25 | 24.4688 | 745400.0 |
| 2000-03-22 13:00:00 | CL | Stock | 24.5 | 24.6875 | 24.4062 | 24.5 | 474400.0 |
| 2000-03-22 14:00:00 | CL | Stock | 24.5 | 24.8438 | 24.5 | 24.7812 | 426400.0 |
| 2000-03-22 15:00:00 | CL | Stock | 24.7812 | 25.4688 | 24.7812 | 25.3125 | 873800.0 |
| 2000-03-22 16:00:00 | CL | Stock | 25.3125 | 25.3125 | 25.2812 | 25.2812 | 99600.0 |
> showing 40 of 14,568 rows — these rows as CSV