PREVIEW / stock_5min / 2017-06-15
file: by_date/stock_5min/2017/2017-06-15.parquet size: 5.3 MB rows: 352,129 symbols: 3,029
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-06-15 04:00:00 | AAPL | Stock | 35.975 | 35.975 | 35.8125 | 35.8125 | 12688.0 |
| 2017-06-15 04:05:00 | AAPL | Stock | 35.9275 | 35.9275 | 35.885 | 35.885 | 5120.0 |
| 2017-06-15 04:10:00 | AAPL | Stock | 35.8875 | 35.8875 | 35.8875 | 35.8875 | 400.0 |
| 2017-06-15 04:20:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.93 | 35.93 | 3212.0 |
| 2017-06-15 04:25:00 | AAPL | Stock | 35.9025 | 35.9025 | 35.9025 | 35.9025 | 1200.0 |
| 2017-06-15 04:40:00 | AAPL | Stock | 35.9375 | 35.9375 | 35.9375 | 35.9375 | 1600.0 |
| 2017-06-15 04:45:00 | AAPL | Stock | 35.875 | 35.9 | 35.875 | 35.9 | 4400.0 |
| 2017-06-15 04:50:00 | AAPL | Stock | 35.905 | 35.905 | 35.8875 | 35.8875 | 4400.0 |
| 2017-06-15 04:55:00 | AAPL | Stock | 35.9325 | 35.9325 | 35.8825 | 35.9 | 12220.0 |
| 2017-06-15 05:00:00 | AAPL | Stock | 35.86 | 35.86 | 35.855 | 35.855 | 5972.0 |
| 2017-06-15 05:10:00 | AAPL | Stock | 35.8475 | 35.8475 | 35.8475 | 35.8475 | 2400.0 |
| 2017-06-15 05:15:00 | AAPL | Stock | 35.8475 | 35.9 | 35.8475 | 35.9 | 2056.0 |
| 2017-06-15 05:25:00 | AAPL | Stock | 35.8625 | 35.8625 | 35.8625 | 35.8625 | 2400.0 |
| 2017-06-15 05:35:00 | AAPL | Stock | 35.8725 | 35.8725 | 35.8725 | 35.8725 | 420.0 |
| 2017-06-15 05:40:00 | AAPL | Stock | 35.8725 | 35.875 | 35.85 | 35.875 | 4400.0 |
| 2017-06-15 05:45:00 | AAPL | Stock | 35.875 | 35.875 | 35.875 | 35.875 | 9592.0 |
| 2017-06-15 05:50:00 | AAPL | Stock | 35.85 | 35.85 | 35.85 | 35.85 | 2400.0 |
| 2017-06-15 05:55:00 | AAPL | Stock | 35.85 | 35.85 | 35.845 | 35.845 | 4608.0 |
| 2017-06-15 06:00:00 | AAPL | Stock | 35.8275 | 35.8275 | 35.8275 | 35.8275 | 1808.0 |
| 2017-06-15 06:05:00 | AAPL | Stock | 35.825 | 35.8825 | 35.825 | 35.8275 | 5184.0 |
| 2017-06-15 06:10:00 | AAPL | Stock | 35.825 | 35.835 | 35.8 | 35.8 | 15488.0 |
| 2017-06-15 06:15:00 | AAPL | Stock | 35.8575 | 35.8625 | 35.7875 | 35.7875 | 15728.0 |
| 2017-06-15 06:20:00 | AAPL | Stock | 35.805 | 35.805 | 35.805 | 35.805 | 6552.0 |
| 2017-06-15 06:25:00 | AAPL | Stock | 35.795 | 35.85 | 35.795 | 35.85 | 4416.0 |
| 2017-06-15 06:40:00 | AAPL | Stock | 35.8475 | 35.8475 | 35.8475 | 35.8475 | 400.0 |
| 2017-06-15 06:45:00 | AAPL | Stock | 35.8275 | 35.8275 | 35.775 | 35.78 | 15000.0 |
| 2017-06-15 06:50:00 | AAPL | Stock | 35.81 | 35.81 | 35.81 | 35.81 | 800.0 |
| 2017-06-15 06:55:00 | AAPL | Stock | 35.81 | 35.8175 | 35.81 | 35.8175 | 24996.0 |
| 2017-06-15 07:00:00 | AAPL | Stock | 35.825 | 35.8475 | 35.8 | 35.8475 | 9688.0 |
| 2017-06-15 07:05:00 | AAPL | Stock | 35.8 | 35.825 | 35.8 | 35.8125 | 1600.0 |
| 2017-06-15 07:10:00 | AAPL | Stock | 35.825 | 35.85 | 35.82 | 35.8375 | 13180.0 |
| 2017-06-15 07:15:00 | AAPL | Stock | 35.8375 | 35.8375 | 35.79 | 35.8175 | 6572.0 |
| 2017-06-15 07:20:00 | AAPL | Stock | 35.825 | 35.825 | 35.785 | 35.785 | 10800.0 |
| 2017-06-15 07:25:00 | AAPL | Stock | 35.7875 | 35.8125 | 35.7875 | 35.8025 | 14384.0 |
| 2017-06-15 07:30:00 | AAPL | Stock | 35.815 | 35.815 | 35.8 | 35.8 | 6384.0 |
| 2017-06-15 07:35:00 | AAPL | Stock | 35.8175 | 35.8175 | 35.79 | 35.8 | 7480.0 |
| 2017-06-15 07:40:00 | AAPL | Stock | 35.8 | 35.85 | 35.8 | 35.85 | 21448.0 |
| 2017-06-15 07:45:00 | AAPL | Stock | 35.8525 | 35.8625 | 35.8525 | 35.8525 | 8600.0 |
| 2017-06-15 07:50:00 | AAPL | Stock | 35.825 | 35.8275 | 35.8225 | 35.8275 | 13868.0 |
| 2017-06-15 07:55:00 | AAPL | Stock | 35.8125 | 35.85 | 35.8125 | 35.8125 | 28840.0 |
| 2017-06-15 08:00:00 | AAPL | Stock | 35.8375 | 35.9 | 35.75 | 35.8 | 236724.0 |
| 2017-06-15 08:05:00 | AAPL | Stock | 35.8025 | 35.8025 | 35.72 | 35.78 | 84816.0 |
| 2017-06-15 08:10:00 | AAPL | Stock | 35.7675 | 35.7975 | 35.735 | 35.795 | 45768.0 |
| 2017-06-15 08:15:00 | AAPL | Stock | 35.79 | 35.815 | 35.79 | 35.815 | 78932.0 |
| 2017-06-15 08:20:00 | AAPL | Stock | 35.7925 | 35.825 | 35.79 | 35.825 | 31468.0 |
| 2017-06-15 08:25:00 | AAPL | Stock | 35.8312 | 35.85 | 35.825 | 35.825 | 63224.0 |
| 2017-06-15 08:30:00 | AAPL | Stock | 35.795 | 35.8675 | 35.7875 | 35.85 | 52736.0 |
| 2017-06-15 08:35:00 | AAPL | Stock | 35.875 | 35.8875 | 35.8375 | 35.865 | 55008.0 |
| 2017-06-15 08:40:00 | AAPL | Stock | 35.8625 | 35.88 | 35.8375 | 35.85 | 16268.0 |
| 2017-06-15 08:45:00 | AAPL | Stock | 35.87 | 35.88 | 35.8375 | 35.8725 | 18888.0 |
> showing 50 of 352,129 rows — these rows as CSV