PREVIEW / stock_30min / 2024-03-20
file: by_date/stock_30min/2024/2024-03-20.parquet size: 2.1 MB rows: 100,862 symbols: 1,088
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-03-20 04:00:00 | AAPL | Stock | 175.9 | 176.08 | 175.65 | 175.86 | 8396.0 |
| 2024-03-20 04:30:00 | AAPL | Stock | 175.94 | 176.0 | 175.5 | 175.5 | 8943.0 |
| 2024-03-20 05:00:00 | AAPL | Stock | 175.58 | 175.71 | 175.41 | 175.6 | 5637.0 |
| 2024-03-20 05:30:00 | AAPL | Stock | 175.75 | 175.75 | 175.45 | 175.55 | 5794.0 |
| 2024-03-20 06:00:00 | AAPL | Stock | 175.65 | 175.73 | 175.45 | 175.45 | 2293.0 |
| 2024-03-20 06:30:00 | AAPL | Stock | 175.42 | 175.75 | 175.42 | 175.73 | 2775.0 |
| 2024-03-20 07:00:00 | AAPL | Stock | 175.7 | 176.5 | 175.7 | 176.22 | 20346.0 |
| 2024-03-20 07:30:00 | AAPL | Stock | 176.22 | 176.34 | 176.12 | 176.2 | 10460.0 |
| 2024-03-20 08:00:00 | AAPL | Stock | 175.92 | 176.53 | 175.37 | 175.99 | 90461.0 |
| 2024-03-20 08:30:00 | AAPL | Stock | 176.0 | 176.1513 | 175.6785 | 175.8779 | 26092.0 |
| 2024-03-20 09:00:00 | AAPL | Stock | 175.88 | 176.05 | 175.4 | 175.72 | 105656.0 |
| 2024-03-20 09:30:00 | AAPL | Stock | 175.72 | 176.1 | 175.09 | 175.685 | 4066020.0 |
| 2024-03-20 10:00:00 | AAPL | Stock | 175.685 | 176.17 | 175.6 | 176.1605 | 2414956.0 |
| 2024-03-20 10:30:00 | AAPL | Stock | 176.165 | 176.38 | 175.8 | 175.9099 | 2013276.0 |
| 2024-03-20 11:00:00 | AAPL | Stock | 175.9 | 176.11 | 175.72 | 176.0599 | 1444242.0 |
| 2024-03-20 11:30:00 | AAPL | Stock | 176.0593 | 176.205 | 175.945 | 176.16 | 1158980.0 |
| 2024-03-20 12:00:00 | AAPL | Stock | 176.15 | 176.51 | 176.0575 | 176.3801 | 1344398.0 |
| 2024-03-20 12:30:00 | AAPL | Stock | 176.38 | 176.7682 | 176.3403 | 176.7 | 1692550.0 |
| 2024-03-20 13:00:00 | AAPL | Stock | 176.695 | 176.775 | 176.31 | 176.325 | 1282820.0 |
| 2024-03-20 13:30:00 | AAPL | Stock | 176.31 | 176.72 | 176.28 | 176.64 | 1432886.0 |
| 2024-03-20 14:00:00 | AAPL | Stock | 176.63 | 177.39 | 176.59 | 177.0075 | 3630328.0 |
| 2024-03-20 14:30:00 | AAPL | Stock | 177.01 | 178.245 | 176.72 | 177.955 | 4411573.0 |
| 2024-03-20 15:00:00 | AAPL | Stock | 177.97 | 178.43 | 177.81 | 178.215 | 3227788.0 |
| 2024-03-20 15:30:00 | AAPL | Stock | 178.21 | 178.67 | 177.945 | 178.65 | 6480874.0 |
| 2024-03-20 16:00:00 | AAPL | Stock | 178.66 | 178.68 | 177.5867 | 177.88 | 7351762.0 |
| 2024-03-20 16:30:00 | AAPL | Stock | 177.85 | 178.67 | 177.74 | 177.76 | 151393.0 |
| 2024-03-20 17:00:00 | AAPL | Stock | 177.77 | 178.67 | 176.1 | 176.4 | 178583.0 |
| 2024-03-20 17:30:00 | AAPL | Stock | 176.305 | 176.65 | 175.83 | 176.65 | 194886.0 |
| 2024-03-20 18:00:00 | AAPL | Stock | 176.65 | 176.93 | 176.43 | 176.45 | 81494.0 |
| 2024-03-20 18:30:00 | AAPL | Stock | 176.48 | 176.5 | 176.27 | 176.4 | 54047.0 |
| 2024-03-20 19:00:00 | AAPL | Stock | 176.41 | 176.7 | 176.4 | 176.53 | 32084.0 |
| 2024-03-20 19:30:00 | AAPL | Stock | 176.57 | 176.57 | 176.25 | 176.4 | 45627.0 |
| 2024-03-20 04:00:00 | MSFT | Stock | 420.88 | 420.99 | 420.61 | 420.7 | 469.0 |
| 2024-03-20 04:30:00 | MSFT | Stock | 420.79 | 420.88 | 420.41 | 420.55 | 939.0 |
| 2024-03-20 05:00:00 | MSFT | Stock | 420.8 | 420.8 | 420.8 | 420.8 | 123.0 |
| 2024-03-20 05:30:00 | MSFT | Stock | 420.91 | 420.94 | 420.91 | 420.94 | 300.0 |
| 2024-03-20 06:30:00 | MSFT | Stock | 421.0 | 421.0 | 421.0 | 421.0 | 800.0 |
| 2024-03-20 07:00:00 | MSFT | Stock | 421.3 | 422.0 | 421.3 | 422.0 | 4780.0 |
| 2024-03-20 07:30:00 | MSFT | Stock | 422.3 | 422.79 | 422.29 | 422.54 | 2516.0 |
| 2024-03-20 08:00:00 | MSFT | Stock | 421.29 | 422.86 | 420.58 | 421.35 | 12207.0 |
| 2024-03-20 08:30:00 | MSFT | Stock | 421.56 | 421.7 | 421.1 | 421.39 | 3176.0 |
| 2024-03-20 09:00:00 | MSFT | Stock | 421.31 | 422.4399 | 421.31 | 422.06 | 11404.0 |
| 2024-03-20 09:30:00 | MSFT | Stock | 422.0 | 422.82 | 420.83 | 421.83 | 1113244.0 |
| 2024-03-20 10:00:00 | MSFT | Stock | 421.86 | 422.54 | 421.25 | 422.13 | 758111.0 |
| 2024-03-20 10:30:00 | MSFT | Stock | 422.125 | 422.26 | 420.66 | 420.96 | 443775.0 |
| 2024-03-20 11:00:00 | MSFT | Stock | 420.96 | 422.79 | 420.92 | 422.565 | 401842.0 |
| 2024-03-20 11:30:00 | MSFT | Stock | 422.55 | 422.74 | 421.7 | 422.4701 | 302492.0 |
| 2024-03-20 12:00:00 | MSFT | Stock | 422.44 | 423.14 | 422.14 | 423.03 | 343999.0 |
| 2024-03-20 12:30:00 | MSFT | Stock | 423.01 | 423.38 | 422.4901 | 423.33 | 407979.0 |
| 2024-03-20 13:00:00 | MSFT | Stock | 423.3 | 423.35 | 422.11 | 422.2 | 242722.0 |
> showing 50 of 100,862 rows — these rows as CSV