PREVIEW / stock_1hour / 2024-10-04
file: by_date/stock_1hour/2024/2024-10-04.parquet size: 1.3 MB rows: 59,089 symbols: 750
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-04 04:00:00 | AAPL | Stock | 226.08 | 226.5 | 225.79 | 225.86 | 18841.0 |
| 2024-10-04 05:00:00 | AAPL | Stock | 225.83 | 225.87 | 225.65 | 225.87 | 3702.0 |
| 2024-10-04 06:00:00 | AAPL | Stock | 225.95 | 226.24 | 225.95 | 226.18 | 8173.0 |
| 2024-10-04 07:00:00 | AAPL | Stock | 226.01 | 226.6 | 225.99 | 226.5 | 19533.0 |
| 2024-10-04 08:00:00 | AAPL | Stock | 226.0 | 227.9 | 225.106 | 227.85 | 163733.0 |
| 2024-10-04 09:00:00 | AAPL | Stock | 227.9 | 228.0 | 225.06 | 225.1899 | 3910928.0 |
| 2024-10-04 10:00:00 | AAPL | Stock | 225.18 | 225.63 | 224.13 | 225.1088 | 4042517.0 |
| 2024-10-04 11:00:00 | AAPL | Stock | 225.1 | 225.53 | 224.31 | 225.53 | 2129099.0 |
| 2024-10-04 12:00:00 | AAPL | Stock | 225.54 | 225.57 | 224.695 | 225.14 | 1711004.0 |
| 2024-10-04 13:00:00 | AAPL | Stock | 225.15 | 225.41 | 224.54 | 224.88 | 1494732.0 |
| 2024-10-04 14:00:00 | AAPL | Stock | 224.89 | 225.54 | 224.63 | 225.53 | 1841644.0 |
| 2024-10-04 15:00:00 | AAPL | Stock | 225.53 | 226.98 | 225.29 | 226.8 | 4944598.0 |
| 2024-10-04 16:00:00 | AAPL | Stock | 226.74 | 226.8 | 226.58 | 226.59 | 5570760.0 |
| 2024-10-04 17:00:00 | AAPL | Stock | 226.6 | 226.8 | 226.52 | 226.77 | 22123.0 |
| 2024-10-04 18:00:00 | AAPL | Stock | 226.74 | 226.74 | 226.5 | 226.56 | 17708.0 |
| 2024-10-04 19:00:00 | AAPL | Stock | 226.59 | 226.6135 | 226.37 | 226.3745 | 14691.0 |
| 2024-10-04 04:00:00 | MSFT | Stock | 418.06 | 418.11 | 417.08 | 417.08 | 1180.0 |
| 2024-10-04 05:00:00 | MSFT | Stock | 417.13 | 417.44 | 417.13 | 417.44 | 996.0 |
| 2024-10-04 06:00:00 | MSFT | Stock | 418.49 | 418.5 | 418.19 | 418.5 | 1392.0 |
| 2024-10-04 07:00:00 | MSFT | Stock | 418.2 | 418.4 | 417.7 | 417.9 | 6159.0 |
| 2024-10-04 08:00:00 | MSFT | Stock | 418.2011 | 420.5 | 416.82 | 420.1601 | 73202.0 |
| 2024-10-04 09:00:00 | MSFT | Stock | 420.144 | 420.35 | 416.05 | 416.22 | 1376360.0 |
| 2024-10-04 10:00:00 | MSFT | Stock | 416.195 | 417.67 | 414.97 | 417.486 | 1253045.0 |
| 2024-10-04 11:00:00 | MSFT | Stock | 417.49 | 418.17 | 415.8208 | 417.81 | 666981.0 |
| 2024-10-04 12:00:00 | MSFT | Stock | 417.85 | 418.99 | 416.76 | 418.42 | 627254.0 |
| 2024-10-04 13:00:00 | MSFT | Stock | 418.44 | 418.7132 | 416.8505 | 417.4626 | 475628.0 |
| 2024-10-04 14:00:00 | MSFT | Stock | 417.49 | 418.15 | 416.76 | 418.13 | 573526.0 |
| 2024-10-04 15:00:00 | MSFT | Stock | 418.12 | 418.16 | 416.0 | 416.02 | 1866045.0 |
| 2024-10-04 16:00:00 | MSFT | Stock | 416.06 | 416.31 | 414.9001 | 415.73 | 4597900.0 |
| 2024-10-04 17:00:00 | MSFT | Stock | 415.69 | 415.71 | 415.5026 | 415.65 | 6513.0 |
| 2024-10-04 18:00:00 | MSFT | Stock | 415.6 | 415.9467 | 415.6 | 415.8 | 3733.0 |
| 2024-10-04 19:00:00 | MSFT | Stock | 415.729 | 415.94 | 415.729 | 415.86 | 3893.0 |
| 2024-10-04 04:00:00 | NVDA | Stock | 123.07 | 123.5 | 122.52 | 122.98 | 330566.0 |
| 2024-10-04 05:00:00 | NVDA | Stock | 122.98 | 123.1 | 122.68 | 123.02 | 163109.0 |
| 2024-10-04 06:00:00 | NVDA | Stock | 123.05 | 123.29 | 122.87 | 122.99 | 196504.0 |
| 2024-10-04 07:00:00 | NVDA | Stock | 122.99 | 123.86 | 122.96 | 123.55 | 1023266.0 |
| 2024-10-04 08:00:00 | NVDA | Stock | 123.55 | 125.16 | 122.5348 | 125.0 | 6854208.0 |
| 2024-10-04 09:00:00 | NVDA | Stock | 125.0 | 125.08 | 122.59 | 122.97 | 37686862.0 |
| 2024-10-04 10:00:00 | NVDA | Stock | 122.97 | 123.7 | 121.83 | 123.6802 | 41748760.0 |
| 2024-10-04 11:00:00 | NVDA | Stock | 123.685 | 124.2899 | 123.26 | 124.2885 | 30452079.0 |
| 2024-10-04 12:00:00 | NVDA | Stock | 124.285 | 124.49 | 123.6201 | 124.28 | 19416420.0 |
| 2024-10-04 13:00:00 | NVDA | Stock | 124.275 | 124.49 | 123.76 | 123.9701 | 17447521.0 |
| 2024-10-04 14:00:00 | NVDA | Stock | 123.975 | 124.7 | 123.91 | 124.615 | 18780250.0 |
| 2024-10-04 15:00:00 | NVDA | Stock | 124.615 | 125.04 | 124.3 | 124.89 | 29451854.0 |
| 2024-10-04 16:00:00 | NVDA | Stock | 124.89 | 124.96 | 124.581 | 124.611 | 12819833.0 |
| 2024-10-04 17:00:00 | NVDA | Stock | 124.61 | 124.73 | 124.6 | 124.61 | 331938.0 |
| 2024-10-04 18:00:00 | NVDA | Stock | 124.6195 | 124.7 | 124.61 | 124.63 | 213869.0 |
| 2024-10-04 19:00:00 | NVDA | Stock | 124.63 | 124.68 | 124.41 | 124.44 | 363764.0 |
| 2024-10-04 04:00:00 | AMZN | Stock | 184.3 | 184.6 | 184.0 | 184.31 | 13965.0 |
| 2024-10-04 05:00:00 | AMZN | Stock | 184.42 | 184.83 | 184.42 | 184.8 | 7461.0 |
> showing 50 of 59,089 rows — these rows as CSV