PREVIEW / stock_1hour / 2003-02-14
file: by_date/stock_1hour/2003/2003-02-14.parquet size: 404 KB rows: 19,577 symbols: 1,541
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 |
|---|---|---|---|---|---|---|---|
| 2003-02-14 08:00:00 | AAPL | Stock | 0.2621 | 0.2625 | 0.262 | 0.262 | 176400.0 |
| 2003-02-14 09:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2563 | 0.257 | 33533864.0 |
| 2003-02-14 10:00:00 | AAPL | Stock | 0.2571 | 0.2629 | 0.257 | 0.2607 | 40064640.0 |
| 2003-02-14 11:00:00 | AAPL | Stock | 0.2607 | 0.2608 | 0.2573 | 0.2575 | 27173888.0 |
| 2003-02-14 12:00:00 | AAPL | Stock | 0.2575 | 0.258 | 0.2563 | 0.2577 | 16908248.0 |
| 2003-02-14 13:00:00 | AAPL | Stock | 0.2577 | 0.2586 | 0.2577 | 0.2584 | 11041912.0 |
| 2003-02-14 14:00:00 | AAPL | Stock | 0.2584 | 0.2586 | 0.2563 | 0.2579 | 20642384.0 |
| 2003-02-14 15:00:00 | AAPL | Stock | 0.2577 | 0.2621 | 0.257 | 0.262 | 40591600.0 |
| 2003-02-14 16:00:00 | AAPL | Stock | 0.262 | 0.2632 | 0.26 | 0.2621 | 3190768.0 |
| 2003-02-14 17:00:00 | AAPL | Stock | 0.2618 | 0.262 | 0.2618 | 0.262 | 151200.0 |
| 2003-02-14 18:00:00 | AAPL | Stock | 0.2618 | 0.2618 | 0.2618 | 0.2618 | 5600.0 |
| 2003-02-14 08:00:00 | MSFT | Stock | 23.64 | 23.665 | 23.519 | 23.61 | 205360.0 |
| 2003-02-14 09:00:00 | MSFT | Stock | 23.61 | 23.75 | 23.45 | 23.525 | 10508582.0 |
| 2003-02-14 10:00:00 | MSFT | Stock | 23.53 | 23.965 | 23.4915 | 23.8395 | 15107984.0 |
| 2003-02-14 11:00:00 | MSFT | Stock | 23.844 | 23.875 | 23.4245 | 23.4595 | 10418174.0 |
| 2003-02-14 12:00:00 | MSFT | Stock | 23.45 | 23.619 | 23.385 | 23.57 | 7114752.0 |
| 2003-02-14 13:00:00 | MSFT | Stock | 23.57 | 23.7 | 23.555 | 23.645 | 6479204.0 |
| 2003-02-14 14:00:00 | MSFT | Stock | 23.64 | 23.75 | 23.565 | 23.72 | 5702384.0 |
| 2003-02-14 15:00:00 | MSFT | Stock | 23.72 | 24.195 | 23.71 | 24.14 | 14922344.0 |
| 2003-02-14 16:00:00 | MSFT | Stock | 24.1405 | 24.25 | 23.8507 | 24.17 | 9920764.0 |
| 2003-02-14 17:00:00 | MSFT | Stock | 24.1845 | 24.195 | 24.15 | 24.185 | 114946.0 |
| 2003-02-14 18:00:00 | MSFT | Stock | 24.195 | 24.225 | 24.155 | 24.18 | 38188.0 |
| 2003-02-14 08:00:00 | NVDA | Stock | 0.0904 | 0.0937 | 0.0892 | 0.0917 | 65205000.0 |
| 2003-02-14 09:00:00 | NVDA | Stock | 0.0917 | 0.0938 | 0.0896 | 0.0923 | 693117240.0 |
| 2003-02-14 10:00:00 | NVDA | Stock | 0.0924 | 0.0978 | 0.0923 | 0.0958 | 892553880.0 |
| 2003-02-14 11:00:00 | NVDA | Stock | 0.0958 | 0.0971 | 0.0954 | 0.0958 | 445021560.0 |
| 2003-02-14 12:00:00 | NVDA | Stock | 0.0958 | 0.0971 | 0.0953 | 0.0965 | 200399400.0 |
| 2003-02-14 13:00:00 | NVDA | Stock | 0.0965 | 0.097 | 0.0962 | 0.0967 | 120671520.0 |
| 2003-02-14 14:00:00 | NVDA | Stock | 0.0967 | 0.0983 | 0.0962 | 0.0983 | 283483440.0 |
| 2003-02-14 15:00:00 | NVDA | Stock | 0.0982 | 0.1004 | 0.0982 | 0.1 | 537299160.0 |
| 2003-02-14 16:00:00 | NVDA | Stock | 0.1003 | 0.1012 | 0.1 | 0.1007 | 19711320.0 |
| 2003-02-14 17:00:00 | NVDA | Stock | 0.1008 | 0.1012 | 0.1003 | 0.101 | 3590640.0 |
| 2003-02-14 18:00:00 | NVDA | Stock | 0.101 | 0.1016 | 0.101 | 0.1015 | 1533000.0 |
| 2003-02-14 08:00:00 | AMZN | Stock | 1.01 | 1.01 | 1.003 | 1.003 | 48920.0 |
| 2003-02-14 09:00:00 | AMZN | Stock | 1.004 | 1.0085 | 0.9931 | 0.9945 | 17911000.0 |
| 2003-02-14 10:00:00 | AMZN | Stock | 0.9945 | 1.0115 | 0.989 | 1.002 | 30414660.0 |
| 2003-02-14 11:00:00 | AMZN | Stock | 1.002 | 1.003 | 0.9855 | 0.9905 | 13389520.0 |
| 2003-02-14 12:00:00 | AMZN | Stock | 0.9905 | 0.995 | 0.9885 | 0.9915 | 9068780.0 |
| 2003-02-14 13:00:00 | AMZN | Stock | 0.992 | 1.0075 | 0.9858 | 0.9935 | 12673880.0 |
| 2003-02-14 14:00:00 | AMZN | Stock | 0.994 | 0.9945 | 0.9875 | 0.9945 | 11857120.0 |
| 2003-02-14 15:00:00 | AMZN | Stock | 0.994 | 1.0045 | 0.993 | 1.0025 | 16125600.0 |
| 2003-02-14 16:00:00 | AMZN | Stock | 1.0035 | 1.005 | 0.998 | 1.005 | 1628420.0 |
| 2003-02-14 17:00:00 | AMZN | Stock | 1.006 | 1.007 | 1.003 | 1.0045 | 36000.0 |
| 2003-02-14 09:00:00 | CL | Stock | 25.195 | 25.225 | 25.12 | 25.19 | 247600.0 |
| 2003-02-14 10:00:00 | CL | Stock | 25.19 | 25.305 | 25.0 | 25.16 | 429400.0 |
| 2003-02-14 11:00:00 | CL | Stock | 25.16 | 25.175 | 24.825 | 24.925 | 346600.0 |
| 2003-02-14 12:00:00 | CL | Stock | 24.925 | 25.04 | 24.905 | 24.98 | 169800.0 |
| 2003-02-14 13:00:00 | CL | Stock | 24.975 | 25.125 | 24.975 | 25.03 | 217800.0 |
| 2003-02-14 14:00:00 | CL | Stock | 25.04 | 25.05 | 24.955 | 25.04 | 193600.0 |
| 2003-02-14 15:00:00 | CL | Stock | 25.04 | 25.35 | 25.04 | 25.35 | 553400.0 |
> showing 50 of 19,577 rows — these rows as CSV