PREVIEW / stock_30min / 2015-11-25
file: by_date/stock_30min/2015/2015-11-25.parquet size: 1.6 MB rows: 80,953 symbols: 3,411
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-25 04:00:00 | AAPL | Stock | 29.75 | 29.75 | 29.75 | 29.75 | 17200.0 |
| 2015-11-25 04:30:00 | AAPL | Stock | 29.75 | 29.75 | 29.7475 | 29.7475 | 18928.0 |
| 2015-11-25 05:00:00 | AAPL | Stock | 29.7475 | 29.7475 | 29.7475 | 29.7475 | 2400.0 |
| 2015-11-25 05:30:00 | AAPL | Stock | 29.745 | 29.745 | 29.745 | 29.745 | 1200.0 |
| 2015-11-25 06:00:00 | AAPL | Stock | 29.7475 | 29.7475 | 29.7175 | 29.7175 | 7600.0 |
| 2015-11-25 06:30:00 | AAPL | Stock | 29.72 | 29.7225 | 29.6725 | 29.72 | 9700.0 |
| 2015-11-25 07:00:00 | AAPL | Stock | 29.72 | 29.735 | 29.705 | 29.7175 | 51992.0 |
| 2015-11-25 07:30:00 | AAPL | Stock | 29.715 | 29.76 | 29.715 | 29.75 | 12560.0 |
| 2015-11-25 08:00:00 | AAPL | Stock | 29.75 | 29.765 | 29.705 | 29.76 | 182152.0 |
| 2015-11-25 08:30:00 | AAPL | Stock | 29.7575 | 29.78 | 29.735 | 29.7625 | 147248.0 |
| 2015-11-25 09:00:00 | AAPL | Stock | 29.7725 | 29.815 | 29.75 | 29.7925 | 207572.0 |
| 2015-11-25 09:30:00 | AAPL | Stock | 29.79 | 29.8075 | 29.555 | 29.642 | 15540864.0 |
| 2015-11-25 10:00:00 | AAPL | Stock | 29.6375 | 29.6575 | 29.5375 | 29.56 | 8992352.0 |
| 2015-11-25 10:30:00 | AAPL | Stock | 29.5588 | 29.635 | 29.5425 | 29.56 | 6938904.0 |
| 2015-11-25 11:00:00 | AAPL | Stock | 29.56 | 29.5925 | 29.5125 | 29.5348 | 5751232.0 |
| 2015-11-25 11:30:00 | AAPL | Stock | 29.535 | 29.5825 | 29.5225 | 29.565 | 3409672.0 |
| 2015-11-25 12:00:00 | AAPL | Stock | 29.565 | 29.59 | 29.515 | 29.58 | 4074808.0 |
| 2015-11-25 12:30:00 | AAPL | Stock | 29.58 | 29.61 | 29.565 | 29.5675 | 2614568.0 |
| 2015-11-25 13:00:00 | AAPL | Stock | 29.57 | 29.5875 | 29.5375 | 29.5512 | 2472480.0 |
| 2015-11-25 13:30:00 | AAPL | Stock | 29.55 | 29.5975 | 29.55 | 29.5812 | 3395808.0 |
| 2015-11-25 14:00:00 | AAPL | Stock | 29.5812 | 29.6125 | 29.5675 | 29.6025 | 2703972.0 |
| 2015-11-25 14:30:00 | AAPL | Stock | 29.6025 | 29.6225 | 29.568 | 29.595 | 2430368.0 |
| 2015-11-25 15:00:00 | AAPL | Stock | 29.595 | 29.605 | 29.5525 | 29.565 | 3139572.0 |
| 2015-11-25 15:30:00 | AAPL | Stock | 29.5675 | 29.5675 | 29.48 | 29.505 | 12130816.0 |
| 2015-11-25 16:00:00 | AAPL | Stock | 29.5075 | 29.5225 | 29.5075 | 29.5075 | 5570088.0 |
| 2015-11-25 16:30:00 | AAPL | Stock | 29.5075 | 29.5175 | 29.5075 | 29.5125 | 43988.0 |
| 2015-11-25 17:00:00 | AAPL | Stock | 29.505 | 29.51 | 29.5025 | 29.5075 | 5600.0 |
| 2015-11-25 17:30:00 | AAPL | Stock | 29.51 | 29.51 | 29.505 | 29.505 | 23376.0 |
| 2015-11-25 18:00:00 | AAPL | Stock | 29.51 | 29.51 | 29.5025 | 29.5075 | 12656.0 |
| 2015-11-25 18:30:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.505 | 29.5075 | 37080.0 |
| 2015-11-25 19:00:00 | AAPL | Stock | 29.5075 | 29.5125 | 29.505 | 29.505 | 12200.0 |
| 2015-11-25 19:30:00 | AAPL | Stock | 29.505 | 29.515 | 29.5025 | 29.515 | 34248.0 |
| 2015-11-25 04:00:00 | MSFT | Stock | 54.21 | 54.21 | 54.21 | 54.21 | 900.0 |
| 2015-11-25 05:00:00 | MSFT | Stock | 54.25 | 54.35 | 54.25 | 54.35 | 400.0 |
| 2015-11-25 05:30:00 | MSFT | Stock | 54.31 | 54.31 | 54.31 | 54.31 | 300.0 |
| 2015-11-25 06:00:00 | MSFT | Stock | 54.35 | 54.35 | 54.35 | 54.35 | 100.0 |
| 2015-11-25 06:30:00 | MSFT | Stock | 54.25 | 54.25 | 54.21 | 54.25 | 3388.0 |
| 2015-11-25 07:00:00 | MSFT | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 100.0 |
| 2015-11-25 07:30:00 | MSFT | Stock | 54.25 | 54.25 | 54.24 | 54.25 | 2100.0 |
| 2015-11-25 08:00:00 | MSFT | Stock | 54.22 | 54.25 | 54.21 | 54.25 | 1500.0 |
| 2015-11-25 08:30:00 | MSFT | Stock | 54.28 | 54.28 | 54.25 | 54.25 | 5097.0 |
| 2015-11-25 09:00:00 | MSFT | Stock | 54.21 | 54.29 | 54.05 | 54.08 | 15672.0 |
| 2015-11-25 09:30:00 | MSFT | Stock | 54.16 | 54.23 | 53.94 | 53.98 | 3539711.0 |
| 2015-11-25 10:00:00 | MSFT | Stock | 53.98 | 54.01 | 53.83 | 53.93 | 1400076.0 |
| 2015-11-25 10:30:00 | MSFT | Stock | 53.92 | 54.03 | 53.92 | 54.0 | 1208023.0 |
| 2015-11-25 11:00:00 | MSFT | Stock | 54.005 | 54.01 | 53.92 | 53.956 | 986072.0 |
| 2015-11-25 11:30:00 | MSFT | Stock | 53.96 | 54.08 | 53.95 | 54.05 | 1009321.0 |
| 2015-11-25 12:00:00 | MSFT | Stock | 54.05 | 54.15 | 54.02 | 54.08 | 1160459.0 |
| 2015-11-25 12:30:00 | MSFT | Stock | 54.08 | 54.15 | 54.05 | 54.05 | 958117.0 |
| 2015-11-25 13:00:00 | MSFT | Stock | 54.057 | 54.09 | 53.97 | 54.01 | 709334.0 |
> showing 50 of 80,953 rows — these rows as CSV