PREVIEW / stock_1hour / 2024-01-30
file: by_date/stock_1hour/2024/2024-01-30.parquet size: 1.3 MB rows: 59,095 symbols: 1,161
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-01-30 04:00:00 | AAPL | Stock | 190.91 | 190.91 | 190.37 | 190.5 | 16497.0 |
| 2024-01-30 05:00:00 | AAPL | Stock | 190.5 | 190.76 | 190.42 | 190.43 | 3946.0 |
| 2024-01-30 06:00:00 | AAPL | Stock | 190.4 | 190.66 | 190.39 | 190.51 | 8291.0 |
| 2024-01-30 07:00:00 | AAPL | Stock | 190.57 | 190.75 | 190.51 | 190.55 | 34448.0 |
| 2024-01-30 08:00:00 | AAPL | Stock | 190.5115 | 191.2 | 190.25 | 190.55 | 81089.0 |
| 2024-01-30 09:00:00 | AAPL | Stock | 190.55 | 191.8 | 190.35 | 191.11 | 4420810.0 |
| 2024-01-30 10:00:00 | AAPL | Stock | 191.1 | 191.17 | 188.22 | 188.49 | 10280653.0 |
| 2024-01-30 11:00:00 | AAPL | Stock | 188.4898 | 188.94 | 187.865 | 188.7201 | 6367135.0 |
| 2024-01-30 12:00:00 | AAPL | Stock | 188.73 | 188.93 | 187.87 | 187.8702 | 4096553.0 |
| 2024-01-30 13:00:00 | AAPL | Stock | 187.8713 | 188.6399 | 187.68 | 188.02 | 3458442.0 |
| 2024-01-30 14:00:00 | AAPL | Stock | 188.02 | 188.28 | 187.47 | 188.23 | 3825804.0 |
| 2024-01-30 15:00:00 | AAPL | Stock | 188.225 | 188.27 | 187.8 | 187.98 | 6247658.0 |
| 2024-01-30 16:00:00 | AAPL | Stock | 188.04 | 188.34 | 187.26 | 188.26 | 6029874.0 |
| 2024-01-30 17:00:00 | AAPL | Stock | 188.33 | 188.39 | 187.4 | 187.5 | 154687.0 |
| 2024-01-30 18:00:00 | AAPL | Stock | 187.5 | 187.88 | 187.27 | 187.85 | 61684.0 |
| 2024-01-30 19:00:00 | AAPL | Stock | 187.88 | 187.88 | 187.25 | 187.3 | 42144.0 |
| 2024-01-30 04:00:00 | MSFT | Stock | 413.97 | 414.04 | 412.31 | 412.69 | 33527.0 |
| 2024-01-30 05:00:00 | MSFT | Stock | 412.68 | 413.38 | 412.37 | 412.59 | 9122.0 |
| 2024-01-30 06:00:00 | MSFT | Stock | 412.6 | 413.31 | 412.4 | 412.58 | 16279.0 |
| 2024-01-30 07:00:00 | MSFT | Stock | 412.87 | 413.45 | 412.35 | 412.75 | 53420.0 |
| 2024-01-30 08:00:00 | MSFT | Stock | 413.36 | 417.16 | 411.86 | 412.18 | 159767.0 |
| 2024-01-30 09:00:00 | MSFT | Stock | 412.13 | 413.73 | 410.26 | 410.88 | 2819589.0 |
| 2024-01-30 10:00:00 | MSFT | Stock | 410.825 | 411.04 | 409.01 | 409.495 | 2987175.0 |
| 2024-01-30 11:00:00 | MSFT | Stock | 409.49 | 410.57 | 409.49 | 409.66 | 1613175.0 |
| 2024-01-30 12:00:00 | MSFT | Stock | 409.67 | 409.83 | 406.4501 | 407.14 | 2041016.0 |
| 2024-01-30 13:00:00 | MSFT | Stock | 407.15 | 408.24 | 406.81 | 408.045 | 1550724.0 |
| 2024-01-30 14:00:00 | MSFT | Stock | 408.055 | 408.49 | 407.31 | 408.004 | 1612065.0 |
| 2024-01-30 15:00:00 | MSFT | Stock | 408.01 | 409.429 | 407.6 | 408.6 | 3301267.0 |
| 2024-01-30 16:00:00 | MSFT | Stock | 408.59 | 416.11 | 401.04 | 403.74 | 4149070.0 |
| 2024-01-30 17:00:00 | MSFT | Stock | 403.75 | 408.59 | 396.5 | 403.7 | 694155.0 |
| 2024-01-30 18:00:00 | MSFT | Stock | 403.36 | 410.99 | 400.02 | 405.55 | 998644.0 |
| 2024-01-30 19:00:00 | MSFT | Stock | 405.5 | 407.65 | 404.6595 | 407.64 | 127340.0 |
| 2024-01-30 04:00:00 | NVDA | Stock | 63.293 | 63.3 | 62.95 | 63.06 | 168220.0 |
| 2024-01-30 05:00:00 | NVDA | Stock | 63.1 | 63.162 | 63.05 | 63.06 | 173640.0 |
| 2024-01-30 06:00:00 | NVDA | Stock | 63.024 | 63.079 | 62.97 | 63.05 | 125690.0 |
| 2024-01-30 07:00:00 | NVDA | Stock | 63.05 | 63.298 | 63.047 | 63.175 | 842650.0 |
| 2024-01-30 08:00:00 | NVDA | Stock | 63.1 | 63.292 | 62.765 | 62.78 | 2557980.0 |
| 2024-01-30 09:00:00 | NVDA | Stock | 62.781 | 63.3 | 62.541 | 62.865 | 54140970.0 |
| 2024-01-30 10:00:00 | NVDA | Stock | 62.8785 | 63.399 | 62.551 | 63.054 | 61038620.0 |
| 2024-01-30 11:00:00 | NVDA | Stock | 63.053 | 63.27 | 62.982 | 63.197 | 30775710.0 |
| 2024-01-30 12:00:00 | NVDA | Stock | 63.204 | 63.493 | 62.603 | 62.691 | 42021580.0 |
| 2024-01-30 13:00:00 | NVDA | Stock | 62.6805 | 62.837 | 62.26 | 62.498 | 38266770.0 |
| 2024-01-30 14:00:00 | NVDA | Stock | 62.498 | 62.883 | 62.283 | 62.8303 | 27595350.0 |
| 2024-01-30 15:00:00 | NVDA | Stock | 62.8237 | 63.022 | 62.655 | 62.753 | 34913820.0 |
| 2024-01-30 16:00:00 | NVDA | Stock | 62.774 | 63.079 | 62.025 | 62.29 | 16014450.0 |
| 2024-01-30 17:00:00 | NVDA | Stock | 62.25 | 62.38 | 60.8 | 61.088 | 4793430.0 |
| 2024-01-30 18:00:00 | NVDA | Stock | 61.1 | 61.642 | 61.0999 | 61.475 | 2229840.0 |
| 2024-01-30 19:00:00 | NVDA | Stock | 61.464 | 61.745 | 61.45 | 61.655 | 1012900.0 |
| 2024-01-30 04:00:00 | AMZN | Stock | 161.92 | 161.96 | 161.5 | 161.52 | 14959.0 |
| 2024-01-30 05:00:00 | AMZN | Stock | 161.58 | 161.76 | 161.5 | 161.67 | 9689.0 |
> showing 50 of 59,095 rows — these rows as CSV