PREVIEW / stock_5min / 2016-07-20
file: by_date/stock_5min/2016/2016-07-20.parquet size: 5.3 MB rows: 350,852 symbols: 3,267
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-07-20 04:10:00 | AAPL | Stock | 24.96 | 24.96 | 24.96 | 24.96 | 496.0 |
| 2016-07-20 05:30:00 | AAPL | Stock | 25.0325 | 25.04 | 25.0325 | 25.04 | 1600.0 |
| 2016-07-20 06:25:00 | AAPL | Stock | 25.01 | 25.01 | 25.01 | 25.01 | 400.0 |
| 2016-07-20 07:05:00 | AAPL | Stock | 25.01 | 25.01 | 25.01 | 25.01 | 1668.0 |
| 2016-07-20 07:10:00 | AAPL | Stock | 25.0125 | 25.0275 | 25.0125 | 25.0225 | 7616.0 |
| 2016-07-20 07:15:00 | AAPL | Stock | 25.0325 | 25.0325 | 25.03 | 25.03 | 1392.0 |
| 2016-07-20 07:20:00 | AAPL | Stock | 25.035 | 25.0375 | 25.035 | 25.0375 | 7424.0 |
| 2016-07-20 07:30:00 | AAPL | Stock | 25.0275 | 25.0275 | 25.0225 | 25.0225 | 3284.0 |
| 2016-07-20 07:40:00 | AAPL | Stock | 25.035 | 25.04 | 25.035 | 25.0375 | 4992.0 |
| 2016-07-20 07:45:00 | AAPL | Stock | 25.0375 | 25.0375 | 25.025 | 25.025 | 1600.0 |
| 2016-07-20 07:50:00 | AAPL | Stock | 25.0225 | 25.0225 | 25.02 | 25.02 | 3600.0 |
| 2016-07-20 07:55:00 | AAPL | Stock | 25.0225 | 25.0325 | 25.02 | 25.0325 | 12000.0 |
| 2016-07-20 08:00:00 | AAPL | Stock | 25.025 | 25.0375 | 25.0225 | 25.03 | 103756.0 |
| 2016-07-20 08:05:00 | AAPL | Stock | 25.0325 | 25.0325 | 25.03 | 25.0325 | 9400.0 |
| 2016-07-20 08:10:00 | AAPL | Stock | 25.025 | 25.0325 | 25.025 | 25.0325 | 19156.0 |
| 2016-07-20 08:15:00 | AAPL | Stock | 25.03 | 25.0325 | 25.025 | 25.025 | 24112.0 |
| 2016-07-20 08:20:00 | AAPL | Stock | 25.03 | 25.03 | 25.0225 | 25.03 | 8020.0 |
| 2016-07-20 08:25:00 | AAPL | Stock | 25.0225 | 25.0325 | 25.0225 | 25.0325 | 9600.0 |
| 2016-07-20 08:30:00 | AAPL | Stock | 25.0325 | 25.0325 | 25.0325 | 25.0325 | 400.0 |
| 2016-07-20 08:35:00 | AAPL | Stock | 25.0325 | 25.0325 | 25.0275 | 25.0325 | 43788.0 |
| 2016-07-20 08:40:00 | AAPL | Stock | 25.0275 | 25.0325 | 25.0275 | 25.0275 | 41748.0 |
| 2016-07-20 08:45:00 | AAPL | Stock | 25.0225 | 25.025 | 25.02 | 25.02 | 23796.0 |
| 2016-07-20 08:50:00 | AAPL | Stock | 25.02 | 25.025 | 25.005 | 25.025 | 52072.0 |
| 2016-07-20 08:55:00 | AAPL | Stock | 25.0225 | 25.025 | 25.02 | 25.02 | 5200.0 |
| 2016-07-20 09:00:00 | AAPL | Stock | 25.02 | 25.02 | 25.005 | 25.005 | 11552.0 |
| 2016-07-20 09:05:00 | AAPL | Stock | 25.005 | 25.0125 | 25.0025 | 25.01 | 13200.0 |
| 2016-07-20 09:10:00 | AAPL | Stock | 25.0075 | 25.015 | 25.0075 | 25.0125 | 6960.0 |
| 2016-07-20 09:15:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.0025 | 25.0125 | 3200.0 |
| 2016-07-20 09:20:00 | AAPL | Stock | 25.0125 | 25.0225 | 25.0125 | 25.015 | 3360.0 |
| 2016-07-20 09:25:00 | AAPL | Stock | 25.015 | 25.025 | 24.9775 | 24.98 | 106624.0 |
| 2016-07-20 09:30:00 | AAPL | Stock | 24.98 | 25.065 | 24.97 | 25.0188 | 5642580.0 |
| 2016-07-20 09:35:00 | AAPL | Stock | 25.0175 | 25.0325 | 24.99 | 25.0075 | 2375168.0 |
| 2016-07-20 09:40:00 | AAPL | Stock | 25.0075 | 25.0325 | 24.9975 | 25.0075 | 1682864.0 |
| 2016-07-20 09:45:00 | AAPL | Stock | 25.009 | 25.08 | 24.9975 | 25.07 | 2727104.0 |
| 2016-07-20 09:50:00 | AAPL | Stock | 25.07 | 25.115 | 25.065 | 25.0725 | 2731952.0 |
| 2016-07-20 09:55:00 | AAPL | Stock | 25.07 | 25.0738 | 25.0275 | 25.055 | 2524964.0 |
| 2016-07-20 10:00:00 | AAPL | Stock | 25.0525 | 25.065 | 25.025 | 25.0495 | 1712484.0 |
| 2016-07-20 10:05:00 | AAPL | Stock | 25.05 | 25.0525 | 24.9912 | 25.01 | 2119032.0 |
| 2016-07-20 10:10:00 | AAPL | Stock | 25.008 | 25.015 | 24.965 | 24.9875 | 2390480.0 |
| 2016-07-20 10:15:00 | AAPL | Stock | 24.9875 | 25.0375 | 24.9812 | 25.0325 | 1489928.0 |
| 2016-07-20 10:20:00 | AAPL | Stock | 25.035 | 25.0575 | 25.0275 | 25.0492 | 2526736.0 |
| 2016-07-20 10:25:00 | AAPL | Stock | 25.0495 | 25.05 | 25.005 | 25.0075 | 1269728.0 |
| 2016-07-20 10:30:00 | AAPL | Stock | 25.0075 | 25.035 | 24.9975 | 25.0275 | 1369444.0 |
| 2016-07-20 10:35:00 | AAPL | Stock | 25.0282 | 25.039 | 25.015 | 25.0375 | 977000.0 |
| 2016-07-20 10:40:00 | AAPL | Stock | 25.0375 | 25.0375 | 25.0025 | 25.004 | 1210080.0 |
| 2016-07-20 10:45:00 | AAPL | Stock | 25.0025 | 25.0175 | 24.9725 | 24.9748 | 1585548.0 |
| 2016-07-20 10:50:00 | AAPL | Stock | 24.9738 | 25.0038 | 24.9738 | 24.9975 | 1086384.0 |
| 2016-07-20 10:55:00 | AAPL | Stock | 24.9995 | 25.01 | 24.9975 | 24.999 | 758452.0 |
| 2016-07-20 11:00:00 | AAPL | Stock | 25.0 | 25.0125 | 24.98 | 24.99 | 1020620.0 |
| 2016-07-20 11:05:00 | AAPL | Stock | 24.9925 | 25.0 | 24.9825 | 24.984 | 811944.0 |
> showing 50 of 350,852 rows — these rows as CSV