PREVIEW / stock_1hour / 2003-03-14
file: by_date/stock_1hour/2003/2003-03-14.parquet size: 429 KB rows: 21,454 symbols: 1,554
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-14 08:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 235200.0 |
| 2003-03-14 09:00:00 | AAPL | Stock | 0.2625 | 0.265 | 0.2614 | 0.2638 | 18841424.0 |
| 2003-03-14 10:00:00 | AAPL | Stock | 0.2638 | 0.2679 | 0.2638 | 0.2666 | 30769144.0 |
| 2003-03-14 11:00:00 | AAPL | Stock | 0.2666 | 0.2675 | 0.2637 | 0.2638 | 22719312.0 |
| 2003-03-14 12:00:00 | AAPL | Stock | 0.2638 | 0.2646 | 0.263 | 0.2645 | 12949776.0 |
| 2003-03-14 13:00:00 | AAPL | Stock | 0.2648 | 0.2648 | 0.2629 | 0.263 | 11842040.0 |
| 2003-03-14 14:00:00 | AAPL | Stock | 0.263 | 0.2645 | 0.2616 | 0.2645 | 13722464.0 |
| 2003-03-14 15:00:00 | AAPL | Stock | 0.2644 | 0.2663 | 0.2629 | 0.2639 | 24177048.0 |
| 2003-03-14 16:00:00 | AAPL | Stock | 0.2639 | 0.2682 | 0.2638 | 0.2639 | 5138616.0 |
| 2003-03-14 17:00:00 | AAPL | Stock | 0.2661 | 0.2661 | 0.2639 | 0.2639 | 28000.0 |
| 2003-03-14 08:00:00 | MSFT | Stock | 24.85 | 24.95 | 24.61 | 24.639 | 383325.0 |
| 2003-03-14 09:00:00 | MSFT | Stock | 24.64 | 24.99 | 24.36 | 24.388 | 11331186.0 |
| 2003-03-14 10:00:00 | MSFT | Stock | 24.38 | 24.961 | 24.37 | 24.72 | 15925090.0 |
| 2003-03-14 11:00:00 | MSFT | Stock | 24.72 | 24.94 | 24.55 | 24.56 | 10067472.0 |
| 2003-03-14 12:00:00 | MSFT | Stock | 24.55 | 24.6 | 24.26 | 24.452 | 6562454.0 |
| 2003-03-14 13:00:00 | MSFT | Stock | 24.46 | 24.6 | 24.38 | 24.42 | 4972445.0 |
| 2003-03-14 14:00:00 | MSFT | Stock | 24.419 | 24.65 | 24.31 | 24.65 | 5779162.0 |
| 2003-03-14 15:00:00 | MSFT | Stock | 24.65 | 24.88 | 24.5 | 24.86 | 11638993.0 |
| 2003-03-14 16:00:00 | MSFT | Stock | 24.85 | 24.98 | 24.56 | 24.9 | 2579226.0 |
| 2003-03-14 17:00:00 | MSFT | Stock | 24.89 | 24.89 | 24.6369 | 24.82 | 131575.0 |
| 2003-03-14 18:00:00 | MSFT | Stock | 24.8 | 24.86 | 24.8 | 24.8 | 41791.0 |
| 2003-03-14 08:00:00 | NVDA | Stock | 0.115 | 0.1177 | 0.1146 | 0.1167 | 10714800.0 |
| 2003-03-14 09:00:00 | NVDA | Stock | 0.1167 | 0.1168 | 0.1132 | 0.1133 | 216162600.0 |
| 2003-03-14 10:00:00 | NVDA | Stock | 0.1133 | 0.1164 | 0.1133 | 0.1155 | 235307760.0 |
| 2003-03-14 11:00:00 | NVDA | Stock | 0.1155 | 0.1162 | 0.1139 | 0.1141 | 121726080.0 |
| 2003-03-14 12:00:00 | NVDA | Stock | 0.114 | 0.1144 | 0.1119 | 0.1128 | 87873360.0 |
| 2003-03-14 13:00:00 | NVDA | Stock | 0.1129 | 0.1136 | 0.112 | 0.1121 | 77328720.0 |
| 2003-03-14 14:00:00 | NVDA | Stock | 0.112 | 0.1124 | 0.111 | 0.1123 | 101453880.0 |
| 2003-03-14 15:00:00 | NVDA | Stock | 0.1125 | 0.1132 | 0.111 | 0.1117 | 165587280.0 |
| 2003-03-14 16:00:00 | NVDA | Stock | 0.1118 | 0.1125 | 0.1114 | 0.1117 | 17286840.0 |
| 2003-03-14 17:00:00 | NVDA | Stock | 0.1114 | 0.1124 | 0.1114 | 0.1118 | 180000.0 |
| 2003-03-14 18:00:00 | NVDA | Stock | 0.1114 | 0.1114 | 0.1112 | 0.1112 | 132000.0 |
| 2003-03-14 08:00:00 | AMZN | Stock | 1.225 | 1.231 | 1.221 | 1.2245 | 647000.0 |
| 2003-03-14 09:00:00 | AMZN | Stock | 1.2245 | 1.23 | 1.21 | 1.2175 | 22280920.0 |
| 2003-03-14 10:00:00 | AMZN | Stock | 1.2186 | 1.244 | 1.2185 | 1.2395 | 36737220.0 |
| 2003-03-14 11:00:00 | AMZN | Stock | 1.24 | 1.245 | 1.236 | 1.2385 | 27288060.0 |
| 2003-03-14 12:00:00 | AMZN | Stock | 1.2385 | 1.242 | 1.2295 | 1.2355 | 20075660.0 |
| 2003-03-14 13:00:00 | AMZN | Stock | 1.2345 | 1.2435 | 1.2315 | 1.2365 | 13426620.0 |
| 2003-03-14 14:00:00 | AMZN | Stock | 1.236 | 1.24 | 1.232 | 1.235 | 13167860.0 |
| 2003-03-14 15:00:00 | AMZN | Stock | 1.2355 | 1.238 | 1.2275 | 1.2355 | 25988360.0 |
| 2003-03-14 16:00:00 | AMZN | Stock | 1.236 | 1.2415 | 1.2329 | 1.2385 | 2258000.0 |
| 2003-03-14 17:00:00 | AMZN | Stock | 1.239 | 1.24 | 1.2355 | 1.24 | 80000.0 |
| 2003-03-14 18:00:00 | AMZN | Stock | 1.2355 | 1.2375 | 1.2355 | 1.2375 | 6000.0 |
| 2003-03-14 09:00:00 | CL | Stock | 26.005 | 26.13 | 25.965 | 26.08 | 382000.0 |
| 2003-03-14 10:00:00 | CL | Stock | 26.09 | 26.32 | 26.04 | 26.14 | 510000.0 |
| 2003-03-14 11:00:00 | CL | Stock | 26.14 | 26.265 | 25.99 | 25.99 | 375000.0 |
| 2003-03-14 12:00:00 | CL | Stock | 25.985 | 26.075 | 25.875 | 25.98 | 362800.0 |
| 2003-03-14 13:00:00 | CL | Stock | 25.98 | 26.06 | 25.865 | 25.875 | 247600.0 |
| 2003-03-14 14:00:00 | CL | Stock | 25.865 | 26.05 | 25.84 | 26.025 | 341200.0 |
| 2003-03-14 15:00:00 | CL | Stock | 26.035 | 26.095 | 25.95 | 26.09 | 722400.0 |
> showing 50 of 21,454 rows — these rows as CSV