PREVIEW / stock_30min / 2022-05-17
file: by_date/stock_30min/2022/2022-05-17.parquet size: 2.2 MB rows: 108,397 symbols: 2,404
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-05-17 04:00:00 | AAPL | Stock | 146.82 | 147.79 | 146.61 | 147.75 | 37594.0 |
| 2022-05-17 04:30:00 | AAPL | Stock | 147.75 | 148.4 | 147.7 | 148.27 | 39766.0 |
| 2022-05-17 05:00:00 | AAPL | Stock | 148.23 | 148.31 | 148.13 | 148.3 | 13782.0 |
| 2022-05-17 05:30:00 | AAPL | Stock | 148.38 | 148.74 | 148.3 | 148.64 | 15794.0 |
| 2022-05-17 06:00:00 | AAPL | Stock | 148.7 | 148.7 | 148.2 | 148.41 | 20563.0 |
| 2022-05-17 06:30:00 | AAPL | Stock | 148.32 | 148.47 | 148.0 | 148.08 | 20582.0 |
| 2022-05-17 07:00:00 | AAPL | Stock | 148.08 | 148.17 | 147.72 | 148.15 | 150859.0 |
| 2022-05-17 07:30:00 | AAPL | Stock | 148.05 | 148.2 | 147.96 | 148.05 | 130811.0 |
| 2022-05-17 08:00:00 | AAPL | Stock | 147.81 | 148.4 | 146.97 | 148.0 | 401444.0 |
| 2022-05-17 08:30:00 | AAPL | Stock | 148.0 | 148.4 | 147.51 | 147.9144 | 235830.0 |
| 2022-05-17 09:00:00 | AAPL | Stock | 147.98 | 148.87 | 147.92 | 148.86 | 288998.0 |
| 2022-05-17 09:30:00 | AAPL | Stock | 148.86 | 149.34 | 147.63 | 147.7978 | 9165398.0 |
| 2022-05-17 10:00:00 | AAPL | Stock | 147.79 | 148.32 | 147.07 | 147.34 | 5447452.0 |
| 2022-05-17 10:30:00 | AAPL | Stock | 147.34 | 147.82 | 146.68 | 147.34 | 4428342.0 |
| 2022-05-17 11:00:00 | AAPL | Stock | 147.34 | 147.83 | 147.05 | 147.8 | 3415541.0 |
| 2022-05-17 11:30:00 | AAPL | Stock | 147.8001 | 148.68 | 147.795 | 147.9906 | 3877116.0 |
| 2022-05-17 12:00:00 | AAPL | Stock | 148.0 | 148.1391 | 147.46 | 148.06 | 2478656.0 |
| 2022-05-17 12:30:00 | AAPL | Stock | 148.07 | 148.4018 | 147.85 | 147.99 | 2565370.0 |
| 2022-05-17 13:00:00 | AAPL | Stock | 147.99 | 148.4403 | 147.65 | 148.1559 | 2308129.0 |
| 2022-05-17 13:30:00 | AAPL | Stock | 148.145 | 148.8301 | 148.12 | 148.55 | 3448930.0 |
| 2022-05-17 14:00:00 | AAPL | Stock | 148.54 | 149.125 | 147.3003 | 147.92 | 5232969.0 |
| 2022-05-17 14:30:00 | AAPL | Stock | 147.905 | 149.33 | 147.39 | 149.1099 | 4316005.0 |
| 2022-05-17 15:00:00 | AAPL | Stock | 149.106 | 149.77 | 149.0766 | 149.51 | 4558216.0 |
| 2022-05-17 15:30:00 | AAPL | Stock | 149.5 | 149.63 | 148.79 | 149.24 | 6877837.0 |
| 2022-05-17 16:00:00 | AAPL | Stock | 149.24 | 149.38 | 149.0999 | 149.3 | 7568623.0 |
| 2022-05-17 16:30:00 | AAPL | Stock | 149.3 | 149.42 | 149.23 | 149.3 | 120931.0 |
| 2022-05-17 17:00:00 | AAPL | Stock | 149.3 | 149.3899 | 149.26 | 149.3399 | 6828.0 |
| 2022-05-17 17:30:00 | AAPL | Stock | 149.3301 | 149.4 | 149.3 | 149.35 | 14441.0 |
| 2022-05-17 18:00:00 | AAPL | Stock | 149.38 | 149.52 | 149.36 | 149.47 | 19881.0 |
| 2022-05-17 18:30:00 | AAPL | Stock | 149.47 | 149.62 | 149.46 | 149.46 | 57770.0 |
| 2022-05-17 19:00:00 | AAPL | Stock | 149.49 | 149.5 | 149.31 | 149.33 | 18425.0 |
| 2022-05-17 19:30:00 | AAPL | Stock | 149.4 | 149.5 | 149.2 | 149.24 | 23262.0 |
| 2022-05-17 04:00:00 | MSFT | Stock | 264.57 | 265.5 | 264.57 | 265.5 | 3342.0 |
| 2022-05-17 04:30:00 | MSFT | Stock | 265.54 | 266.98 | 265.42 | 266.5 | 13265.0 |
| 2022-05-17 05:00:00 | MSFT | Stock | 266.11 | 266.3 | 265.93 | 266.15 | 2591.0 |
| 2022-05-17 05:30:00 | MSFT | Stock | 266.01 | 266.55 | 265.95 | 266.55 | 7397.0 |
| 2022-05-17 06:00:00 | MSFT | Stock | 266.6 | 267.0 | 265.55 | 266.4 | 10745.0 |
| 2022-05-17 06:30:00 | MSFT | Stock | 266.66 | 266.66 | 265.96 | 266.44 | 5353.0 |
| 2022-05-17 07:00:00 | MSFT | Stock | 266.4 | 266.69 | 265.26 | 266.48 | 30519.0 |
| 2022-05-17 07:30:00 | MSFT | Stock | 266.25 | 266.37 | 265.5 | 265.75 | 7358.0 |
| 2022-05-17 08:00:00 | MSFT | Stock | 265.8998 | 266.7 | 264.25 | 265.42 | 37921.0 |
| 2022-05-17 08:30:00 | MSFT | Stock | 265.8 | 265.8 | 265.0 | 265.35 | 33273.0 |
| 2022-05-17 09:00:00 | MSFT | Stock | 265.34 | 266.39 | 264.91 | 266.14 | 64041.0 |
| 2022-05-17 09:30:00 | MSFT | Stock | 266.14 | 268.33 | 265.45 | 265.73 | 3118205.0 |
| 2022-05-17 10:00:00 | MSFT | Stock | 265.77 | 266.3799 | 264.27 | 264.3628 | 1632495.0 |
| 2022-05-17 10:30:00 | MSFT | Stock | 264.38 | 264.76 | 262.46 | 263.1184 | 1421374.0 |
| 2022-05-17 11:00:00 | MSFT | Stock | 263.11 | 264.75 | 262.85 | 264.69 | 1031884.0 |
| 2022-05-17 11:30:00 | MSFT | Stock | 264.75 | 266.11 | 264.74 | 265.06 | 1033749.0 |
| 2022-05-17 12:00:00 | MSFT | Stock | 265.07 | 265.5 | 264.53 | 265.3 | 842066.0 |
| 2022-05-17 12:30:00 | MSFT | Stock | 265.31 | 265.98 | 264.91 | 264.99 | 692323.0 |
> showing 50 of 108,397 rows — these rows as CSV