PREVIEW / stock_1hour / 2009-03-17
file: by_date/stock_1hour/2009/2009-03-17.parquet size: 803 KB rows: 40,006 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-17 08:00:00 | AAPL | Stock | 3.3939 | 3.4196 | 3.3846 | 3.3979 | 698236.0 |
| 2009-03-17 09:00:00 | AAPL | Stock | 3.3964 | 3.4925 | 3.3936 | 3.4766 | 103515804.0 |
| 2009-03-17 10:00:00 | AAPL | Stock | 3.4771 | 3.5075 | 3.4771 | 3.4921 | 111078212.0 |
| 2009-03-17 11:00:00 | AAPL | Stock | 3.4925 | 3.5161 | 3.4871 | 3.5075 | 65355920.0 |
| 2009-03-17 12:00:00 | AAPL | Stock | 3.5075 | 3.5175 | 3.4786 | 3.4818 | 72867564.0 |
| 2009-03-17 13:00:00 | AAPL | Stock | 3.4821 | 3.5089 | 3.47 | 3.4757 | 86484804.0 |
| 2009-03-17 14:00:00 | AAPL | Stock | 3.4754 | 3.4875 | 3.4464 | 3.4711 | 111118448.0 |
| 2009-03-17 15:00:00 | AAPL | Stock | 3.4704 | 3.5604 | 3.4686 | 3.5589 | 206719268.0 |
| 2009-03-17 16:00:00 | AAPL | Stock | 3.5593 | 3.5625 | 3.4464 | 3.5571 | 19096728.0 |
| 2009-03-17 17:00:00 | AAPL | Stock | 3.5571 | 3.5607 | 3.5571 | 3.5571 | 279272.0 |
| 2009-03-17 18:00:00 | AAPL | Stock | 3.5571 | 3.56 | 3.5543 | 3.5586 | 885304.0 |
| 2009-03-17 19:00:00 | AAPL | Stock | 3.5593 | 3.5629 | 3.5575 | 3.5582 | 489720.0 |
| 2009-03-17 07:00:00 | MSFT | Stock | 16.31 | 16.5 | 16.31 | 16.43 | 5600.0 |
| 2009-03-17 08:00:00 | MSFT | Stock | 16.31 | 16.44 | 16.31 | 16.39 | 16710.0 |
| 2009-03-17 09:00:00 | MSFT | Stock | 16.35 | 16.54 | 16.3 | 16.51 | 5869849.0 |
| 2009-03-17 10:00:00 | MSFT | Stock | 16.52 | 16.56 | 16.26 | 16.472 | 8630997.0 |
| 2009-03-17 11:00:00 | MSFT | Stock | 16.46 | 16.59 | 16.46 | 16.53 | 6317285.0 |
| 2009-03-17 12:00:00 | MSFT | Stock | 16.53 | 16.7 | 16.44 | 16.68 | 6303919.0 |
| 2009-03-17 13:00:00 | MSFT | Stock | 16.68 | 16.75 | 16.59 | 16.602 | 7719258.0 |
| 2009-03-17 14:00:00 | MSFT | Stock | 16.61 | 16.68 | 16.48 | 16.64 | 7074397.0 |
| 2009-03-17 15:00:00 | MSFT | Stock | 16.63 | 16.89 | 16.62 | 16.89 | 15945932.0 |
| 2009-03-17 16:00:00 | MSFT | Stock | 16.89 | 16.97 | 16.585 | 16.9 | 3081263.0 |
| 2009-03-17 17:00:00 | MSFT | Stock | 16.91 | 16.92 | 16.9 | 16.9 | 16919.0 |
| 2009-03-17 18:00:00 | MSFT | Stock | 16.92 | 16.92 | 16.9 | 16.9 | 180664.0 |
| 2009-03-17 19:00:00 | MSFT | Stock | 16.91 | 16.92 | 16.9 | 16.9 | 7700.0 |
| 2009-03-17 08:00:00 | NVDA | Stock | 0.2325 | 0.2338 | 0.2325 | 0.2338 | 20000.0 |
| 2009-03-17 09:00:00 | NVDA | Stock | 0.236 | 0.2405 | 0.2332 | 0.2378 | 91095040.0 |
| 2009-03-17 10:00:00 | NVDA | Stock | 0.2378 | 0.2408 | 0.2358 | 0.237 | 163349400.0 |
| 2009-03-17 11:00:00 | NVDA | Stock | 0.2368 | 0.2396 | 0.235 | 0.2388 | 120248040.0 |
| 2009-03-17 12:00:00 | NVDA | Stock | 0.239 | 0.244 | 0.2388 | 0.24 | 133911920.0 |
| 2009-03-17 13:00:00 | NVDA | Stock | 0.24 | 0.242 | 0.2385 | 0.2405 | 82605280.0 |
| 2009-03-17 14:00:00 | NVDA | Stock | 0.2402 | 0.243 | 0.2382 | 0.2425 | 137895440.0 |
| 2009-03-17 15:00:00 | NVDA | Stock | 0.2425 | 0.2475 | 0.2422 | 0.247 | 250009800.0 |
| 2009-03-17 16:00:00 | NVDA | Stock | 0.2468 | 0.2473 | 0.2406 | 0.2473 | 5631320.0 |
| 2009-03-17 17:00:00 | NVDA | Stock | 0.2388 | 0.2388 | 0.2388 | 0.2388 | 1968000.0 |
| 2009-03-17 18:00:00 | NVDA | Stock | 0.2462 | 0.2465 | 0.2445 | 0.2465 | 76000.0 |
| 2009-03-17 19:00:00 | NVDA | Stock | 0.2458 | 0.2458 | 0.2458 | 0.2458 | 20000.0 |
| 2009-03-17 08:00:00 | AMZN | Stock | 3.335 | 3.3405 | 3.3255 | 3.3405 | 38200.0 |
| 2009-03-17 09:00:00 | AMZN | Stock | 3.34 | 3.4415 | 3.329 | 3.4265 | 20934560.0 |
| 2009-03-17 10:00:00 | AMZN | Stock | 3.4255 | 3.479 | 3.4125 | 3.4705 | 35455900.0 |
| 2009-03-17 11:00:00 | AMZN | Stock | 3.4705 | 3.473 | 3.447 | 3.469 | 15671020.0 |
| 2009-03-17 12:00:00 | AMZN | Stock | 3.47 | 3.486 | 3.4445 | 3.463 | 18806760.0 |
| 2009-03-17 13:00:00 | AMZN | Stock | 3.463 | 3.485 | 3.454 | 3.4735 | 20407760.0 |
| 2009-03-17 14:00:00 | AMZN | Stock | 3.4725 | 3.55 | 3.4625 | 3.532 | 47667340.0 |
| 2009-03-17 15:00:00 | AMZN | Stock | 3.5325 | 3.5852 | 3.5285 | 3.566 | 72343000.0 |
| 2009-03-17 16:00:00 | AMZN | Stock | 3.5705 | 3.5705 | 3.349 | 3.5615 | 6166080.0 |
| 2009-03-17 17:00:00 | AMZN | Stock | 3.568 | 3.571 | 3.4375 | 3.57 | 56500.0 |
| 2009-03-17 18:00:00 | AMZN | Stock | 3.5675 | 3.5675 | 3.5615 | 3.5625 | 13500.0 |
| 2009-03-17 19:00:00 | AMZN | Stock | 3.56 | 3.5675 | 3.56 | 3.5675 | 140000.0 |
| 2009-03-17 08:00:00 | TLT | Stock | 101.2 | 101.2 | 101.2 | 101.2 | 195.0 |
> showing 50 of 40,006 rows — these rows as CSV