PREVIEW / stock_5min / 2017-03-08
file: by_date/stock_5min/2017/2017-03-08.parquet size: 5.5 MB rows: 358,571 symbols: 3,098
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-08 05:30:00 | AAPL | Stock | 34.92 | 34.92 | 34.92 | 34.92 | 1040.0 |
| 2017-03-08 06:15:00 | AAPL | Stock | 34.9075 | 34.9125 | 34.9075 | 34.9125 | 2800.0 |
| 2017-03-08 06:20:00 | AAPL | Stock | 34.9125 | 34.9125 | 34.9125 | 34.9125 | 2400.0 |
| 2017-03-08 06:25:00 | AAPL | Stock | 34.8875 | 34.8875 | 34.875 | 34.875 | 4744.0 |
| 2017-03-08 06:35:00 | AAPL | Stock | 34.875 | 34.875 | 34.875 | 34.875 | 1200.0 |
| 2017-03-08 06:40:00 | AAPL | Stock | 34.9075 | 34.9075 | 34.9075 | 34.9075 | 1060.0 |
| 2017-03-08 07:00:00 | AAPL | Stock | 34.875 | 34.875 | 34.85 | 34.85 | 5412.0 |
| 2017-03-08 07:05:00 | AAPL | Stock | 34.855 | 34.855 | 34.85 | 34.85 | 8440.0 |
| 2017-03-08 07:10:00 | AAPL | Stock | 34.85 | 34.85 | 34.8 | 34.8125 | 19388.0 |
| 2017-03-08 07:15:00 | AAPL | Stock | 34.8025 | 34.8025 | 34.7875 | 34.7875 | 22720.0 |
| 2017-03-08 07:20:00 | AAPL | Stock | 34.78 | 34.8 | 34.775 | 34.8 | 9808.0 |
| 2017-03-08 07:25:00 | AAPL | Stock | 34.8 | 34.8125 | 34.7675 | 34.7675 | 26664.0 |
| 2017-03-08 07:30:00 | AAPL | Stock | 34.7625 | 34.7625 | 34.725 | 34.7325 | 14492.0 |
| 2017-03-08 07:35:00 | AAPL | Stock | 34.75 | 34.7625 | 34.75 | 34.75 | 10800.0 |
| 2017-03-08 07:40:00 | AAPL | Stock | 34.75 | 34.75 | 34.73 | 34.75 | 8800.0 |
| 2017-03-08 07:45:00 | AAPL | Stock | 34.7525 | 34.775 | 34.75 | 34.775 | 29600.0 |
| 2017-03-08 07:50:00 | AAPL | Stock | 34.78 | 34.8 | 34.775 | 34.79 | 17652.0 |
| 2017-03-08 07:55:00 | AAPL | Stock | 34.7875 | 34.8075 | 34.7875 | 34.8075 | 14512.0 |
| 2017-03-08 08:00:00 | AAPL | Stock | 34.7625 | 34.8075 | 34.7 | 34.7075 | 126028.0 |
| 2017-03-08 08:05:00 | AAPL | Stock | 34.7175 | 34.7425 | 34.715 | 34.7425 | 46416.0 |
| 2017-03-08 08:10:00 | AAPL | Stock | 34.7375 | 34.7575 | 34.7225 | 34.75 | 29156.0 |
| 2017-03-08 08:15:00 | AAPL | Stock | 34.75 | 34.8 | 34.75 | 34.8 | 45820.0 |
| 2017-03-08 08:20:00 | AAPL | Stock | 34.7975 | 34.805 | 34.77 | 34.7875 | 31780.0 |
| 2017-03-08 08:25:00 | AAPL | Stock | 34.77 | 34.78 | 34.75 | 34.78 | 94516.0 |
| 2017-03-08 08:30:00 | AAPL | Stock | 34.775 | 34.785 | 34.775 | 34.785 | 7920.0 |
| 2017-03-08 08:35:00 | AAPL | Stock | 34.775 | 34.775 | 34.74 | 34.75 | 40140.0 |
| 2017-03-08 08:40:00 | AAPL | Stock | 34.74 | 34.74 | 34.68 | 34.685 | 201124.0 |
| 2017-03-08 08:45:00 | AAPL | Stock | 34.685 | 34.7125 | 34.6775 | 34.7125 | 34700.0 |
| 2017-03-08 08:50:00 | AAPL | Stock | 34.71 | 34.725 | 34.71 | 34.725 | 66408.0 |
| 2017-03-08 08:55:00 | AAPL | Stock | 34.715 | 34.775 | 34.7125 | 34.73 | 29592.0 |
| 2017-03-08 09:00:00 | AAPL | Stock | 34.7375 | 34.7375 | 34.705 | 34.7225 | 10000.0 |
| 2017-03-08 09:05:00 | AAPL | Stock | 34.7175 | 34.7375 | 34.7175 | 34.7375 | 34464.0 |
| 2017-03-08 09:10:00 | AAPL | Stock | 34.735 | 34.7475 | 34.73 | 34.7475 | 31124.0 |
| 2017-03-08 09:15:00 | AAPL | Stock | 34.7475 | 34.75 | 34.7225 | 34.725 | 35164.0 |
| 2017-03-08 09:20:00 | AAPL | Stock | 34.725 | 34.7375 | 34.72 | 34.7325 | 8400.0 |
| 2017-03-08 09:25:00 | AAPL | Stock | 34.735 | 34.745 | 34.72 | 34.725 | 78928.0 |
| 2017-03-08 09:30:00 | AAPL | Stock | 34.7375 | 34.85 | 34.725 | 34.8325 | 3870740.0 |
| 2017-03-08 09:35:00 | AAPL | Stock | 34.835 | 34.8725 | 34.775 | 34.8 | 2136384.0 |
| 2017-03-08 09:40:00 | AAPL | Stock | 34.8025 | 34.8375 | 34.785 | 34.815 | 1497384.0 |
| 2017-03-08 09:45:00 | AAPL | Stock | 34.815 | 34.8775 | 34.815 | 34.845 | 1757968.0 |
| 2017-03-08 09:50:00 | AAPL | Stock | 34.8462 | 34.85 | 34.815 | 34.83 | 1660436.0 |
| 2017-03-08 09:55:00 | AAPL | Stock | 34.83 | 34.9 | 34.83 | 34.8988 | 1775476.0 |
| 2017-03-08 10:00:00 | AAPL | Stock | 34.9 | 34.905 | 34.8625 | 34.89 | 1033204.0 |
| 2017-03-08 10:05:00 | AAPL | Stock | 34.8862 | 34.8875 | 34.835 | 34.8425 | 983384.0 |
| 2017-03-08 10:10:00 | AAPL | Stock | 34.84 | 34.841 | 34.8075 | 34.8338 | 835472.0 |
| 2017-03-08 10:15:00 | AAPL | Stock | 34.835 | 34.8625 | 34.8312 | 34.8475 | 845724.0 |
| 2017-03-08 10:20:00 | AAPL | Stock | 34.8462 | 34.8675 | 34.8375 | 34.855 | 793884.0 |
| 2017-03-08 10:25:00 | AAPL | Stock | 34.855 | 34.8825 | 34.8525 | 34.88 | 681160.0 |
| 2017-03-08 10:30:00 | AAPL | Stock | 34.88 | 34.91 | 34.875 | 34.885 | 886596.0 |
| 2017-03-08 10:35:00 | AAPL | Stock | 34.8825 | 34.8925 | 34.8625 | 34.8725 | 572000.0 |
> showing 50 of 358,571 rows — these rows as CSV