PREVIEW / stock_1hour / 2003-04-22
file: by_date/stock_1hour/2003/2003-04-22.parquet size: 431 KB rows: 21,419 symbols: 1,564
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-04-22 08:00:00 | AAPL | Stock | 0.2339 | 0.2343 | 0.2339 | 0.2339 | 67200.0 |
| 2003-04-22 09:00:00 | AAPL | Stock | 0.2338 | 0.2366 | 0.2321 | 0.2359 | 22263304.0 |
| 2003-04-22 10:00:00 | AAPL | Stock | 0.2361 | 0.2388 | 0.2352 | 0.2382 | 43293656.0 |
| 2003-04-22 11:00:00 | AAPL | Stock | 0.2382 | 0.2391 | 0.2368 | 0.2384 | 31458672.0 |
| 2003-04-22 12:00:00 | AAPL | Stock | 0.2384 | 0.2411 | 0.2379 | 0.2396 | 31171952.0 |
| 2003-04-22 13:00:00 | AAPL | Stock | 0.2395 | 0.242 | 0.2395 | 0.242 | 33430936.0 |
| 2003-04-22 14:00:00 | AAPL | Stock | 0.242 | 0.2432 | 0.2414 | 0.2427 | 47801768.0 |
| 2003-04-22 15:00:00 | AAPL | Stock | 0.2428 | 0.2432 | 0.2407 | 0.2413 | 46928336.0 |
| 2003-04-22 16:00:00 | AAPL | Stock | 0.2414 | 0.242 | 0.2411 | 0.2411 | 7100576.0 |
| 2003-04-22 17:00:00 | AAPL | Stock | 0.2414 | 0.2414 | 0.2413 | 0.2413 | 2514400.0 |
| 2003-04-22 18:00:00 | AAPL | Stock | 0.242 | 0.242 | 0.2414 | 0.2414 | 39200.0 |
| 2003-04-22 08:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.011 | 25.07 | 41615.0 |
| 2003-04-22 09:00:00 | MSFT | Stock | 25.07 | 25.22 | 24.99 | 25.13 | 5370312.0 |
| 2003-04-22 10:00:00 | MSFT | Stock | 25.14 | 25.561 | 25.1 | 25.49 | 9912743.0 |
| 2003-04-22 11:00:00 | MSFT | Stock | 25.49 | 25.56 | 25.311 | 25.5487 | 5984250.0 |
| 2003-04-22 12:00:00 | MSFT | Stock | 25.55 | 25.72 | 25.49 | 25.69 | 6014302.0 |
| 2003-04-22 13:00:00 | MSFT | Stock | 25.69 | 25.78 | 25.49 | 25.57 | 7392201.0 |
| 2003-04-22 14:00:00 | MSFT | Stock | 25.58 | 25.75 | 25.53 | 25.7 | 6855518.0 |
| 2003-04-22 15:00:00 | MSFT | Stock | 25.71 | 25.8 | 25.629 | 25.77 | 9255891.0 |
| 2003-04-22 16:00:00 | MSFT | Stock | 25.77 | 25.8 | 25.06 | 25.75 | 770729.0 |
| 2003-04-22 17:00:00 | MSFT | Stock | 25.78 | 25.8 | 25.74 | 25.79 | 206694.0 |
| 2003-04-22 18:00:00 | MSFT | Stock | 25.79 | 25.79 | 25.74 | 25.75 | 32752.0 |
| 2003-04-22 08:00:00 | NVDA | Stock | 0.1169 | 0.1169 | 0.1158 | 0.1167 | 640800.0 |
| 2003-04-22 09:00:00 | NVDA | Stock | 0.1159 | 0.1167 | 0.1154 | 0.1156 | 50571240.0 |
| 2003-04-22 10:00:00 | NVDA | Stock | 0.1155 | 0.1166 | 0.1142 | 0.1164 | 139126560.0 |
| 2003-04-22 11:00:00 | NVDA | Stock | 0.1164 | 0.1166 | 0.115 | 0.1163 | 88035600.0 |
| 2003-04-22 12:00:00 | NVDA | Stock | 0.1163 | 0.1171 | 0.1162 | 0.1167 | 58906320.0 |
| 2003-04-22 13:00:00 | NVDA | Stock | 0.1167 | 0.1178 | 0.1167 | 0.1172 | 157953360.0 |
| 2003-04-22 14:00:00 | NVDA | Stock | 0.1171 | 0.1178 | 0.1168 | 0.1178 | 92544600.0 |
| 2003-04-22 15:00:00 | NVDA | Stock | 0.1178 | 0.1182 | 0.1169 | 0.1182 | 106737000.0 |
| 2003-04-22 16:00:00 | NVDA | Stock | 0.1182 | 0.1182 | 0.1176 | 0.1176 | 5107080.0 |
| 2003-04-22 17:00:00 | NVDA | Stock | 0.1178 | 0.1182 | 0.1178 | 0.1181 | 2727600.0 |
| 2003-04-22 18:00:00 | NVDA | Stock | 0.1181 | 0.1181 | 0.1178 | 0.1178 | 38400.0 |
| 2003-04-22 08:00:00 | AMZN | Stock | 1.2625 | 1.2625 | 1.25 | 1.2583 | 297500.0 |
| 2003-04-22 09:00:00 | AMZN | Stock | 1.2625 | 1.2625 | 1.241 | 1.2485 | 16791160.0 |
| 2003-04-22 10:00:00 | AMZN | Stock | 1.2485 | 1.26 | 1.245 | 1.2535 | 17192600.0 |
| 2003-04-22 11:00:00 | AMZN | Stock | 1.2535 | 1.262 | 1.2525 | 1.2606 | 17867660.0 |
| 2003-04-22 12:00:00 | AMZN | Stock | 1.2605 | 1.276 | 1.2575 | 1.2735 | 15053760.0 |
| 2003-04-22 13:00:00 | AMZN | Stock | 1.273 | 1.275 | 1.2645 | 1.2695 | 7180480.0 |
| 2003-04-22 14:00:00 | AMZN | Stock | 1.27 | 1.2845 | 1.27 | 1.2815 | 15244060.0 |
| 2003-04-22 15:00:00 | AMZN | Stock | 1.282 | 1.284 | 1.2755 | 1.279 | 20845820.0 |
| 2003-04-22 16:00:00 | AMZN | Stock | 1.2795 | 1.3025 | 1.2626 | 1.3 | 2292740.0 |
| 2003-04-22 17:00:00 | AMZN | Stock | 1.3025 | 1.31 | 1.2786 | 1.2807 | 1075000.0 |
| 2003-04-22 18:00:00 | AMZN | Stock | 1.302 | 1.302 | 1.3005 | 1.3005 | 87360.0 |
| 2003-04-22 09:00:00 | CL | Stock | 28.3 | 28.3 | 28.16 | 28.165 | 463000.0 |
| 2003-04-22 10:00:00 | CL | Stock | 28.18 | 28.725 | 28.16 | 28.635 | 658800.0 |
| 2003-04-22 11:00:00 | CL | Stock | 28.635 | 28.635 | 28.44 | 28.55 | 561600.0 |
| 2003-04-22 12:00:00 | CL | Stock | 28.55 | 28.64 | 28.46 | 28.64 | 387800.0 |
| 2003-04-22 13:00:00 | CL | Stock | 28.64 | 28.71 | 28.595 | 28.65 | 420400.0 |
| 2003-04-22 14:00:00 | CL | Stock | 28.63 | 28.7 | 28.59 | 28.65 | 689200.0 |
> showing 50 of 21,419 rows — these rows as CSV