PREVIEW / stock_5min / 2014-07-11
file: by_date/stock_5min/2014/2014-07-11.parquet size: 5.3 MB rows: 358,550 symbols: 3,537
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-07-11 04:00:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 1200.0 |
| 2014-07-11 04:20:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.795 | 23.795 | 2400.0 |
| 2014-07-11 04:25:00 | AAPL | Stock | 23.7925 | 23.7925 | 23.7925 | 23.7925 | 400.0 |
| 2014-07-11 04:30:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 768.0 |
| 2014-07-11 04:50:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8075 | 23.8075 | 1680.0 |
| 2014-07-11 05:00:00 | AAPL | Stock | 23.8025 | 23.82 | 23.8025 | 23.82 | 1568.0 |
| 2014-07-11 05:20:00 | AAPL | Stock | 23.81 | 23.81 | 23.81 | 23.81 | 6000.0 |
| 2014-07-11 05:45:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8 | 23.8 | 4000.0 |
| 2014-07-11 06:00:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 2000.0 |
| 2014-07-11 06:05:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 2400.0 |
| 2014-07-11 06:25:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8075 | 23.8075 | 3940.0 |
| 2014-07-11 06:30:00 | AAPL | Stock | 23.82 | 23.82 | 23.8 | 23.8 | 2460.0 |
| 2014-07-11 06:35:00 | AAPL | Stock | 23.82 | 23.82 | 23.82 | 23.82 | 800.0 |
| 2014-07-11 06:40:00 | AAPL | Stock | 23.8275 | 23.8275 | 23.8275 | 23.8275 | 400.0 |
| 2014-07-11 06:45:00 | AAPL | Stock | 23.8275 | 23.8375 | 23.8275 | 23.8375 | 4500.0 |
| 2014-07-11 06:50:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.825 | 23.825 | 6800.0 |
| 2014-07-11 06:55:00 | AAPL | Stock | 23.8325 | 23.8325 | 23.8325 | 23.8325 | 1600.0 |
| 2014-07-11 07:00:00 | AAPL | Stock | 23.81 | 23.825 | 23.81 | 23.825 | 12800.0 |
| 2014-07-11 07:05:00 | AAPL | Stock | 23.83 | 23.83 | 23.83 | 23.83 | 7120.0 |
| 2014-07-11 07:10:00 | AAPL | Stock | 23.835 | 23.835 | 23.83 | 23.83 | 4488.0 |
| 2014-07-11 07:20:00 | AAPL | Stock | 23.83 | 23.83 | 23.83 | 23.83 | 4000.0 |
| 2014-07-11 07:25:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 3824.0 |
| 2014-07-11 07:30:00 | AAPL | Stock | 23.8225 | 23.8225 | 23.82 | 23.82 | 1228.0 |
| 2014-07-11 07:35:00 | AAPL | Stock | 23.82 | 23.82 | 23.82 | 23.82 | 428.0 |
| 2014-07-11 07:40:00 | AAPL | Stock | 23.8125 | 23.8175 | 23.8125 | 23.8175 | 4400.0 |
| 2014-07-11 07:45:00 | AAPL | Stock | 23.82 | 23.82 | 23.82 | 23.82 | 1600.0 |
| 2014-07-11 07:50:00 | AAPL | Stock | 23.82 | 23.82 | 23.81 | 23.8125 | 6000.0 |
| 2014-07-11 07:55:00 | AAPL | Stock | 23.81 | 23.81 | 23.7875 | 23.7925 | 5828.0 |
| 2014-07-11 08:00:00 | AAPL | Stock | 23.81 | 23.835 | 23.7875 | 23.8225 | 87576.0 |
| 2014-07-11 08:05:00 | AAPL | Stock | 23.83 | 23.83 | 23.815 | 23.815 | 28156.0 |
| 2014-07-11 08:10:00 | AAPL | Stock | 23.825 | 23.8375 | 23.825 | 23.8375 | 31928.0 |
| 2014-07-11 08:15:00 | AAPL | Stock | 23.8337 | 23.8375 | 23.8125 | 23.8225 | 37020.0 |
| 2014-07-11 08:20:00 | AAPL | Stock | 23.815 | 23.815 | 23.805 | 23.805 | 9072.0 |
| 2014-07-11 08:25:00 | AAPL | Stock | 23.8075 | 23.825 | 23.8075 | 23.825 | 23408.0 |
| 2014-07-11 08:30:00 | AAPL | Stock | 23.825 | 23.845 | 23.8175 | 23.8425 | 62740.0 |
| 2014-07-11 08:35:00 | AAPL | Stock | 23.835 | 23.8425 | 23.8325 | 23.8325 | 18400.0 |
| 2014-07-11 08:40:00 | AAPL | Stock | 23.825 | 23.8325 | 23.825 | 23.8325 | 5200.0 |
| 2014-07-11 08:45:00 | AAPL | Stock | 23.8325 | 23.8325 | 23.8225 | 23.83 | 12860.0 |
| 2014-07-11 08:50:00 | AAPL | Stock | 23.8275 | 23.8325 | 23.8025 | 23.8025 | 43200.0 |
| 2014-07-11 08:55:00 | AAPL | Stock | 23.815 | 23.815 | 23.805 | 23.805 | 5000.0 |
| 2014-07-11 09:00:00 | AAPL | Stock | 23.805 | 23.805 | 23.8 | 23.8 | 15796.0 |
| 2014-07-11 09:05:00 | AAPL | Stock | 23.7975 | 23.83 | 23.7975 | 23.825 | 43720.0 |
| 2014-07-11 09:10:00 | AAPL | Stock | 23.82 | 23.83 | 23.8075 | 23.83 | 45960.0 |
| 2014-07-11 09:15:00 | AAPL | Stock | 23.825 | 23.83 | 23.8 | 23.8 | 52760.0 |
| 2014-07-11 09:20:00 | AAPL | Stock | 23.82 | 23.825 | 23.8025 | 23.8125 | 6732.0 |
| 2014-07-11 09:25:00 | AAPL | Stock | 23.8125 | 23.845 | 23.8075 | 23.8425 | 104968.0 |
| 2014-07-11 09:30:00 | AAPL | Stock | 23.84 | 23.905 | 23.805 | 23.84 | 7736780.0 |
| 2014-07-11 09:35:00 | AAPL | Stock | 23.84 | 23.855 | 23.8125 | 23.8425 | 3204532.0 |
| 2014-07-11 09:40:00 | AAPL | Stock | 23.8425 | 23.8438 | 23.7625 | 23.7875 | 3851728.0 |
| 2014-07-11 09:45:00 | AAPL | Stock | 23.7875 | 23.795 | 23.74 | 23.75 | 2856924.0 |
> showing 50 of 358,550 rows — these rows as CSV