PREVIEW / stock_30min / 2004-01-09
file: by_date/stock_30min/2004/2004-01-09.parquet size: 762 KB rows: 40,405 symbols: 1,712
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-01-09 08:30:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4136 | 0.4175 | 1135456.0 |
| 2004-01-09 09:00:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4136 | 0.4159 | 795200.0 |
| 2004-01-09 09:30:00 | AAPL | Stock | 0.4148 | 0.4275 | 0.4143 | 0.4261 | 72476992.0 |
| 2004-01-09 10:00:00 | AAPL | Stock | 0.4261 | 0.4309 | 0.4239 | 0.4254 | 72641800.0 |
| 2004-01-09 10:30:00 | AAPL | Stock | 0.425 | 0.427 | 0.4234 | 0.4265 | 25693752.0 |
| 2004-01-09 11:00:00 | AAPL | Stock | 0.4266 | 0.4268 | 0.4234 | 0.425 | 18462360.0 |
| 2004-01-09 11:30:00 | AAPL | Stock | 0.425 | 0.4259 | 0.4214 | 0.4225 | 20967016.0 |
| 2004-01-09 12:00:00 | AAPL | Stock | 0.4225 | 0.4241 | 0.4219 | 0.4234 | 13066256.0 |
| 2004-01-09 12:30:00 | AAPL | Stock | 0.4236 | 0.4236 | 0.4196 | 0.4202 | 15064168.0 |
| 2004-01-09 13:00:00 | AAPL | Stock | 0.4205 | 0.4239 | 0.4204 | 0.4228 | 10671360.0 |
| 2004-01-09 13:30:00 | AAPL | Stock | 0.4228 | 0.4229 | 0.4189 | 0.4202 | 11881632.0 |
| 2004-01-09 14:00:00 | AAPL | Stock | 0.4205 | 0.422 | 0.4168 | 0.4179 | 18282376.0 |
| 2004-01-09 14:30:00 | AAPL | Stock | 0.4175 | 0.4179 | 0.407 | 0.408 | 51702056.0 |
| 2004-01-09 15:00:00 | AAPL | Stock | 0.408 | 0.4127 | 0.408 | 0.4109 | 36264704.0 |
| 2004-01-09 15:30:00 | AAPL | Stock | 0.4105 | 0.4127 | 0.4104 | 0.4104 | 36846600.0 |
| 2004-01-09 16:00:00 | AAPL | Stock | 0.4104 | 0.4116 | 0.4098 | 0.41 | 1923152.0 |
| 2004-01-09 16:30:00 | AAPL | Stock | 0.412 | 0.4121 | 0.4116 | 0.4121 | 47600.0 |
| 2004-01-09 17:00:00 | AAPL | Stock | 0.4102 | 0.4121 | 0.4102 | 0.4116 | 1231552.0 |
| 2004-01-09 17:30:00 | AAPL | Stock | 0.4121 | 0.4127 | 0.4111 | 0.4127 | 67200.0 |
| 2004-01-09 18:00:00 | AAPL | Stock | 0.4103 | 0.4125 | 0.4102 | 0.4102 | 454160.0 |
| 2004-01-09 08:00:00 | MSFT | Stock | 28.27 | 28.27 | 28.02 | 28.17 | 7900.0 |
| 2004-01-09 08:30:00 | MSFT | Stock | 28.17 | 28.17 | 28.0 | 28.0 | 128715.0 |
| 2004-01-09 09:00:00 | MSFT | Stock | 28.01 | 28.05 | 28.0 | 28.02 | 89075.0 |
| 2004-01-09 09:30:00 | MSFT | Stock | 28.03 | 28.04 | 27.82 | 27.9 | 9608992.0 |
| 2004-01-09 10:00:00 | MSFT | Stock | 27.9 | 27.99 | 27.74 | 27.75 | 7355401.0 |
| 2004-01-09 10:30:00 | MSFT | Stock | 27.75 | 27.9 | 27.73 | 27.86 | 5048123.0 |
| 2004-01-09 11:00:00 | MSFT | Stock | 27.86 | 27.9 | 27.8 | 27.85 | 3616662.0 |
| 2004-01-09 11:30:00 | MSFT | Stock | 27.86 | 27.87 | 27.77 | 27.83 | 3519461.0 |
| 2004-01-09 12:00:00 | MSFT | Stock | 27.82 | 27.83 | 27.77 | 27.77 | 3196475.0 |
| 2004-01-09 12:30:00 | MSFT | Stock | 27.78 | 27.8 | 27.75 | 27.8 | 3525233.0 |
| 2004-01-09 13:00:00 | MSFT | Stock | 27.8 | 27.88 | 27.79 | 27.86 | 2579788.0 |
| 2004-01-09 13:30:00 | MSFT | Stock | 27.86 | 27.9 | 27.8 | 27.88 | 2977167.0 |
| 2004-01-09 14:00:00 | MSFT | Stock | 27.8803 | 27.91 | 27.83 | 27.87 | 4441046.0 |
| 2004-01-09 14:30:00 | MSFT | Stock | 27.86 | 27.87 | 27.72 | 27.77 | 4939381.0 |
| 2004-01-09 15:00:00 | MSFT | Stock | 27.77 | 27.79 | 27.68 | 27.69 | 4771501.0 |
| 2004-01-09 15:30:00 | MSFT | Stock | 27.68 | 27.73 | 27.59 | 27.62 | 8130731.0 |
| 2004-01-09 16:00:00 | MSFT | Stock | 27.62 | 28.23 | 27.57 | 27.63 | 585393.0 |
| 2004-01-09 16:30:00 | MSFT | Stock | 27.64 | 27.64 | 27.6 | 27.62 | 18673.0 |
| 2004-01-09 17:00:00 | MSFT | Stock | 27.63 | 27.63 | 27.6 | 27.6 | 649080.0 |
| 2004-01-09 17:30:00 | MSFT | Stock | 27.63 | 27.68 | 27.62 | 27.68 | 14927.0 |
| 2004-01-09 18:00:00 | MSFT | Stock | 27.6385 | 27.68 | 27.63 | 27.66 | 59176.0 |
| 2004-01-09 08:00:00 | NVDA | Stock | 0.2083 | 0.2083 | 0.2083 | 0.2083 | 132000.0 |
| 2004-01-09 08:30:00 | NVDA | Stock | 0.2085 | 0.2085 | 0.2075 | 0.2076 | 1740000.0 |
| 2004-01-09 09:00:00 | NVDA | Stock | 0.2076 | 0.2078 | 0.2073 | 0.2074 | 34308000.0 |
| 2004-01-09 09:30:00 | NVDA | Stock | 0.2075 | 0.2108 | 0.2062 | 0.2087 | 136263120.0 |
| 2004-01-09 10:00:00 | NVDA | Stock | 0.2087 | 0.2102 | 0.2083 | 0.209 | 38787960.0 |
| 2004-01-09 10:30:00 | NVDA | Stock | 0.2091 | 0.2119 | 0.2091 | 0.2116 | 75439680.0 |
| 2004-01-09 11:00:00 | NVDA | Stock | 0.2115 | 0.2119 | 0.211 | 0.2118 | 56666280.0 |
| 2004-01-09 11:30:00 | NVDA | Stock | 0.2118 | 0.2148 | 0.2117 | 0.2148 | 57037680.0 |
| 2004-01-09 12:00:00 | NVDA | Stock | 0.2148 | 0.2148 | 0.2128 | 0.2132 | 43024080.0 |
> showing 50 of 40,405 rows — these rows as CSV