PREVIEW / stock_1hour / 2003-04-15
file: by_date/stock_1hour/2003/2003-04-15.parquet size: 415 KB rows: 21,090 symbols: 1,566
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-15 08:00:00 | AAPL | Stock | 0.2436 | 0.2436 | 0.2411 | 0.2411 | 1450400.0 |
| 2003-04-15 09:00:00 | AAPL | Stock | 0.2411 | 0.2434 | 0.2375 | 0.24 | 49539056.0 |
| 2003-04-15 10:00:00 | AAPL | Stock | 0.24 | 0.2409 | 0.2379 | 0.2396 | 46003272.0 |
| 2003-04-15 11:00:00 | AAPL | Stock | 0.2398 | 0.2427 | 0.2398 | 0.2411 | 31941672.0 |
| 2003-04-15 12:00:00 | AAPL | Stock | 0.2407 | 0.2413 | 0.2391 | 0.2395 | 30366056.0 |
| 2003-04-15 13:00:00 | AAPL | Stock | 0.2393 | 0.24 | 0.238 | 0.2386 | 43748656.0 |
| 2003-04-15 14:00:00 | AAPL | Stock | 0.2386 | 0.2389 | 0.2379 | 0.2386 | 32915120.0 |
| 2003-04-15 15:00:00 | AAPL | Stock | 0.2386 | 0.24 | 0.2382 | 0.2391 | 37311960.0 |
| 2003-04-15 16:00:00 | AAPL | Stock | 0.2391 | 0.2411 | 0.2391 | 0.2411 | 3382400.0 |
| 2003-04-15 17:00:00 | AAPL | Stock | 0.2411 | 0.2436 | 0.2382 | 0.242 | 350280.0 |
| 2003-04-15 18:00:00 | AAPL | Stock | 0.2429 | 0.2434 | 0.2418 | 0.2434 | 171920.0 |
| 2003-04-15 08:00:00 | MSFT | Stock | 24.87 | 25.15 | 24.7 | 24.75 | 193665.0 |
| 2003-04-15 09:00:00 | MSFT | Stock | 24.76 | 24.791 | 24.55 | 24.6 | 6921489.0 |
| 2003-04-15 10:00:00 | MSFT | Stock | 24.6 | 24.7 | 24.48 | 24.62 | 9307362.0 |
| 2003-04-15 11:00:00 | MSFT | Stock | 24.62 | 24.724 | 24.2 | 24.59 | 6441192.0 |
| 2003-04-15 12:00:00 | MSFT | Stock | 24.6 | 24.71 | 24.57 | 24.67 | 4216410.0 |
| 2003-04-15 13:00:00 | MSFT | Stock | 24.69 | 24.704 | 24.39 | 24.48 | 5624691.0 |
| 2003-04-15 14:00:00 | MSFT | Stock | 24.48 | 24.51 | 24.4 | 24.47 | 5200383.0 |
| 2003-04-15 15:00:00 | MSFT | Stock | 24.47 | 24.65 | 24.33 | 24.6 | 11847826.0 |
| 2003-04-15 16:00:00 | MSFT | Stock | 24.6 | 25.88 | 24.58 | 25.83 | 7631545.0 |
| 2003-04-15 17:00:00 | MSFT | Stock | 25.83 | 25.86 | 24.42 | 25.75 | 1830998.0 |
| 2003-04-15 18:00:00 | MSFT | Stock | 25.73 | 25.8 | 25.65 | 25.75 | 356390.0 |
| 2003-04-15 08:00:00 | NVDA | Stock | 0.1123 | 0.1125 | 0.1117 | 0.1117 | 783600.0 |
| 2003-04-15 09:00:00 | NVDA | Stock | 0.1116 | 0.1125 | 0.1092 | 0.1114 | 57902400.0 |
| 2003-04-15 10:00:00 | NVDA | Stock | 0.1112 | 0.1132 | 0.1107 | 0.1125 | 49690080.0 |
| 2003-04-15 11:00:00 | NVDA | Stock | 0.1125 | 0.1132 | 0.1123 | 0.1124 | 67363800.0 |
| 2003-04-15 12:00:00 | NVDA | Stock | 0.1125 | 0.1125 | 0.1112 | 0.1113 | 88254120.0 |
| 2003-04-15 13:00:00 | NVDA | Stock | 0.1114 | 0.1119 | 0.1102 | 0.1107 | 80738520.0 |
| 2003-04-15 14:00:00 | NVDA | Stock | 0.1108 | 0.1119 | 0.1106 | 0.1117 | 41503200.0 |
| 2003-04-15 15:00:00 | NVDA | Stock | 0.1117 | 0.1119 | 0.111 | 0.1117 | 51716280.0 |
| 2003-04-15 16:00:00 | NVDA | Stock | 0.1117 | 0.1152 | 0.1117 | 0.115 | 14371080.0 |
| 2003-04-15 17:00:00 | NVDA | Stock | 0.1151 | 0.1164 | 0.1117 | 0.1161 | 5076000.0 |
| 2003-04-15 18:00:00 | NVDA | Stock | 0.116 | 0.1164 | 0.1157 | 0.1158 | 1632000.0 |
| 2003-04-15 08:00:00 | AMZN | Stock | 1.2525 | 1.253 | 1.2405 | 1.2406 | 236000.0 |
| 2003-04-15 09:00:00 | AMZN | Stock | 1.245 | 1.2645 | 1.241 | 1.254 | 17883580.0 |
| 2003-04-15 10:00:00 | AMZN | Stock | 1.254 | 1.265 | 1.253 | 1.257 | 21290560.0 |
| 2003-04-15 11:00:00 | AMZN | Stock | 1.257 | 1.265 | 1.2555 | 1.26 | 17496640.0 |
| 2003-04-15 12:00:00 | AMZN | Stock | 1.26 | 1.2715 | 1.26 | 1.2665 | 12212540.0 |
| 2003-04-15 13:00:00 | AMZN | Stock | 1.267 | 1.268 | 1.2575 | 1.2595 | 11628600.0 |
| 2003-04-15 14:00:00 | AMZN | Stock | 1.26 | 1.2685 | 1.257 | 1.2655 | 10527040.0 |
| 2003-04-15 15:00:00 | AMZN | Stock | 1.265 | 1.269 | 1.256 | 1.257 | 19942400.0 |
| 2003-04-15 16:00:00 | AMZN | Stock | 1.257 | 1.27 | 1.2546 | 1.27 | 1977360.0 |
| 2003-04-15 17:00:00 | AMZN | Stock | 1.27 | 1.2755 | 1.2555 | 1.2705 | 288740.0 |
| 2003-04-15 18:00:00 | AMZN | Stock | 1.275 | 1.275 | 1.273 | 1.273 | 26000.0 |
| 2003-04-15 09:00:00 | CL | Stock | 28.31 | 28.375 | 28.25 | 28.33 | 421600.0 |
| 2003-04-15 10:00:00 | CL | Stock | 28.33 | 28.45 | 28.275 | 28.425 | 543400.0 |
| 2003-04-15 11:00:00 | CL | Stock | 28.43 | 28.555 | 28.43 | 28.545 | 578200.0 |
| 2003-04-15 12:00:00 | CL | Stock | 28.505 | 28.75 | 28.495 | 28.64 | 910800.0 |
| 2003-04-15 13:00:00 | CL | Stock | 28.64 | 28.815 | 28.62 | 28.71 | 831000.0 |
| 2003-04-15 14:00:00 | CL | Stock | 28.705 | 28.725 | 28.635 | 28.72 | 591000.0 |
> showing 50 of 21,090 rows — these rows as CSV