PREVIEW / stock_1hour / 2024-05-10
file: by_date/stock_1hour/2024/2024-05-10.parquet size: 1.3 MB rows: 58,045 symbols: 962
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-10 04:00:00 | AAPL | Stock | 184.57 | 184.86 | 184.56 | 184.82 | 11971.0 |
| 2024-05-10 05:00:00 | AAPL | Stock | 184.81 | 185.0 | 184.7 | 184.94 | 20896.0 |
| 2024-05-10 06:00:00 | AAPL | Stock | 184.95 | 184.95 | 184.8 | 184.8 | 1726.0 |
| 2024-05-10 07:00:00 | AAPL | Stock | 184.85 | 184.99 | 184.75 | 184.79 | 12526.0 |
| 2024-05-10 08:00:00 | AAPL | Stock | 184.95 | 185.0 | 184.14 | 184.69 | 88302.0 |
| 2024-05-10 09:00:00 | AAPL | Stock | 184.69 | 185.09 | 183.36 | 183.6 | 6524055.0 |
| 2024-05-10 10:00:00 | AAPL | Stock | 183.62 | 183.9799 | 182.26 | 182.55 | 7372097.0 |
| 2024-05-10 11:00:00 | AAPL | Stock | 182.55 | 182.885 | 182.37 | 182.575 | 4385357.0 |
| 2024-05-10 12:00:00 | AAPL | Stock | 182.575 | 182.61 | 182.245 | 182.39 | 2807919.0 |
| 2024-05-10 13:00:00 | AAPL | Stock | 182.39 | 182.5199 | 182.13 | 182.475 | 2508418.0 |
| 2024-05-10 14:00:00 | AAPL | Stock | 182.475 | 182.93 | 182.35 | 182.9099 | 3834387.0 |
| 2024-05-10 15:00:00 | AAPL | Stock | 182.9078 | 183.2 | 182.675 | 182.99 | 5974824.0 |
| 2024-05-10 16:00:00 | AAPL | Stock | 182.99 | 183.05 | 182.58 | 182.58 | 7740436.0 |
| 2024-05-10 17:00:00 | AAPL | Stock | 182.57 | 183.06 | 182.55 | 182.75 | 61381.0 |
| 2024-05-10 18:00:00 | AAPL | Stock | 182.82 | 182.84 | 182.75 | 182.82 | 7174.0 |
| 2024-05-10 19:00:00 | AAPL | Stock | 183.05 | 183.05 | 182.5 | 182.5 | 20393.0 |
| 2024-05-10 04:00:00 | MSFT | Stock | 413.26 | 413.66 | 413.0 | 413.66 | 3212.0 |
| 2024-05-10 05:00:00 | MSFT | Stock | 413.8 | 414.9 | 413.8 | 414.6 | 1981.0 |
| 2024-05-10 06:00:00 | MSFT | Stock | 414.3 | 414.3 | 413.85 | 413.85 | 690.0 |
| 2024-05-10 07:00:00 | MSFT | Stock | 413.33 | 414.34 | 413.33 | 414.2 | 6270.0 |
| 2024-05-10 08:00:00 | MSFT | Stock | 413.65 | 414.3 | 412.79 | 412.85 | 31560.0 |
| 2024-05-10 09:00:00 | MSFT | Stock | 412.72 | 415.38 | 411.8 | 414.14 | 1211191.0 |
| 2024-05-10 10:00:00 | MSFT | Stock | 414.09 | 414.19 | 412.74 | 413.2145 | 1102489.0 |
| 2024-05-10 11:00:00 | MSFT | Stock | 413.23 | 413.955 | 412.65 | 413.71 | 583238.0 |
| 2024-05-10 12:00:00 | MSFT | Stock | 413.72 | 414.64 | 413.35 | 414.4375 | 473752.0 |
| 2024-05-10 13:00:00 | MSFT | Stock | 414.4 | 414.58 | 413.62 | 414.46 | 391192.0 |
| 2024-05-10 14:00:00 | MSFT | Stock | 414.445 | 414.86 | 414.03 | 414.84 | 535057.0 |
| 2024-05-10 15:00:00 | MSFT | Stock | 414.85 | 415.13 | 414.31 | 414.64 | 1002702.0 |
| 2024-05-10 16:00:00 | MSFT | Stock | 414.6 | 415.09 | 414.44 | 414.85 | 2691505.0 |
| 2024-05-10 17:00:00 | MSFT | Stock | 414.8598 | 415.0011 | 414.5 | 414.5 | 9694.0 |
| 2024-05-10 18:00:00 | MSFT | Stock | 414.49 | 414.49 | 414.0545 | 414.4499 | 1109.0 |
| 2024-05-10 19:00:00 | MSFT | Stock | 414.74 | 414.74 | 414.15 | 414.6 | 3089.0 |
| 2024-05-10 04:00:00 | NVDA | Stock | 89.4 | 90.355 | 89.255 | 90.298 | 286260.0 |
| 2024-05-10 05:00:00 | NVDA | Stock | 90.268 | 90.278 | 90.0 | 90.0 | 134640.0 |
| 2024-05-10 06:00:00 | NVDA | Stock | 90.011 | 90.068 | 89.866 | 89.94 | 116970.0 |
| 2024-05-10 07:00:00 | NVDA | Stock | 89.94 | 89.98 | 89.712 | 89.942 | 454680.0 |
| 2024-05-10 08:00:00 | NVDA | Stock | 89.875 | 90.15 | 88.968 | 89.888 | 2166430.0 |
| 2024-05-10 09:00:00 | NVDA | Stock | 89.84 | 91.401 | 89.84 | 90.8215 | 56502050.0 |
| 2024-05-10 10:00:00 | NVDA | Stock | 90.823 | 90.909 | 89.36 | 89.814 | 60904770.0 |
| 2024-05-10 11:00:00 | NVDA | Stock | 89.793 | 90.196 | 89.227 | 89.6058 | 30953340.0 |
| 2024-05-10 12:00:00 | NVDA | Stock | 89.594 | 90.0199 | 89.32 | 89.877 | 20813520.0 |
| 2024-05-10 13:00:00 | NVDA | Stock | 89.878 | 90.024 | 89.656 | 89.993 | 17916290.0 |
| 2024-05-10 14:00:00 | NVDA | Stock | 89.992 | 90.122 | 89.685 | 89.9014 | 18220380.0 |
| 2024-05-10 15:00:00 | NVDA | Stock | 89.881 | 89.985 | 89.561 | 89.886 | 23290130.0 |
| 2024-05-10 16:00:00 | NVDA | Stock | 89.878 | 89.95 | 89.626 | 89.7 | 11126970.0 |
| 2024-05-10 17:00:00 | NVDA | Stock | 89.6708 | 89.803 | 89.67 | 89.78 | 543790.0 |
| 2024-05-10 18:00:00 | NVDA | Stock | 89.78 | 89.78 | 89.701 | 89.714 | 94990.0 |
| 2024-05-10 19:00:00 | NVDA | Stock | 89.714 | 89.878 | 89.651 | 89.72 | 392690.0 |
| 2024-05-10 04:00:00 | AMZN | Stock | 189.61 | 189.95 | 189.39 | 189.94 | 7444.0 |
| 2024-05-10 05:00:00 | AMZN | Stock | 189.98 | 190.31 | 189.95 | 190.28 | 5200.0 |
> showing 50 of 58,045 rows — these rows as CSV