PREVIEW / stock_5min / 2015-07-21
file: by_date/stock_5min/2015/2015-07-21.parquet size: 5.4 MB rows: 357,979 symbols: 3,470
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-07-21 04:00:00 | AAPL | Stock | 33.1875 | 33.1875 | 33.1825 | 33.1825 | 4400.0 |
| 2015-07-21 04:05:00 | AAPL | Stock | 33.1875 | 33.25 | 33.1875 | 33.25 | 8400.0 |
| 2015-07-21 04:15:00 | AAPL | Stock | 33.215 | 33.215 | 33.2 | 33.215 | 4000.0 |
| 2015-07-21 04:30:00 | AAPL | Stock | 33.215 | 33.2425 | 33.215 | 33.2425 | 2000.0 |
| 2015-07-21 04:35:00 | AAPL | Stock | 33.2475 | 33.2475 | 33.2475 | 33.2475 | 2000.0 |
| 2015-07-21 04:40:00 | AAPL | Stock | 33.245 | 33.245 | 33.245 | 33.245 | 4000.0 |
| 2015-07-21 04:50:00 | AAPL | Stock | 33.2475 | 33.2475 | 33.2475 | 33.2475 | 800.0 |
| 2015-07-21 05:00:00 | AAPL | Stock | 33.24 | 33.24 | 33.24 | 33.24 | 1096.0 |
| 2015-07-21 05:05:00 | AAPL | Stock | 33.225 | 33.225 | 33.2 | 33.2 | 4800.0 |
| 2015-07-21 05:15:00 | AAPL | Stock | 33.2 | 33.225 | 33.1975 | 33.225 | 6800.0 |
| 2015-07-21 05:20:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 3800.0 |
| 2015-07-21 05:25:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 4000.0 |
| 2015-07-21 05:30:00 | AAPL | Stock | 33.2125 | 33.2175 | 33.2125 | 33.2125 | 3960.0 |
| 2015-07-21 05:35:00 | AAPL | Stock | 33.22 | 33.22 | 33.2125 | 33.2125 | 8440.0 |
| 2015-07-21 05:45:00 | AAPL | Stock | 33.2 | 33.2 | 33.2 | 33.2 | 800.0 |
| 2015-07-21 05:50:00 | AAPL | Stock | 33.2 | 33.22 | 33.2 | 33.22 | 3500.0 |
| 2015-07-21 05:55:00 | AAPL | Stock | 33.2175 | 33.2175 | 33.2175 | 33.2175 | 1536.0 |
| 2015-07-21 06:00:00 | AAPL | Stock | 33.2075 | 33.2125 | 33.2075 | 33.2075 | 5460.0 |
| 2015-07-21 06:05:00 | AAPL | Stock | 33.22 | 33.225 | 33.22 | 33.225 | 18420.0 |
| 2015-07-21 06:10:00 | AAPL | Stock | 33.225 | 33.225 | 33.2175 | 33.225 | 20868.0 |
| 2015-07-21 06:15:00 | AAPL | Stock | 33.245 | 33.245 | 33.225 | 33.225 | 6324.0 |
| 2015-07-21 06:20:00 | AAPL | Stock | 33.225 | 33.25 | 33.225 | 33.25 | 11784.0 |
| 2015-07-21 06:30:00 | AAPL | Stock | 33.25 | 33.25 | 33.25 | 33.25 | 880.0 |
| 2015-07-21 06:35:00 | AAPL | Stock | 33.225 | 33.225 | 33.205 | 33.2125 | 20000.0 |
| 2015-07-21 06:40:00 | AAPL | Stock | 33.23 | 33.23 | 33.2175 | 33.2175 | 45240.0 |
| 2015-07-21 06:50:00 | AAPL | Stock | 33.225 | 33.2275 | 33.2175 | 33.2175 | 18000.0 |
| 2015-07-21 06:55:00 | AAPL | Stock | 33.2225 | 33.2225 | 33.215 | 33.215 | 40684.0 |
| 2015-07-21 07:00:00 | AAPL | Stock | 33.21 | 33.2875 | 33.21 | 33.2875 | 156696.0 |
| 2015-07-21 07:05:00 | AAPL | Stock | 33.2875 | 33.32 | 33.2825 | 33.32 | 68076.0 |
| 2015-07-21 07:10:00 | AAPL | Stock | 33.32 | 33.32 | 33.3075 | 33.3125 | 35264.0 |
| 2015-07-21 07:15:00 | AAPL | Stock | 33.31 | 33.315 | 33.2925 | 33.295 | 19504.0 |
| 2015-07-21 07:20:00 | AAPL | Stock | 33.3 | 33.3 | 33.25 | 33.2625 | 54968.0 |
| 2015-07-21 07:25:00 | AAPL | Stock | 33.265 | 33.2775 | 33.25 | 33.2625 | 30520.0 |
| 2015-07-21 07:30:00 | AAPL | Stock | 33.2675 | 33.2875 | 33.2675 | 33.2675 | 30212.0 |
| 2015-07-21 07:35:00 | AAPL | Stock | 33.2725 | 33.2725 | 33.225 | 33.225 | 95608.0 |
| 2015-07-21 07:40:00 | AAPL | Stock | 33.25 | 33.25 | 33.23 | 33.2375 | 28096.0 |
| 2015-07-21 07:45:00 | AAPL | Stock | 33.2375 | 33.25 | 33.2125 | 33.2375 | 58380.0 |
| 2015-07-21 07:50:00 | AAPL | Stock | 33.2325 | 33.2375 | 33.21 | 33.225 | 66324.0 |
| 2015-07-21 07:55:00 | AAPL | Stock | 33.22 | 33.2625 | 33.215 | 33.2625 | 29656.0 |
| 2015-07-21 08:00:00 | AAPL | Stock | 33.26 | 33.3175 | 33.2175 | 33.2725 | 525988.0 |
| 2015-07-21 08:05:00 | AAPL | Stock | 33.27 | 33.29 | 33.265 | 33.2875 | 139828.0 |
| 2015-07-21 08:10:00 | AAPL | Stock | 33.29 | 33.295 | 33.2875 | 33.295 | 105856.0 |
| 2015-07-21 08:15:00 | AAPL | Stock | 33.2875 | 33.295 | 33.2675 | 33.275 | 70116.0 |
| 2015-07-21 08:20:00 | AAPL | Stock | 33.27 | 33.2875 | 33.2625 | 33.265 | 78304.0 |
| 2015-07-21 08:25:00 | AAPL | Stock | 33.2625 | 33.2675 | 33.225 | 33.2343 | 161404.0 |
| 2015-07-21 08:30:00 | AAPL | Stock | 33.235 | 33.2625 | 33.2325 | 33.255 | 82340.0 |
| 2015-07-21 08:35:00 | AAPL | Stock | 33.255 | 33.255 | 33.2375 | 33.2442 | 62636.0 |
| 2015-07-21 08:40:00 | AAPL | Stock | 33.245 | 33.245 | 33.2125 | 33.2175 | 107320.0 |
| 2015-07-21 08:45:00 | AAPL | Stock | 33.22 | 33.235 | 33.2125 | 33.23 | 102776.0 |
| 2015-07-21 08:50:00 | AAPL | Stock | 33.2275 | 33.23 | 33.2075 | 33.2075 | 87680.0 |
> showing 50 of 357,979 rows — these rows as CSV