PREVIEW / stock_1hour / 2001-02-22
file: by_date/stock_1hour/2001/2001-02-22.parquet size: 354 KB rows: 16,462 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-22 08:00:00 | AAPL | Stock | 0.3281 | 0.3371 | 0.3281 | 0.3371 | 257600.0 |
| 2001-02-22 09:00:00 | AAPL | Stock | 0.3393 | 0.346 | 0.3326 | 0.3348 | 52270400.0 |
| 2001-02-22 10:00:00 | AAPL | Stock | 0.3337 | 0.3348 | 0.3214 | 0.3281 | 129180800.0 |
| 2001-02-22 11:00:00 | AAPL | Stock | 0.3281 | 0.3371 | 0.3225 | 0.3348 | 53704000.0 |
| 2001-02-22 12:00:00 | AAPL | Stock | 0.3359 | 0.3359 | 0.3292 | 0.3326 | 40409600.0 |
| 2001-02-22 13:00:00 | AAPL | Stock | 0.3337 | 0.3404 | 0.3304 | 0.3393 | 62619200.0 |
| 2001-02-22 14:00:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3292 | 0.3326 | 28425600.0 |
| 2001-02-22 15:00:00 | AAPL | Stock | 0.3315 | 0.3359 | 0.3259 | 0.3348 | 47286400.0 |
| 2001-02-22 16:00:00 | AAPL | Stock | 0.3359 | 0.3426 | 0.3281 | 0.3359 | 8976800.0 |
| 2001-02-22 17:00:00 | AAPL | Stock | 0.3259 | 0.3259 | 0.3259 | 0.3259 | 5600.0 |
| 2001-02-22 08:00:00 | MSFT | Stock | 27.7812 | 28.125 | 27.75 | 27.9375 | 431200.0 |
| 2001-02-22 09:00:00 | MSFT | Stock | 28.0625 | 28.2188 | 27.6875 | 27.875 | 12123600.0 |
| 2001-02-22 10:00:00 | MSFT | Stock | 27.875 | 27.9375 | 27.0 | 27.4375 | 26208800.0 |
| 2001-02-22 11:00:00 | MSFT | Stock | 27.4375 | 27.9688 | 27.1875 | 27.4375 | 11710800.0 |
| 2001-02-22 12:00:00 | MSFT | Stock | 27.5 | 27.9375 | 27.2812 | 27.8125 | 6386400.0 |
| 2001-02-22 13:00:00 | MSFT | Stock | 27.8438 | 28.25 | 27.75 | 28.2344 | 8896800.0 |
| 2001-02-22 14:00:00 | MSFT | Stock | 28.2344 | 28.4062 | 27.5312 | 27.6875 | 9549200.0 |
| 2001-02-22 15:00:00 | MSFT | Stock | 27.6875 | 27.8438 | 27.1875 | 27.625 | 13831000.0 |
| 2001-02-22 16:00:00 | MSFT | Stock | 27.625 | 27.875 | 27.3438 | 27.6094 | 6533000.0 |
| 2001-02-22 17:00:00 | MSFT | Stock | 27.2812 | 27.8438 | 27.125 | 27.5 | 89600.0 |
| 2001-02-22 18:00:00 | MSFT | Stock | 27.5 | 27.5625 | 27.4375 | 27.5312 | 7200.0 |
| 2001-02-22 08:00:00 | NVDA | Stock | 0.2313 | 0.2313 | 0.2292 | 0.2313 | 456000.0 |
| 2001-02-22 09:00:00 | NVDA | Stock | 0.2333 | 0.2438 | 0.232 | 0.2365 | 64272000.0 |
| 2001-02-22 10:00:00 | NVDA | Stock | 0.2362 | 0.2375 | 0.2255 | 0.2352 | 149400000.0 |
| 2001-02-22 11:00:00 | NVDA | Stock | 0.2349 | 0.2401 | 0.2299 | 0.2378 | 136272000.0 |
| 2001-02-22 12:00:00 | NVDA | Stock | 0.2378 | 0.2396 | 0.2365 | 0.2388 | 67344000.0 |
| 2001-02-22 13:00:00 | NVDA | Stock | 0.2391 | 0.2479 | 0.2389 | 0.2474 | 122592000.0 |
| 2001-02-22 14:00:00 | NVDA | Stock | 0.2471 | 0.25 | 0.2398 | 0.2423 | 107136000.0 |
| 2001-02-22 15:00:00 | NVDA | Stock | 0.2424 | 0.2453 | 0.2346 | 0.2427 | 117408000.0 |
| 2001-02-22 16:00:00 | NVDA | Stock | 0.2435 | 0.2449 | 0.2333 | 0.2367 | 8064000.0 |
| 2001-02-22 17:00:00 | NVDA | Stock | 0.2367 | 0.2367 | 0.2339 | 0.2344 | 936000.0 |
| 2001-02-22 18:00:00 | NVDA | Stock | 0.2396 | 0.2396 | 0.2396 | 0.2396 | 24000.0 |
| 2001-02-22 08:00:00 | AMZN | Stock | 0.5969 | 0.6094 | 0.575 | 0.6 | 1180000.0 |
| 2001-02-22 09:00:00 | AMZN | Stock | 0.6 | 0.6 | 0.5781 | 0.5844 | 20664000.0 |
| 2001-02-22 10:00:00 | AMZN | Stock | 0.5875 | 0.5969 | 0.5719 | 0.5844 | 27960000.0 |
| 2001-02-22 11:00:00 | AMZN | Stock | 0.5844 | 0.5906 | 0.575 | 0.5844 | 27816000.0 |
| 2001-02-22 12:00:00 | AMZN | Stock | 0.5844 | 0.5938 | 0.5688 | 0.5875 | 14816000.0 |
| 2001-02-22 13:00:00 | AMZN | Stock | 0.5875 | 0.6063 | 0.5812 | 0.6 | 20862000.0 |
| 2001-02-22 14:00:00 | AMZN | Stock | 0.6 | 0.6063 | 0.5938 | 0.5984 | 14884000.0 |
| 2001-02-22 15:00:00 | AMZN | Stock | 0.6 | 0.6031 | 0.5812 | 0.5969 | 26612000.0 |
| 2001-02-22 16:00:00 | AMZN | Stock | 0.5984 | 0.6031 | 0.5969 | 0.5969 | 1998000.0 |
| 2001-02-22 17:00:00 | AMZN | Stock | 0.5969 | 0.6 | 0.5922 | 0.5922 | 24000.0 |
| 2001-02-22 18:00:00 | AMZN | Stock | 0.5875 | 0.5875 | 0.5875 | 0.5875 | 10000.0 |
| 2001-02-22 09:00:00 | CL | Stock | 29.85 | 30.11 | 29.8 | 30.01 | 575000.0 |
| 2001-02-22 10:00:00 | CL | Stock | 30.005 | 30.125 | 29.835 | 30.085 | 816400.0 |
| 2001-02-22 11:00:00 | CL | Stock | 30.075 | 30.085 | 29.625 | 29.63 | 603000.0 |
| 2001-02-22 12:00:00 | CL | Stock | 29.63 | 29.65 | 29.37 | 29.425 | 408200.0 |
| 2001-02-22 13:00:00 | CL | Stock | 29.43 | 29.52 | 29.175 | 29.275 | 388200.0 |
| 2001-02-22 14:00:00 | CL | Stock | 29.3 | 29.415 | 29.27 | 29.35 | 378800.0 |
| 2001-02-22 15:00:00 | CL | Stock | 29.355 | 29.725 | 29.28 | 29.625 | 551200.0 |
> showing 50 of 16,462 rows — these rows as CSV