PREVIEW / stock_5min / 2017-05-08
file: by_date/stock_5min/2017/2017-05-08.parquet size: 5.4 MB rows: 353,061 symbols: 3,043
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-08 04:05:00 | AAPL | Stock | 37.295 | 37.295 | 37.295 | 37.295 | 1600.0 |
| 2017-05-08 04:10:00 | AAPL | Stock | 37.2475 | 37.2475 | 37.2475 | 37.2475 | 532.0 |
| 2017-05-08 04:40:00 | AAPL | Stock | 37.255 | 37.255 | 37.255 | 37.255 | 800.0 |
| 2017-05-08 04:50:00 | AAPL | Stock | 37.25 | 37.25 | 37.25 | 37.25 | 400.0 |
| 2017-05-08 04:55:00 | AAPL | Stock | 37.25 | 37.25 | 37.25 | 37.25 | 1200.0 |
| 2017-05-08 06:25:00 | AAPL | Stock | 37.24 | 37.24 | 37.24 | 37.24 | 1200.0 |
| 2017-05-08 06:30:00 | AAPL | Stock | 37.2475 | 37.2475 | 37.2475 | 37.2475 | 800.0 |
| 2017-05-08 06:40:00 | AAPL | Stock | 37.2625 | 37.2925 | 37.2625 | 37.2925 | 1200.0 |
| 2017-05-08 06:45:00 | AAPL | Stock | 37.2925 | 37.335 | 37.2925 | 37.335 | 6400.0 |
| 2017-05-08 06:50:00 | AAPL | Stock | 37.3225 | 37.3225 | 37.3225 | 37.3225 | 760.0 |
| 2017-05-08 06:55:00 | AAPL | Stock | 37.3325 | 37.335 | 37.3325 | 37.335 | 3600.0 |
| 2017-05-08 07:00:00 | AAPL | Stock | 37.33 | 37.3325 | 37.3125 | 37.3125 | 10440.0 |
| 2017-05-08 07:05:00 | AAPL | Stock | 37.3075 | 37.3075 | 37.3075 | 37.3075 | 7600.0 |
| 2017-05-08 07:10:00 | AAPL | Stock | 37.3125 | 37.35 | 37.3125 | 37.3425 | 25708.0 |
| 2017-05-08 07:15:00 | AAPL | Stock | 37.3425 | 37.375 | 37.3325 | 37.3475 | 28940.0 |
| 2017-05-08 07:20:00 | AAPL | Stock | 37.3375 | 37.3475 | 37.3275 | 37.3275 | 33812.0 |
| 2017-05-08 07:25:00 | AAPL | Stock | 37.33 | 37.33 | 37.32 | 37.3275 | 7916.0 |
| 2017-05-08 07:30:00 | AAPL | Stock | 37.3275 | 37.3375 | 37.3275 | 37.3375 | 3400.0 |
| 2017-05-08 07:35:00 | AAPL | Stock | 37.3425 | 37.3425 | 37.32 | 37.32 | 7620.0 |
| 2017-05-08 07:40:00 | AAPL | Stock | 37.335 | 37.34 | 37.33 | 37.33 | 8120.0 |
| 2017-05-08 07:45:00 | AAPL | Stock | 37.33 | 37.33 | 37.3 | 37.3125 | 32224.0 |
| 2017-05-08 07:50:00 | AAPL | Stock | 37.305 | 37.305 | 37.2875 | 37.2875 | 16836.0 |
| 2017-05-08 07:55:00 | AAPL | Stock | 37.295 | 37.295 | 37.2875 | 37.2875 | 16400.0 |
| 2017-05-08 08:00:00 | AAPL | Stock | 37.2475 | 37.345 | 37.2475 | 37.275 | 73188.0 |
| 2017-05-08 08:05:00 | AAPL | Stock | 37.275 | 37.275 | 37.235 | 37.24 | 38236.0 |
| 2017-05-08 08:10:00 | AAPL | Stock | 37.24 | 37.24 | 37.21 | 37.2225 | 103708.0 |
| 2017-05-08 08:15:00 | AAPL | Stock | 37.2225 | 37.225 | 37.2 | 37.225 | 53836.0 |
| 2017-05-08 08:20:00 | AAPL | Stock | 37.225 | 37.225 | 37.215 | 37.2225 | 28616.0 |
| 2017-05-08 08:25:00 | AAPL | Stock | 37.2225 | 37.2225 | 37.2175 | 37.2225 | 46356.0 |
| 2017-05-08 08:30:00 | AAPL | Stock | 37.22 | 37.2625 | 37.215 | 37.2625 | 108504.0 |
| 2017-05-08 08:35:00 | AAPL | Stock | 37.245 | 37.2825 | 37.245 | 37.2825 | 20724.0 |
| 2017-05-08 08:40:00 | AAPL | Stock | 37.28 | 37.295 | 37.27 | 37.2725 | 117576.0 |
| 2017-05-08 08:45:00 | AAPL | Stock | 37.2675 | 37.2775 | 37.2525 | 37.27 | 152496.0 |
| 2017-05-08 08:50:00 | AAPL | Stock | 37.275 | 37.275 | 37.2725 | 37.2725 | 35400.0 |
| 2017-05-08 08:55:00 | AAPL | Stock | 37.2675 | 37.275 | 37.2675 | 37.275 | 8968.0 |
| 2017-05-08 09:00:00 | AAPL | Stock | 37.275 | 37.28 | 37.27 | 37.275 | 32976.0 |
| 2017-05-08 09:05:00 | AAPL | Stock | 37.275 | 37.2875 | 37.27 | 37.275 | 35372.0 |
| 2017-05-08 09:10:00 | AAPL | Stock | 37.2875 | 37.2875 | 37.275 | 37.275 | 7440.0 |
| 2017-05-08 09:15:00 | AAPL | Stock | 37.2725 | 37.28 | 37.2675 | 37.2675 | 14892.0 |
| 2017-05-08 09:20:00 | AAPL | Stock | 37.2725 | 37.2775 | 37.265 | 37.2675 | 20904.0 |
| 2017-05-08 09:25:00 | AAPL | Stock | 37.2775 | 37.2825 | 37.2575 | 37.26 | 88900.0 |
| 2017-05-08 09:30:00 | AAPL | Stock | 37.2575 | 37.46 | 37.2575 | 37.46 | 7592308.0 |
| 2017-05-08 09:35:00 | AAPL | Stock | 37.46 | 37.55 | 37.43 | 37.4375 | 8098724.0 |
| 2017-05-08 09:40:00 | AAPL | Stock | 37.44 | 37.595 | 37.4375 | 37.5925 | 3963872.0 |
| 2017-05-08 09:45:00 | AAPL | Stock | 37.5925 | 37.6675 | 37.5875 | 37.645 | 3109480.0 |
| 2017-05-08 09:50:00 | AAPL | Stock | 37.6475 | 37.7125 | 37.5975 | 37.5975 | 4330960.0 |
| 2017-05-08 09:55:00 | AAPL | Stock | 37.6 | 37.655 | 37.595 | 37.6175 | 2132212.0 |
| 2017-05-08 10:00:00 | AAPL | Stock | 37.615 | 37.63 | 37.5775 | 37.59 | 1824280.0 |
| 2017-05-08 10:05:00 | AAPL | Stock | 37.5875 | 37.665 | 37.5625 | 37.6638 | 2122340.0 |
| 2017-05-08 10:10:00 | AAPL | Stock | 37.6625 | 37.7175 | 37.64 | 37.6875 | 2718116.0 |
> showing 50 of 353,061 rows — these rows as CSV