PREVIEW / stock_30min / 2015-11-06
file: by_date/stock_30min/2015/2015-11-06.parquet size: 1.6 MB rows: 82,392 symbols: 3,419
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-06 04:00:00 | AAPL | Stock | 30.315 | 30.315 | 30.25 | 30.25 | 16040.0 |
| 2015-11-06 04:30:00 | AAPL | Stock | 30.275 | 30.275 | 30.275 | 30.275 | 800.0 |
| 2015-11-06 05:00:00 | AAPL | Stock | 30.2725 | 30.275 | 30.2725 | 30.275 | 1960.0 |
| 2015-11-06 05:30:00 | AAPL | Stock | 30.275 | 30.275 | 30.275 | 30.275 | 1276.0 |
| 2015-11-06 06:00:00 | AAPL | Stock | 30.275 | 30.3325 | 30.275 | 30.3325 | 27168.0 |
| 2015-11-06 06:30:00 | AAPL | Stock | 30.3175 | 30.3175 | 30.3125 | 30.3175 | 5952.0 |
| 2015-11-06 07:00:00 | AAPL | Stock | 30.3175 | 30.35 | 30.3125 | 30.3425 | 29400.0 |
| 2015-11-06 07:30:00 | AAPL | Stock | 30.3375 | 30.3375 | 30.2975 | 30.315 | 15800.0 |
| 2015-11-06 08:00:00 | AAPL | Stock | 30.2975 | 30.354 | 30.175 | 30.3475 | 158316.0 |
| 2015-11-06 08:30:00 | AAPL | Stock | 30.3475 | 30.4 | 30.19 | 30.3075 | 1045300.0 |
| 2015-11-06 09:00:00 | AAPL | Stock | 30.3075 | 30.345 | 30.2625 | 30.3 | 630472.0 |
| 2015-11-06 09:30:00 | AAPL | Stock | 30.2775 | 30.4525 | 30.22 | 30.2525 | 20761612.0 |
| 2015-11-06 10:00:00 | AAPL | Stock | 30.25 | 30.31 | 30.155 | 30.3025 | 14783260.0 |
| 2015-11-06 10:30:00 | AAPL | Stock | 30.3025 | 30.4375 | 30.2875 | 30.369 | 9964016.0 |
| 2015-11-06 11:00:00 | AAPL | Stock | 30.3725 | 30.435 | 30.2765 | 30.35 | 8496900.0 |
| 2015-11-06 11:30:00 | AAPL | Stock | 30.3475 | 30.385 | 30.3322 | 30.3475 | 6151380.0 |
| 2015-11-06 12:00:00 | AAPL | Stock | 30.3475 | 30.3925 | 30.2525 | 30.27 | 6646196.0 |
| 2015-11-06 12:30:00 | AAPL | Stock | 30.2725 | 30.2725 | 30.18 | 30.2425 | 8174348.0 |
| 2015-11-06 13:00:00 | AAPL | Stock | 30.2425 | 30.2575 | 30.2125 | 30.2425 | 5887808.0 |
| 2015-11-06 13:30:00 | AAPL | Stock | 30.2422 | 30.3 | 30.2325 | 30.265 | 4264120.0 |
| 2015-11-06 14:00:00 | AAPL | Stock | 30.2675 | 30.3325 | 30.22 | 30.2475 | 7156932.0 |
| 2015-11-06 14:30:00 | AAPL | Stock | 30.245 | 30.255 | 30.175 | 30.2248 | 7096900.0 |
| 2015-11-06 15:00:00 | AAPL | Stock | 30.2225 | 30.2475 | 30.1875 | 30.2125 | 5362180.0 |
| 2015-11-06 15:30:00 | AAPL | Stock | 30.2125 | 30.2775 | 30.2 | 30.265 | 11834596.0 |
| 2015-11-06 16:00:00 | AAPL | Stock | 30.265 | 30.3075 | 30.2475 | 30.2525 | 5548504.0 |
| 2015-11-06 16:30:00 | AAPL | Stock | 30.2525 | 30.26 | 30.2475 | 30.251 | 91804.0 |
| 2015-11-06 17:00:00 | AAPL | Stock | 30.255 | 30.2625 | 30.2475 | 30.2475 | 49904.0 |
| 2015-11-06 17:30:00 | AAPL | Stock | 30.245 | 30.2475 | 30.2325 | 30.235 | 19384.0 |
| 2015-11-06 18:00:00 | AAPL | Stock | 30.24 | 30.2475 | 30.2325 | 30.2475 | 28640.0 |
| 2015-11-06 18:30:00 | AAPL | Stock | 30.2475 | 30.2575 | 30.24 | 30.2575 | 12428.0 |
| 2015-11-06 19:00:00 | AAPL | Stock | 30.25 | 30.26 | 30.24 | 30.2575 | 21700.0 |
| 2015-11-06 19:30:00 | AAPL | Stock | 30.2575 | 30.265 | 30.2425 | 30.265 | 30112.0 |
| 2015-11-06 07:00:00 | MSFT | Stock | 54.34 | 54.34 | 54.34 | 54.34 | 100.0 |
| 2015-11-06 07:30:00 | MSFT | Stock | 54.3 | 54.3 | 54.3 | 54.3 | 200.0 |
| 2015-11-06 08:00:00 | MSFT | Stock | 54.35 | 54.35 | 54.35 | 54.35 | 500.0 |
| 2015-11-06 08:30:00 | MSFT | Stock | 54.19 | 54.42 | 54.05 | 54.06 | 33272.0 |
| 2015-11-06 09:00:00 | MSFT | Stock | 54.07 | 54.22 | 53.85 | 53.97 | 29465.0 |
| 2015-11-06 09:30:00 | MSFT | Stock | 53.97 | 54.33 | 53.964 | 54.27 | 3279764.0 |
| 2015-11-06 10:00:00 | MSFT | Stock | 54.26 | 54.38 | 54.03 | 54.37 | 2329860.0 |
| 2015-11-06 10:30:00 | MSFT | Stock | 54.37 | 54.86 | 54.354 | 54.48 | 2990721.0 |
| 2015-11-06 11:00:00 | MSFT | Stock | 54.48 | 54.535 | 54.26 | 54.33 | 1697879.0 |
| 2015-11-06 11:30:00 | MSFT | Stock | 54.33 | 54.59 | 54.32 | 54.5 | 1811100.0 |
| 2015-11-06 12:00:00 | MSFT | Stock | 54.5 | 54.51 | 54.35 | 54.491 | 1750578.0 |
| 2015-11-06 12:30:00 | MSFT | Stock | 54.49 | 54.75 | 54.41 | 54.75 | 2417772.0 |
| 2015-11-06 13:00:00 | MSFT | Stock | 54.75 | 54.825 | 54.595 | 54.765 | 1638216.0 |
| 2015-11-06 13:30:00 | MSFT | Stock | 54.76 | 54.94 | 54.73 | 54.87 | 1301069.0 |
| 2015-11-06 14:00:00 | MSFT | Stock | 54.87 | 54.98 | 54.7 | 54.75 | 1599130.0 |
| 2015-11-06 14:30:00 | MSFT | Stock | 54.76 | 54.8 | 54.564 | 54.74 | 1446449.0 |
| 2015-11-06 15:00:00 | MSFT | Stock | 54.744 | 54.8 | 54.521 | 54.62 | 1495094.0 |
| 2015-11-06 15:30:00 | MSFT | Stock | 54.625 | 54.93 | 54.62 | 54.91 | 3140207.0 |
> showing 50 of 82,392 rows — these rows as CSV