PREVIEW / stock_5min / 2016-06-16
file: by_date/stock_5min/2016/2016-06-16.parquet size: 5.4 MB rows: 359,008 symbols: 3,284
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-06-16 04:00:00 | AAPL | Stock | 24.285 | 24.285 | 24.1725 | 24.175 | 9200.0 |
| 2016-06-16 04:10:00 | AAPL | Stock | 24.075 | 24.075 | 24.075 | 24.075 | 568.0 |
| 2016-06-16 04:40:00 | AAPL | Stock | 24.0375 | 24.0375 | 24.0375 | 24.0375 | 3600.0 |
| 2016-06-16 04:50:00 | AAPL | Stock | 24.0375 | 24.04 | 24.025 | 24.04 | 7476.0 |
| 2016-06-16 04:55:00 | AAPL | Stock | 24.0375 | 24.0375 | 24.0375 | 24.0375 | 4200.0 |
| 2016-06-16 05:30:00 | AAPL | Stock | 24.0725 | 24.0725 | 24.0725 | 24.0725 | 2000.0 |
| 2016-06-16 05:35:00 | AAPL | Stock | 24.11 | 24.11 | 24.11 | 24.11 | 600.0 |
| 2016-06-16 05:55:00 | AAPL | Stock | 24.11 | 24.11 | 24.11 | 24.11 | 7260.0 |
| 2016-06-16 06:05:00 | AAPL | Stock | 24.12 | 24.12 | 24.075 | 24.075 | 4004.0 |
| 2016-06-16 06:10:00 | AAPL | Stock | 24.0875 | 24.11 | 24.0875 | 24.11 | 5200.0 |
| 2016-06-16 06:20:00 | AAPL | Stock | 24.085 | 24.085 | 24.075 | 24.075 | 1660.0 |
| 2016-06-16 06:30:00 | AAPL | Stock | 24.1225 | 24.1225 | 24.1075 | 24.1075 | 5160.0 |
| 2016-06-16 06:35:00 | AAPL | Stock | 24.11 | 24.1375 | 24.1075 | 24.1375 | 5416.0 |
| 2016-06-16 06:45:00 | AAPL | Stock | 24.1225 | 24.1225 | 24.1225 | 24.1225 | 1120.0 |
| 2016-06-16 06:50:00 | AAPL | Stock | 24.1225 | 24.1225 | 24.1225 | 24.1225 | 2800.0 |
| 2016-06-16 07:00:00 | AAPL | Stock | 24.1475 | 24.1475 | 24.135 | 24.135 | 5844.0 |
| 2016-06-16 07:05:00 | AAPL | Stock | 24.135 | 24.135 | 24.1325 | 24.1325 | 3200.0 |
| 2016-06-16 07:10:00 | AAPL | Stock | 24.125 | 24.125 | 24.0875 | 24.0875 | 14584.0 |
| 2016-06-16 07:15:00 | AAPL | Stock | 24.11 | 24.1225 | 24.1 | 24.1 | 3600.0 |
| 2016-06-16 07:20:00 | AAPL | Stock | 24.0975 | 24.11 | 24.0975 | 24.11 | 2676.0 |
| 2016-06-16 07:25:00 | AAPL | Stock | 24.1025 | 24.1025 | 24.0925 | 24.0925 | 21204.0 |
| 2016-06-16 07:30:00 | AAPL | Stock | 24.0875 | 24.0875 | 24.0875 | 24.0875 | 2800.0 |
| 2016-06-16 07:35:00 | AAPL | Stock | 24.095 | 24.1 | 24.075 | 24.1 | 10656.0 |
| 2016-06-16 07:40:00 | AAPL | Stock | 24.1 | 24.105 | 24.075 | 24.1 | 13844.0 |
| 2016-06-16 07:45:00 | AAPL | Stock | 24.0975 | 24.0975 | 24.0975 | 24.0975 | 2000.0 |
| 2016-06-16 07:50:00 | AAPL | Stock | 24.0875 | 24.0875 | 24.08 | 24.08 | 17200.0 |
| 2016-06-16 07:55:00 | AAPL | Stock | 24.0775 | 24.0875 | 24.075 | 24.085 | 8400.0 |
| 2016-06-16 08:00:00 | AAPL | Stock | 24.145 | 24.145 | 24.08 | 24.0975 | 54896.0 |
| 2016-06-16 08:05:00 | AAPL | Stock | 24.1 | 24.1175 | 24.0975 | 24.1175 | 17560.0 |
| 2016-06-16 08:10:00 | AAPL | Stock | 24.1175 | 24.1225 | 24.11 | 24.115 | 36608.0 |
| 2016-06-16 08:15:00 | AAPL | Stock | 24.11 | 24.1125 | 24.0925 | 24.1 | 57464.0 |
| 2016-06-16 08:20:00 | AAPL | Stock | 24.0875 | 24.1 | 24.0875 | 24.1 | 30604.0 |
| 2016-06-16 08:25:00 | AAPL | Stock | 24.0925 | 24.105 | 24.075 | 24.075 | 54388.0 |
| 2016-06-16 08:30:00 | AAPL | Stock | 24.0825 | 24.0875 | 24.075 | 24.0825 | 72860.0 |
| 2016-06-16 08:35:00 | AAPL | Stock | 24.0825 | 24.1025 | 24.08 | 24.0825 | 19100.0 |
| 2016-06-16 08:40:00 | AAPL | Stock | 24.0825 | 24.0925 | 24.075 | 24.075 | 28404.0 |
| 2016-06-16 08:45:00 | AAPL | Stock | 24.08 | 24.0875 | 24.075 | 24.075 | 38928.0 |
| 2016-06-16 08:50:00 | AAPL | Stock | 24.0775 | 24.1 | 24.0775 | 24.0875 | 12600.0 |
| 2016-06-16 08:55:00 | AAPL | Stock | 24.0875 | 24.09 | 24.075 | 24.08 | 17660.0 |
| 2016-06-16 09:00:00 | AAPL | Stock | 24.075 | 24.085 | 24.075 | 24.0825 | 16860.0 |
| 2016-06-16 09:05:00 | AAPL | Stock | 24.085 | 24.085 | 24.0775 | 24.085 | 7560.0 |
| 2016-06-16 09:10:00 | AAPL | Stock | 24.0875 | 24.0875 | 24.075 | 24.08 | 161472.0 |
| 2016-06-16 09:15:00 | AAPL | Stock | 24.08 | 24.09 | 24.08 | 24.09 | 17500.0 |
| 2016-06-16 09:20:00 | AAPL | Stock | 24.095 | 24.12 | 24.09 | 24.1025 | 42388.0 |
| 2016-06-16 09:25:00 | AAPL | Stock | 24.1 | 24.1225 | 24.0925 | 24.1075 | 68796.0 |
| 2016-06-16 09:30:00 | AAPL | Stock | 24.11 | 24.1792 | 24.0675 | 24.1258 | 5266672.0 |
| 2016-06-16 09:35:00 | AAPL | Stock | 24.1275 | 24.13 | 24.08 | 24.113 | 2641484.0 |
| 2016-06-16 09:40:00 | AAPL | Stock | 24.1125 | 24.135 | 24.0825 | 24.0875 | 2040808.0 |
| 2016-06-16 09:45:00 | AAPL | Stock | 24.0875 | 24.125 | 24.05 | 24.1225 | 3086136.0 |
| 2016-06-16 09:50:00 | AAPL | Stock | 24.1225 | 24.135 | 24.1 | 24.1175 | 1830940.0 |
> showing 50 of 359,008 rows — these rows as CSV