PREVIEW / stock_1hour / 2000-02-03
file: by_date/stock_1hour/2000/2000-02-03.parquet size: 283 KB rows: 14,403 symbols: 1,137
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-02-03 09:00:00 | AAPL | Stock | 0.8956 | 0.9146 | 0.8951 | 0.9102 | 92086400.0 |
| 2000-02-03 10:00:00 | AAPL | Stock | 0.9102 | 0.9163 | 0.9051 | 0.9141 | 83384000.0 |
| 2000-02-03 11:00:00 | AAPL | Stock | 0.9146 | 0.923 | 0.9141 | 0.9143 | 70649600.0 |
| 2000-02-03 12:00:00 | AAPL | Stock | 0.9141 | 0.9213 | 0.9063 | 0.9196 | 71131200.0 |
| 2000-02-03 13:00:00 | AAPL | Stock | 0.9196 | 0.923 | 0.9169 | 0.9208 | 29814400.0 |
| 2000-02-03 14:00:00 | AAPL | Stock | 0.9208 | 0.9219 | 0.9051 | 0.9185 | 56884800.0 |
| 2000-02-03 15:00:00 | AAPL | Stock | 0.9182 | 0.9308 | 0.9157 | 0.923 | 53020800.0 |
| 2000-02-03 16:00:00 | AAPL | Stock | 0.923 | 0.923 | 0.9219 | 0.9224 | 638400.0 |
| 2000-02-03 09:00:00 | MSFT | Stock | 51.0312 | 51.1562 | 50.5 | 51.125 | 7050000.0 |
| 2000-02-03 10:00:00 | MSFT | Stock | 51.125 | 51.125 | 50.375 | 50.9688 | 7376200.0 |
| 2000-02-03 11:00:00 | MSFT | Stock | 50.9688 | 51.4375 | 50.5625 | 50.5625 | 6202400.0 |
| 2000-02-03 12:00:00 | MSFT | Stock | 50.5625 | 50.9688 | 50.0625 | 50.875 | 6280000.0 |
| 2000-02-03 13:00:00 | MSFT | Stock | 50.9062 | 51.375 | 50.7188 | 51.25 | 4553600.0 |
| 2000-02-03 14:00:00 | MSFT | Stock | 51.25 | 51.9375 | 50.9688 | 51.7812 | 6523400.0 |
| 2000-02-03 15:00:00 | MSFT | Stock | 51.75 | 52.0938 | 51.4062 | 51.7812 | 8828200.0 |
| 2000-02-03 16:00:00 | MSFT | Stock | 51.7812 | 51.8125 | 51.7344 | 51.8125 | 58800.0 |
| 2000-02-03 09:00:00 | NVDA | Stock | 0.0839 | 0.0855 | 0.0831 | 0.0846 | 32352000.0 |
| 2000-02-03 10:00:00 | NVDA | Stock | 0.0846 | 0.0854 | 0.0836 | 0.0839 | 27264000.0 |
| 2000-02-03 11:00:00 | NVDA | Stock | 0.0836 | 0.0839 | 0.082 | 0.0836 | 13728000.0 |
| 2000-02-03 12:00:00 | NVDA | Stock | 0.0836 | 0.0836 | 0.0823 | 0.0825 | 10752000.0 |
| 2000-02-03 13:00:00 | NVDA | Stock | 0.0831 | 0.0832 | 0.0824 | 0.0831 | 7872000.0 |
| 2000-02-03 14:00:00 | NVDA | Stock | 0.0831 | 0.0832 | 0.0827 | 0.0831 | 5760000.0 |
| 2000-02-03 15:00:00 | NVDA | Stock | 0.0831 | 0.0831 | 0.0823 | 0.0826 | 9408000.0 |
| 2000-02-03 09:00:00 | AMZN | Stock | 4.0562 | 4.125 | 3.925 | 3.9438 | 168794000.0 |
| 2000-02-03 10:00:00 | AMZN | Stock | 3.9406 | 4.0281 | 3.8688 | 4.0156 | 120696000.0 |
| 2000-02-03 11:00:00 | AMZN | Stock | 4.0156 | 4.1219 | 3.9875 | 4.0281 | 140686000.0 |
| 2000-02-03 12:00:00 | AMZN | Stock | 4.0312 | 4.05 | 3.95 | 4.0281 | 64554000.0 |
| 2000-02-03 13:00:00 | AMZN | Stock | 4.0312 | 4.075 | 4.025 | 4.0688 | 39482000.0 |
| 2000-02-03 14:00:00 | AMZN | Stock | 4.0688 | 4.25 | 4.0531 | 4.2312 | 136314000.0 |
| 2000-02-03 15:00:00 | AMZN | Stock | 4.2344 | 4.2688 | 4.15 | 4.2 | 123044000.0 |
| 2000-02-03 16:00:00 | AMZN | Stock | 4.2062 | 4.2156 | 4.2 | 4.2094 | 730000.0 |
| 2000-02-03 09:00:00 | CL | Stock | 30.5 | 30.5 | 29.5 | 29.7188 | 628200.0 |
| 2000-02-03 10:00:00 | CL | Stock | 29.7188 | 29.9062 | 29.1875 | 29.8438 | 758600.0 |
| 2000-02-03 11:00:00 | CL | Stock | 29.875 | 30.125 | 29.8438 | 30.0 | 531600.0 |
| 2000-02-03 12:00:00 | CL | Stock | 30.0 | 30.2188 | 30.0 | 30.2188 | 401400.0 |
| 2000-02-03 13:00:00 | CL | Stock | 30.3438 | 30.875 | 30.0 | 30.0312 | 362600.0 |
| 2000-02-03 14:00:00 | CL | Stock | 29.9688 | 30.5625 | 29.9688 | 30.3125 | 588600.0 |
| 2000-02-03 15:00:00 | CL | Stock | 30.3125 | 30.3438 | 29.8438 | 29.9688 | 888600.0 |
| 2000-02-03 16:00:00 | CL | Stock | 30.0 | 30.0 | 29.9688 | 30.0 | 43000.0 |
> showing 39 of 14,403 rows — these rows as CSV