PREVIEW / stock_1hour / 2000-04-07
file: by_date/stock_1hour/2000/2000-04-07.parquet size: 274 KB rows: 13,610 symbols: 1,153
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-07 09:00:00 | AAPL | Stock | 1.1362 | 1.1496 | 1.1205 | 1.1496 | 55249600.0 |
| 2000-04-07 10:00:00 | AAPL | Stock | 1.1501 | 1.1585 | 1.1395 | 1.1445 | 49280000.0 |
| 2000-04-07 11:00:00 | AAPL | Stock | 1.1468 | 1.1563 | 1.1451 | 1.1512 | 33801600.0 |
| 2000-04-07 12:00:00 | AAPL | Stock | 1.1512 | 1.1585 | 1.1484 | 1.1496 | 13652800.0 |
| 2000-04-07 13:00:00 | AAPL | Stock | 1.1501 | 1.1563 | 1.149 | 1.1523 | 11984000.0 |
| 2000-04-07 14:00:00 | AAPL | Stock | 1.1523 | 1.1551 | 1.1434 | 1.149 | 21963200.0 |
| 2000-04-07 15:00:00 | AAPL | Stock | 1.1496 | 1.1696 | 1.1496 | 1.1696 | 37531200.0 |
| 2000-04-07 09:00:00 | MSFT | Stock | 43.5 | 43.625 | 42.5625 | 42.8125 | 11744800.0 |
| 2000-04-07 10:00:00 | MSFT | Stock | 42.7969 | 42.9844 | 42.5 | 42.9062 | 14152200.0 |
| 2000-04-07 11:00:00 | MSFT | Stock | 42.9062 | 43.1875 | 42.75 | 43.0625 | 8100600.0 |
| 2000-04-07 12:00:00 | MSFT | Stock | 43.0625 | 43.5 | 42.9375 | 43.2812 | 8535600.0 |
| 2000-04-07 13:00:00 | MSFT | Stock | 43.3125 | 43.4688 | 43.25 | 43.4375 | 5305600.0 |
| 2000-04-07 14:00:00 | MSFT | Stock | 43.4375 | 44.0 | 43.2812 | 43.8438 | 10184600.0 |
| 2000-04-07 15:00:00 | MSFT | Stock | 43.875 | 44.6875 | 43.8125 | 44.5312 | 17878200.0 |
| 2000-04-07 16:00:00 | MSFT | Stock | 44.5312 | 44.5625 | 44.5 | 44.5 | 133400.0 |
| 2000-04-07 09:00:00 | NVDA | Stock | 0.2099 | 0.2099 | 0.201 | 0.2021 | 41760000.0 |
| 2000-04-07 10:00:00 | NVDA | Stock | 0.2021 | 0.2074 | 0.2013 | 0.2069 | 42576000.0 |
| 2000-04-07 11:00:00 | NVDA | Stock | 0.2064 | 0.2083 | 0.2062 | 0.2076 | 32256000.0 |
| 2000-04-07 12:00:00 | NVDA | Stock | 0.2077 | 0.2143 | 0.2076 | 0.2128 | 49632000.0 |
| 2000-04-07 13:00:00 | NVDA | Stock | 0.2125 | 0.2128 | 0.2031 | 0.2066 | 39072000.0 |
| 2000-04-07 14:00:00 | NVDA | Stock | 0.2073 | 0.2117 | 0.2044 | 0.2117 | 33648000.0 |
| 2000-04-07 15:00:00 | NVDA | Stock | 0.2125 | 0.2187 | 0.2073 | 0.2136 | 71568000.0 |
| 2000-04-07 16:00:00 | NVDA | Stock | 0.2146 | 0.2146 | 0.2137 | 0.2137 | 1488000.0 |
| 2000-04-07 09:00:00 | AMZN | Stock | 3.2562 | 3.2688 | 3.2125 | 3.2188 | 7704000.0 |
| 2000-04-07 10:00:00 | AMZN | Stock | 3.2219 | 3.2469 | 3.2063 | 3.2188 | 7176000.0 |
| 2000-04-07 11:00:00 | AMZN | Stock | 3.2188 | 3.4031 | 3.2156 | 3.4 | 42612000.0 |
| 2000-04-07 12:00:00 | AMZN | Stock | 3.4 | 3.4312 | 3.3625 | 3.3938 | 16906000.0 |
| 2000-04-07 13:00:00 | AMZN | Stock | 3.3969 | 3.4125 | 3.3375 | 3.3375 | 9108000.0 |
| 2000-04-07 14:00:00 | AMZN | Stock | 3.3375 | 3.375 | 3.3 | 3.3375 | 18234000.0 |
| 2000-04-07 15:00:00 | AMZN | Stock | 3.3344 | 3.4 | 3.3312 | 3.3938 | 12242000.0 |
| 2000-04-07 09:00:00 | CL | Stock | 29.5 | 29.75 | 29.4375 | 29.6875 | 180400.0 |
| 2000-04-07 10:00:00 | CL | Stock | 29.75 | 29.9062 | 29.5625 | 29.75 | 319600.0 |
| 2000-04-07 11:00:00 | CL | Stock | 29.8125 | 29.9375 | 29.7188 | 29.75 | 193400.0 |
| 2000-04-07 12:00:00 | CL | Stock | 29.75 | 30.0 | 29.75 | 29.8438 | 333600.0 |
| 2000-04-07 13:00:00 | CL | Stock | 29.875 | 29.875 | 29.625 | 29.625 | 281000.0 |
| 2000-04-07 14:00:00 | CL | Stock | 29.6562 | 29.7188 | 29.375 | 29.4688 | 346400.0 |
| 2000-04-07 15:00:00 | CL | Stock | 29.5 | 29.7188 | 29.4688 | 29.6562 | 741800.0 |
| 2000-04-07 16:00:00 | CL | Stock | 29.6875 | 29.6875 | 29.6562 | 29.6562 | 25600.0 |
> showing 38 of 13,610 rows — these rows as CSV