PREVIEW / stock_1hour / 2004-02-11
file: by_date/stock_1hour/2004/2004-02-11.parquet size: 504 KB rows: 22,981 symbols: 1,721
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-02-11 08:00:00 | AAPL | Stock | 0.4109 | 0.4109 | 0.4109 | 0.4109 | 11200.0 |
| 2004-02-11 09:00:00 | AAPL | Stock | 0.4118 | 0.4195 | 0.4114 | 0.4182 | 42061432.0 |
| 2004-02-11 10:00:00 | AAPL | Stock | 0.4184 | 0.4223 | 0.4161 | 0.4211 | 68818400.0 |
| 2004-02-11 11:00:00 | AAPL | Stock | 0.4213 | 0.4245 | 0.4202 | 0.4218 | 51421048.0 |
| 2004-02-11 12:00:00 | AAPL | Stock | 0.4218 | 0.4248 | 0.4216 | 0.4236 | 28888216.0 |
| 2004-02-11 13:00:00 | AAPL | Stock | 0.4234 | 0.4257 | 0.4227 | 0.4241 | 36198848.0 |
| 2004-02-11 14:00:00 | AAPL | Stock | 0.4245 | 0.4259 | 0.4232 | 0.4246 | 35546672.0 |
| 2004-02-11 15:00:00 | AAPL | Stock | 0.4246 | 0.4263 | 0.4232 | 0.4252 | 77023856.0 |
| 2004-02-11 16:00:00 | AAPL | Stock | 0.4252 | 0.4257 | 0.4234 | 0.4257 | 1881992.0 |
| 2004-02-11 17:00:00 | AAPL | Stock | 0.4263 | 0.4263 | 0.4257 | 0.4261 | 153440.0 |
| 2004-02-11 18:00:00 | AAPL | Stock | 0.4261 | 0.4261 | 0.4261 | 0.4261 | 84000.0 |
| 2004-02-11 08:00:00 | MSFT | Stock | 27.05 | 27.2 | 26.94 | 27.05 | 6410.0 |
| 2004-02-11 09:00:00 | MSFT | Stock | 27.05 | 27.07 | 26.9 | 26.94 | 4784235.0 |
| 2004-02-11 10:00:00 | MSFT | Stock | 26.93 | 26.96 | 26.85 | 26.89 | 7403063.0 |
| 2004-02-11 11:00:00 | MSFT | Stock | 26.89 | 27.14 | 26.89 | 27.13 | 9497595.0 |
| 2004-02-11 12:00:00 | MSFT | Stock | 27.13 | 27.15 | 27.02 | 27.03 | 4550376.0 |
| 2004-02-11 13:00:00 | MSFT | Stock | 27.02 | 27.07 | 26.96 | 27.06 | 5276462.0 |
| 2004-02-11 14:00:00 | MSFT | Stock | 27.06 | 27.13 | 27.02 | 27.07 | 6039211.0 |
| 2004-02-11 15:00:00 | MSFT | Stock | 27.07 | 27.2 | 27.02 | 27.15 | 11465370.0 |
| 2004-02-11 16:00:00 | MSFT | Stock | 27.17 | 27.21 | 27.14 | 27.15 | 660900.0 |
| 2004-02-11 17:00:00 | MSFT | Stock | 27.15 | 27.19 | 27.15 | 27.16 | 17460.0 |
| 2004-02-11 08:00:00 | NVDA | Stock | 0.1954 | 0.1967 | 0.1952 | 0.1967 | 1212000.0 |
| 2004-02-11 09:00:00 | NVDA | Stock | 0.1969 | 0.2007 | 0.1953 | 0.2007 | 151201320.0 |
| 2004-02-11 10:00:00 | NVDA | Stock | 0.2007 | 0.2021 | 0.1988 | 0.2 | 131566800.0 |
| 2004-02-11 11:00:00 | NVDA | Stock | 0.2 | 0.2027 | 0.1996 | 0.201 | 127695840.0 |
| 2004-02-11 12:00:00 | NVDA | Stock | 0.201 | 0.2018 | 0.2007 | 0.2009 | 45701280.0 |
| 2004-02-11 13:00:00 | NVDA | Stock | 0.201 | 0.2017 | 0.2 | 0.2012 | 63433680.0 |
| 2004-02-11 14:00:00 | NVDA | Stock | 0.2012 | 0.2017 | 0.2004 | 0.2012 | 49911000.0 |
| 2004-02-11 15:00:00 | NVDA | Stock | 0.201 | 0.2019 | 0.2 | 0.2019 | 139158000.0 |
| 2004-02-11 16:00:00 | NVDA | Stock | 0.2019 | 0.2021 | 0.2008 | 0.2013 | 19975320.0 |
| 2004-02-11 17:00:00 | NVDA | Stock | 0.2013 | 0.2021 | 0.2012 | 0.2012 | 348000.0 |
| 2004-02-11 18:00:00 | NVDA | Stock | 0.2013 | 0.2013 | 0.2013 | 0.2013 | 156000.0 |
| 2004-02-11 08:00:00 | AMZN | Stock | 2.29 | 2.29 | 2.2865 | 2.2885 | 81980.0 |
| 2004-02-11 09:00:00 | AMZN | Stock | 2.288 | 2.299 | 2.2815 | 2.2926 | 12774780.0 |
| 2004-02-11 10:00:00 | AMZN | Stock | 2.2925 | 2.303 | 2.277 | 2.299 | 17241960.0 |
| 2004-02-11 11:00:00 | AMZN | Stock | 2.2985 | 2.3345 | 2.2985 | 2.3235 | 30934220.0 |
| 2004-02-11 12:00:00 | AMZN | Stock | 2.3245 | 2.343 | 2.3229 | 2.338 | 23108480.0 |
| 2004-02-11 13:00:00 | AMZN | Stock | 2.339 | 2.3485 | 2.335 | 2.3455 | 14809740.0 |
| 2004-02-11 14:00:00 | AMZN | Stock | 2.3453 | 2.358 | 2.342 | 2.356 | 17862620.0 |
| 2004-02-11 15:00:00 | AMZN | Stock | 2.3565 | 2.3682 | 2.3485 | 2.3565 | 33471400.0 |
| 2004-02-11 16:00:00 | AMZN | Stock | 2.3565 | 2.367 | 2.3555 | 2.357 | 1483760.0 |
| 2004-02-11 17:00:00 | AMZN | Stock | 2.3585 | 2.3585 | 2.3585 | 2.3585 | 6000.0 |
| 2004-02-11 18:00:00 | AMZN | Stock | 2.36 | 2.36 | 2.359 | 2.36 | 57000.0 |
| 2004-02-11 09:00:00 | CL | Stock | 27.625 | 27.64 | 27.52 | 27.53 | 501200.0 |
| 2004-02-11 10:00:00 | CL | Stock | 27.535 | 27.585 | 27.425 | 27.445 | 1243400.0 |
| 2004-02-11 11:00:00 | CL | Stock | 27.445 | 27.57 | 27.445 | 27.495 | 845400.0 |
| 2004-02-11 12:00:00 | CL | Stock | 27.48 | 27.6005 | 27.46 | 27.6 | 479200.0 |
| 2004-02-11 13:00:00 | CL | Stock | 27.6 | 27.6 | 27.525 | 27.576 | 466600.0 |
| 2004-02-11 14:00:00 | CL | Stock | 27.575 | 27.625 | 27.51 | 27.525 | 340800.0 |
| 2004-02-11 15:00:00 | CL | Stock | 27.525 | 27.57 | 27.475 | 27.5 | 2030800.0 |
> showing 50 of 22,981 rows — these rows as CSV