PREVIEW / stock_1hour / 2004-09-22
file: by_date/stock_1hour/2004/2004-09-22.parquet size: 501 KB rows: 23,531 symbols: 1,827
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-09-22 08:00:00 | AAPL | Stock | 0.6773 | 0.6839 | 0.6711 | 0.6834 | 162400.0 |
| 2004-09-22 09:00:00 | AAPL | Stock | 0.6777 | 0.6838 | 0.6729 | 0.6741 | 47842312.0 |
| 2004-09-22 10:00:00 | AAPL | Stock | 0.6741 | 0.6752 | 0.66 | 0.6639 | 88418008.0 |
| 2004-09-22 11:00:00 | AAPL | Stock | 0.6639 | 0.6668 | 0.6598 | 0.66 | 50098776.0 |
| 2004-09-22 12:00:00 | AAPL | Stock | 0.66 | 0.6673 | 0.6573 | 0.6634 | 72762368.0 |
| 2004-09-22 13:00:00 | AAPL | Stock | 0.6636 | 0.6671 | 0.6629 | 0.6638 | 29421168.0 |
| 2004-09-22 14:00:00 | AAPL | Stock | 0.6636 | 0.6636 | 0.66 | 0.6613 | 39073216.0 |
| 2004-09-22 15:00:00 | AAPL | Stock | 0.6613 | 0.6625 | 0.6573 | 0.6593 | 59969672.0 |
| 2004-09-22 16:00:00 | AAPL | Stock | 0.6595 | 0.6607 | 0.6582 | 0.6593 | 5171936.0 |
| 2004-09-22 18:00:00 | AAPL | Stock | 0.6589 | 0.6589 | 0.6582 | 0.6582 | 98000.0 |
| 2004-09-22 08:00:00 | MSFT | Stock | 27.26 | 27.28 | 27.22 | 27.22 | 36561.0 |
| 2004-09-22 09:00:00 | MSFT | Stock | 27.23 | 27.27 | 27.2 | 27.27 | 7015452.0 |
| 2004-09-22 10:00:00 | MSFT | Stock | 27.26 | 27.29 | 27.2 | 27.21 | 9828556.0 |
| 2004-09-22 11:00:00 | MSFT | Stock | 27.21 | 27.25 | 27.19 | 27.2 | 7723516.0 |
| 2004-09-22 12:00:00 | MSFT | Stock | 27.2 | 27.22 | 27.12 | 27.14 | 7498303.0 |
| 2004-09-22 13:00:00 | MSFT | Stock | 27.14 | 27.21 | 27.11 | 27.11 | 7294680.0 |
| 2004-09-22 14:00:00 | MSFT | Stock | 27.12 | 27.191 | 27.09 | 27.159 | 13405847.0 |
| 2004-09-22 15:00:00 | MSFT | Stock | 27.16 | 27.18 | 27.07 | 27.12 | 12273822.0 |
| 2004-09-22 16:00:00 | MSFT | Stock | 27.11 | 27.1808 | 27.1098 | 27.14 | 742800.0 |
| 2004-09-22 17:00:00 | MSFT | Stock | 27.11 | 27.12 | 27.11 | 27.11 | 499600.0 |
| 2004-09-22 18:00:00 | MSFT | Stock | 27.13 | 27.13 | 27.12 | 27.12 | 2500.0 |
| 2004-09-22 08:00:00 | NVDA | Stock | 0.1235 | 0.1237 | 0.1227 | 0.1227 | 912000.0 |
| 2004-09-22 09:00:00 | NVDA | Stock | 0.1229 | 0.1252 | 0.1221 | 0.1244 | 62954400.0 |
| 2004-09-22 10:00:00 | NVDA | Stock | 0.1244 | 0.1247 | 0.1208 | 0.121 | 154309920.0 |
| 2004-09-22 11:00:00 | NVDA | Stock | 0.1209 | 0.1212 | 0.12 | 0.1207 | 80898240.0 |
| 2004-09-22 12:00:00 | NVDA | Stock | 0.1207 | 0.1217 | 0.1207 | 0.1212 | 31239840.0 |
| 2004-09-22 13:00:00 | NVDA | Stock | 0.1212 | 0.1222 | 0.1202 | 0.1203 | 54319680.0 |
| 2004-09-22 14:00:00 | NVDA | Stock | 0.1203 | 0.1211 | 0.1201 | 0.1204 | 54661320.0 |
| 2004-09-22 15:00:00 | NVDA | Stock | 0.1203 | 0.1205 | 0.1191 | 0.1197 | 144838680.0 |
| 2004-09-22 16:00:00 | NVDA | Stock | 0.1198 | 0.1199 | 0.1192 | 0.1192 | 3875880.0 |
| 2004-09-22 17:00:00 | NVDA | Stock | 0.1187 | 0.1187 | 0.1187 | 0.1187 | 72000.0 |
| 2004-09-22 18:00:00 | NVDA | Stock | 0.1196 | 0.1196 | 0.1196 | 0.1196 | 146040.0 |
| 2004-09-22 08:00:00 | AMZN | Stock | 2.1965 | 2.1965 | 2.1445 | 2.148 | 55300.0 |
| 2004-09-22 09:00:00 | AMZN | Stock | 2.15 | 2.161 | 2.127 | 2.13 | 32301780.0 |
| 2004-09-22 10:00:00 | AMZN | Stock | 2.13 | 2.1325 | 2.086 | 2.0895 | 68734280.0 |
| 2004-09-22 11:00:00 | AMZN | Stock | 2.0895 | 2.102 | 2.084 | 2.093 | 29169980.0 |
| 2004-09-22 12:00:00 | AMZN | Stock | 2.092 | 2.104 | 2.088 | 2.098 | 14200200.0 |
| 2004-09-22 13:00:00 | AMZN | Stock | 2.0975 | 2.1085 | 2.077 | 2.0785 | 23014220.0 |
| 2004-09-22 14:00:00 | AMZN | Stock | 2.0785 | 2.0825 | 2.0585 | 2.0715 | 36541820.0 |
| 2004-09-22 15:00:00 | AMZN | Stock | 2.0715 | 2.073 | 2.059 | 2.0705 | 32440160.0 |
| 2004-09-22 16:00:00 | AMZN | Stock | 2.07 | 2.0745 | 2.0675 | 2.069 | 2804500.0 |
| 2004-09-22 17:00:00 | AMZN | Stock | 2.069 | 2.072 | 2.06 | 2.06 | 112000.0 |
| 2004-09-22 09:00:00 | CL | Stock | 23.05 | 23.075 | 22.92 | 22.96 | 2930200.0 |
| 2004-09-22 10:00:00 | CL | Stock | 22.96 | 23.05 | 22.9 | 22.965 | 4147800.0 |
| 2004-09-22 11:00:00 | CL | Stock | 22.965 | 23.015 | 22.965 | 23.005 | 2863000.0 |
| 2004-09-22 12:00:00 | CL | Stock | 23.01 | 23.04 | 22.99 | 23.01 | 1469000.0 |
| 2004-09-22 13:00:00 | CL | Stock | 23.005 | 23.015 | 22.925 | 22.96 | 1808400.0 |
| 2004-09-22 14:00:00 | CL | Stock | 22.96 | 23.02 | 22.915 | 22.985 | 2209600.0 |
| 2004-09-22 15:00:00 | CL | Stock | 22.985 | 23.01 | 22.915 | 22.935 | 3940200.0 |
| 2004-09-22 16:00:00 | CL | Stock | 22.935 | 22.94 | 22.925 | 22.925 | 63400.0 |
> showing 50 of 23,531 rows — these rows as CSV