PREVIEW / stock_1hour / 2004-10-13
file: by_date/stock_1hour/2004/2004-10-13.parquet size: 525 KB rows: 24,215 symbols: 1,831
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-13 08:00:00 | AAPL | Stock | 0.6893 | 0.6929 | 0.6893 | 0.692 | 1074640.0 |
| 2004-10-13 09:00:00 | AAPL | Stock | 0.6923 | 0.7071 | 0.6918 | 0.7032 | 144507944.0 |
| 2004-10-13 10:00:00 | AAPL | Stock | 0.7036 | 0.7036 | 0.6945 | 0.6968 | 120328432.0 |
| 2004-10-13 11:00:00 | AAPL | Stock | 0.6968 | 0.6982 | 0.692 | 0.6959 | 76161848.0 |
| 2004-10-13 12:00:00 | AAPL | Stock | 0.6961 | 0.6979 | 0.6946 | 0.6966 | 52415944.0 |
| 2004-10-13 13:00:00 | AAPL | Stock | 0.6966 | 0.6991 | 0.6918 | 0.6938 | 72899400.0 |
| 2004-10-13 14:00:00 | AAPL | Stock | 0.6939 | 0.6993 | 0.692 | 0.6993 | 69448512.0 |
| 2004-10-13 15:00:00 | AAPL | Stock | 0.6993 | 0.71 | 0.6961 | 0.7082 | 208774160.0 |
| 2004-10-13 16:00:00 | AAPL | Stock | 0.7082 | 0.7571 | 0.7005 | 0.75 | 338709896.0 |
| 2004-10-13 17:00:00 | AAPL | Stock | 0.7505 | 0.7621 | 0.7013 | 0.757 | 63914256.0 |
| 2004-10-13 18:00:00 | AAPL | Stock | 0.757 | 0.7607 | 0.755 | 0.7573 | 5420856.0 |
| 2004-10-13 08:00:00 | MSFT | Stock | 28.14 | 28.22 | 28.14 | 28.21 | 20490.0 |
| 2004-10-13 09:00:00 | MSFT | Stock | 28.21 | 28.25 | 28.05 | 28.17 | 5551862.0 |
| 2004-10-13 10:00:00 | MSFT | Stock | 28.17 | 28.21 | 28.11 | 28.13 | 6434528.0 |
| 2004-10-13 11:00:00 | MSFT | Stock | 28.13 | 28.181 | 28.07 | 28.16 | 6695364.0 |
| 2004-10-13 12:00:00 | MSFT | Stock | 28.17 | 28.27 | 28.15 | 28.17 | 4857396.0 |
| 2004-10-13 13:00:00 | MSFT | Stock | 28.16 | 28.22 | 27.94 | 28.0 | 9078910.0 |
| 2004-10-13 14:00:00 | MSFT | Stock | 28.0 | 28.13 | 27.98 | 28.04 | 8248593.0 |
| 2004-10-13 15:00:00 | MSFT | Stock | 28.03 | 28.09 | 27.98 | 28.01 | 5106488.0 |
| 2004-10-13 16:00:00 | MSFT | Stock | 28.0 | 28.11 | 28.0 | 28.03 | 1163878.0 |
| 2004-10-13 17:00:00 | MSFT | Stock | 28.03 | 28.0531 | 28.02 | 28.02 | 47055.0 |
| 2004-10-13 18:00:00 | MSFT | Stock | 28.02 | 28.04 | 28.02 | 28.04 | 8107.0 |
| 2004-10-13 08:00:00 | NVDA | Stock | 0.1225 | 0.1227 | 0.1221 | 0.1221 | 472200.0 |
| 2004-10-13 09:00:00 | NVDA | Stock | 0.1221 | 0.1245 | 0.1193 | 0.1233 | 79148520.0 |
| 2004-10-13 10:00:00 | NVDA | Stock | 0.1233 | 0.1237 | 0.1202 | 0.1206 | 193327440.0 |
| 2004-10-13 11:00:00 | NVDA | Stock | 0.1206 | 0.1207 | 0.1192 | 0.1195 | 109594440.0 |
| 2004-10-13 12:00:00 | NVDA | Stock | 0.1195 | 0.1201 | 0.1189 | 0.1193 | 63830520.0 |
| 2004-10-13 13:00:00 | NVDA | Stock | 0.1192 | 0.12 | 0.1179 | 0.1182 | 66177960.0 |
| 2004-10-13 14:00:00 | NVDA | Stock | 0.1182 | 0.1189 | 0.1176 | 0.118 | 54385680.0 |
| 2004-10-13 15:00:00 | NVDA | Stock | 0.1179 | 0.1189 | 0.1179 | 0.1187 | 90298800.0 |
| 2004-10-13 16:00:00 | NVDA | Stock | 0.1187 | 0.1187 | 0.1178 | 0.1178 | 5547480.0 |
| 2004-10-13 17:00:00 | NVDA | Stock | 0.1181 | 0.1184 | 0.1167 | 0.1167 | 396000.0 |
| 2004-10-13 18:00:00 | NVDA | Stock | 0.1167 | 0.1167 | 0.1167 | 0.1167 | 120360.0 |
| 2004-10-13 08:00:00 | AMZN | Stock | 2.046 | 2.062 | 2.0375 | 2.0575 | 850700.0 |
| 2004-10-13 09:00:00 | AMZN | Stock | 2.058 | 2.0775 | 2.011 | 2.0445 | 32502400.0 |
| 2004-10-13 10:00:00 | AMZN | Stock | 2.044 | 2.045 | 2.027 | 2.0375 | 24659840.0 |
| 2004-10-13 11:00:00 | AMZN | Stock | 2.0375 | 2.049 | 2.0295 | 2.04 | 26172680.0 |
| 2004-10-13 12:00:00 | AMZN | Stock | 2.0395 | 2.041 | 2.032 | 2.039 | 13316520.0 |
| 2004-10-13 13:00:00 | AMZN | Stock | 2.0395 | 2.042 | 1.997 | 2.005 | 27721880.0 |
| 2004-10-13 14:00:00 | AMZN | Stock | 2.005 | 2.0145 | 2.002 | 2.0045 | 23959120.0 |
| 2004-10-13 15:00:00 | AMZN | Stock | 2.004 | 2.007 | 1.9875 | 1.999 | 27427200.0 |
| 2004-10-13 16:00:00 | AMZN | Stock | 1.9995 | 2.0276 | 1.9965 | 1.9965 | 1673460.0 |
| 2004-10-13 17:00:00 | AMZN | Stock | 1.9965 | 1.9998 | 1.9875 | 1.9875 | 46000.0 |
| 2004-10-13 08:00:00 | CL | Stock | 21.785 | 21.825 | 21.785 | 21.825 | 5400.0 |
| 2004-10-13 09:00:00 | CL | Stock | 21.84 | 21.845 | 21.655 | 21.74 | 1110000.0 |
| 2004-10-13 10:00:00 | CL | Stock | 21.735 | 21.75 | 21.56 | 21.62 | 1393400.0 |
| 2004-10-13 11:00:00 | CL | Stock | 21.625 | 21.725 | 21.605 | 21.715 | 885000.0 |
| 2004-10-13 12:00:00 | CL | Stock | 21.715 | 21.795 | 21.685 | 21.75 | 1352000.0 |
| 2004-10-13 13:00:00 | CL | Stock | 21.75 | 21.76 | 21.635 | 21.645 | 1315600.0 |
| 2004-10-13 14:00:00 | CL | Stock | 21.65 | 21.685 | 21.605 | 21.675 | 1251800.0 |
> showing 50 of 24,215 rows — these rows as CSV