PREVIEW / stock_30min / 2014-08-21
file: by_date/stock_30min/2014/2014-08-21.parquet size: 1.6 MB rows: 82,118 symbols: 3,581
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-21 04:00:00 | AAPL | Stock | 25.12 | 25.1275 | 25.11 | 25.11 | 48560.0 |
| 2014-08-21 04:30:00 | AAPL | Stock | 25.11 | 25.1125 | 25.1025 | 25.11 | 10200.0 |
| 2014-08-21 05:00:00 | AAPL | Stock | 25.11 | 25.1125 | 25.1025 | 25.1025 | 9120.0 |
| 2014-08-21 05:30:00 | AAPL | Stock | 25.115 | 25.125 | 25.115 | 25.125 | 6660.0 |
| 2014-08-21 06:00:00 | AAPL | Stock | 25.1325 | 25.1375 | 25.13 | 25.1325 | 8000.0 |
| 2014-08-21 06:30:00 | AAPL | Stock | 25.135 | 25.155 | 25.135 | 25.1525 | 26000.0 |
| 2014-08-21 07:00:00 | AAPL | Stock | 25.1375 | 25.155 | 25.125 | 25.155 | 43520.0 |
| 2014-08-21 07:30:00 | AAPL | Stock | 25.1425 | 25.15 | 25.115 | 25.115 | 98772.0 |
| 2014-08-21 08:00:00 | AAPL | Stock | 25.1225 | 25.15 | 25.09 | 25.13 | 325680.0 |
| 2014-08-21 08:30:00 | AAPL | Stock | 25.1325 | 25.17 | 25.12 | 25.17 | 389760.0 |
| 2014-08-21 09:00:00 | AAPL | Stock | 25.165 | 25.1725 | 25.1225 | 25.14 | 315312.0 |
| 2014-08-21 09:30:00 | AAPL | Stock | 25.1425 | 25.195 | 25.0875 | 25.1538 | 20885760.0 |
| 2014-08-21 10:00:00 | AAPL | Stock | 25.155 | 25.16 | 25.0275 | 25.0962 | 15781980.0 |
| 2014-08-21 10:30:00 | AAPL | Stock | 25.095 | 25.155 | 25.095 | 25.1097 | 8450652.0 |
| 2014-08-21 11:00:00 | AAPL | Stock | 25.11 | 25.12 | 25.085 | 25.0938 | 6689088.0 |
| 2014-08-21 11:30:00 | AAPL | Stock | 25.095 | 25.1368 | 25.09 | 25.1115 | 5935752.0 |
| 2014-08-21 12:00:00 | AAPL | Stock | 25.11 | 25.1375 | 25.0875 | 25.1127 | 6418472.0 |
| 2014-08-21 12:30:00 | AAPL | Stock | 25.115 | 25.125 | 25.0875 | 25.1175 | 4081420.0 |
| 2014-08-21 13:00:00 | AAPL | Stock | 25.1175 | 25.1475 | 25.1125 | 25.1338 | 5056172.0 |
| 2014-08-21 13:30:00 | AAPL | Stock | 25.1338 | 25.1675 | 25.1225 | 25.1585 | 5394576.0 |
| 2014-08-21 14:00:00 | AAPL | Stock | 25.1588 | 25.235 | 25.155 | 25.2115 | 9445904.0 |
| 2014-08-21 14:30:00 | AAPL | Stock | 25.2122 | 25.2212 | 25.2025 | 25.2075 | 5001424.0 |
| 2014-08-21 15:00:00 | AAPL | Stock | 25.2087 | 25.2125 | 25.18 | 25.2025 | 6055260.0 |
| 2014-08-21 15:30:00 | AAPL | Stock | 25.2025 | 25.205 | 25.1175 | 25.1475 | 13159924.0 |
| 2014-08-21 16:00:00 | AAPL | Stock | 25.145 | 25.16 | 25.1122 | 25.135 | 9733580.0 |
| 2014-08-21 16:30:00 | AAPL | Stock | 25.135 | 25.15 | 20.7615 | 25.145 | 79900.0 |
| 2014-08-21 17:00:00 | AAPL | Stock | 25.1475 | 25.1475 | 25.14 | 25.14 | 52464.0 |
| 2014-08-21 17:30:00 | AAPL | Stock | 25.145 | 25.15 | 25.1375 | 25.14 | 70064.0 |
| 2014-08-21 18:00:00 | AAPL | Stock | 25.14 | 25.15 | 25.14 | 25.145 | 194836.0 |
| 2014-08-21 18:30:00 | AAPL | Stock | 25.1425 | 25.145 | 25.13 | 25.1425 | 37104.0 |
| 2014-08-21 19:00:00 | AAPL | Stock | 25.1425 | 25.15 | 25.1425 | 25.15 | 52512.0 |
| 2014-08-21 19:30:00 | AAPL | Stock | 25.15 | 25.16 | 25.145 | 25.1525 | 39528.0 |
| 2014-08-21 08:00:00 | MSFT | Stock | 45.12 | 45.12 | 44.97 | 44.99 | 700.0 |
| 2014-08-21 08:30:00 | MSFT | Stock | 44.98 | 44.98 | 44.97 | 44.97 | 1000.0 |
| 2014-08-21 09:00:00 | MSFT | Stock | 45.0 | 45.0 | 44.86 | 44.86 | 5704.0 |
| 2014-08-21 09:30:00 | MSFT | Stock | 44.84 | 45.25 | 44.83 | 45.16 | 3787216.0 |
| 2014-08-21 10:00:00 | MSFT | Stock | 45.16 | 45.18 | 44.995 | 45.025 | 1717520.0 |
| 2014-08-21 10:30:00 | MSFT | Stock | 45.02 | 45.15 | 45.02 | 45.06 | 1400028.0 |
| 2014-08-21 11:00:00 | MSFT | Stock | 45.06 | 45.13 | 45.0 | 45.105 | 1058210.0 |
| 2014-08-21 11:30:00 | MSFT | Stock | 45.105 | 45.24 | 45.095 | 45.23 | 1270355.0 |
| 2014-08-21 12:00:00 | MSFT | Stock | 45.22 | 45.24 | 45.13 | 45.16 | 655782.0 |
| 2014-08-21 12:30:00 | MSFT | Stock | 45.16 | 45.17 | 45.1 | 45.13 | 1149872.0 |
| 2014-08-21 13:00:00 | MSFT | Stock | 45.13 | 45.18 | 45.12 | 45.16 | 488009.0 |
| 2014-08-21 13:30:00 | MSFT | Stock | 45.17 | 45.17 | 45.1 | 45.128 | 547534.0 |
| 2014-08-21 14:00:00 | MSFT | Stock | 45.13 | 45.17 | 45.1 | 45.11 | 766871.0 |
| 2014-08-21 14:30:00 | MSFT | Stock | 45.115 | 45.17 | 45.09 | 45.14 | 719557.0 |
| 2014-08-21 15:00:00 | MSFT | Stock | 45.145 | 45.16 | 45.12 | 45.15 | 1174950.0 |
| 2014-08-21 15:30:00 | MSFT | Stock | 45.15 | 45.23 | 45.12 | 45.23 | 2891285.0 |
| 2014-08-21 16:00:00 | MSFT | Stock | 45.22 | 45.226 | 45.095 | 45.095 | 3258530.0 |
| 2014-08-21 16:30:00 | MSFT | Stock | 45.18 | 45.19 | 45.18 | 45.19 | 1200.0 |
> showing 50 of 82,118 rows — these rows as CSV