PREVIEW / stock_30min / 2022-06-22
file: by_date/stock_30min/2022/2022-06-22.parquet size: 2.1 MB rows: 105,778 symbols: 2,346
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 |
|---|---|---|---|---|---|---|---|
| 2022-06-22 04:00:00 | AAPL | Stock | 134.98 | 134.98 | 132.62 | 132.83 | 49383.0 |
| 2022-06-22 04:30:00 | AAPL | Stock | 132.8 | 133.07 | 132.8 | 132.98 | 35777.0 |
| 2022-06-22 05:00:00 | AAPL | Stock | 133.09 | 133.3 | 132.85 | 133.1 | 15877.0 |
| 2022-06-22 05:30:00 | AAPL | Stock | 133.07 | 133.23 | 133.05 | 133.23 | 5776.0 |
| 2022-06-22 06:00:00 | AAPL | Stock | 133.15 | 133.46 | 133.15 | 133.44 | 11889.0 |
| 2022-06-22 06:30:00 | AAPL | Stock | 133.46 | 133.56 | 133.28 | 133.39 | 16806.0 |
| 2022-06-22 07:00:00 | AAPL | Stock | 133.41 | 133.85 | 133.39 | 133.85 | 73417.0 |
| 2022-06-22 07:30:00 | AAPL | Stock | 133.88 | 133.89 | 133.63 | 133.7 | 48066.0 |
| 2022-06-22 08:00:00 | AAPL | Stock | 133.66 | 134.0 | 132.8612 | 133.61 | 223133.0 |
| 2022-06-22 08:30:00 | AAPL | Stock | 133.56 | 134.24 | 133.4 | 134.13 | 181172.0 |
| 2022-06-22 09:00:00 | AAPL | Stock | 134.17 | 134.87 | 133.7 | 134.79 | 211548.0 |
| 2022-06-22 09:30:00 | AAPL | Stock | 134.79 | 135.945 | 133.91 | 135.67 | 9053800.0 |
| 2022-06-22 10:00:00 | AAPL | Stock | 135.68 | 137.51 | 135.25 | 137.27 | 6425705.0 |
| 2022-06-22 10:30:00 | AAPL | Stock | 137.2783 | 137.76 | 136.63 | 136.8075 | 5299983.0 |
| 2022-06-22 11:00:00 | AAPL | Stock | 136.82 | 136.92 | 136.21 | 136.4772 | 4114619.0 |
| 2022-06-22 11:30:00 | AAPL | Stock | 136.475 | 136.9843 | 135.3 | 135.48 | 3927677.0 |
| 2022-06-22 12:00:00 | AAPL | Stock | 135.47 | 135.99 | 135.14 | 135.63 | 2912210.0 |
| 2022-06-22 12:30:00 | AAPL | Stock | 135.63 | 136.1 | 135.52 | 136.03 | 3229884.0 |
| 2022-06-22 13:00:00 | AAPL | Stock | 136.04 | 136.4569 | 135.6593 | 136.37 | 2427897.0 |
| 2022-06-22 13:30:00 | AAPL | Stock | 136.37 | 136.395 | 135.91 | 136.0601 | 2191236.0 |
| 2022-06-22 14:00:00 | AAPL | Stock | 136.07 | 136.97 | 136.03 | 136.49 | 2991135.0 |
| 2022-06-22 14:30:00 | AAPL | Stock | 136.5 | 136.6806 | 136.17 | 136.455 | 2174720.0 |
| 2022-06-22 15:00:00 | AAPL | Stock | 136.46 | 136.64 | 135.72 | 135.8764 | 2981985.0 |
| 2022-06-22 15:30:00 | AAPL | Stock | 135.88 | 135.95 | 134.98 | 135.3 | 6170179.0 |
| 2022-06-22 16:00:00 | AAPL | Stock | 135.31 | 135.4 | 135.0 | 135.21 | 8746857.0 |
| 2022-06-22 16:30:00 | AAPL | Stock | 135.21 | 135.35 | 135.05 | 135.21 | 40618.0 |
| 2022-06-22 17:00:00 | AAPL | Stock | 135.17 | 135.19 | 135.1 | 135.15 | 18130.0 |
| 2022-06-22 17:30:00 | AAPL | Stock | 135.1599 | 135.22 | 135.14 | 135.16 | 10663.0 |
| 2022-06-22 18:00:00 | AAPL | Stock | 135.15 | 135.2 | 134.75 | 134.84 | 45296.0 |
| 2022-06-22 18:30:00 | AAPL | Stock | 134.86 | 134.89 | 134.77 | 134.78 | 26261.0 |
| 2022-06-22 19:00:00 | AAPL | Stock | 134.82 | 134.84 | 134.3 | 134.42 | 39499.0 |
| 2022-06-22 19:30:00 | AAPL | Stock | 134.35 | 134.4 | 134.15 | 134.16 | 60487.0 |
| 2022-06-22 04:00:00 | MSFT | Stock | 250.1 | 250.1 | 248.1 | 248.15 | 11351.0 |
| 2022-06-22 04:30:00 | MSFT | Stock | 248.1 | 248.33 | 248.1 | 248.1 | 12732.0 |
| 2022-06-22 05:00:00 | MSFT | Stock | 248.3 | 248.8 | 248.3 | 248.8 | 7248.0 |
| 2022-06-22 05:30:00 | MSFT | Stock | 248.71 | 248.71 | 248.51 | 248.51 | 300.0 |
| 2022-06-22 06:00:00 | MSFT | Stock | 248.88 | 249.3 | 248.88 | 249.3 | 5315.0 |
| 2022-06-22 06:30:00 | MSFT | Stock | 249.2 | 249.48 | 249.2 | 249.48 | 258.0 |
| 2022-06-22 07:00:00 | MSFT | Stock | 249.45 | 249.7 | 249.29 | 249.7 | 8032.0 |
| 2022-06-22 07:30:00 | MSFT | Stock | 249.83 | 249.84 | 249.35 | 249.49 | 4235.0 |
| 2022-06-22 08:00:00 | MSFT | Stock | 249.3037 | 253.106 | 249.0 | 249.002 | 25244.0 |
| 2022-06-22 08:30:00 | MSFT | Stock | 249.08 | 249.66 | 248.61 | 249.5 | 20526.0 |
| 2022-06-22 09:00:00 | MSFT | Stock | 249.55 | 251.9 | 249.21 | 251.9 | 42357.0 |
| 2022-06-22 09:30:00 | MSFT | Stock | 251.99 | 254.53 | 250.37 | 254.0 | 2125718.0 |
| 2022-06-22 10:00:00 | MSFT | Stock | 254.02 | 256.78 | 253.34 | 256.215 | 1350370.0 |
| 2022-06-22 10:30:00 | MSFT | Stock | 256.29 | 257.17 | 255.75 | 257.05 | 1233091.0 |
| 2022-06-22 11:00:00 | MSFT | Stock | 257.06 | 257.12 | 255.85 | 256.29 | 1153842.0 |
| 2022-06-22 11:30:00 | MSFT | Stock | 256.3 | 257.07 | 254.0375 | 254.085 | 959242.0 |
| 2022-06-22 12:00:00 | MSFT | Stock | 254.085 | 254.81 | 253.42 | 254.18 | 832116.0 |
| 2022-06-22 12:30:00 | MSFT | Stock | 254.18 | 254.99 | 254.01 | 254.9 | 503727.0 |
> showing 50 of 105,778 rows — these rows as CSV