PREVIEW / stock_5min / 2016-02-03
file: by_date/stock_5min/2016/2016-02-03.parquet size: 5.5 MB rows: 364,572 symbols: 3,371
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-03 04:00:00 | AAPL | Stock | 23.73 | 23.73 | 23.73 | 23.73 | 1124.0 |
| 2016-02-03 04:10:00 | AAPL | Stock | 23.73 | 23.73 | 23.73 | 23.73 | 836.0 |
| 2016-02-03 04:15:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 2000.0 |
| 2016-02-03 04:45:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 3600.0 |
| 2016-02-03 04:50:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 400.0 |
| 2016-02-03 04:55:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 400.0 |
| 2016-02-03 05:05:00 | AAPL | Stock | 23.66 | 23.66 | 23.66 | 23.66 | 400.0 |
| 2016-02-03 05:15:00 | AAPL | Stock | 23.68 | 23.68 | 23.68 | 23.68 | 4000.0 |
| 2016-02-03 05:20:00 | AAPL | Stock | 23.64 | 23.64 | 23.6375 | 23.6375 | 4800.0 |
| 2016-02-03 05:50:00 | AAPL | Stock | 23.665 | 23.665 | 23.65 | 23.65 | 8800.0 |
| 2016-02-03 05:55:00 | AAPL | Stock | 23.6575 | 23.6575 | 23.6575 | 23.6575 | 800.0 |
| 2016-02-03 06:30:00 | AAPL | Stock | 23.775 | 23.775 | 23.775 | 23.775 | 600.0 |
| 2016-02-03 06:35:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 2728.0 |
| 2016-02-03 06:40:00 | AAPL | Stock | 23.7925 | 23.7925 | 23.7925 | 23.7925 | 400.0 |
| 2016-02-03 06:55:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 1180.0 |
| 2016-02-03 07:00:00 | AAPL | Stock | 23.785 | 23.82 | 23.755 | 23.82 | 16824.0 |
| 2016-02-03 07:05:00 | AAPL | Stock | 23.8175 | 23.825 | 23.8175 | 23.8225 | 8600.0 |
| 2016-02-03 07:10:00 | AAPL | Stock | 23.8 | 23.8125 | 23.8 | 23.8125 | 2800.0 |
| 2016-02-03 07:15:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 800.0 |
| 2016-02-03 07:20:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7725 | 23.7875 | 13400.0 |
| 2016-02-03 07:25:00 | AAPL | Stock | 23.77 | 23.775 | 23.755 | 23.755 | 6200.0 |
| 2016-02-03 07:30:00 | AAPL | Stock | 23.765 | 23.765 | 23.7375 | 23.7475 | 3200.0 |
| 2016-02-03 07:40:00 | AAPL | Stock | 23.7325 | 23.7325 | 23.7225 | 23.7225 | 4412.0 |
| 2016-02-03 07:45:00 | AAPL | Stock | 23.7225 | 23.735 | 23.7225 | 23.735 | 800.0 |
| 2016-02-03 07:50:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 400.0 |
| 2016-02-03 07:55:00 | AAPL | Stock | 23.71 | 23.71 | 23.71 | 23.71 | 2600.0 |
| 2016-02-03 08:00:00 | AAPL | Stock | 23.7175 | 23.825 | 23.6925 | 23.73 | 52976.0 |
| 2016-02-03 08:05:00 | AAPL | Stock | 23.745 | 23.745 | 23.725 | 23.725 | 7960.0 |
| 2016-02-03 08:10:00 | AAPL | Stock | 23.73 | 23.73 | 23.7175 | 23.725 | 13396.0 |
| 2016-02-03 08:15:00 | AAPL | Stock | 23.7375 | 23.7425 | 23.725 | 23.725 | 18988.0 |
| 2016-02-03 08:20:00 | AAPL | Stock | 23.71 | 23.725 | 23.6975 | 23.715 | 14992.0 |
| 2016-02-03 08:25:00 | AAPL | Stock | 23.7125 | 23.745 | 23.7025 | 23.745 | 32344.0 |
| 2016-02-03 08:30:00 | AAPL | Stock | 23.74 | 23.7725 | 23.7275 | 23.75 | 45072.0 |
| 2016-02-03 08:35:00 | AAPL | Stock | 23.755 | 23.77 | 23.7375 | 23.7425 | 24040.0 |
| 2016-02-03 08:40:00 | AAPL | Stock | 23.7525 | 23.78 | 23.7525 | 23.78 | 16628.0 |
| 2016-02-03 08:45:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.75 | 23.75 | 31460.0 |
| 2016-02-03 08:50:00 | AAPL | Stock | 23.75 | 23.775 | 23.7425 | 23.77 | 70580.0 |
| 2016-02-03 08:55:00 | AAPL | Stock | 23.7725 | 23.7775 | 23.7625 | 23.77 | 69088.0 |
| 2016-02-03 09:00:00 | AAPL | Stock | 23.765 | 23.7725 | 23.7575 | 23.7725 | 10412.0 |
| 2016-02-03 09:05:00 | AAPL | Stock | 23.7725 | 23.775 | 23.765 | 23.775 | 44244.0 |
| 2016-02-03 09:10:00 | AAPL | Stock | 23.785 | 23.8 | 23.7775 | 23.7875 | 19384.0 |
| 2016-02-03 09:15:00 | AAPL | Stock | 23.7825 | 23.795 | 23.78 | 23.795 | 14520.0 |
| 2016-02-03 09:20:00 | AAPL | Stock | 23.7875 | 23.795 | 23.7825 | 23.795 | 21000.0 |
| 2016-02-03 09:25:00 | AAPL | Stock | 23.7825 | 23.7825 | 23.7275 | 23.75 | 181868.0 |
| 2016-02-03 09:30:00 | AAPL | Stock | 23.75 | 23.845 | 23.715 | 23.7875 | 3646596.0 |
| 2016-02-03 09:35:00 | AAPL | Stock | 23.7875 | 23.8025 | 23.725 | 23.7375 | 2565320.0 |
| 2016-02-03 09:40:00 | AAPL | Stock | 23.7375 | 23.8625 | 23.7375 | 23.85 | 2706176.0 |
| 2016-02-03 09:45:00 | AAPL | Stock | 23.8525 | 23.885 | 23.8 | 23.8838 | 2348056.0 |
| 2016-02-03 09:50:00 | AAPL | Stock | 23.8825 | 23.91 | 23.785 | 23.84 | 2283236.0 |
| 2016-02-03 09:55:00 | AAPL | Stock | 23.8375 | 23.855 | 23.74 | 23.7925 | 2289720.0 |
> showing 50 of 364,572 rows — these rows as CSV