PREVIEW / stock_30min / 2024-02-20
file: by_date/stock_30min/2024/2024-02-20.parquet size: 2.1 MB rows: 103,177 symbols: 1,124
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-20 04:00:00 | AAPL | Stock | 181.7 | 181.9 | 181.5 | 181.51 | 8374.0 |
| 2024-02-20 04:30:00 | AAPL | Stock | 181.43 | 181.51 | 181.15 | 181.48 | 11661.0 |
| 2024-02-20 05:00:00 | AAPL | Stock | 181.32 | 181.44 | 181.15 | 181.2 | 3112.0 |
| 2024-02-20 05:30:00 | AAPL | Stock | 181.27 | 181.43 | 181.27 | 181.38 | 3424.0 |
| 2024-02-20 06:00:00 | AAPL | Stock | 181.4 | 181.5 | 181.25 | 181.49 | 4630.0 |
| 2024-02-20 06:30:00 | AAPL | Stock | 181.5 | 181.65 | 181.5 | 181.59 | 3108.0 |
| 2024-02-20 07:00:00 | AAPL | Stock | 181.65 | 182.05 | 181.5 | 181.83 | 19435.0 |
| 2024-02-20 07:30:00 | AAPL | Stock | 181.79 | 181.9 | 181.75 | 181.89 | 9438.0 |
| 2024-02-20 08:00:00 | AAPL | Stock | 181.9 | 182.0 | 181.14 | 181.7 | 50126.0 |
| 2024-02-20 08:30:00 | AAPL | Stock | 181.7 | 182.57 | 181.7 | 182.21 | 81305.0 |
| 2024-02-20 09:00:00 | AAPL | Stock | 182.24 | 182.55 | 181.17 | 181.72 | 155731.0 |
| 2024-02-20 09:30:00 | AAPL | Stock | 181.77 | 182.43 | 180.68 | 180.835 | 5914291.0 |
| 2024-02-20 10:00:00 | AAPL | Stock | 180.83 | 180.835 | 180.245 | 180.46 | 3099300.0 |
| 2024-02-20 10:30:00 | AAPL | Stock | 180.46 | 180.82 | 180.0 | 180.735 | 2981267.0 |
| 2024-02-20 11:00:00 | AAPL | Stock | 180.73 | 181.165 | 180.7 | 181.125 | 2041550.0 |
| 2024-02-20 11:30:00 | AAPL | Stock | 181.13 | 181.37 | 180.84 | 181.085 | 2468084.0 |
| 2024-02-20 12:00:00 | AAPL | Stock | 181.1 | 181.1261 | 180.6 | 180.745 | 2066694.0 |
| 2024-02-20 12:30:00 | AAPL | Stock | 180.745 | 180.94 | 180.49 | 180.755 | 1509493.0 |
| 2024-02-20 13:00:00 | AAPL | Stock | 180.745 | 180.95 | 180.44 | 180.51 | 1542658.0 |
| 2024-02-20 13:30:00 | AAPL | Stock | 180.505 | 180.84 | 180.4 | 180.7302 | 1259513.0 |
| 2024-02-20 14:00:00 | AAPL | Stock | 180.73 | 180.79 | 180.41 | 180.69 | 1279558.0 |
| 2024-02-20 14:30:00 | AAPL | Stock | 180.69 | 180.91 | 180.47 | 180.9 | 1210279.0 |
| 2024-02-20 15:00:00 | AAPL | Stock | 180.91 | 181.46 | 180.86 | 181.3827 | 1849115.0 |
| 2024-02-20 15:30:00 | AAPL | Stock | 181.39 | 181.66 | 180.86 | 181.62 | 5060765.0 |
| 2024-02-20 16:00:00 | AAPL | Stock | 181.63 | 181.63 | 181.31 | 181.5 | 5595441.0 |
| 2024-02-20 16:30:00 | AAPL | Stock | 181.5 | 181.8 | 181.47 | 181.68 | 66102.0 |
| 2024-02-20 17:00:00 | AAPL | Stock | 181.68 | 181.77 | 181.62 | 181.72 | 17405.0 |
| 2024-02-20 17:30:00 | AAPL | Stock | 181.65 | 181.68 | 181.52 | 181.55 | 7327.0 |
| 2024-02-20 18:00:00 | AAPL | Stock | 181.6 | 181.88 | 181.58 | 181.82 | 21154.0 |
| 2024-02-20 18:30:00 | AAPL | Stock | 181.82 | 181.87 | 181.61 | 181.7 | 5740.0 |
| 2024-02-20 19:00:00 | AAPL | Stock | 181.66 | 181.95 | 181.6401 | 181.85 | 6009.0 |
| 2024-02-20 19:30:00 | AAPL | Stock | 181.77 | 181.9599 | 181.7 | 181.7 | 14194.0 |
| 2024-02-20 04:00:00 | MSFT | Stock | 403.66 | 404.1 | 402.4 | 403.5 | 8566.0 |
| 2024-02-20 04:30:00 | MSFT | Stock | 403.2 | 403.2 | 402.2 | 402.2 | 2324.0 |
| 2024-02-20 05:00:00 | MSFT | Stock | 402.0 | 402.0 | 400.11 | 400.25 | 7286.0 |
| 2024-02-20 05:30:00 | MSFT | Stock | 400.43 | 400.77 | 400.3 | 400.53 | 3422.0 |
| 2024-02-20 06:00:00 | MSFT | Stock | 400.54 | 401.09 | 400.49 | 401.09 | 1971.0 |
| 2024-02-20 06:30:00 | MSFT | Stock | 401.1 | 401.1 | 400.35 | 400.9 | 3044.0 |
| 2024-02-20 07:00:00 | MSFT | Stock | 401.0 | 403.88 | 401.0 | 403.06 | 11946.0 |
| 2024-02-20 07:30:00 | MSFT | Stock | 403.13 | 403.13 | 401.85 | 401.96 | 6123.0 |
| 2024-02-20 08:00:00 | MSFT | Stock | 401.4 | 404.5 | 401.3 | 403.48 | 53597.0 |
| 2024-02-20 08:30:00 | MSFT | Stock | 403.5 | 403.88 | 403.1 | 403.35 | 12764.0 |
| 2024-02-20 09:00:00 | MSFT | Stock | 403.15 | 403.52 | 401.85 | 402.9 | 21170.0 |
| 2024-02-20 09:30:00 | MSFT | Stock | 403.33 | 404.49 | 399.55 | 399.75 | 2779745.0 |
| 2024-02-20 10:00:00 | MSFT | Stock | 399.725 | 399.85 | 398.59 | 399.22 | 1254735.0 |
| 2024-02-20 10:30:00 | MSFT | Stock | 399.22 | 400.55 | 398.01 | 400.55 | 943366.0 |
| 2024-02-20 11:00:00 | MSFT | Stock | 400.58 | 402.18 | 400.51 | 401.86 | 676301.0 |
| 2024-02-20 11:30:00 | MSFT | Stock | 401.84 | 401.84 | 399.8 | 399.81 | 605080.0 |
| 2024-02-20 12:00:00 | MSFT | Stock | 399.785 | 399.98 | 398.96 | 399.05 | 459257.0 |
| 2024-02-20 12:30:00 | MSFT | Stock | 399.04 | 399.8199 | 398.48 | 399.58 | 548437.0 |
> showing 50 of 103,177 rows — these rows as CSV