PREVIEW / stock_1hour / 2000-01-12
file: by_date/stock_1hour/2000/2000-01-12.parquet size: 277 KB rows: 14,216 symbols: 1,132
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-01-12 09:00:00 | AAPL | Stock | 0.8482 | 0.8527 | 0.8047 | 0.8103 | 69473600.0 |
| 2000-01-12 10:00:00 | AAPL | Stock | 0.8119 | 0.8214 | 0.7773 | 0.7972 | 178348800.0 |
| 2000-01-12 11:00:00 | AAPL | Stock | 0.7958 | 0.8214 | 0.7902 | 0.8147 | 148142400.0 |
| 2000-01-12 12:00:00 | AAPL | Stock | 0.8147 | 0.8147 | 0.7913 | 0.7969 | 107811200.0 |
| 2000-01-12 13:00:00 | AAPL | Stock | 0.7963 | 0.798 | 0.7813 | 0.7857 | 122225600.0 |
| 2000-01-12 14:00:00 | AAPL | Stock | 0.7852 | 0.7946 | 0.7813 | 0.7924 | 142195200.0 |
| 2000-01-12 15:00:00 | AAPL | Stock | 0.793 | 0.7935 | 0.7768 | 0.7768 | 181227200.0 |
| 2000-01-12 16:00:00 | AAPL | Stock | 0.7785 | 0.779 | 0.7768 | 0.7785 | 1209600.0 |
| 2000-01-12 09:00:00 | MSFT | Stock | 54.25 | 54.4375 | 52.875 | 53.25 | 8329400.0 |
| 2000-01-12 10:00:00 | MSFT | Stock | 53.25 | 53.5 | 52.5469 | 53.25 | 15635400.0 |
| 2000-01-12 11:00:00 | MSFT | Stock | 53.2812 | 53.5625 | 52.75 | 52.7812 | 7014400.0 |
| 2000-01-12 12:00:00 | MSFT | Stock | 52.7812 | 53.9688 | 52.5625 | 53.2188 | 10702200.0 |
| 2000-01-12 13:00:00 | MSFT | Stock | 53.1875 | 53.375 | 52.875 | 53.0 | 3918000.0 |
| 2000-01-12 14:00:00 | MSFT | Stock | 52.9688 | 53.125 | 52.5 | 52.5312 | 7087800.0 |
| 2000-01-12 15:00:00 | MSFT | Stock | 52.5625 | 53.3125 | 52.2188 | 52.9062 | 11137800.0 |
| 2000-01-12 16:00:00 | MSFT | Stock | 52.9062 | 52.9062 | 52.7969 | 52.9062 | 157200.0 |
| 2000-01-12 09:00:00 | NVDA | Stock | 0.0865 | 0.0866 | 0.0855 | 0.0855 | 5856000.0 |
| 2000-01-12 10:00:00 | NVDA | Stock | 0.0857 | 0.0858 | 0.0844 | 0.0852 | 34800000.0 |
| 2000-01-12 11:00:00 | NVDA | Stock | 0.0849 | 0.085 | 0.0841 | 0.0845 | 10272000.0 |
| 2000-01-12 12:00:00 | NVDA | Stock | 0.0848 | 0.0848 | 0.0831 | 0.0841 | 25584000.0 |
| 2000-01-12 13:00:00 | NVDA | Stock | 0.0836 | 0.0841 | 0.0833 | 0.0836 | 10944000.0 |
| 2000-01-12 14:00:00 | NVDA | Stock | 0.0836 | 0.0839 | 0.0833 | 0.0839 | 17184000.0 |
| 2000-01-12 15:00:00 | NVDA | Stock | 0.0839 | 0.0844 | 0.0833 | 0.0842 | 9504000.0 |
| 2000-01-12 09:00:00 | AMZN | Stock | 3.3938 | 3.4 | 3.25 | 3.2641 | 39428000.0 |
| 2000-01-12 10:00:00 | AMZN | Stock | 3.2594 | 3.3625 | 3.2469 | 3.3406 | 43840000.0 |
| 2000-01-12 11:00:00 | AMZN | Stock | 3.3438 | 3.375 | 3.3 | 3.3625 | 17116000.0 |
| 2000-01-12 12:00:00 | AMZN | Stock | 3.3625 | 3.3656 | 3.2875 | 3.2875 | 16694000.0 |
| 2000-01-12 13:00:00 | AMZN | Stock | 3.2875 | 3.3094 | 3.25 | 3.2562 | 14090000.0 |
| 2000-01-12 14:00:00 | AMZN | Stock | 3.2562 | 3.2562 | 3.175 | 3.2031 | 38970000.0 |
| 2000-01-12 15:00:00 | AMZN | Stock | 3.2031 | 3.225 | 3.15 | 3.1781 | 35150000.0 |
| 2000-01-12 16:00:00 | AMZN | Stock | 3.1844 | 3.1875 | 3.1781 | 3.1781 | 532000.0 |
| 2000-01-12 09:00:00 | CL | Stock | 31.625 | 31.8438 | 31.5625 | 31.5938 | 253800.0 |
| 2000-01-12 10:00:00 | CL | Stock | 31.5312 | 31.9688 | 31.4062 | 31.9688 | 321800.0 |
| 2000-01-12 11:00:00 | CL | Stock | 31.9062 | 32.1562 | 31.8438 | 31.9375 | 242800.0 |
| 2000-01-12 12:00:00 | CL | Stock | 31.9062 | 31.9375 | 31.4375 | 31.6875 | 485600.0 |
| 2000-01-12 13:00:00 | CL | Stock | 31.7188 | 31.9062 | 31.6562 | 31.8125 | 209000.0 |
| 2000-01-12 14:00:00 | CL | Stock | 31.8125 | 31.9688 | 31.5938 | 31.8438 | 373800.0 |
| 2000-01-12 15:00:00 | CL | Stock | 31.8438 | 32.2188 | 31.8125 | 32.1875 | 385400.0 |
| 2000-01-12 16:00:00 | CL | Stock | 32.1562 | 32.1875 | 32.1562 | 32.1875 | 45400.0 |
> showing 39 of 14,216 rows — these rows as CSV