PREVIEW / stock_30min / 2020-10-26
file: by_date/stock_30min/2020/2020-10-26.parquet size: 2.0 MB rows: 98,118 symbols: 2,521
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-10-26 04:00:00 | AAPL | Stock | 113.7 | 113.79 | 113.4 | 113.5 | 36589.0 |
| 2020-10-26 04:30:00 | AAPL | Stock | 113.5 | 113.74 | 113.31 | 113.64 | 39366.0 |
| 2020-10-26 05:00:00 | AAPL | Stock | 113.63 | 113.87 | 113.61 | 113.8 | 12869.0 |
| 2020-10-26 05:30:00 | AAPL | Stock | 113.79 | 113.8 | 113.5 | 113.56 | 12022.0 |
| 2020-10-26 06:00:00 | AAPL | Stock | 113.6 | 114.15 | 113.52 | 114.01 | 21078.0 |
| 2020-10-26 06:30:00 | AAPL | Stock | 114.11 | 114.28 | 113.91 | 114.09 | 30000.0 |
| 2020-10-26 07:00:00 | AAPL | Stock | 114.15 | 114.36 | 113.9 | 114.01 | 195799.0 |
| 2020-10-26 07:30:00 | AAPL | Stock | 114.03 | 114.1 | 113.65 | 113.75 | 158772.0 |
| 2020-10-26 08:00:00 | AAPL | Stock | 114.3 | 115.32 | 113.58 | 113.78 | 435168.0 |
| 2020-10-26 08:30:00 | AAPL | Stock | 113.8 | 113.94 | 113.55 | 113.66 | 204153.0 |
| 2020-10-26 09:00:00 | AAPL | Stock | 113.65 | 114.13 | 113.6 | 114.03 | 411007.0 |
| 2020-10-26 09:30:00 | AAPL | Stock | 114.01 | 115.87 | 113.7 | 115.7 | 13297576.0 |
| 2020-10-26 10:00:00 | AAPL | Stock | 115.71 | 116.55 | 115.5 | 115.63 | 7872764.0 |
| 2020-10-26 10:30:00 | AAPL | Stock | 115.636 | 115.64 | 114.87 | 114.93 | 7251527.0 |
| 2020-10-26 11:00:00 | AAPL | Stock | 114.93 | 114.98 | 114.28 | 114.345 | 7333381.0 |
| 2020-10-26 11:30:00 | AAPL | Stock | 114.35 | 114.6 | 113.89 | 114.18 | 7031782.0 |
| 2020-10-26 12:00:00 | AAPL | Stock | 114.17 | 114.68 | 113.99 | 114.485 | 4729384.0 |
| 2020-10-26 12:30:00 | AAPL | Stock | 114.48 | 114.48 | 113.86 | 113.94 | 4651356.0 |
| 2020-10-26 13:00:00 | AAPL | Stock | 113.935 | 114.14 | 113.18 | 113.21 | 5809714.0 |
| 2020-10-26 13:30:00 | AAPL | Stock | 113.208 | 113.88 | 112.88 | 113.83 | 6638734.0 |
| 2020-10-26 14:00:00 | AAPL | Stock | 113.835 | 114.24 | 113.67 | 114.148 | 4887380.0 |
| 2020-10-26 14:30:00 | AAPL | Stock | 114.15 | 114.4 | 113.88 | 114.16 | 4896445.0 |
| 2020-10-26 15:00:00 | AAPL | Stock | 114.165 | 114.71 | 113.9 | 114.7 | 5218665.0 |
| 2020-10-26 15:30:00 | AAPL | Stock | 114.698 | 115.22 | 114.27 | 115.06 | 11337195.0 |
| 2020-10-26 16:00:00 | AAPL | Stock | 115.05 | 115.25 | 114.135 | 115.15 | 8277264.0 |
| 2020-10-26 16:30:00 | AAPL | Stock | 115.15 | 115.2 | 115.05 | 115.17 | 97847.0 |
| 2020-10-26 17:00:00 | AAPL | Stock | 115.15 | 115.18 | 115.05 | 115.08 | 65818.0 |
| 2020-10-26 17:30:00 | AAPL | Stock | 115.08 | 115.19 | 115.05 | 115.179 | 602821.0 |
| 2020-10-26 18:00:00 | AAPL | Stock | 115.18 | 115.25 | 115.09 | 115.16 | 74085.0 |
| 2020-10-26 18:30:00 | AAPL | Stock | 115.16 | 115.18 | 115.08 | 115.09 | 41629.0 |
| 2020-10-26 19:00:00 | AAPL | Stock | 115.09 | 115.2 | 115.0 | 115.15 | 59173.0 |
| 2020-10-26 19:30:00 | AAPL | Stock | 115.15 | 115.16 | 114.81 | 114.86 | 98258.0 |
| 2020-10-26 04:00:00 | MSFT | Stock | 214.07 | 214.2 | 213.51 | 213.51 | 7271.0 |
| 2020-10-26 04:30:00 | MSFT | Stock | 213.5 | 214.09 | 213.3 | 214.09 | 18592.0 |
| 2020-10-26 05:00:00 | MSFT | Stock | 213.99 | 214.15 | 213.81 | 214.05 | 2228.0 |
| 2020-10-26 05:30:00 | MSFT | Stock | 213.96 | 214.0 | 213.71 | 214.0 | 2530.0 |
| 2020-10-26 06:00:00 | MSFT | Stock | 213.9 | 214.0 | 213.8 | 214.0 | 2682.0 |
| 2020-10-26 06:30:00 | MSFT | Stock | 214.17 | 214.36 | 213.91 | 214.02 | 7221.0 |
| 2020-10-26 07:00:00 | MSFT | Stock | 214.14 | 215.11 | 214.0 | 214.59 | 33042.0 |
| 2020-10-26 07:30:00 | MSFT | Stock | 214.6 | 214.76 | 214.02 | 214.02 | 11672.0 |
| 2020-10-26 08:00:00 | MSFT | Stock | 214.644 | 215.1 | 213.8 | 214.01 | 44384.0 |
| 2020-10-26 08:30:00 | MSFT | Stock | 213.99 | 214.3 | 213.88 | 214.006 | 26725.0 |
| 2020-10-26 09:00:00 | MSFT | Stock | 214.03 | 214.64 | 213.82 | 213.85 | 48781.0 |
| 2020-10-26 09:30:00 | MSFT | Stock | 213.85 | 215.92 | 213.65 | 215.59 | 2416373.0 |
| 2020-10-26 10:00:00 | MSFT | Stock | 215.578 | 216.34 | 214.7 | 214.83 | 1512970.0 |
| 2020-10-26 10:30:00 | MSFT | Stock | 214.82 | 214.83 | 212.8 | 213.0 | 1922773.0 |
| 2020-10-26 11:00:00 | MSFT | Stock | 213.01 | 213.02 | 210.64 | 210.71 | 2834541.0 |
| 2020-10-26 11:30:00 | MSFT | Stock | 210.71 | 211.28 | 209.77 | 210.78 | 2617730.0 |
| 2020-10-26 12:00:00 | MSFT | Stock | 210.78 | 211.3 | 210.37 | 211.13 | 1629136.0 |
| 2020-10-26 12:30:00 | MSFT | Stock | 211.12 | 211.13 | 209.57 | 209.685 | 1505568.0 |
> showing 50 of 98,118 rows — these rows as CSV