PREVIEW / stock_1hour / 2024-02-15
file: by_date/stock_1hour/2024/2024-02-15.parquet size: 1.4 MB rows: 60,369 symbols: 1,127
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-15 04:00:00 | AAPL | Stock | 182.7 | 183.18 | 182.6 | 182.88 | 20796.0 |
| 2024-02-15 05:00:00 | AAPL | Stock | 182.82 | 182.82 | 182.3 | 182.74 | 9846.0 |
| 2024-02-15 06:00:00 | AAPL | Stock | 182.68 | 183.0 | 182.31 | 182.6 | 11513.0 |
| 2024-02-15 07:00:00 | AAPL | Stock | 182.55 | 183.15 | 182.55 | 183.1 | 36776.0 |
| 2024-02-15 08:00:00 | AAPL | Stock | 182.55 | 183.8 | 182.55 | 183.06 | 258149.0 |
| 2024-02-15 09:00:00 | AAPL | Stock | 183.04 | 184.0894 | 181.91 | 182.08 | 6442870.0 |
| 2024-02-15 10:00:00 | AAPL | Stock | 182.08 | 182.67 | 181.35 | 182.035 | 7808776.0 |
| 2024-02-15 11:00:00 | AAPL | Stock | 182.035 | 182.16 | 181.55 | 181.74 | 4210687.0 |
| 2024-02-15 12:00:00 | AAPL | Stock | 181.7324 | 182.2499 | 181.64 | 181.79 | 3398929.0 |
| 2024-02-15 13:00:00 | AAPL | Stock | 181.79 | 182.46 | 181.665 | 182.12 | 3770492.0 |
| 2024-02-15 14:00:00 | AAPL | Stock | 182.12 | 182.365 | 181.74 | 182.3509 | 3944277.0 |
| 2024-02-15 15:00:00 | AAPL | Stock | 182.3572 | 184.49 | 182.1 | 183.95 | 12564830.0 |
| 2024-02-15 16:00:00 | AAPL | Stock | 183.94 | 185.94 | 183.76 | 185.21 | 6948528.0 |
| 2024-02-15 17:00:00 | AAPL | Stock | 185.21 | 185.38 | 184.3 | 184.34 | 231307.0 |
| 2024-02-15 18:00:00 | AAPL | Stock | 184.34 | 184.72 | 184.22 | 184.58 | 71661.0 |
| 2024-02-15 19:00:00 | AAPL | Stock | 184.62 | 184.88 | 184.4 | 184.63 | 50780.0 |
| 2024-02-15 04:00:00 | MSFT | Stock | 410.46 | 411.09 | 410.21 | 411.08 | 3321.0 |
| 2024-02-15 05:00:00 | MSFT | Stock | 411.09 | 411.13 | 410.85 | 410.85 | 1550.0 |
| 2024-02-15 06:00:00 | MSFT | Stock | 410.85 | 411.33 | 410.85 | 411.33 | 2558.0 |
| 2024-02-15 07:00:00 | MSFT | Stock | 411.33 | 411.33 | 410.62 | 410.98 | 8191.0 |
| 2024-02-15 08:00:00 | MSFT | Stock | 411.3 | 411.52 | 409.83 | 410.4 | 36068.0 |
| 2024-02-15 09:00:00 | MSFT | Stock | 410.34 | 410.82 | 405.5 | 405.73 | 2310354.0 |
| 2024-02-15 10:00:00 | MSFT | Stock | 405.75 | 406.355 | 404.7 | 406.04 | 2226860.0 |
| 2024-02-15 11:00:00 | MSFT | Stock | 406.08 | 406.16 | 404.29 | 404.65 | 1737518.0 |
| 2024-02-15 12:00:00 | MSFT | Stock | 404.65 | 405.95 | 404.429 | 405.37 | 1008988.0 |
| 2024-02-15 13:00:00 | MSFT | Stock | 405.3676 | 406.26 | 405.13 | 405.86 | 1006482.0 |
| 2024-02-15 14:00:00 | MSFT | Stock | 405.87 | 406.17 | 404.84 | 405.7345 | 1159852.0 |
| 2024-02-15 15:00:00 | MSFT | Stock | 405.74 | 407.2 | 405.59 | 406.65 | 2749689.0 |
| 2024-02-15 16:00:00 | MSFT | Stock | 406.56 | 406.56 | 405.05 | 406.25 | 2755754.0 |
| 2024-02-15 17:00:00 | MSFT | Stock | 406.25 | 406.25 | 405.9 | 405.97 | 4864.0 |
| 2024-02-15 18:00:00 | MSFT | Stock | 406.0 | 406.28 | 406.0 | 406.15 | 6113.0 |
| 2024-02-15 19:00:00 | MSFT | Stock | 406.15 | 406.5 | 406.0 | 406.11 | 3032.0 |
| 2024-02-15 04:00:00 | NVDA | Stock | 74.016 | 74.299 | 73.18 | 73.7 | 538840.0 |
| 2024-02-15 05:00:00 | NVDA | Stock | 73.662 | 74.039 | 73.541 | 74.03 | 227750.0 |
| 2024-02-15 06:00:00 | NVDA | Stock | 74.049 | 74.199 | 73.77 | 73.989 | 210760.0 |
| 2024-02-15 07:00:00 | NVDA | Stock | 73.965 | 74.087 | 73.665 | 73.706 | 906560.0 |
| 2024-02-15 08:00:00 | NVDA | Stock | 73.924 | 74.433 | 73.6 | 73.76 | 2829130.0 |
| 2024-02-15 09:00:00 | NVDA | Stock | 73.745 | 73.975 | 72.4 | 72.5033 | 66834040.0 |
| 2024-02-15 10:00:00 | NVDA | Stock | 72.529 | 73.499 | 72.5081 | 73.336 | 58173700.0 |
| 2024-02-15 11:00:00 | NVDA | Stock | 73.329 | 73.367 | 72.684 | 73.02 | 39903750.0 |
| 2024-02-15 12:00:00 | NVDA | Stock | 73.0335 | 73.371 | 72.711 | 73.0653 | 28475970.0 |
| 2024-02-15 13:00:00 | NVDA | Stock | 73.059 | 73.375 | 72.8605 | 73.0241 | 27473010.0 |
| 2024-02-15 14:00:00 | NVDA | Stock | 73.0234 | 73.283 | 72.892 | 73.026 | 25037980.0 |
| 2024-02-15 15:00:00 | NVDA | Stock | 73.0255 | 73.0635 | 72.573 | 72.657 | 39962080.0 |
| 2024-02-15 16:00:00 | NVDA | Stock | 72.658 | 73.127 | 72.658 | 73.0 | 17245120.0 |
| 2024-02-15 17:00:00 | NVDA | Stock | 73.015 | 73.05 | 72.8264 | 72.972 | 671150.0 |
| 2024-02-15 18:00:00 | NVDA | Stock | 72.965 | 73.1 | 72.965 | 73.075 | 568610.0 |
| 2024-02-15 19:00:00 | NVDA | Stock | 73.063 | 73.255 | 73.032 | 73.227 | 1003880.0 |
| 2024-02-15 04:00:00 | AMZN | Stock | 172.28 | 172.28 | 171.29 | 171.62 | 9316.0 |
| 2024-02-15 05:00:00 | AMZN | Stock | 171.68 | 171.72 | 171.4 | 171.46 | 5319.0 |
> showing 50 of 60,369 rows — these rows as CSV