PREVIEW / stock_30min / 2014-10-22
file: by_date/stock_30min/2014/2014-10-22.parquet size: 1.6 MB rows: 82,828 symbols: 3,544
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-22 04:00:00 | AAPL | Stock | 25.62 | 25.6225 | 25.5 | 25.575 | 26600.0 |
| 2014-10-22 04:30:00 | AAPL | Stock | 25.575 | 25.595 | 25.5625 | 25.595 | 10228.0 |
| 2014-10-22 05:00:00 | AAPL | Stock | 25.5875 | 25.5875 | 25.585 | 25.585 | 11960.0 |
| 2014-10-22 05:30:00 | AAPL | Stock | 25.5825 | 25.5825 | 25.5725 | 25.575 | 7784.0 |
| 2014-10-22 06:00:00 | AAPL | Stock | 25.565 | 25.575 | 25.545 | 25.5625 | 18184.0 |
| 2014-10-22 06:30:00 | AAPL | Stock | 25.55 | 25.5625 | 25.5425 | 25.55 | 25592.0 |
| 2014-10-22 07:00:00 | AAPL | Stock | 25.55 | 25.595 | 25.545 | 25.595 | 72024.0 |
| 2014-10-22 07:30:00 | AAPL | Stock | 25.595 | 25.615 | 25.57 | 25.6 | 85072.0 |
| 2014-10-22 08:00:00 | AAPL | Stock | 25.6 | 25.6875 | 25.5375 | 25.685 | 620920.0 |
| 2014-10-22 08:30:00 | AAPL | Stock | 25.675 | 25.7125 | 25.6125 | 25.7125 | 638164.0 |
| 2014-10-22 09:00:00 | AAPL | Stock | 25.695 | 25.735 | 25.6575 | 25.7225 | 583792.0 |
| 2014-10-22 09:30:00 | AAPL | Stock | 25.7125 | 25.86 | 25.65 | 25.8475 | 45783528.0 |
| 2014-10-22 10:00:00 | AAPL | Stock | 25.8475 | 25.8575 | 25.7075 | 25.7975 | 22089020.0 |
| 2014-10-22 10:30:00 | AAPL | Stock | 25.7928 | 25.8475 | 25.77 | 25.84 | 13360332.0 |
| 2014-10-22 11:00:00 | AAPL | Stock | 25.8412 | 25.9375 | 25.8075 | 25.9237 | 23465824.0 |
| 2014-10-22 11:30:00 | AAPL | Stock | 25.9225 | 26.0275 | 25.885 | 25.9375 | 31547092.0 |
| 2014-10-22 12:00:00 | AAPL | Stock | 25.9375 | 25.9875 | 25.8375 | 25.925 | 14877548.0 |
| 2014-10-22 12:30:00 | AAPL | Stock | 25.9275 | 25.9292 | 25.725 | 25.839 | 19638244.0 |
| 2014-10-22 13:00:00 | AAPL | Stock | 25.8385 | 25.8725 | 25.7825 | 25.8225 | 10126652.0 |
| 2014-10-22 13:30:00 | AAPL | Stock | 25.8225 | 25.9125 | 25.795 | 25.87 | 11521212.0 |
| 2014-10-22 14:00:00 | AAPL | Stock | 25.87 | 25.9 | 25.8325 | 25.845 | 9348880.0 |
| 2014-10-22 14:30:00 | AAPL | Stock | 25.8462 | 25.8975 | 25.7975 | 25.891 | 9992788.0 |
| 2014-10-22 15:00:00 | AAPL | Stock | 25.8925 | 25.9 | 25.8525 | 25.8675 | 9329612.0 |
| 2014-10-22 15:30:00 | AAPL | Stock | 25.8675 | 25.8688 | 25.7375 | 25.75 | 24556692.0 |
| 2014-10-22 16:00:00 | AAPL | Stock | 25.7475 | 25.8402 | 25.6175 | 25.7475 | 5932152.0 |
| 2014-10-22 16:30:00 | AAPL | Stock | 25.7475 | 25.8448 | 23.414 | 25.7725 | 365316.0 |
| 2014-10-22 17:00:00 | AAPL | Stock | 25.765 | 25.77 | 25.75 | 25.75 | 80980.0 |
| 2014-10-22 17:30:00 | AAPL | Stock | 25.75 | 25.765 | 25.75 | 25.7525 | 60224.0 |
| 2014-10-22 18:00:00 | AAPL | Stock | 25.75 | 25.7725 | 25.7475 | 25.77 | 142120.0 |
| 2014-10-22 18:30:00 | AAPL | Stock | 25.77 | 25.7775 | 25.7575 | 25.7775 | 118496.0 |
| 2014-10-22 19:00:00 | AAPL | Stock | 25.7775 | 25.7925 | 25.7675 | 25.7875 | 71948.0 |
| 2014-10-22 19:30:00 | AAPL | Stock | 25.7875 | 25.7975 | 25.7775 | 25.7825 | 67976.0 |
| 2014-10-22 07:00:00 | MSFT | Stock | 44.91 | 45.03 | 44.91 | 44.92 | 1400.0 |
| 2014-10-22 07:30:00 | MSFT | Stock | 44.98 | 45.56 | 44.9 | 44.91 | 8550.0 |
| 2014-10-22 08:00:00 | MSFT | Stock | 44.98 | 45.0 | 44.98 | 45.0 | 200.0 |
| 2014-10-22 08:30:00 | MSFT | Stock | 44.93 | 45.04 | 44.93 | 45.0 | 3452.0 |
| 2014-10-22 09:00:00 | MSFT | Stock | 45.01 | 45.08 | 44.99 | 44.99 | 76629.0 |
| 2014-10-22 09:30:00 | MSFT | Stock | 44.97 | 45.07 | 44.83 | 44.875 | 3930997.0 |
| 2014-10-22 10:00:00 | MSFT | Stock | 44.88 | 44.89 | 44.66 | 44.79 | 2945127.0 |
| 2014-10-22 10:30:00 | MSFT | Stock | 44.79 | 44.81 | 44.63 | 44.675 | 1788387.0 |
| 2014-10-22 11:00:00 | MSFT | Stock | 44.67 | 44.72 | 44.58 | 44.6 | 2445593.0 |
| 2014-10-22 11:30:00 | MSFT | Stock | 44.59 | 44.65 | 44.52 | 44.52 | 1398740.0 |
| 2014-10-22 12:00:00 | MSFT | Stock | 44.52 | 44.53 | 44.34 | 44.445 | 1812873.0 |
| 2014-10-22 12:30:00 | MSFT | Stock | 44.45 | 44.49 | 44.38 | 44.47 | 1542844.0 |
| 2014-10-22 13:00:00 | MSFT | Stock | 44.47 | 44.6 | 44.47 | 44.5 | 1483554.0 |
| 2014-10-22 13:30:00 | MSFT | Stock | 44.5 | 44.55 | 44.46 | 44.475 | 1308345.0 |
| 2014-10-22 14:00:00 | MSFT | Stock | 44.47 | 44.5 | 44.42 | 44.47 | 1424056.0 |
| 2014-10-22 14:30:00 | MSFT | Stock | 44.48 | 44.5 | 44.38 | 44.44 | 1843901.0 |
| 2014-10-22 15:00:00 | MSFT | Stock | 44.44 | 44.445 | 44.28 | 44.295 | 2736254.0 |
| 2014-10-22 15:30:00 | MSFT | Stock | 44.295 | 44.44 | 44.225 | 44.39 | 5052466.0 |
> showing 50 of 82,828 rows — these rows as CSV