PREVIEW / stock_1hour / 2005-05-25
file: by_date/stock_1hour/2005/2005-05-25.parquet size: 542 KB rows: 26,068 symbols: 1,985
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-25 08:00:00 | AAPL | Stock | 1.4125 | 1.4179 | 1.4114 | 1.4179 | 1012564.0 |
| 2005-05-25 09:00:00 | AAPL | Stock | 1.4182 | 1.4246 | 1.4043 | 1.4218 | 70947548.0 |
| 2005-05-25 10:00:00 | AAPL | Stock | 1.4218 | 1.4236 | 1.4118 | 1.4161 | 84252868.0 |
| 2005-05-25 11:00:00 | AAPL | Stock | 1.4164 | 1.4193 | 1.4125 | 1.4179 | 37888004.0 |
| 2005-05-25 12:00:00 | AAPL | Stock | 1.4179 | 1.4268 | 1.4175 | 1.4221 | 44338028.0 |
| 2005-05-25 13:00:00 | AAPL | Stock | 1.4221 | 1.4229 | 1.4114 | 1.4142 | 39080692.0 |
| 2005-05-25 14:00:00 | AAPL | Stock | 1.4143 | 1.4204 | 1.4139 | 1.42 | 42717640.0 |
| 2005-05-25 15:00:00 | AAPL | Stock | 1.42 | 1.425 | 1.4171 | 1.4207 | 68621644.0 |
| 2005-05-25 16:00:00 | AAPL | Stock | 1.4207 | 1.4211 | 1.4179 | 1.4196 | 2080120.0 |
| 2005-05-25 17:00:00 | AAPL | Stock | 1.4196 | 1.4264 | 1.4196 | 1.4214 | 17746596.0 |
| 2005-05-25 18:00:00 | AAPL | Stock | 1.4214 | 1.425 | 1.4214 | 1.4225 | 19600.0 |
| 2005-05-25 08:00:00 | MSFT | Stock | 25.72 | 25.75 | 25.71 | 25.71 | 13450.0 |
| 2005-05-25 09:00:00 | MSFT | Stock | 25.73 | 25.75 | 25.62 | 25.63 | 4757302.0 |
| 2005-05-25 10:00:00 | MSFT | Stock | 25.63 | 25.72 | 25.52 | 25.59 | 7252173.0 |
| 2005-05-25 11:00:00 | MSFT | Stock | 25.58 | 25.61 | 25.5 | 25.6 | 6124092.0 |
| 2005-05-25 12:00:00 | MSFT | Stock | 25.598 | 25.64 | 25.59 | 25.61 | 2462362.0 |
| 2005-05-25 13:00:00 | MSFT | Stock | 25.61 | 25.63 | 25.54 | 25.6 | 3764163.0 |
| 2005-05-25 14:00:00 | MSFT | Stock | 25.6 | 25.65 | 25.56 | 25.64 | 2740286.0 |
| 2005-05-25 15:00:00 | MSFT | Stock | 25.632 | 25.77 | 25.63 | 25.73 | 6343959.0 |
| 2005-05-25 16:00:00 | MSFT | Stock | 25.73 | 25.74 | 25.669 | 25.71 | 860870.0 |
| 2005-05-25 17:00:00 | MSFT | Stock | 25.71 | 25.71 | 25.7 | 25.7 | 610350.0 |
| 2005-05-25 18:00:00 | MSFT | Stock | 25.73 | 25.74 | 25.7 | 25.7 | 2100.0 |
| 2005-05-25 08:00:00 | NVDA | Stock | 0.225 | 0.2258 | 0.225 | 0.2258 | 138000.0 |
| 2005-05-25 09:00:00 | NVDA | Stock | 0.2272 | 0.2287 | 0.2252 | 0.2258 | 91264200.0 |
| 2005-05-25 10:00:00 | NVDA | Stock | 0.2259 | 0.2259 | 0.2223 | 0.2225 | 132790320.0 |
| 2005-05-25 11:00:00 | NVDA | Stock | 0.2226 | 0.2237 | 0.2224 | 0.2236 | 53712000.0 |
| 2005-05-25 12:00:00 | NVDA | Stock | 0.2237 | 0.2253 | 0.2234 | 0.2247 | 48028680.0 |
| 2005-05-25 13:00:00 | NVDA | Stock | 0.2247 | 0.2247 | 0.2233 | 0.2239 | 32906280.0 |
| 2005-05-25 14:00:00 | NVDA | Stock | 0.2239 | 0.2252 | 0.2237 | 0.2243 | 44250960.0 |
| 2005-05-25 15:00:00 | NVDA | Stock | 0.2245 | 0.2258 | 0.2238 | 0.2245 | 93232320.0 |
| 2005-05-25 16:00:00 | NVDA | Stock | 0.2244 | 0.2246 | 0.2243 | 0.2245 | 15291240.0 |
| 2005-05-25 17:00:00 | NVDA | Stock | 0.225 | 0.2252 | 0.225 | 0.2252 | 162000.0 |
| 2005-05-25 18:00:00 | NVDA | Stock | 0.2252 | 0.2252 | 0.2234 | 0.2234 | 204000.0 |
| 2005-05-25 08:00:00 | AMZN | Stock | 1.7765 | 1.7765 | 1.7725 | 1.7725 | 14000.0 |
| 2005-05-25 09:00:00 | AMZN | Stock | 1.7655 | 1.7655 | 1.7595 | 1.7635 | 10238760.0 |
| 2005-05-25 10:00:00 | AMZN | Stock | 1.7635 | 1.7725 | 1.763 | 1.766 | 16695540.0 |
| 2005-05-25 11:00:00 | AMZN | Stock | 1.7665 | 1.769 | 1.7625 | 1.7651 | 7077260.0 |
| 2005-05-25 12:00:00 | AMZN | Stock | 1.7655 | 1.7665 | 1.7635 | 1.764 | 3548220.0 |
| 2005-05-25 13:00:00 | AMZN | Stock | 1.764 | 1.764 | 1.7605 | 1.7615 | 6984960.0 |
| 2005-05-25 14:00:00 | AMZN | Stock | 1.762 | 1.7635 | 1.76 | 1.763 | 15131340.0 |
| 2005-05-25 15:00:00 | AMZN | Stock | 1.7635 | 1.7635 | 1.7605 | 1.762 | 16449560.0 |
| 2005-05-25 16:00:00 | AMZN | Stock | 1.7615 | 1.7645 | 1.76 | 1.7625 | 316860.0 |
| 2005-05-25 17:00:00 | AMZN | Stock | 1.7625 | 1.7625 | 1.7625 | 1.7625 | 74000.0 |
| 2005-05-25 09:00:00 | CL | Stock | 25.385 | 25.44 | 25.305 | 25.405 | 287000.0 |
| 2005-05-25 10:00:00 | CL | Stock | 25.42 | 25.44 | 25.26 | 25.265 | 413200.0 |
| 2005-05-25 11:00:00 | CL | Stock | 25.27 | 25.29 | 25.175 | 25.19 | 312200.0 |
| 2005-05-25 12:00:00 | CL | Stock | 25.19 | 25.245 | 25.165 | 25.22 | 143000.0 |
| 2005-05-25 13:00:00 | CL | Stock | 25.215 | 25.23 | 25.13 | 25.205 | 276200.0 |
| 2005-05-25 14:00:00 | CL | Stock | 25.205 | 25.275 | 25.185 | 25.25 | 628600.0 |
| 2005-05-25 15:00:00 | CL | Stock | 25.255 | 25.2705 | 25.23 | 25.245 | 561600.0 |
> showing 50 of 26,068 rows — these rows as CSV