PREVIEW / stock_30min / 2022-05-10
file: by_date/stock_30min/2022/2022-05-10.parquet size: 2.2 MB rows: 110,302 symbols: 2,498
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-10 04:00:00 | AAPL | Stock | 153.52 | 154.66 | 153.52 | 154.59 | 50234.0 |
| 2022-05-10 04:30:00 | AAPL | Stock | 154.66 | 154.85 | 154.12 | 154.33 | 31812.0 |
| 2022-05-10 05:00:00 | AAPL | Stock | 154.32 | 154.5 | 154.24 | 154.35 | 15662.0 |
| 2022-05-10 05:30:00 | AAPL | Stock | 154.39 | 154.64 | 153.5 | 153.6 | 23585.0 |
| 2022-05-10 06:00:00 | AAPL | Stock | 153.6 | 153.92 | 153.4 | 153.6 | 51767.0 |
| 2022-05-10 06:30:00 | AAPL | Stock | 153.71 | 153.95 | 153.45 | 153.5 | 14255.0 |
| 2022-05-10 07:00:00 | AAPL | Stock | 153.5 | 153.6 | 153.19 | 153.5 | 44112.0 |
| 2022-05-10 07:30:00 | AAPL | Stock | 153.48 | 153.76 | 153.3 | 153.76 | 48856.0 |
| 2022-05-10 08:00:00 | AAPL | Stock | 153.4802 | 154.74 | 153.16 | 154.41 | 347349.0 |
| 2022-05-10 08:30:00 | AAPL | Stock | 154.41 | 156.0 | 154.36 | 155.53 | 307809.0 |
| 2022-05-10 09:00:00 | AAPL | Stock | 155.52 | 155.99 | 154.99 | 155.52 | 366946.0 |
| 2022-05-10 09:30:00 | AAPL | Stock | 155.57 | 156.54 | 154.14 | 155.8203 | 14014898.0 |
| 2022-05-10 10:00:00 | AAPL | Stock | 155.83 | 156.385 | 155.18 | 155.4 | 7868069.0 |
| 2022-05-10 10:30:00 | AAPL | Stock | 155.4 | 155.58 | 153.96 | 154.48 | 6523046.0 |
| 2022-05-10 11:00:00 | AAPL | Stock | 154.48 | 154.78 | 153.1 | 153.73 | 6817659.0 |
| 2022-05-10 11:30:00 | AAPL | Stock | 153.73 | 154.55 | 153.04 | 153.76 | 5096607.0 |
| 2022-05-10 12:00:00 | AAPL | Stock | 153.75 | 154.34 | 153.43 | 153.75 | 4012541.0 |
| 2022-05-10 12:30:00 | AAPL | Stock | 153.74 | 154.2 | 152.93 | 153.36 | 4414850.0 |
| 2022-05-10 13:00:00 | AAPL | Stock | 153.39 | 154.66 | 153.25 | 154.6471 | 4457778.0 |
| 2022-05-10 13:30:00 | AAPL | Stock | 154.6564 | 156.74 | 154.6564 | 156.695 | 6770375.0 |
| 2022-05-10 14:00:00 | AAPL | Stock | 156.7 | 156.73 | 155.23 | 155.535 | 5458012.0 |
| 2022-05-10 14:30:00 | AAPL | Stock | 155.545 | 156.33 | 155.34 | 156.07 | 4664251.0 |
| 2022-05-10 15:00:00 | AAPL | Stock | 156.09 | 156.62 | 155.0 | 155.21 | 5223032.0 |
| 2022-05-10 15:30:00 | AAPL | Stock | 155.22 | 155.23 | 154.03 | 154.5 | 7889712.0 |
| 2022-05-10 16:00:00 | AAPL | Stock | 154.475 | 154.65 | 154.1 | 154.36 | 10625531.0 |
| 2022-05-10 16:30:00 | AAPL | Stock | 154.35 | 154.51 | 154.1 | 154.16 | 73146.0 |
| 2022-05-10 17:00:00 | AAPL | Stock | 154.15 | 154.2 | 154.02 | 154.1735 | 26558.0 |
| 2022-05-10 17:30:00 | AAPL | Stock | 154.15 | 154.51 | 154.0 | 154.3 | 83692.0 |
| 2022-05-10 18:00:00 | AAPL | Stock | 154.22 | 154.49 | 154.2 | 154.38 | 18251.0 |
| 2022-05-10 18:30:00 | AAPL | Stock | 154.37 | 154.51 | 154.3 | 154.5 | 9262.0 |
| 2022-05-10 19:00:00 | AAPL | Stock | 154.53 | 154.7 | 154.45 | 154.65 | 18682.0 |
| 2022-05-10 19:30:00 | AAPL | Stock | 154.65 | 154.65 | 154.35 | 154.5 | 40622.0 |
| 2022-05-10 04:00:00 | MSFT | Stock | 267.24 | 269.29 | 267.24 | 269.07 | 17921.0 |
| 2022-05-10 04:30:00 | MSFT | Stock | 269.25 | 269.29 | 268.55 | 268.55 | 2161.0 |
| 2022-05-10 05:00:00 | MSFT | Stock | 268.41 | 268.51 | 268.2 | 268.51 | 4556.0 |
| 2022-05-10 05:30:00 | MSFT | Stock | 268.69 | 268.85 | 267.76 | 267.76 | 534.0 |
| 2022-05-10 06:00:00 | MSFT | Stock | 267.76 | 268.19 | 267.76 | 268.19 | 968.0 |
| 2022-05-10 06:30:00 | MSFT | Stock | 268.27 | 268.54 | 268.2 | 268.2 | 3508.0 |
| 2022-05-10 07:00:00 | MSFT | Stock | 268.0 | 268.0 | 266.86 | 267.3 | 26120.0 |
| 2022-05-10 07:30:00 | MSFT | Stock | 267.49 | 268.3 | 267.49 | 268.19 | 13013.0 |
| 2022-05-10 08:00:00 | MSFT | Stock | 267.9999 | 269.45 | 266.75 | 269.1 | 70297.0 |
| 2022-05-10 08:30:00 | MSFT | Stock | 269.1 | 270.9814 | 269.09 | 270.67 | 73804.0 |
| 2022-05-10 09:00:00 | MSFT | Stock | 270.8 | 272.0 | 270.78 | 271.67 | 87851.0 |
| 2022-05-10 09:30:00 | MSFT | Stock | 271.61 | 272.91 | 269.08 | 271.9 | 3949227.0 |
| 2022-05-10 10:00:00 | MSFT | Stock | 271.91 | 273.56 | 269.56 | 271.0499 | 2056330.0 |
| 2022-05-10 10:30:00 | MSFT | Stock | 271.08 | 271.56 | 267.39 | 267.5 | 1738196.0 |
| 2022-05-10 11:00:00 | MSFT | Stock | 267.5075 | 268.51 | 265.07 | 266.79 | 1613533.0 |
| 2022-05-10 11:30:00 | MSFT | Stock | 266.85 | 268.72 | 266.075 | 268.055 | 1226576.0 |
| 2022-05-10 12:00:00 | MSFT | Stock | 268.04 | 268.77 | 267.0703 | 268.0 | 1097995.0 |
| 2022-05-10 12:30:00 | MSFT | Stock | 267.97 | 269.34 | 266.87 | 267.62 | 1123987.0 |
> showing 50 of 110,302 rows — these rows as CSV