PREVIEW / stock_1hour / 2024-08-23
file: by_date/stock_1hour/2024/2024-08-23.parquet size: 1.3 MB rows: 58,227 symbols: 833
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-23 04:00:00 | AAPL | Stock | 225.5 | 225.65 | 225.11 | 225.65 | 5813.0 |
| 2024-08-23 05:00:00 | AAPL | Stock | 225.71 | 225.75 | 225.5 | 225.7 | 2964.0 |
| 2024-08-23 06:00:00 | AAPL | Stock | 225.65 | 225.96 | 225.57 | 225.96 | 2928.0 |
| 2024-08-23 07:00:00 | AAPL | Stock | 225.87 | 226.14 | 225.83 | 226.14 | 13316.0 |
| 2024-08-23 08:00:00 | AAPL | Stock | 225.99 | 226.38 | 225.05 | 226.34 | 78003.0 |
| 2024-08-23 09:00:00 | AAPL | Stock | 226.34 | 227.39 | 224.53 | 227.04 | 3392175.0 |
| 2024-08-23 10:00:00 | AAPL | Stock | 227.06 | 228.22 | 225.51 | 226.2399 | 5617405.0 |
| 2024-08-23 11:00:00 | AAPL | Stock | 226.21 | 226.74 | 225.1901 | 225.84 | 2653661.0 |
| 2024-08-23 12:00:00 | AAPL | Stock | 225.85 | 225.905 | 224.33 | 225.3 | 2543013.0 |
| 2024-08-23 13:00:00 | AAPL | Stock | 225.33 | 226.51 | 225.15 | 226.21 | 1703832.0 |
| 2024-08-23 14:00:00 | AAPL | Stock | 226.21 | 226.7 | 226.11 | 226.47 | 1540233.0 |
| 2024-08-23 15:00:00 | AAPL | Stock | 226.47 | 227.1669 | 226.22 | 226.7736 | 3760038.0 |
| 2024-08-23 16:00:00 | AAPL | Stock | 226.76 | 227.09 | 226.76 | 226.95 | 9207744.0 |
| 2024-08-23 17:00:00 | AAPL | Stock | 226.99 | 226.99 | 226.9 | 226.9783 | 9186.0 |
| 2024-08-23 18:00:00 | AAPL | Stock | 226.98 | 227.1 | 226.98 | 227.1 | 10966.0 |
| 2024-08-23 19:00:00 | AAPL | Stock | 227.1292 | 227.17 | 227.01 | 227.1631 | 14170.0 |
| 2024-08-23 04:00:00 | MSFT | Stock | 418.05 | 418.5 | 417.51 | 418.41 | 2670.0 |
| 2024-08-23 05:00:00 | MSFT | Stock | 418.02 | 418.95 | 417.8 | 418.92 | 3130.0 |
| 2024-08-23 06:00:00 | MSFT | Stock | 418.91 | 419.06 | 418.8 | 419.06 | 2641.0 |
| 2024-08-23 07:00:00 | MSFT | Stock | 419.0 | 419.0 | 418.4 | 418.59 | 9583.0 |
| 2024-08-23 08:00:00 | MSFT | Stock | 418.42 | 419.0 | 416.588 | 418.5 | 25991.0 |
| 2024-08-23 09:00:00 | MSFT | Stock | 418.54 | 418.86 | 416.28 | 417.24 | 1111066.0 |
| 2024-08-23 10:00:00 | MSFT | Stock | 417.26 | 419.26 | 412.92 | 414.93 | 1989297.0 |
| 2024-08-23 11:00:00 | MSFT | Stock | 414.9 | 416.81 | 413.96 | 414.635 | 901953.0 |
| 2024-08-23 12:00:00 | MSFT | Stock | 414.69 | 414.805 | 412.09 | 413.97 | 853119.0 |
| 2024-08-23 13:00:00 | MSFT | Stock | 413.96 | 415.53 | 413.66 | 414.48 | 625133.0 |
| 2024-08-23 14:00:00 | MSFT | Stock | 414.495 | 415.17 | 414.07 | 414.4 | 631700.0 |
| 2024-08-23 15:00:00 | MSFT | Stock | 414.39 | 417.15 | 414.17 | 416.58 | 1639466.0 |
| 2024-08-23 16:00:00 | MSFT | Stock | 416.79 | 417.4 | 416.0 | 416.81 | 3285200.0 |
| 2024-08-23 17:00:00 | MSFT | Stock | 416.71 | 416.88 | 416.55 | 416.61 | 6507.0 |
| 2024-08-23 18:00:00 | MSFT | Stock | 416.55 | 416.75 | 416.4537 | 416.75 | 7189.0 |
| 2024-08-23 19:00:00 | MSFT | Stock | 416.75 | 416.88 | 416.7 | 416.84 | 3516.0 |
| 2024-08-23 04:00:00 | NVDA | Stock | 125.55 | 125.69 | 125.06 | 125.49 | 392606.0 |
| 2024-08-23 05:00:00 | NVDA | Stock | 125.5 | 125.5 | 124.69 | 125.09 | 269351.0 |
| 2024-08-23 06:00:00 | NVDA | Stock | 125.16 | 125.59 | 125.16 | 125.41 | 204734.0 |
| 2024-08-23 07:00:00 | NVDA | Stock | 125.41 | 125.62 | 125.16 | 125.42 | 695287.0 |
| 2024-08-23 08:00:00 | NVDA | Stock | 125.45 | 125.8 | 124.8496 | 125.28 | 2030664.0 |
| 2024-08-23 09:00:00 | NVDA | Stock | 125.31 | 127.54 | 125.22 | 127.4097 | 39065004.0 |
| 2024-08-23 10:00:00 | NVDA | Stock | 127.42 | 129.6 | 126.51 | 127.96 | 76630377.0 |
| 2024-08-23 11:00:00 | NVDA | Stock | 127.97 | 129.18 | 127.3 | 128.13 | 34813153.0 |
| 2024-08-23 12:00:00 | NVDA | Stock | 128.16 | 128.27 | 126.62 | 127.3699 | 27256475.0 |
| 2024-08-23 13:00:00 | NVDA | Stock | 127.35 | 128.44 | 127.16 | 128.165 | 18525389.0 |
| 2024-08-23 14:00:00 | NVDA | Stock | 128.18 | 128.8 | 128.09 | 128.2803 | 18366953.0 |
| 2024-08-23 15:00:00 | NVDA | Stock | 128.28 | 129.32 | 127.875 | 129.28 | 33951050.0 |
| 2024-08-23 16:00:00 | NVDA | Stock | 129.25 | 129.37 | 125.85 | 129.05 | 27285205.0 |
| 2024-08-23 17:00:00 | NVDA | Stock | 129.06 | 129.28 | 129.02 | 129.18 | 464742.0 |
| 2024-08-23 18:00:00 | NVDA | Stock | 129.18 | 129.37 | 129.17 | 129.37 | 427041.0 |
| 2024-08-23 19:00:00 | NVDA | Stock | 129.37 | 129.47 | 129.34 | 129.45 | 571747.0 |
| 2024-08-23 04:00:00 | AMZN | Stock | 177.77 | 177.9 | 177.1 | 177.36 | 21724.0 |
| 2024-08-23 05:00:00 | AMZN | Stock | 177.33 | 177.42 | 177.2 | 177.42 | 5469.0 |
> showing 50 of 58,227 rows — these rows as CSV