PREVIEW / stock_1hour / 2003-06-06
file: by_date/stock_1hour/2003/2003-06-06.parquet size: 468 KB rows: 22,073 symbols: 1,578
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-06-06 09:00:00 | AAPL | Stock | 0.3182 | 0.3221 | 0.313 | 0.318 | 35078120.0 |
| 2003-06-06 10:00:00 | AAPL | Stock | 0.3179 | 0.3214 | 0.3166 | 0.3209 | 37492672.0 |
| 2003-06-06 11:00:00 | AAPL | Stock | 0.3209 | 0.3211 | 0.3139 | 0.3161 | 30547104.0 |
| 2003-06-06 12:00:00 | AAPL | Stock | 0.3161 | 0.317 | 0.3116 | 0.3116 | 26525128.0 |
| 2003-06-06 13:00:00 | AAPL | Stock | 0.3116 | 0.3143 | 0.3096 | 0.3134 | 17832584.0 |
| 2003-06-06 14:00:00 | AAPL | Stock | 0.3134 | 0.3134 | 0.3095 | 0.31 | 24404856.0 |
| 2003-06-06 15:00:00 | AAPL | Stock | 0.3098 | 0.3105 | 0.3061 | 0.3063 | 36238160.0 |
| 2003-06-06 16:00:00 | AAPL | Stock | 0.3066 | 0.3066 | 0.3045 | 0.3064 | 2360512.0 |
| 2003-06-06 17:00:00 | AAPL | Stock | 0.3064 | 0.315 | 0.3055 | 0.315 | 2760800.0 |
| 2003-06-06 18:00:00 | AAPL | Stock | 0.3064 | 0.3064 | 0.3064 | 0.3064 | 119672.0 |
| 2003-06-06 08:00:00 | MSFT | Stock | 24.39 | 24.67 | 24.3 | 24.62 | 713609.0 |
| 2003-06-06 09:00:00 | MSFT | Stock | 24.6 | 24.63 | 24.1 | 24.411 | 18674766.0 |
| 2003-06-06 10:00:00 | MSFT | Stock | 24.41 | 24.49 | 24.243 | 24.36 | 15208182.0 |
| 2003-06-06 11:00:00 | MSFT | Stock | 24.36 | 24.38 | 24.2 | 24.28 | 12080924.0 |
| 2003-06-06 12:00:00 | MSFT | Stock | 24.29 | 24.31 | 24.1 | 24.1 | 9822778.0 |
| 2003-06-06 13:00:00 | MSFT | Stock | 24.1 | 24.17 | 23.99 | 24.06 | 11608007.0 |
| 2003-06-06 14:00:00 | MSFT | Stock | 24.061 | 24.09 | 23.82 | 23.83 | 15369532.0 |
| 2003-06-06 15:00:00 | MSFT | Stock | 23.83 | 23.934 | 23.65 | 23.681 | 22688329.0 |
| 2003-06-06 16:00:00 | MSFT | Stock | 23.692 | 24.42 | 23.6 | 23.749 | 1519231.0 |
| 2003-06-06 17:00:00 | MSFT | Stock | 23.71 | 23.74 | 23.65 | 23.74 | 1297804.0 |
| 2003-06-06 18:00:00 | MSFT | Stock | 23.74 | 23.75 | 23.7 | 23.74 | 251940.0 |
| 2003-06-06 08:00:00 | NVDA | Stock | 0.2292 | 0.2297 | 0.2248 | 0.2285 | 4264080.0 |
| 2003-06-06 09:00:00 | NVDA | Stock | 0.2287 | 0.2312 | 0.2258 | 0.2304 | 216021000.0 |
| 2003-06-06 10:00:00 | NVDA | Stock | 0.2307 | 0.2312 | 0.225 | 0.2255 | 209869560.0 |
| 2003-06-06 11:00:00 | NVDA | Stock | 0.2255 | 0.2258 | 0.2207 | 0.2237 | 237025080.0 |
| 2003-06-06 12:00:00 | NVDA | Stock | 0.2237 | 0.2239 | 0.2146 | 0.2152 | 194249040.0 |
| 2003-06-06 13:00:00 | NVDA | Stock | 0.2153 | 0.2195 | 0.213 | 0.2187 | 137746200.0 |
| 2003-06-06 14:00:00 | NVDA | Stock | 0.2187 | 0.2191 | 0.2147 | 0.2148 | 88413600.0 |
| 2003-06-06 15:00:00 | NVDA | Stock | 0.2148 | 0.2167 | 0.2137 | 0.2146 | 153793680.0 |
| 2003-06-06 16:00:00 | NVDA | Stock | 0.2146 | 0.2153 | 0.2144 | 0.2149 | 12001200.0 |
| 2003-06-06 17:00:00 | NVDA | Stock | 0.2148 | 0.2223 | 0.2148 | 0.2223 | 4692360.0 |
| 2003-06-06 18:00:00 | NVDA | Stock | 0.2154 | 0.2154 | 0.215 | 0.215 | 480360.0 |
| 2003-06-06 08:00:00 | AMZN | Stock | 1.7995 | 1.8195 | 1.7995 | 1.81 | 140200.0 |
| 2003-06-06 09:00:00 | AMZN | Stock | 1.816 | 1.8174 | 1.7915 | 1.8015 | 22373140.0 |
| 2003-06-06 10:00:00 | AMZN | Stock | 1.7995 | 1.808 | 1.7575 | 1.7695 | 29817320.0 |
| 2003-06-06 11:00:00 | AMZN | Stock | 1.7695 | 1.7695 | 1.707 | 1.7105 | 38196500.0 |
| 2003-06-06 12:00:00 | AMZN | Stock | 1.7105 | 1.7105 | 1.681 | 1.6855 | 40022120.0 |
| 2003-06-06 13:00:00 | AMZN | Stock | 1.685 | 1.7145 | 1.6705 | 1.7045 | 25465020.0 |
| 2003-06-06 14:00:00 | AMZN | Stock | 1.7055 | 1.712 | 1.682 | 1.6825 | 14510800.0 |
| 2003-06-06 15:00:00 | AMZN | Stock | 1.682 | 1.697 | 1.6625 | 1.6665 | 37761920.0 |
| 2003-06-06 16:00:00 | AMZN | Stock | 1.67 | 1.6875 | 1.6665 | 1.6725 | 1307960.0 |
| 2003-06-06 17:00:00 | AMZN | Stock | 1.666 | 1.6755 | 1.666 | 1.675 | 152000.0 |
| 2003-06-06 09:00:00 | CL | Stock | 29.55 | 29.61 | 29.425 | 29.605 | 332200.0 |
| 2003-06-06 10:00:00 | CL | Stock | 29.605 | 29.675 | 29.4 | 29.6 | 569400.0 |
| 2003-06-06 11:00:00 | CL | Stock | 29.6 | 29.61 | 29.345 | 29.4 | 687600.0 |
| 2003-06-06 12:00:00 | CL | Stock | 29.385 | 29.385 | 29.27 | 29.305 | 503200.0 |
| 2003-06-06 13:00:00 | CL | Stock | 29.305 | 29.43 | 29.215 | 29.285 | 371200.0 |
| 2003-06-06 14:00:00 | CL | Stock | 29.3 | 29.31 | 29.21 | 29.24 | 436200.0 |
| 2003-06-06 15:00:00 | CL | Stock | 29.245 | 29.33 | 29.24 | 29.285 | 632000.0 |
| 2003-06-06 16:00:00 | CL | Stock | 29.285 | 29.3 | 29.285 | 29.295 | 77000.0 |
> showing 50 of 22,073 rows — these rows as CSV