PREVIEW / stock_1hour / 2003-06-17
file: by_date/stock_1hour/2003/2003-06-17.parquet size: 457 KB rows: 21,628 symbols: 1,585
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-17 08:00:00 | AAPL | Stock | 0.3263 | 0.3268 | 0.3263 | 0.3264 | 2938152.0 |
| 2003-06-17 09:00:00 | AAPL | Stock | 0.327 | 0.3304 | 0.3223 | 0.3246 | 35586768.0 |
| 2003-06-17 10:00:00 | AAPL | Stock | 0.3245 | 0.3275 | 0.3213 | 0.3239 | 34077232.0 |
| 2003-06-17 11:00:00 | AAPL | Stock | 0.3239 | 0.3252 | 0.3234 | 0.3239 | 16501688.0 |
| 2003-06-17 12:00:00 | AAPL | Stock | 0.3239 | 0.3241 | 0.3216 | 0.3229 | 8786176.0 |
| 2003-06-17 13:00:00 | AAPL | Stock | 0.3229 | 0.3239 | 0.3214 | 0.3216 | 13055728.0 |
| 2003-06-17 14:00:00 | AAPL | Stock | 0.3216 | 0.3259 | 0.3213 | 0.3254 | 17921624.0 |
| 2003-06-17 15:00:00 | AAPL | Stock | 0.3254 | 0.3259 | 0.3224 | 0.3248 | 24307584.0 |
| 2003-06-17 16:00:00 | AAPL | Stock | 0.3243 | 0.3263 | 0.3229 | 0.3248 | 4356800.0 |
| 2003-06-17 18:00:00 | AAPL | Stock | 0.3254 | 0.3254 | 0.3254 | 0.3254 | 30800.0 |
| 2003-06-17 08:00:00 | MSFT | Stock | 25.6 | 25.85 | 25.38 | 25.83 | 1211922.0 |
| 2003-06-17 09:00:00 | MSFT | Stock | 25.83 | 25.901 | 25.53 | 25.9 | 23790440.0 |
| 2003-06-17 10:00:00 | MSFT | Stock | 25.89 | 26.0 | 25.75 | 25.8599 | 19575705.0 |
| 2003-06-17 11:00:00 | MSFT | Stock | 25.86 | 26.07 | 25.84 | 26.07 | 17798243.0 |
| 2003-06-17 12:00:00 | MSFT | Stock | 26.05 | 26.1 | 25.91 | 26.0 | 9487853.0 |
| 2003-06-17 13:00:00 | MSFT | Stock | 25.99 | 26.02 | 25.92 | 25.94 | 7051704.0 |
| 2003-06-17 14:00:00 | MSFT | Stock | 25.9411 | 26.105 | 25.92 | 26.08 | 10759869.0 |
| 2003-06-17 15:00:00 | MSFT | Stock | 26.08 | 26.14 | 25.89 | 25.92 | 18102628.0 |
| 2003-06-17 16:00:00 | MSFT | Stock | 25.91 | 26.1 | 25.89 | 25.93 | 1602775.0 |
| 2003-06-17 17:00:00 | MSFT | Stock | 25.9 | 25.98 | 25.9 | 25.92 | 12701.0 |
| 2003-06-17 18:00:00 | MSFT | Stock | 25.92 | 25.93 | 25.88 | 25.91 | 9154.0 |
| 2003-06-17 08:00:00 | NVDA | Stock | 0.1998 | 0.2035 | 0.1998 | 0.2035 | 1717800.0 |
| 2003-06-17 09:00:00 | NVDA | Stock | 0.2035 | 0.2052 | 0.1983 | 0.2004 | 203882640.0 |
| 2003-06-17 10:00:00 | NVDA | Stock | 0.2004 | 0.2021 | 0.1987 | 0.2011 | 146751240.0 |
| 2003-06-17 11:00:00 | NVDA | Stock | 0.2012 | 0.2045 | 0.2004 | 0.2042 | 136277400.0 |
| 2003-06-17 12:00:00 | NVDA | Stock | 0.2042 | 0.2042 | 0.2021 | 0.2026 | 50033640.0 |
| 2003-06-17 13:00:00 | NVDA | Stock | 0.2026 | 0.2039 | 0.2025 | 0.2028 | 62548800.0 |
| 2003-06-17 14:00:00 | NVDA | Stock | 0.2028 | 0.2058 | 0.2016 | 0.2052 | 143769120.0 |
| 2003-06-17 15:00:00 | NVDA | Stock | 0.2051 | 0.2054 | 0.2026 | 0.2043 | 155212440.0 |
| 2003-06-17 16:00:00 | NVDA | Stock | 0.2045 | 0.205 | 0.2042 | 0.205 | 9132120.0 |
| 2003-06-17 17:00:00 | NVDA | Stock | 0.2039 | 0.2047 | 0.2039 | 0.2047 | 72000.0 |
| 2003-06-17 18:00:00 | NVDA | Stock | 0.2047 | 0.2047 | 0.204 | 0.204 | 360000.0 |
| 2003-06-17 08:00:00 | AMZN | Stock | 1.792 | 1.805 | 1.792 | 1.794 | 1121400.0 |
| 2003-06-17 09:00:00 | AMZN | Stock | 1.7945 | 1.8185 | 1.7665 | 1.7925 | 32085360.0 |
| 2003-06-17 10:00:00 | AMZN | Stock | 1.7945 | 1.815 | 1.7645 | 1.7785 | 35478740.0 |
| 2003-06-17 11:00:00 | AMZN | Stock | 1.779 | 1.7915 | 1.7715 | 1.783 | 16802780.0 |
| 2003-06-17 12:00:00 | AMZN | Stock | 1.7835 | 1.785 | 1.774 | 1.779 | 9396400.0 |
| 2003-06-17 13:00:00 | AMZN | Stock | 1.7795 | 1.7955 | 1.779 | 1.782 | 13932040.0 |
| 2003-06-17 14:00:00 | AMZN | Stock | 1.7815 | 1.8045 | 1.778 | 1.8005 | 17769940.0 |
| 2003-06-17 15:00:00 | AMZN | Stock | 1.801 | 1.805 | 1.791 | 1.7935 | 22711200.0 |
| 2003-06-17 16:00:00 | AMZN | Stock | 1.792 | 1.794 | 1.7705 | 1.7895 | 1165800.0 |
| 2003-06-17 17:00:00 | AMZN | Stock | 1.786 | 1.792 | 1.786 | 1.792 | 108000.0 |
| 2003-06-17 18:00:00 | AMZN | Stock | 1.783 | 1.783 | 1.783 | 1.783 | 4000.0 |
| 2003-06-17 09:00:00 | CL | Stock | 30.45 | 30.45 | 30.16 | 30.255 | 396200.0 |
| 2003-06-17 10:00:00 | CL | Stock | 30.255 | 30.35 | 30.225 | 30.31 | 456200.0 |
| 2003-06-17 11:00:00 | CL | Stock | 30.315 | 30.36 | 30.29 | 30.345 | 266800.0 |
| 2003-06-17 12:00:00 | CL | Stock | 30.34 | 30.425 | 30.3 | 30.385 | 538000.0 |
| 2003-06-17 13:00:00 | CL | Stock | 30.385 | 30.425 | 30.35 | 30.35 | 199400.0 |
| 2003-06-17 14:00:00 | CL | Stock | 30.35 | 30.435 | 30.35 | 30.42 | 496400.0 |
| 2003-06-17 15:00:00 | CL | Stock | 30.42 | 30.425 | 30.25 | 30.325 | 596000.0 |
> showing 50 of 21,628 rows — these rows as CSV