PREVIEW / stock_1hour / 2003-10-24
file: by_date/stock_1hour/2003/2003-10-24.parquet size: 477 KB rows: 22,079 symbols: 1,635
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-10-24 09:00:00 | AAPL | Stock | 0.4105 | 0.4105 | 0.3988 | 0.4063 | 28978600.0 |
| 2003-10-24 10:00:00 | AAPL | Stock | 0.4064 | 0.4066 | 0.4002 | 0.4025 | 28334880.0 |
| 2003-10-24 11:00:00 | AAPL | Stock | 0.4025 | 0.4034 | 0.3979 | 0.3991 | 22595496.0 |
| 2003-10-24 12:00:00 | AAPL | Stock | 0.399 | 0.3996 | 0.3978 | 0.3989 | 18950232.0 |
| 2003-10-24 13:00:00 | AAPL | Stock | 0.3991 | 0.4 | 0.397 | 0.3973 | 21798280.0 |
| 2003-10-24 14:00:00 | AAPL | Stock | 0.3973 | 0.4013 | 0.3971 | 0.3995 | 28734160.0 |
| 2003-10-24 15:00:00 | AAPL | Stock | 0.3991 | 0.4039 | 0.3989 | 0.4036 | 43058904.0 |
| 2003-10-24 16:00:00 | AAPL | Stock | 0.4036 | 0.4055 | 0.4017 | 0.4045 | 6098400.0 |
| 2003-10-24 17:00:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4036 | 0.4036 | 5600.0 |
| 2003-10-24 08:00:00 | MSFT | Stock | 27.56 | 28.91 | 27.19 | 27.33 | 4649283.0 |
| 2003-10-24 09:00:00 | MSFT | Stock | 27.33 | 28.9 | 26.83 | 27.08 | 40457940.0 |
| 2003-10-24 10:00:00 | MSFT | Stock | 27.08 | 27.14 | 27.01 | 27.09 | 26705455.0 |
| 2003-10-24 11:00:00 | MSFT | Stock | 27.08 | 27.101 | 26.86 | 26.89 | 19597782.0 |
| 2003-10-24 12:00:00 | MSFT | Stock | 26.89 | 26.94 | 26.67 | 26.73 | 20201335.0 |
| 2003-10-24 13:00:00 | MSFT | Stock | 26.73 | 26.8 | 26.52 | 26.55 | 16552626.0 |
| 2003-10-24 14:00:00 | MSFT | Stock | 26.55 | 26.62 | 26.49 | 26.55 | 30643974.0 |
| 2003-10-24 15:00:00 | MSFT | Stock | 26.541 | 26.73 | 26.42 | 26.62 | 32932646.0 |
| 2003-10-24 16:00:00 | MSFT | Stock | 26.62 | 26.9443 | 26.58 | 26.68 | 2012747.0 |
| 2003-10-24 17:00:00 | MSFT | Stock | 26.68 | 27.0919 | 26.61 | 26.64 | 390388.0 |
| 2003-10-24 18:00:00 | MSFT | Stock | 26.64 | 26.66 | 26.64 | 26.66 | 36757.0 |
| 2003-10-24 09:00:00 | NVDA | Stock | 0.1431 | 0.1438 | 0.1406 | 0.1435 | 49344600.0 |
| 2003-10-24 10:00:00 | NVDA | Stock | 0.1433 | 0.1435 | 0.1417 | 0.1426 | 42013080.0 |
| 2003-10-24 11:00:00 | NVDA | Stock | 0.1426 | 0.1434 | 0.141 | 0.1421 | 90325320.0 |
| 2003-10-24 12:00:00 | NVDA | Stock | 0.1419 | 0.1425 | 0.1408 | 0.1416 | 64728840.0 |
| 2003-10-24 13:00:00 | NVDA | Stock | 0.1416 | 0.1417 | 0.1406 | 0.1407 | 38189640.0 |
| 2003-10-24 14:00:00 | NVDA | Stock | 0.1408 | 0.1417 | 0.1406 | 0.1407 | 31521720.0 |
| 2003-10-24 15:00:00 | NVDA | Stock | 0.1408 | 0.143 | 0.1403 | 0.1423 | 90420840.0 |
| 2003-10-24 16:00:00 | NVDA | Stock | 0.1424 | 0.1428 | 0.1417 | 0.1427 | 2503320.0 |
| 2003-10-24 17:00:00 | NVDA | Stock | 0.1426 | 0.1426 | 0.1424 | 0.1426 | 456000.0 |
| 2003-10-24 08:00:00 | AMZN | Stock | 2.714 | 2.73 | 2.7 | 2.7275 | 741000.0 |
| 2003-10-24 09:00:00 | AMZN | Stock | 2.7325 | 2.747 | 2.694 | 2.7175 | 33354360.0 |
| 2003-10-24 10:00:00 | AMZN | Stock | 2.7175 | 2.7435 | 2.7125 | 2.7205 | 31522560.0 |
| 2003-10-24 11:00:00 | AMZN | Stock | 2.7212 | 2.7325 | 2.7 | 2.7035 | 24998500.0 |
| 2003-10-24 12:00:00 | AMZN | Stock | 2.703 | 2.705 | 2.65 | 2.655 | 25280760.0 |
| 2003-10-24 13:00:00 | AMZN | Stock | 2.655 | 2.673 | 2.65 | 2.661 | 18843960.0 |
| 2003-10-24 14:00:00 | AMZN | Stock | 2.661 | 2.694 | 2.657 | 2.685 | 23438560.0 |
| 2003-10-24 15:00:00 | AMZN | Stock | 2.685 | 2.734 | 2.6825 | 2.73 | 33188920.0 |
| 2003-10-24 16:00:00 | AMZN | Stock | 2.73 | 2.7325 | 2.7119 | 2.727 | 1293720.0 |
| 2003-10-24 17:00:00 | AMZN | Stock | 2.7295 | 2.7325 | 2.729 | 2.7315 | 274000.0 |
| 2003-10-24 18:00:00 | AMZN | Stock | 2.732 | 2.7325 | 2.731 | 2.7325 | 40000.0 |
| 2003-10-24 09:00:00 | CL | Stock | 26.595 | 26.595 | 26.35 | 26.495 | 1458400.0 |
| 2003-10-24 10:00:00 | CL | Stock | 26.5 | 26.525 | 26.175 | 26.185 | 1975000.0 |
| 2003-10-24 11:00:00 | CL | Stock | 26.185 | 26.25 | 26.02 | 26.025 | 1819800.0 |
| 2003-10-24 12:00:00 | CL | Stock | 26.0 | 26.07 | 25.65 | 25.85 | 2094000.0 |
| 2003-10-24 13:00:00 | CL | Stock | 25.85 | 26.005 | 25.73 | 25.78 | 1061400.0 |
| 2003-10-24 14:00:00 | CL | Stock | 25.775 | 25.87 | 25.7 | 25.72 | 2077400.0 |
| 2003-10-24 15:00:00 | CL | Stock | 25.725 | 25.875 | 25.655 | 25.87 | 2727600.0 |
| 2003-10-24 16:00:00 | CL | Stock | 25.875 | 25.925 | 25.875 | 25.925 | 257600.0 |
| 2003-10-24 17:00:00 | CL | Stock | 26.2884 | 26.2884 | 25.875 | 25.88 | 2200.0 |
> showing 49 of 22,079 rows — these rows as CSV