PREVIEW / stock_1hour / 2024-07-15
file: by_date/stock_1hour/2024/2024-07-15.parquet size: 1.4 MB rows: 60,552 symbols: 907
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-15 04:00:00 | AAPL | Stock | 232.22 | 234.77 | 232.0 | 234.4 | 154096.0 |
| 2024-07-15 05:00:00 | AAPL | Stock | 234.5 | 235.21 | 234.08 | 235.07 | 43413.0 |
| 2024-07-15 06:00:00 | AAPL | Stock | 235.0 | 235.56 | 234.89 | 235.09 | 32986.0 |
| 2024-07-15 07:00:00 | AAPL | Stock | 235.03 | 235.38 | 234.7 | 234.7 | 135446.0 |
| 2024-07-15 08:00:00 | AAPL | Stock | 234.9101 | 235.48 | 231.0 | 235.06 | 403194.0 |
| 2024-07-15 09:00:00 | AAPL | Stock | 235.1 | 237.23 | 233.33 | 234.4901 | 11711731.0 |
| 2024-07-15 10:00:00 | AAPL | Stock | 234.5 | 235.62 | 234.13 | 235.5013 | 6728786.0 |
| 2024-07-15 11:00:00 | AAPL | Stock | 235.51 | 236.3101 | 234.66 | 235.09 | 4833033.0 |
| 2024-07-15 12:00:00 | AAPL | Stock | 235.09 | 235.88 | 234.5 | 235.4529 | 2865147.0 |
| 2024-07-15 13:00:00 | AAPL | Stock | 235.46 | 235.49 | 234.11 | 234.5499 | 3504806.0 |
| 2024-07-15 14:00:00 | AAPL | Stock | 234.538 | 234.8401 | 233.904 | 234.7837 | 2886787.0 |
| 2024-07-15 15:00:00 | AAPL | Stock | 234.78 | 235.08 | 233.09 | 234.42 | 6252673.0 |
| 2024-07-15 16:00:00 | AAPL | Stock | 234.43 | 234.99 | 234.4 | 234.95 | 8714262.0 |
| 2024-07-15 17:00:00 | AAPL | Stock | 234.9799 | 234.99 | 234.4 | 234.99 | 90026.0 |
| 2024-07-15 18:00:00 | AAPL | Stock | 234.99 | 235.29 | 234.97 | 235.26 | 29634.0 |
| 2024-07-15 19:00:00 | AAPL | Stock | 235.26 | 235.57 | 235.25 | 235.57 | 40987.0 |
| 2024-07-15 04:00:00 | MSFT | Stock | 454.97 | 455.0 | 454.0 | 454.53 | 7870.0 |
| 2024-07-15 05:00:00 | MSFT | Stock | 454.21 | 454.21 | 453.3 | 453.3 | 600.0 |
| 2024-07-15 06:00:00 | MSFT | Stock | 453.14 | 453.14 | 452.14 | 452.38 | 3213.0 |
| 2024-07-15 07:00:00 | MSFT | Stock | 452.71 | 453.51 | 452.6 | 453.28 | 9337.0 |
| 2024-07-15 08:00:00 | MSFT | Stock | 452.78 | 456.0 | 452.5 | 452.75 | 29995.0 |
| 2024-07-15 09:00:00 | MSFT | Stock | 452.8936 | 456.25 | 452.25 | 454.515 | 1129462.0 |
| 2024-07-15 10:00:00 | MSFT | Stock | 454.52 | 456.13 | 453.67 | 455.48 | 1055837.0 |
| 2024-07-15 11:00:00 | MSFT | Stock | 455.57 | 457.26 | 453.88 | 455.14 | 835850.0 |
| 2024-07-15 12:00:00 | MSFT | Stock | 455.12 | 455.12 | 451.43 | 453.48 | 698873.0 |
| 2024-07-15 13:00:00 | MSFT | Stock | 453.46 | 453.46 | 451.43 | 451.7274 | 555983.0 |
| 2024-07-15 14:00:00 | MSFT | Stock | 451.71 | 453.96 | 451.59 | 453.79 | 514015.0 |
| 2024-07-15 15:00:00 | MSFT | Stock | 453.77 | 454.37 | 451.65 | 454.04 | 1174364.0 |
| 2024-07-15 16:00:00 | MSFT | Stock | 453.96 | 454.79 | 453.91 | 454.21 | 2883255.0 |
| 2024-07-15 17:00:00 | MSFT | Stock | 454.13 | 454.13 | 453.96 | 454.0 | 762708.0 |
| 2024-07-15 18:00:00 | MSFT | Stock | 454.12 | 454.64 | 454.12 | 454.5 | 3205.0 |
| 2024-07-15 19:00:00 | MSFT | Stock | 454.6 | 454.7401 | 454.6 | 454.74 | 2006.0 |
| 2024-07-15 04:00:00 | NVDA | Stock | 130.24 | 130.95 | 129.5 | 130.24 | 384840.0 |
| 2024-07-15 05:00:00 | NVDA | Stock | 130.24 | 130.31 | 129.76 | 130.2 | 105740.0 |
| 2024-07-15 06:00:00 | NVDA | Stock | 130.2 | 130.34 | 129.93 | 130.15 | 152924.0 |
| 2024-07-15 07:00:00 | NVDA | Stock | 130.12 | 131.25 | 130.04 | 130.9 | 1260967.0 |
| 2024-07-15 08:00:00 | NVDA | Stock | 130.25 | 131.5 | 129.0 | 130.8599 | 2646119.0 |
| 2024-07-15 09:00:00 | NVDA | Stock | 130.86 | 131.39 | 128.05 | 128.78 | 31565690.0 |
| 2024-07-15 10:00:00 | NVDA | Stock | 128.77 | 130.2 | 128.63 | 129.82 | 26532336.0 |
| 2024-07-15 11:00:00 | NVDA | Stock | 129.81 | 130.69 | 128.45 | 128.935 | 24715677.0 |
| 2024-07-15 12:00:00 | NVDA | Stock | 128.94 | 129.107 | 127.26 | 128.7196 | 23007153.0 |
| 2024-07-15 13:00:00 | NVDA | Stock | 128.71 | 128.7436 | 127.5 | 127.752 | 18164835.0 |
| 2024-07-15 14:00:00 | NVDA | Stock | 127.76 | 128.38 | 127.38 | 128.08 | 16027979.0 |
| 2024-07-15 15:00:00 | NVDA | Stock | 128.07 | 128.5 | 127.18 | 128.42 | 21781264.0 |
| 2024-07-15 16:00:00 | NVDA | Stock | 128.45 | 128.9276 | 128.1 | 128.51 | 11938159.0 |
| 2024-07-15 17:00:00 | NVDA | Stock | 128.4906 | 128.68 | 128.44 | 128.52 | 379878.0 |
| 2024-07-15 18:00:00 | NVDA | Stock | 128.53 | 128.69 | 128.5 | 128.56 | 244381.0 |
| 2024-07-15 19:00:00 | NVDA | Stock | 128.56 | 128.64 | 128.52 | 128.6 | 366966.0 |
| 2024-07-15 04:00:00 | AMZN | Stock | 194.95 | 195.45 | 194.9 | 195.33 | 19829.0 |
| 2024-07-15 05:00:00 | AMZN | Stock | 195.31 | 195.33 | 195.07 | 195.16 | 5911.0 |
> showing 50 of 60,552 rows — these rows as CSV