PREVIEW / stock_30min / 2020-12-14
file: by_date/stock_30min/2020/2020-12-14.parquet size: 2.2 MB rows: 110,655 symbols: 2,689
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-14 04:00:00 | AAPL | Stock | 122.2 | 122.47 | 122.16 | 122.17 | 17619.0 |
| 2020-12-14 04:30:00 | AAPL | Stock | 122.15 | 122.45 | 122.09 | 122.45 | 5783.0 |
| 2020-12-14 05:00:00 | AAPL | Stock | 122.45 | 122.48 | 122.39 | 122.48 | 1819.0 |
| 2020-12-14 05:30:00 | AAPL | Stock | 122.4 | 122.69 | 122.38 | 122.65 | 6517.0 |
| 2020-12-14 06:00:00 | AAPL | Stock | 122.6 | 122.65 | 122.59 | 122.59 | 2215.0 |
| 2020-12-14 06:30:00 | AAPL | Stock | 122.64 | 122.8 | 122.61 | 122.73 | 18484.0 |
| 2020-12-14 07:00:00 | AAPL | Stock | 122.73 | 123.08 | 122.55 | 122.97 | 121188.0 |
| 2020-12-14 07:30:00 | AAPL | Stock | 122.97 | 123.25 | 122.91 | 123.25 | 89574.0 |
| 2020-12-14 08:00:00 | AAPL | Stock | 123.23 | 123.26 | 122.33 | 122.7 | 339029.0 |
| 2020-12-14 08:30:00 | AAPL | Stock | 122.74 | 123.2 | 122.58 | 123.06 | 269944.0 |
| 2020-12-14 09:00:00 | AAPL | Stock | 123.1 | 123.12 | 122.54 | 122.58 | 304272.0 |
| 2020-12-14 09:30:00 | AAPL | Stock | 122.6 | 123.35 | 122.5 | 122.941 | 8782114.0 |
| 2020-12-14 10:00:00 | AAPL | Stock | 122.95 | 123.03 | 122.64 | 122.902 | 5193692.0 |
| 2020-12-14 10:30:00 | AAPL | Stock | 122.908 | 123.11 | 122.49 | 122.82 | 4737678.0 |
| 2020-12-14 11:00:00 | AAPL | Stock | 122.81 | 123.19 | 122.63 | 123.0 | 3663667.0 |
| 2020-12-14 11:30:00 | AAPL | Stock | 123.0 | 123.1 | 122.68 | 122.956 | 2968357.0 |
| 2020-12-14 12:00:00 | AAPL | Stock | 122.959 | 122.99 | 122.67 | 122.914 | 2640587.0 |
| 2020-12-14 12:30:00 | AAPL | Stock | 122.91 | 122.964 | 122.29 | 122.44 | 3054243.0 |
| 2020-12-14 13:00:00 | AAPL | Stock | 122.45 | 122.62 | 122.12 | 122.145 | 3193658.0 |
| 2020-12-14 13:30:00 | AAPL | Stock | 122.15 | 122.52 | 122.13 | 122.408 | 2601717.0 |
| 2020-12-14 14:00:00 | AAPL | Stock | 122.41 | 122.54 | 122.23 | 122.478 | 2358297.0 |
| 2020-12-14 14:30:00 | AAPL | Stock | 122.475 | 122.49 | 121.87 | 122.24 | 3446447.0 |
| 2020-12-14 15:00:00 | AAPL | Stock | 122.245 | 122.49 | 122.0 | 122.31 | 2868482.0 |
| 2020-12-14 15:30:00 | AAPL | Stock | 122.305 | 122.37 | 121.54 | 121.77 | 7197238.0 |
| 2020-12-14 16:00:00 | AAPL | Stock | 121.77 | 122.0 | 121.62 | 121.75 | 13582532.0 |
| 2020-12-14 16:30:00 | AAPL | Stock | 121.76 | 121.85 | 121.76 | 121.81 | 15538.0 |
| 2020-12-14 17:00:00 | AAPL | Stock | 121.81 | 121.85 | 121.75 | 121.8 | 16854.0 |
| 2020-12-14 17:30:00 | AAPL | Stock | 121.82 | 121.84 | 121.8 | 121.8 | 12710.0 |
| 2020-12-14 18:00:00 | AAPL | Stock | 121.8 | 121.85 | 121.8 | 121.84 | 11358.0 |
| 2020-12-14 18:30:00 | AAPL | Stock | 121.83 | 121.92 | 121.8 | 121.85 | 40298.0 |
| 2020-12-14 19:00:00 | AAPL | Stock | 121.9 | 121.93 | 121.77 | 121.8 | 31199.0 |
| 2020-12-14 19:30:00 | AAPL | Stock | 121.8 | 121.91 | 121.77 | 121.89 | 23864.0 |
| 2020-12-14 04:00:00 | MSFT | Stock | 213.38 | 213.38 | 212.99 | 213.06 | 1575.0 |
| 2020-12-14 05:00:00 | MSFT | Stock | 213.4 | 214.01 | 213.4 | 213.57 | 4933.0 |
| 2020-12-14 05:30:00 | MSFT | Stock | 213.8 | 213.8 | 213.8 | 213.8 | 335.0 |
| 2020-12-14 06:00:00 | MSFT | Stock | 213.81 | 213.93 | 213.81 | 213.93 | 418.0 |
| 2020-12-14 06:30:00 | MSFT | Stock | 213.92 | 213.93 | 213.92 | 213.93 | 386.0 |
| 2020-12-14 07:00:00 | MSFT | Stock | 213.93 | 214.0 | 213.79 | 214.0 | 3641.0 |
| 2020-12-14 07:30:00 | MSFT | Stock | 213.9 | 213.97 | 213.8 | 213.81 | 2440.0 |
| 2020-12-14 08:00:00 | MSFT | Stock | 213.8 | 213.99 | 212.73 | 213.224 | 46006.0 |
| 2020-12-14 08:30:00 | MSFT | Stock | 213.204 | 213.4 | 213.05 | 213.38 | 13327.0 |
| 2020-12-14 09:00:00 | MSFT | Stock | 213.38 | 213.62 | 212.85 | 212.96 | 26874.0 |
| 2020-12-14 09:30:00 | MSFT | Stock | 212.96 | 214.79 | 212.88 | 214.74 | 3004457.0 |
| 2020-12-14 10:00:00 | MSFT | Stock | 214.73 | 215.67 | 214.54 | 215.1 | 2078702.0 |
| 2020-12-14 10:30:00 | MSFT | Stock | 215.09 | 215.16 | 214.56 | 214.57 | 1355757.0 |
| 2020-12-14 11:00:00 | MSFT | Stock | 214.57 | 215.685 | 214.51 | 215.4 | 1476046.0 |
| 2020-12-14 11:30:00 | MSFT | Stock | 215.4 | 216.2 | 215.24 | 216.15 | 1373377.0 |
| 2020-12-14 12:00:00 | MSFT | Stock | 216.16 | 216.21 | 215.24 | 215.24 | 931481.0 |
| 2020-12-14 12:30:00 | MSFT | Stock | 215.27 | 215.41 | 214.382 | 214.57 | 933776.0 |
| 2020-12-14 13:00:00 | MSFT | Stock | 214.58 | 215.08 | 214.02 | 214.775 | 985502.0 |
> showing 50 of 110,655 rows — these rows as CSV