PREVIEW / stock_30min / 2021-11-09
file: by_date/stock_30min/2021/2021-11-09.parquet size: 2.3 MB rows: 114,296 symbols: 2,682
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-11-09 04:00:00 | AAPL | Stock | 150.03 | 150.33 | 150.01 | 150.16 | 5845.0 |
| 2021-11-09 04:30:00 | AAPL | Stock | 150.22 | 150.28 | 150.1 | 150.12 | 8382.0 |
| 2021-11-09 05:00:00 | AAPL | Stock | 150.13 | 150.28 | 150.12 | 150.12 | 5621.0 |
| 2021-11-09 05:30:00 | AAPL | Stock | 150.12 | 150.2 | 150.1 | 150.15 | 2405.0 |
| 2021-11-09 06:00:00 | AAPL | Stock | 150.12 | 150.16 | 150.02 | 150.02 | 5427.0 |
| 2021-11-09 06:30:00 | AAPL | Stock | 150.04 | 150.11 | 150.0 | 150.03 | 6810.0 |
| 2021-11-09 07:00:00 | AAPL | Stock | 150.03 | 150.24 | 150.01 | 150.06 | 31926.0 |
| 2021-11-09 07:30:00 | AAPL | Stock | 150.05 | 150.2 | 149.84 | 149.95 | 54603.0 |
| 2021-11-09 08:00:00 | AAPL | Stock | 150.06 | 150.24 | 149.85 | 150.11 | 154640.0 |
| 2021-11-09 08:30:00 | AAPL | Stock | 150.15 | 150.44 | 150.11 | 150.28 | 1715906.0 |
| 2021-11-09 09:00:00 | AAPL | Stock | 150.25 | 150.5 | 150.06 | 150.15 | 116177.0 |
| 2021-11-09 09:30:00 | AAPL | Stock | 150.19 | 151.428 | 150.07 | 150.96 | 8395674.0 |
| 2021-11-09 10:00:00 | AAPL | Stock | 150.95 | 150.96 | 150.15 | 150.63 | 4389144.0 |
| 2021-11-09 10:30:00 | AAPL | Stock | 150.63 | 151.2 | 150.58 | 150.865 | 2929331.0 |
| 2021-11-09 11:00:00 | AAPL | Stock | 150.87 | 151.17 | 150.575 | 150.61 | 2260288.0 |
| 2021-11-09 11:30:00 | AAPL | Stock | 150.615 | 151.069 | 150.61 | 150.8784 | 1910258.0 |
| 2021-11-09 12:00:00 | AAPL | Stock | 150.875 | 150.89 | 150.5 | 150.7 | 2298278.0 |
| 2021-11-09 12:30:00 | AAPL | Stock | 150.7 | 151.24 | 150.645 | 151.0101 | 2160234.0 |
| 2021-11-09 13:00:00 | AAPL | Stock | 151.015 | 151.22 | 150.955 | 151.005 | 1508043.0 |
| 2021-11-09 13:30:00 | AAPL | Stock | 151.01 | 151.145 | 150.545 | 150.71 | 1714197.0 |
| 2021-11-09 14:00:00 | AAPL | Stock | 150.7 | 150.83 | 150.615 | 150.7 | 1746052.0 |
| 2021-11-09 14:30:00 | AAPL | Stock | 150.7 | 150.98 | 150.66 | 150.825 | 1566077.0 |
| 2021-11-09 15:00:00 | AAPL | Stock | 150.82 | 150.9 | 150.625 | 150.67 | 1784933.0 |
| 2021-11-09 15:30:00 | AAPL | Stock | 150.67 | 151.13 | 150.645 | 150.83 | 4064347.0 |
| 2021-11-09 16:00:00 | AAPL | Stock | 150.81 | 150.9 | 150.66 | 150.71 | 7059528.0 |
| 2021-11-09 16:30:00 | AAPL | Stock | 150.72 | 150.81 | 150.33 | 150.5 | 82831.0 |
| 2021-11-09 17:00:00 | AAPL | Stock | 150.51 | 150.66 | 150.5 | 150.62 | 19700.0 |
| 2021-11-09 17:30:00 | AAPL | Stock | 150.61 | 150.67 | 150.61 | 150.66 | 6325.0 |
| 2021-11-09 18:00:00 | AAPL | Stock | 150.64 | 150.64 | 150.5 | 150.51 | 11700.0 |
| 2021-11-09 18:30:00 | AAPL | Stock | 150.54 | 150.55 | 150.5 | 150.5 | 8729.0 |
| 2021-11-09 19:00:00 | AAPL | Stock | 150.49 | 150.63 | 150.46 | 150.55 | 16992.0 |
| 2021-11-09 19:30:00 | AAPL | Stock | 150.55 | 150.67 | 150.5 | 150.65 | 17689.0 |
| 2021-11-09 04:00:00 | MSFT | Stock | 336.55 | 336.57 | 336.55 | 336.55 | 882.0 |
| 2021-11-09 04:30:00 | MSFT | Stock | 336.4 | 336.74 | 336.23 | 336.3 | 3210.0 |
| 2021-11-09 05:00:00 | MSFT | Stock | 336.49 | 336.97 | 336.49 | 336.73 | 1570.0 |
| 2021-11-09 05:30:00 | MSFT | Stock | 336.54 | 337.3 | 336.54 | 337.23 | 2339.0 |
| 2021-11-09 06:00:00 | MSFT | Stock | 337.38 | 337.42 | 337.1 | 337.1 | 5272.0 |
| 2021-11-09 06:30:00 | MSFT | Stock | 337.21 | 337.21 | 337.11 | 337.11 | 1274.0 |
| 2021-11-09 07:00:00 | MSFT | Stock | 337.08 | 337.08 | 336.54 | 336.66 | 14259.0 |
| 2021-11-09 07:30:00 | MSFT | Stock | 336.62 | 336.74 | 336.1 | 336.35 | 5711.0 |
| 2021-11-09 08:00:00 | MSFT | Stock | 336.5305 | 337.22 | 336.08 | 336.7 | 20987.0 |
| 2021-11-09 08:30:00 | MSFT | Stock | 336.8 | 337.35 | 336.7 | 337.06 | 168280.0 |
| 2021-11-09 09:00:00 | MSFT | Stock | 337.16 | 337.18 | 336.5 | 336.9 | 6730.0 |
| 2021-11-09 09:30:00 | MSFT | Stock | 336.97 | 338.72 | 336.64 | 336.9 | 2035664.0 |
| 2021-11-09 10:00:00 | MSFT | Stock | 336.89 | 337.27 | 336.06 | 336.8 | 1264683.0 |
| 2021-11-09 10:30:00 | MSFT | Stock | 336.77 | 337.83 | 336.72 | 337.03 | 810212.0 |
| 2021-11-09 11:00:00 | MSFT | Stock | 337.02 | 337.25 | 336.15 | 336.51 | 760101.0 |
| 2021-11-09 11:30:00 | MSFT | Stock | 336.52 | 337.15 | 336.155 | 336.61 | 661861.0 |
| 2021-11-09 12:00:00 | MSFT | Stock | 336.58 | 336.8 | 335.92 | 336.09 | 627298.0 |
| 2021-11-09 12:30:00 | MSFT | Stock | 336.06 | 336.57 | 335.79 | 336.08 | 654153.0 |
> showing 50 of 114,296 rows — these rows as CSV