PREVIEW / stock_1hour / 2024-08-09
file: by_date/stock_1hour/2024/2024-08-09.parquet size: 1.3 MB rows: 57,076 symbols: 824
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-09 04:00:00 | AAPL | Stock | 213.41 | 214.25 | 213.26 | 214.1 | 30972.0 |
| 2024-08-09 05:00:00 | AAPL | Stock | 214.14 | 214.14 | 212.44 | 212.44 | 40432.0 |
| 2024-08-09 06:00:00 | AAPL | Stock | 212.4 | 212.49 | 211.57 | 212.3 | 33826.0 |
| 2024-08-09 07:00:00 | AAPL | Stock | 212.46 | 212.7 | 211.0 | 211.62 | 119666.0 |
| 2024-08-09 08:00:00 | AAPL | Stock | 212.7 | 213.8178 | 210.64 | 211.18 | 87163.0 |
| 2024-08-09 09:00:00 | AAPL | Stock | 211.2 | 213.48 | 210.7 | 212.56 | 3239753.0 |
| 2024-08-09 10:00:00 | AAPL | Stock | 212.58 | 215.18 | 212.34 | 214.82 | 4381182.0 |
| 2024-08-09 11:00:00 | AAPL | Stock | 214.82 | 215.735 | 214.54 | 214.7 | 3246236.0 |
| 2024-08-09 12:00:00 | AAPL | Stock | 214.7 | 215.45 | 214.41 | 215.435 | 2642444.0 |
| 2024-08-09 13:00:00 | AAPL | Stock | 215.4382 | 216.78 | 215.25 | 215.9164 | 3076416.0 |
| 2024-08-09 14:00:00 | AAPL | Stock | 215.93 | 216.0915 | 214.9 | 215.61 | 3048087.0 |
| 2024-08-09 15:00:00 | AAPL | Stock | 215.605 | 216.615 | 215.21 | 216.3 | 5834136.0 |
| 2024-08-09 16:00:00 | AAPL | Stock | 216.24 | 216.4298 | 215.96 | 216.12 | 5966394.0 |
| 2024-08-09 17:00:00 | AAPL | Stock | 216.09 | 216.2999 | 216.09 | 216.1703 | 14148.0 |
| 2024-08-09 18:00:00 | AAPL | Stock | 216.17 | 216.25 | 216.11 | 216.25 | 7669.0 |
| 2024-08-09 19:00:00 | AAPL | Stock | 216.31 | 216.468 | 216.28 | 216.468 | 16931.0 |
| 2024-08-09 04:00:00 | MSFT | Stock | 404.75 | 406.82 | 403.92 | 406.25 | 9040.0 |
| 2024-08-09 05:00:00 | MSFT | Stock | 406.32 | 407.3 | 406.2 | 407.0 | 8448.0 |
| 2024-08-09 06:00:00 | MSFT | Stock | 407.0 | 407.0 | 406.1 | 406.5 | 5494.0 |
| 2024-08-09 07:00:00 | MSFT | Stock | 406.6 | 406.64 | 404.27 | 404.81 | 19896.0 |
| 2024-08-09 08:00:00 | MSFT | Stock | 405.4 | 406.3 | 401.6 | 403.29 | 44233.0 |
| 2024-08-09 09:00:00 | MSFT | Stock | 403.0 | 406.0 | 402.67 | 403.48 | 1081650.0 |
| 2024-08-09 10:00:00 | MSFT | Stock | 403.49 | 405.95 | 402.2624 | 405.075 | 1254232.0 |
| 2024-08-09 11:00:00 | MSFT | Stock | 405.22 | 406.16 | 403.85 | 404.1399 | 717834.0 |
| 2024-08-09 12:00:00 | MSFT | Stock | 404.21 | 405.17 | 403.41 | 404.98 | 636557.0 |
| 2024-08-09 13:00:00 | MSFT | Stock | 404.97 | 408.05 | 404.67 | 406.6342 | 840575.0 |
| 2024-08-09 14:00:00 | MSFT | Stock | 406.65 | 407.0879 | 405.96 | 406.6583 | 495110.0 |
| 2024-08-09 15:00:00 | MSFT | Stock | 406.63 | 407.1899 | 405.74 | 406.02 | 1296954.0 |
| 2024-08-09 16:00:00 | MSFT | Stock | 406.02 | 406.83 | 406.01 | 406.383 | 2714069.0 |
| 2024-08-09 17:00:00 | MSFT | Stock | 406.39 | 406.39 | 406.1 | 406.1 | 2240.0 |
| 2024-08-09 18:00:00 | MSFT | Stock | 406.2671 | 406.2671 | 406.19 | 406.25 | 414.0 |
| 2024-08-09 19:00:00 | MSFT | Stock | 406.229 | 406.7 | 406.229 | 406.7 | 1984.0 |
| 2024-08-09 04:00:00 | NVDA | Stock | 105.84 | 109.0 | 105.26 | 107.43 | 1125975.0 |
| 2024-08-09 05:00:00 | NVDA | Stock | 107.44 | 107.74 | 106.9 | 107.2 | 620245.0 |
| 2024-08-09 06:00:00 | NVDA | Stock | 107.13 | 107.2 | 106.16 | 106.84 | 660323.0 |
| 2024-08-09 07:00:00 | NVDA | Stock | 106.82 | 107.41 | 105.5 | 106.79 | 2267826.0 |
| 2024-08-09 08:00:00 | NVDA | Stock | 106.84 | 107.7076 | 104.08 | 105.44 | 5455837.0 |
| 2024-08-09 09:00:00 | NVDA | Stock | 105.41 | 106.6 | 103.76 | 103.82 | 43500575.0 |
| 2024-08-09 10:00:00 | NVDA | Stock | 103.81 | 106.04 | 103.43 | 104.89 | 53757745.0 |
| 2024-08-09 11:00:00 | NVDA | Stock | 104.895 | 105.68 | 103.86 | 103.97 | 31294437.0 |
| 2024-08-09 12:00:00 | NVDA | Stock | 103.97 | 104.595 | 103.72 | 104.3901 | 24397365.0 |
| 2024-08-09 13:00:00 | NVDA | Stock | 104.39 | 105.8299 | 104.305 | 105.2292 | 28182706.0 |
| 2024-08-09 14:00:00 | NVDA | Stock | 105.24 | 105.445 | 104.565 | 104.765 | 22391162.0 |
| 2024-08-09 15:00:00 | NVDA | Stock | 104.76 | 105.04 | 104.21 | 104.71 | 30115270.0 |
| 2024-08-09 16:00:00 | NVDA | Stock | 104.7 | 105.05 | 104.6 | 104.641 | 9296692.0 |
| 2024-08-09 17:00:00 | NVDA | Stock | 104.68 | 104.75 | 104.5 | 104.61 | 431157.0 |
| 2024-08-09 18:00:00 | NVDA | Stock | 104.63 | 104.72 | 104.58 | 104.698 | 182579.0 |
| 2024-08-09 19:00:00 | NVDA | Stock | 104.69 | 104.84 | 104.62 | 104.7698 | 441168.0 |
| 2024-08-09 04:00:00 | AMZN | Stock | 166.55 | 167.16 | 166.3 | 167.06 | 21069.0 |
| 2024-08-09 05:00:00 | AMZN | Stock | 167.09 | 167.41 | 167.01 | 167.38 | 20867.0 |
> showing 50 of 57,076 rows — these rows as CSV