PREVIEW / stock_1hour / 2001-02-28
file: by_date/stock_1hour/2001/2001-02-28.parquet size: 353 KB rows: 16,705 symbols: 1,272
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-28 08:00:00 | AAPL | Stock | 0.3449 | 0.346 | 0.3449 | 0.3449 | 100800.0 |
| 2001-02-28 09:00:00 | AAPL | Stock | 0.3438 | 0.3471 | 0.3337 | 0.3382 | 28459200.0 |
| 2001-02-28 10:00:00 | AAPL | Stock | 0.3371 | 0.346 | 0.3348 | 0.3371 | 32519200.0 |
| 2001-02-28 11:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3281 | 0.3315 | 35873600.0 |
| 2001-02-28 12:00:00 | AAPL | Stock | 0.3326 | 0.3348 | 0.3292 | 0.3337 | 26168800.0 |
| 2001-02-28 13:00:00 | AAPL | Stock | 0.3337 | 0.3393 | 0.3315 | 0.3359 | 48568800.0 |
| 2001-02-28 14:00:00 | AAPL | Stock | 0.3359 | 0.3382 | 0.3292 | 0.3292 | 25435200.0 |
| 2001-02-28 15:00:00 | AAPL | Stock | 0.3292 | 0.3348 | 0.3237 | 0.327 | 259884800.0 |
| 2001-02-28 16:00:00 | AAPL | Stock | 0.327 | 0.3281 | 0.3214 | 0.3248 | 13977600.0 |
| 2001-02-28 17:00:00 | AAPL | Stock | 0.3237 | 0.3259 | 0.3192 | 0.3225 | 2654400.0 |
| 2001-02-28 08:00:00 | MSFT | Stock | 29.7344 | 29.75 | 29.5781 | 29.625 | 210600.0 |
| 2001-02-28 09:00:00 | MSFT | Stock | 29.5312 | 29.8438 | 29.0938 | 29.2812 | 10660200.0 |
| 2001-02-28 10:00:00 | MSFT | Stock | 29.3125 | 30.0312 | 29.2812 | 29.9062 | 15806000.0 |
| 2001-02-28 11:00:00 | MSFT | Stock | 29.9062 | 29.9688 | 29.2812 | 29.5625 | 11886400.0 |
| 2001-02-28 12:00:00 | MSFT | Stock | 29.5312 | 29.75 | 29.4375 | 29.75 | 4520400.0 |
| 2001-02-28 13:00:00 | MSFT | Stock | 29.7188 | 29.9688 | 29.5312 | 29.8438 | 11522800.0 |
| 2001-02-28 14:00:00 | MSFT | Stock | 29.9062 | 29.9062 | 29.375 | 29.4062 | 9118200.0 |
| 2001-02-28 15:00:00 | MSFT | Stock | 29.4062 | 29.7656 | 29.1562 | 29.4688 | 12508600.0 |
| 2001-02-28 16:00:00 | MSFT | Stock | 29.4688 | 29.7812 | 29.25 | 29.4375 | 5204800.0 |
| 2001-02-28 17:00:00 | MSFT | Stock | 29.4062 | 29.5312 | 29.375 | 29.5 | 859400.0 |
| 2001-02-28 18:00:00 | MSFT | Stock | 29.4688 | 29.5 | 29.4375 | 29.4375 | 1200.0 |
| 2001-02-28 08:00:00 | NVDA | Stock | 0.2167 | 0.2167 | 0.2167 | 0.2167 | 120000.0 |
| 2001-02-28 09:00:00 | NVDA | Stock | 0.2094 | 0.2188 | 0.2063 | 0.2141 | 57576000.0 |
| 2001-02-28 10:00:00 | NVDA | Stock | 0.2125 | 0.2167 | 0.2055 | 0.2055 | 59184000.0 |
| 2001-02-28 11:00:00 | NVDA | Stock | 0.2053 | 0.2083 | 0.1875 | 0.1917 | 174840000.0 |
| 2001-02-28 12:00:00 | NVDA | Stock | 0.1918 | 0.1938 | 0.1867 | 0.1927 | 93984000.0 |
| 2001-02-28 13:00:00 | NVDA | Stock | 0.1927 | 0.1958 | 0.1883 | 0.193 | 98040000.0 |
| 2001-02-28 14:00:00 | NVDA | Stock | 0.193 | 0.193 | 0.1836 | 0.1846 | 80808000.0 |
| 2001-02-28 15:00:00 | NVDA | Stock | 0.1849 | 0.1901 | 0.1823 | 0.1865 | 178824000.0 |
| 2001-02-28 16:00:00 | NVDA | Stock | 0.1868 | 0.1878 | 0.1836 | 0.1862 | 13104000.0 |
| 2001-02-28 17:00:00 | NVDA | Stock | 0.1867 | 0.187 | 0.1862 | 0.187 | 4224000.0 |
| 2001-02-28 18:00:00 | NVDA | Stock | 0.1875 | 0.1875 | 0.1875 | 0.1875 | 72000.0 |
| 2001-02-28 08:00:00 | AMZN | Stock | 0.5875 | 0.6 | 0.5375 | 0.5469 | 1866000.0 |
| 2001-02-28 09:00:00 | AMZN | Stock | 0.5469 | 0.5875 | 0.5375 | 0.5531 | 54532000.0 |
| 2001-02-28 10:00:00 | AMZN | Stock | 0.5562 | 0.5656 | 0.5438 | 0.5438 | 32976000.0 |
| 2001-02-28 11:00:00 | AMZN | Stock | 0.5438 | 0.5469 | 0.525 | 0.5375 | 35990000.0 |
| 2001-02-28 12:00:00 | AMZN | Stock | 0.5375 | 0.5406 | 0.5156 | 0.5281 | 29996000.0 |
| 2001-02-28 13:00:00 | AMZN | Stock | 0.525 | 0.5281 | 0.5125 | 0.5219 | 43306000.0 |
| 2001-02-28 14:00:00 | AMZN | Stock | 0.5219 | 0.525 | 0.5031 | 0.5062 | 28352000.0 |
| 2001-02-28 15:00:00 | AMZN | Stock | 0.5062 | 0.5188 | 0.4969 | 0.5062 | 36060000.0 |
| 2001-02-28 16:00:00 | AMZN | Stock | 0.5094 | 0.5094 | 0.4875 | 0.5 | 4782000.0 |
| 2001-02-28 17:00:00 | AMZN | Stock | 0.4984 | 0.5 | 0.4938 | 0.4953 | 60000.0 |
| 2001-02-28 18:00:00 | AMZN | Stock | 0.4938 | 0.4953 | 0.4922 | 0.4938 | 32000.0 |
| 2001-02-28 09:00:00 | CL | Stock | 29.5 | 29.7 | 29.495 | 29.65 | 232400.0 |
| 2001-02-28 10:00:00 | CL | Stock | 29.65 | 29.71 | 29.51 | 29.55 | 436800.0 |
| 2001-02-28 11:00:00 | CL | Stock | 29.545 | 29.545 | 29.4 | 29.45 | 319400.0 |
| 2001-02-28 12:00:00 | CL | Stock | 29.45 | 29.55 | 29.375 | 29.43 | 304800.0 |
| 2001-02-28 13:00:00 | CL | Stock | 29.41 | 29.525 | 29.35 | 29.355 | 174800.0 |
| 2001-02-28 14:00:00 | CL | Stock | 29.375 | 29.5 | 29.3 | 29.495 | 174000.0 |
| 2001-02-28 15:00:00 | CL | Stock | 29.475 | 29.55 | 29.375 | 29.5 | 426400.0 |
> showing 50 of 16,705 rows — these rows as CSV