PREVIEW / stock_1hour / 2007-12-06
file: by_date/stock_1hour/2007/2007-12-06.parquet size: 815 KB rows: 40,257 symbols: 3,230
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-06 04:00:00 | AAPL | Stock | 6.6696 | 6.6696 | 6.65 | 6.6661 | 74508.0 |
| 2007-12-06 06:00:00 | AAPL | Stock | 6.6696 | 6.6932 | 6.6696 | 6.6875 | 178136.0 |
| 2007-12-06 07:00:00 | AAPL | Stock | 6.6939 | 6.7268 | 6.6714 | 6.6804 | 2689344.0 |
| 2007-12-06 08:00:00 | AAPL | Stock | 6.6957 | 6.7029 | 6.625 | 6.6454 | 9234876.0 |
| 2007-12-06 09:00:00 | AAPL | Stock | 6.6464 | 6.7464 | 6.6329 | 6.7229 | 146791372.0 |
| 2007-12-06 10:00:00 | AAPL | Stock | 6.7225 | 6.7607 | 6.6964 | 6.7286 | 148347892.0 |
| 2007-12-06 11:00:00 | AAPL | Stock | 6.7289 | 6.7375 | 6.6964 | 6.7207 | 87111108.0 |
| 2007-12-06 12:00:00 | AAPL | Stock | 6.7204 | 6.7671 | 6.6904 | 6.7632 | 124285392.0 |
| 2007-12-06 13:00:00 | AAPL | Stock | 6.7639 | 6.7768 | 6.7357 | 6.7429 | 97254108.0 |
| 2007-12-06 14:00:00 | AAPL | Stock | 6.7436 | 6.7754 | 6.7418 | 6.7561 | 94504928.0 |
| 2007-12-06 15:00:00 | AAPL | Stock | 6.7561 | 6.7857 | 6.7471 | 6.7839 | 173050332.0 |
| 2007-12-06 16:00:00 | AAPL | Stock | 6.7843 | 6.7868 | 6.7402 | 6.775 | 15464680.0 |
| 2007-12-06 17:00:00 | AAPL | Stock | 6.7768 | 6.7836 | 6.7216 | 6.7829 | 1016904.0 |
| 2007-12-06 18:00:00 | AAPL | Stock | 6.7829 | 6.7839 | 6.7786 | 6.7814 | 272860.0 |
| 2007-12-06 19:00:00 | AAPL | Stock | 6.7814 | 6.7839 | 6.7786 | 6.7825 | 391860.0 |
| 2007-12-06 07:00:00 | MSFT | Stock | 34.35 | 34.5 | 34.2 | 34.2 | 6310.0 |
| 2007-12-06 08:00:00 | MSFT | Stock | 34.38 | 34.41 | 34.15 | 34.19 | 173566.0 |
| 2007-12-06 09:00:00 | MSFT | Stock | 34.16 | 34.39 | 34.05 | 34.08 | 4745296.0 |
| 2007-12-06 10:00:00 | MSFT | Stock | 34.105 | 34.21 | 33.9 | 33.93 | 6810543.0 |
| 2007-12-06 11:00:00 | MSFT | Stock | 33.92 | 34.47 | 33.87 | 34.33 | 9665291.0 |
| 2007-12-06 12:00:00 | MSFT | Stock | 34.328 | 34.36 | 34.19 | 34.24 | 4103856.0 |
| 2007-12-06 13:00:00 | MSFT | Stock | 34.24 | 34.33 | 34.19 | 34.22 | 4312019.0 |
| 2007-12-06 14:00:00 | MSFT | Stock | 34.212 | 34.6 | 34.19 | 34.53 | 7009305.0 |
| 2007-12-06 15:00:00 | MSFT | Stock | 34.54 | 34.61 | 34.4 | 34.55 | 9585854.0 |
| 2007-12-06 16:00:00 | MSFT | Stock | 34.55 | 34.55 | 34.294 | 34.55 | 2791578.0 |
| 2007-12-06 17:00:00 | MSFT | Stock | 34.5 | 34.5 | 34.21 | 34.4 | 6021.0 |
| 2007-12-06 18:00:00 | MSFT | Stock | 34.55 | 34.55 | 34.42 | 34.42 | 1412669.0 |
| 2007-12-06 19:00:00 | MSFT | Stock | 34.45 | 34.55 | 34.42 | 34.49 | 2110.0 |
| 2007-12-06 08:00:00 | NVDA | Stock | 0.8588 | 0.8588 | 0.8488 | 0.85 | 66000.0 |
| 2007-12-06 09:00:00 | NVDA | Stock | 0.8402 | 0.848 | 0.836 | 0.847 | 39077240.0 |
| 2007-12-06 10:00:00 | NVDA | Stock | 0.847 | 0.847 | 0.835 | 0.838 | 56483160.0 |
| 2007-12-06 11:00:00 | NVDA | Stock | 0.8382 | 0.839 | 0.8312 | 0.8382 | 36670400.0 |
| 2007-12-06 12:00:00 | NVDA | Stock | 0.838 | 0.8458 | 0.8345 | 0.8445 | 40318600.0 |
| 2007-12-06 13:00:00 | NVDA | Stock | 0.8443 | 0.8458 | 0.8385 | 0.8422 | 34236680.0 |
| 2007-12-06 14:00:00 | NVDA | Stock | 0.8422 | 0.8575 | 0.8418 | 0.8558 | 66924600.0 |
| 2007-12-06 15:00:00 | NVDA | Stock | 0.856 | 0.8605 | 0.853 | 0.8592 | 89497560.0 |
| 2007-12-06 16:00:00 | NVDA | Stock | 0.8588 | 0.8606 | 0.8412 | 0.8571 | 7643840.0 |
| 2007-12-06 17:00:00 | NVDA | Stock | 0.8552 | 0.8562 | 0.8474 | 0.8562 | 232320.0 |
| 2007-12-06 19:00:00 | NVDA | Stock | 0.856 | 0.856 | 0.8552 | 0.8552 | 77240.0 |
| 2007-12-06 08:00:00 | AMZN | Stock | 4.6865 | 4.704 | 4.6755 | 4.6815 | 121540.0 |
| 2007-12-06 09:00:00 | AMZN | Stock | 4.6595 | 4.7015 | 4.64 | 4.697 | 10958880.0 |
| 2007-12-06 10:00:00 | AMZN | Stock | 4.6965 | 4.75 | 4.675 | 4.701 | 24237280.0 |
| 2007-12-06 11:00:00 | AMZN | Stock | 4.7 | 4.7135 | 4.6765 | 4.6825 | 11418640.0 |
| 2007-12-06 12:00:00 | AMZN | Stock | 4.685 | 4.697 | 4.6415 | 4.669 | 10843700.0 |
| 2007-12-06 13:00:00 | AMZN | Stock | 4.6705 | 4.68 | 4.6425 | 4.648 | 11118160.0 |
| 2007-12-06 14:00:00 | AMZN | Stock | 4.647 | 4.694 | 4.6455 | 4.684 | 10158240.0 |
| 2007-12-06 15:00:00 | AMZN | Stock | 4.6845 | 4.7205 | 4.652 | 4.7075 | 27217380.0 |
| 2007-12-06 16:00:00 | AMZN | Stock | 4.7075 | 4.7105 | 4.6867 | 4.7 | 1121400.0 |
| 2007-12-06 17:00:00 | AMZN | Stock | 4.7015 | 4.7015 | 4.6896 | 4.6896 | 65080.0 |
| 2007-12-06 18:00:00 | AMZN | Stock | 4.699 | 4.7 | 4.699 | 4.7 | 11740.0 |
> showing 50 of 40,257 rows — these rows as CSV