PREVIEW / stock_1hour / 2003-08-21
file: by_date/stock_1hour/2003/2003-08-21.parquet size: 474 KB rows: 21,881 symbols: 1,614
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-08-21 08:00:00 | AAPL | Stock | 0.3775 | 0.3775 | 0.3775 | 0.3775 | 112000.0 |
| 2003-08-21 09:00:00 | AAPL | Stock | 0.3771 | 0.3814 | 0.3741 | 0.3814 | 25515560.0 |
| 2003-08-21 10:00:00 | AAPL | Stock | 0.3814 | 0.3876 | 0.3804 | 0.3859 | 53472328.0 |
| 2003-08-21 11:00:00 | AAPL | Stock | 0.3859 | 0.3863 | 0.3779 | 0.3795 | 43309840.0 |
| 2003-08-21 12:00:00 | AAPL | Stock | 0.3793 | 0.3857 | 0.3793 | 0.3814 | 31754520.0 |
| 2003-08-21 13:00:00 | AAPL | Stock | 0.3814 | 0.3818 | 0.3795 | 0.3818 | 13535816.0 |
| 2003-08-21 14:00:00 | AAPL | Stock | 0.3818 | 0.3838 | 0.3816 | 0.3834 | 17175984.0 |
| 2003-08-21 15:00:00 | AAPL | Stock | 0.3834 | 0.3873 | 0.3829 | 0.3861 | 41385792.0 |
| 2003-08-21 16:00:00 | AAPL | Stock | 0.3857 | 0.3871 | 0.3848 | 0.3868 | 3459568.0 |
| 2003-08-21 18:00:00 | AAPL | Stock | 0.3871 | 0.3871 | 0.3848 | 0.3848 | 257600.0 |
| 2003-08-21 08:00:00 | MSFT | Stock | 26.505 | 26.651 | 26.48 | 26.6 | 74506.0 |
| 2003-08-21 09:00:00 | MSFT | Stock | 26.601 | 26.69 | 26.48 | 26.66 | 6580263.0 |
| 2003-08-21 10:00:00 | MSFT | Stock | 26.65 | 26.73 | 26.53 | 26.65 | 8021508.0 |
| 2003-08-21 11:00:00 | MSFT | Stock | 26.65 | 26.69 | 26.15 | 26.32 | 12046008.0 |
| 2003-08-21 12:00:00 | MSFT | Stock | 26.31 | 26.45 | 26.23 | 26.26 | 7677334.0 |
| 2003-08-21 13:00:00 | MSFT | Stock | 26.26 | 26.32 | 26.17 | 26.29 | 4303669.0 |
| 2003-08-21 14:00:00 | MSFT | Stock | 26.28 | 26.31 | 26.15 | 26.151 | 6735596.0 |
| 2003-08-21 15:00:00 | MSFT | Stock | 26.16 | 26.32 | 26.15 | 26.24 | 8633278.0 |
| 2003-08-21 16:00:00 | MSFT | Stock | 26.23 | 26.27 | 26.01 | 26.19 | 968961.0 |
| 2003-08-21 17:00:00 | MSFT | Stock | 26.18 | 26.3866 | 26.17 | 26.22 | 47200.0 |
| 2003-08-21 18:00:00 | MSFT | Stock | 26.2 | 26.22 | 26.19 | 26.2 | 6500.0 |
| 2003-08-21 08:00:00 | NVDA | Stock | 0.1483 | 0.1509 | 0.1472 | 0.1502 | 5334000.0 |
| 2003-08-21 09:00:00 | NVDA | Stock | 0.1508 | 0.1525 | 0.15 | 0.1518 | 116295840.0 |
| 2003-08-21 10:00:00 | NVDA | Stock | 0.1519 | 0.1521 | 0.1502 | 0.1517 | 120863040.0 |
| 2003-08-21 11:00:00 | NVDA | Stock | 0.1517 | 0.1519 | 0.1483 | 0.1497 | 98040240.0 |
| 2003-08-21 12:00:00 | NVDA | Stock | 0.1497 | 0.1507 | 0.1492 | 0.1495 | 61617000.0 |
| 2003-08-21 13:00:00 | NVDA | Stock | 0.1495 | 0.1512 | 0.1495 | 0.151 | 49275120.0 |
| 2003-08-21 14:00:00 | NVDA | Stock | 0.151 | 0.1516 | 0.1499 | 0.1502 | 49722120.0 |
| 2003-08-21 15:00:00 | NVDA | Stock | 0.1502 | 0.1516 | 0.1502 | 0.1512 | 88648440.0 |
| 2003-08-21 16:00:00 | NVDA | Stock | 0.1512 | 0.1519 | 0.1508 | 0.1517 | 7906440.0 |
| 2003-08-21 17:00:00 | NVDA | Stock | 0.1511 | 0.1517 | 0.1508 | 0.1517 | 3144000.0 |
| 2003-08-21 08:00:00 | AMZN | Stock | 2.1885 | 2.2125 | 2.1885 | 2.2125 | 239760.0 |
| 2003-08-21 09:00:00 | AMZN | Stock | 2.205 | 2.2755 | 2.1935 | 2.2115 | 18998700.0 |
| 2003-08-21 10:00:00 | AMZN | Stock | 2.21 | 2.2325 | 2.2085 | 2.227 | 29702400.0 |
| 2003-08-21 11:00:00 | AMZN | Stock | 2.2268 | 2.2275 | 2.2055 | 2.224 | 24623920.0 |
| 2003-08-21 12:00:00 | AMZN | Stock | 2.224 | 2.235 | 2.221 | 2.2315 | 26430940.0 |
| 2003-08-21 13:00:00 | AMZN | Stock | 2.232 | 2.2475 | 2.2305 | 2.243 | 22666000.0 |
| 2003-08-21 14:00:00 | AMZN | Stock | 2.2435 | 2.2625 | 2.24 | 2.2585 | 31580740.0 |
| 2003-08-21 15:00:00 | AMZN | Stock | 2.258 | 2.2955 | 2.2545 | 2.289 | 49655300.0 |
| 2003-08-21 16:00:00 | AMZN | Stock | 2.288 | 2.3 | 2.2746 | 2.295 | 2521920.0 |
| 2003-08-21 17:00:00 | AMZN | Stock | 2.297 | 2.305 | 2.29 | 2.2995 | 456500.0 |
| 2003-08-21 18:00:00 | AMZN | Stock | 2.298 | 2.298 | 2.295 | 2.2951 | 52000.0 |
| 2003-08-21 09:00:00 | CL | Stock | 27.24 | 27.33 | 27.135 | 27.33 | 209000.0 |
| 2003-08-21 10:00:00 | CL | Stock | 27.325 | 27.395 | 27.295 | 27.335 | 354600.0 |
| 2003-08-21 11:00:00 | CL | Stock | 27.33 | 27.33 | 27.125 | 27.21 | 387200.0 |
| 2003-08-21 12:00:00 | CL | Stock | 27.2 | 27.275 | 27.14 | 27.155 | 292800.0 |
| 2003-08-21 13:00:00 | CL | Stock | 27.155 | 27.215 | 27.13 | 27.19 | 306200.0 |
| 2003-08-21 14:00:00 | CL | Stock | 27.18 | 27.21 | 27.14 | 27.155 | 407200.0 |
| 2003-08-21 15:00:00 | CL | Stock | 27.16 | 27.23 | 27.075 | 27.18 | 542400.0 |
| 2003-08-21 16:00:00 | CL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 53800.0 |
> showing 50 of 21,881 rows — these rows as CSV