PREVIEW / stock_1hour / 2004-03-03
file: by_date/stock_1hour/2004/2004-03-03.parquet size: 514 KB rows: 23,285 symbols: 1,723
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-03-03 08:00:00 | AAPL | Stock | 0.4209 | 0.425 | 0.4209 | 0.4238 | 90720.0 |
| 2004-03-03 09:00:00 | AAPL | Stock | 0.4232 | 0.4245 | 0.4214 | 0.423 | 13101312.0 |
| 2004-03-03 10:00:00 | AAPL | Stock | 0.4229 | 0.425 | 0.4214 | 0.4245 | 21789768.0 |
| 2004-03-03 11:00:00 | AAPL | Stock | 0.4245 | 0.4282 | 0.4245 | 0.428 | 16733360.0 |
| 2004-03-03 12:00:00 | AAPL | Stock | 0.428 | 0.4289 | 0.4275 | 0.4275 | 19796224.0 |
| 2004-03-03 13:00:00 | AAPL | Stock | 0.4279 | 0.4311 | 0.4277 | 0.4311 | 27727504.0 |
| 2004-03-03 14:00:00 | AAPL | Stock | 0.4311 | 0.432 | 0.4282 | 0.4284 | 32676056.0 |
| 2004-03-03 15:00:00 | AAPL | Stock | 0.4284 | 0.4303 | 0.4266 | 0.4266 | 59566248.0 |
| 2004-03-03 16:00:00 | AAPL | Stock | 0.4266 | 0.4286 | 0.426 | 0.427 | 6476064.0 |
| 2004-03-03 17:00:00 | AAPL | Stock | 0.4261 | 0.4261 | 0.4261 | 0.4261 | 411992.0 |
| 2004-03-03 08:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.38 | 26.39 | 1215952.0 |
| 2004-03-03 09:00:00 | MSFT | Stock | 26.39 | 26.48 | 26.33 | 26.47 | 3935653.0 |
| 2004-03-03 10:00:00 | MSFT | Stock | 26.48 | 26.55 | 26.36 | 26.43 | 8559624.0 |
| 2004-03-03 11:00:00 | MSFT | Stock | 26.429 | 26.44 | 26.38 | 26.4 | 4792629.0 |
| 2004-03-03 12:00:00 | MSFT | Stock | 26.4 | 26.425 | 26.22 | 26.29 | 8264728.0 |
| 2004-03-03 13:00:00 | MSFT | Stock | 26.29 | 26.43 | 26.27 | 26.35 | 6072742.0 |
| 2004-03-03 14:00:00 | MSFT | Stock | 26.35 | 26.42 | 26.3199 | 26.34 | 5088985.0 |
| 2004-03-03 15:00:00 | MSFT | Stock | 26.33 | 26.41 | 26.31 | 26.37 | 7122398.0 |
| 2004-03-03 16:00:00 | MSFT | Stock | 26.36 | 26.39 | 26.3468 | 26.35 | 1370619.0 |
| 2004-03-03 17:00:00 | MSFT | Stock | 26.37 | 26.3755 | 26.35 | 26.36 | 132559.0 |
| 2004-03-03 18:00:00 | MSFT | Stock | 26.37 | 26.37 | 26.37 | 26.37 | 3100.0 |
| 2004-03-03 08:00:00 | NVDA | Stock | 0.1846 | 0.1846 | 0.1846 | 0.1846 | 108000.0 |
| 2004-03-03 09:00:00 | NVDA | Stock | 0.1842 | 0.1842 | 0.1809 | 0.1827 | 51218400.0 |
| 2004-03-03 10:00:00 | NVDA | Stock | 0.1826 | 0.1833 | 0.1811 | 0.1812 | 54690600.0 |
| 2004-03-03 11:00:00 | NVDA | Stock | 0.1812 | 0.182 | 0.1792 | 0.1815 | 112083720.0 |
| 2004-03-03 12:00:00 | NVDA | Stock | 0.1814 | 0.1816 | 0.1806 | 0.1814 | 38693520.0 |
| 2004-03-03 13:00:00 | NVDA | Stock | 0.1814 | 0.1841 | 0.1812 | 0.1827 | 118545840.0 |
| 2004-03-03 14:00:00 | NVDA | Stock | 0.1827 | 0.1835 | 0.1822 | 0.1826 | 38024520.0 |
| 2004-03-03 15:00:00 | NVDA | Stock | 0.1826 | 0.1835 | 0.1823 | 0.1823 | 61505160.0 |
| 2004-03-03 16:00:00 | NVDA | Stock | 0.1828 | 0.1828 | 0.1817 | 0.1823 | 4112520.0 |
| 2004-03-03 08:00:00 | AMZN | Stock | 2.099 | 2.1 | 2.099 | 2.1 | 14000.0 |
| 2004-03-03 09:00:00 | AMZN | Stock | 2.098 | 2.1195 | 2.086 | 2.108 | 13379260.0 |
| 2004-03-03 10:00:00 | AMZN | Stock | 2.1085 | 2.119 | 2.092 | 2.0995 | 15469180.0 |
| 2004-03-03 11:00:00 | AMZN | Stock | 2.0994 | 2.1005 | 2.0919 | 2.094 | 9591940.0 |
| 2004-03-03 12:00:00 | AMZN | Stock | 2.0945 | 2.096 | 2.0825 | 2.0955 | 9977440.0 |
| 2004-03-03 13:00:00 | AMZN | Stock | 2.095 | 2.147 | 2.0935 | 2.1375 | 43624560.0 |
| 2004-03-03 14:00:00 | AMZN | Stock | 2.138 | 2.1482 | 2.132 | 2.1415 | 22096520.0 |
| 2004-03-03 15:00:00 | AMZN | Stock | 2.1415 | 2.169 | 2.1415 | 2.156 | 50260560.0 |
| 2004-03-03 16:00:00 | AMZN | Stock | 2.1565 | 2.161 | 2.1555 | 2.156 | 1909800.0 |
| 2004-03-03 17:00:00 | AMZN | Stock | 2.1565 | 2.1599 | 2.156 | 2.1595 | 1497980.0 |
| 2004-03-03 18:00:00 | AMZN | Stock | 2.156 | 2.156 | 2.1555 | 2.1555 | 22360.0 |
| 2004-03-03 09:00:00 | CL | Stock | 27.925 | 28.02 | 27.91 | 27.99 | 314000.0 |
| 2004-03-03 10:00:00 | CL | Stock | 27.99 | 28.07 | 27.98 | 28.035 | 424800.0 |
| 2004-03-03 11:00:00 | CL | Stock | 28.03 | 28.045 | 27.96 | 28.01 | 397200.0 |
| 2004-03-03 12:00:00 | CL | Stock | 28.015 | 28.025 | 27.955 | 28.0 | 560200.0 |
| 2004-03-03 13:00:00 | CL | Stock | 28.005 | 28.105 | 27.98 | 28.095 | 244600.0 |
| 2004-03-03 14:00:00 | CL | Stock | 28.095 | 28.13 | 28.085 | 28.115 | 216400.0 |
| 2004-03-03 15:00:00 | CL | Stock | 28.12 | 28.19 | 28.1 | 28.175 | 413400.0 |
| 2004-03-03 16:00:00 | CL | Stock | 28.155 | 28.155 | 28.054 | 28.054 | 202400.0 |
> showing 49 of 23,285 rows — these rows as CSV