PREVIEW / stock_1hour / 2024-10-02
file: by_date/stock_1hour/2024/2024-10-02.parquet size: 1.4 MB rows: 59,681 symbols: 749
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-10-02 04:00:00 | AAPL | Stock | 225.6 | 226.0 | 225.52 | 225.75 | 7376.0 |
| 2024-10-02 05:00:00 | AAPL | Stock | 225.65 | 225.65 | 224.75 | 224.8 | 12046.0 |
| 2024-10-02 06:00:00 | AAPL | Stock | 224.64 | 225.0 | 224.5 | 224.84 | 34672.0 |
| 2024-10-02 07:00:00 | AAPL | Stock | 224.82 | 225.0 | 224.52 | 224.75 | 31081.0 |
| 2024-10-02 08:00:00 | AAPL | Stock | 224.66 | 225.98 | 224.5 | 225.2 | 100161.0 |
| 2024-10-02 09:00:00 | AAPL | Stock | 225.2 | 226.12 | 223.21 | 223.38 | 4687236.0 |
| 2024-10-02 10:00:00 | AAPL | Stock | 223.375 | 226.39 | 223.02 | 226.08 | 4538335.0 |
| 2024-10-02 11:00:00 | AAPL | Stock | 226.085 | 227.05 | 225.91 | 226.84 | 3357491.0 |
| 2024-10-02 12:00:00 | AAPL | Stock | 226.85 | 227.03 | 226.62 | 226.635 | 1836858.0 |
| 2024-10-02 13:00:00 | AAPL | Stock | 226.63 | 227.14 | 226.34 | 227.116 | 1794652.0 |
| 2024-10-02 14:00:00 | AAPL | Stock | 227.11 | 227.18 | 226.46 | 226.9 | 1544366.0 |
| 2024-10-02 15:00:00 | AAPL | Stock | 226.9 | 227.37 | 226.68 | 226.81 | 3037454.0 |
| 2024-10-02 16:00:00 | AAPL | Stock | 226.79 | 227.38 | 226.66 | 227.2 | 4235343.0 |
| 2024-10-02 17:00:00 | AAPL | Stock | 227.299 | 227.3 | 226.78 | 227.0982 | 117587.0 |
| 2024-10-02 18:00:00 | AAPL | Stock | 227.06 | 227.15 | 227.0 | 227.0287 | 15648.0 |
| 2024-10-02 19:00:00 | AAPL | Stock | 227.0 | 227.07 | 226.78 | 226.9715 | 18590.0 |
| 2024-10-02 04:00:00 | MSFT | Stock | 420.0 | 420.5 | 420.0 | 420.33 | 3189.0 |
| 2024-10-02 05:00:00 | MSFT | Stock | 420.03 | 420.03 | 419.5 | 419.54 | 1147.0 |
| 2024-10-02 06:00:00 | MSFT | Stock | 419.28 | 420.0 | 419.27 | 419.59 | 5552.0 |
| 2024-10-02 07:00:00 | MSFT | Stock | 419.83 | 420.14 | 419.14 | 419.14 | 10060.0 |
| 2024-10-02 08:00:00 | MSFT | Stock | 419.9843 | 420.79 | 419.1 | 420.5332 | 25772.0 |
| 2024-10-02 09:00:00 | MSFT | Stock | 420.3 | 422.88 | 416.71 | 418.5192 | 1703671.0 |
| 2024-10-02 10:00:00 | MSFT | Stock | 418.5 | 419.22 | 417.57 | 418.04 | 1402029.0 |
| 2024-10-02 11:00:00 | MSFT | Stock | 418.07 | 419.335 | 417.68 | 418.495 | 874590.0 |
| 2024-10-02 12:00:00 | MSFT | Stock | 418.51 | 419.4 | 417.05 | 417.07 | 713533.0 |
| 2024-10-02 13:00:00 | MSFT | Stock | 417.08 | 418.6 | 417.01 | 418.27 | 623204.0 |
| 2024-10-02 14:00:00 | MSFT | Stock | 418.24 | 418.7299 | 417.2 | 418.25 | 684578.0 |
| 2024-10-02 15:00:00 | MSFT | Stock | 418.255 | 418.97 | 417.02 | 417.12 | 1585369.0 |
| 2024-10-02 16:00:00 | MSFT | Stock | 417.13 | 418.27 | 417.0 | 417.9 | 3086701.0 |
| 2024-10-02 17:00:00 | MSFT | Stock | 417.69 | 418.1 | 417.13 | 417.77 | 8375.0 |
| 2024-10-02 18:00:00 | MSFT | Stock | 417.75 | 418.08 | 417.75 | 418.076 | 3687.0 |
| 2024-10-02 19:00:00 | MSFT | Stock | 418.0 | 418.2 | 417.9 | 418.2 | 7082.0 |
| 2024-10-02 04:00:00 | NVDA | Stock | 116.5 | 116.73 | 115.88 | 116.06 | 402255.0 |
| 2024-10-02 05:00:00 | NVDA | Stock | 116.09 | 116.2 | 114.75 | 115.54 | 1186211.0 |
| 2024-10-02 06:00:00 | NVDA | Stock | 115.48 | 115.87 | 114.7 | 115.78 | 461354.0 |
| 2024-10-02 07:00:00 | NVDA | Stock | 115.8 | 116.91 | 115.65 | 116.31 | 940238.0 |
| 2024-10-02 08:00:00 | NVDA | Stock | 116.29 | 117.85 | 114.77 | 117.45 | 3144117.0 |
| 2024-10-02 09:00:00 | NVDA | Stock | 117.45 | 117.8 | 115.14 | 117.13 | 30086417.0 |
| 2024-10-02 10:00:00 | NVDA | Stock | 117.13 | 118.75 | 117.05 | 118.005 | 35767455.0 |
| 2024-10-02 11:00:00 | NVDA | Stock | 118.005 | 119.29 | 117.95 | 118.8801 | 25230009.0 |
| 2024-10-02 12:00:00 | NVDA | Stock | 118.89 | 119.13 | 117.93 | 117.955 | 15122170.0 |
| 2024-10-02 13:00:00 | NVDA | Stock | 117.96 | 118.5809 | 117.76 | 118.5699 | 16072411.0 |
| 2024-10-02 14:00:00 | NVDA | Stock | 118.5699 | 118.89 | 118.33 | 118.7707 | 13541669.0 |
| 2024-10-02 15:00:00 | NVDA | Stock | 118.775 | 119.38 | 118.6099 | 118.8399 | 23208702.0 |
| 2024-10-02 16:00:00 | NVDA | Stock | 118.83 | 120.8257 | 118.74 | 120.58 | 16338772.0 |
| 2024-10-02 17:00:00 | NVDA | Stock | 120.58 | 120.74 | 118.85 | 120.31 | 4026565.0 |
| 2024-10-02 18:00:00 | NVDA | Stock | 120.33 | 120.4 | 120.12 | 120.3 | 530638.0 |
| 2024-10-02 19:00:00 | NVDA | Stock | 120.3 | 120.66 | 120.12 | 120.6405 | 743471.0 |
| 2024-10-02 04:00:00 | AMZN | Stock | 184.65 | 185.0 | 184.57 | 184.72 | 7049.0 |
| 2024-10-02 05:00:00 | AMZN | Stock | 184.69 | 184.8 | 184.44 | 184.44 | 7201.0 |
> showing 50 of 59,681 rows — these rows as CSV