PREVIEW / stock_30min / 2024-01-24
file: by_date/stock_30min/2024/2024-01-24.parquet size: 2.0 MB rows: 98,553 symbols: 1,167
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-01-24 04:00:00 | AAPL | Stock | 194.9 | 195.49 | 194.9 | 195.05 | 19403.0 |
| 2024-01-24 04:30:00 | AAPL | Stock | 194.99 | 195.0 | 194.82 | 194.83 | 7582.0 |
| 2024-01-24 05:00:00 | AAPL | Stock | 194.85 | 194.9 | 194.75 | 194.75 | 2097.0 |
| 2024-01-24 05:30:00 | AAPL | Stock | 194.73 | 194.82 | 194.73 | 194.8 | 2641.0 |
| 2024-01-24 06:00:00 | AAPL | Stock | 194.8 | 195.08 | 194.8 | 194.95 | 8914.0 |
| 2024-01-24 06:30:00 | AAPL | Stock | 194.98 | 195.3 | 194.98 | 195.29 | 6332.0 |
| 2024-01-24 07:00:00 | AAPL | Stock | 195.0 | 195.25 | 195.0 | 195.1 | 18068.0 |
| 2024-01-24 07:30:00 | AAPL | Stock | 195.08 | 195.55 | 195.08 | 195.41 | 30893.0 |
| 2024-01-24 08:00:00 | AAPL | Stock | 195.13 | 195.58 | 194.61 | 195.45 | 110683.0 |
| 2024-01-24 08:30:00 | AAPL | Stock | 195.4 | 195.48 | 195.2 | 195.39 | 71778.0 |
| 2024-01-24 09:00:00 | AAPL | Stock | 195.42 | 195.52 | 195.22 | 195.41 | 123890.0 |
| 2024-01-24 09:30:00 | AAPL | Stock | 195.41 | 196.38 | 194.91 | 195.08 | 5305926.0 |
| 2024-01-24 10:00:00 | AAPL | Stock | 195.08 | 196.05 | 194.66 | 196.0 | 3659338.0 |
| 2024-01-24 10:30:00 | AAPL | Stock | 195.9901 | 196.34 | 195.67 | 195.91 | 3216493.0 |
| 2024-01-24 11:00:00 | AAPL | Stock | 195.91 | 195.99 | 195.27 | 195.4 | 2397894.0 |
| 2024-01-24 11:30:00 | AAPL | Stock | 195.41 | 195.9 | 195.345 | 195.86 | 1880406.0 |
| 2024-01-24 12:00:00 | AAPL | Stock | 195.86 | 195.896 | 195.51 | 195.75 | 1599632.0 |
| 2024-01-24 12:30:00 | AAPL | Stock | 195.7527 | 196.08 | 195.74 | 195.745 | 1842002.0 |
| 2024-01-24 13:00:00 | AAPL | Stock | 195.74 | 195.74 | 195.215 | 195.655 | 2447390.0 |
| 2024-01-24 13:30:00 | AAPL | Stock | 195.66 | 195.6601 | 195.14 | 195.2899 | 1779482.0 |
| 2024-01-24 14:00:00 | AAPL | Stock | 195.2818 | 195.39 | 194.69 | 194.81 | 1954810.0 |
| 2024-01-24 14:30:00 | AAPL | Stock | 194.81 | 195.2182 | 194.76 | 194.91 | 1833427.0 |
| 2024-01-24 15:00:00 | AAPL | Stock | 194.91 | 195.13 | 194.55 | 194.6567 | 2125481.0 |
| 2024-01-24 15:30:00 | AAPL | Stock | 194.6599 | 195.1 | 194.34 | 194.51 | 4148567.0 |
| 2024-01-24 16:00:00 | AAPL | Stock | 194.5 | 194.54 | 193.91 | 194.06 | 7498399.0 |
| 2024-01-24 16:30:00 | AAPL | Stock | 194.13 | 194.5 | 194.06 | 194.26 | 37740.0 |
| 2024-01-24 17:00:00 | AAPL | Stock | 194.18 | 194.2 | 194.06 | 194.08 | 14767.0 |
| 2024-01-24 17:30:00 | AAPL | Stock | 194.14 | 194.14 | 194.03 | 194.07 | 7482.0 |
| 2024-01-24 18:00:00 | AAPL | Stock | 194.05 | 194.09 | 193.87 | 193.87 | 11311.0 |
| 2024-01-24 18:30:00 | AAPL | Stock | 193.879 | 194.1 | 193.82 | 194.1 | 12809.0 |
| 2024-01-24 19:00:00 | AAPL | Stock | 194.1 | 194.15 | 193.96 | 194.0 | 5744.0 |
| 2024-01-24 19:30:00 | AAPL | Stock | 193.97 | 194.04 | 193.9 | 193.91 | 14351.0 |
| 2024-01-24 04:00:00 | MSFT | Stock | 401.74 | 402.66 | 401.5 | 402.65 | 4515.0 |
| 2024-01-24 04:30:00 | MSFT | Stock | 402.54 | 402.8 | 402.5 | 402.8 | 1431.0 |
| 2024-01-24 05:00:00 | MSFT | Stock | 402.55 | 402.55 | 402.22 | 402.22 | 2203.0 |
| 2024-01-24 05:30:00 | MSFT | Stock | 402.37 | 402.55 | 402.35 | 402.5 | 1581.0 |
| 2024-01-24 06:00:00 | MSFT | Stock | 402.53 | 402.62 | 402.2 | 402.2 | 3266.0 |
| 2024-01-24 06:30:00 | MSFT | Stock | 402.11 | 402.11 | 401.75 | 401.75 | 958.0 |
| 2024-01-24 07:00:00 | MSFT | Stock | 401.99 | 402.32 | 401.5 | 401.55 | 15791.0 |
| 2024-01-24 07:30:00 | MSFT | Stock | 401.72 | 401.93 | 401.5 | 401.82 | 7813.0 |
| 2024-01-24 08:00:00 | MSFT | Stock | 402.29 | 402.3 | 401.0 | 401.92 | 57997.0 |
| 2024-01-24 08:30:00 | MSFT | Stock | 401.7 | 401.86 | 401.02 | 401.5 | 14741.0 |
| 2024-01-24 09:00:00 | MSFT | Stock | 401.5 | 401.92 | 401.27 | 401.53 | 46495.0 |
| 2024-01-24 09:30:00 | MSFT | Stock | 401.61 | 402.7 | 400.45 | 402.67 | 2361543.0 |
| 2024-01-24 10:00:00 | MSFT | Stock | 402.67 | 403.95 | 402.12 | 403.7751 | 1328858.0 |
| 2024-01-24 10:30:00 | MSFT | Stock | 403.78 | 404.72 | 403.47 | 403.4952 | 1036178.0 |
| 2024-01-24 11:00:00 | MSFT | Stock | 403.51 | 403.79 | 402.5 | 403.35 | 969827.0 |
| 2024-01-24 11:30:00 | MSFT | Stock | 403.352 | 404.22 | 402.86 | 404.08 | 652391.0 |
| 2024-01-24 12:00:00 | MSFT | Stock | 404.09 | 404.99 | 403.9447 | 404.77 | 737404.0 |
| 2024-01-24 12:30:00 | MSFT | Stock | 404.79 | 405.63 | 404.56 | 405.332 | 689405.0 |
> showing 50 of 98,553 rows — these rows as CSV