PREVIEW / stock_5min / 2014-10-15
file: by_date/stock_5min/2014/2014-10-15.parquet size: 5.9 MB rows: 384,713 symbols: 3,570
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-10-15 04:05:00 | AAPL | Stock | 24.7525 | 24.7525 | 24.7525 | 24.7525 | 2800.0 |
| 2014-10-15 04:10:00 | AAPL | Stock | 24.705 | 24.705 | 24.705 | 24.705 | 400.0 |
| 2014-10-15 04:15:00 | AAPL | Stock | 24.7025 | 24.7025 | 24.675 | 24.675 | 3200.0 |
| 2014-10-15 04:30:00 | AAPL | Stock | 24.73 | 24.73 | 24.73 | 24.73 | 1200.0 |
| 2014-10-15 04:40:00 | AAPL | Stock | 24.715 | 24.715 | 24.715 | 24.715 | 1160.0 |
| 2014-10-15 04:50:00 | AAPL | Stock | 24.6925 | 24.7025 | 24.6925 | 24.7025 | 3200.0 |
| 2014-10-15 05:00:00 | AAPL | Stock | 24.7 | 24.7 | 24.69 | 24.69 | 3600.0 |
| 2014-10-15 05:10:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6275 | 24.6275 | 1600.0 |
| 2014-10-15 05:35:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 1200.0 |
| 2014-10-15 05:40:00 | AAPL | Stock | 24.7025 | 24.7025 | 24.675 | 24.675 | 2200.0 |
| 2014-10-15 05:45:00 | AAPL | Stock | 24.7 | 24.705 | 24.7 | 24.705 | 4000.0 |
| 2014-10-15 05:50:00 | AAPL | Stock | 24.735 | 24.78 | 24.735 | 24.775 | 4644.0 |
| 2014-10-15 05:55:00 | AAPL | Stock | 24.775 | 24.775 | 24.775 | 24.775 | 400.0 |
| 2014-10-15 06:05:00 | AAPL | Stock | 24.7825 | 24.7825 | 24.775 | 24.775 | 16228.0 |
| 2014-10-15 06:20:00 | AAPL | Stock | 24.7725 | 24.775 | 24.7725 | 24.775 | 7960.0 |
| 2014-10-15 06:45:00 | AAPL | Stock | 24.7875 | 24.7925 | 24.7875 | 24.7925 | 1200.0 |
| 2014-10-15 07:00:00 | AAPL | Stock | 24.7625 | 24.8 | 24.7575 | 24.8 | 16376.0 |
| 2014-10-15 07:05:00 | AAPL | Stock | 24.8075 | 24.82 | 24.7625 | 24.7625 | 29516.0 |
| 2014-10-15 07:10:00 | AAPL | Stock | 24.7625 | 24.765 | 24.7625 | 24.765 | 5820.0 |
| 2014-10-15 07:15:00 | AAPL | Stock | 24.7675 | 24.7675 | 24.65 | 24.65 | 89300.0 |
| 2014-10-15 07:20:00 | AAPL | Stock | 24.6475 | 24.69 | 24.6475 | 24.69 | 28400.0 |
| 2014-10-15 07:25:00 | AAPL | Stock | 24.7 | 24.7125 | 24.675 | 24.6775 | 25600.0 |
| 2014-10-15 07:30:00 | AAPL | Stock | 24.6775 | 24.715 | 24.675 | 24.69 | 79192.0 |
| 2014-10-15 07:35:00 | AAPL | Stock | 24.69 | 24.7 | 24.65 | 24.685 | 180920.0 |
| 2014-10-15 07:40:00 | AAPL | Stock | 24.6875 | 24.7075 | 24.6775 | 24.7 | 56400.0 |
| 2014-10-15 07:45:00 | AAPL | Stock | 24.7075 | 24.735 | 24.665 | 24.735 | 56800.0 |
| 2014-10-15 07:50:00 | AAPL | Stock | 24.7175 | 24.7475 | 24.695 | 24.71 | 115260.0 |
| 2014-10-15 07:55:00 | AAPL | Stock | 24.7025 | 24.7575 | 24.7025 | 24.7375 | 90352.0 |
| 2014-10-15 08:00:00 | AAPL | Stock | 24.735 | 24.8175 | 24.66 | 24.7825 | 318744.0 |
| 2014-10-15 08:05:00 | AAPL | Stock | 24.785 | 24.805 | 24.7575 | 24.7575 | 120540.0 |
| 2014-10-15 08:10:00 | AAPL | Stock | 24.775 | 24.81 | 24.755 | 24.7875 | 226152.0 |
| 2014-10-15 08:15:00 | AAPL | Stock | 24.8 | 24.8 | 24.75 | 24.7675 | 105052.0 |
| 2014-10-15 08:20:00 | AAPL | Stock | 24.7725 | 24.835 | 24.7725 | 24.825 | 114848.0 |
| 2014-10-15 08:25:00 | AAPL | Stock | 24.8125 | 24.875 | 24.81 | 24.85 | 184644.0 |
| 2014-10-15 08:30:00 | AAPL | Stock | 24.8275 | 24.8275 | 24.75 | 24.76 | 158904.0 |
| 2014-10-15 08:35:00 | AAPL | Stock | 24.755 | 24.77 | 24.7275 | 24.75 | 210704.0 |
| 2014-10-15 08:40:00 | AAPL | Stock | 24.76 | 24.7625 | 24.715 | 24.725 | 197544.0 |
| 2014-10-15 08:45:00 | AAPL | Stock | 24.725 | 24.725 | 24.6625 | 24.665 | 349848.0 |
| 2014-10-15 08:50:00 | AAPL | Stock | 24.665 | 24.675 | 24.625 | 24.665 | 201908.0 |
| 2014-10-15 08:55:00 | AAPL | Stock | 24.655 | 24.665 | 24.625 | 24.64 | 230520.0 |
| 2014-10-15 09:00:00 | AAPL | Stock | 24.6425 | 24.6875 | 24.6 | 24.625 | 227732.0 |
| 2014-10-15 09:05:00 | AAPL | Stock | 24.625 | 24.6575 | 24.5875 | 24.5875 | 155672.0 |
| 2014-10-15 09:10:00 | AAPL | Stock | 24.5875 | 24.6 | 24.575 | 24.58 | 161168.0 |
| 2014-10-15 09:15:00 | AAPL | Stock | 24.5825 | 24.6875 | 24.5625 | 24.5625 | 225244.0 |
| 2014-10-15 09:20:00 | AAPL | Stock | 24.575 | 24.595 | 24.525 | 24.5375 | 292680.0 |
| 2014-10-15 09:25:00 | AAPL | Stock | 24.5375 | 24.555 | 24.45 | 24.5025 | 526780.0 |
| 2014-10-15 09:30:00 | AAPL | Stock | 24.5025 | 24.675 | 24.45 | 24.61 | 11971784.0 |
| 2014-10-15 09:35:00 | AAPL | Stock | 24.6125 | 24.7325 | 24.575 | 24.7 | 7270184.0 |
| 2014-10-15 09:40:00 | AAPL | Stock | 24.7 | 24.705 | 24.5175 | 24.6065 | 6067660.0 |
| 2014-10-15 09:45:00 | AAPL | Stock | 24.6025 | 24.6475 | 24.52 | 24.6235 | 8255756.0 |
> showing 50 of 384,713 rows — these rows as CSV