PREVIEW / stock_1hour / 2024-08-06
file: by_date/stock_1hour/2024/2024-08-06.parquet size: 1.3 MB rows: 60,216 symbols: 878
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-08-06 04:00:00 | AAPL | Stock | 211.84 | 212.84 | 210.01 | 210.33 | 65398.0 |
| 2024-08-06 05:00:00 | AAPL | Stock | 210.32 | 210.32 | 208.23 | 209.21 | 39259.0 |
| 2024-08-06 06:00:00 | AAPL | Stock | 209.02 | 209.02 | 207.85 | 208.5 | 65345.0 |
| 2024-08-06 07:00:00 | AAPL | Stock | 208.45 | 209.25 | 207.2 | 207.74 | 126031.0 |
| 2024-08-06 08:00:00 | AAPL | Stock | 208.9 | 214.8 | 205.3 | 205.8907 | 409424.0 |
| 2024-08-06 09:00:00 | AAPL | Stock | 206.0 | 206.9 | 201.07 | 203.19 | 10835034.0 |
| 2024-08-06 10:00:00 | AAPL | Stock | 203.19 | 207.68 | 202.43 | 207.546 | 8401900.0 |
| 2024-08-06 11:00:00 | AAPL | Stock | 207.52 | 208.5596 | 206.03 | 208.45 | 5284329.0 |
| 2024-08-06 12:00:00 | AAPL | Stock | 208.46 | 209.99 | 208.27 | 209.7 | 3949000.0 |
| 2024-08-06 13:00:00 | AAPL | Stock | 209.69 | 209.72 | 208.33 | 208.51 | 3119819.0 |
| 2024-08-06 14:00:00 | AAPL | Stock | 208.51 | 209.95 | 207.705 | 208.78 | 3744628.0 |
| 2024-08-06 15:00:00 | AAPL | Stock | 208.74 | 208.83 | 206.4 | 207.125 | 7101677.0 |
| 2024-08-06 16:00:00 | AAPL | Stock | 207.23 | 207.24 | 205.5 | 205.5 | 6642088.0 |
| 2024-08-06 17:00:00 | AAPL | Stock | 205.5 | 207.23 | 204.7195 | 204.93 | 140982.0 |
| 2024-08-06 18:00:00 | AAPL | Stock | 205.0 | 206.82 | 204.9 | 205.83 | 58643.0 |
| 2024-08-06 19:00:00 | AAPL | Stock | 206.16 | 206.4997 | 205.0 | 205.01 | 38714.0 |
| 2024-08-06 04:00:00 | MSFT | Stock | 402.03 | 402.03 | 399.4 | 400.5 | 16888.0 |
| 2024-08-06 05:00:00 | MSFT | Stock | 399.5 | 399.5 | 396.35 | 398.06 | 9722.0 |
| 2024-08-06 06:00:00 | MSFT | Stock | 397.98 | 400.42 | 397.78 | 400.42 | 4991.0 |
| 2024-08-06 07:00:00 | MSFT | Stock | 400.62 | 401.15 | 399.12 | 400.25 | 38506.0 |
| 2024-08-06 08:00:00 | MSFT | Stock | 400.5 | 403.3 | 396.137 | 398.9 | 69702.0 |
| 2024-08-06 09:00:00 | MSFT | Stock | 398.71 | 402.705 | 397.5 | 400.48 | 2558596.0 |
| 2024-08-06 10:00:00 | MSFT | Stock | 400.48 | 404.68 | 399.67 | 403.92 | 2101859.0 |
| 2024-08-06 11:00:00 | MSFT | Stock | 403.95 | 404.98 | 401.11 | 404.743 | 1280126.0 |
| 2024-08-06 12:00:00 | MSFT | Stock | 404.76 | 405.67 | 403.22 | 404.83 | 984021.0 |
| 2024-08-06 13:00:00 | MSFT | Stock | 404.82 | 405.24 | 403.18 | 403.65 | 796679.0 |
| 2024-08-06 14:00:00 | MSFT | Stock | 403.66 | 404.8 | 402.48 | 402.495 | 859831.0 |
| 2024-08-06 15:00:00 | MSFT | Stock | 402.5 | 402.85 | 399.23 | 399.43 | 2259314.0 |
| 2024-08-06 16:00:00 | MSFT | Stock | 399.42 | 399.99 | 397.45 | 397.81 | 4430701.0 |
| 2024-08-06 17:00:00 | MSFT | Stock | 397.59 | 399.61 | 396.03 | 396.1692 | 47046.0 |
| 2024-08-06 18:00:00 | MSFT | Stock | 397.17 | 399.4 | 396.6 | 397.76 | 13145.0 |
| 2024-08-06 19:00:00 | MSFT | Stock | 398.05 | 398.79 | 397.06 | 397.3001 | 10921.0 |
| 2024-08-06 04:00:00 | NVDA | Stock | 104.5 | 105.9 | 102.16 | 103.26 | 1696106.0 |
| 2024-08-06 05:00:00 | NVDA | Stock | 103.24 | 103.26 | 100.12 | 101.5 | 1205489.0 |
| 2024-08-06 06:00:00 | NVDA | Stock | 101.48 | 102.98 | 101.17 | 102.69 | 670551.0 |
| 2024-08-06 07:00:00 | NVDA | Stock | 102.72 | 104.47 | 102.6 | 103.41 | 2288871.0 |
| 2024-08-06 08:00:00 | NVDA | Stock | 103.04 | 107.0 | 100.4448 | 102.35 | 4107407.0 |
| 2024-08-06 09:00:00 | NVDA | Stock | 102.36 | 104.85 | 100.55 | 103.44 | 56866621.0 |
| 2024-08-06 10:00:00 | NVDA | Stock | 103.45 | 106.355 | 102.94 | 105.28 | 61202802.0 |
| 2024-08-06 11:00:00 | NVDA | Stock | 105.29 | 105.63 | 103.87 | 105.2816 | 37674273.0 |
| 2024-08-06 12:00:00 | NVDA | Stock | 105.29 | 107.44 | 105.0 | 107.145 | 35999751.0 |
| 2024-08-06 13:00:00 | NVDA | Stock | 107.145 | 107.405 | 106.13 | 106.7499 | 30336642.0 |
| 2024-08-06 14:00:00 | NVDA | Stock | 106.745 | 107.71 | 106.51 | 106.76 | 28496052.0 |
| 2024-08-06 15:00:00 | NVDA | Stock | 106.758 | 106.8 | 104.0 | 104.01 | 50326996.0 |
| 2024-08-06 16:00:00 | NVDA | Stock | 103.99 | 109.25 | 103.0 | 104.2 | 37033468.0 |
| 2024-08-06 17:00:00 | NVDA | Stock | 104.19 | 105.25 | 101.65 | 102.2 | 6051505.0 |
| 2024-08-06 18:00:00 | NVDA | Stock | 102.32 | 103.25 | 101.71 | 102.32 | 2005933.0 |
| 2024-08-06 19:00:00 | NVDA | Stock | 102.35 | 102.67 | 101.5 | 101.55 | 1386100.0 |
| 2024-08-06 04:00:00 | AMZN | Stock | 164.0 | 164.5 | 161.71 | 162.2 | 51858.0 |
| 2024-08-06 05:00:00 | AMZN | Stock | 162.0 | 162.0 | 160.05 | 161.05 | 31518.0 |
> showing 50 of 60,216 rows — these rows as CSV