PREVIEW / stock_1hour / 2024-05-06
file: by_date/stock_1hour/2024/2024-05-06.parquet size: 1.3 MB rows: 59,783 symbols: 991
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-05-06 04:00:00 | AAPL | Stock | 180.4 | 181.63 | 180.3 | 181.38 | 99669.0 |
| 2024-05-06 05:00:00 | AAPL | Stock | 181.39 | 182.0 | 181.35 | 181.67 | 33418.0 |
| 2024-05-06 06:00:00 | AAPL | Stock | 181.64 | 182.32 | 181.31 | 182.32 | 45269.0 |
| 2024-05-06 07:00:00 | AAPL | Stock | 182.35 | 182.99 | 182.32 | 182.62 | 101143.0 |
| 2024-05-06 08:00:00 | AAPL | Stock | 182.39 | 182.96 | 180.5 | 182.33 | 426984.0 |
| 2024-05-06 09:00:00 | AAPL | Stock | 182.297 | 184.2 | 181.63 | 182.4701 | 10595158.0 |
| 2024-05-06 10:00:00 | AAPL | Stock | 182.48 | 183.0899 | 181.89 | 182.39 | 8775276.0 |
| 2024-05-06 11:00:00 | AAPL | Stock | 182.38 | 182.4 | 181.69 | 182.315 | 5791504.0 |
| 2024-05-06 12:00:00 | AAPL | Stock | 182.315 | 182.38 | 181.28 | 181.53 | 6402249.0 |
| 2024-05-06 13:00:00 | AAPL | Stock | 181.52 | 181.718 | 180.42 | 181.09 | 7113563.0 |
| 2024-05-06 14:00:00 | AAPL | Stock | 181.085 | 181.34 | 180.69 | 181.15 | 5477411.0 |
| 2024-05-06 15:00:00 | AAPL | Stock | 181.1576 | 182.02 | 180.86 | 181.7 | 10379317.0 |
| 2024-05-06 16:00:00 | AAPL | Stock | 181.61 | 181.9 | 181.3 | 181.82 | 6993601.0 |
| 2024-05-06 17:00:00 | AAPL | Stock | 181.83 | 182.05 | 181.71 | 181.83 | 76346.0 |
| 2024-05-06 18:00:00 | AAPL | Stock | 181.77 | 182.0 | 181.7617 | 181.97 | 35862.0 |
| 2024-05-06 19:00:00 | AAPL | Stock | 181.95 | 183.9 | 181.89 | 182.89 | 384592.0 |
| 2024-05-06 04:00:00 | MSFT | Stock | 407.23 | 407.76 | 407.13 | 407.6 | 1956.0 |
| 2024-05-06 05:00:00 | MSFT | Stock | 407.54 | 407.93 | 407.39 | 407.93 | 1067.0 |
| 2024-05-06 06:00:00 | MSFT | Stock | 407.99 | 408.8 | 407.99 | 408.55 | 3919.0 |
| 2024-05-06 07:00:00 | MSFT | Stock | 408.27 | 408.39 | 408.0 | 408.1 | 4583.0 |
| 2024-05-06 08:00:00 | MSFT | Stock | 408.2619 | 409.1 | 406.59 | 408.78 | 35125.0 |
| 2024-05-06 09:00:00 | MSFT | Stock | 408.7604 | 409.42 | 406.3701 | 407.365 | 1321398.0 |
| 2024-05-06 10:00:00 | MSFT | Stock | 407.4 | 409.32 | 406.52 | 409.165 | 1434953.0 |
| 2024-05-06 11:00:00 | MSFT | Stock | 409.2 | 410.23 | 408.868 | 409.92 | 870477.0 |
| 2024-05-06 12:00:00 | MSFT | Stock | 409.9231 | 410.83 | 409.36 | 410.41 | 609186.0 |
| 2024-05-06 13:00:00 | MSFT | Stock | 410.425 | 411.68 | 409.65 | 411.55 | 689249.0 |
| 2024-05-06 14:00:00 | MSFT | Stock | 411.54 | 412.56 | 411.46 | 412.42 | 635838.0 |
| 2024-05-06 15:00:00 | MSFT | Stock | 412.42 | 413.93 | 411.8 | 413.64 | 1477861.0 |
| 2024-05-06 16:00:00 | MSFT | Stock | 413.73 | 413.76 | 413.2206 | 413.45 | 3621540.0 |
| 2024-05-06 17:00:00 | MSFT | Stock | 413.54 | 414.0 | 413.54 | 413.76 | 24323.0 |
| 2024-05-06 18:00:00 | MSFT | Stock | 413.57 | 413.87 | 413.49 | 413.49 | 12374.0 |
| 2024-05-06 19:00:00 | MSFT | Stock | 413.6 | 413.6 | 412.65 | 412.65 | 6100.0 |
| 2024-05-06 04:00:00 | NVDA | Stock | 88.869 | 89.47 | 88.848 | 89.4 | 296650.0 |
| 2024-05-06 05:00:00 | NVDA | Stock | 89.42 | 89.445 | 89.245 | 89.42 | 88260.0 |
| 2024-05-06 06:00:00 | NVDA | Stock | 89.443 | 89.445 | 89.3 | 89.32 | 86610.0 |
| 2024-05-06 07:00:00 | NVDA | Stock | 89.351 | 89.4 | 89.184 | 89.23 | 564870.0 |
| 2024-05-06 08:00:00 | NVDA | Stock | 89.351 | 89.445 | 88.511 | 89.2652 | 1999530.0 |
| 2024-05-06 09:00:00 | NVDA | Stock | 89.2501 | 91.599 | 88.951 | 91.5823 | 60693850.0 |
| 2024-05-06 10:00:00 | NVDA | Stock | 91.597 | 91.688 | 90.83 | 91.1809 | 52418260.0 |
| 2024-05-06 11:00:00 | NVDA | Stock | 91.173 | 91.9628 | 91.066 | 91.792 | 33358990.0 |
| 2024-05-06 12:00:00 | NVDA | Stock | 91.782 | 91.99 | 91.445 | 91.9735 | 25037410.0 |
| 2024-05-06 13:00:00 | NVDA | Stock | 91.983 | 91.991 | 91.56 | 91.734 | 18594320.0 |
| 2024-05-06 14:00:00 | NVDA | Stock | 91.7285 | 92.22 | 91.689 | 92.1213 | 25691270.0 |
| 2024-05-06 15:00:00 | NVDA | Stock | 92.1145 | 92.187 | 91.671 | 92.161 | 32672730.0 |
| 2024-05-06 16:00:00 | NVDA | Stock | 92.033 | 92.19 | 91.3896 | 91.915 | 14593270.0 |
| 2024-05-06 17:00:00 | NVDA | Stock | 91.939 | 92.14 | 91.925 | 91.97 | 247130.0 |
| 2024-05-06 18:00:00 | NVDA | Stock | 91.952 | 92.05 | 91.94 | 92.05 | 247560.0 |
| 2024-05-06 19:00:00 | NVDA | Stock | 92.006 | 92.043 | 91.031 | 91.502 | 1972810.0 |
| 2024-05-06 04:00:00 | AMZN | Stock | 185.85 | 186.23 | 185.85 | 186.0 | 11147.0 |
| 2024-05-06 05:00:00 | AMZN | Stock | 186.15 | 186.31 | 186.15 | 186.31 | 4630.0 |
> showing 50 of 59,783 rows — these rows as CSV