PREVIEW / stock_1hour / 2024-04-05
file: by_date/stock_1hour/2024/2024-04-05.parquet size: 1.3 MB rows: 58,342 symbols: 1,027
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-05 04:00:00 | AAPL | Stock | 169.2 | 169.35 | 169.1 | 169.3 | 13372.0 |
| 2024-04-05 05:00:00 | AAPL | Stock | 169.36 | 169.4 | 169.3 | 169.4 | 3704.0 |
| 2024-04-05 06:00:00 | AAPL | Stock | 169.44 | 169.47 | 169.27 | 169.47 | 4493.0 |
| 2024-04-05 07:00:00 | AAPL | Stock | 169.48 | 169.94 | 169.36 | 169.7 | 19763.0 |
| 2024-04-05 08:00:00 | AAPL | Stock | 169.4 | 170.1 | 168.81 | 169.82 | 218608.0 |
| 2024-04-05 09:00:00 | AAPL | Stock | 169.8 | 170.1 | 168.95 | 169.54 | 4569224.0 |
| 2024-04-05 10:00:00 | AAPL | Stock | 169.54 | 169.91 | 169.045 | 169.65 | 4581597.0 |
| 2024-04-05 11:00:00 | AAPL | Stock | 169.645 | 170.24 | 169.2109 | 170.21 | 4162549.0 |
| 2024-04-05 12:00:00 | AAPL | Stock | 170.21 | 170.39 | 169.9301 | 170.26 | 2831184.0 |
| 2024-04-05 13:00:00 | AAPL | Stock | 170.255 | 170.375 | 169.51 | 169.62 | 2601924.0 |
| 2024-04-05 14:00:00 | AAPL | Stock | 169.63 | 169.97 | 169.35 | 169.59 | 2804913.0 |
| 2024-04-05 15:00:00 | AAPL | Stock | 169.59 | 169.98 | 169.5 | 169.6 | 5278379.0 |
| 2024-04-05 16:00:00 | AAPL | Stock | 169.57 | 169.99 | 169.47 | 169.56 | 6690083.0 |
| 2024-04-05 17:00:00 | AAPL | Stock | 169.56 | 169.7 | 169.53 | 169.63 | 17006.0 |
| 2024-04-05 18:00:00 | AAPL | Stock | 169.62 | 169.68 | 169.45 | 169.5 | 15346.0 |
| 2024-04-05 19:00:00 | AAPL | Stock | 169.5 | 169.56 | 169.25 | 169.47 | 19664.0 |
| 2024-04-05 04:00:00 | MSFT | Stock | 419.21 | 419.55 | 419.21 | 419.43 | 2012.0 |
| 2024-04-05 05:00:00 | MSFT | Stock | 419.39 | 419.68 | 419.39 | 419.68 | 712.0 |
| 2024-04-05 06:00:00 | MSFT | Stock | 419.45 | 419.5 | 419.45 | 419.5 | 387.0 |
| 2024-04-05 07:00:00 | MSFT | Stock | 419.91 | 420.4 | 419.91 | 420.4 | 3864.0 |
| 2024-04-05 08:00:00 | MSFT | Stock | 419.96 | 421.8199 | 418.5 | 420.9236 | 118176.0 |
| 2024-04-05 09:00:00 | MSFT | Stock | 420.96 | 422.565 | 418.32 | 422.3 | 1384710.0 |
| 2024-04-05 10:00:00 | MSFT | Stock | 422.35 | 424.0296 | 420.92 | 424.02 | 1324522.0 |
| 2024-04-05 11:00:00 | MSFT | Stock | 424.03 | 426.3 | 422.86 | 425.68 | 1014273.0 |
| 2024-04-05 12:00:00 | MSFT | Stock | 425.71 | 426.315 | 425.02 | 426.27 | 776452.0 |
| 2024-04-05 13:00:00 | MSFT | Stock | 426.27 | 426.49 | 423.79 | 424.13 | 723116.0 |
| 2024-04-05 14:00:00 | MSFT | Stock | 424.08 | 425.52 | 423.37 | 424.35 | 701202.0 |
| 2024-04-05 15:00:00 | MSFT | Stock | 424.35 | 426.51 | 424.16 | 425.36 | 1466780.0 |
| 2024-04-05 16:00:00 | MSFT | Stock | 425.52 | 426.0 | 424.5 | 425.2 | 2869203.0 |
| 2024-04-05 17:00:00 | MSFT | Stock | 425.24 | 425.26 | 425.05 | 425.21 | 4247.0 |
| 2024-04-05 18:00:00 | MSFT | Stock | 425.23 | 425.39 | 425.15 | 425.39 | 4850.0 |
| 2024-04-05 19:00:00 | MSFT | Stock | 425.21 | 425.52 | 425.21 | 425.48 | 1340.0 |
| 2024-04-05 04:00:00 | NVDA | Stock | 86.8 | 86.847 | 86.39 | 86.6 | 147010.0 |
| 2024-04-05 05:00:00 | NVDA | Stock | 86.7 | 86.7 | 86.422 | 86.564 | 172560.0 |
| 2024-04-05 06:00:00 | NVDA | Stock | 86.529 | 86.6 | 86.25 | 86.43 | 90470.0 |
| 2024-04-05 07:00:00 | NVDA | Stock | 86.437 | 86.59 | 86.287 | 86.479 | 415960.0 |
| 2024-04-05 08:00:00 | NVDA | Stock | 86.469 | 87.373 | 85.8 | 86.7 | 5180210.0 |
| 2024-04-05 09:00:00 | NVDA | Stock | 86.6662 | 87.671 | 85.926 | 87.41 | 59607790.0 |
| 2024-04-05 10:00:00 | NVDA | Stock | 87.419 | 87.755 | 86.616 | 87.74 | 47438150.0 |
| 2024-04-05 11:00:00 | NVDA | Stock | 87.759 | 88.294 | 87.23 | 88.214 | 41135300.0 |
| 2024-04-05 12:00:00 | NVDA | Stock | 88.224 | 88.481 | 87.935 | 88.326 | 32566510.0 |
| 2024-04-05 13:00:00 | NVDA | Stock | 88.34 | 88.415 | 87.574 | 87.605 | 24759220.0 |
| 2024-04-05 14:00:00 | NVDA | Stock | 87.6 | 88.138 | 87.311 | 87.6315 | 28607080.0 |
| 2024-04-05 15:00:00 | NVDA | Stock | 87.64 | 88.197 | 87.554 | 87.98 | 33871190.0 |
| 2024-04-05 16:00:00 | NVDA | Stock | 87.977 | 88.049 | 87.866 | 88.015 | 14949340.0 |
| 2024-04-05 17:00:00 | NVDA | Stock | 88.0148 | 88.0148 | 87.9 | 87.9 | 296170.0 |
| 2024-04-05 18:00:00 | NVDA | Stock | 87.921 | 88.069 | 87.921 | 88.06 | 247070.0 |
| 2024-04-05 19:00:00 | NVDA | Stock | 88.0678 | 88.068 | 88.008 | 88.049 | 277990.0 |
| 2024-04-05 04:00:00 | AMZN | Stock | 181.06 | 181.37 | 181.03 | 181.1 | 4069.0 |
| 2024-04-05 05:00:00 | AMZN | Stock | 181.2 | 181.35 | 181.11 | 181.35 | 2529.0 |
> showing 50 of 58,342 rows — these rows as CSV