PREVIEW / stock_1hour / 2024-02-14
file: by_date/stock_1hour/2024/2024-02-14.parquet size: 1.4 MB rows: 60,162 symbols: 1,136
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-14 04:00:00 | AAPL | Stock | 185.43 | 185.65 | 185.42 | 185.61 | 11894.0 |
| 2024-02-14 05:00:00 | AAPL | Stock | 185.61 | 185.65 | 185.33 | 185.54 | 11150.0 |
| 2024-02-14 06:00:00 | AAPL | Stock | 185.5 | 185.5 | 185.35 | 185.5 | 6254.0 |
| 2024-02-14 07:00:00 | AAPL | Stock | 185.5 | 185.9 | 185.39 | 185.51 | 39936.0 |
| 2024-02-14 08:00:00 | AAPL | Stock | 185.79 | 185.94 | 185.21 | 185.3 | 100198.0 |
| 2024-02-14 09:00:00 | AAPL | Stock | 185.36 | 185.53 | 183.91 | 184.02 | 4772358.0 |
| 2024-02-14 10:00:00 | AAPL | Stock | 184.03 | 184.27 | 183.11 | 183.1801 | 7218566.0 |
| 2024-02-14 11:00:00 | AAPL | Stock | 183.185 | 183.6 | 182.8035 | 182.995 | 4844567.0 |
| 2024-02-14 12:00:00 | AAPL | Stock | 183.0 | 183.015 | 182.51 | 182.715 | 3849318.0 |
| 2024-02-14 13:00:00 | AAPL | Stock | 182.72 | 183.16 | 182.44 | 182.95 | 3430861.0 |
| 2024-02-14 14:00:00 | AAPL | Stock | 182.95 | 183.21 | 182.49 | 182.9176 | 3378389.0 |
| 2024-02-14 15:00:00 | AAPL | Stock | 182.92 | 184.27 | 182.83 | 184.02 | 7232263.0 |
| 2024-02-14 16:00:00 | AAPL | Stock | 184.04 | 184.49 | 181.88 | 182.64 | 6635238.0 |
| 2024-02-14 17:00:00 | AAPL | Stock | 182.61 | 184.15 | 182.42 | 183.3 | 498595.0 |
| 2024-02-14 18:00:00 | AAPL | Stock | 183.3 | 183.35 | 183.12 | 183.12 | 61732.0 |
| 2024-02-14 19:00:00 | AAPL | Stock | 183.14 | 183.3 | 183.1001 | 183.13 | 24914.0 |
| 2024-02-14 04:00:00 | MSFT | Stock | 408.85 | 410.75 | 408.85 | 410.68 | 4292.0 |
| 2024-02-14 05:00:00 | MSFT | Stock | 410.62 | 411.19 | 410.38 | 410.72 | 8286.0 |
| 2024-02-14 06:00:00 | MSFT | Stock | 410.6 | 410.6 | 409.8 | 410.0 | 4726.0 |
| 2024-02-14 07:00:00 | MSFT | Stock | 410.15 | 410.15 | 409.0 | 409.05 | 26747.0 |
| 2024-02-14 08:00:00 | MSFT | Stock | 409.59 | 409.9 | 407.54 | 408.43 | 64035.0 |
| 2024-02-14 09:00:00 | MSFT | Stock | 408.73 | 408.7997 | 404.57 | 405.31 | 2387989.0 |
| 2024-02-14 10:00:00 | MSFT | Stock | 405.325 | 407.18 | 405.04 | 405.76 | 2326600.0 |
| 2024-02-14 11:00:00 | MSFT | Stock | 405.75 | 406.89 | 405.19 | 405.41 | 1197247.0 |
| 2024-02-14 12:00:00 | MSFT | Stock | 405.45 | 407.57 | 405.03 | 407.06 | 966825.0 |
| 2024-02-14 13:00:00 | MSFT | Stock | 407.06 | 407.82 | 406.11 | 407.2513 | 837394.0 |
| 2024-02-14 14:00:00 | MSFT | Stock | 407.27 | 407.4 | 405.93 | 407.29 | 822899.0 |
| 2024-02-14 15:00:00 | MSFT | Stock | 407.31 | 409.84 | 407.02 | 409.2 | 2560669.0 |
| 2024-02-14 16:00:00 | MSFT | Stock | 409.21 | 412.0 | 408.6841 | 411.0 | 3020495.0 |
| 2024-02-14 17:00:00 | MSFT | Stock | 410.9 | 410.9913 | 410.0 | 410.4 | 18285.0 |
| 2024-02-14 18:00:00 | MSFT | Stock | 410.6998 | 410.7 | 410.3 | 410.35 | 10193.0 |
| 2024-02-14 19:00:00 | MSFT | Stock | 410.17 | 410.5 | 410.11 | 410.11 | 4421.0 |
| 2024-02-14 04:00:00 | NVDA | Stock | 72.989 | 73.43 | 72.801 | 73.354 | 190410.0 |
| 2024-02-14 05:00:00 | NVDA | Stock | 73.355 | 73.38 | 73.25 | 73.34 | 91260.0 |
| 2024-02-14 06:00:00 | NVDA | Stock | 73.32 | 73.34 | 72.99 | 73.125 | 227580.0 |
| 2024-02-14 07:00:00 | NVDA | Stock | 73.116 | 73.4 | 73.085 | 73.13 | 823440.0 |
| 2024-02-14 08:00:00 | NVDA | Stock | 73.297 | 73.385 | 72.55 | 73.264 | 2573610.0 |
| 2024-02-14 09:00:00 | NVDA | Stock | 73.263 | 74.048 | 73.006 | 74.028 | 66279780.0 |
| 2024-02-14 10:00:00 | NVDA | Stock | 74.048 | 74.236 | 73.051 | 73.071 | 65589610.0 |
| 2024-02-14 11:00:00 | NVDA | Stock | 73.0757 | 73.0757 | 71.938 | 72.5284 | 66822850.0 |
| 2024-02-14 12:00:00 | NVDA | Stock | 72.525 | 73.072 | 72.187 | 72.861 | 38119550.0 |
| 2024-02-14 13:00:00 | NVDA | Stock | 72.8631 | 73.18 | 72.45 | 72.975 | 33072510.0 |
| 2024-02-14 14:00:00 | NVDA | Stock | 72.9821 | 73.248 | 72.64 | 73.1941 | 30851220.0 |
| 2024-02-14 15:00:00 | NVDA | Stock | 73.199 | 73.907 | 73.034 | 73.855 | 50833980.0 |
| 2024-02-14 16:00:00 | NVDA | Stock | 73.859 | 73.94 | 73.418 | 73.718 | 20073890.0 |
| 2024-02-14 17:00:00 | NVDA | Stock | 73.7111 | 73.869 | 73.55 | 73.6942 | 963280.0 |
| 2024-02-14 18:00:00 | NVDA | Stock | 73.695 | 73.858 | 73.656 | 73.8 | 420800.0 |
| 2024-02-14 19:00:00 | NVDA | Stock | 73.797 | 73.82 | 73.75 | 73.8 | 414990.0 |
| 2024-02-14 04:00:00 | AMZN | Stock | 169.33 | 170.1 | 169.33 | 170.07 | 9982.0 |
| 2024-02-14 05:00:00 | AMZN | Stock | 170.1 | 170.13 | 170.0 | 170.12 | 10128.0 |
> showing 50 of 60,162 rows — these rows as CSV