PREVIEW / stock_1hour / 2024-03-26
file: by_date/stock_1hour/2024/2024-03-26.parquet size: 1.3 MB rows: 59,639 symbols: 1,070
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-26 04:00:00 | AAPL | Stock | 171.05 | 171.45 | 171.01 | 171.34 | 10845.0 |
| 2024-03-26 05:00:00 | AAPL | Stock | 171.33 | 171.5 | 171.32 | 171.39 | 7697.0 |
| 2024-03-26 06:00:00 | AAPL | Stock | 171.4 | 171.75 | 171.4 | 171.73 | 12379.0 |
| 2024-03-26 07:00:00 | AAPL | Stock | 171.65 | 171.68 | 171.3 | 171.45 | 21111.0 |
| 2024-03-26 08:00:00 | AAPL | Stock | 171.66 | 171.7353 | 169.11 | 170.62 | 680620.0 |
| 2024-03-26 09:00:00 | AAPL | Stock | 170.56 | 170.8399 | 169.65 | 170.74 | 6232733.0 |
| 2024-03-26 10:00:00 | AAPL | Stock | 170.74 | 171.0699 | 170.36 | 170.645 | 5907433.0 |
| 2024-03-26 11:00:00 | AAPL | Stock | 170.65 | 170.87 | 170.44 | 170.5701 | 3217295.0 |
| 2024-03-26 12:00:00 | AAPL | Stock | 170.575 | 171.25 | 170.55 | 171.05 | 4307341.0 |
| 2024-03-26 13:00:00 | AAPL | Stock | 171.05 | 171.42 | 170.28 | 170.295 | 4164759.0 |
| 2024-03-26 14:00:00 | AAPL | Stock | 170.29 | 170.5799 | 170.16 | 170.55 | 3132873.0 |
| 2024-03-26 15:00:00 | AAPL | Stock | 170.55 | 170.685 | 169.58 | 169.815 | 9506538.0 |
| 2024-03-26 16:00:00 | AAPL | Stock | 169.82 | 170.1 | 169.71 | 169.92 | 10255906.0 |
| 2024-03-26 17:00:00 | AAPL | Stock | 169.91 | 170.0 | 169.64 | 169.88 | 84204.0 |
| 2024-03-26 18:00:00 | AAPL | Stock | 169.87 | 169.9 | 169.8 | 169.89 | 33806.0 |
| 2024-03-26 19:00:00 | AAPL | Stock | 169.89 | 169.98 | 169.81 | 169.98 | 20783.0 |
| 2024-03-26 04:00:00 | MSFT | Stock | 424.59 | 425.24 | 424.59 | 425.07 | 1045.0 |
| 2024-03-26 05:00:00 | MSFT | Stock | 425.4 | 426.32 | 425.4 | 426.0 | 4463.0 |
| 2024-03-26 06:00:00 | MSFT | Stock | 426.0 | 426.09 | 425.02 | 425.39 | 5148.0 |
| 2024-03-26 07:00:00 | MSFT | Stock | 425.45 | 425.49 | 424.73 | 424.8 | 5308.0 |
| 2024-03-26 08:00:00 | MSFT | Stock | 425.4 | 425.5 | 422.86 | 424.5 | 29788.0 |
| 2024-03-26 09:00:00 | MSFT | Stock | 424.65 | 425.99 | 422.9 | 423.6115 | 1123398.0 |
| 2024-03-26 10:00:00 | MSFT | Stock | 423.62 | 424.9 | 423.615 | 424.29 | 1326690.0 |
| 2024-03-26 11:00:00 | MSFT | Stock | 424.31 | 424.86 | 423.68 | 424.805 | 746309.0 |
| 2024-03-26 12:00:00 | MSFT | Stock | 424.79 | 425.065 | 422.46 | 422.71 | 954707.0 |
| 2024-03-26 13:00:00 | MSFT | Stock | 422.7 | 423.04 | 422.2 | 422.7763 | 731345.0 |
| 2024-03-26 14:00:00 | MSFT | Stock | 422.78 | 423.23 | 422.46 | 423.1864 | 627520.0 |
| 2024-03-26 15:00:00 | MSFT | Stock | 423.21 | 423.7 | 421.35 | 421.88 | 2005717.0 |
| 2024-03-26 16:00:00 | MSFT | Stock | 421.95 | 422.36 | 420.81 | 421.83 | 4160260.0 |
| 2024-03-26 17:00:00 | MSFT | Stock | 421.77 | 421.77 | 421.13 | 421.51 | 5592.0 |
| 2024-03-26 18:00:00 | MSFT | Stock | 421.95 | 422.6 | 421.6219 | 421.75 | 9820.0 |
| 2024-03-26 19:00:00 | MSFT | Stock | 422.0 | 422.4 | 421.66 | 422.4 | 16398.0 |
| 2024-03-26 04:00:00 | NVDA | Stock | 95.447 | 95.867 | 95.445 | 95.766 | 170490.0 |
| 2024-03-26 05:00:00 | NVDA | Stock | 95.799 | 95.85 | 95.75 | 95.8 | 79830.0 |
| 2024-03-26 06:00:00 | NVDA | Stock | 95.8 | 95.857 | 95.68 | 95.753 | 76850.0 |
| 2024-03-26 07:00:00 | NVDA | Stock | 95.782 | 96.21 | 95.75 | 95.982 | 1427170.0 |
| 2024-03-26 08:00:00 | NVDA | Stock | 96.022 | 96.209 | 95.14 | 95.8359 | 2358860.0 |
| 2024-03-26 09:00:00 | NVDA | Stock | 95.86 | 96.375 | 95.007 | 95.581 | 55411280.0 |
| 2024-03-26 10:00:00 | NVDA | Stock | 95.591 | 95.747 | 94.045 | 94.647 | 75786690.0 |
| 2024-03-26 11:00:00 | NVDA | Stock | 94.648 | 95.039 | 94.25 | 94.4625 | 40073480.0 |
| 2024-03-26 12:00:00 | NVDA | Stock | 94.47 | 94.642 | 93.881 | 94.209 | 36904860.0 |
| 2024-03-26 13:00:00 | NVDA | Stock | 94.204 | 94.985 | 94.051 | 94.8606 | 31698510.0 |
| 2024-03-26 14:00:00 | NVDA | Stock | 94.854 | 95.256 | 94.683 | 94.793 | 33612350.0 |
| 2024-03-26 15:00:00 | NVDA | Stock | 94.7705 | 94.8422 | 92.502 | 92.573 | 67795820.0 |
| 2024-03-26 16:00:00 | NVDA | Stock | 92.561 | 93.186 | 92.36 | 92.935 | 25729130.0 |
| 2024-03-26 17:00:00 | NVDA | Stock | 92.935 | 92.94 | 92.561 | 92.705 | 776890.0 |
| 2024-03-26 18:00:00 | NVDA | Stock | 92.703 | 92.9 | 92.64 | 92.693 | 642630.0 |
| 2024-03-26 19:00:00 | NVDA | Stock | 92.712 | 92.75 | 92.588 | 92.65 | 655410.0 |
| 2024-03-26 04:00:00 | AMZN | Stock | 180.6 | 180.6 | 180.25 | 180.35 | 5912.0 |
| 2024-03-26 05:00:00 | AMZN | Stock | 180.25 | 180.36 | 180.21 | 180.31 | 4434.0 |
> showing 50 of 59,639 rows — these rows as CSV