PREVIEW / stock_1hour / 2024-08-29
file: by_date/stock_1hour/2024/2024-08-29.parquet size: 1.3 MB rows: 57,929 symbols: 819
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-29 04:00:00 | AAPL | Stock | 226.89 | 228.8 | 226.89 | 228.77 | 32216.0 |
| 2024-08-29 05:00:00 | AAPL | Stock | 228.73 | 229.38 | 228.63 | 229.21 | 46916.0 |
| 2024-08-29 06:00:00 | AAPL | Stock | 229.33 | 229.74 | 228.9 | 229.25 | 32858.0 |
| 2024-08-29 07:00:00 | AAPL | Stock | 229.25 | 230.39 | 229.16 | 229.98 | 184850.0 |
| 2024-08-29 08:00:00 | AAPL | Stock | 229.4 | 230.6 | 226.49 | 226.49 | 426670.0 |
| 2024-08-29 09:00:00 | AAPL | Stock | 230.37 | 231.66 | 228.88 | 231.57 | 8368254.0 |
| 2024-08-29 10:00:00 | AAPL | Stock | 231.58 | 232.7249 | 230.31 | 232.37 | 6487915.0 |
| 2024-08-29 11:00:00 | AAPL | Stock | 232.34 | 232.92 | 231.49 | 231.6799 | 3873833.0 |
| 2024-08-29 12:00:00 | AAPL | Stock | 231.67 | 232.71 | 231.6 | 232.54 | 2765948.0 |
| 2024-08-29 13:00:00 | AAPL | Stock | 232.53 | 232.58 | 231.34 | 231.74 | 2956623.0 |
| 2024-08-29 14:00:00 | AAPL | Stock | 231.75 | 231.75 | 229.85 | 230.45 | 3788558.0 |
| 2024-08-29 15:00:00 | AAPL | Stock | 230.43 | 230.78 | 229.33 | 229.83 | 5286058.0 |
| 2024-08-29 16:00:00 | AAPL | Stock | 229.79 | 230.25 | 229.3 | 230.25 | 5439720.0 |
| 2024-08-29 17:00:00 | AAPL | Stock | 230.24 | 230.3399 | 229.79 | 230.33 | 225106.0 |
| 2024-08-29 18:00:00 | AAPL | Stock | 230.33 | 230.33 | 229.88 | 230.1 | 43778.0 |
| 2024-08-29 19:00:00 | AAPL | Stock | 230.0203 | 230.3 | 230.0 | 230.29 | 18923.0 |
| 2024-08-29 04:00:00 | MSFT | Stock | 411.73 | 412.81 | 410.12 | 412.56 | 12396.0 |
| 2024-08-29 05:00:00 | MSFT | Stock | 412.56 | 413.4 | 412.56 | 413.31 | 4953.0 |
| 2024-08-29 06:00:00 | MSFT | Stock | 413.12 | 413.21 | 412.45 | 412.66 | 2363.0 |
| 2024-08-29 07:00:00 | MSFT | Stock | 412.45 | 413.45 | 412.45 | 413.0 | 8727.0 |
| 2024-08-29 08:00:00 | MSFT | Stock | 412.46 | 414.114 | 410.42 | 413.4159 | 36860.0 |
| 2024-08-29 09:00:00 | MSFT | Stock | 413.1 | 421.75 | 411.99 | 421.01 | 1899667.0 |
| 2024-08-29 10:00:00 | MSFT | Stock | 421.01 | 422.05 | 410.6 | 420.14 | 1697998.0 |
| 2024-08-29 11:00:00 | MSFT | Stock | 420.175 | 420.43 | 418.57 | 419.1579 | 855490.0 |
| 2024-08-29 12:00:00 | MSFT | Stock | 419.12 | 420.35 | 418.96 | 419.495 | 517707.0 |
| 2024-08-29 13:00:00 | MSFT | Stock | 419.475 | 419.475 | 417.25 | 417.965 | 519077.0 |
| 2024-08-29 14:00:00 | MSFT | Stock | 417.93 | 417.93 | 412.69 | 413.41 | 907877.0 |
| 2024-08-29 15:00:00 | MSFT | Stock | 413.43 | 414.68 | 411.93 | 413.18 | 1825932.0 |
| 2024-08-29 16:00:00 | MSFT | Stock | 413.15 | 414.49 | 412.74 | 413.85 | 2599467.0 |
| 2024-08-29 17:00:00 | MSFT | Stock | 413.99 | 414.69 | 413.12 | 414.4335 | 177123.0 |
| 2024-08-29 18:00:00 | MSFT | Stock | 414.01 | 414.29 | 413.0016 | 414.0875 | 10932.0 |
| 2024-08-29 19:00:00 | MSFT | Stock | 413.6633 | 413.9675 | 413.6 | 413.8 | 1881.0 |
| 2024-08-29 04:00:00 | NVDA | Stock | 120.0 | 121.0 | 118.9 | 120.28 | 2419160.0 |
| 2024-08-29 05:00:00 | NVDA | Stock | 120.27 | 124.15 | 119.97 | 123.31 | 2686050.0 |
| 2024-08-29 06:00:00 | NVDA | Stock | 123.34 | 123.74 | 121.67 | 121.72 | 2096645.0 |
| 2024-08-29 07:00:00 | NVDA | Stock | 121.68 | 122.2 | 120.0 | 121.29 | 4179908.0 |
| 2024-08-29 08:00:00 | NVDA | Stock | 121.28 | 123.7157 | 118.0 | 121.2525 | 8029120.0 |
| 2024-08-29 09:00:00 | NVDA | Stock | 121.26 | 124.43 | 119.67 | 123.13 | 71778293.0 |
| 2024-08-29 10:00:00 | NVDA | Stock | 123.125 | 123.68 | 119.23 | 122.205 | 74031576.0 |
| 2024-08-29 11:00:00 | NVDA | Stock | 122.2 | 122.54 | 120.73 | 121.115 | 36160450.0 |
| 2024-08-29 12:00:00 | NVDA | Stock | 121.11 | 121.84 | 120.28 | 120.6356 | 25562180.0 |
| 2024-08-29 13:00:00 | NVDA | Stock | 120.64 | 121.16 | 120.23 | 120.99 | 21397995.0 |
| 2024-08-29 14:00:00 | NVDA | Stock | 121.0 | 121.0 | 116.71 | 117.77 | 55700331.0 |
| 2024-08-29 15:00:00 | NVDA | Stock | 117.76 | 119.08 | 117.31 | 117.63 | 53017613.0 |
| 2024-08-29 16:00:00 | NVDA | Stock | 117.59 | 118.35 | 117.43 | 118.1713 | 27663801.0 |
| 2024-08-29 17:00:00 | NVDA | Stock | 118.17 | 118.33 | 117.59 | 118.11 | 1025990.0 |
| 2024-08-29 18:00:00 | NVDA | Stock | 118.13 | 118.23 | 118.0 | 118.21 | 614957.0 |
| 2024-08-29 19:00:00 | NVDA | Stock | 118.2 | 118.5 | 118.16 | 118.49 | 642543.0 |
| 2024-08-29 04:00:00 | AMZN | Stock | 170.86 | 171.99 | 170.45 | 171.8 | 18696.0 |
| 2024-08-29 05:00:00 | AMZN | Stock | 171.73 | 172.63 | 171.73 | 172.45 | 9370.0 |
> showing 50 of 57,929 rows — these rows as CSV