PREVIEW / stock_1hour / 2024-05-14
file: by_date/stock_1hour/2024/2024-05-14.parquet size: 1.4 MB rows: 59,918 symbols: 972
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-05-14 04:00:00 | AAPL | Stock | 186.5 | 187.0 | 186.46 | 187.0 | 19828.0 |
| 2024-05-14 05:00:00 | AAPL | Stock | 187.0 | 187.12 | 186.8 | 187.02 | 30594.0 |
| 2024-05-14 06:00:00 | AAPL | Stock | 187.0 | 187.1 | 187.0 | 187.04 | 28979.0 |
| 2024-05-14 07:00:00 | AAPL | Stock | 187.01 | 187.01 | 186.4 | 186.5 | 31825.0 |
| 2024-05-14 08:00:00 | AAPL | Stock | 186.9 | 187.5 | 185.4 | 186.32 | 252617.0 |
| 2024-05-14 09:00:00 | AAPL | Stock | 186.34 | 188.3 | 186.07 | 187.01 | 6867398.0 |
| 2024-05-14 10:00:00 | AAPL | Stock | 187.02 | 187.1487 | 186.29 | 186.99 | 5212641.0 |
| 2024-05-14 11:00:00 | AAPL | Stock | 187.0 | 187.21 | 186.51 | 186.91 | 3392448.0 |
| 2024-05-14 12:00:00 | AAPL | Stock | 186.92 | 186.955 | 186.6 | 186.779 | 2288765.0 |
| 2024-05-14 13:00:00 | AAPL | Stock | 186.78 | 187.05 | 186.451 | 186.94 | 2678140.0 |
| 2024-05-14 14:00:00 | AAPL | Stock | 186.935 | 187.65 | 186.885 | 187.53 | 3046544.0 |
| 2024-05-14 15:00:00 | AAPL | Stock | 187.5208 | 187.91 | 187.16 | 187.39 | 6369180.0 |
| 2024-05-14 16:00:00 | AAPL | Stock | 187.32 | 187.56 | 187.32 | 187.55 | 6656828.0 |
| 2024-05-14 17:00:00 | AAPL | Stock | 187.55 | 187.57 | 187.44 | 187.55 | 12274.0 |
| 2024-05-14 18:00:00 | AAPL | Stock | 187.58 | 187.76 | 187.43 | 187.62 | 45455.0 |
| 2024-05-14 19:00:00 | AAPL | Stock | 187.6 | 187.8 | 187.45 | 187.45 | 21983.0 |
| 2024-05-14 04:00:00 | MSFT | Stock | 414.1 | 415.06 | 413.83 | 415.0 | 2033.0 |
| 2024-05-14 05:00:00 | MSFT | Stock | 414.51 | 414.51 | 414.25 | 414.25 | 579.0 |
| 2024-05-14 06:00:00 | MSFT | Stock | 414.16 | 414.35 | 414.0 | 414.0 | 3002.0 |
| 2024-05-14 07:00:00 | MSFT | Stock | 414.01 | 414.1 | 413.12 | 413.12 | 6104.0 |
| 2024-05-14 08:00:00 | MSFT | Stock | 413.3597 | 414.32 | 411.35 | 411.96 | 31082.0 |
| 2024-05-14 09:00:00 | MSFT | Stock | 411.85 | 413.89 | 411.2827 | 412.1 | 1117861.0 |
| 2024-05-14 10:00:00 | MSFT | Stock | 412.14 | 415.56 | 411.92 | 414.62 | 1368299.0 |
| 2024-05-14 11:00:00 | MSFT | Stock | 414.67 | 415.23 | 412.905 | 413.005 | 606848.0 |
| 2024-05-14 12:00:00 | MSFT | Stock | 412.965 | 413.32 | 411.9303 | 412.74 | 582449.0 |
| 2024-05-14 13:00:00 | MSFT | Stock | 412.76 | 414.2 | 412.5922 | 414.135 | 494077.0 |
| 2024-05-14 14:00:00 | MSFT | Stock | 414.145 | 416.74 | 414.06 | 416.6182 | 785175.0 |
| 2024-05-14 15:00:00 | MSFT | Stock | 416.645 | 417.49 | 416.19 | 416.42 | 1371436.0 |
| 2024-05-14 16:00:00 | MSFT | Stock | 416.56 | 416.6205 | 416.0564 | 416.22 | 2732616.0 |
| 2024-05-14 17:00:00 | MSFT | Stock | 416.22 | 416.56 | 416.0004 | 416.56 | 5579.0 |
| 2024-05-14 18:00:00 | MSFT | Stock | 416.14 | 416.56 | 416.05 | 416.25 | 4737.0 |
| 2024-05-14 19:00:00 | MSFT | Stock | 416.3 | 416.7 | 413.75 | 416.7 | 42596.0 |
| 2024-05-14 04:00:00 | NVDA | Stock | 90.2 | 90.318 | 90.107 | 90.3 | 44540.0 |
| 2024-05-14 05:00:00 | NVDA | Stock | 90.272 | 90.281 | 90.004 | 90.1 | 31300.0 |
| 2024-05-14 06:00:00 | NVDA | Stock | 90.138 | 90.199 | 89.774 | 89.935 | 266720.0 |
| 2024-05-14 07:00:00 | NVDA | Stock | 90.0 | 90.133 | 89.9 | 89.984 | 316920.0 |
| 2024-05-14 08:00:00 | NVDA | Stock | 90.022 | 90.4 | 89.41 | 89.76 | 2094320.0 |
| 2024-05-14 09:00:00 | NVDA | Stock | 89.795 | 90.257 | 88.934 | 89.762 | 35602130.0 |
| 2024-05-14 10:00:00 | NVDA | Stock | 89.7375 | 90.949 | 89.445 | 90.5 | 47952900.0 |
| 2024-05-14 11:00:00 | NVDA | Stock | 90.4855 | 91.273 | 90.42 | 90.902 | 29846430.0 |
| 2024-05-14 12:00:00 | NVDA | Stock | 90.9017 | 90.944 | 90.509 | 90.795 | 16799730.0 |
| 2024-05-14 13:00:00 | NVDA | Stock | 90.823 | 90.922 | 90.611 | 90.8268 | 12978950.0 |
| 2024-05-14 14:00:00 | NVDA | Stock | 90.815 | 91.651 | 90.815 | 91.5662 | 32496580.0 |
| 2024-05-14 15:00:00 | NVDA | Stock | 91.5565 | 91.634 | 91.276 | 91.375 | 28020210.0 |
| 2024-05-14 16:00:00 | NVDA | Stock | 91.356 | 91.375 | 91.013 | 91.1 | 11830330.0 |
| 2024-05-14 17:00:00 | NVDA | Stock | 91.115 | 91.2399 | 91.115 | 91.199 | 149830.0 |
| 2024-05-14 18:00:00 | NVDA | Stock | 91.19 | 91.356 | 91.18 | 91.285 | 148780.0 |
| 2024-05-14 19:00:00 | NVDA | Stock | 91.286 | 91.3 | 91.238 | 91.293 | 295060.0 |
| 2024-05-14 04:00:00 | AMZN | Stock | 186.74 | 186.82 | 186.58 | 186.58 | 5869.0 |
| 2024-05-14 05:00:00 | AMZN | Stock | 186.58 | 186.58 | 185.8 | 185.8 | 9307.0 |
> showing 50 of 59,918 rows — these rows as CSV