PREVIEW / stock_1hour / 2024-07-25
file: by_date/stock_1hour/2024/2024-07-25.parquet size: 1.3 MB rows: 59,059 symbols: 882
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-07-25 04:00:00 | AAPL | Stock | 217.4 | 217.4 | 215.94 | 217.14 | 49514.0 |
| 2024-07-25 05:00:00 | AAPL | Stock | 217.1 | 217.7 | 216.3 | 216.46 | 24938.0 |
| 2024-07-25 06:00:00 | AAPL | Stock | 216.5 | 217.3 | 216.1 | 217.2 | 33681.0 |
| 2024-07-25 07:00:00 | AAPL | Stock | 217.06 | 217.76 | 216.85 | 217.0 | 92674.0 |
| 2024-07-25 08:00:00 | AAPL | Stock | 217.24 | 218.34 | 216.85 | 218.16 | 191490.0 |
| 2024-07-25 09:00:00 | AAPL | Stock | 218.14 | 219.85 | 215.06 | 215.56 | 5744189.0 |
| 2024-07-25 10:00:00 | AAPL | Stock | 215.55 | 218.57 | 214.62 | 218.5599 | 8454219.0 |
| 2024-07-25 11:00:00 | AAPL | Stock | 218.54 | 219.4 | 217.76 | 219.3549 | 4401682.0 |
| 2024-07-25 12:00:00 | AAPL | Stock | 219.36 | 220.85 | 218.8085 | 220.2089 | 4031996.0 |
| 2024-07-25 13:00:00 | AAPL | Stock | 220.2 | 220.78 | 219.27 | 220.348 | 2620917.0 |
| 2024-07-25 14:00:00 | AAPL | Stock | 220.35 | 220.43 | 218.6399 | 218.64 | 2852082.0 |
| 2024-07-25 15:00:00 | AAPL | Stock | 218.62 | 220.42 | 217.33 | 217.49 | 6074526.0 |
| 2024-07-25 16:00:00 | AAPL | Stock | 217.49 | 218.07 | 217.14 | 218.06 | 6229858.0 |
| 2024-07-25 17:00:00 | AAPL | Stock | 218.1 | 218.1 | 217.49 | 217.8501 | 34542.0 |
| 2024-07-25 18:00:00 | AAPL | Stock | 217.85 | 218.5 | 217.7 | 217.7 | 53067.0 |
| 2024-07-25 19:00:00 | AAPL | Stock | 217.7 | 218.09 | 217.7 | 217.91 | 28478.0 |
| 2024-07-25 04:00:00 | MSFT | Stock | 428.86 | 429.7 | 425.47 | 427.9 | 10586.0 |
| 2024-07-25 05:00:00 | MSFT | Stock | 428.04 | 428.48 | 426.85 | 426.95 | 4191.0 |
| 2024-07-25 06:00:00 | MSFT | Stock | 427.06 | 427.4 | 426.3 | 427.4 | 10210.0 |
| 2024-07-25 07:00:00 | MSFT | Stock | 427.37 | 428.97 | 426.9 | 426.9 | 8847.0 |
| 2024-07-25 08:00:00 | MSFT | Stock | 427.56 | 430.3 | 425.8728 | 430.3 | 51205.0 |
| 2024-07-25 09:00:00 | MSFT | Stock | 430.49 | 430.49 | 421.84 | 422.12 | 2512243.0 |
| 2024-07-25 10:00:00 | MSFT | Stock | 422.02 | 424.8 | 417.51 | 423.98 | 4360195.0 |
| 2024-07-25 11:00:00 | MSFT | Stock | 423.99 | 425.39 | 420.98 | 422.9 | 1969297.0 |
| 2024-07-25 12:00:00 | MSFT | Stock | 422.89 | 426.085 | 422.0 | 425.61 | 1464136.0 |
| 2024-07-25 13:00:00 | MSFT | Stock | 425.64 | 427.2723 | 423.72 | 424.895 | 1239701.0 |
| 2024-07-25 14:00:00 | MSFT | Stock | 424.9 | 425.0 | 420.43 | 420.955 | 1583768.0 |
| 2024-07-25 15:00:00 | MSFT | Stock | 420.87 | 422.44 | 417.94 | 418.4 | 2931461.0 |
| 2024-07-25 16:00:00 | MSFT | Stock | 418.4 | 418.5 | 417.2 | 418.0 | 3474909.0 |
| 2024-07-25 17:00:00 | MSFT | Stock | 418.01 | 418.4 | 417.52 | 417.7 | 12408.0 |
| 2024-07-25 18:00:00 | MSFT | Stock | 417.9 | 419.05 | 417.9 | 418.05 | 23494.0 |
| 2024-07-25 19:00:00 | MSFT | Stock | 418.1 | 418.5 | 417.75 | 418.15 | 8255.0 |
| 2024-07-25 04:00:00 | NVDA | Stock | 114.88 | 115.5 | 111.52 | 113.43 | 1561575.0 |
| 2024-07-25 05:00:00 | NVDA | Stock | 113.45 | 114.2 | 112.63 | 112.74 | 503572.0 |
| 2024-07-25 06:00:00 | NVDA | Stock | 112.77 | 113.8 | 112.44 | 113.69 | 514921.0 |
| 2024-07-25 07:00:00 | NVDA | Stock | 113.73 | 113.89 | 112.75 | 112.82 | 980980.0 |
| 2024-07-25 08:00:00 | NVDA | Stock | 113.5 | 115.75 | 111.5271 | 113.76 | 4171176.0 |
| 2024-07-25 09:00:00 | NVDA | Stock | 113.77 | 114.8 | 108.9 | 109.7851 | 58928076.0 |
| 2024-07-25 10:00:00 | NVDA | Stock | 109.78 | 115.77 | 106.3 | 115.4795 | 120523973.0 |
| 2024-07-25 11:00:00 | NVDA | Stock | 115.465 | 115.65 | 112.93 | 114.84 | 47352386.0 |
| 2024-07-25 12:00:00 | NVDA | Stock | 114.8397 | 116.58 | 113.87 | 116.0545 | 38155141.0 |
| 2024-07-25 13:00:00 | NVDA | Stock | 116.05 | 116.63 | 114.37 | 115.635 | 27532707.0 |
| 2024-07-25 14:00:00 | NVDA | Stock | 115.64 | 115.78 | 113.55 | 113.937 | 28110910.0 |
| 2024-07-25 15:00:00 | NVDA | Stock | 113.93 | 115.25 | 112.08 | 112.34 | 42655103.0 |
| 2024-07-25 16:00:00 | NVDA | Stock | 112.33 | 113.256 | 111.1 | 111.97 | 19106248.0 |
| 2024-07-25 17:00:00 | NVDA | Stock | 111.9506 | 112.28 | 111.68 | 111.9 | 584171.0 |
| 2024-07-25 18:00:00 | NVDA | Stock | 111.9 | 112.64 | 111.9 | 112.15 | 737997.0 |
| 2024-07-25 19:00:00 | NVDA | Stock | 112.15 | 112.36 | 111.81 | 112.24 | 527179.0 |
| 2024-07-25 04:00:00 | AMZN | Stock | 180.98 | 181.43 | 179.7 | 180.87 | 27297.0 |
| 2024-07-25 05:00:00 | AMZN | Stock | 180.85 | 181.33 | 180.63 | 180.68 | 7886.0 |
> showing 50 of 59,059 rows — these rows as CSV