PREVIEW / stock_30min / 2015-12-04
file: by_date/stock_30min/2015/2015-12-04.parquet size: 1.6 MB rows: 82,049 symbols: 3,402
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-12-04 04:00:00 | AAPL | Stock | 28.885 | 28.9875 | 28.885 | 28.9375 | 15600.0 |
| 2015-12-04 04:30:00 | AAPL | Stock | 28.9575 | 28.9575 | 28.9225 | 28.9225 | 7560.0 |
| 2015-12-04 05:00:00 | AAPL | Stock | 28.92 | 28.98 | 28.92 | 28.98 | 12868.0 |
| 2015-12-04 05:30:00 | AAPL | Stock | 28.9425 | 28.9425 | 28.9425 | 28.9425 | 400.0 |
| 2015-12-04 06:00:00 | AAPL | Stock | 28.9375 | 28.9375 | 28.92 | 28.92 | 3200.0 |
| 2015-12-04 06:30:00 | AAPL | Stock | 28.93 | 28.93 | 28.905 | 28.93 | 2104.0 |
| 2015-12-04 07:00:00 | AAPL | Stock | 28.935 | 28.935 | 28.895 | 28.9225 | 15952.0 |
| 2015-12-04 07:30:00 | AAPL | Stock | 28.9225 | 28.9225 | 28.8925 | 28.9 | 13160.0 |
| 2015-12-04 08:00:00 | AAPL | Stock | 28.89 | 28.925 | 28.805 | 28.8475 | 128988.0 |
| 2015-12-04 08:30:00 | AAPL | Stock | 28.8375 | 28.9375 | 28.8375 | 28.8625 | 318096.0 |
| 2015-12-04 09:00:00 | AAPL | Stock | 28.8625 | 28.8625 | 28.7525 | 28.8125 | 452148.0 |
| 2015-12-04 09:30:00 | AAPL | Stock | 28.8225 | 29.3675 | 28.7775 | 29.355 | 32473164.0 |
| 2015-12-04 10:00:00 | AAPL | Stock | 29.3575 | 29.55 | 29.315 | 29.525 | 31485596.0 |
| 2015-12-04 10:30:00 | AAPL | Stock | 29.5275 | 29.62 | 29.465 | 29.6162 | 20043936.0 |
| 2015-12-04 11:00:00 | AAPL | Stock | 29.6162 | 29.625 | 29.5225 | 29.525 | 12700484.0 |
| 2015-12-04 11:30:00 | AAPL | Stock | 29.5262 | 29.59 | 29.4675 | 29.5538 | 11215804.0 |
| 2015-12-04 12:00:00 | AAPL | Stock | 29.5525 | 29.6075 | 29.5 | 29.5852 | 8349116.0 |
| 2015-12-04 12:30:00 | AAPL | Stock | 29.5865 | 29.7062 | 29.58 | 29.6495 | 11151632.0 |
| 2015-12-04 13:00:00 | AAPL | Stock | 29.655 | 29.7175 | 29.6375 | 29.6575 | 9702436.0 |
| 2015-12-04 13:30:00 | AAPL | Stock | 29.66 | 29.7355 | 29.6375 | 29.7338 | 7845412.0 |
| 2015-12-04 14:00:00 | AAPL | Stock | 29.7338 | 29.775 | 29.705 | 29.761 | 10822272.0 |
| 2015-12-04 14:30:00 | AAPL | Stock | 29.7625 | 29.7875 | 29.735 | 29.7775 | 8700884.0 |
| 2015-12-04 15:00:00 | AAPL | Stock | 29.78 | 29.8125 | 29.7312 | 29.75 | 12459800.0 |
| 2015-12-04 15:30:00 | AAPL | Stock | 29.75 | 29.7725 | 29.7075 | 29.75 | 18733664.0 |
| 2015-12-04 16:00:00 | AAPL | Stock | 29.7575 | 29.7725 | 29.472 | 29.755 | 16009920.0 |
| 2015-12-04 16:30:00 | AAPL | Stock | 29.75 | 29.7575 | 29.75 | 29.75 | 376152.0 |
| 2015-12-04 17:00:00 | AAPL | Stock | 29.745 | 29.755 | 29.7425 | 29.7525 | 48520.0 |
| 2015-12-04 17:30:00 | AAPL | Stock | 29.75 | 29.7725 | 29.75 | 29.7725 | 70720.0 |
| 2015-12-04 18:00:00 | AAPL | Stock | 29.7725 | 29.775 | 29.755 | 29.7575 | 19640.0 |
| 2015-12-04 18:30:00 | AAPL | Stock | 29.7575 | 29.7625 | 29.7575 | 29.7625 | 17760.0 |
| 2015-12-04 19:00:00 | AAPL | Stock | 29.7625 | 29.765 | 29.7625 | 29.765 | 9768.0 |
| 2015-12-04 19:30:00 | AAPL | Stock | 29.7675 | 29.7675 | 29.76 | 29.7625 | 9976.0 |
| 2015-12-04 04:00:00 | MSFT | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 900.0 |
| 2015-12-04 05:00:00 | MSFT | Stock | 54.51 | 54.51 | 54.46 | 54.46 | 1150.0 |
| 2015-12-04 05:30:00 | MSFT | Stock | 54.43 | 54.43 | 54.43 | 54.43 | 300.0 |
| 2015-12-04 06:00:00 | MSFT | Stock | 54.45 | 54.45 | 54.45 | 54.45 | 200.0 |
| 2015-12-04 06:30:00 | MSFT | Stock | 54.4 | 54.4 | 54.4 | 54.4 | 700.0 |
| 2015-12-04 07:00:00 | MSFT | Stock | 54.48 | 54.48 | 54.4 | 54.4 | 1308.0 |
| 2015-12-04 08:00:00 | MSFT | Stock | 54.33 | 54.37 | 54.33 | 54.35 | 2200.0 |
| 2015-12-04 08:30:00 | MSFT | Stock | 54.35 | 54.48 | 54.3 | 54.4 | 13268.0 |
| 2015-12-04 09:00:00 | MSFT | Stock | 54.4 | 54.4 | 54.11 | 54.11 | 86300.0 |
| 2015-12-04 09:30:00 | MSFT | Stock | 54.16 | 55.02 | 54.1 | 54.92 | 4522518.0 |
| 2015-12-04 10:00:00 | MSFT | Stock | 54.93 | 55.19 | 54.725 | 55.03 | 2648629.0 |
| 2015-12-04 10:30:00 | MSFT | Stock | 55.04 | 55.27 | 54.944 | 55.25 | 2306383.0 |
| 2015-12-04 11:00:00 | MSFT | Stock | 55.245 | 55.36 | 55.1 | 55.19 | 2055646.0 |
| 2015-12-04 11:30:00 | MSFT | Stock | 55.192 | 55.33 | 55.14 | 55.3 | 1421203.0 |
| 2015-12-04 12:00:00 | MSFT | Stock | 55.3 | 55.48 | 55.24 | 55.44 | 1477575.0 |
| 2015-12-04 12:30:00 | MSFT | Stock | 55.446 | 55.63 | 55.43 | 55.56 | 2389142.0 |
| 2015-12-04 13:00:00 | MSFT | Stock | 55.56 | 55.7 | 55.5 | 55.585 | 2115852.0 |
| 2015-12-04 13:30:00 | MSFT | Stock | 55.58 | 55.87 | 55.56 | 55.82 | 2084297.0 |
> showing 50 of 82,049 rows — these rows as CSV