PREVIEW / stock_5min / 2015-04-28
file: by_date/stock_5min/2015/2015-04-28.parquet size: 5.5 MB rows: 362,219 symbols: 3,506
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-04-28 04:00:00 | AAPL | Stock | 33.6375 | 33.6375 | 33.5 | 33.5 | 53336.0 |
| 2015-04-28 04:05:00 | AAPL | Stock | 33.5 | 33.5375 | 33.5 | 33.525 | 14660.0 |
| 2015-04-28 04:10:00 | AAPL | Stock | 33.525 | 33.525 | 33.5 | 33.525 | 5328.0 |
| 2015-04-28 04:15:00 | AAPL | Stock | 33.5125 | 33.55 | 33.5125 | 33.5375 | 7720.0 |
| 2015-04-28 04:20:00 | AAPL | Stock | 33.5375 | 33.5375 | 33.5175 | 33.525 | 27884.0 |
| 2015-04-28 04:25:00 | AAPL | Stock | 33.5 | 33.525 | 33.5 | 33.525 | 8000.0 |
| 2015-04-28 04:35:00 | AAPL | Stock | 33.56 | 33.57 | 33.56 | 33.57 | 7944.0 |
| 2015-04-28 04:40:00 | AAPL | Stock | 33.5875 | 33.5975 | 33.5875 | 33.595 | 13312.0 |
| 2015-04-28 04:45:00 | AAPL | Stock | 33.5925 | 33.625 | 33.5875 | 33.5875 | 9596.0 |
| 2015-04-28 04:50:00 | AAPL | Stock | 33.6175 | 33.6725 | 33.6125 | 33.65 | 20664.0 |
| 2015-04-28 04:55:00 | AAPL | Stock | 33.66 | 33.675 | 33.66 | 33.665 | 9580.0 |
| 2015-04-28 05:00:00 | AAPL | Stock | 33.675 | 33.685 | 33.6625 | 33.675 | 23624.0 |
| 2015-04-28 05:05:00 | AAPL | Stock | 33.7 | 33.7 | 33.6775 | 33.7 | 6332.0 |
| 2015-04-28 05:10:00 | AAPL | Stock | 33.7 | 33.71 | 33.69 | 33.71 | 5600.0 |
| 2015-04-28 05:15:00 | AAPL | Stock | 33.7 | 33.7425 | 33.7 | 33.715 | 7568.0 |
| 2015-04-28 05:20:00 | AAPL | Stock | 33.715 | 33.735 | 33.715 | 33.735 | 4800.0 |
| 2015-04-28 05:25:00 | AAPL | Stock | 33.7125 | 33.7125 | 33.7125 | 33.7125 | 1600.0 |
| 2015-04-28 05:30:00 | AAPL | Stock | 33.74 | 33.74 | 33.7125 | 33.7125 | 10396.0 |
| 2015-04-28 05:35:00 | AAPL | Stock | 33.7125 | 33.7375 | 33.69 | 33.69 | 28284.0 |
| 2015-04-28 05:40:00 | AAPL | Stock | 33.69 | 33.7 | 33.6875 | 33.6875 | 17352.0 |
| 2015-04-28 05:45:00 | AAPL | Stock | 33.675 | 33.7 | 33.6675 | 33.695 | 16736.0 |
| 2015-04-28 05:50:00 | AAPL | Stock | 33.695 | 33.695 | 33.6675 | 33.6825 | 6632.0 |
| 2015-04-28 05:55:00 | AAPL | Stock | 33.685 | 33.7125 | 33.685 | 33.7125 | 11460.0 |
| 2015-04-28 06:00:00 | AAPL | Stock | 33.725 | 33.755 | 33.685 | 33.75 | 47952.0 |
| 2015-04-28 06:05:00 | AAPL | Stock | 33.75 | 33.8475 | 33.75 | 33.82 | 49240.0 |
| 2015-04-28 06:10:00 | AAPL | Stock | 33.8 | 33.825 | 33.775 | 33.8 | 17840.0 |
| 2015-04-28 06:15:00 | AAPL | Stock | 33.82 | 33.8475 | 33.78 | 33.8475 | 39052.0 |
| 2015-04-28 06:20:00 | AAPL | Stock | 33.8475 | 33.8475 | 33.75 | 33.78 | 45508.0 |
| 2015-04-28 06:25:00 | AAPL | Stock | 33.835 | 33.835 | 33.775 | 33.775 | 4212.0 |
| 2015-04-28 06:30:00 | AAPL | Stock | 33.8 | 33.8 | 33.7125 | 33.7625 | 30416.0 |
| 2015-04-28 06:35:00 | AAPL | Stock | 33.7625 | 33.7625 | 33.75 | 33.75 | 2940.0 |
| 2015-04-28 06:40:00 | AAPL | Stock | 33.77 | 33.82 | 33.77 | 33.8125 | 17580.0 |
| 2015-04-28 06:45:00 | AAPL | Stock | 33.7775 | 33.82 | 33.7675 | 33.82 | 44516.0 |
| 2015-04-28 06:50:00 | AAPL | Stock | 33.8025 | 33.9375 | 33.8025 | 33.815 | 100676.0 |
| 2015-04-28 06:55:00 | AAPL | Stock | 33.8175 | 33.905 | 33.8175 | 33.8875 | 51160.0 |
| 2015-04-28 07:00:00 | AAPL | Stock | 33.8875 | 33.9275 | 33.84 | 33.905 | 227680.0 |
| 2015-04-28 07:05:00 | AAPL | Stock | 33.9 | 34.0 | 33.9 | 33.9925 | 381032.0 |
| 2015-04-28 07:10:00 | AAPL | Stock | 33.99 | 33.9975 | 33.9 | 33.9 | 158212.0 |
| 2015-04-28 07:15:00 | AAPL | Stock | 33.915 | 33.9775 | 33.915 | 33.965 | 138576.0 |
| 2015-04-28 07:20:00 | AAPL | Stock | 33.9625 | 34.0325 | 33.955 | 34.0025 | 555760.0 |
| 2015-04-28 07:25:00 | AAPL | Stock | 34.0 | 34.05 | 33.9625 | 34.03 | 396464.0 |
| 2015-04-28 07:30:00 | AAPL | Stock | 34.035 | 34.05 | 33.9675 | 33.9875 | 230376.0 |
| 2015-04-28 07:35:00 | AAPL | Stock | 33.9975 | 34.015 | 33.9875 | 34.0075 | 220988.0 |
| 2015-04-28 07:40:00 | AAPL | Stock | 34.0075 | 34.0125 | 33.95 | 33.995 | 245520.0 |
| 2015-04-28 07:45:00 | AAPL | Stock | 33.9975 | 33.9975 | 33.925 | 33.9625 | 247880.0 |
| 2015-04-28 07:50:00 | AAPL | Stock | 33.965 | 33.965 | 33.925 | 33.9375 | 133532.0 |
| 2015-04-28 07:55:00 | AAPL | Stock | 33.9425 | 33.945 | 33.9 | 33.9275 | 197680.0 |
| 2015-04-28 08:00:00 | AAPL | Stock | 33.9125 | 34.045 | 33.5825 | 33.8625 | 1790180.0 |
| 2015-04-28 08:05:00 | AAPL | Stock | 33.86 | 33.8975 | 33.8575 | 33.8675 | 414044.0 |
| 2015-04-28 08:10:00 | AAPL | Stock | 33.865 | 33.88 | 33.7775 | 33.8125 | 542708.0 |
> showing 50 of 362,219 rows — these rows as CSV