PREVIEW / stock_5min / 2015-12-23
file: by_date/stock_5min/2015/2015-12-23.parquet size: 5.5 MB rows: 367,697 symbols: 3,431
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-23 04:15:00 | AAPL | Stock | 26.85 | 26.85 | 26.85 | 26.85 | 1880.0 |
| 2015-12-23 04:25:00 | AAPL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 1692.0 |
| 2015-12-23 04:30:00 | AAPL | Stock | 26.9 | 26.9 | 26.9 | 26.9 | 800.0 |
| 2015-12-23 04:35:00 | AAPL | Stock | 26.85 | 26.85 | 26.85 | 26.85 | 472.0 |
| 2015-12-23 05:30:00 | AAPL | Stock | 26.875 | 26.875 | 26.875 | 26.875 | 1600.0 |
| 2015-12-23 05:50:00 | AAPL | Stock | 26.8775 | 26.8875 | 26.8775 | 26.8875 | 1588.0 |
| 2015-12-23 05:55:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.885 | 26.8875 | 5000.0 |
| 2015-12-23 06:00:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.875 | 26.8875 | 6000.0 |
| 2015-12-23 06:15:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.8875 | 26.8875 | 800.0 |
| 2015-12-23 06:25:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.8875 | 26.8875 | 1200.0 |
| 2015-12-23 06:50:00 | AAPL | Stock | 26.875 | 26.875 | 26.8625 | 26.8625 | 2000.0 |
| 2015-12-23 07:05:00 | AAPL | Stock | 26.885 | 26.885 | 26.8725 | 26.875 | 9600.0 |
| 2015-12-23 07:10:00 | AAPL | Stock | 26.88 | 26.9 | 26.875 | 26.9 | 8400.0 |
| 2015-12-23 07:15:00 | AAPL | Stock | 26.8825 | 26.9 | 26.8825 | 26.9 | 808.0 |
| 2015-12-23 07:20:00 | AAPL | Stock | 26.905 | 26.9075 | 26.905 | 26.9075 | 5800.0 |
| 2015-12-23 07:30:00 | AAPL | Stock | 26.9025 | 26.925 | 26.9025 | 26.925 | 12756.0 |
| 2015-12-23 07:35:00 | AAPL | Stock | 26.925 | 26.925 | 26.9125 | 26.9125 | 3200.0 |
| 2015-12-23 07:40:00 | AAPL | Stock | 26.9125 | 26.9125 | 26.9125 | 26.9125 | 3344.0 |
| 2015-12-23 07:45:00 | AAPL | Stock | 26.905 | 26.905 | 26.905 | 26.905 | 400.0 |
| 2015-12-23 07:55:00 | AAPL | Stock | 26.91 | 26.91 | 26.895 | 26.895 | 5716.0 |
| 2015-12-23 08:00:00 | AAPL | Stock | 26.89 | 26.92 | 26.8725 | 26.8725 | 41080.0 |
| 2015-12-23 08:05:00 | AAPL | Stock | 26.8725 | 26.875 | 26.8375 | 26.8375 | 24592.0 |
| 2015-12-23 08:10:00 | AAPL | Stock | 26.835 | 26.865 | 26.8325 | 26.855 | 19516.0 |
| 2015-12-23 08:15:00 | AAPL | Stock | 26.855 | 26.855 | 26.855 | 26.855 | 400.0 |
| 2015-12-23 08:20:00 | AAPL | Stock | 26.8575 | 26.88 | 26.8575 | 26.88 | 6672.0 |
| 2015-12-23 08:25:00 | AAPL | Stock | 26.875 | 26.89 | 26.875 | 26.89 | 12000.0 |
| 2015-12-23 08:30:00 | AAPL | Stock | 26.875 | 26.875 | 26.8625 | 26.865 | 22028.0 |
| 2015-12-23 08:35:00 | AAPL | Stock | 26.8625 | 26.8625 | 26.8475 | 26.8475 | 16888.0 |
| 2015-12-23 08:40:00 | AAPL | Stock | 26.845 | 26.845 | 26.825 | 26.825 | 57520.0 |
| 2015-12-23 08:45:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.825 | 26.83 | 13700.0 |
| 2015-12-23 08:50:00 | AAPL | Stock | 26.8275 | 26.8275 | 26.8075 | 26.8225 | 22076.0 |
| 2015-12-23 08:55:00 | AAPL | Stock | 26.815 | 26.82 | 26.81 | 26.81 | 12820.0 |
| 2015-12-23 09:00:00 | AAPL | Stock | 26.81 | 26.8225 | 26.805 | 26.81 | 45996.0 |
| 2015-12-23 09:05:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.82 | 26.825 | 4400.0 |
| 2015-12-23 09:10:00 | AAPL | Stock | 26.815 | 26.825 | 26.8075 | 26.8125 | 9376.0 |
| 2015-12-23 09:15:00 | AAPL | Stock | 26.8125 | 26.8225 | 26.8125 | 26.8225 | 3916.0 |
| 2015-12-23 09:20:00 | AAPL | Stock | 26.8225 | 26.8375 | 26.8175 | 26.835 | 24000.0 |
| 2015-12-23 09:25:00 | AAPL | Stock | 26.82 | 26.835 | 26.795 | 26.805 | 67156.0 |
| 2015-12-23 09:30:00 | AAPL | Stock | 26.8175 | 26.9175 | 26.8 | 26.9075 | 3475676.0 |
| 2015-12-23 09:35:00 | AAPL | Stock | 26.9025 | 27.005 | 26.885 | 26.9225 | 2420096.0 |
| 2015-12-23 09:40:00 | AAPL | Stock | 26.9225 | 26.965 | 26.895 | 26.963 | 2285540.0 |
| 2015-12-23 09:45:00 | AAPL | Stock | 26.9625 | 27.0575 | 26.9575 | 27.0325 | 3551664.0 |
| 2015-12-23 09:50:00 | AAPL | Stock | 27.035 | 27.12 | 27.0225 | 27.1162 | 3286240.0 |
| 2015-12-23 09:55:00 | AAPL | Stock | 27.115 | 27.1175 | 27.0425 | 27.0425 | 2140708.0 |
| 2015-12-23 10:00:00 | AAPL | Stock | 27.0475 | 27.1525 | 27.0475 | 27.1 | 3013744.0 |
| 2015-12-23 10:05:00 | AAPL | Stock | 27.1025 | 27.1262 | 27.03 | 27.0462 | 2558696.0 |
| 2015-12-23 10:10:00 | AAPL | Stock | 27.05 | 27.069 | 27.0275 | 27.055 | 1738844.0 |
| 2015-12-23 10:15:00 | AAPL | Stock | 27.0532 | 27.075 | 27.0225 | 27.03 | 1380620.0 |
| 2015-12-23 10:20:00 | AAPL | Stock | 27.0325 | 27.0725 | 27.0 | 27.0125 | 1526548.0 |
| 2015-12-23 10:25:00 | AAPL | Stock | 27.0112 | 27.0175 | 26.9625 | 26.995 | 2005588.0 |
> showing 50 of 367,697 rows — these rows as CSV