PREVIEW / stock_1hour / 2024-03-15
file: by_date/stock_1hour/2024/2024-03-15.parquet size: 1.4 MB rows: 59,470 symbols: 1,066
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-03-15 04:00:00 | AAPL | Stock | 173.41 | 173.64 | 173.21 | 173.49 | 8062.0 |
| 2024-03-15 05:00:00 | AAPL | Stock | 173.49 | 174.21 | 173.49 | 174.18 | 21330.0 |
| 2024-03-15 06:00:00 | AAPL | Stock | 174.15 | 174.25 | 173.85 | 173.85 | 8977.0 |
| 2024-03-15 07:00:00 | AAPL | Stock | 173.82 | 173.92 | 173.4 | 173.4 | 33927.0 |
| 2024-03-15 08:00:00 | AAPL | Stock | 173.86 | 173.94 | 173.37 | 173.68 | 110270.0 |
| 2024-03-15 09:00:00 | AAPL | Stock | 173.65 | 173.66 | 170.05 | 171.45 | 17561518.0 |
| 2024-03-15 10:00:00 | AAPL | Stock | 171.44 | 171.605 | 170.285 | 170.7 | 7513545.0 |
| 2024-03-15 11:00:00 | AAPL | Stock | 170.7 | 171.17 | 170.6111 | 170.985 | 5347481.0 |
| 2024-03-15 12:00:00 | AAPL | Stock | 170.98 | 171.515 | 170.66 | 170.7073 | 4319577.0 |
| 2024-03-15 13:00:00 | AAPL | Stock | 170.705 | 171.14 | 170.52 | 171.1274 | 4146746.0 |
| 2024-03-15 14:00:00 | AAPL | Stock | 171.125 | 171.52 | 170.8 | 171.52 | 5602566.0 |
| 2024-03-15 15:00:00 | AAPL | Stock | 171.5256 | 172.6 | 171.47 | 172.56 | 10003690.0 |
| 2024-03-15 16:00:00 | AAPL | Stock | 172.57 | 172.65 | 172.27 | 172.49 | 37425775.0 |
| 2024-03-15 17:00:00 | AAPL | Stock | 172.51 | 172.62 | 172.29 | 172.29 | 74285.0 |
| 2024-03-15 18:00:00 | AAPL | Stock | 172.3 | 172.6 | 172.25 | 172.59 | 46016.0 |
| 2024-03-15 19:00:00 | AAPL | Stock | 172.59 | 172.74 | 172.59 | 172.63 | 30142.0 |
| 2024-03-15 04:00:00 | MSFT | Stock | 426.33 | 427.78 | 426.0 | 427.3 | 5359.0 |
| 2024-03-15 05:00:00 | MSFT | Stock | 427.38 | 428.79 | 427.3 | 428.5 | 8992.0 |
| 2024-03-15 06:00:00 | MSFT | Stock | 428.5 | 428.95 | 428.5 | 428.73 | 7934.0 |
| 2024-03-15 07:00:00 | MSFT | Stock | 428.5 | 428.55 | 427.2 | 427.25 | 15743.0 |
| 2024-03-15 08:00:00 | MSFT | Stock | 428.39 | 428.78 | 426.27 | 427.25 | 62605.0 |
| 2024-03-15 09:00:00 | MSFT | Stock | 427.013 | 427.013 | 417.0 | 418.4194 | 8896684.0 |
| 2024-03-15 10:00:00 | MSFT | Stock | 418.45 | 419.3 | 415.76 | 418.08 | 2713695.0 |
| 2024-03-15 11:00:00 | MSFT | Stock | 418.14 | 418.39 | 415.08 | 415.235 | 1556430.0 |
| 2024-03-15 12:00:00 | MSFT | Stock | 415.25 | 415.83 | 412.79 | 413.2076 | 1787770.0 |
| 2024-03-15 13:00:00 | MSFT | Stock | 413.23 | 415.2 | 413.085 | 415.15 | 1297768.0 |
| 2024-03-15 14:00:00 | MSFT | Stock | 415.1799 | 416.33 | 414.33 | 415.955 | 1183971.0 |
| 2024-03-15 15:00:00 | MSFT | Stock | 415.97 | 417.2799 | 415.59 | 416.422 | 2260006.0 |
| 2024-03-15 16:00:00 | MSFT | Stock | 416.42 | 416.62 | 415.4 | 415.4 | 11169187.0 |
| 2024-03-15 17:00:00 | MSFT | Stock | 415.4 | 416.42 | 415.33 | 415.65 | 34672.0 |
| 2024-03-15 18:00:00 | MSFT | Stock | 415.64 | 415.8899 | 415.0 | 415.4 | 11756.0 |
| 2024-03-15 19:00:00 | MSFT | Stock | 415.38 | 415.8 | 415.38 | 415.44 | 7675.0 |
| 2024-03-15 04:00:00 | NVDA | Stock | 87.0 | 88.228 | 86.928 | 88.2 | 284270.0 |
| 2024-03-15 05:00:00 | NVDA | Stock | 88.16 | 88.35 | 87.75 | 88.298 | 335010.0 |
| 2024-03-15 06:00:00 | NVDA | Stock | 88.25 | 89.094 | 88.203 | 88.663 | 432920.0 |
| 2024-03-15 07:00:00 | NVDA | Stock | 88.678 | 88.75 | 88.098 | 88.2 | 1217160.0 |
| 2024-03-15 08:00:00 | NVDA | Stock | 88.522 | 88.9 | 86.5 | 87.56 | 3387500.0 |
| 2024-03-15 09:00:00 | NVDA | Stock | 87.555 | 88.341 | 86.257 | 87.725 | 76812380.0 |
| 2024-03-15 10:00:00 | NVDA | Stock | 87.7 | 89.538 | 86.98 | 88.882 | 77503340.0 |
| 2024-03-15 11:00:00 | NVDA | Stock | 88.888 | 89.33 | 88.631 | 88.9705 | 40461620.0 |
| 2024-03-15 12:00:00 | NVDA | Stock | 88.956 | 89.2 | 88.412 | 88.736 | 32506520.0 |
| 2024-03-15 13:00:00 | NVDA | Stock | 88.753 | 89.074 | 88.599 | 88.9837 | 26659820.0 |
| 2024-03-15 14:00:00 | NVDA | Stock | 88.99 | 89.546 | 88.961 | 89.128 | 34690770.0 |
| 2024-03-15 15:00:00 | NVDA | Stock | 89.128 | 89.25 | 87.64 | 87.809 | 63549460.0 |
| 2024-03-15 16:00:00 | NVDA | Stock | 87.8115 | 88.0 | 87.481 | 87.85 | 80142950.0 |
| 2024-03-15 17:00:00 | NVDA | Stock | 87.8501 | 88.211 | 87.806 | 87.968 | 1114270.0 |
| 2024-03-15 18:00:00 | NVDA | Stock | 87.982 | 88.05 | 87.868 | 88.006 | 525130.0 |
| 2024-03-15 19:00:00 | NVDA | Stock | 88.04 | 88.3 | 88.02 | 88.192 | 733240.0 |
| 2024-03-15 04:00:00 | AMZN | Stock | 178.22 | 178.5 | 178.2 | 178.25 | 11888.0 |
| 2024-03-15 05:00:00 | AMZN | Stock | 178.28 | 178.29 | 178.0 | 178.25 | 24976.0 |
> showing 50 of 59,470 rows — these rows as CSV