PREVIEW / stock_30min / 2021-03-11
file: by_date/stock_30min/2021/2021-03-11.parquet size: 2.4 MB rows: 119,916 symbols: 2,897
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-11 04:00:00 | AAPL | Stock | 122.24 | 122.59 | 121.46 | 122.38 | 58471.0 |
| 2021-03-11 04:30:00 | AAPL | Stock | 122.39 | 122.59 | 122.29 | 122.39 | 27051.0 |
| 2021-03-11 05:00:00 | AAPL | Stock | 122.4 | 122.53 | 122.29 | 122.43 | 19696.0 |
| 2021-03-11 05:30:00 | AAPL | Stock | 122.42 | 122.9 | 122.38 | 122.81 | 26412.0 |
| 2021-03-11 06:00:00 | AAPL | Stock | 122.73 | 122.85 | 122.41 | 122.41 | 17815.0 |
| 2021-03-11 06:30:00 | AAPL | Stock | 122.5 | 122.68 | 122.38 | 122.46 | 9768.0 |
| 2021-03-11 07:00:00 | AAPL | Stock | 122.46 | 122.6 | 121.75 | 122.06 | 296113.0 |
| 2021-03-11 07:30:00 | AAPL | Stock | 122.09 | 122.48 | 121.95 | 122.439 | 262143.0 |
| 2021-03-11 08:00:00 | AAPL | Stock | 122.45 | 122.94 | 120.13 | 122.75 | 725772.0 |
| 2021-03-11 08:30:00 | AAPL | Stock | 122.75 | 122.77 | 122.15 | 122.42 | 335077.0 |
| 2021-03-11 09:00:00 | AAPL | Stock | 122.38 | 122.59 | 122.01 | 122.32 | 370918.0 |
| 2021-03-11 09:30:00 | AAPL | Stock | 122.31 | 123.21 | 121.41 | 121.7 | 15886473.0 |
| 2021-03-11 10:00:00 | AAPL | Stock | 121.695 | 122.225 | 121.26 | 121.3954 | 8295633.0 |
| 2021-03-11 10:30:00 | AAPL | Stock | 121.39 | 122.42 | 121.39 | 122.3699 | 6051289.0 |
| 2021-03-11 11:00:00 | AAPL | Stock | 122.37 | 122.68 | 122.0893 | 122.66 | 5203105.0 |
| 2021-03-11 11:30:00 | AAPL | Stock | 122.66 | 122.77 | 122.01 | 122.0101 | 6058687.0 |
| 2021-03-11 12:00:00 | AAPL | Stock | 122.02 | 122.4501 | 121.86 | 122.005 | 5776783.0 |
| 2021-03-11 12:30:00 | AAPL | Stock | 122.01 | 122.1 | 121.73 | 121.84 | 3318743.0 |
| 2021-03-11 13:00:00 | AAPL | Stock | 121.8308 | 122.31 | 121.66 | 121.766 | 4548606.0 |
| 2021-03-11 13:30:00 | AAPL | Stock | 121.77 | 121.98 | 121.56 | 121.91 | 3995948.0 |
| 2021-03-11 14:00:00 | AAPL | Stock | 121.9 | 122.05 | 121.81 | 121.82 | 3433642.0 |
| 2021-03-11 14:30:00 | AAPL | Stock | 121.82 | 121.975 | 121.7 | 121.825 | 3159372.0 |
| 2021-03-11 15:00:00 | AAPL | Stock | 121.825 | 122.23 | 121.8 | 122.17 | 3779802.0 |
| 2021-03-11 15:30:00 | AAPL | Stock | 122.17 | 122.2099 | 121.76 | 121.95 | 8504472.0 |
| 2021-03-11 16:00:00 | AAPL | Stock | 121.96 | 122.06 | 121.8 | 121.9 | 8449171.0 |
| 2021-03-11 16:30:00 | AAPL | Stock | 121.96 | 121.96 | 121.89 | 121.89 | 88850.0 |
| 2021-03-11 17:00:00 | AAPL | Stock | 121.89 | 121.92 | 121.72 | 121.8 | 73790.0 |
| 2021-03-11 17:30:00 | AAPL | Stock | 121.79 | 121.93 | 121.72 | 121.91 | 40137.0 |
| 2021-03-11 18:00:00 | AAPL | Stock | 121.9 | 122.1 | 121.87 | 122.1 | 85081.0 |
| 2021-03-11 18:30:00 | AAPL | Stock | 122.09 | 122.14 | 122.04 | 122.07 | 46199.0 |
| 2021-03-11 19:00:00 | AAPL | Stock | 122.04 | 122.13 | 122.0 | 122.08 | 38177.0 |
| 2021-03-11 19:30:00 | AAPL | Stock | 122.0601 | 122.34 | 122.02 | 122.3 | 118748.0 |
| 2021-03-11 04:00:00 | MSFT | Stock | 236.01 | 236.56 | 236.01 | 236.5 | 853.0 |
| 2021-03-11 04:30:00 | MSFT | Stock | 236.26 | 236.4 | 236.0 | 236.0 | 4926.0 |
| 2021-03-11 05:00:00 | MSFT | Stock | 236.26 | 236.27 | 235.9 | 236.0 | 2143.0 |
| 2021-03-11 05:30:00 | MSFT | Stock | 236.18 | 236.5 | 236.18 | 236.49 | 1607.0 |
| 2021-03-11 06:00:00 | MSFT | Stock | 236.25 | 236.35 | 235.78 | 236.35 | 1211.0 |
| 2021-03-11 06:30:00 | MSFT | Stock | 236.0 | 236.0 | 235.99 | 236.0 | 847.0 |
| 2021-03-11 07:00:00 | MSFT | Stock | 235.81 | 235.97 | 235.02 | 235.75 | 20463.0 |
| 2021-03-11 07:30:00 | MSFT | Stock | 235.7 | 236.29 | 235.37 | 235.88 | 27410.0 |
| 2021-03-11 08:00:00 | MSFT | Stock | 235.8 | 236.14 | 231.839 | 234.99 | 24663.0 |
| 2021-03-11 08:30:00 | MSFT | Stock | 234.81 | 235.2 | 234.5 | 235.2 | 14190.0 |
| 2021-03-11 09:00:00 | MSFT | Stock | 234.9 | 235.5499 | 233.99 | 234.5 | 25692.0 |
| 2021-03-11 09:30:00 | MSFT | Stock | 234.5 | 236.75 | 234.31 | 235.2 | 2509775.0 |
| 2021-03-11 10:00:00 | MSFT | Stock | 235.2 | 236.19 | 234.75 | 235.74 | 1616561.0 |
| 2021-03-11 10:30:00 | MSFT | Stock | 235.745 | 237.61 | 235.745 | 237.495 | 1585185.0 |
| 2021-03-11 11:00:00 | MSFT | Stock | 237.49 | 237.73 | 237.02 | 237.49 | 1229252.0 |
| 2021-03-11 11:30:00 | MSFT | Stock | 237.49 | 238.869 | 237.31 | 238.68 | 1373728.0 |
| 2021-03-11 12:00:00 | MSFT | Stock | 238.69 | 239.0 | 237.87 | 238.2 | 1002797.0 |
| 2021-03-11 12:30:00 | MSFT | Stock | 238.19 | 238.31 | 237.77 | 238.24 | 767896.0 |
> showing 50 of 119,916 rows — these rows as CSV