PREVIEW / stock_1hour / 2000-06-06
file: by_date/stock_1hour/2000/2000-06-06.parquet size: 295 KB rows: 15,103 symbols: 1,181
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-06-06 09:00:00 | AAPL | Stock | 0.8052 | 0.8287 | 0.8052 | 0.8192 | 35974400.0 |
| 2000-06-06 10:00:00 | AAPL | Stock | 0.8186 | 0.8237 | 0.8075 | 0.8164 | 42392000.0 |
| 2000-06-06 11:00:00 | AAPL | Stock | 0.8164 | 0.8348 | 0.8136 | 0.8281 | 50960000.0 |
| 2000-06-06 12:00:00 | AAPL | Stock | 0.8281 | 0.8393 | 0.8276 | 0.8359 | 48675200.0 |
| 2000-06-06 13:00:00 | AAPL | Stock | 0.8359 | 0.8588 | 0.8348 | 0.8516 | 80662400.0 |
| 2000-06-06 14:00:00 | AAPL | Stock | 0.8516 | 0.8583 | 0.8359 | 0.8382 | 153473600.0 |
| 2000-06-06 15:00:00 | AAPL | Stock | 0.8387 | 0.8449 | 0.829 | 0.8292 | 88468800.0 |
| 2000-06-06 16:00:00 | AAPL | Stock | 0.8295 | 0.8309 | 0.8225 | 0.8292 | 12689600.0 |
| 2000-06-06 17:00:00 | AAPL | Stock | 0.8292 | 0.8292 | 0.8292 | 0.8292 | 168000.0 |
| 2000-06-06 18:00:00 | AAPL | Stock | 0.8315 | 0.8315 | 0.8315 | 0.8315 | 22400.0 |
| 2000-06-06 08:00:00 | MSFT | Stock | 33.4219 | 34.125 | 33.4219 | 33.875 | 383000.0 |
| 2000-06-06 09:00:00 | MSFT | Stock | 33.875 | 34.1562 | 33.75 | 34.125 | 12452000.0 |
| 2000-06-06 10:00:00 | MSFT | Stock | 34.0938 | 34.5938 | 33.9375 | 34.375 | 19076200.0 |
| 2000-06-06 11:00:00 | MSFT | Stock | 34.4062 | 34.6875 | 34.3125 | 34.6562 | 8545800.0 |
| 2000-06-06 12:00:00 | MSFT | Stock | 34.6562 | 34.875 | 34.625 | 34.8438 | 10637400.0 |
| 2000-06-06 13:00:00 | MSFT | Stock | 34.8438 | 34.875 | 34.5781 | 34.6875 | 12724600.0 |
| 2000-06-06 14:00:00 | MSFT | Stock | 34.6875 | 34.8125 | 34.4375 | 34.5938 | 12587800.0 |
| 2000-06-06 15:00:00 | MSFT | Stock | 34.5625 | 34.9375 | 34.25 | 34.75 | 18204400.0 |
| 2000-06-06 16:00:00 | MSFT | Stock | 34.75 | 34.8438 | 34.5938 | 34.8125 | 3505200.0 |
| 2000-06-06 17:00:00 | MSFT | Stock | 34.8125 | 34.8438 | 34.6719 | 34.7812 | 69800.0 |
| 2000-06-06 18:00:00 | MSFT | Stock | 34.7812 | 34.8438 | 34.75 | 34.8438 | 11000.0 |
| 2000-06-06 09:00:00 | NVDA | Stock | 0.281 | 0.2858 | 0.2794 | 0.2858 | 32256000.0 |
| 2000-06-06 10:00:00 | NVDA | Stock | 0.2858 | 0.2914 | 0.2844 | 0.2887 | 89280000.0 |
| 2000-06-06 11:00:00 | NVDA | Stock | 0.287 | 0.2887 | 0.2852 | 0.2864 | 20544000.0 |
| 2000-06-06 12:00:00 | NVDA | Stock | 0.2865 | 0.2865 | 0.2818 | 0.2841 | 42480000.0 |
| 2000-06-06 13:00:00 | NVDA | Stock | 0.2831 | 0.2857 | 0.2812 | 0.2833 | 51936000.0 |
| 2000-06-06 14:00:00 | NVDA | Stock | 0.2823 | 0.2832 | 0.2745 | 0.275 | 56784000.0 |
| 2000-06-06 15:00:00 | NVDA | Stock | 0.275 | 0.2771 | 0.2646 | 0.266 | 65520000.0 |
| 2000-06-06 16:00:00 | NVDA | Stock | 0.266 | 0.2826 | 0.266 | 0.2661 | 9216000.0 |
| 2000-06-06 18:00:00 | NVDA | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 48000.0 |
| 2000-06-06 08:00:00 | AMZN | Stock | 2.8 | 2.8 | 2.625 | 2.6766 | 214000.0 |
| 2000-06-06 09:00:00 | AMZN | Stock | 2.7 | 2.7281 | 2.6375 | 2.65 | 9908000.0 |
| 2000-06-06 10:00:00 | AMZN | Stock | 2.65 | 2.6719 | 2.625 | 2.6375 | 14960000.0 |
| 2000-06-06 11:00:00 | AMZN | Stock | 2.6406 | 2.6938 | 2.625 | 2.675 | 10474000.0 |
| 2000-06-06 12:00:00 | AMZN | Stock | 2.6688 | 2.6813 | 2.65 | 2.675 | 7620000.0 |
| 2000-06-06 13:00:00 | AMZN | Stock | 2.675 | 2.6875 | 2.6438 | 2.65 | 6110000.0 |
| 2000-06-06 14:00:00 | AMZN | Stock | 2.65 | 2.6594 | 2.575 | 2.575 | 16080000.0 |
| 2000-06-06 15:00:00 | AMZN | Stock | 2.5781 | 2.5875 | 2.5125 | 2.5281 | 28538000.0 |
| 2000-06-06 16:00:00 | AMZN | Stock | 2.5281 | 2.6688 | 2.5281 | 2.5438 | 1390000.0 |
| 2000-06-06 17:00:00 | AMZN | Stock | 2.5281 | 2.5438 | 2.5281 | 2.5438 | 16000.0 |
| 2000-06-06 18:00:00 | AMZN | Stock | 2.55 | 2.55 | 2.55 | 2.55 | 10000.0 |
| 2000-06-06 09:00:00 | CL | Stock | 26.0 | 26.375 | 26.0 | 26.375 | 371200.0 |
| 2000-06-06 10:00:00 | CL | Stock | 26.375 | 26.5938 | 26.3125 | 26.375 | 348200.0 |
| 2000-06-06 11:00:00 | CL | Stock | 26.3438 | 26.5625 | 26.2812 | 26.375 | 238800.0 |
| 2000-06-06 12:00:00 | CL | Stock | 26.3438 | 26.4375 | 26.2188 | 26.4062 | 349600.0 |
| 2000-06-06 13:00:00 | CL | Stock | 26.4375 | 26.875 | 26.4375 | 26.8125 | 317000.0 |
| 2000-06-06 14:00:00 | CL | Stock | 26.75 | 27.2812 | 26.75 | 27.2812 | 304200.0 |
| 2000-06-06 15:00:00 | CL | Stock | 27.25 | 27.375 | 27.1875 | 27.2812 | 434800.0 |
| 2000-06-06 16:00:00 | CL | Stock | 27.2812 | 27.2812 | 27.25 | 27.2812 | 61400.0 |
> showing 49 of 15,103 rows — these rows as CSV