PREVIEW / stock_1hour / 2003-06-26
file: by_date/stock_1hour/2003/2003-06-26.parquet size: 452 KB rows: 21,291 symbols: 1,589
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-26 08:00:00 | AAPL | Stock | 0.3455 | 0.3455 | 0.3455 | 0.3455 | 5600.0 |
| 2003-06-26 09:00:00 | AAPL | Stock | 0.3404 | 0.3421 | 0.3339 | 0.3402 | 20588904.0 |
| 2003-06-26 10:00:00 | AAPL | Stock | 0.3396 | 0.342 | 0.3382 | 0.3404 | 25925424.0 |
| 2003-06-26 11:00:00 | AAPL | Stock | 0.3404 | 0.3429 | 0.34 | 0.3425 | 14902104.0 |
| 2003-06-26 12:00:00 | AAPL | Stock | 0.3425 | 0.3429 | 0.3405 | 0.3409 | 11659256.0 |
| 2003-06-26 13:00:00 | AAPL | Stock | 0.3409 | 0.3432 | 0.3404 | 0.3423 | 10329424.0 |
| 2003-06-26 14:00:00 | AAPL | Stock | 0.3421 | 0.3434 | 0.3409 | 0.3423 | 18776128.0 |
| 2003-06-26 15:00:00 | AAPL | Stock | 0.3423 | 0.3443 | 0.34 | 0.3443 | 36691312.0 |
| 2003-06-26 16:00:00 | AAPL | Stock | 0.3445 | 0.345 | 0.3405 | 0.3422 | 4167576.0 |
| 2003-06-26 08:00:00 | MSFT | Stock | 25.4 | 25.429 | 25.01 | 25.4 | 97074.0 |
| 2003-06-26 09:00:00 | MSFT | Stock | 25.361 | 25.56 | 25.21 | 25.47 | 7394036.0 |
| 2003-06-26 10:00:00 | MSFT | Stock | 25.47 | 25.5311 | 25.35 | 25.45 | 7454166.0 |
| 2003-06-26 11:00:00 | MSFT | Stock | 25.44 | 25.69 | 25.37 | 25.69 | 5325617.0 |
| 2003-06-26 12:00:00 | MSFT | Stock | 25.7 | 25.72 | 25.54 | 25.61 | 4094929.0 |
| 2003-06-26 13:00:00 | MSFT | Stock | 25.61 | 25.66 | 25.57 | 25.6 | 2830444.0 |
| 2003-06-26 14:00:00 | MSFT | Stock | 25.6 | 25.95 | 25.6 | 25.81 | 8854657.0 |
| 2003-06-26 15:00:00 | MSFT | Stock | 25.81 | 25.82 | 25.56 | 25.73 | 8597469.0 |
| 2003-06-26 16:00:00 | MSFT | Stock | 25.74 | 26.51 | 25.68 | 25.75 | 856710.0 |
| 2003-06-26 17:00:00 | MSFT | Stock | 25.74 | 25.79 | 25.71 | 25.74 | 15940.0 |
| 2003-06-26 18:00:00 | MSFT | Stock | 25.72 | 25.77 | 25.72 | 25.75 | 62360.0 |
| 2003-06-26 08:00:00 | NVDA | Stock | 0.1922 | 0.1932 | 0.1922 | 0.1923 | 1728000.0 |
| 2003-06-26 09:00:00 | NVDA | Stock | 0.1923 | 0.194 | 0.191 | 0.1925 | 115443120.0 |
| 2003-06-26 10:00:00 | NVDA | Stock | 0.1925 | 0.1931 | 0.1857 | 0.188 | 229331880.0 |
| 2003-06-26 11:00:00 | NVDA | Stock | 0.1881 | 0.1904 | 0.1875 | 0.1901 | 98106720.0 |
| 2003-06-26 12:00:00 | NVDA | Stock | 0.19 | 0.1917 | 0.1892 | 0.19 | 128606880.0 |
| 2003-06-26 13:00:00 | NVDA | Stock | 0.19 | 0.1912 | 0.19 | 0.1902 | 35220240.0 |
| 2003-06-26 14:00:00 | NVDA | Stock | 0.1903 | 0.1922 | 0.1903 | 0.1911 | 105699000.0 |
| 2003-06-26 15:00:00 | NVDA | Stock | 0.1912 | 0.1917 | 0.1902 | 0.1912 | 122250480.0 |
| 2003-06-26 16:00:00 | NVDA | Stock | 0.1912 | 0.1923 | 0.191 | 0.1912 | 6081240.0 |
| 2003-06-26 17:00:00 | NVDA | Stock | 0.1904 | 0.1904 | 0.1904 | 0.1904 | 684000.0 |
| 2003-06-26 18:00:00 | NVDA | Stock | 0.1912 | 0.1917 | 0.1908 | 0.1917 | 84000.0 |
| 2003-06-26 08:00:00 | AMZN | Stock | 1.767 | 1.778 | 1.765 | 1.778 | 34000.0 |
| 2003-06-26 09:00:00 | AMZN | Stock | 1.77 | 1.771 | 1.753 | 1.7605 | 21261740.0 |
| 2003-06-26 10:00:00 | AMZN | Stock | 1.7605 | 1.77 | 1.757 | 1.7625 | 23755920.0 |
| 2003-06-26 11:00:00 | AMZN | Stock | 1.7625 | 1.7925 | 1.7595 | 1.792 | 18842480.0 |
| 2003-06-26 12:00:00 | AMZN | Stock | 1.792 | 1.8115 | 1.7875 | 1.808 | 25244300.0 |
| 2003-06-26 13:00:00 | AMZN | Stock | 1.807 | 1.8121 | 1.8065 | 1.81 | 13877980.0 |
| 2003-06-26 14:00:00 | AMZN | Stock | 1.81 | 1.8345 | 1.81 | 1.825 | 34758440.0 |
| 2003-06-26 15:00:00 | AMZN | Stock | 1.825 | 1.842 | 1.8125 | 1.8354 | 40491220.0 |
| 2003-06-26 16:00:00 | AMZN | Stock | 1.836 | 1.844 | 1.83 | 1.8425 | 1804060.0 |
| 2003-06-26 17:00:00 | AMZN | Stock | 1.8355 | 1.844 | 1.7991 | 1.844 | 370000.0 |
| 2003-06-26 18:00:00 | AMZN | Stock | 1.844 | 1.845 | 1.8435 | 1.845 | 30000.0 |
| 2003-06-26 09:00:00 | CL | Stock | 29.15 | 29.405 | 28.91 | 28.995 | 875000.0 |
| 2003-06-26 10:00:00 | CL | Stock | 29.006 | 29.075 | 28.89 | 28.97 | 815800.0 |
| 2003-06-26 11:00:00 | CL | Stock | 28.97 | 29.02 | 28.91 | 28.94 | 312800.0 |
| 2003-06-26 12:00:00 | CL | Stock | 28.94 | 28.955 | 28.86 | 28.88 | 377400.0 |
| 2003-06-26 13:00:00 | CL | Stock | 28.885 | 28.94 | 28.86 | 28.865 | 437200.0 |
| 2003-06-26 14:00:00 | CL | Stock | 28.865 | 28.945 | 28.865 | 28.92 | 553400.0 |
| 2003-06-26 15:00:00 | CL | Stock | 28.92 | 29.205 | 28.92 | 29.16 | 1302800.0 |
| 2003-06-26 16:00:00 | CL | Stock | 29.155 | 29.16 | 29.155 | 29.16 | 71400.0 |
> showing 50 of 21,291 rows — these rows as CSV