PREVIEW / stock_1hour / 2004-10-12
file: by_date/stock_1hour/2004/2004-10-12.parquet size: 505 KB rows: 23,600 symbols: 1,841
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-10-12 08:00:00 | AAPL | Stock | 0.6888 | 0.6938 | 0.6827 | 0.6836 | 184800.0 |
| 2004-10-12 09:00:00 | AAPL | Stock | 0.6834 | 0.6875 | 0.6752 | 0.6764 | 61615624.0 |
| 2004-10-12 10:00:00 | AAPL | Stock | 0.6763 | 0.6807 | 0.6723 | 0.6795 | 67247040.0 |
| 2004-10-12 11:00:00 | AAPL | Stock | 0.6798 | 0.6889 | 0.6795 | 0.6868 | 53104296.0 |
| 2004-10-12 12:00:00 | AAPL | Stock | 0.6868 | 0.687 | 0.6836 | 0.6855 | 46565344.0 |
| 2004-10-12 13:00:00 | AAPL | Stock | 0.6855 | 0.6884 | 0.6846 | 0.6863 | 38981152.0 |
| 2004-10-12 14:00:00 | AAPL | Stock | 0.6866 | 0.6866 | 0.6838 | 0.6859 | 42762216.0 |
| 2004-10-12 15:00:00 | AAPL | Stock | 0.6857 | 0.6873 | 0.6829 | 0.685 | 102431168.0 |
| 2004-10-12 16:00:00 | AAPL | Stock | 0.685 | 0.6911 | 0.683 | 0.6911 | 6587616.0 |
| 2004-10-12 17:00:00 | AAPL | Stock | 0.6911 | 0.6911 | 0.6838 | 0.69 | 280336.0 |
| 2004-10-12 18:00:00 | AAPL | Stock | 0.69 | 0.6911 | 0.6877 | 0.6911 | 227080.0 |
| 2004-10-12 08:00:00 | MSFT | Stock | 27.94 | 27.94 | 27.81 | 27.88 | 21183.0 |
| 2004-10-12 09:00:00 | MSFT | Stock | 27.87 | 27.97 | 27.81 | 27.939 | 7283303.0 |
| 2004-10-12 10:00:00 | MSFT | Stock | 27.94 | 27.99 | 27.9 | 27.94 | 9248833.0 |
| 2004-10-12 11:00:00 | MSFT | Stock | 27.94 | 27.96 | 27.91 | 27.96 | 5799194.0 |
| 2004-10-12 12:00:00 | MSFT | Stock | 27.96 | 27.96 | 27.89 | 27.92 | 6020743.0 |
| 2004-10-12 13:00:00 | MSFT | Stock | 27.92 | 27.97 | 27.9 | 27.95 | 5459492.0 |
| 2004-10-12 14:00:00 | MSFT | Stock | 27.94 | 28.08 | 27.919 | 28.06 | 11308268.0 |
| 2004-10-12 15:00:00 | MSFT | Stock | 28.06 | 28.16 | 27.9951 | 28.05 | 9415927.0 |
| 2004-10-12 16:00:00 | MSFT | Stock | 28.06 | 28.19 | 27.93 | 28.17 | 465014.0 |
| 2004-10-12 17:00:00 | MSFT | Stock | 28.18 | 28.18 | 28.03 | 28.14 | 25279.0 |
| 2004-10-12 18:00:00 | MSFT | Stock | 28.15 | 28.17 | 28.15 | 28.17 | 2403.0 |
| 2004-10-12 08:00:00 | NVDA | Stock | 0.1171 | 0.1171 | 0.1167 | 0.1168 | 540000.0 |
| 2004-10-12 09:00:00 | NVDA | Stock | 0.1172 | 0.1187 | 0.1158 | 0.1162 | 131258040.0 |
| 2004-10-12 10:00:00 | NVDA | Stock | 0.1162 | 0.1167 | 0.1151 | 0.1164 | 125208360.0 |
| 2004-10-12 11:00:00 | NVDA | Stock | 0.1165 | 0.1175 | 0.1163 | 0.1172 | 91466880.0 |
| 2004-10-12 12:00:00 | NVDA | Stock | 0.1172 | 0.1173 | 0.1167 | 0.1171 | 66044760.0 |
| 2004-10-12 13:00:00 | NVDA | Stock | 0.1171 | 0.1172 | 0.1165 | 0.1166 | 44348400.0 |
| 2004-10-12 14:00:00 | NVDA | Stock | 0.1166 | 0.1188 | 0.1162 | 0.1183 | 127135920.0 |
| 2004-10-12 15:00:00 | NVDA | Stock | 0.1183 | 0.1202 | 0.1183 | 0.1192 | 196108080.0 |
| 2004-10-12 16:00:00 | NVDA | Stock | 0.1192 | 0.1215 | 0.1192 | 0.1215 | 1848000.0 |
| 2004-10-12 17:00:00 | NVDA | Stock | 0.1193 | 0.1221 | 0.1193 | 0.1221 | 1607880.0 |
| 2004-10-12 18:00:00 | NVDA | Stock | 0.1221 | 0.1221 | 0.1221 | 0.1221 | 144000.0 |
| 2004-10-12 08:00:00 | AMZN | Stock | 1.9905 | 1.9905 | 1.9765 | 1.987 | 45360.0 |
| 2004-10-12 09:00:00 | AMZN | Stock | 1.987 | 1.9945 | 1.9765 | 1.9831 | 18048400.0 |
| 2004-10-12 10:00:00 | AMZN | Stock | 1.983 | 1.998 | 1.9735 | 1.998 | 22896100.0 |
| 2004-10-12 11:00:00 | AMZN | Stock | 1.998 | 2.0095 | 1.991 | 2.0015 | 15826120.0 |
| 2004-10-12 12:00:00 | AMZN | Stock | 2.002 | 2.0065 | 1.999 | 2.0055 | 10711220.0 |
| 2004-10-12 13:00:00 | AMZN | Stock | 2.0055 | 2.012 | 2.0015 | 2.0095 | 9571700.0 |
| 2004-10-12 14:00:00 | AMZN | Stock | 2.0095 | 2.029 | 2.007 | 2.024 | 21938300.0 |
| 2004-10-12 15:00:00 | AMZN | Stock | 2.024 | 2.025 | 2.0045 | 2.011 | 22226860.0 |
| 2004-10-12 16:00:00 | AMZN | Stock | 2.013 | 2.0575 | 1.9915 | 2.0215 | 4716060.0 |
| 2004-10-12 17:00:00 | AMZN | Stock | 2.0111 | 2.0275 | 2.0071 | 2.025 | 1639760.0 |
| 2004-10-12 18:00:00 | AMZN | Stock | 2.025 | 2.025 | 2.021 | 2.025 | 432120.0 |
| 2004-10-12 09:00:00 | CL | Stock | 21.925 | 21.96 | 21.86 | 21.91 | 692600.0 |
| 2004-10-12 10:00:00 | CL | Stock | 21.905 | 21.91 | 21.81 | 21.82 | 1552200.0 |
| 2004-10-12 11:00:00 | CL | Stock | 21.82 | 21.835 | 21.76 | 21.805 | 1578400.0 |
| 2004-10-12 12:00:00 | CL | Stock | 21.805 | 21.81 | 21.74 | 21.74 | 1871200.0 |
| 2004-10-12 13:00:00 | CL | Stock | 21.74 | 21.745 | 21.65 | 21.71 | 1159800.0 |
| 2004-10-12 14:00:00 | CL | Stock | 21.71 | 21.78 | 21.675 | 21.765 | 936600.0 |
> showing 50 of 23,600 rows — these rows as CSV