PREVIEW / stock_1hour / 2005-02-22
file: by_date/stock_1hour/2005/2005-02-22.parquet size: 572 KB rows: 26,915 symbols: 1,941
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-22 08:00:00 | AAPL | Stock | 1.5404 | 1.5461 | 1.5348 | 1.5414 | 4279408.0 |
| 2005-02-22 09:00:00 | AAPL | Stock | 1.5423 | 1.5502 | 1.5295 | 1.5373 | 165655000.0 |
| 2005-02-22 10:00:00 | AAPL | Stock | 1.5379 | 1.5768 | 1.5318 | 1.5577 | 361154080.0 |
| 2005-02-22 11:00:00 | AAPL | Stock | 1.5579 | 1.5621 | 1.552 | 1.562 | 125353144.0 |
| 2005-02-22 12:00:00 | AAPL | Stock | 1.5618 | 1.5668 | 1.5455 | 1.5534 | 131598376.0 |
| 2005-02-22 13:00:00 | AAPL | Stock | 1.5538 | 1.557 | 1.5496 | 1.5525 | 78847328.0 |
| 2005-02-22 14:00:00 | AAPL | Stock | 1.5527 | 1.5532 | 1.5355 | 1.5445 | 118161456.0 |
| 2005-02-22 15:00:00 | AAPL | Stock | 1.5448 | 1.5448 | 1.5232 | 1.5246 | 208565728.0 |
| 2005-02-22 16:00:00 | AAPL | Stock | 1.523 | 1.5259 | 1.5189 | 1.522 | 10367616.0 |
| 2005-02-22 17:00:00 | AAPL | Stock | 1.5221 | 1.5245 | 1.5195 | 1.5214 | 1030064.0 |
| 2005-02-22 18:00:00 | AAPL | Stock | 1.5214 | 1.5254 | 1.5213 | 1.5213 | 590576.0 |
| 2005-02-22 08:00:00 | MSFT | Stock | 25.42 | 25.42 | 25.34 | 25.36 | 23186.0 |
| 2005-02-22 09:00:00 | MSFT | Stock | 25.38 | 25.49 | 25.22 | 25.31 | 12295688.0 |
| 2005-02-22 10:00:00 | MSFT | Stock | 25.31 | 25.42 | 25.26 | 25.35 | 18586544.0 |
| 2005-02-22 11:00:00 | MSFT | Stock | 25.36 | 25.37 | 25.28 | 25.33 | 9857886.0 |
| 2005-02-22 12:00:00 | MSFT | Stock | 25.332 | 25.37 | 25.21 | 25.28 | 15253467.0 |
| 2005-02-22 13:00:00 | MSFT | Stock | 25.28 | 25.38 | 25.24 | 25.28 | 11047926.0 |
| 2005-02-22 14:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.23 | 25.25 | 6539259.0 |
| 2005-02-22 15:00:00 | MSFT | Stock | 25.25 | 25.33 | 25.2 | 25.22 | 17034216.0 |
| 2005-02-22 16:00:00 | MSFT | Stock | 25.22 | 25.29 | 25.17 | 25.17 | 2321764.0 |
| 2005-02-22 17:00:00 | MSFT | Stock | 25.18 | 25.24 | 25.16 | 25.17 | 108242.0 |
| 2005-02-22 18:00:00 | MSFT | Stock | 25.17 | 25.23 | 25.17 | 25.18 | 78080.0 |
| 2005-02-22 08:00:00 | NVDA | Stock | 0.2352 | 0.2352 | 0.2331 | 0.2342 | 4018080.0 |
| 2005-02-22 09:00:00 | NVDA | Stock | 0.2342 | 0.2368 | 0.2319 | 0.2345 | 166365360.0 |
| 2005-02-22 10:00:00 | NVDA | Stock | 0.2346 | 0.2387 | 0.2325 | 0.2376 | 307483080.0 |
| 2005-02-22 11:00:00 | NVDA | Stock | 0.2376 | 0.2419 | 0.237 | 0.241 | 280538400.0 |
| 2005-02-22 12:00:00 | NVDA | Stock | 0.241 | 0.243 | 0.24 | 0.2421 | 181718760.0 |
| 2005-02-22 13:00:00 | NVDA | Stock | 0.242 | 0.2441 | 0.2411 | 0.2412 | 149756400.0 |
| 2005-02-22 14:00:00 | NVDA | Stock | 0.2412 | 0.2416 | 0.2387 | 0.2404 | 132157800.0 |
| 2005-02-22 15:00:00 | NVDA | Stock | 0.2405 | 0.2407 | 0.2369 | 0.2386 | 187290960.0 |
| 2005-02-22 16:00:00 | NVDA | Stock | 0.2386 | 0.2397 | 0.2382 | 0.2388 | 6317520.0 |
| 2005-02-22 17:00:00 | NVDA | Stock | 0.2391 | 0.2392 | 0.2386 | 0.2387 | 459240.0 |
| 2005-02-22 18:00:00 | NVDA | Stock | 0.2387 | 0.2387 | 0.2387 | 0.2387 | 288000.0 |
| 2005-02-22 08:00:00 | AMZN | Stock | 1.7625 | 1.7625 | 1.75 | 1.75 | 12000.0 |
| 2005-02-22 09:00:00 | AMZN | Stock | 1.7575 | 1.7575 | 1.7335 | 1.7505 | 19375140.0 |
| 2005-02-22 10:00:00 | AMZN | Stock | 1.7505 | 1.7695 | 1.745 | 1.7515 | 24577400.0 |
| 2005-02-22 11:00:00 | AMZN | Stock | 1.752 | 1.7595 | 1.749 | 1.749 | 13820780.0 |
| 2005-02-22 12:00:00 | AMZN | Stock | 1.7495 | 1.7525 | 1.7305 | 1.7325 | 18288300.0 |
| 2005-02-22 13:00:00 | AMZN | Stock | 1.733 | 1.7385 | 1.726 | 1.735 | 16652240.0 |
| 2005-02-22 14:00:00 | AMZN | Stock | 1.735 | 1.744 | 1.7315 | 1.7395 | 14522560.0 |
| 2005-02-22 15:00:00 | AMZN | Stock | 1.7395 | 1.7395 | 1.7255 | 1.734 | 27710120.0 |
| 2005-02-22 16:00:00 | AMZN | Stock | 1.735 | 1.7405 | 1.733 | 1.7395 | 749720.0 |
| 2005-02-22 17:00:00 | AMZN | Stock | 1.738 | 1.738 | 1.736 | 1.7375 | 138560.0 |
| 2005-02-22 09:00:00 | CL | Stock | 26.6 | 26.64 | 26.55 | 26.57 | 453800.0 |
| 2005-02-22 10:00:00 | CL | Stock | 26.57 | 26.635 | 26.5 | 26.625 | 751000.0 |
| 2005-02-22 11:00:00 | CL | Stock | 26.625 | 26.635 | 26.55 | 26.565 | 399400.0 |
| 2005-02-22 12:00:00 | CL | Stock | 26.565 | 26.575 | 26.415 | 26.48 | 534200.0 |
| 2005-02-22 13:00:00 | CL | Stock | 26.485 | 26.51 | 26.395 | 26.41 | 383400.0 |
| 2005-02-22 14:00:00 | CL | Stock | 26.415 | 26.42 | 26.3 | 26.36 | 363600.0 |
| 2005-02-22 15:00:00 | CL | Stock | 26.36 | 26.375 | 26.235 | 26.235 | 738200.0 |
> showing 50 of 26,915 rows — these rows as CSV