PREVIEW / stock_1hour / 2024-03-25
file: by_date/stock_1hour/2024/2024-03-25.parquet size: 1.4 MB rows: 59,773 symbols: 1,058
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-25 04:00:00 | AAPL | Stock | 172.2 | 172.2 | 172.0 | 172.18 | 4220.0 |
| 2024-03-25 05:00:00 | AAPL | Stock | 172.17 | 172.17 | 171.68 | 171.71 | 16311.0 |
| 2024-03-25 06:00:00 | AAPL | Stock | 171.7 | 171.85 | 171.3 | 171.3 | 11870.0 |
| 2024-03-25 07:00:00 | AAPL | Stock | 171.39 | 171.41 | 171.07 | 171.19 | 60111.0 |
| 2024-03-25 08:00:00 | AAPL | Stock | 171.4 | 172.27 | 170.9 | 171.0 | 158484.0 |
| 2024-03-25 09:00:00 | AAPL | Stock | 171.02 | 171.1 | 169.45 | 170.18 | 7829604.0 |
| 2024-03-25 10:00:00 | AAPL | Stock | 170.18 | 170.61 | 169.77 | 170.55 | 6300680.0 |
| 2024-03-25 11:00:00 | AAPL | Stock | 170.54 | 170.765 | 170.09 | 170.62 | 4095911.0 |
| 2024-03-25 12:00:00 | AAPL | Stock | 170.62 | 171.15 | 170.38 | 170.99 | 3721660.0 |
| 2024-03-25 13:00:00 | AAPL | Stock | 171.0 | 171.52 | 170.985 | 171.468 | 3706680.0 |
| 2024-03-25 14:00:00 | AAPL | Stock | 171.465 | 171.61 | 171.235 | 171.448 | 3168636.0 |
| 2024-03-25 15:00:00 | AAPL | Stock | 171.45 | 171.94 | 170.79 | 170.85 | 7478150.0 |
| 2024-03-25 16:00:00 | AAPL | Stock | 170.86 | 171.1496 | 170.75 | 170.85 | 8192328.0 |
| 2024-03-25 17:00:00 | AAPL | Stock | 170.9078 | 170.93 | 170.05 | 170.88 | 23858.0 |
| 2024-03-25 18:00:00 | AAPL | Stock | 170.8301 | 170.9999 | 170.83 | 170.93 | 25017.0 |
| 2024-03-25 19:00:00 | AAPL | Stock | 170.9 | 170.98 | 170.83 | 170.92 | 13469.0 |
| 2024-03-25 04:00:00 | MSFT | Stock | 427.61 | 427.61 | 425.27 | 426.6 | 3641.0 |
| 2024-03-25 05:00:00 | MSFT | Stock | 426.66 | 426.9 | 426.36 | 426.61 | 2774.0 |
| 2024-03-25 06:00:00 | MSFT | Stock | 426.48 | 426.48 | 425.0 | 425.86 | 5281.0 |
| 2024-03-25 07:00:00 | MSFT | Stock | 426.1 | 426.1 | 425.09 | 425.51 | 7876.0 |
| 2024-03-25 08:00:00 | MSFT | Stock | 426.07 | 428.74 | 425.14 | 426.19 | 29705.0 |
| 2024-03-25 09:00:00 | MSFT | Stock | 426.3 | 427.41 | 421.61 | 423.2815 | 2002637.0 |
| 2024-03-25 10:00:00 | MSFT | Stock | 423.25 | 425.32 | 422.44 | 425.05 | 1388157.0 |
| 2024-03-25 11:00:00 | MSFT | Stock | 425.05 | 425.17 | 424.11 | 424.555 | 798835.0 |
| 2024-03-25 12:00:00 | MSFT | Stock | 424.56 | 425.22 | 424.13 | 424.36 | 590565.0 |
| 2024-03-25 13:00:00 | MSFT | Stock | 424.36 | 424.64 | 423.1207 | 423.34 | 860297.0 |
| 2024-03-25 14:00:00 | MSFT | Stock | 423.33 | 424.4 | 423.09 | 424.285 | 644365.0 |
| 2024-03-25 15:00:00 | MSFT | Stock | 424.3 | 424.3 | 422.32 | 422.89 | 1634241.0 |
| 2024-03-25 16:00:00 | MSFT | Stock | 422.86 | 422.94 | 422.5 | 422.86 | 3437064.0 |
| 2024-03-25 17:00:00 | MSFT | Stock | 422.92 | 425.13 | 422.86 | 423.62 | 5924.0 |
| 2024-03-25 18:00:00 | MSFT | Stock | 423.6014 | 423.77 | 422.86 | 423.3988 | 7821.0 |
| 2024-03-25 19:00:00 | MSFT | Stock | 423.7 | 423.7 | 423.16 | 423.6099 | 5254.0 |
| 2024-03-25 04:00:00 | NVDA | Stock | 94.65 | 95.435 | 94.266 | 95.38 | 710550.0 |
| 2024-03-25 05:00:00 | NVDA | Stock | 95.4 | 95.42 | 94.925 | 95.1 | 308250.0 |
| 2024-03-25 06:00:00 | NVDA | Stock | 95.076 | 95.1 | 94.431 | 94.5 | 393890.0 |
| 2024-03-25 07:00:00 | NVDA | Stock | 94.545 | 94.567 | 93.1 | 93.808 | 2863430.0 |
| 2024-03-25 08:00:00 | NVDA | Stock | 94.404 | 94.65 | 93.126 | 94.112 | 4007470.0 |
| 2024-03-25 09:00:00 | NVDA | Stock | 94.136 | 95.84 | 93.51 | 95.547 | 71035190.0 |
| 2024-03-25 10:00:00 | NVDA | Stock | 95.5465 | 96.766 | 95.371 | 95.914 | 76466030.0 |
| 2024-03-25 11:00:00 | NVDA | Stock | 95.914 | 96.448 | 95.14 | 95.228 | 47409990.0 |
| 2024-03-25 12:00:00 | NVDA | Stock | 95.235 | 95.548 | 94.664 | 95.372 | 46835620.0 |
| 2024-03-25 13:00:00 | NVDA | Stock | 95.393 | 96.064 | 94.99 | 96.043 | 35375070.0 |
| 2024-03-25 14:00:00 | NVDA | Stock | 96.051 | 96.28 | 95.7745 | 96.2 | 36367540.0 |
| 2024-03-25 15:00:00 | NVDA | Stock | 96.2116 | 96.242 | 94.98 | 95.0 | 53060400.0 |
| 2024-03-25 16:00:00 | NVDA | Stock | 95.002 | 95.15 | 94.8 | 95.02 | 17265690.0 |
| 2024-03-25 17:00:00 | NVDA | Stock | 95.025 | 95.5043 | 94.996 | 95.141 | 557910.0 |
| 2024-03-25 18:00:00 | NVDA | Stock | 95.125 | 95.199 | 95.0758 | 95.145 | 432210.0 |
| 2024-03-25 19:00:00 | NVDA | Stock | 95.149 | 95.434 | 95.087 | 95.379 | 788700.0 |
| 2024-03-25 04:00:00 | AMZN | Stock | 179.0 | 179.01 | 178.74 | 179.0 | 3210.0 |
| 2024-03-25 05:00:00 | AMZN | Stock | 178.81 | 178.81 | 178.25 | 178.44 | 5790.0 |
> showing 50 of 59,773 rows — these rows as CSV