PREVIEW / stock_5min / 2016-02-16
file: by_date/stock_5min/2016/2016-02-16.parquet size: 5.4 MB rows: 363,947 symbols: 3,359
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-16 04:00:00 | AAPL | Stock | 23.46 | 24.0525 | 23.46 | 23.96 | 9132.0 |
| 2016-02-16 04:05:00 | AAPL | Stock | 23.96 | 23.96 | 23.95 | 23.95 | 2000.0 |
| 2016-02-16 04:10:00 | AAPL | Stock | 23.95 | 23.95 | 23.885 | 23.8875 | 13124.0 |
| 2016-02-16 04:15:00 | AAPL | Stock | 23.8875 | 23.8875 | 23.875 | 23.875 | 1528.0 |
| 2016-02-16 04:25:00 | AAPL | Stock | 23.9475 | 23.95 | 23.9475 | 23.95 | 3644.0 |
| 2016-02-16 04:40:00 | AAPL | Stock | 23.915 | 23.915 | 23.915 | 23.915 | 2000.0 |
| 2016-02-16 04:55:00 | AAPL | Stock | 23.885 | 23.885 | 23.885 | 23.885 | 400.0 |
| 2016-02-16 05:00:00 | AAPL | Stock | 23.8775 | 23.8775 | 23.8775 | 23.8775 | 3800.0 |
| 2016-02-16 05:15:00 | AAPL | Stock | 23.84 | 23.84 | 23.8375 | 23.8375 | 2000.0 |
| 2016-02-16 05:30:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 400.0 |
| 2016-02-16 06:10:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 3760.0 |
| 2016-02-16 06:15:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 1076.0 |
| 2016-02-16 06:25:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 2852.0 |
| 2016-02-16 06:35:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 400.0 |
| 2016-02-16 06:45:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 400.0 |
| 2016-02-16 06:50:00 | AAPL | Stock | 23.8375 | 23.85 | 23.8375 | 23.85 | 4536.0 |
| 2016-02-16 06:55:00 | AAPL | Stock | 23.825 | 23.85 | 23.8125 | 23.85 | 12800.0 |
| 2016-02-16 07:00:00 | AAPL | Stock | 23.8575 | 23.8575 | 23.84 | 23.84 | 7604.0 |
| 2016-02-16 07:05:00 | AAPL | Stock | 23.8625 | 23.8625 | 23.8625 | 23.8625 | 1900.0 |
| 2016-02-16 07:10:00 | AAPL | Stock | 23.85 | 23.8625 | 23.85 | 23.8625 | 12304.0 |
| 2016-02-16 07:15:00 | AAPL | Stock | 23.8625 | 23.8625 | 23.8625 | 23.8625 | 400.0 |
| 2016-02-16 07:20:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 5200.0 |
| 2016-02-16 07:25:00 | AAPL | Stock | 23.8325 | 23.8375 | 23.8325 | 23.8375 | 5600.0 |
| 2016-02-16 07:30:00 | AAPL | Stock | 23.85 | 23.8625 | 23.85 | 23.8625 | 9976.0 |
| 2016-02-16 07:35:00 | AAPL | Stock | 23.8675 | 23.8875 | 23.8675 | 23.8875 | 30200.0 |
| 2016-02-16 07:40:00 | AAPL | Stock | 23.89 | 23.9 | 23.8875 | 23.9 | 11260.0 |
| 2016-02-16 07:45:00 | AAPL | Stock | 23.9025 | 23.9025 | 23.8875 | 23.89 | 11364.0 |
| 2016-02-16 07:50:00 | AAPL | Stock | 23.8775 | 23.885 | 23.875 | 23.885 | 4400.0 |
| 2016-02-16 07:55:00 | AAPL | Stock | 23.875 | 23.875 | 23.87 | 23.87 | 22152.0 |
| 2016-02-16 08:00:00 | AAPL | Stock | 23.8625 | 23.9025 | 23.45 | 23.8 | 101684.0 |
| 2016-02-16 08:05:00 | AAPL | Stock | 23.8 | 23.8125 | 23.78 | 23.7875 | 56832.0 |
| 2016-02-16 08:10:00 | AAPL | Stock | 23.78 | 23.7875 | 23.7625 | 23.7675 | 59988.0 |
| 2016-02-16 08:15:00 | AAPL | Stock | 23.775 | 23.775 | 23.7625 | 23.775 | 31752.0 |
| 2016-02-16 08:20:00 | AAPL | Stock | 23.765 | 23.7725 | 23.75 | 23.75 | 22728.0 |
| 2016-02-16 08:25:00 | AAPL | Stock | 23.7525 | 23.7625 | 23.75 | 23.75 | 16452.0 |
| 2016-02-16 08:30:00 | AAPL | Stock | 23.75 | 23.7875 | 23.745 | 23.7875 | 55448.0 |
| 2016-02-16 08:35:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.75 | 23.7525 | 24972.0 |
| 2016-02-16 08:40:00 | AAPL | Stock | 23.745 | 23.78 | 23.725 | 23.725 | 39148.0 |
| 2016-02-16 08:45:00 | AAPL | Stock | 23.73 | 23.7525 | 23.725 | 23.75 | 22236.0 |
| 2016-02-16 08:50:00 | AAPL | Stock | 23.75 | 23.7925 | 23.75 | 23.7825 | 27028.0 |
| 2016-02-16 08:55:00 | AAPL | Stock | 23.7825 | 23.795 | 23.7775 | 23.7875 | 25484.0 |
| 2016-02-16 09:00:00 | AAPL | Stock | 23.785 | 23.79 | 23.7775 | 23.7875 | 20456.0 |
| 2016-02-16 09:05:00 | AAPL | Stock | 23.7825 | 23.7925 | 23.775 | 23.7925 | 28552.0 |
| 2016-02-16 09:10:00 | AAPL | Stock | 23.7925 | 23.8125 | 23.7825 | 23.8125 | 115740.0 |
| 2016-02-16 09:15:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.795 | 23.8 | 18804.0 |
| 2016-02-16 09:20:00 | AAPL | Stock | 23.8 | 23.81 | 23.7975 | 23.7975 | 3904.0 |
| 2016-02-16 09:25:00 | AAPL | Stock | 23.795 | 23.8 | 23.7275 | 23.7475 | 57840.0 |
| 2016-02-16 09:30:00 | AAPL | Stock | 23.74 | 23.755 | 23.6575 | 23.6675 | 5829988.0 |
| 2016-02-16 09:35:00 | AAPL | Stock | 23.6675 | 23.7825 | 23.6525 | 23.7625 | 3321012.0 |
| 2016-02-16 09:40:00 | AAPL | Stock | 23.7635 | 23.8575 | 23.745 | 23.8525 | 4493044.0 |
> showing 50 of 363,947 rows — these rows as CSV