PREVIEW / stock_1hour / 2024-06-27
file: by_date/stock_1hour/2024/2024-06-27.parquet size: 1.3 MB rows: 58,444 symbols: 915
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-06-27 04:00:00 | AAPL | Stock | 213.08 | 213.23 | 212.8 | 213.1 | 4709.0 |
| 2024-06-27 05:00:00 | AAPL | Stock | 213.19 | 214.2 | 213.19 | 213.8 | 17061.0 |
| 2024-06-27 06:00:00 | AAPL | Stock | 213.84 | 214.34 | 213.84 | 213.99 | 10936.0 |
| 2024-06-27 07:00:00 | AAPL | Stock | 214.06 | 214.33 | 213.78 | 214.16 | 35105.0 |
| 2024-06-27 08:00:00 | AAPL | Stock | 213.92 | 214.49 | 213.0 | 214.41 | 155514.0 |
| 2024-06-27 09:00:00 | AAPL | Stock | 214.4195 | 215.7395 | 213.74 | 214.41 | 8202985.0 |
| 2024-06-27 10:00:00 | AAPL | Stock | 214.42 | 214.85 | 212.35 | 213.28 | 6836918.0 |
| 2024-06-27 11:00:00 | AAPL | Stock | 213.275 | 213.68 | 212.57 | 213.205 | 3831260.0 |
| 2024-06-27 12:00:00 | AAPL | Stock | 213.2 | 214.19 | 213.05 | 213.67 | 3118606.0 |
| 2024-06-27 13:00:00 | AAPL | Stock | 213.67 | 214.07 | 213.56 | 213.635 | 2215797.0 |
| 2024-06-27 14:00:00 | AAPL | Stock | 213.635 | 213.785 | 213.05 | 213.74 | 2411703.0 |
| 2024-06-27 15:00:00 | AAPL | Stock | 213.75 | 214.12 | 213.14 | 214.11 | 5499609.0 |
| 2024-06-27 16:00:00 | AAPL | Stock | 214.07 | 214.5 | 213.58 | 214.15 | 7220374.0 |
| 2024-06-27 17:00:00 | AAPL | Stock | 214.15 | 214.28 | 214.0 | 214.19 | 14613.0 |
| 2024-06-27 18:00:00 | AAPL | Stock | 214.1201 | 214.5 | 214.12 | 214.47 | 26610.0 |
| 2024-06-27 19:00:00 | AAPL | Stock | 214.4666 | 214.51 | 214.4 | 214.45 | 23558.0 |
| 2024-06-27 04:00:00 | MSFT | Stock | 451.52 | 451.72 | 451.51 | 451.63 | 1496.0 |
| 2024-06-27 05:00:00 | MSFT | Stock | 451.6 | 452.0 | 451.6 | 452.0 | 590.0 |
| 2024-06-27 06:00:00 | MSFT | Stock | 452.16 | 452.39 | 452.16 | 452.22 | 548.0 |
| 2024-06-27 07:00:00 | MSFT | Stock | 452.2 | 452.25 | 451.69 | 451.84 | 5259.0 |
| 2024-06-27 08:00:00 | MSFT | Stock | 451.9319 | 452.5 | 451.6501 | 452.5 | 14723.0 |
| 2024-06-27 09:00:00 | MSFT | Stock | 452.3 | 455.761 | 451.77 | 454.895 | 1365636.0 |
| 2024-06-27 10:00:00 | MSFT | Stock | 454.85 | 456.17 | 454.45 | 455.32 | 1313656.0 |
| 2024-06-27 11:00:00 | MSFT | Stock | 455.31 | 455.7 | 452.87 | 453.7351 | 750853.0 |
| 2024-06-27 12:00:00 | MSFT | Stock | 453.65 | 454.66 | 453.63 | 453.895 | 536766.0 |
| 2024-06-27 13:00:00 | MSFT | Stock | 453.91 | 454.5493 | 453.28 | 453.54 | 539860.0 |
| 2024-06-27 14:00:00 | MSFT | Stock | 453.49 | 453.5012 | 451.88 | 452.81 | 703715.0 |
| 2024-06-27 15:00:00 | MSFT | Stock | 452.87 | 453.22 | 452.12 | 453.03 | 1481768.0 |
| 2024-06-27 16:00:00 | MSFT | Stock | 452.83 | 453.52 | 451.94 | 452.85 | 3257414.0 |
| 2024-06-27 17:00:00 | MSFT | Stock | 452.55 | 452.75 | 451.77 | 452.633 | 8121.0 |
| 2024-06-27 18:00:00 | MSFT | Stock | 452.5 | 453.52 | 452.5 | 453.12 | 8925.0 |
| 2024-06-27 19:00:00 | MSFT | Stock | 453.5008 | 453.96 | 453.5 | 453.55 | 4503.0 |
| 2024-06-27 04:00:00 | NVDA | Stock | 123.88 | 125.28 | 123.81 | 125.0 | 370279.0 |
| 2024-06-27 05:00:00 | NVDA | Stock | 125.0 | 125.25 | 124.26 | 124.6 | 190184.0 |
| 2024-06-27 06:00:00 | NVDA | Stock | 124.6 | 124.99 | 124.26 | 124.7 | 176878.0 |
| 2024-06-27 07:00:00 | NVDA | Stock | 124.7 | 124.73 | 123.93 | 124.0 | 700992.0 |
| 2024-06-27 08:00:00 | NVDA | Stock | 124.4 | 125.48 | 123.59 | 125.35 | 3360644.0 |
| 2024-06-27 09:00:00 | NVDA | Stock | 125.35 | 126.41 | 123.75 | 124.4205 | 38662153.0 |
| 2024-06-27 10:00:00 | NVDA | Stock | 124.438 | 125.47 | 123.4601 | 124.225 | 36443545.0 |
| 2024-06-27 11:00:00 | NVDA | Stock | 124.23 | 124.3 | 122.94 | 123.4599 | 28806775.0 |
| 2024-06-27 12:00:00 | NVDA | Stock | 123.455 | 124.74 | 123.21 | 124.34 | 21495498.0 |
| 2024-06-27 13:00:00 | NVDA | Stock | 124.32 | 125.08 | 124.08 | 124.57 | 15157884.0 |
| 2024-06-27 14:00:00 | NVDA | Stock | 124.57 | 125.0 | 124.19 | 124.77 | 13926521.0 |
| 2024-06-27 15:00:00 | NVDA | Stock | 124.7899 | 124.82 | 122.92 | 123.985 | 31228871.0 |
| 2024-06-27 16:00:00 | NVDA | Stock | 123.99 | 124.14 | 123.6602 | 123.97 | 19580615.0 |
| 2024-06-27 17:00:00 | NVDA | Stock | 123.97 | 124.19 | 123.93 | 124.03 | 394700.0 |
| 2024-06-27 18:00:00 | NVDA | Stock | 124.03 | 124.15 | 123.9702 | 124.12 | 277471.0 |
| 2024-06-27 19:00:00 | NVDA | Stock | 124.14 | 124.55 | 124.13 | 124.49 | 590418.0 |
| 2024-06-27 04:00:00 | AMZN | Stock | 193.37 | 193.5 | 193.33 | 193.5 | 4786.0 |
| 2024-06-27 05:00:00 | AMZN | Stock | 193.43 | 193.6 | 193.0 | 193.3 | 10960.0 |
> showing 50 of 58,444 rows — these rows as CSV