PREVIEW / stock_5min / 2015-12-07
file: by_date/stock_5min/2015/2015-12-07.parquet size: 5.6 MB rows: 372,564 symbols: 3,420
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-07 04:00:00 | AAPL | Stock | 29.81 | 29.815 | 29.81 | 29.815 | 3676.0 |
| 2015-12-07 04:05:00 | AAPL | Stock | 29.8575 | 29.8625 | 29.8575 | 29.8625 | 9276.0 |
| 2015-12-07 04:15:00 | AAPL | Stock | 29.8625 | 29.875 | 29.8625 | 29.875 | 3200.0 |
| 2015-12-07 04:20:00 | AAPL | Stock | 29.88 | 29.88 | 29.88 | 29.88 | 1600.0 |
| 2015-12-07 04:35:00 | AAPL | Stock | 29.825 | 29.825 | 29.825 | 29.825 | 400.0 |
| 2015-12-07 04:40:00 | AAPL | Stock | 29.825 | 29.825 | 29.825 | 29.825 | 7600.0 |
| 2015-12-07 04:45:00 | AAPL | Stock | 29.86 | 29.86 | 29.86 | 29.86 | 3600.0 |
| 2015-12-07 05:10:00 | AAPL | Stock | 29.8375 | 29.8375 | 29.8375 | 29.8375 | 4000.0 |
| 2015-12-07 05:40:00 | AAPL | Stock | 29.8775 | 29.8775 | 29.8525 | 29.8525 | 1888.0 |
| 2015-12-07 05:45:00 | AAPL | Stock | 29.8525 | 29.8525 | 29.8525 | 29.8525 | 400.0 |
| 2015-12-07 06:00:00 | AAPL | Stock | 29.8325 | 29.84 | 29.8325 | 29.84 | 4060.0 |
| 2015-12-07 06:05:00 | AAPL | Stock | 29.84 | 29.84 | 29.8325 | 29.8325 | 7200.0 |
| 2015-12-07 06:10:00 | AAPL | Stock | 29.8325 | 29.8325 | 29.8325 | 29.8325 | 4000.0 |
| 2015-12-07 06:15:00 | AAPL | Stock | 29.825 | 29.825 | 29.825 | 29.825 | 620.0 |
| 2015-12-07 06:30:00 | AAPL | Stock | 29.825 | 29.825 | 29.825 | 29.825 | 800.0 |
| 2015-12-07 06:35:00 | AAPL | Stock | 29.815 | 29.815 | 29.815 | 29.815 | 400.0 |
| 2015-12-07 06:45:00 | AAPL | Stock | 29.825 | 29.8375 | 29.825 | 29.8375 | 4800.0 |
| 2015-12-07 07:00:00 | AAPL | Stock | 29.815 | 29.8175 | 29.8025 | 29.8175 | 12736.0 |
| 2015-12-07 07:05:00 | AAPL | Stock | 29.8175 | 29.8325 | 29.815 | 29.825 | 25724.0 |
| 2015-12-07 07:10:00 | AAPL | Stock | 29.82 | 29.82 | 29.78 | 29.78 | 5496.0 |
| 2015-12-07 07:15:00 | AAPL | Stock | 29.8125 | 29.825 | 29.8 | 29.8175 | 48912.0 |
| 2015-12-07 07:20:00 | AAPL | Stock | 29.825 | 29.825 | 29.7825 | 29.7825 | 9600.0 |
| 2015-12-07 07:25:00 | AAPL | Stock | 29.7875 | 29.7875 | 29.7875 | 29.7875 | 6000.0 |
| 2015-12-07 07:35:00 | AAPL | Stock | 29.805 | 29.805 | 29.78 | 29.7825 | 7172.0 |
| 2015-12-07 07:50:00 | AAPL | Stock | 29.8 | 29.8 | 29.8 | 29.8 | 6160.0 |
| 2015-12-07 07:55:00 | AAPL | Stock | 29.79 | 29.7975 | 29.7875 | 29.7975 | 3000.0 |
| 2015-12-07 08:00:00 | AAPL | Stock | 29.7875 | 29.82 | 29.74 | 29.75 | 159944.0 |
| 2015-12-07 08:05:00 | AAPL | Stock | 29.75 | 29.75 | 29.725 | 29.7275 | 39572.0 |
| 2015-12-07 08:10:00 | AAPL | Stock | 29.735 | 29.7375 | 29.7275 | 29.7375 | 13040.0 |
| 2015-12-07 08:15:00 | AAPL | Stock | 29.7325 | 29.735 | 29.7275 | 29.7275 | 8480.0 |
| 2015-12-07 08:20:00 | AAPL | Stock | 29.725 | 29.725 | 29.705 | 29.705 | 21620.0 |
| 2015-12-07 08:25:00 | AAPL | Stock | 29.7225 | 29.7225 | 29.7025 | 29.7125 | 7852.0 |
| 2015-12-07 08:30:00 | AAPL | Stock | 29.7125 | 29.725 | 29.705 | 29.705 | 54128.0 |
| 2015-12-07 08:35:00 | AAPL | Stock | 29.705 | 29.7275 | 29.705 | 29.7275 | 4000.0 |
| 2015-12-07 08:40:00 | AAPL | Stock | 29.725 | 29.73 | 29.72 | 29.725 | 26252.0 |
| 2015-12-07 08:45:00 | AAPL | Stock | 29.7175 | 29.73 | 29.715 | 29.73 | 7040.0 |
| 2015-12-07 08:50:00 | AAPL | Stock | 29.73 | 29.73 | 29.715 | 29.725 | 10600.0 |
| 2015-12-07 08:55:00 | AAPL | Stock | 29.725 | 29.725 | 29.72 | 29.725 | 27700.0 |
| 2015-12-07 09:00:00 | AAPL | Stock | 29.7225 | 29.73 | 29.715 | 29.725 | 15348.0 |
| 2015-12-07 09:05:00 | AAPL | Stock | 29.7225 | 29.73 | 29.72 | 29.72 | 14512.0 |
| 2015-12-07 09:10:00 | AAPL | Stock | 29.725 | 29.735 | 29.725 | 29.7275 | 32804.0 |
| 2015-12-07 09:15:00 | AAPL | Stock | 29.7375 | 29.745 | 29.7375 | 29.7425 | 11120.0 |
| 2015-12-07 09:20:00 | AAPL | Stock | 29.7375 | 29.7475 | 29.7375 | 29.745 | 46580.0 |
| 2015-12-07 09:25:00 | AAPL | Stock | 29.7475 | 29.78 | 29.715 | 29.7325 | 100148.0 |
| 2015-12-07 09:30:00 | AAPL | Stock | 29.735 | 29.8 | 29.6525 | 29.7415 | 5569884.0 |
| 2015-12-07 09:35:00 | AAPL | Stock | 29.7385 | 29.965 | 29.735 | 29.9225 | 5608516.0 |
| 2015-12-07 09:40:00 | AAPL | Stock | 29.925 | 29.93 | 29.7875 | 29.8325 | 3347112.0 |
| 2015-12-07 09:45:00 | AAPL | Stock | 29.83 | 29.8315 | 29.6975 | 29.7285 | 3442064.0 |
| 2015-12-07 09:50:00 | AAPL | Stock | 29.725 | 29.7475 | 29.6325 | 29.6675 | 3514824.0 |
| 2015-12-07 09:55:00 | AAPL | Stock | 29.665 | 29.85 | 29.6575 | 29.782 | 3051640.0 |
> showing 50 of 372,564 rows — these rows as CSV