PREVIEW / stock_1hour / 2024-10-16
file: by_date/stock_1hour/2024/2024-10-16.parquet size: 1.4 MB rows: 60,450 symbols: 777
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-16 04:00:00 | AAPL | Stock | 234.34 | 234.44 | 234.08 | 234.15 | 9433.0 |
| 2024-10-16 05:00:00 | AAPL | Stock | 234.18 | 234.25 | 233.0 | 233.54 | 7936.0 |
| 2024-10-16 06:00:00 | AAPL | Stock | 233.46 | 233.74 | 233.42 | 233.55 | 5315.0 |
| 2024-10-16 07:00:00 | AAPL | Stock | 233.69 | 234.23 | 233.69 | 233.95 | 21245.0 |
| 2024-10-16 08:00:00 | AAPL | Stock | 233.8 | 234.15 | 232.84 | 232.91 | 144160.0 |
| 2024-10-16 09:00:00 | AAPL | Stock | 232.91 | 233.23 | 230.03 | 230.08 | 5490503.0 |
| 2024-10-16 10:00:00 | AAPL | Stock | 230.085 | 230.99 | 229.84 | 230.3995 | 4059750.0 |
| 2024-10-16 11:00:00 | AAPL | Stock | 230.4 | 231.145 | 230.1102 | 230.1988 | 2502341.0 |
| 2024-10-16 12:00:00 | AAPL | Stock | 230.1901 | 231.07 | 230.061 | 231.035 | 1928722.0 |
| 2024-10-16 13:00:00 | AAPL | Stock | 231.05 | 231.29 | 230.58 | 230.805 | 1605937.0 |
| 2024-10-16 14:00:00 | AAPL | Stock | 230.8242 | 231.44 | 230.73 | 231.2676 | 1630184.0 |
| 2024-10-16 15:00:00 | AAPL | Stock | 231.27 | 231.935 | 231.2 | 231.75 | 3090728.0 |
| 2024-10-16 16:00:00 | AAPL | Stock | 231.75 | 231.79 | 230.8862 | 231.48 | 5119076.0 |
| 2024-10-16 17:00:00 | AAPL | Stock | 231.47 | 231.78 | 231.36 | 231.6 | 97993.0 |
| 2024-10-16 18:00:00 | AAPL | Stock | 231.6 | 231.76 | 231.55 | 231.65 | 6630.0 |
| 2024-10-16 19:00:00 | AAPL | Stock | 231.59 | 231.6 | 231.3 | 231.3605 | 7831.0 |
| 2024-10-16 04:00:00 | MSFT | Stock | 419.77 | 419.77 | 419.0 | 419.15 | 3080.0 |
| 2024-10-16 05:00:00 | MSFT | Stock | 419.38 | 419.53 | 419.38 | 419.53 | 830.0 |
| 2024-10-16 06:00:00 | MSFT | Stock | 419.55 | 419.69 | 416.85 | 418.0 | 10362.0 |
| 2024-10-16 07:00:00 | MSFT | Stock | 418.0 | 418.46 | 417.55 | 418.15 | 9773.0 |
| 2024-10-16 08:00:00 | MSFT | Stock | 418.47 | 420.0 | 416.64 | 417.0 | 33727.0 |
| 2024-10-16 09:00:00 | MSFT | Stock | 417.24 | 417.3995 | 410.6408 | 410.93 | 1779797.0 |
| 2024-10-16 10:00:00 | MSFT | Stock | 410.88 | 414.26 | 410.48 | 413.705 | 1457933.0 |
| 2024-10-16 11:00:00 | MSFT | Stock | 413.71 | 415.82 | 413.595 | 414.11 | 794850.0 |
| 2024-10-16 12:00:00 | MSFT | Stock | 414.1 | 415.73 | 414.04 | 415.6501 | 458476.0 |
| 2024-10-16 13:00:00 | MSFT | Stock | 415.72 | 416.01 | 414.2501 | 414.91 | 493290.0 |
| 2024-10-16 14:00:00 | MSFT | Stock | 414.87 | 416.1 | 414.83 | 415.75 | 537601.0 |
| 2024-10-16 15:00:00 | MSFT | Stock | 415.76 | 416.36 | 415.26 | 416.13 | 1113647.0 |
| 2024-10-16 16:00:00 | MSFT | Stock | 416.12 | 416.48 | 414.2804 | 416.04 | 3032592.0 |
| 2024-10-16 17:00:00 | MSFT | Stock | 416.048 | 416.12 | 416.01 | 416.01 | 263438.0 |
| 2024-10-16 18:00:00 | MSFT | Stock | 416.01 | 416.12 | 415.8195 | 415.85 | 7473.0 |
| 2024-10-16 19:00:00 | MSFT | Stock | 415.85 | 415.8955 | 415.4 | 415.5 | 8496.0 |
| 2024-10-16 04:00:00 | NVDA | Stock | 132.5 | 132.6 | 131.7 | 132.24 | 512809.0 |
| 2024-10-16 05:00:00 | NVDA | Stock | 132.28 | 132.82 | 132.24 | 132.5 | 308870.0 |
| 2024-10-16 06:00:00 | NVDA | Stock | 132.52 | 132.79 | 132.31 | 132.55 | 210440.0 |
| 2024-10-16 07:00:00 | NVDA | Stock | 132.54 | 132.8 | 132.05 | 132.52 | 919714.0 |
| 2024-10-16 08:00:00 | NVDA | Stock | 132.4 | 133.15 | 131.9965 | 132.72 | 2336836.0 |
| 2024-10-16 09:00:00 | NVDA | Stock | 132.73 | 134.11 | 131.58 | 132.11 | 39569128.0 |
| 2024-10-16 10:00:00 | NVDA | Stock | 132.11 | 134.78 | 131.69 | 133.0 | 46133294.0 |
| 2024-10-16 11:00:00 | NVDA | Stock | 133.005 | 134.3 | 132.91 | 133.8508 | 24417296.0 |
| 2024-10-16 12:00:00 | NVDA | Stock | 133.858 | 134.96 | 133.74 | 134.8901 | 18730372.0 |
| 2024-10-16 13:00:00 | NVDA | Stock | 134.9 | 136.25 | 134.6915 | 136.155 | 29679394.0 |
| 2024-10-16 14:00:00 | NVDA | Stock | 136.155 | 136.62 | 135.68 | 136.45 | 25448962.0 |
| 2024-10-16 15:00:00 | NVDA | Stock | 136.455 | 136.51 | 135.3106 | 135.7099 | 29958257.0 |
| 2024-10-16 16:00:00 | NVDA | Stock | 135.69 | 135.7235 | 134.2672 | 135.46 | 16861696.0 |
| 2024-10-16 17:00:00 | NVDA | Stock | 135.46 | 135.6191 | 135.4 | 135.53 | 329817.0 |
| 2024-10-16 18:00:00 | NVDA | Stock | 135.54 | 135.96 | 135.49 | 135.92 | 405460.0 |
| 2024-10-16 19:00:00 | NVDA | Stock | 135.92 | 136.03 | 135.5 | 135.5339 | 578232.0 |
| 2024-10-16 04:00:00 | AMZN | Stock | 188.0 | 188.1 | 187.6 | 187.96 | 12318.0 |
| 2024-10-16 05:00:00 | AMZN | Stock | 187.9 | 188.11 | 187.9 | 188.03 | 3381.0 |
> showing 50 of 60,450 rows — these rows as CSV