PREVIEW / stock_1hour / 2024-02-29
file: by_date/stock_1hour/2024/2024-02-29.parquet size: 1.4 MB rows: 61,494 symbols: 1,101
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-29 04:00:00 | AAPL | Stock | 180.89 | 181.08 | 180.6 | 180.97 | 12722.0 |
| 2024-02-29 05:00:00 | AAPL | Stock | 180.96 | 181.19 | 180.29 | 180.76 | 41769.0 |
| 2024-02-29 06:00:00 | AAPL | Stock | 180.8 | 180.92 | 180.7 | 180.92 | 6719.0 |
| 2024-02-29 07:00:00 | AAPL | Stock | 181.0 | 181.0 | 180.4 | 180.51 | 19288.0 |
| 2024-02-29 08:00:00 | AAPL | Stock | 180.89 | 181.85 | 180.4 | 181.62 | 251767.0 |
| 2024-02-29 09:00:00 | AAPL | Stock | 181.62 | 182.57 | 181.0 | 181.5 | 6303916.0 |
| 2024-02-29 10:00:00 | AAPL | Stock | 181.5 | 182.135 | 180.71 | 180.9499 | 7299039.0 |
| 2024-02-29 11:00:00 | AAPL | Stock | 180.955 | 180.965 | 179.53 | 180.11 | 7115635.0 |
| 2024-02-29 12:00:00 | AAPL | Stock | 180.105 | 180.31 | 179.65 | 180.145 | 5128485.0 |
| 2024-02-29 13:00:00 | AAPL | Stock | 180.145 | 180.8 | 179.68 | 180.085 | 5431495.0 |
| 2024-02-29 14:00:00 | AAPL | Stock | 180.085 | 180.49 | 179.86 | 180.2 | 4753543.0 |
| 2024-02-29 15:00:00 | AAPL | Stock | 180.2 | 181.11 | 179.57 | 180.77 | 14317676.0 |
| 2024-02-29 16:00:00 | AAPL | Stock | 180.73 | 180.96 | 180.35 | 180.89 | 55023979.0 |
| 2024-02-29 17:00:00 | AAPL | Stock | 180.88 | 180.89 | 180.5 | 180.6013 | 220765.0 |
| 2024-02-29 18:00:00 | AAPL | Stock | 180.6 | 180.66 | 180.2 | 180.3059 | 46287.0 |
| 2024-02-29 19:00:00 | AAPL | Stock | 180.3 | 180.67 | 180.3 | 180.63 | 30153.0 |
| 2024-02-29 04:00:00 | MSFT | Stock | 405.99 | 405.99 | 405.37 | 405.67 | 4290.0 |
| 2024-02-29 05:00:00 | MSFT | Stock | 405.6 | 406.85 | 405.6 | 405.7 | 4795.0 |
| 2024-02-29 06:00:00 | MSFT | Stock | 405.69 | 406.56 | 405.65 | 406.56 | 5269.0 |
| 2024-02-29 07:00:00 | MSFT | Stock | 406.85 | 406.85 | 406.14 | 406.14 | 2520.0 |
| 2024-02-29 08:00:00 | MSFT | Stock | 406.15 | 409.75 | 405.09 | 409.2 | 71269.0 |
| 2024-02-29 09:00:00 | MSFT | Stock | 409.22 | 410.205 | 407.74 | 409.81 | 2049585.0 |
| 2024-02-29 10:00:00 | MSFT | Stock | 409.81 | 410.12 | 407.43 | 407.75 | 1633988.0 |
| 2024-02-29 11:00:00 | MSFT | Stock | 407.8 | 408.7 | 405.92 | 407.7468 | 1133668.0 |
| 2024-02-29 12:00:00 | MSFT | Stock | 407.74 | 408.93 | 407.52 | 408.66 | 754493.0 |
| 2024-02-29 13:00:00 | MSFT | Stock | 408.73 | 409.685 | 408.62 | 409.65 | 793073.0 |
| 2024-02-29 14:00:00 | MSFT | Stock | 409.68 | 410.22 | 409.2 | 409.885 | 1014348.0 |
| 2024-02-29 15:00:00 | MSFT | Stock | 409.9 | 414.2 | 409.66 | 413.42 | 3916630.0 |
| 2024-02-29 16:00:00 | MSFT | Stock | 413.38 | 413.82 | 412.76 | 412.83 | 10740277.0 |
| 2024-02-29 17:00:00 | MSFT | Stock | 412.81 | 413.64 | 412.81 | 413.05 | 92434.0 |
| 2024-02-29 18:00:00 | MSFT | Stock | 413.02 | 413.26 | 411.85 | 412.5 | 12569.0 |
| 2024-02-29 19:00:00 | MSFT | Stock | 412.8 | 413.3 | 412.6 | 412.7 | 9951.0 |
| 2024-02-29 04:00:00 | NVDA | Stock | 77.31 | 77.4 | 77.24 | 77.354 | 65540.0 |
| 2024-02-29 05:00:00 | NVDA | Stock | 77.34 | 77.489 | 77.286 | 77.489 | 74330.0 |
| 2024-02-29 06:00:00 | NVDA | Stock | 77.5 | 77.75 | 77.5 | 77.531 | 81990.0 |
| 2024-02-29 07:00:00 | NVDA | Stock | 77.579 | 78.176 | 77.477 | 77.95 | 601400.0 |
| 2024-02-29 08:00:00 | NVDA | Stock | 77.53 | 78.9 | 77.305 | 78.685 | 5589380.0 |
| 2024-02-29 09:00:00 | NVDA | Stock | 78.697 | 79.915 | 78.696 | 79.4779 | 67377500.0 |
| 2024-02-29 10:00:00 | NVDA | Stock | 79.468 | 79.785 | 79.11 | 79.3447 | 51622030.0 |
| 2024-02-29 11:00:00 | NVDA | Stock | 79.329 | 79.372 | 78.35 | 78.9945 | 40902040.0 |
| 2024-02-29 12:00:00 | NVDA | Stock | 78.98 | 79.24 | 78.847 | 79.095 | 24411340.0 |
| 2024-02-29 13:00:00 | NVDA | Stock | 79.096 | 79.397 | 79.0366 | 79.213 | 20999820.0 |
| 2024-02-29 14:00:00 | NVDA | Stock | 79.213 | 79.514 | 79.158 | 79.3938 | 22488920.0 |
| 2024-02-29 15:00:00 | NVDA | Stock | 79.4015 | 79.99 | 78.9 | 79.218 | 49492120.0 |
| 2024-02-29 16:00:00 | NVDA | Stock | 79.112 | 79.764 | 79.112 | 79.675 | 99369990.0 |
| 2024-02-29 17:00:00 | NVDA | Stock | 79.677 | 79.718 | 79.112 | 79.58 | 738550.0 |
| 2024-02-29 18:00:00 | NVDA | Stock | 79.56 | 79.64 | 79.525 | 79.5727 | 419180.0 |
| 2024-02-29 19:00:00 | NVDA | Stock | 79.589 | 79.782 | 79.589 | 79.738 | 829590.0 |
| 2024-02-29 04:00:00 | AMZN | Stock | 172.16 | 172.16 | 171.68 | 171.93 | 10983.0 |
| 2024-02-29 05:00:00 | AMZN | Stock | 171.95 | 171.95 | 171.54 | 171.65 | 7715.0 |
> showing 50 of 61,494 rows — these rows as CSV