PREVIEW / stock_1hour / 2024-02-22
file: by_date/stock_1hour/2024/2024-02-22.parquet size: 1.4 MB rows: 60,668 symbols: 1,142
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-02-22 04:00:00 | AAPL | Stock | 183.8 | 183.98 | 183.35 | 183.58 | 24156.0 |
| 2024-02-22 05:00:00 | AAPL | Stock | 183.54 | 183.54 | 183.03 | 183.2 | 15408.0 |
| 2024-02-22 06:00:00 | AAPL | Stock | 183.19 | 183.75 | 183.13 | 183.49 | 10538.0 |
| 2024-02-22 07:00:00 | AAPL | Stock | 183.32 | 183.54 | 183.17 | 183.18 | 53733.0 |
| 2024-02-22 08:00:00 | AAPL | Stock | 183.42 | 184.11 | 182.9 | 183.3787 | 174716.0 |
| 2024-02-22 09:00:00 | AAPL | Stock | 183.38 | 184.19 | 182.524 | 183.13 | 5729770.0 |
| 2024-02-22 10:00:00 | AAPL | Stock | 183.13 | 183.49 | 182.7 | 182.86 | 5142446.0 |
| 2024-02-22 11:00:00 | AAPL | Stock | 182.87 | 183.26 | 182.46 | 182.95 | 3512080.0 |
| 2024-02-22 12:00:00 | AAPL | Stock | 182.95 | 183.65 | 182.74 | 183.62 | 3301628.0 |
| 2024-02-22 13:00:00 | AAPL | Stock | 183.61 | 184.29 | 183.535 | 184.2175 | 3737376.0 |
| 2024-02-22 14:00:00 | AAPL | Stock | 184.21 | 184.955 | 184.19 | 184.545 | 4009344.0 |
| 2024-02-22 15:00:00 | AAPL | Stock | 184.55 | 184.85 | 184.18 | 184.36 | 7401846.0 |
| 2024-02-22 16:00:00 | AAPL | Stock | 184.371 | 184.38 | 183.72 | 184.2 | 7226530.0 |
| 2024-02-22 17:00:00 | AAPL | Stock | 184.2006 | 184.37 | 184.0 | 184.0 | 12215.0 |
| 2024-02-22 18:00:00 | AAPL | Stock | 184.0 | 184.31 | 184.0 | 184.24 | 14440.0 |
| 2024-02-22 19:00:00 | AAPL | Stock | 184.15 | 184.18 | 183.75 | 183.95 | 11594.0 |
| 2024-02-22 04:00:00 | MSFT | Stock | 408.4 | 408.4 | 406.2 | 408.13 | 18152.0 |
| 2024-02-22 05:00:00 | MSFT | Stock | 408.0 | 408.97 | 407.9 | 408.6 | 12633.0 |
| 2024-02-22 06:00:00 | MSFT | Stock | 408.54 | 410.0 | 408.54 | 409.7 | 13689.0 |
| 2024-02-22 07:00:00 | MSFT | Stock | 409.5 | 409.99 | 408.75 | 409.9 | 76320.0 |
| 2024-02-22 08:00:00 | MSFT | Stock | 409.35 | 410.72 | 407.115 | 409.7 | 161368.0 |
| 2024-02-22 09:00:00 | MSFT | Stock | 409.8 | 412.83 | 408.57 | 410.88 | 4003216.0 |
| 2024-02-22 10:00:00 | MSFT | Stock | 410.88 | 412.21 | 409.36 | 409.6 | 2310263.0 |
| 2024-02-22 11:00:00 | MSFT | Stock | 409.62 | 410.39 | 408.86 | 409.0 | 1125459.0 |
| 2024-02-22 12:00:00 | MSFT | Stock | 409.0 | 409.76 | 408.64 | 409.71 | 783428.0 |
| 2024-02-22 13:00:00 | MSFT | Stock | 409.64 | 410.87 | 409.29 | 410.655 | 908723.0 |
| 2024-02-22 14:00:00 | MSFT | Stock | 410.62 | 411.68 | 410.45 | 410.84 | 1005082.0 |
| 2024-02-22 15:00:00 | MSFT | Stock | 410.83 | 412.06 | 410.79 | 411.63 | 2927921.0 |
| 2024-02-22 16:00:00 | MSFT | Stock | 411.53 | 412.17 | 410.4 | 411.76 | 4372370.0 |
| 2024-02-22 17:00:00 | MSFT | Stock | 411.75 | 411.75 | 411.0985 | 411.18 | 5035.0 |
| 2024-02-22 18:00:00 | MSFT | Stock | 411.57 | 412.0 | 411.3 | 411.48 | 13408.0 |
| 2024-02-22 19:00:00 | MSFT | Stock | 411.5 | 411.75 | 411.3 | 411.75 | 5770.0 |
| 2024-02-22 04:00:00 | NVDA | Stock | 74.916 | 77.298 | 74.202 | 77.2 | 3501430.0 |
| 2024-02-22 05:00:00 | NVDA | Stock | 77.17 | 77.559 | 76.76 | 76.869 | 1696190.0 |
| 2024-02-22 06:00:00 | NVDA | Stock | 76.859 | 77.4 | 76.5 | 77.223 | 1508400.0 |
| 2024-02-22 07:00:00 | NVDA | Stock | 77.223 | 77.254 | 75.65 | 76.208 | 5271030.0 |
| 2024-02-22 08:00:00 | NVDA | Stock | 76.97 | 77.1 | 74.23 | 75.316 | 13597910.0 |
| 2024-02-22 09:00:00 | NVDA | Stock | 75.3361 | 77.898 | 74.22 | 77.1 | 169708770.0 |
| 2024-02-22 10:00:00 | NVDA | Stock | 77.1 | 78.085 | 76.81 | 77.7254 | 120617440.0 |
| 2024-02-22 11:00:00 | NVDA | Stock | 77.728 | 78.154 | 77.459 | 77.6135 | 58849250.0 |
| 2024-02-22 12:00:00 | NVDA | Stock | 77.6175 | 77.788 | 77.271 | 77.542 | 40732290.0 |
| 2024-02-22 13:00:00 | NVDA | Stock | 77.538 | 77.848 | 77.055 | 77.764 | 40342150.0 |
| 2024-02-22 14:00:00 | NVDA | Stock | 77.7678 | 77.993 | 77.498 | 77.8553 | 39204900.0 |
| 2024-02-22 15:00:00 | NVDA | Stock | 77.8585 | 78.575 | 77.78 | 78.465 | 78560680.0 |
| 2024-02-22 16:00:00 | NVDA | Stock | 78.465 | 79.24 | 78.125 | 78.97 | 32208710.0 |
| 2024-02-22 17:00:00 | NVDA | Stock | 79.0 | 79.486 | 78.84 | 79.486 | 2925930.0 |
| 2024-02-22 18:00:00 | NVDA | Stock | 79.485 | 79.965 | 79.451 | 79.901 | 4861400.0 |
| 2024-02-22 19:00:00 | NVDA | Stock | 79.9 | 79.925 | 79.721 | 79.895 | 2140130.0 |
| 2024-02-22 04:00:00 | AMZN | Stock | 171.51 | 173.14 | 170.6 | 171.44 | 27009.0 |
| 2024-02-22 05:00:00 | AMZN | Stock | 171.36 | 171.49 | 171.2 | 171.38 | 25854.0 |
> showing 50 of 60,668 rows — these rows as CSV