PREVIEW / stock_1hour / 2024-08-19
file: by_date/stock_1hour/2024/2024-08-19.parquet size: 1.4 MB rows: 60,176 symbols: 855
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-19 04:00:00 | AAPL | Stock | 226.44 | 226.44 | 225.2 | 225.6 | 15446.0 |
| 2024-08-19 05:00:00 | AAPL | Stock | 225.6 | 225.69 | 225.3 | 225.38 | 8350.0 |
| 2024-08-19 06:00:00 | AAPL | Stock | 225.43 | 225.46 | 225.0 | 225.1 | 15466.0 |
| 2024-08-19 07:00:00 | AAPL | Stock | 225.19 | 226.03 | 225.19 | 225.98 | 25613.0 |
| 2024-08-19 08:00:00 | AAPL | Stock | 225.35 | 226.44 | 224.89 | 226.0936 | 99677.0 |
| 2024-08-19 09:00:00 | AAPL | Stock | 226.13 | 226.14 | 224.116 | 224.4 | 3853232.0 |
| 2024-08-19 10:00:00 | AAPL | Stock | 224.4 | 224.52 | 223.04 | 224.21 | 4400888.0 |
| 2024-08-19 11:00:00 | AAPL | Stock | 224.23 | 224.73 | 223.75 | 223.8647 | 2642994.0 |
| 2024-08-19 12:00:00 | AAPL | Stock | 223.88 | 224.465 | 223.8 | 224.375 | 1967498.0 |
| 2024-08-19 13:00:00 | AAPL | Stock | 224.36 | 224.43 | 223.75 | 224.315 | 2139952.0 |
| 2024-08-19 14:00:00 | AAPL | Stock | 224.31 | 224.92 | 224.28 | 224.785 | 2060135.0 |
| 2024-08-19 15:00:00 | AAPL | Stock | 224.78 | 225.99 | 224.67 | 225.9 | 4327884.0 |
| 2024-08-19 16:00:00 | AAPL | Stock | 225.9 | 226.0 | 225.65 | 225.84 | 6293248.0 |
| 2024-08-19 17:00:00 | AAPL | Stock | 225.83 | 225.89 | 225.71 | 225.8088 | 73350.0 |
| 2024-08-19 18:00:00 | AAPL | Stock | 225.81 | 226.06 | 225.7989 | 225.9 | 35221.0 |
| 2024-08-19 19:00:00 | AAPL | Stock | 225.92 | 225.97 | 225.6849 | 225.7 | 8931.0 |
| 2024-08-19 04:00:00 | MSFT | Stock | 418.01 | 418.01 | 417.41 | 418.0 | 4459.0 |
| 2024-08-19 05:00:00 | MSFT | Stock | 418.07 | 418.57 | 417.82 | 418.55 | 1466.0 |
| 2024-08-19 06:00:00 | MSFT | Stock | 418.71 | 418.71 | 418.34 | 418.35 | 4578.0 |
| 2024-08-19 07:00:00 | MSFT | Stock | 418.45 | 419.16 | 418.45 | 418.98 | 6185.0 |
| 2024-08-19 08:00:00 | MSFT | Stock | 418.07 | 419.4 | 417.88 | 418.8988 | 24890.0 |
| 2024-08-19 09:00:00 | MSFT | Stock | 418.96 | 419.87 | 417.67 | 419.64 | 982998.0 |
| 2024-08-19 10:00:00 | MSFT | Stock | 419.61 | 419.75 | 416.46 | 418.2 | 883620.0 |
| 2024-08-19 11:00:00 | MSFT | Stock | 418.18 | 418.53 | 417.08 | 417.31 | 623649.0 |
| 2024-08-19 12:00:00 | MSFT | Stock | 417.33 | 419.2 | 417.314 | 418.88 | 472273.0 |
| 2024-08-19 13:00:00 | MSFT | Stock | 418.88 | 419.07 | 418.27 | 418.94 | 441017.0 |
| 2024-08-19 14:00:00 | MSFT | Stock | 418.94 | 420.6 | 418.8542 | 420.03 | 606588.0 |
| 2024-08-19 15:00:00 | MSFT | Stock | 420.045 | 421.75 | 419.47 | 421.58 | 1423448.0 |
| 2024-08-19 16:00:00 | MSFT | Stock | 421.53 | 422.05 | 421.1 | 421.99 | 3989468.0 |
| 2024-08-19 17:00:00 | MSFT | Stock | 421.9 | 421.9482 | 421.53 | 421.6 | 5403.0 |
| 2024-08-19 18:00:00 | MSFT | Stock | 422.0 | 422.1 | 421.75 | 422.1 | 10229.0 |
| 2024-08-19 19:00:00 | MSFT | Stock | 421.9 | 422.25 | 421.9 | 422.2164 | 4777.0 |
| 2024-08-19 04:00:00 | NVDA | Stock | 124.31 | 124.56 | 122.67 | 123.15 | 734390.0 |
| 2024-08-19 05:00:00 | NVDA | Stock | 123.15 | 123.62 | 122.77 | 123.58 | 308431.0 |
| 2024-08-19 06:00:00 | NVDA | Stock | 123.56 | 124.26 | 123.47 | 123.58 | 441090.0 |
| 2024-08-19 07:00:00 | NVDA | Stock | 123.58 | 124.79 | 123.5 | 124.79 | 1148898.0 |
| 2024-08-19 08:00:00 | NVDA | Stock | 123.86 | 125.74 | 122.8648 | 124.7423 | 3422455.0 |
| 2024-08-19 09:00:00 | NVDA | Stock | 124.73 | 125.669 | 123.42 | 124.91 | 41861044.0 |
| 2024-08-19 10:00:00 | NVDA | Stock | 124.915 | 125.86 | 123.81 | 125.705 | 44412465.0 |
| 2024-08-19 11:00:00 | NVDA | Stock | 125.7 | 127.6599 | 125.61 | 127.075 | 37930935.0 |
| 2024-08-19 12:00:00 | NVDA | Stock | 127.08 | 127.48 | 126.45 | 127.35 | 27569510.0 |
| 2024-08-19 13:00:00 | NVDA | Stock | 127.34 | 128.7 | 127.29 | 128.5514 | 28417176.0 |
| 2024-08-19 14:00:00 | NVDA | Stock | 128.56 | 129.29 | 128.555 | 128.83 | 33039601.0 |
| 2024-08-19 15:00:00 | NVDA | Stock | 128.83 | 130.0 | 128.58 | 129.99 | 39568264.0 |
| 2024-08-19 16:00:00 | NVDA | Stock | 129.99 | 130.0 | 127.1771 | 129.48 | 22400735.0 |
| 2024-08-19 17:00:00 | NVDA | Stock | 129.49 | 130.0 | 129.29 | 129.42 | 697761.0 |
| 2024-08-19 18:00:00 | NVDA | Stock | 129.41 | 129.49 | 129.1 | 129.19 | 579259.0 |
| 2024-08-19 19:00:00 | NVDA | Stock | 129.2 | 129.35 | 129.1 | 129.11 | 723644.0 |
| 2024-08-19 04:00:00 | AMZN | Stock | 177.25 | 177.57 | 176.8 | 177.21 | 15529.0 |
| 2024-08-19 05:00:00 | AMZN | Stock | 177.27 | 177.92 | 176.92 | 177.92 | 13112.0 |
> showing 50 of 60,176 rows — these rows as CSV