PREVIEW / stock_30min / 2018-05-10
file: by_date/stock_30min/2018/2018-05-10.parquet size: 1.7 MB rows: 83,555 symbols: 2,842
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-10 04:00:00 | AAPL | Stock | 46.86 | 46.86 | 46.84 | 46.84 | 27600.0 |
| 2018-05-10 05:30:00 | AAPL | Stock | 46.805 | 46.805 | 46.8 | 46.8 | 7600.0 |
| 2018-05-10 06:00:00 | AAPL | Stock | 46.805 | 46.805 | 46.805 | 46.805 | 800.0 |
| 2018-05-10 06:30:00 | AAPL | Stock | 46.8 | 46.8 | 46.8 | 46.8 | 3600.0 |
| 2018-05-10 07:00:00 | AAPL | Stock | 46.8325 | 46.8475 | 46.8075 | 46.8375 | 47124.0 |
| 2018-05-10 07:30:00 | AAPL | Stock | 46.845 | 46.875 | 46.845 | 46.865 | 61960.0 |
| 2018-05-10 08:00:00 | AAPL | Stock | 46.8625 | 46.885 | 46.8 | 46.8425 | 184548.0 |
| 2018-05-10 08:30:00 | AAPL | Stock | 46.8375 | 46.9675 | 46.8375 | 46.9625 | 275128.0 |
| 2018-05-10 09:00:00 | AAPL | Stock | 46.9425 | 46.9875 | 46.9 | 46.9225 | 229172.0 |
| 2018-05-10 09:30:00 | AAPL | Stock | 46.935 | 47.14 | 46.9125 | 47.0 | 13835416.0 |
| 2018-05-10 10:00:00 | AAPL | Stock | 47.0 | 47.1575 | 46.9362 | 47.1525 | 8662428.0 |
| 2018-05-10 10:30:00 | AAPL | Stock | 47.15 | 47.1775 | 47.0875 | 47.1675 | 5096176.0 |
| 2018-05-10 11:00:00 | AAPL | Stock | 47.165 | 47.3888 | 47.1488 | 47.32 | 8636100.0 |
| 2018-05-10 11:30:00 | AAPL | Stock | 47.32 | 47.4625 | 47.295 | 47.4427 | 7031932.0 |
| 2018-05-10 12:00:00 | AAPL | Stock | 47.445 | 47.5 | 47.3602 | 47.4475 | 7644984.0 |
| 2018-05-10 12:30:00 | AAPL | Stock | 47.445 | 47.4625 | 47.37 | 47.46 | 3227336.0 |
| 2018-05-10 13:00:00 | AAPL | Stock | 47.46 | 47.5625 | 47.4525 | 47.5125 | 7349880.0 |
| 2018-05-10 13:30:00 | AAPL | Stock | 47.5125 | 47.5925 | 47.42 | 47.4712 | 6128388.0 |
| 2018-05-10 14:00:00 | AAPL | Stock | 47.4725 | 47.525 | 47.4175 | 47.52 | 3384356.0 |
| 2018-05-10 14:30:00 | AAPL | Stock | 47.5215 | 47.5475 | 47.3675 | 47.4925 | 4772660.0 |
| 2018-05-10 15:00:00 | AAPL | Stock | 47.4948 | 47.525 | 47.4275 | 47.5115 | 5570960.0 |
| 2018-05-10 15:30:00 | AAPL | Stock | 47.5125 | 47.5675 | 47.4525 | 47.5075 | 12298936.0 |
| 2018-05-10 16:00:00 | AAPL | Stock | 47.5075 | 47.52 | 47.475 | 47.475 | 4649096.0 |
| 2018-05-10 16:30:00 | AAPL | Stock | 47.475 | 47.51 | 47.3825 | 47.3975 | 131480.0 |
| 2018-05-10 17:00:00 | AAPL | Stock | 47.405 | 47.4375 | 47.405 | 47.4375 | 48808.0 |
| 2018-05-10 17:30:00 | AAPL | Stock | 47.4375 | 47.45 | 47.4125 | 47.435 | 32992.0 |
| 2018-05-10 18:00:00 | AAPL | Stock | 47.4375 | 47.485 | 47.4375 | 47.44 | 24384.0 |
| 2018-05-10 18:30:00 | AAPL | Stock | 47.44 | 47.475 | 47.44 | 47.475 | 21328.0 |
| 2018-05-10 19:00:00 | AAPL | Stock | 47.475 | 47.475 | 47.45 | 47.45 | 25800.0 |
| 2018-05-10 19:30:00 | AAPL | Stock | 47.4625 | 47.5 | 47.4525 | 47.4625 | 53324.0 |
| 2018-05-10 04:00:00 | MSFT | Stock | 97.0 | 97.0 | 97.0 | 97.0 | 187.0 |
| 2018-05-10 06:30:00 | MSFT | Stock | 97.06 | 97.06 | 97.05 | 97.05 | 300.0 |
| 2018-05-10 07:30:00 | MSFT | Stock | 97.0 | 97.06 | 97.0 | 97.06 | 2499.0 |
| 2018-05-10 08:00:00 | MSFT | Stock | 97.0 | 97.15 | 96.94 | 96.94 | 6126.0 |
| 2018-05-10 08:30:00 | MSFT | Stock | 97.05 | 97.24 | 97.05 | 97.15 | 7052.0 |
| 2018-05-10 09:00:00 | MSFT | Stock | 97.11 | 97.37 | 97.1 | 97.37 | 17765.0 |
| 2018-05-10 09:30:00 | MSFT | Stock | 97.36 | 97.58 | 97.09 | 97.24 | 2128572.0 |
| 2018-05-10 10:00:00 | MSFT | Stock | 97.25 | 97.72 | 97.07 | 97.68 | 1276516.0 |
| 2018-05-10 10:30:00 | MSFT | Stock | 97.68 | 97.78 | 97.54 | 97.62 | 938007.0 |
| 2018-05-10 11:00:00 | MSFT | Stock | 97.615 | 97.84 | 97.57 | 97.75 | 813980.0 |
| 2018-05-10 11:30:00 | MSFT | Stock | 97.76 | 97.77 | 97.54 | 97.58 | 737780.0 |
| 2018-05-10 12:00:00 | MSFT | Stock | 97.586 | 97.87 | 97.48 | 97.83 | 950487.0 |
| 2018-05-10 12:30:00 | MSFT | Stock | 97.82 | 97.832 | 97.62 | 97.67 | 693449.0 |
| 2018-05-10 13:00:00 | MSFT | Stock | 97.68 | 97.8 | 97.544 | 97.57 | 923403.0 |
| 2018-05-10 13:30:00 | MSFT | Stock | 97.57 | 97.65 | 97.23 | 97.35 | 828911.0 |
| 2018-05-10 14:00:00 | MSFT | Stock | 97.35 | 97.406 | 97.18 | 97.325 | 1421412.0 |
| 2018-05-10 14:30:00 | MSFT | Stock | 97.33 | 97.55 | 97.05 | 97.53 | 924397.0 |
| 2018-05-10 15:00:00 | MSFT | Stock | 97.53 | 97.63 | 97.37 | 97.62 | 1052548.0 |
| 2018-05-10 15:30:00 | MSFT | Stock | 97.62 | 97.95 | 97.505 | 97.9 | 2236616.0 |
| 2018-05-10 16:00:00 | MSFT | Stock | 97.9 | 97.92 | 97.66 | 97.87 | 5857051.0 |
> showing 50 of 83,555 rows — these rows as CSV