PREVIEW / stock_1hour / 2000-02-09
file: by_date/stock_1hour/2000/2000-02-09.parquet size: 285 KB rows: 14,530 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-09 09:00:00 | AAPL | Stock | 1.019 | 1.0212 | 1.0045 | 1.0078 | 37923200.0 |
| 2000-02-09 10:00:00 | AAPL | Stock | 1.0078 | 1.0413 | 1.0067 | 1.0346 | 65228800.0 |
| 2000-02-09 11:00:00 | AAPL | Stock | 1.0346 | 1.0458 | 1.0173 | 1.0173 | 51352000.0 |
| 2000-02-09 12:00:00 | AAPL | Stock | 1.0176 | 1.019 | 1.0067 | 1.0089 | 30665600.0 |
| 2000-02-09 13:00:00 | AAPL | Stock | 1.0112 | 1.019 | 1.0078 | 1.0179 | 25144000.0 |
| 2000-02-09 14:00:00 | AAPL | Stock | 1.019 | 1.0223 | 1.0095 | 1.0145 | 23945600.0 |
| 2000-02-09 15:00:00 | AAPL | Stock | 1.0142 | 1.0201 | 1.0045 | 1.0056 | 40163200.0 |
| 2000-02-09 16:00:00 | AAPL | Stock | 1.0056 | 1.0056 | 1.005 | 1.0056 | 604800.0 |
| 2000-02-09 09:00:00 | MSFT | Stock | 54.7188 | 54.7188 | 54.0625 | 54.1562 | 6370800.0 |
| 2000-02-09 10:00:00 | MSFT | Stock | 54.125 | 54.3438 | 53.875 | 54.0312 | 6847600.0 |
| 2000-02-09 11:00:00 | MSFT | Stock | 54.0 | 54.1562 | 53.625 | 53.875 | 4997200.0 |
| 2000-02-09 12:00:00 | MSFT | Stock | 53.875 | 53.9375 | 53.4688 | 53.5 | 5332800.0 |
| 2000-02-09 13:00:00 | MSFT | Stock | 53.5 | 53.75 | 52.8438 | 52.9062 | 6091200.0 |
| 2000-02-09 14:00:00 | MSFT | Stock | 52.875 | 53.4688 | 52.8438 | 53.375 | 6559600.0 |
| 2000-02-09 15:00:00 | MSFT | Stock | 53.375 | 53.4375 | 51.9375 | 52.0 | 13404600.0 |
| 2000-02-09 16:00:00 | MSFT | Stock | 52.0 | 52.0312 | 51.9375 | 52.0 | 99000.0 |
| 2000-02-09 09:00:00 | NVDA | Stock | 0.0862 | 0.0876 | 0.0859 | 0.0875 | 90480000.0 |
| 2000-02-09 10:00:00 | NVDA | Stock | 0.0871 | 0.0875 | 0.0862 | 0.0866 | 79200000.0 |
| 2000-02-09 11:00:00 | NVDA | Stock | 0.0866 | 0.0875 | 0.0862 | 0.0862 | 68160000.0 |
| 2000-02-09 12:00:00 | NVDA | Stock | 0.0862 | 0.0867 | 0.085 | 0.0858 | 70224000.0 |
| 2000-02-09 13:00:00 | NVDA | Stock | 0.0859 | 0.0859 | 0.0854 | 0.0859 | 79824000.0 |
| 2000-02-09 14:00:00 | NVDA | Stock | 0.0859 | 0.0863 | 0.0857 | 0.0862 | 65568000.0 |
| 2000-02-09 15:00:00 | NVDA | Stock | 0.0862 | 0.0863 | 0.0853 | 0.0861 | 105168000.0 |
| 2000-02-09 16:00:00 | NVDA | Stock | 0.0861 | 0.0861 | 0.0852 | 0.0852 | 4656000.0 |
| 2000-02-09 09:00:00 | AMZN | Stock | 4.0266 | 4.1625 | 4.0063 | 4.0922 | 29016000.0 |
| 2000-02-09 10:00:00 | AMZN | Stock | 4.0906 | 4.1859 | 4.0781 | 4.1125 | 29296000.0 |
| 2000-02-09 11:00:00 | AMZN | Stock | 4.1031 | 4.1313 | 4.05 | 4.0625 | 24424000.0 |
| 2000-02-09 12:00:00 | AMZN | Stock | 4.0625 | 4.0938 | 4.0125 | 4.0594 | 20396000.0 |
| 2000-02-09 13:00:00 | AMZN | Stock | 4.0594 | 4.1375 | 4.0594 | 4.1219 | 23564000.0 |
| 2000-02-09 14:00:00 | AMZN | Stock | 4.125 | 4.15 | 4.0969 | 4.125 | 16752000.0 |
| 2000-02-09 15:00:00 | AMZN | Stock | 4.125 | 4.1469 | 4.0125 | 4.0188 | 24280000.0 |
| 2000-02-09 16:00:00 | AMZN | Stock | 4.0188 | 4.0312 | 4.0125 | 4.0125 | 256000.0 |
| 2000-02-09 09:00:00 | CL | Stock | 29.875 | 29.875 | 29.25 | 29.3125 | 440000.0 |
| 2000-02-09 10:00:00 | CL | Stock | 29.3125 | 29.5625 | 29.0625 | 29.2188 | 711800.0 |
| 2000-02-09 11:00:00 | CL | Stock | 29.2188 | 29.375 | 28.8125 | 29.0625 | 816800.0 |
| 2000-02-09 12:00:00 | CL | Stock | 29.0 | 29.25 | 28.9375 | 29.1875 | 631600.0 |
| 2000-02-09 13:00:00 | CL | Stock | 29.1562 | 29.1562 | 28.9375 | 29.0 | 513000.0 |
| 2000-02-09 14:00:00 | CL | Stock | 28.9375 | 29.1562 | 28.875 | 29.1562 | 564400.0 |
| 2000-02-09 15:00:00 | CL | Stock | 29.125 | 29.1875 | 29.0 | 29.0 | 604200.0 |
| 2000-02-09 16:00:00 | CL | Stock | 29.0938 | 29.0938 | 29.0938 | 29.0938 | 124000.0 |
> showing 40 of 14,530 rows — these rows as CSV