PREVIEW / stock_30min / 2023-11-22
file: by_date/stock_30min/2023/2023-11-22.parquet size: 2.0 MB rows: 95,727 symbols: 1,302
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-22 04:00:00 | AAPL | Stock | 190.38 | 190.5 | 190.38 | 190.46 | 4125.0 |
| 2023-11-22 04:30:00 | AAPL | Stock | 190.5 | 190.5 | 190.4 | 190.5 | 3170.0 |
| 2023-11-22 05:00:00 | AAPL | Stock | 190.51 | 190.66 | 190.5 | 190.63 | 1281.0 |
| 2023-11-22 05:30:00 | AAPL | Stock | 190.61 | 190.98 | 190.58 | 190.88 | 5712.0 |
| 2023-11-22 06:00:00 | AAPL | Stock | 190.8 | 190.94 | 190.71 | 190.94 | 3861.0 |
| 2023-11-22 06:30:00 | AAPL | Stock | 190.9 | 190.9 | 190.69 | 190.7 | 2010.0 |
| 2023-11-22 07:00:00 | AAPL | Stock | 190.7 | 191.15 | 190.69 | 191.07 | 27988.0 |
| 2023-11-22 07:30:00 | AAPL | Stock | 191.03 | 191.14 | 190.92 | 191.02 | 13749.0 |
| 2023-11-22 08:00:00 | AAPL | Stock | 190.72 | 191.15 | 190.1 | 191.12 | 66649.0 |
| 2023-11-22 08:30:00 | AAPL | Stock | 191.1 | 191.18 | 190.9 | 191.1785 | 52604.0 |
| 2023-11-22 09:00:00 | AAPL | Stock | 191.15 | 191.5 | 191.11 | 191.48 | 89412.0 |
| 2023-11-22 09:30:00 | AAPL | Stock | 191.49 | 192.93 | 191.465 | 191.9125 | 6749863.0 |
| 2023-11-22 10:00:00 | AAPL | Stock | 191.92 | 192.15 | 191.43 | 191.9315 | 2882636.0 |
| 2023-11-22 10:30:00 | AAPL | Stock | 191.95 | 192.37 | 191.39 | 191.45 | 2473129.0 |
| 2023-11-22 11:00:00 | AAPL | Stock | 191.455 | 191.865 | 191.44 | 191.66 | 1678361.0 |
| 2023-11-22 11:30:00 | AAPL | Stock | 191.66 | 191.8499 | 191.48 | 191.6623 | 1369771.0 |
| 2023-11-22 12:00:00 | AAPL | Stock | 191.665 | 191.96 | 191.55 | 191.915 | 1510601.0 |
| 2023-11-22 12:30:00 | AAPL | Stock | 191.915 | 191.945 | 191.64 | 191.905 | 1515511.0 |
| 2023-11-22 13:00:00 | AAPL | Stock | 191.9 | 192.09 | 191.68 | 192.005 | 1485430.0 |
| 2023-11-22 13:30:00 | AAPL | Stock | 192.01 | 192.0303 | 191.53 | 191.63 | 1623805.0 |
| 2023-11-22 14:00:00 | AAPL | Stock | 191.62 | 191.71 | 191.49 | 191.635 | 1322031.0 |
| 2023-11-22 14:30:00 | AAPL | Stock | 191.64 | 191.64 | 190.825 | 191.3501 | 1948221.0 |
| 2023-11-22 15:00:00 | AAPL | Stock | 191.35 | 191.555 | 191.22 | 191.52 | 1504341.0 |
| 2023-11-22 15:30:00 | AAPL | Stock | 191.515 | 191.7 | 191.22 | 191.3 | 3041603.0 |
| 2023-11-22 16:00:00 | AAPL | Stock | 191.3 | 191.47 | 191.23 | 191.28 | 4422802.0 |
| 2023-11-22 16:30:00 | AAPL | Stock | 191.28 | 191.31 | 191.24 | 191.3 | 22863.0 |
| 2023-11-22 17:00:00 | AAPL | Stock | 191.35 | 191.35 | 191.25 | 191.25 | 71221.0 |
| 2023-11-22 17:30:00 | AAPL | Stock | 191.2344 | 191.31 | 191.23 | 191.31 | 5867.0 |
| 2023-11-22 18:00:00 | AAPL | Stock | 191.32 | 191.34 | 191.27 | 191.3 | 3792.0 |
| 2023-11-22 18:30:00 | AAPL | Stock | 191.3 | 191.31 | 191.22 | 191.31 | 545.0 |
| 2023-11-22 19:00:00 | AAPL | Stock | 191.25 | 191.31 | 191.25 | 191.26 | 2691.0 |
| 2023-11-22 19:30:00 | AAPL | Stock | 191.26 | 191.29 | 191.22 | 191.26 | 4921.0 |
| 2023-11-22 04:00:00 | MSFT | Stock | 372.57 | 374.69 | 372.57 | 374.5 | 4561.0 |
| 2023-11-22 04:30:00 | MSFT | Stock | 374.49 | 374.88 | 374.3 | 374.72 | 2950.0 |
| 2023-11-22 05:00:00 | MSFT | Stock | 374.7 | 375.17 | 374.69 | 375.1 | 2709.0 |
| 2023-11-22 05:30:00 | MSFT | Stock | 374.9 | 375.45 | 374.88 | 375.4 | 1612.0 |
| 2023-11-22 06:00:00 | MSFT | Stock | 375.5 | 376.15 | 375.3 | 376.15 | 6245.0 |
| 2023-11-22 06:30:00 | MSFT | Stock | 376.05 | 376.1 | 375.47 | 375.5 | 2985.0 |
| 2023-11-22 07:00:00 | MSFT | Stock | 375.4 | 376.68 | 375.25 | 376.45 | 30966.0 |
| 2023-11-22 07:30:00 | MSFT | Stock | 376.35 | 377.6 | 376.3 | 377.0 | 87459.0 |
| 2023-11-22 08:00:00 | MSFT | Stock | 375.5236 | 377.7 | 371.6 | 377.37 | 153054.0 |
| 2023-11-22 08:30:00 | MSFT | Stock | 377.38 | 377.95 | 376.89 | 377.944 | 73230.0 |
| 2023-11-22 09:00:00 | MSFT | Stock | 377.8642 | 378.5 | 377.55 | 378.0 | 107662.0 |
| 2023-11-22 09:30:00 | MSFT | Stock | 377.99 | 379.7899 | 376.31 | 376.99 | 3882914.0 |
| 2023-11-22 10:00:00 | MSFT | Stock | 376.97 | 377.4 | 374.965 | 376.95 | 1732376.0 |
| 2023-11-22 10:30:00 | MSFT | Stock | 376.97 | 378.35 | 376.95 | 377.19 | 1131892.0 |
| 2023-11-22 11:00:00 | MSFT | Stock | 377.19 | 378.36 | 377.03 | 378.12 | 834281.0 |
| 2023-11-22 11:30:00 | MSFT | Stock | 378.16 | 378.53 | 377.91 | 378.365 | 711973.0 |
| 2023-11-22 12:00:00 | MSFT | Stock | 378.37 | 379.0 | 378.28 | 378.675 | 686796.0 |
| 2023-11-22 12:30:00 | MSFT | Stock | 378.69 | 378.76 | 378.01 | 378.4001 | 693076.0 |
> showing 50 of 95,727 rows — these rows as CSV