PREVIEW / stock_1hour / 2004-02-05
file: by_date/stock_1hour/2004/2004-02-05.parquet size: 503 KB rows: 23,134 symbols: 1,711
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-05 08:00:00 | AAPL | Stock | 0.3893 | 0.3904 | 0.3893 | 0.3893 | 72800.0 |
| 2004-02-05 09:00:00 | AAPL | Stock | 0.3904 | 0.3961 | 0.3895 | 0.3934 | 33153736.0 |
| 2004-02-05 10:00:00 | AAPL | Stock | 0.3932 | 0.3948 | 0.3927 | 0.3938 | 38148320.0 |
| 2004-02-05 11:00:00 | AAPL | Stock | 0.3939 | 0.3959 | 0.3929 | 0.3955 | 26076736.0 |
| 2004-02-05 12:00:00 | AAPL | Stock | 0.3957 | 0.4 | 0.3955 | 0.4 | 43105496.0 |
| 2004-02-05 13:00:00 | AAPL | Stock | 0.4 | 0.4027 | 0.4 | 0.402 | 44093616.0 |
| 2004-02-05 14:00:00 | AAPL | Stock | 0.402 | 0.4046 | 0.3979 | 0.3982 | 38589040.0 |
| 2004-02-05 15:00:00 | AAPL | Stock | 0.398 | 0.4091 | 0.398 | 0.3998 | 86014320.0 |
| 2004-02-05 16:00:00 | AAPL | Stock | 0.3998 | 0.4022 | 0.3966 | 0.3996 | 11584216.0 |
| 2004-02-05 17:00:00 | AAPL | Stock | 0.3991 | 0.3996 | 0.3991 | 0.3996 | 39872.0 |
| 2004-02-05 08:00:00 | MSFT | Stock | 27.02 | 27.5 | 27.02 | 27.12 | 36620.0 |
| 2004-02-05 09:00:00 | MSFT | Stock | 27.12 | 27.16 | 27.0 | 27.08 | 6979644.0 |
| 2004-02-05 10:00:00 | MSFT | Stock | 27.08 | 27.13 | 27.02 | 27.03 | 6798809.0 |
| 2004-02-05 11:00:00 | MSFT | Stock | 27.04 | 27.06 | 26.83 | 26.9 | 10102229.0 |
| 2004-02-05 12:00:00 | MSFT | Stock | 26.9 | 27.06 | 26.88 | 27.05 | 4627537.0 |
| 2004-02-05 13:00:00 | MSFT | Stock | 27.04 | 27.17 | 26.93 | 26.95 | 7134424.0 |
| 2004-02-05 14:00:00 | MSFT | Stock | 26.95 | 27.05 | 26.92 | 26.98 | 5955733.0 |
| 2004-02-05 15:00:00 | MSFT | Stock | 26.99 | 27.12 | 26.95 | 26.96 | 10690778.0 |
| 2004-02-05 16:00:00 | MSFT | Stock | 26.96 | 27.06 | 26.95 | 26.99 | 1097644.0 |
| 2004-02-05 17:00:00 | MSFT | Stock | 26.97 | 27.0159 | 26.94 | 26.95 | 52244.0 |
| 2004-02-05 18:00:00 | MSFT | Stock | 26.96 | 26.98 | 26.95 | 26.96 | 5387.0 |
| 2004-02-05 08:00:00 | NVDA | Stock | 0.183 | 0.1846 | 0.183 | 0.1842 | 360000.0 |
| 2004-02-05 09:00:00 | NVDA | Stock | 0.1841 | 0.1864 | 0.1825 | 0.185 | 39609960.0 |
| 2004-02-05 10:00:00 | NVDA | Stock | 0.185 | 0.1869 | 0.185 | 0.185 | 48740400.0 |
| 2004-02-05 11:00:00 | NVDA | Stock | 0.185 | 0.1851 | 0.1834 | 0.1843 | 39448920.0 |
| 2004-02-05 12:00:00 | NVDA | Stock | 0.1842 | 0.1848 | 0.1832 | 0.1846 | 23315400.0 |
| 2004-02-05 13:00:00 | NVDA | Stock | 0.1846 | 0.186 | 0.1844 | 0.1855 | 27381600.0 |
| 2004-02-05 14:00:00 | NVDA | Stock | 0.1856 | 0.1872 | 0.1856 | 0.1865 | 49641960.0 |
| 2004-02-05 15:00:00 | NVDA | Stock | 0.1865 | 0.1875 | 0.1853 | 0.1854 | 89331600.0 |
| 2004-02-05 16:00:00 | NVDA | Stock | 0.1853 | 0.1858 | 0.185 | 0.1858 | 1600680.0 |
| 2004-02-05 17:00:00 | NVDA | Stock | 0.1853 | 0.1857 | 0.1853 | 0.1857 | 56880.0 |
| 2004-02-05 18:00:00 | NVDA | Stock | 0.1858 | 0.1858 | 0.1858 | 0.1858 | 60000.0 |
| 2004-02-05 08:00:00 | AMZN | Stock | 2.289 | 2.2905 | 2.2825 | 2.2825 | 286000.0 |
| 2004-02-05 09:00:00 | AMZN | Stock | 2.2825 | 2.3305 | 2.28 | 2.317 | 54880740.0 |
| 2004-02-05 10:00:00 | AMZN | Stock | 2.318 | 2.3465 | 2.316 | 2.335 | 56951600.0 |
| 2004-02-05 11:00:00 | AMZN | Stock | 2.337 | 2.3475 | 2.3275 | 2.336 | 28349260.0 |
| 2004-02-05 12:00:00 | AMZN | Stock | 2.336 | 2.342 | 2.3145 | 2.3225 | 20560780.0 |
| 2004-02-05 13:00:00 | AMZN | Stock | 2.3225 | 2.3425 | 2.3175 | 2.3395 | 23022640.0 |
| 2004-02-05 14:00:00 | AMZN | Stock | 2.34 | 2.3545 | 2.3135 | 2.32 | 29243760.0 |
| 2004-02-05 15:00:00 | AMZN | Stock | 2.32 | 2.3235 | 2.299 | 2.302 | 36501060.0 |
| 2004-02-05 16:00:00 | AMZN | Stock | 2.3005 | 2.3215 | 2.2985 | 2.303 | 2408940.0 |
| 2004-02-05 17:00:00 | AMZN | Stock | 2.3025 | 2.3264 | 2.3 | 2.305 | 152980.0 |
| 2004-02-05 18:00:00 | AMZN | Stock | 2.305 | 2.305 | 2.3 | 2.305 | 38340.0 |
| 2004-02-05 09:00:00 | CL | Stock | 27.0 | 27.035 | 26.915 | 27.03 | 919000.0 |
| 2004-02-05 10:00:00 | CL | Stock | 27.025 | 27.07 | 26.96 | 27.0 | 1292400.0 |
| 2004-02-05 11:00:00 | CL | Stock | 26.995 | 27.1 | 26.995 | 27.065 | 632600.0 |
| 2004-02-05 12:00:00 | CL | Stock | 27.065 | 27.095 | 27.0 | 27.035 | 620000.0 |
| 2004-02-05 13:00:00 | CL | Stock | 27.05 | 27.25 | 27.01 | 27.225 | 1243200.0 |
| 2004-02-05 14:00:00 | CL | Stock | 27.224 | 27.275 | 27.13 | 27.235 | 1416200.0 |
| 2004-02-05 15:00:00 | CL | Stock | 27.225 | 27.355 | 27.225 | 27.33 | 1639800.0 |
> showing 50 of 23,134 rows — these rows as CSV