PREVIEW / stock_1hour / 2024-07-19
file: by_date/stock_1hour/2024/2024-07-19.parquet size: 1.3 MB rows: 57,145 symbols: 882
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-07-19 04:00:00 | AAPL | Stock | 224.13 | 224.2 | 222.0 | 223.0 | 42856.0 |
| 2024-07-19 05:00:00 | AAPL | Stock | 222.93 | 224.9 | 222.91 | 224.85 | 37740.0 |
| 2024-07-19 06:00:00 | AAPL | Stock | 224.79 | 225.66 | 224.79 | 225.1 | 27665.0 |
| 2024-07-19 07:00:00 | AAPL | Stock | 225.0 | 226.24 | 225.0 | 225.9 | 44142.0 |
| 2024-07-19 08:00:00 | AAPL | Stock | 225.15 | 226.38 | 223.26 | 226.28 | 185231.0 |
| 2024-07-19 09:00:00 | AAPL | Stock | 226.3 | 226.6 | 224.42 | 225.825 | 8483692.0 |
| 2024-07-19 10:00:00 | AAPL | Stock | 225.81 | 226.8 | 224.62 | 224.8 | 4789091.0 |
| 2024-07-19 11:00:00 | AAPL | Stock | 224.81 | 225.26 | 223.56 | 224.99 | 3400694.0 |
| 2024-07-19 12:00:00 | AAPL | Stock | 224.97 | 224.99 | 223.275 | 223.99 | 2510901.0 |
| 2024-07-19 13:00:00 | AAPL | Stock | 223.97 | 224.782 | 223.47 | 224.61 | 2485168.0 |
| 2024-07-19 14:00:00 | AAPL | Stock | 224.6 | 224.945 | 223.89 | 224.44 | 2538106.0 |
| 2024-07-19 15:00:00 | AAPL | Stock | 224.45 | 225.12 | 224.01 | 224.33 | 6018719.0 |
| 2024-07-19 16:00:00 | AAPL | Stock | 224.31 | 224.6 | 224.31 | 224.46 | 5958232.0 |
| 2024-07-19 17:00:00 | AAPL | Stock | 224.46 | 224.47 | 224.31 | 224.35 | 445803.0 |
| 2024-07-19 18:00:00 | AAPL | Stock | 224.35 | 224.35 | 224.3 | 224.3 | 131017.0 |
| 2024-07-19 19:00:00 | AAPL | Stock | 224.3007 | 224.34 | 224.18 | 224.3271 | 7311.0 |
| 2024-07-19 04:00:00 | MSFT | Stock | 431.59 | 435.0 | 428.0 | 429.34 | 128063.0 |
| 2024-07-19 05:00:00 | MSFT | Stock | 429.51 | 432.17 | 425.2 | 430.03 | 164297.0 |
| 2024-07-19 06:00:00 | MSFT | Stock | 429.8 | 434.71 | 429.04 | 433.6 | 102345.0 |
| 2024-07-19 07:00:00 | MSFT | Stock | 433.6 | 435.4 | 432.5 | 433.95 | 86499.0 |
| 2024-07-19 08:00:00 | MSFT | Stock | 434.0 | 442.3 | 426.4714 | 435.4 | 160015.0 |
| 2024-07-19 09:00:00 | MSFT | Stock | 435.4 | 441.14 | 431.8 | 437.78 | 4216210.0 |
| 2024-07-19 10:00:00 | MSFT | Stock | 437.76 | 441.0 | 436.86 | 439.225 | 1482619.0 |
| 2024-07-19 11:00:00 | MSFT | Stock | 439.27 | 440.26 | 436.45 | 438.455 | 897563.0 |
| 2024-07-19 12:00:00 | MSFT | Stock | 438.42 | 438.74 | 436.19 | 437.15 | 676900.0 |
| 2024-07-19 13:00:00 | MSFT | Stock | 437.12 | 437.19 | 435.63 | 436.8099 | 685921.0 |
| 2024-07-19 14:00:00 | MSFT | Stock | 436.73 | 437.6 | 435.895 | 437.52 | 659049.0 |
| 2024-07-19 15:00:00 | MSFT | Stock | 437.51 | 438.36 | 435.97 | 437.09 | 1680754.0 |
| 2024-07-19 16:00:00 | MSFT | Stock | 437.11 | 437.6 | 437.11 | 437.4999 | 2563728.0 |
| 2024-07-19 17:00:00 | MSFT | Stock | 437.4245 | 437.7 | 437.11 | 437.36 | 10321.0 |
| 2024-07-19 18:00:00 | MSFT | Stock | 437.29 | 437.29 | 437.09 | 437.09 | 41055.0 |
| 2024-07-19 19:00:00 | MSFT | Stock | 437.0 | 437.0001 | 435.863 | 436.735 | 9623.0 |
| 2024-07-19 04:00:00 | NVDA | Stock | 119.84 | 121.74 | 119.15 | 120.34 | 560333.0 |
| 2024-07-19 05:00:00 | NVDA | Stock | 120.34 | 120.58 | 119.51 | 120.02 | 286936.0 |
| 2024-07-19 06:00:00 | NVDA | Stock | 120.01 | 120.73 | 120.0 | 120.57 | 203129.0 |
| 2024-07-19 07:00:00 | NVDA | Stock | 120.62 | 121.47 | 120.25 | 121.05 | 544773.0 |
| 2024-07-19 08:00:00 | NVDA | Stock | 120.4 | 122.23 | 119.6 | 121.06 | 1608158.0 |
| 2024-07-19 09:00:00 | NVDA | Stock | 121.06 | 121.6 | 119.01 | 120.36 | 27938198.0 |
| 2024-07-19 10:00:00 | NVDA | Stock | 120.36 | 120.75 | 118.59 | 119.77 | 28065624.0 |
| 2024-07-19 11:00:00 | NVDA | Stock | 119.77 | 120.27 | 118.75 | 119.7901 | 19755669.0 |
| 2024-07-19 12:00:00 | NVDA | Stock | 119.78 | 119.98 | 118.16 | 118.84 | 17073591.0 |
| 2024-07-19 13:00:00 | NVDA | Stock | 118.84 | 118.94 | 117.37 | 118.205 | 19417958.0 |
| 2024-07-19 14:00:00 | NVDA | Stock | 118.2 | 118.5 | 117.7002 | 118.242 | 14247770.0 |
| 2024-07-19 15:00:00 | NVDA | Stock | 118.25 | 118.85 | 117.75 | 117.99 | 28395687.0 |
| 2024-07-19 16:00:00 | NVDA | Stock | 118.04 | 118.39 | 117.81 | 117.98 | 16200109.0 |
| 2024-07-19 17:00:00 | NVDA | Stock | 117.98 | 118.14 | 117.93 | 118.08 | 299483.0 |
| 2024-07-19 18:00:00 | NVDA | Stock | 118.07 | 118.15 | 117.85 | 117.9 | 348192.0 |
| 2024-07-19 19:00:00 | NVDA | Stock | 117.9 | 118.0794 | 117.87 | 118.0 | 268830.0 |
| 2024-07-19 04:00:00 | AMZN | Stock | 184.0 | 184.68 | 183.4 | 184.36 | 15465.0 |
| 2024-07-19 05:00:00 | AMZN | Stock | 184.31 | 184.54 | 183.77 | 184.24 | 11847.0 |
> showing 50 of 57,145 rows — these rows as CSV