PREVIEW / stock_1hour / 2022-12-29
file: by_date/stock_1hour/2022/2022-12-29.parquet size: 1.4 MB rows: 60,891 symbols: 1,949
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-29 04:00:00 | AAPL | Stock | 126.82 | 126.9 | 126.52 | 126.84 | 33159.0 |
| 2022-12-29 05:00:00 | AAPL | Stock | 126.84 | 126.92 | 126.71 | 126.9 | 21657.0 |
| 2022-12-29 06:00:00 | AAPL | Stock | 126.93 | 127.27 | 126.93 | 127.25 | 42579.0 |
| 2022-12-29 07:00:00 | AAPL | Stock | 127.2 | 127.6 | 127.07 | 127.3 | 134269.0 |
| 2022-12-29 08:00:00 | AAPL | Stock | 127.23 | 128.12 | 126.13 | 128.01 | 637827.0 |
| 2022-12-29 09:00:00 | AAPL | Stock | 127.98 | 129.77 | 127.73 | 128.75 | 12405947.0 |
| 2022-12-29 10:00:00 | AAPL | Stock | 128.745 | 129.98 | 128.19 | 129.9542 | 12268057.0 |
| 2022-12-29 11:00:00 | AAPL | Stock | 129.96 | 130.4814 | 129.44 | 130.1005 | 9299491.0 |
| 2022-12-29 12:00:00 | AAPL | Stock | 130.11 | 130.37 | 129.51 | 129.8401 | 6761896.0 |
| 2022-12-29 13:00:00 | AAPL | Stock | 129.845 | 130.075 | 129.325 | 130.035 | 5631033.0 |
| 2022-12-29 14:00:00 | AAPL | Stock | 130.03 | 130.24 | 129.73 | 129.775 | 5250214.0 |
| 2022-12-29 15:00:00 | AAPL | Stock | 129.765 | 130.22 | 129.56 | 129.6 | 8784845.0 |
| 2022-12-29 16:00:00 | AAPL | Stock | 129.61 | 129.6603 | 129.45 | 129.52 | 6561289.0 |
| 2022-12-29 17:00:00 | AAPL | Stock | 129.5001 | 129.56 | 129.42 | 129.52 | 58435.0 |
| 2022-12-29 18:00:00 | AAPL | Stock | 129.52 | 129.52 | 129.31 | 129.39 | 31482.0 |
| 2022-12-29 19:00:00 | AAPL | Stock | 129.35 | 129.36 | 129.21 | 129.25 | 36245.0 |
| 2022-12-29 04:00:00 | MSFT | Stock | 235.8 | 236.33 | 235.38 | 236.19 | 5208.0 |
| 2022-12-29 05:00:00 | MSFT | Stock | 236.05 | 236.09 | 236.05 | 236.07 | 1070.0 |
| 2022-12-29 06:00:00 | MSFT | Stock | 236.1 | 236.18 | 235.4 | 235.94 | 6199.0 |
| 2022-12-29 07:00:00 | MSFT | Stock | 235.57 | 235.72 | 235.12 | 235.65 | 13198.0 |
| 2022-12-29 08:00:00 | MSFT | Stock | 235.65 | 236.69 | 234.56 | 236.48 | 36630.0 |
| 2022-12-29 09:00:00 | MSFT | Stock | 236.4343 | 238.65 | 235.31 | 238.06 | 1739794.0 |
| 2022-12-29 10:00:00 | MSFT | Stock | 238.07 | 239.97 | 237.71 | 239.84 | 2223307.0 |
| 2022-12-29 11:00:00 | MSFT | Stock | 239.86 | 240.9 | 239.21 | 240.76 | 1668873.0 |
| 2022-12-29 12:00:00 | MSFT | Stock | 240.78 | 241.14 | 240.32 | 240.57 | 1311114.0 |
| 2022-12-29 13:00:00 | MSFT | Stock | 240.57 | 241.15 | 240.055 | 241.0518 | 1257685.0 |
| 2022-12-29 14:00:00 | MSFT | Stock | 241.05 | 241.54 | 240.82 | 240.88 | 1372559.0 |
| 2022-12-29 15:00:00 | MSFT | Stock | 240.87 | 241.92 | 240.82 | 240.9825 | 2894712.0 |
| 2022-12-29 16:00:00 | MSFT | Stock | 240.97 | 241.03 | 240.75 | 240.75 | 3546668.0 |
| 2022-12-29 17:00:00 | MSFT | Stock | 240.85 | 240.9 | 240.75 | 240.9 | 6764.0 |
| 2022-12-29 18:00:00 | MSFT | Stock | 240.82 | 240.93 | 240.75 | 240.78 | 3838.0 |
| 2022-12-29 19:00:00 | MSFT | Stock | 240.75 | 240.75 | 240.42 | 240.42 | 3793.0 |
| 2022-12-29 04:00:00 | NVDA | Stock | 14.091 | 14.204 | 14.091 | 14.204 | 160900.0 |
| 2022-12-29 05:00:00 | NVDA | Stock | 14.204 | 14.212 | 14.173 | 14.206 | 58440.0 |
| 2022-12-29 06:00:00 | NVDA | Stock | 14.23 | 14.23 | 14.183 | 14.202 | 46730.0 |
| 2022-12-29 07:00:00 | NVDA | Stock | 14.202 | 14.202 | 14.176 | 14.2 | 190000.0 |
| 2022-12-29 08:00:00 | NVDA | Stock | 14.186 | 14.495 | 14.173 | 14.424 | 2940840.0 |
| 2022-12-29 09:00:00 | NVDA | Stock | 14.41 | 14.531 | 14.227 | 14.4645 | 50868400.0 |
| 2022-12-29 10:00:00 | NVDA | Stock | 14.467 | 14.549 | 14.361 | 14.54 | 51253800.0 |
| 2022-12-29 11:00:00 | NVDA | Stock | 14.542 | 14.68 | 14.481 | 14.635 | 38219930.0 |
| 2022-12-29 12:00:00 | NVDA | Stock | 14.638 | 14.658 | 14.525 | 14.643 | 31841680.0 |
| 2022-12-29 13:00:00 | NVDA | Stock | 14.644 | 14.645 | 14.532 | 14.5825 | 27816840.0 |
| 2022-12-29 14:00:00 | NVDA | Stock | 14.582 | 14.609 | 14.501 | 14.523 | 21617370.0 |
| 2022-12-29 15:00:00 | NVDA | Stock | 14.522 | 14.683 | 14.516 | 14.603 | 53978650.0 |
| 2022-12-29 16:00:00 | NVDA | Stock | 14.603 | 14.63 | 14.6 | 14.611 | 25041300.0 |
| 2022-12-29 17:00:00 | NVDA | Stock | 14.611 | 14.611 | 14.605 | 14.61 | 77040.0 |
| 2022-12-29 18:00:00 | NVDA | Stock | 14.608 | 14.612 | 14.603 | 14.605 | 145750.0 |
| 2022-12-29 19:00:00 | NVDA | Stock | 14.602 | 14.605 | 14.586 | 14.595 | 287740.0 |
| 2022-12-29 04:00:00 | AMZN | Stock | 82.31 | 82.6 | 82.0 | 82.6 | 24394.0 |
| 2022-12-29 05:00:00 | AMZN | Stock | 82.59 | 82.7 | 82.49 | 82.67 | 4953.0 |
> showing 50 of 60,891 rows — these rows as CSV