PREVIEW / stock_1hour / 2024-04-18
file: by_date/stock_1hour/2024/2024-04-18.parquet size: 1.3 MB rows: 57,494 symbols: 990
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-04-18 04:00:00 | AAPL | Stock | 168.8 | 169.0 | 168.37 | 168.48 | 16092.0 |
| 2024-04-18 05:00:00 | AAPL | Stock | 168.48 | 168.66 | 168.09 | 168.41 | 17859.0 |
| 2024-04-18 06:00:00 | AAPL | Stock | 168.39 | 168.4 | 168.1 | 168.3 | 6450.0 |
| 2024-04-18 07:00:00 | AAPL | Stock | 168.37 | 168.5 | 167.84 | 167.95 | 41760.0 |
| 2024-04-18 08:00:00 | AAPL | Stock | 168.42 | 169.0 | 167.14 | 167.58 | 156730.0 |
| 2024-04-18 09:00:00 | AAPL | Stock | 167.64 | 168.64 | 167.5 | 167.7001 | 4668714.0 |
| 2024-04-18 10:00:00 | AAPL | Stock | 167.7 | 168.28 | 167.33 | 168.16 | 5085333.0 |
| 2024-04-18 11:00:00 | AAPL | Stock | 168.16 | 168.245 | 167.78 | 167.84 | 3011359.0 |
| 2024-04-18 12:00:00 | AAPL | Stock | 167.84 | 167.96 | 166.74 | 166.81 | 4166448.0 |
| 2024-04-18 13:00:00 | AAPL | Stock | 166.8007 | 167.12 | 166.55 | 166.84 | 3701503.0 |
| 2024-04-18 14:00:00 | AAPL | Stock | 166.84 | 167.11 | 166.63 | 166.73 | 3085250.0 |
| 2024-04-18 15:00:00 | AAPL | Stock | 166.73 | 167.375 | 166.72 | 167.0101 | 5258374.0 |
| 2024-04-18 16:00:00 | AAPL | Stock | 167.01 | 167.44 | 166.92 | 166.97 | 4266634.0 |
| 2024-04-18 17:00:00 | AAPL | Stock | 166.98 | 166.98 | 166.85 | 166.89 | 26987.0 |
| 2024-04-18 18:00:00 | AAPL | Stock | 166.9 | 167.1 | 166.85 | 166.8526 | 32406.0 |
| 2024-04-18 19:00:00 | AAPL | Stock | 166.85 | 166.87 | 166.6 | 166.8 | 38095.0 |
| 2024-04-18 04:00:00 | MSFT | Stock | 414.1 | 414.1 | 412.5 | 413.28 | 2383.0 |
| 2024-04-18 05:00:00 | MSFT | Stock | 413.07 | 413.07 | 412.0 | 412.9 | 3131.0 |
| 2024-04-18 06:00:00 | MSFT | Stock | 412.9 | 413.24 | 412.58 | 413.0 | 1718.0 |
| 2024-04-18 07:00:00 | MSFT | Stock | 412.84 | 413.11 | 412.75 | 413.01 | 8289.0 |
| 2024-04-18 08:00:00 | MSFT | Stock | 412.89 | 414.46 | 412.3501 | 412.84 | 25807.0 |
| 2024-04-18 09:00:00 | MSFT | Stock | 412.6 | 412.94 | 407.46 | 408.295 | 1506549.0 |
| 2024-04-18 10:00:00 | MSFT | Stock | 408.25 | 411.43 | 407.09 | 410.45 | 1817459.0 |
| 2024-04-18 11:00:00 | MSFT | Stock | 410.495 | 411.89 | 410.25 | 411.3301 | 922754.0 |
| 2024-04-18 12:00:00 | MSFT | Stock | 411.34 | 411.68 | 407.66 | 407.75 | 737025.0 |
| 2024-04-18 13:00:00 | MSFT | Stock | 407.75 | 408.24 | 406.05 | 406.17 | 852508.0 |
| 2024-04-18 14:00:00 | MSFT | Stock | 406.17 | 406.77 | 404.78 | 404.93 | 1166593.0 |
| 2024-04-18 15:00:00 | MSFT | Stock | 404.9 | 406.16 | 403.95 | 404.15 | 1961323.0 |
| 2024-04-18 16:00:00 | MSFT | Stock | 404.41 | 404.63 | 403.51 | 403.88 | 3049537.0 |
| 2024-04-18 17:00:00 | MSFT | Stock | 403.91 | 403.91 | 403.6 | 403.66 | 10295.0 |
| 2024-04-18 18:00:00 | MSFT | Stock | 403.7 | 404.44 | 403.62 | 404.22 | 12336.0 |
| 2024-04-18 19:00:00 | MSFT | Stock | 404.22 | 404.34 | 403.65 | 403.79 | 12198.0 |
| 2024-04-18 04:00:00 | NVDA | Stock | 85.55 | 85.571 | 84.88 | 85.15 | 315490.0 |
| 2024-04-18 05:00:00 | NVDA | Stock | 85.15 | 85.45 | 84.403 | 84.531 | 307560.0 |
| 2024-04-18 06:00:00 | NVDA | Stock | 84.553 | 84.88 | 84.356 | 84.7 | 146690.0 |
| 2024-04-18 07:00:00 | NVDA | Stock | 84.679 | 85.476 | 84.662 | 85.3 | 971090.0 |
| 2024-04-18 08:00:00 | NVDA | Stock | 84.798 | 86.625 | 84.699 | 84.9 | 2550610.0 |
| 2024-04-18 09:00:00 | NVDA | Stock | 84.9 | 85.2 | 82.402 | 84.2418 | 66486620.0 |
| 2024-04-18 10:00:00 | NVDA | Stock | 84.241 | 85.649 | 83.835 | 85.369 | 62051550.0 |
| 2024-04-18 11:00:00 | NVDA | Stock | 85.36 | 86.034 | 85.055 | 85.798 | 38239850.0 |
| 2024-04-18 12:00:00 | NVDA | Stock | 85.79 | 86.19 | 85.051 | 85.103 | 35337730.0 |
| 2024-04-18 13:00:00 | NVDA | Stock | 85.1137 | 85.231 | 84.1 | 84.588 | 42885020.0 |
| 2024-04-18 14:00:00 | NVDA | Stock | 84.5795 | 84.85 | 84.223 | 84.398 | 24217350.0 |
| 2024-04-18 15:00:00 | NVDA | Stock | 84.393 | 85.166 | 84.361 | 84.658 | 35477900.0 |
| 2024-04-18 16:00:00 | NVDA | Stock | 84.671 | 84.86 | 84.405 | 84.58 | 13168300.0 |
| 2024-04-18 17:00:00 | NVDA | Stock | 84.594 | 84.595 | 83.9906 | 84.42 | 426310.0 |
| 2024-04-18 18:00:00 | NVDA | Stock | 84.444 | 84.671 | 84.444 | 84.515 | 349410.0 |
| 2024-04-18 19:00:00 | NVDA | Stock | 84.525 | 84.525 | 84.2 | 84.2 | 325900.0 |
| 2024-04-18 04:00:00 | AMZN | Stock | 181.31 | 182.1 | 181.31 | 181.9 | 7192.0 |
| 2024-04-18 05:00:00 | AMZN | Stock | 181.9 | 181.97 | 181.68 | 181.87 | 5024.0 |
> showing 50 of 57,494 rows — these rows as CSV