PREVIEW / stock_5min / 2017-03-15
file: by_date/stock_5min/2017/2017-03-15.parquet size: 5.5 MB rows: 359,511 symbols: 3,082
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-15 04:00:00 | AAPL | Stock | 34.7925 | 34.7925 | 34.7925 | 34.7925 | 560.0 |
| 2017-03-15 04:10:00 | AAPL | Stock | 34.7925 | 34.7925 | 34.7925 | 34.7925 | 2560.0 |
| 2017-03-15 05:35:00 | AAPL | Stock | 34.83 | 34.83 | 34.83 | 34.83 | 2600.0 |
| 2017-03-15 05:55:00 | AAPL | Stock | 34.7825 | 34.7825 | 34.7825 | 34.7825 | 480.0 |
| 2017-03-15 06:10:00 | AAPL | Stock | 34.8125 | 34.8425 | 34.8125 | 34.8425 | 2432.0 |
| 2017-03-15 06:15:00 | AAPL | Stock | 34.8125 | 34.8125 | 34.8125 | 34.8125 | 800.0 |
| 2017-03-15 06:25:00 | AAPL | Stock | 34.8125 | 34.8125 | 34.8125 | 34.8125 | 7200.0 |
| 2017-03-15 06:35:00 | AAPL | Stock | 34.84 | 34.8425 | 34.84 | 34.8425 | 3508.0 |
| 2017-03-15 06:40:00 | AAPL | Stock | 34.8175 | 34.8175 | 34.8175 | 34.8175 | 400.0 |
| 2017-03-15 06:45:00 | AAPL | Stock | 34.82 | 34.82 | 34.8175 | 34.8175 | 1512.0 |
| 2017-03-15 06:55:00 | AAPL | Stock | 34.8225 | 34.8225 | 34.8225 | 34.8225 | 3144.0 |
| 2017-03-15 07:05:00 | AAPL | Stock | 34.8125 | 34.8125 | 34.8125 | 34.8125 | 6000.0 |
| 2017-03-15 07:15:00 | AAPL | Stock | 34.8125 | 34.8125 | 34.8125 | 34.8125 | 400.0 |
| 2017-03-15 07:25:00 | AAPL | Stock | 34.82 | 34.82 | 34.82 | 34.82 | 5400.0 |
| 2017-03-15 07:30:00 | AAPL | Stock | 34.8175 | 34.825 | 34.8125 | 34.8125 | 26580.0 |
| 2017-03-15 07:35:00 | AAPL | Stock | 34.8225 | 34.8225 | 34.8225 | 34.8225 | 1800.0 |
| 2017-03-15 07:40:00 | AAPL | Stock | 34.8225 | 34.8225 | 34.8225 | 34.8225 | 1116.0 |
| 2017-03-15 07:45:00 | AAPL | Stock | 34.8225 | 34.8225 | 34.8225 | 34.8225 | 600.0 |
| 2017-03-15 07:55:00 | AAPL | Stock | 34.8225 | 34.8225 | 34.8225 | 34.8225 | 3200.0 |
| 2017-03-15 08:00:00 | AAPL | Stock | 34.8125 | 34.8275 | 34.8025 | 34.805 | 14180.0 |
| 2017-03-15 08:05:00 | AAPL | Stock | 34.8225 | 34.8225 | 34.8125 | 34.8125 | 3600.0 |
| 2017-03-15 08:15:00 | AAPL | Stock | 34.805 | 34.81 | 34.805 | 34.81 | 9120.0 |
| 2017-03-15 08:20:00 | AAPL | Stock | 34.81 | 34.81 | 34.8 | 34.8 | 12576.0 |
| 2017-03-15 08:25:00 | AAPL | Stock | 34.81 | 34.825 | 34.81 | 34.81 | 10108.0 |
| 2017-03-15 08:30:00 | AAPL | Stock | 34.8175 | 34.8175 | 34.8175 | 34.8175 | 1120.0 |
| 2017-03-15 08:35:00 | AAPL | Stock | 34.81 | 34.82 | 34.81 | 34.82 | 15600.0 |
| 2017-03-15 08:40:00 | AAPL | Stock | 34.815 | 34.8175 | 34.815 | 34.8175 | 4560.0 |
| 2017-03-15 08:45:00 | AAPL | Stock | 34.8125 | 34.8125 | 34.8125 | 34.8125 | 400.0 |
| 2017-03-15 08:50:00 | AAPL | Stock | 34.825 | 34.825 | 34.8125 | 34.8125 | 8792.0 |
| 2017-03-15 08:55:00 | AAPL | Stock | 34.81 | 34.81 | 34.805 | 34.805 | 4400.0 |
| 2017-03-15 09:00:00 | AAPL | Stock | 34.81 | 34.81 | 34.81 | 34.81 | 800.0 |
| 2017-03-15 09:05:00 | AAPL | Stock | 34.81 | 34.81 | 34.8025 | 34.81 | 20028.0 |
| 2017-03-15 09:10:00 | AAPL | Stock | 34.8175 | 34.82 | 34.795 | 34.8175 | 31348.0 |
| 2017-03-15 09:15:00 | AAPL | Stock | 34.82 | 34.8375 | 34.82 | 34.8375 | 24200.0 |
| 2017-03-15 09:20:00 | AAPL | Stock | 34.835 | 34.8575 | 34.835 | 34.8575 | 21572.0 |
| 2017-03-15 09:25:00 | AAPL | Stock | 34.8475 | 34.8875 | 34.83 | 34.865 | 97580.0 |
| 2017-03-15 09:30:00 | AAPL | Stock | 34.865 | 34.88 | 34.8 | 34.8275 | 3130304.0 |
| 2017-03-15 09:35:00 | AAPL | Stock | 34.8275 | 34.835 | 34.775 | 34.8125 | 1386636.0 |
| 2017-03-15 09:40:00 | AAPL | Stock | 34.8125 | 34.825 | 34.7825 | 34.795 | 1376512.0 |
| 2017-03-15 09:45:00 | AAPL | Stock | 34.795 | 34.8075 | 34.7675 | 34.78 | 1102272.0 |
| 2017-03-15 09:50:00 | AAPL | Stock | 34.78 | 34.8125 | 34.7562 | 34.793 | 1346152.0 |
| 2017-03-15 09:55:00 | AAPL | Stock | 34.7925 | 34.83 | 34.777 | 34.815 | 1310232.0 |
| 2017-03-15 10:00:00 | AAPL | Stock | 34.8125 | 34.83 | 34.795 | 34.815 | 777812.0 |
| 2017-03-15 10:05:00 | AAPL | Stock | 34.815 | 34.82 | 34.795 | 34.8075 | 584480.0 |
| 2017-03-15 10:10:00 | AAPL | Stock | 34.805 | 34.835 | 34.8025 | 34.8312 | 642512.0 |
| 2017-03-15 10:15:00 | AAPL | Stock | 34.8325 | 34.8375 | 34.805 | 34.8275 | 616356.0 |
| 2017-03-15 10:20:00 | AAPL | Stock | 34.825 | 34.8375 | 34.8225 | 34.8275 | 591040.0 |
| 2017-03-15 10:25:00 | AAPL | Stock | 34.8275 | 34.8375 | 34.82 | 34.83 | 499320.0 |
| 2017-03-15 10:30:00 | AAPL | Stock | 34.8312 | 34.8375 | 34.8112 | 34.8225 | 523964.0 |
| 2017-03-15 10:35:00 | AAPL | Stock | 34.825 | 34.8285 | 34.8112 | 34.8125 | 399884.0 |
> showing 50 of 359,511 rows — these rows as CSV