PREVIEW / stock_1hour / 2004-09-15
file: by_date/stock_1hour/2004/2004-09-15.parquet size: 510 KB rows: 24,344 symbols: 1,812
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-15 08:00:00 | AAPL | Stock | 0.6325 | 0.6329 | 0.6325 | 0.6329 | 58800.0 |
| 2004-09-15 09:00:00 | AAPL | Stock | 0.6325 | 0.6327 | 0.6214 | 0.627 | 59454584.0 |
| 2004-09-15 10:00:00 | AAPL | Stock | 0.627 | 0.6282 | 0.6232 | 0.6261 | 36641248.0 |
| 2004-09-15 11:00:00 | AAPL | Stock | 0.6261 | 0.6323 | 0.6261 | 0.6318 | 39394992.0 |
| 2004-09-15 12:00:00 | AAPL | Stock | 0.6316 | 0.6334 | 0.628 | 0.6296 | 22187032.0 |
| 2004-09-15 13:00:00 | AAPL | Stock | 0.6295 | 0.6323 | 0.6291 | 0.6323 | 10647168.0 |
| 2004-09-15 14:00:00 | AAPL | Stock | 0.6321 | 0.6335 | 0.6304 | 0.6311 | 18984280.0 |
| 2004-09-15 15:00:00 | AAPL | Stock | 0.6309 | 0.6318 | 0.6275 | 0.6284 | 27073144.0 |
| 2004-09-15 16:00:00 | AAPL | Stock | 0.6279 | 0.6305 | 0.6277 | 0.6294 | 3752112.0 |
| 2004-09-15 17:00:00 | AAPL | Stock | 0.6288 | 0.6288 | 0.6279 | 0.6279 | 854504.0 |
| 2004-09-15 08:00:00 | MSFT | Stock | 27.37 | 27.48 | 27.33 | 27.37 | 53768.0 |
| 2004-09-15 09:00:00 | MSFT | Stock | 27.37 | 27.41 | 27.27 | 27.27 | 7074051.0 |
| 2004-09-15 10:00:00 | MSFT | Stock | 27.28 | 27.32 | 27.21 | 27.25 | 9611135.0 |
| 2004-09-15 11:00:00 | MSFT | Stock | 27.25 | 27.27 | 27.19 | 27.22 | 6750407.0 |
| 2004-09-15 12:00:00 | MSFT | Stock | 27.22 | 27.25 | 27.14 | 27.2 | 6383406.0 |
| 2004-09-15 13:00:00 | MSFT | Stock | 27.2 | 27.26 | 27.18 | 27.229 | 4900492.0 |
| 2004-09-15 14:00:00 | MSFT | Stock | 27.23 | 27.25 | 27.15 | 27.17 | 4656392.0 |
| 2004-09-15 15:00:00 | MSFT | Stock | 27.18 | 27.26 | 27.15 | 27.18 | 9930265.0 |
| 2004-09-15 16:00:00 | MSFT | Stock | 27.18 | 27.2525 | 27.16 | 27.2176 | 1612156.0 |
| 2004-09-15 17:00:00 | MSFT | Stock | 27.18 | 27.21 | 27.18 | 27.21 | 126436.0 |
| 2004-09-15 18:00:00 | MSFT | Stock | 27.2 | 27.2 | 27.19 | 27.19 | 415.0 |
| 2004-09-15 08:00:00 | NVDA | Stock | 0.12 | 0.12 | 0.1161 | 0.1169 | 3323400.0 |
| 2004-09-15 09:00:00 | NVDA | Stock | 0.117 | 0.1172 | 0.114 | 0.1142 | 256822680.0 |
| 2004-09-15 10:00:00 | NVDA | Stock | 0.1142 | 0.1154 | 0.1133 | 0.1138 | 225140160.0 |
| 2004-09-15 11:00:00 | NVDA | Stock | 0.1138 | 0.1146 | 0.1135 | 0.1137 | 145560360.0 |
| 2004-09-15 12:00:00 | NVDA | Stock | 0.1137 | 0.1137 | 0.1118 | 0.1123 | 170297760.0 |
| 2004-09-15 13:00:00 | NVDA | Stock | 0.1123 | 0.114 | 0.1122 | 0.1133 | 129978600.0 |
| 2004-09-15 14:00:00 | NVDA | Stock | 0.1133 | 0.1142 | 0.1132 | 0.1136 | 66572280.0 |
| 2004-09-15 15:00:00 | NVDA | Stock | 0.1137 | 0.1139 | 0.1133 | 0.1137 | 140118120.0 |
| 2004-09-15 16:00:00 | NVDA | Stock | 0.1136 | 0.1138 | 0.1133 | 0.1133 | 6797760.0 |
| 2004-09-15 17:00:00 | NVDA | Stock | 0.1137 | 0.1137 | 0.1133 | 0.1133 | 3044760.0 |
| 2004-09-15 18:00:00 | NVDA | Stock | 0.1133 | 0.1135 | 0.1133 | 0.1133 | 336000.0 |
| 2004-09-15 08:00:00 | AMZN | Stock | 2.125 | 2.1335 | 2.1165 | 2.12 | 211000.0 |
| 2004-09-15 09:00:00 | AMZN | Stock | 2.12 | 2.141 | 2.0935 | 2.1125 | 55221520.0 |
| 2004-09-15 10:00:00 | AMZN | Stock | 2.1125 | 2.159 | 2.1105 | 2.1155 | 67846820.0 |
| 2004-09-15 11:00:00 | AMZN | Stock | 2.115 | 2.13 | 2.1105 | 2.1185 | 21686380.0 |
| 2004-09-15 12:00:00 | AMZN | Stock | 2.1185 | 2.1245 | 2.11 | 2.114 | 14441640.0 |
| 2004-09-15 13:00:00 | AMZN | Stock | 2.114 | 2.136 | 2.114 | 2.1325 | 14602160.0 |
| 2004-09-15 14:00:00 | AMZN | Stock | 2.132 | 2.1385 | 2.1195 | 2.1275 | 22310620.0 |
| 2004-09-15 15:00:00 | AMZN | Stock | 2.1275 | 2.1295 | 2.11 | 2.1115 | 21707540.0 |
| 2004-09-15 16:00:00 | AMZN | Stock | 2.11 | 2.113 | 2.109 | 2.1105 | 1708620.0 |
| 2004-09-15 17:00:00 | AMZN | Stock | 2.11 | 2.1124 | 2.11 | 2.1105 | 603260.0 |
| 2004-09-15 18:00:00 | AMZN | Stock | 2.11 | 2.114 | 2.11 | 2.114 | 62000.0 |
| 2004-09-15 09:00:00 | CL | Stock | 27.175 | 27.18 | 27.115 | 27.14 | 160000.0 |
| 2004-09-15 10:00:00 | CL | Stock | 27.14 | 27.175 | 27.09 | 27.09 | 376600.0 |
| 2004-09-15 11:00:00 | CL | Stock | 27.09 | 27.1 | 27.01 | 27.1 | 218800.0 |
| 2004-09-15 12:00:00 | CL | Stock | 27.095 | 27.135 | 27.075 | 27.115 | 251400.0 |
| 2004-09-15 13:00:00 | CL | Stock | 27.115 | 27.125 | 27.065 | 27.115 | 152600.0 |
| 2004-09-15 14:00:00 | CL | Stock | 27.11 | 27.165 | 27.105 | 27.15 | 489400.0 |
| 2004-09-15 15:00:00 | CL | Stock | 27.15 | 27.25 | 27.14 | 27.175 | 607200.0 |
> showing 50 of 24,344 rows — these rows as CSV