PREVIEW / stock_30min / 2020-12-24
file: by_date/stock_30min/2020/2020-12-24.parquet size: 1.4 MB rows: 67,756 symbols: 2,659
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-24 04:00:00 | AAPL | Stock | 131.05 | 131.15 | 131.0 | 131.0 | 8645.0 |
| 2020-12-24 04:30:00 | AAPL | Stock | 131.0 | 131.09 | 131.0 | 131.0 | 4283.0 |
| 2020-12-24 05:00:00 | AAPL | Stock | 131.01 | 131.05 | 131.0 | 131.05 | 1981.0 |
| 2020-12-24 05:30:00 | AAPL | Stock | 130.9 | 130.9 | 130.7 | 130.7 | 5577.0 |
| 2020-12-24 06:00:00 | AAPL | Stock | 130.77 | 130.82 | 130.69 | 130.82 | 12728.0 |
| 2020-12-24 06:30:00 | AAPL | Stock | 130.98 | 130.98 | 130.9 | 130.9 | 1160.0 |
| 2020-12-24 07:00:00 | AAPL | Stock | 131.0 | 131.05 | 130.93 | 131.0 | 71750.0 |
| 2020-12-24 07:30:00 | AAPL | Stock | 131.0 | 131.1 | 130.96 | 131.07 | 52901.0 |
| 2020-12-24 08:00:00 | AAPL | Stock | 131.05 | 131.13 | 130.9 | 131.11 | 183133.0 |
| 2020-12-24 08:30:00 | AAPL | Stock | 131.09 | 131.46 | 131.0 | 131.27 | 227097.0 |
| 2020-12-24 09:00:00 | AAPL | Stock | 131.28 | 131.48 | 131.07 | 131.33 | 177578.0 |
| 2020-12-24 09:30:00 | AAPL | Stock | 131.33 | 133.18 | 131.1 | 132.481 | 12642235.0 |
| 2020-12-24 10:00:00 | AAPL | Stock | 132.48 | 133.16 | 132.24 | 133.136 | 6798992.0 |
| 2020-12-24 10:30:00 | AAPL | Stock | 133.134 | 133.46 | 132.51 | 132.515 | 7896461.0 |
| 2020-12-24 11:00:00 | AAPL | Stock | 132.515 | 132.64 | 132.11 | 132.147 | 5055173.0 |
| 2020-12-24 11:30:00 | AAPL | Stock | 132.16 | 132.36 | 131.65 | 131.86 | 4110075.0 |
| 2020-12-24 12:00:00 | AAPL | Stock | 131.86 | 132.15 | 131.59 | 131.88 | 3858410.0 |
| 2020-12-24 12:30:00 | AAPL | Stock | 131.88 | 132.05 | 131.61 | 131.99 | 5539422.0 |
| 2020-12-24 13:00:00 | AAPL | Stock | 131.97 | 132.07 | 131.9 | 132.0 | 1822875.0 |
| 2020-12-24 13:30:00 | AAPL | Stock | 131.95 | 132.05 | 131.92 | 131.92 | 54937.0 |
| 2020-12-24 14:00:00 | AAPL | Stock | 131.94 | 131.99 | 131.92 | 131.975 | 23249.0 |
| 2020-12-24 14:30:00 | AAPL | Stock | 131.98 | 131.99 | 131.89 | 131.9 | 26522.0 |
| 2020-12-24 15:00:00 | AAPL | Stock | 131.96 | 131.96 | 131.85 | 131.88 | 19149.0 |
| 2020-12-24 15:30:00 | AAPL | Stock | 131.88 | 131.9 | 131.85 | 131.89 | 15670.0 |
| 2020-12-24 16:00:00 | AAPL | Stock | 131.9 | 131.98 | 131.89 | 131.91 | 5156.0 |
| 2020-12-24 16:30:00 | AAPL | Stock | 131.9 | 132.0 | 131.9 | 131.99 | 18030.0 |
| 2020-12-24 05:30:00 | MSFT | Stock | 221.12 | 221.12 | 221.12 | 221.12 | 100.0 |
| 2020-12-24 07:00:00 | MSFT | Stock | 221.29 | 221.77 | 221.29 | 221.58 | 1317.0 |
| 2020-12-24 07:30:00 | MSFT | Stock | 221.61 | 221.61 | 221.41 | 221.43 | 1407.0 |
| 2020-12-24 08:00:00 | MSFT | Stock | 221.888 | 221.888 | 220.47 | 221.35 | 5612.0 |
| 2020-12-24 08:30:00 | MSFT | Stock | 221.35 | 221.6 | 221.35 | 221.57 | 3032.0 |
| 2020-12-24 09:00:00 | MSFT | Stock | 221.5 | 221.6 | 221.49 | 221.5 | 1683.0 |
| 2020-12-24 09:30:00 | MSFT | Stock | 221.42 | 222.945 | 221.2 | 222.08 | 1424847.0 |
| 2020-12-24 10:00:00 | MSFT | Stock | 222.07 | 223.61 | 222.07 | 223.355 | 1248047.0 |
| 2020-12-24 10:30:00 | MSFT | Stock | 223.36 | 223.54 | 222.08 | 222.11 | 871987.0 |
| 2020-12-24 11:00:00 | MSFT | Stock | 222.11 | 222.4 | 221.914 | 221.96 | 736471.0 |
| 2020-12-24 11:30:00 | MSFT | Stock | 221.96 | 222.33 | 221.269 | 221.67 | 754923.0 |
| 2020-12-24 12:00:00 | MSFT | Stock | 221.679 | 222.23 | 221.44 | 222.225 | 800269.0 |
| 2020-12-24 12:30:00 | MSFT | Stock | 222.22 | 223.5 | 222.17 | 222.71 | 1821210.0 |
| 2020-12-24 13:00:00 | MSFT | Stock | 222.75 | 223.0 | 222.41 | 222.59 | 880692.0 |
| 2020-12-24 13:30:00 | MSFT | Stock | 222.59 | 222.65 | 222.51 | 222.6 | 4455.0 |
| 2020-12-24 14:00:00 | MSFT | Stock | 222.6 | 222.7 | 222.59 | 222.59 | 793.0 |
| 2020-12-24 14:30:00 | MSFT | Stock | 222.645 | 222.69 | 222.6 | 222.635 | 502.0 |
| 2020-12-24 15:00:00 | MSFT | Stock | 222.59 | 222.59 | 222.5 | 222.5 | 3648.0 |
| 2020-12-24 15:30:00 | MSFT | Stock | 222.5 | 222.5 | 222.5 | 222.5 | 200.0 |
| 2020-12-24 16:00:00 | MSFT | Stock | 222.5 | 222.55 | 222.5 | 222.55 | 2301.0 |
| 2020-12-24 16:30:00 | MSFT | Stock | 222.55 | 222.55 | 222.45 | 222.51 | 721.0 |
| 2020-12-24 07:00:00 | NVDA | Stock | 13.0588 | 13.0625 | 13.055 | 13.055 | 32160.0 |
| 2020-12-24 07:30:00 | NVDA | Stock | 13.055 | 13.0562 | 13.0445 | 13.0562 | 112720.0 |
| 2020-12-24 08:00:00 | NVDA | Stock | 13.0571 | 13.0648 | 13.025 | 13.0325 | 412840.0 |
> showing 50 of 67,756 rows — these rows as CSV