PREVIEW / stock_30min / 2024-01-31
file: by_date/stock_30min/2024/2024-01-31.parquet size: 2.0 MB rows: 98,787 symbols: 1,184
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-31 04:00:00 | AAPL | Stock | 186.98 | 187.25 | 186.3 | 186.41 | 23692.0 |
| 2024-01-31 04:30:00 | AAPL | Stock | 186.41 | 186.71 | 186.3 | 186.68 | 4132.0 |
| 2024-01-31 05:00:00 | AAPL | Stock | 186.7 | 186.91 | 186.7 | 186.91 | 4508.0 |
| 2024-01-31 05:30:00 | AAPL | Stock | 186.88 | 186.95 | 186.78 | 186.78 | 5923.0 |
| 2024-01-31 06:00:00 | AAPL | Stock | 186.75 | 187.19 | 186.55 | 187.19 | 6855.0 |
| 2024-01-31 06:30:00 | AAPL | Stock | 187.15 | 187.28 | 187.09 | 187.2 | 5508.0 |
| 2024-01-31 07:00:00 | AAPL | Stock | 187.21 | 187.39 | 187.15 | 187.3 | 27557.0 |
| 2024-01-31 07:30:00 | AAPL | Stock | 187.3 | 187.84 | 187.14 | 187.84 | 13276.0 |
| 2024-01-31 08:00:00 | AAPL | Stock | 187.2108 | 187.9 | 186.52 | 187.59 | 75306.0 |
| 2024-01-31 08:30:00 | AAPL | Stock | 187.68 | 187.9392 | 187.461 | 187.6 | 16891.0 |
| 2024-01-31 09:00:00 | AAPL | Stock | 187.64 | 187.64 | 186.65 | 187.09 | 109597.0 |
| 2024-01-31 09:30:00 | AAPL | Stock | 187.13 | 187.15 | 184.79 | 185.195 | 6515242.0 |
| 2024-01-31 10:00:00 | AAPL | Stock | 185.19 | 185.78 | 184.95 | 185.015 | 3016552.0 |
| 2024-01-31 10:30:00 | AAPL | Stock | 185.02 | 185.44 | 184.9 | 185.29 | 2362105.0 |
| 2024-01-31 11:00:00 | AAPL | Stock | 185.3 | 185.87 | 185.295 | 185.7199 | 1653653.0 |
| 2024-01-31 11:30:00 | AAPL | Stock | 185.72 | 185.86 | 185.42 | 185.685 | 1404839.0 |
| 2024-01-31 12:00:00 | AAPL | Stock | 185.685 | 186.11 | 185.6119 | 186.09 | 1293985.0 |
| 2024-01-31 12:30:00 | AAPL | Stock | 186.08 | 186.34 | 185.8333 | 186.325 | 1355992.0 |
| 2024-01-31 13:00:00 | AAPL | Stock | 186.33 | 186.44 | 186.075 | 186.16 | 1234105.0 |
| 2024-01-31 13:30:00 | AAPL | Stock | 186.17 | 186.53 | 186.1 | 186.18 | 1326320.0 |
| 2024-01-31 14:00:00 | AAPL | Stock | 186.17 | 186.32 | 185.26 | 185.67 | 2092671.0 |
| 2024-01-31 14:30:00 | AAPL | Stock | 185.67 | 186.94 | 185.46 | 185.97 | 2484267.0 |
| 2024-01-31 15:00:00 | AAPL | Stock | 185.98 | 186.03 | 185.035 | 185.52 | 2714885.0 |
| 2024-01-31 15:30:00 | AAPL | Stock | 185.52 | 185.5887 | 184.35 | 184.36 | 5126592.0 |
| 2024-01-31 16:00:00 | AAPL | Stock | 184.44 | 185.93 | 184.4 | 185.55 | 10455785.0 |
| 2024-01-31 16:30:00 | AAPL | Stock | 185.56 | 185.69 | 184.4 | 184.83 | 270675.0 |
| 2024-01-31 17:00:00 | AAPL | Stock | 184.92 | 185.24 | 184.8 | 185.15 | 33314.0 |
| 2024-01-31 17:30:00 | AAPL | Stock | 185.14 | 185.29 | 184.85 | 185.1 | 9875.0 |
| 2024-01-31 18:00:00 | AAPL | Stock | 185.2887 | 185.29 | 184.86 | 185.28 | 10802.0 |
| 2024-01-31 18:30:00 | AAPL | Stock | 185.28 | 185.45 | 185.23 | 185.23 | 14660.0 |
| 2024-01-31 19:00:00 | AAPL | Stock | 185.37 | 185.45 | 185.22 | 185.31 | 9695.0 |
| 2024-01-31 19:30:00 | AAPL | Stock | 185.36 | 185.75 | 185.36 | 185.7 | 17606.0 |
| 2024-01-31 04:00:00 | MSFT | Stock | 406.44 | 407.3 | 400.91 | 401.21 | 35463.0 |
| 2024-01-31 04:30:00 | MSFT | Stock | 401.39 | 402.45 | 399.0 | 402.26 | 48677.0 |
| 2024-01-31 05:00:00 | MSFT | Stock | 402.02 | 402.79 | 401.78 | 402.0 | 10020.0 |
| 2024-01-31 05:30:00 | MSFT | Stock | 402.42 | 403.7 | 402.42 | 403.3 | 11703.0 |
| 2024-01-31 06:00:00 | MSFT | Stock | 402.63 | 404.7 | 401.7 | 404.7 | 14841.0 |
| 2024-01-31 06:30:00 | MSFT | Stock | 404.85 | 405.17 | 404.35 | 405.17 | 12197.0 |
| 2024-01-31 07:00:00 | MSFT | Stock | 405.42 | 405.87 | 404.5 | 405.45 | 61267.0 |
| 2024-01-31 07:30:00 | MSFT | Stock | 405.5 | 407.5 | 405.06 | 407.35 | 48879.0 |
| 2024-01-31 08:00:00 | MSFT | Stock | 405.8 | 408.5 | 404.35 | 408.44 | 195259.0 |
| 2024-01-31 08:30:00 | MSFT | Stock | 408.44 | 408.72 | 405.5109 | 406.1 | 114209.0 |
| 2024-01-31 09:00:00 | MSFT | Stock | 406.04 | 407.85 | 405.32 | 407.16 | 122707.0 |
| 2024-01-31 09:30:00 | MSFT | Stock | 406.96 | 415.32 | 405.17 | 406.545 | 7566739.0 |
| 2024-01-31 10:00:00 | MSFT | Stock | 406.59 | 406.74 | 402.55 | 402.9 | 3283432.0 |
| 2024-01-31 10:30:00 | MSFT | Stock | 402.89 | 403.8 | 402.68 | 403.34 | 1644279.0 |
| 2024-01-31 11:00:00 | MSFT | Stock | 403.3001 | 405.28 | 403.2871 | 403.64 | 1419615.0 |
| 2024-01-31 11:30:00 | MSFT | Stock | 403.678 | 403.805 | 402.11 | 402.88 | 1414335.0 |
| 2024-01-31 12:00:00 | MSFT | Stock | 402.89 | 403.75 | 402.0 | 402.1195 | 1018936.0 |
| 2024-01-31 12:30:00 | MSFT | Stock | 402.117 | 402.51 | 401.32 | 402.38 | 1026795.0 |
> showing 50 of 98,787 rows — these rows as CSV