PREVIEW / stock_30min / 2021-03-25
file: by_date/stock_30min/2021/2021-03-25.parquet size: 2.3 MB rows: 116,497 symbols: 2,921
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-25 04:00:00 | AAPL | Stock | 120.15 | 120.82 | 120.15 | 120.66 | 8568.0 |
| 2021-03-25 04:30:00 | AAPL | Stock | 120.72 | 120.72 | 120.55 | 120.6 | 8281.0 |
| 2021-03-25 05:00:00 | AAPL | Stock | 120.5 | 120.58 | 120.3 | 120.58 | 4354.0 |
| 2021-03-25 05:30:00 | AAPL | Stock | 120.59 | 120.59 | 120.41 | 120.41 | 1842.0 |
| 2021-03-25 06:00:00 | AAPL | Stock | 120.47 | 120.83 | 120.47 | 120.83 | 5588.0 |
| 2021-03-25 06:30:00 | AAPL | Stock | 120.77 | 120.88 | 120.6 | 120.6 | 3561.0 |
| 2021-03-25 07:00:00 | AAPL | Stock | 120.64 | 120.7 | 120.1 | 120.17 | 95352.0 |
| 2021-03-25 07:30:00 | AAPL | Stock | 120.17 | 120.17 | 119.0 | 119.1 | 222394.0 |
| 2021-03-25 08:00:00 | AAPL | Stock | 120.4499 | 120.68 | 119.0 | 119.16 | 549423.0 |
| 2021-03-25 08:30:00 | AAPL | Stock | 119.09 | 119.4 | 118.8 | 119.02 | 323127.0 |
| 2021-03-25 09:00:00 | AAPL | Stock | 119.02 | 119.77 | 118.59 | 119.52 | 681528.0 |
| 2021-03-25 09:30:00 | AAPL | Stock | 119.54 | 121.05 | 119.0 | 121.0214 | 12814810.0 |
| 2021-03-25 10:00:00 | AAPL | Stock | 121.02 | 121.66 | 120.65 | 120.6794 | 8384326.0 |
| 2021-03-25 10:30:00 | AAPL | Stock | 120.68 | 120.79 | 119.28 | 119.71 | 8253982.0 |
| 2021-03-25 11:00:00 | AAPL | Stock | 119.71 | 119.72 | 119.09 | 119.555 | 6607375.0 |
| 2021-03-25 11:30:00 | AAPL | Stock | 119.5509 | 119.95 | 119.34 | 119.715 | 5474739.0 |
| 2021-03-25 12:00:00 | AAPL | Stock | 119.72 | 120.36 | 119.49 | 120.291 | 5218072.0 |
| 2021-03-25 12:30:00 | AAPL | Stock | 120.3 | 120.34 | 119.895 | 120.16 | 3984545.0 |
| 2021-03-25 13:00:00 | AAPL | Stock | 120.16 | 120.6 | 119.77 | 119.98 | 4301682.0 |
| 2021-03-25 13:30:00 | AAPL | Stock | 119.99 | 120.36 | 119.83 | 119.96 | 3507303.0 |
| 2021-03-25 14:00:00 | AAPL | Stock | 119.96 | 119.96 | 119.55 | 119.59 | 2996956.0 |
| 2021-03-25 14:30:00 | AAPL | Stock | 119.59 | 120.61 | 119.485 | 120.5702 | 3844161.0 |
| 2021-03-25 15:00:00 | AAPL | Stock | 120.57 | 121.0901 | 120.55 | 120.92 | 4633145.0 |
| 2021-03-25 15:30:00 | AAPL | Stock | 120.9198 | 121.08 | 120.54 | 120.6 | 7707599.0 |
| 2021-03-25 16:00:00 | AAPL | Stock | 120.59 | 120.67 | 120.51 | 120.57 | 5931581.0 |
| 2021-03-25 16:30:00 | AAPL | Stock | 120.57 | 120.59 | 120.35 | 120.51 | 70790.0 |
| 2021-03-25 17:00:00 | AAPL | Stock | 120.55 | 120.64 | 120.5 | 120.59 | 34748.0 |
| 2021-03-25 17:30:00 | AAPL | Stock | 120.61 | 120.64 | 120.59 | 120.59 | 13295.0 |
| 2021-03-25 18:00:00 | AAPL | Stock | 120.59 | 120.59 | 120.45 | 120.52 | 37527.0 |
| 2021-03-25 18:30:00 | AAPL | Stock | 120.5 | 120.6 | 120.46 | 120.58 | 22365.0 |
| 2021-03-25 19:00:00 | AAPL | Stock | 120.58 | 120.77 | 120.56 | 120.74 | 46868.0 |
| 2021-03-25 19:30:00 | AAPL | Stock | 120.74 | 120.85 | 120.73 | 120.75 | 46743.0 |
| 2021-03-25 04:00:00 | MSFT | Stock | 235.0 | 236.17 | 235.0 | 236.17 | 829.0 |
| 2021-03-25 05:00:00 | MSFT | Stock | 235.6 | 235.6 | 235.6 | 235.6 | 446.0 |
| 2021-03-25 05:30:00 | MSFT | Stock | 235.29 | 235.29 | 235.29 | 235.29 | 140.0 |
| 2021-03-25 06:00:00 | MSFT | Stock | 235.47 | 235.67 | 235.47 | 235.67 | 360.0 |
| 2021-03-25 07:00:00 | MSFT | Stock | 235.72 | 236.0 | 235.5 | 235.5 | 625.0 |
| 2021-03-25 07:30:00 | MSFT | Stock | 235.09 | 235.26 | 234.5 | 235.25 | 15279.0 |
| 2021-03-25 08:00:00 | MSFT | Stock | 235.0 | 236.0 | 234.3 | 235.0 | 24726.0 |
| 2021-03-25 08:30:00 | MSFT | Stock | 235.24 | 235.99 | 234.65 | 235.34 | 28055.0 |
| 2021-03-25 09:00:00 | MSFT | Stock | 235.49 | 236.51 | 234.73 | 235.29 | 37457.0 |
| 2021-03-25 09:30:00 | MSFT | Stock | 235.29 | 236.805 | 234.595 | 235.85 | 2592933.0 |
| 2021-03-25 10:00:00 | MSFT | Stock | 235.83 | 236.94 | 234.26 | 234.27 | 1701812.0 |
| 2021-03-25 10:30:00 | MSFT | Stock | 234.2619 | 234.33 | 232.73 | 232.88 | 1759073.0 |
| 2021-03-25 11:00:00 | MSFT | Stock | 232.89 | 233.05 | 231.72 | 232.77 | 1932150.0 |
| 2021-03-25 11:30:00 | MSFT | Stock | 232.775 | 233.13 | 231.57 | 232.31 | 1719316.0 |
| 2021-03-25 12:00:00 | MSFT | Stock | 232.32 | 232.72 | 231.78 | 232.63 | 1277742.0 |
| 2021-03-25 12:30:00 | MSFT | Stock | 232.63 | 232.71 | 231.81 | 232.155 | 1126685.0 |
| 2021-03-25 13:00:00 | MSFT | Stock | 232.15 | 233.12 | 231.57 | 232.46 | 1430563.0 |
| 2021-03-25 13:30:00 | MSFT | Stock | 232.48 | 232.84 | 232.1 | 232.3 | 1027100.0 |
> showing 50 of 116,497 rows — these rows as CSV