PREVIEW / stock_30min / 2022-05-25
file: by_date/stock_30min/2022/2022-05-25.parquet size: 2.1 MB rows: 103,333 symbols: 2,342
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-25 04:00:00 | AAPL | Stock | 141.19 | 141.19 | 140.01 | 140.35 | 22896.0 |
| 2022-05-25 04:30:00 | AAPL | Stock | 140.31 | 140.7 | 140.31 | 140.4 | 7507.0 |
| 2022-05-25 05:00:00 | AAPL | Stock | 140.36 | 140.36 | 139.7 | 140.11 | 14974.0 |
| 2022-05-25 05:30:00 | AAPL | Stock | 140.0 | 140.5 | 139.96 | 140.45 | 16179.0 |
| 2022-05-25 06:00:00 | AAPL | Stock | 140.4 | 140.55 | 140.18 | 140.34 | 18158.0 |
| 2022-05-25 06:30:00 | AAPL | Stock | 140.21 | 140.28 | 139.61 | 139.65 | 47265.0 |
| 2022-05-25 07:00:00 | AAPL | Stock | 139.65 | 139.85 | 138.78 | 139.09 | 167161.0 |
| 2022-05-25 07:30:00 | AAPL | Stock | 139.09 | 139.15 | 138.67 | 138.89 | 105837.0 |
| 2022-05-25 08:00:00 | AAPL | Stock | 139.7945 | 142.13 | 138.08 | 138.74 | 631108.0 |
| 2022-05-25 08:30:00 | AAPL | Stock | 138.75 | 139.4 | 138.331 | 138.68 | 429875.0 |
| 2022-05-25 09:00:00 | AAPL | Stock | 138.7 | 138.97 | 138.11 | 138.46 | 259696.0 |
| 2022-05-25 09:30:00 | AAPL | Stock | 138.43 | 140.34 | 138.34 | 139.33 | 9467434.0 |
| 2022-05-25 10:00:00 | AAPL | Stock | 139.33 | 140.85 | 138.95 | 140.85 | 6737383.0 |
| 2022-05-25 10:30:00 | AAPL | Stock | 140.85 | 141.38 | 140.075 | 140.19 | 5822949.0 |
| 2022-05-25 11:00:00 | AAPL | Stock | 140.19 | 140.63 | 139.68 | 140.25 | 3751609.0 |
| 2022-05-25 11:30:00 | AAPL | Stock | 140.2718 | 140.28 | 139.45 | 139.9184 | 3679882.0 |
| 2022-05-25 12:00:00 | AAPL | Stock | 139.92 | 140.185 | 138.96 | 139.175 | 3359197.0 |
| 2022-05-25 12:30:00 | AAPL | Stock | 139.16 | 139.57 | 138.8414 | 139.44 | 3202770.0 |
| 2022-05-25 13:00:00 | AAPL | Stock | 139.435 | 139.435 | 138.5008 | 139.23 | 3693163.0 |
| 2022-05-25 13:30:00 | AAPL | Stock | 139.23 | 139.76 | 139.02 | 139.45 | 3250717.0 |
| 2022-05-25 14:00:00 | AAPL | Stock | 139.4699 | 140.5601 | 138.5534 | 140.4831 | 7434383.0 |
| 2022-05-25 14:30:00 | AAPL | Stock | 140.49 | 141.19 | 140.23 | 141.09 | 5526778.0 |
| 2022-05-25 15:00:00 | AAPL | Stock | 141.1 | 141.785 | 140.98 | 141.3787 | 5371113.0 |
| 2022-05-25 15:30:00 | AAPL | Stock | 141.38 | 141.5441 | 139.93 | 140.7011 | 9034394.0 |
| 2022-05-25 16:00:00 | AAPL | Stock | 140.71 | 140.71 | 138.68 | 139.01 | 7478602.0 |
| 2022-05-25 16:30:00 | AAPL | Stock | 139.07 | 140.52 | 139.0 | 139.7741 | 119044.0 |
| 2022-05-25 17:00:00 | AAPL | Stock | 139.84 | 140.52 | 139.6094 | 139.7 | 19928.0 |
| 2022-05-25 17:30:00 | AAPL | Stock | 139.6999 | 139.85 | 139.61 | 139.78 | 22645.0 |
| 2022-05-25 18:00:00 | AAPL | Stock | 139.78 | 140.4 | 139.78 | 139.97 | 43979.0 |
| 2022-05-25 18:30:00 | AAPL | Stock | 140.07 | 140.11 | 139.94 | 140.02 | 16784.0 |
| 2022-05-25 19:00:00 | AAPL | Stock | 140.06 | 140.2 | 140.06 | 140.2 | 11558.0 |
| 2022-05-25 19:30:00 | AAPL | Stock | 140.22 | 140.25 | 139.85 | 139.93 | 32796.0 |
| 2022-05-25 04:00:00 | MSFT | Stock | 260.4 | 260.4 | 259.4 | 259.94 | 2296.0 |
| 2022-05-25 04:30:00 | MSFT | Stock | 259.85 | 259.85 | 259.85 | 259.85 | 188.0 |
| 2022-05-25 05:00:00 | MSFT | Stock | 259.1 | 259.12 | 258.8 | 259.0 | 3606.0 |
| 2022-05-25 05:30:00 | MSFT | Stock | 259.57 | 259.65 | 259.57 | 259.65 | 446.0 |
| 2022-05-25 06:00:00 | MSFT | Stock | 259.71 | 259.87 | 259.71 | 259.8 | 307.0 |
| 2022-05-25 06:30:00 | MSFT | Stock | 259.62 | 259.62 | 259.39 | 259.39 | 1655.0 |
| 2022-05-25 07:00:00 | MSFT | Stock | 259.44 | 259.91 | 257.8 | 258.0 | 12655.0 |
| 2022-05-25 07:30:00 | MSFT | Stock | 258.33 | 258.61 | 257.95 | 258.4 | 13187.0 |
| 2022-05-25 08:00:00 | MSFT | Stock | 259.1173 | 259.99 | 257.8 | 258.3 | 33593.0 |
| 2022-05-25 08:30:00 | MSFT | Stock | 258.0 | 258.9 | 257.82 | 258.66 | 40998.0 |
| 2022-05-25 09:00:00 | MSFT | Stock | 258.66 | 259.0 | 258.1 | 258.1 | 18317.0 |
| 2022-05-25 09:30:00 | MSFT | Stock | 258.14 | 261.3498 | 257.54 | 259.26 | 2296770.0 |
| 2022-05-25 10:00:00 | MSFT | Stock | 259.25 | 260.4 | 257.125 | 260.15 | 1721855.0 |
| 2022-05-25 10:30:00 | MSFT | Stock | 260.15 | 260.88 | 259.2 | 259.6483 | 1109498.0 |
| 2022-05-25 11:00:00 | MSFT | Stock | 259.66 | 259.69 | 258.11 | 259.3 | 1005558.0 |
| 2022-05-25 11:30:00 | MSFT | Stock | 259.295 | 260.1 | 258.3101 | 259.48 | 974513.0 |
| 2022-05-25 12:00:00 | MSFT | Stock | 259.485 | 259.76 | 258.64 | 258.99 | 815483.0 |
| 2022-05-25 12:30:00 | MSFT | Stock | 258.985 | 260.19 | 258.555 | 259.8 | 1089027.0 |
> showing 50 of 103,333 rows — these rows as CSV