PREVIEW / stock_1hour / 2024-04-15
file: by_date/stock_1hour/2024/2024-04-15.parquet size: 1.3 MB rows: 59,966 symbols: 1,013
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-04-15 04:00:00 | AAPL | Stock | 175.36 | 176.21 | 175.15 | 175.18 | 52126.0 |
| 2024-04-15 05:00:00 | AAPL | Stock | 175.25 | 175.55 | 174.5 | 174.65 | 29903.0 |
| 2024-04-15 06:00:00 | AAPL | Stock | 174.72 | 174.72 | 174.0 | 174.35 | 51367.0 |
| 2024-04-15 07:00:00 | AAPL | Stock | 174.4 | 175.58 | 174.35 | 175.52 | 158128.0 |
| 2024-04-15 08:00:00 | AAPL | Stock | 174.43 | 176.28 | 174.3701 | 175.6504 | 332676.0 |
| 2024-04-15 09:00:00 | AAPL | Stock | 175.73 | 175.98 | 173.83 | 174.63 | 8237179.0 |
| 2024-04-15 10:00:00 | AAPL | Stock | 174.62 | 175.27 | 174.5 | 174.83 | 6565885.0 |
| 2024-04-15 11:00:00 | AAPL | Stock | 174.84 | 176.63 | 174.835 | 176.005 | 7457512.0 |
| 2024-04-15 12:00:00 | AAPL | Stock | 176.0001 | 176.15 | 174.9 | 175.13 | 3660010.0 |
| 2024-04-15 13:00:00 | AAPL | Stock | 175.135 | 175.57 | 173.532 | 173.9 | 6003776.0 |
| 2024-04-15 14:00:00 | AAPL | Stock | 173.89 | 173.89 | 172.5 | 173.3111 | 7604574.0 |
| 2024-04-15 15:00:00 | AAPL | Stock | 173.32 | 173.64 | 172.66 | 172.69 | 8102212.0 |
| 2024-04-15 16:00:00 | AAPL | Stock | 172.69 | 172.99 | 172.43 | 172.95 | 10280318.0 |
| 2024-04-15 17:00:00 | AAPL | Stock | 172.91 | 172.91 | 172.61 | 172.8 | 47034.0 |
| 2024-04-15 18:00:00 | AAPL | Stock | 172.8 | 173.12 | 172.5 | 172.66 | 50150.0 |
| 2024-04-15 19:00:00 | AAPL | Stock | 172.69 | 172.77 | 172.49 | 172.65 | 26063.0 |
| 2024-04-15 04:00:00 | MSFT | Stock | 423.99 | 425.0 | 423.99 | 424.5 | 10558.0 |
| 2024-04-15 05:00:00 | MSFT | Stock | 424.4 | 424.8 | 424.07 | 424.13 | 5831.0 |
| 2024-04-15 06:00:00 | MSFT | Stock | 424.03 | 424.3 | 424.0 | 424.2 | 2753.0 |
| 2024-04-15 07:00:00 | MSFT | Stock | 424.13 | 425.0 | 423.95 | 424.7 | 19484.0 |
| 2024-04-15 08:00:00 | MSFT | Stock | 424.4 | 426.26 | 421.95 | 425.45 | 52031.0 |
| 2024-04-15 09:00:00 | MSFT | Stock | 425.04 | 426.85 | 423.71 | 426.17 | 1487809.0 |
| 2024-04-15 10:00:00 | MSFT | Stock | 426.15 | 426.82 | 421.99 | 422.31 | 1715391.0 |
| 2024-04-15 11:00:00 | MSFT | Stock | 422.3 | 423.24 | 421.6 | 421.93 | 952063.0 |
| 2024-04-15 12:00:00 | MSFT | Stock | 421.91 | 422.45 | 419.365 | 420.1 | 950618.0 |
| 2024-04-15 13:00:00 | MSFT | Stock | 420.1 | 420.69 | 414.5 | 415.72 | 1329166.0 |
| 2024-04-15 14:00:00 | MSFT | Stock | 415.66 | 415.95 | 413.98 | 414.79 | 914343.0 |
| 2024-04-15 15:00:00 | MSFT | Stock | 414.82 | 415.06 | 413.43 | 413.63 | 1943873.0 |
| 2024-04-15 16:00:00 | MSFT | Stock | 413.64 | 413.65 | 412.51 | 413.41 | 4034787.0 |
| 2024-04-15 17:00:00 | MSFT | Stock | 413.25 | 413.64 | 413.0 | 413.26 | 9974.0 |
| 2024-04-15 18:00:00 | MSFT | Stock | 413.3 | 414.0 | 413.25 | 413.9 | 12095.0 |
| 2024-04-15 19:00:00 | MSFT | Stock | 413.75 | 414.35 | 413.0 | 414.0 | 7770.0 |
| 2024-04-15 04:00:00 | NVDA | Stock | 88.152 | 89.05 | 88.152 | 88.85 | 230780.0 |
| 2024-04-15 05:00:00 | NVDA | Stock | 88.859 | 89.377 | 88.859 | 89.055 | 137860.0 |
| 2024-04-15 06:00:00 | NVDA | Stock | 89.1 | 89.45 | 89.1 | 89.145 | 152600.0 |
| 2024-04-15 07:00:00 | NVDA | Stock | 89.13 | 89.25 | 88.752 | 88.905 | 881380.0 |
| 2024-04-15 08:00:00 | NVDA | Stock | 88.971 | 89.1506 | 87.9 | 88.978 | 2591080.0 |
| 2024-04-15 09:00:00 | NVDA | Stock | 88.987 | 90.424 | 88.23 | 90.1575 | 55449490.0 |
| 2024-04-15 10:00:00 | NVDA | Stock | 90.164 | 90.613 | 88.6499 | 88.747 | 58775600.0 |
| 2024-04-15 11:00:00 | NVDA | Stock | 88.776 | 89.093 | 88.304 | 88.962 | 32739690.0 |
| 2024-04-15 12:00:00 | NVDA | Stock | 88.956 | 89.1956 | 87.588 | 88.077 | 29764760.0 |
| 2024-04-15 13:00:00 | NVDA | Stock | 88.051 | 88.3338 | 86.333 | 86.9257 | 42427850.0 |
| 2024-04-15 14:00:00 | NVDA | Stock | 86.925 | 87.279 | 86.48 | 86.8335 | 30049780.0 |
| 2024-04-15 15:00:00 | NVDA | Stock | 86.8335 | 86.8379 | 85.929 | 86.001 | 46086180.0 |
| 2024-04-15 16:00:00 | NVDA | Stock | 86.001 | 88.0 | 85.5 | 85.74 | 16504760.0 |
| 2024-04-15 17:00:00 | NVDA | Stock | 85.7112 | 86.001 | 85.385 | 85.6 | 843020.0 |
| 2024-04-15 18:00:00 | NVDA | Stock | 85.606 | 85.82 | 85.606 | 85.734 | 547560.0 |
| 2024-04-15 19:00:00 | NVDA | Stock | 85.734 | 85.78 | 85.64 | 85.7 | 466110.0 |
| 2024-04-15 04:00:00 | AMZN | Stock | 186.93 | 187.51 | 186.43 | 187.34 | 17790.0 |
| 2024-04-15 05:00:00 | AMZN | Stock | 187.36 | 187.5 | 187.0 | 187.06 | 10761.0 |
> showing 50 of 59,966 rows — these rows as CSV