PREVIEW / stock_1hour / 2004-11-03
file: by_date/stock_1hour/2004/2004-11-03.parquet size: 566 KB rows: 26,040 symbols: 1,860
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-03 08:00:00 | AAPL | Stock | 0.9645 | 0.9821 | 0.9645 | 0.9732 | 2954000.0 |
| 2004-11-03 09:00:00 | AAPL | Stock | 0.9732 | 0.978 | 0.9561 | 0.9723 | 135047304.0 |
| 2004-11-03 10:00:00 | AAPL | Stock | 0.9729 | 0.9811 | 0.9641 | 0.9736 | 167269312.0 |
| 2004-11-03 11:00:00 | AAPL | Stock | 0.9736 | 0.9889 | 0.97 | 0.9821 | 162987384.0 |
| 2004-11-03 12:00:00 | AAPL | Stock | 0.9821 | 1.002 | 0.982 | 0.998 | 175295232.0 |
| 2004-11-03 13:00:00 | AAPL | Stock | 0.9982 | 1.0 | 0.9843 | 0.9855 | 195466096.0 |
| 2004-11-03 14:00:00 | AAPL | Stock | 0.9857 | 0.9879 | 0.9791 | 0.9879 | 111793248.0 |
| 2004-11-03 15:00:00 | AAPL | Stock | 0.988 | 0.99 | 0.9795 | 0.9879 | 142566760.0 |
| 2004-11-03 16:00:00 | AAPL | Stock | 0.9879 | 0.99 | 0.987 | 0.9882 | 39810120.0 |
| 2004-11-03 17:00:00 | AAPL | Stock | 0.988 | 0.9889 | 0.9855 | 0.9881 | 337008.0 |
| 2004-11-03 08:00:00 | MSFT | Stock | 28.41 | 28.69 | 28.41 | 28.64 | 235216.0 |
| 2004-11-03 09:00:00 | MSFT | Stock | 28.65 | 28.67 | 28.32 | 28.45 | 11876912.0 |
| 2004-11-03 10:00:00 | MSFT | Stock | 28.44 | 28.54 | 28.36 | 28.46 | 14327991.0 |
| 2004-11-03 11:00:00 | MSFT | Stock | 28.46 | 28.56 | 28.42 | 28.48 | 8655286.0 |
| 2004-11-03 12:00:00 | MSFT | Stock | 28.48 | 28.49 | 28.42 | 28.44 | 4394225.0 |
| 2004-11-03 13:00:00 | MSFT | Stock | 28.44 | 28.54 | 28.44 | 28.5 | 6617678.0 |
| 2004-11-03 14:00:00 | MSFT | Stock | 28.5 | 28.51 | 28.37 | 28.43 | 8816888.0 |
| 2004-11-03 15:00:00 | MSFT | Stock | 28.43 | 28.51 | 28.31 | 28.47 | 15048272.0 |
| 2004-11-03 16:00:00 | MSFT | Stock | 28.51 | 28.53 | 28.35 | 28.46 | 5909440.0 |
| 2004-11-03 17:00:00 | MSFT | Stock | 28.46 | 28.5 | 28.41 | 28.5 | 93650.0 |
| 2004-11-03 18:00:00 | MSFT | Stock | 28.5 | 28.5 | 28.45 | 28.45 | 1014.0 |
| 2004-11-03 08:00:00 | NVDA | Stock | 0.1292 | 0.1292 | 0.1279 | 0.1287 | 2360400.0 |
| 2004-11-03 09:00:00 | NVDA | Stock | 0.1287 | 0.1304 | 0.1257 | 0.1272 | 173179080.0 |
| 2004-11-03 10:00:00 | NVDA | Stock | 0.1272 | 0.1274 | 0.1257 | 0.1267 | 149795760.0 |
| 2004-11-03 11:00:00 | NVDA | Stock | 0.1267 | 0.1279 | 0.1264 | 0.1272 | 105154560.0 |
| 2004-11-03 12:00:00 | NVDA | Stock | 0.1272 | 0.1274 | 0.1267 | 0.1267 | 116292120.0 |
| 2004-11-03 13:00:00 | NVDA | Stock | 0.1267 | 0.1276 | 0.1263 | 0.1272 | 59651760.0 |
| 2004-11-03 14:00:00 | NVDA | Stock | 0.1272 | 0.1272 | 0.1254 | 0.1257 | 100452960.0 |
| 2004-11-03 15:00:00 | NVDA | Stock | 0.1257 | 0.1267 | 0.1254 | 0.1261 | 190606080.0 |
| 2004-11-03 16:00:00 | NVDA | Stock | 0.1258 | 0.1261 | 0.1255 | 0.1261 | 5685720.0 |
| 2004-11-03 17:00:00 | NVDA | Stock | 0.1261 | 0.1261 | 0.1259 | 0.126 | 480360.0 |
| 2004-11-03 18:00:00 | NVDA | Stock | 0.1265 | 0.1265 | 0.1265 | 0.1265 | 12000.0 |
| 2004-11-03 08:00:00 | AMZN | Stock | 1.8395 | 1.855 | 1.833 | 1.85 | 923260.0 |
| 2004-11-03 09:00:00 | AMZN | Stock | 1.8525 | 1.881 | 1.815 | 1.836 | 40235360.0 |
| 2004-11-03 10:00:00 | AMZN | Stock | 1.837 | 1.8405 | 1.812 | 1.836 | 38737120.0 |
| 2004-11-03 11:00:00 | AMZN | Stock | 1.836 | 1.845 | 1.8285 | 1.835 | 26405260.0 |
| 2004-11-03 12:00:00 | AMZN | Stock | 1.8355 | 1.8358 | 1.81 | 1.82 | 19880940.0 |
| 2004-11-03 13:00:00 | AMZN | Stock | 1.8205 | 1.8245 | 1.818 | 1.8195 | 9056280.0 |
| 2004-11-03 14:00:00 | AMZN | Stock | 1.8195 | 1.8195 | 1.78 | 1.7875 | 30896020.0 |
| 2004-11-03 15:00:00 | AMZN | Stock | 1.7875 | 1.7935 | 1.778 | 1.793 | 31038000.0 |
| 2004-11-03 16:00:00 | AMZN | Stock | 1.793 | 1.796 | 1.7895 | 1.7935 | 1850920.0 |
| 2004-11-03 17:00:00 | AMZN | Stock | 1.7885 | 1.796 | 1.7851 | 1.7851 | 1924600.0 |
| 2004-11-03 18:00:00 | AMZN | Stock | 1.7925 | 1.7925 | 1.79 | 1.79 | 8000.0 |
| 2004-11-03 09:00:00 | CL | Stock | 22.775 | 22.785 | 22.56 | 22.61 | 783200.0 |
| 2004-11-03 10:00:00 | CL | Stock | 22.61 | 22.78 | 22.595 | 22.765 | 1138600.0 |
| 2004-11-03 11:00:00 | CL | Stock | 22.77 | 22.805 | 22.7 | 22.76 | 506200.0 |
| 2004-11-03 12:00:00 | CL | Stock | 22.76 | 22.76 | 22.675 | 22.715 | 666000.0 |
| 2004-11-03 13:00:00 | CL | Stock | 22.725 | 22.75 | 22.72 | 22.74 | 470000.0 |
| 2004-11-03 14:00:00 | CL | Stock | 22.74 | 22.75 | 22.675 | 22.73 | 362200.0 |
| 2004-11-03 15:00:00 | CL | Stock | 22.73 | 22.73 | 22.65 | 22.715 | 767800.0 |
> showing 50 of 26,040 rows — these rows as CSV