PREVIEW / stock_1hour / 2004-04-05
file: by_date/stock_1hour/2004/2004-04-05.parquet size: 534 KB rows: 25,094 symbols: 1,763
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-04-05 08:00:00 | AAPL | Stock | 0.492 | 0.4929 | 0.492 | 0.4929 | 44800.0 |
| 2004-04-05 09:00:00 | AAPL | Stock | 0.4911 | 0.4955 | 0.4884 | 0.4936 | 29005928.0 |
| 2004-04-05 10:00:00 | AAPL | Stock | 0.4936 | 0.4938 | 0.49 | 0.4916 | 27478248.0 |
| 2004-04-05 11:00:00 | AAPL | Stock | 0.4914 | 0.4979 | 0.4911 | 0.4971 | 28736568.0 |
| 2004-04-05 12:00:00 | AAPL | Stock | 0.4973 | 0.5061 | 0.4964 | 0.5055 | 74965408.0 |
| 2004-04-05 13:00:00 | AAPL | Stock | 0.5052 | 0.5066 | 0.5005 | 0.5018 | 56100296.0 |
| 2004-04-05 14:00:00 | AAPL | Stock | 0.5018 | 0.5036 | 0.4995 | 0.5029 | 35835688.0 |
| 2004-04-05 15:00:00 | AAPL | Stock | 0.5029 | 0.5064 | 0.5018 | 0.5057 | 102646208.0 |
| 2004-04-05 16:00:00 | AAPL | Stock | 0.5061 | 0.5064 | 0.5036 | 0.5044 | 2504488.0 |
| 2004-04-05 17:00:00 | AAPL | Stock | 0.5038 | 0.5057 | 0.5038 | 0.5054 | 6233640.0 |
| 2004-04-05 08:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.75 | 25.75 | 24488.0 |
| 2004-04-05 09:00:00 | MSFT | Stock | 25.75 | 25.97 | 25.75 | 25.88 | 6814938.0 |
| 2004-04-05 10:00:00 | MSFT | Stock | 25.89 | 25.97 | 25.87 | 25.92 | 7189886.0 |
| 2004-04-05 11:00:00 | MSFT | Stock | 25.92 | 25.94 | 25.8 | 25.8 | 6182731.0 |
| 2004-04-05 12:00:00 | MSFT | Stock | 25.8 | 25.85 | 25.79 | 25.79 | 4833382.0 |
| 2004-04-05 13:00:00 | MSFT | Stock | 25.79 | 25.83 | 25.73 | 25.8 | 5606432.0 |
| 2004-04-05 14:00:00 | MSFT | Stock | 25.79 | 25.81 | 25.74 | 25.779 | 5522599.0 |
| 2004-04-05 15:00:00 | MSFT | Stock | 25.78 | 25.97 | 25.77 | 25.96 | 13000815.0 |
| 2004-04-05 16:00:00 | MSFT | Stock | 25.96 | 25.99 | 25.91 | 25.91 | 650564.0 |
| 2004-04-05 17:00:00 | MSFT | Stock | 25.98 | 25.984 | 25.9 | 25.9 | 1037656.0 |
| 2004-04-05 18:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.9 | 25.9 | 440.0 |
| 2004-04-05 08:00:00 | NVDA | Stock | 0.2194 | 0.2196 | 0.2193 | 0.2193 | 216000.0 |
| 2004-04-05 09:00:00 | NVDA | Stock | 0.2187 | 0.2207 | 0.218 | 0.2192 | 54355680.0 |
| 2004-04-05 10:00:00 | NVDA | Stock | 0.2193 | 0.2217 | 0.2192 | 0.2212 | 112736400.0 |
| 2004-04-05 11:00:00 | NVDA | Stock | 0.2212 | 0.223 | 0.221 | 0.2222 | 64267440.0 |
| 2004-04-05 12:00:00 | NVDA | Stock | 0.2223 | 0.223 | 0.2217 | 0.2223 | 33589200.0 |
| 2004-04-05 13:00:00 | NVDA | Stock | 0.2222 | 0.2231 | 0.2222 | 0.2227 | 28329360.0 |
| 2004-04-05 14:00:00 | NVDA | Stock | 0.2227 | 0.2247 | 0.2225 | 0.224 | 43475520.0 |
| 2004-04-05 15:00:00 | NVDA | Stock | 0.2239 | 0.2279 | 0.2238 | 0.2275 | 167387760.0 |
| 2004-04-05 16:00:00 | NVDA | Stock | 0.2275 | 0.2287 | 0.2267 | 0.2277 | 30493560.0 |
| 2004-04-05 17:00:00 | NVDA | Stock | 0.2281 | 0.2292 | 0.2275 | 0.2275 | 5216640.0 |
| 2004-04-05 18:00:00 | NVDA | Stock | 0.2275 | 0.2275 | 0.2271 | 0.2271 | 324000.0 |
| 2004-04-05 08:00:00 | AMZN | Stock | 2.3045 | 2.3045 | 2.2925 | 2.2925 | 107900.0 |
| 2004-04-05 09:00:00 | AMZN | Stock | 2.2925 | 2.309 | 2.2795 | 2.2985 | 15476120.0 |
| 2004-04-05 10:00:00 | AMZN | Stock | 2.2985 | 2.316 | 2.2975 | 2.3105 | 22569400.0 |
| 2004-04-05 11:00:00 | AMZN | Stock | 2.3105 | 2.324 | 2.309 | 2.322 | 13534760.0 |
| 2004-04-05 12:00:00 | AMZN | Stock | 2.3215 | 2.341 | 2.3205 | 2.3295 | 12478280.0 |
| 2004-04-05 13:00:00 | AMZN | Stock | 2.3295 | 2.335 | 2.3245 | 2.3275 | 9383860.0 |
| 2004-04-05 14:00:00 | AMZN | Stock | 2.328 | 2.341 | 2.3225 | 2.336 | 10538680.0 |
| 2004-04-05 15:00:00 | AMZN | Stock | 2.336 | 2.3545 | 2.33 | 2.349 | 26038140.0 |
| 2004-04-05 16:00:00 | AMZN | Stock | 2.349 | 2.3575 | 2.3425 | 2.3545 | 512520.0 |
| 2004-04-05 17:00:00 | AMZN | Stock | 2.3435 | 2.3482 | 2.3222 | 2.348 | 1381540.0 |
| 2004-04-05 18:00:00 | AMZN | Stock | 2.3455 | 2.3455 | 2.3455 | 2.3455 | 6000.0 |
| 2004-04-05 09:00:00 | CL | Stock | 27.75 | 27.75 | 27.525 | 27.56 | 215000.0 |
| 2004-04-05 10:00:00 | CL | Stock | 27.56 | 27.6 | 27.43 | 27.435 | 352000.0 |
| 2004-04-05 11:00:00 | CL | Stock | 27.43 | 27.5 | 27.425 | 27.495 | 270000.0 |
| 2004-04-05 12:00:00 | CL | Stock | 27.495 | 27.555 | 27.48 | 27.525 | 226400.0 |
| 2004-04-05 13:00:00 | CL | Stock | 27.52 | 27.56 | 27.47 | 27.49 | 220200.0 |
| 2004-04-05 14:00:00 | CL | Stock | 27.49 | 27.495 | 27.325 | 27.33 | 480600.0 |
| 2004-04-05 15:00:00 | CL | Stock | 27.335 | 27.475 | 27.295 | 27.435 | 1043400.0 |
> showing 50 of 25,094 rows — these rows as CSV