PREVIEW / stock_1hour / 2024-10-03
file: by_date/stock_1hour/2024/2024-10-03.parquet size: 1.3 MB rows: 58,596 symbols: 746
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-03 04:00:00 | AAPL | Stock | 226.2 | 226.2 | 225.67 | 225.86 | 11799.0 |
| 2024-10-03 05:00:00 | AAPL | Stock | 225.86 | 225.86 | 225.74 | 225.74 | 736.0 |
| 2024-10-03 06:00:00 | AAPL | Stock | 225.79 | 225.9 | 225.53 | 225.75 | 11367.0 |
| 2024-10-03 07:00:00 | AAPL | Stock | 225.8 | 226.09 | 225.15 | 225.53 | 40271.0 |
| 2024-10-03 08:00:00 | AAPL | Stock | 225.5 | 226.37 | 224.79 | 225.21 | 152139.0 |
| 2024-10-03 09:00:00 | AAPL | Stock | 225.15 | 226.7 | 224.57 | 226.305 | 2625891.0 |
| 2024-10-03 10:00:00 | AAPL | Stock | 226.31 | 226.805 | 224.25 | 224.34 | 3803814.0 |
| 2024-10-03 11:00:00 | AAPL | Stock | 224.33 | 225.25 | 224.282 | 225.13 | 2124906.0 |
| 2024-10-03 12:00:00 | AAPL | Stock | 225.1472 | 225.37 | 223.57 | 223.82 | 2100135.0 |
| 2024-10-03 13:00:00 | AAPL | Stock | 223.8 | 224.34 | 223.32 | 224.3 | 1871411.0 |
| 2024-10-03 14:00:00 | AAPL | Stock | 224.29 | 224.4099 | 223.6102 | 223.63 | 1357474.0 |
| 2024-10-03 15:00:00 | AAPL | Stock | 223.62 | 225.84 | 223.5 | 225.67 | 5781708.0 |
| 2024-10-03 16:00:00 | AAPL | Stock | 225.66 | 225.9499 | 225.613 | 225.73 | 5164592.0 |
| 2024-10-03 17:00:00 | AAPL | Stock | 225.71 | 225.79 | 225.51 | 225.65 | 133795.0 |
| 2024-10-03 18:00:00 | AAPL | Stock | 225.5252 | 226.0 | 225.48 | 225.8 | 30264.0 |
| 2024-10-03 19:00:00 | AAPL | Stock | 225.8805 | 226.2005 | 225.83 | 226.07 | 33740.0 |
| 2024-10-03 04:00:00 | MSFT | Stock | 416.91 | 416.99 | 416.05 | 416.53 | 1613.0 |
| 2024-10-03 05:00:00 | MSFT | Stock | 416.4 | 416.43 | 416.18 | 416.27 | 435.0 |
| 2024-10-03 06:00:00 | MSFT | Stock | 416.24 | 416.78 | 416.24 | 416.78 | 662.0 |
| 2024-10-03 07:00:00 | MSFT | Stock | 417.12 | 417.99 | 417.0 | 417.99 | 3030.0 |
| 2024-10-03 08:00:00 | MSFT | Stock | 417.12 | 419.077 | 416.01 | 417.0 | 43101.0 |
| 2024-10-03 09:00:00 | MSFT | Stock | 417.0 | 418.34 | 415.7613 | 418.1899 | 1347453.0 |
| 2024-10-03 10:00:00 | MSFT | Stock | 418.19 | 419.55 | 415.88 | 416.29 | 1361320.0 |
| 2024-10-03 11:00:00 | MSFT | Stock | 416.24 | 418.01 | 416.09 | 417.81 | 662315.0 |
| 2024-10-03 12:00:00 | MSFT | Stock | 417.81 | 417.95 | 414.52 | 415.1 | 690153.0 |
| 2024-10-03 13:00:00 | MSFT | Stock | 415.03 | 416.45 | 414.29 | 416.45 | 833048.0 |
| 2024-10-03 14:00:00 | MSFT | Stock | 416.51 | 417.04 | 415.74 | 415.876 | 450975.0 |
| 2024-10-03 15:00:00 | MSFT | Stock | 415.84 | 417.07 | 414.99 | 416.54 | 1488747.0 |
| 2024-10-03 16:00:00 | MSFT | Stock | 416.54 | 416.94 | 416.08 | 416.54 | 2138649.0 |
| 2024-10-03 17:00:00 | MSFT | Stock | 416.06 | 416.54 | 415.9511 | 416.28 | 11188.0 |
| 2024-10-03 18:00:00 | MSFT | Stock | 416.2 | 416.8 | 416.15 | 416.3346 | 8966.0 |
| 2024-10-03 19:00:00 | MSFT | Stock | 416.5 | 416.78 | 416.0 | 416.33 | 7130.0 |
| 2024-10-03 04:00:00 | NVDA | Stock | 118.89 | 120.4 | 118.77 | 119.61 | 631639.0 |
| 2024-10-03 05:00:00 | NVDA | Stock | 119.6 | 119.94 | 119.5 | 119.68 | 190762.0 |
| 2024-10-03 06:00:00 | NVDA | Stock | 119.7 | 120.47 | 119.68 | 120.46 | 364160.0 |
| 2024-10-03 07:00:00 | NVDA | Stock | 120.44 | 120.75 | 120.37 | 120.59 | 860347.0 |
| 2024-10-03 08:00:00 | NVDA | Stock | 120.5 | 121.5 | 116.42 | 120.98 | 4245654.0 |
| 2024-10-03 09:00:00 | NVDA | Stock | 120.97 | 123.68 | 120.3401 | 123.36 | 48937990.0 |
| 2024-10-03 10:00:00 | NVDA | Stock | 123.34 | 124.36 | 121.78 | 122.36 | 63046329.0 |
| 2024-10-03 11:00:00 | NVDA | Stock | 122.36 | 123.33 | 121.96 | 123.06 | 26470529.0 |
| 2024-10-03 12:00:00 | NVDA | Stock | 123.065 | 123.17 | 121.74 | 121.9599 | 22542764.0 |
| 2024-10-03 13:00:00 | NVDA | Stock | 121.955 | 123.0 | 121.46 | 122.95 | 22676721.0 |
| 2024-10-03 14:00:00 | NVDA | Stock | 122.955 | 123.2 | 122.45 | 122.5342 | 17418611.0 |
| 2024-10-03 15:00:00 | NVDA | Stock | 122.535 | 123.0 | 122.1125 | 122.84 | 25203986.0 |
| 2024-10-03 16:00:00 | NVDA | Stock | 122.85 | 122.97 | 122.4 | 122.49 | 15167549.0 |
| 2024-10-03 17:00:00 | NVDA | Stock | 122.5 | 122.85 | 122.23 | 122.46 | 2300406.0 |
| 2024-10-03 18:00:00 | NVDA | Stock | 122.44 | 122.9 | 122.35 | 122.8849 | 398736.0 |
| 2024-10-03 19:00:00 | NVDA | Stock | 122.89 | 122.99 | 122.65 | 122.78 | 582813.0 |
| 2024-10-03 04:00:00 | AMZN | Stock | 184.05 | 184.05 | 183.48 | 183.48 | 11888.0 |
| 2024-10-03 05:00:00 | AMZN | Stock | 183.5 | 183.79 | 183.5 | 183.59 | 6378.0 |
> showing 50 of 58,596 rows — these rows as CSV