PREVIEW / stock_30min / 2016-06-08
file: by_date/stock_30min/2016/2016-06-08.parquet size: 1.6 MB rows: 82,847 symbols: 3,307
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-08 06:30:00 | AAPL | Stock | 24.75 | 24.75 | 24.75 | 24.75 | 800.0 |
| 2016-06-08 07:00:00 | AAPL | Stock | 24.7625 | 24.7625 | 24.7575 | 24.7575 | 10508.0 |
| 2016-06-08 07:30:00 | AAPL | Stock | 24.78 | 24.7875 | 24.78 | 24.7875 | 3240.0 |
| 2016-06-08 08:00:00 | AAPL | Stock | 24.7575 | 24.795 | 24.7575 | 24.785 | 28160.0 |
| 2016-06-08 08:30:00 | AAPL | Stock | 24.7925 | 24.7925 | 24.775 | 24.7875 | 12108.0 |
| 2016-06-08 09:00:00 | AAPL | Stock | 24.795 | 24.8125 | 24.7575 | 24.7575 | 210804.0 |
| 2016-06-08 09:30:00 | AAPL | Stock | 24.755 | 24.89 | 24.755 | 24.8725 | 10024272.0 |
| 2016-06-08 10:00:00 | AAPL | Stock | 24.875 | 24.8775 | 24.7078 | 24.7425 | 8658536.0 |
| 2016-06-08 10:30:00 | AAPL | Stock | 24.7425 | 24.78 | 24.6825 | 24.686 | 7130336.0 |
| 2016-06-08 11:00:00 | AAPL | Stock | 24.6852 | 24.7425 | 24.67 | 24.7295 | 5222748.0 |
| 2016-06-08 11:30:00 | AAPL | Stock | 24.73 | 24.805 | 24.73 | 24.765 | 4787180.0 |
| 2016-06-08 12:00:00 | AAPL | Stock | 24.7675 | 24.7902 | 24.7575 | 24.7775 | 2485384.0 |
| 2016-06-08 12:30:00 | AAPL | Stock | 24.7775 | 24.785 | 24.735 | 24.7675 | 2731636.0 |
| 2016-06-08 13:00:00 | AAPL | Stock | 24.77 | 24.785 | 24.725 | 24.7273 | 3200064.0 |
| 2016-06-08 13:30:00 | AAPL | Stock | 24.7258 | 24.7475 | 24.7138 | 24.7275 | 3554892.0 |
| 2016-06-08 14:00:00 | AAPL | Stock | 24.7275 | 24.775 | 24.7175 | 24.7675 | 3516372.0 |
| 2016-06-08 14:30:00 | AAPL | Stock | 24.7675 | 24.775 | 24.73 | 24.7355 | 3562572.0 |
| 2016-06-08 15:00:00 | AAPL | Stock | 24.7375 | 24.765 | 24.725 | 24.73 | 4150828.0 |
| 2016-06-08 15:30:00 | AAPL | Stock | 24.7305 | 24.7425 | 24.6975 | 24.735 | 8371552.0 |
| 2016-06-08 16:00:00 | AAPL | Stock | 24.735 | 24.86 | 24.705 | 24.73 | 6844508.0 |
| 2016-06-08 16:30:00 | AAPL | Stock | 24.7325 | 24.7325 | 24.71 | 24.71 | 11336.0 |
| 2016-06-08 17:00:00 | AAPL | Stock | 24.7075 | 24.71 | 24.6875 | 24.6875 | 59148.0 |
| 2016-06-08 17:30:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 1600.0 |
| 2016-06-08 18:00:00 | AAPL | Stock | 24.7125 | 24.7175 | 24.7125 | 24.7175 | 5328.0 |
| 2016-06-08 18:30:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7075 | 24.7125 | 1600.0 |
| 2016-06-08 19:30:00 | AAPL | Stock | 24.7 | 24.7075 | 24.6925 | 24.7 | 20508.0 |
| 2016-06-08 08:30:00 | MSFT | Stock | 52.09 | 52.09 | 52.09 | 52.09 | 1000.0 |
| 2016-06-08 09:00:00 | MSFT | Stock | 52.12 | 52.15 | 52.01 | 52.01 | 8755.0 |
| 2016-06-08 09:30:00 | MSFT | Stock | 52.01 | 52.44 | 52.0 | 52.29 | 1828452.0 |
| 2016-06-08 10:00:00 | MSFT | Stock | 52.285 | 52.295 | 51.87 | 51.96 | 2153215.0 |
| 2016-06-08 10:30:00 | MSFT | Stock | 51.965 | 52.12 | 51.95 | 52.03 | 1197402.0 |
| 2016-06-08 11:00:00 | MSFT | Stock | 52.03 | 52.14 | 51.94 | 51.985 | 1412538.0 |
| 2016-06-08 11:30:00 | MSFT | Stock | 51.99 | 52.13 | 51.98 | 52.13 | 1356148.0 |
| 2016-06-08 12:00:00 | MSFT | Stock | 52.13 | 52.23 | 52.11 | 52.17 | 1014978.0 |
| 2016-06-08 12:30:00 | MSFT | Stock | 52.165 | 52.2 | 52.075 | 52.155 | 717933.0 |
| 2016-06-08 13:00:00 | MSFT | Stock | 52.16 | 52.2 | 52.02 | 52.02 | 684582.0 |
| 2016-06-08 13:30:00 | MSFT | Stock | 52.02 | 52.08 | 52.01 | 52.05 | 754127.0 |
| 2016-06-08 14:00:00 | MSFT | Stock | 52.045 | 52.18 | 51.97 | 52.175 | 985345.0 |
| 2016-06-08 14:30:00 | MSFT | Stock | 52.18 | 52.18 | 52.05 | 52.05 | 1002854.0 |
| 2016-06-08 15:00:00 | MSFT | Stock | 52.05 | 52.1 | 52.0 | 52.055 | 1054814.0 |
| 2016-06-08 15:30:00 | MSFT | Stock | 52.06 | 52.07 | 51.97 | 52.04 | 2677219.0 |
| 2016-06-08 16:00:00 | MSFT | Stock | 52.04 | 52.156 | 52.04 | 52.07 | 2372766.0 |
| 2016-06-08 17:30:00 | MSFT | Stock | 52.0 | 52.0 | 52.0 | 52.0 | 2600.0 |
| 2016-06-08 18:00:00 | MSFT | Stock | 52.0 | 52.0 | 52.0 | 52.0 | 100.0 |
| 2016-06-08 19:00:00 | MSFT | Stock | 52.0 | 52.0 | 52.0 | 52.0 | 500.0 |
| 2016-06-08 19:30:00 | MSFT | Stock | 52.0 | 52.0 | 52.0 | 52.0 | 100.0 |
| 2016-06-08 08:00:00 | NVDA | Stock | 1.1668 | 1.1668 | 1.163 | 1.163 | 36000.0 |
| 2016-06-08 09:00:00 | NVDA | Stock | 1.166 | 1.166 | 1.1588 | 1.1595 | 61760.0 |
| 2016-06-08 09:30:00 | NVDA | Stock | 1.1585 | 1.1628 | 1.1512 | 1.1515 | 32164720.0 |
| 2016-06-08 10:00:00 | NVDA | Stock | 1.1512 | 1.1524 | 1.145 | 1.1493 | 29159840.0 |
> showing 50 of 82,847 rows — these rows as CSV