PREVIEW / stock_5min / 2016-01-05
file: by_date/stock_5min/2016/2016-01-05.parquet size: 5.5 MB rows: 368,567 symbols: 3,382
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-01-05 04:00:00 | AAPL | Stock | 26.37 | 26.37 | 26.37 | 26.37 | 400.0 |
| 2016-01-05 04:25:00 | AAPL | Stock | 26.3175 | 26.3175 | 26.3175 | 26.3175 | 400.0 |
| 2016-01-05 04:30:00 | AAPL | Stock | 26.3175 | 26.3175 | 26.3175 | 26.3175 | 920.0 |
| 2016-01-05 04:35:00 | AAPL | Stock | 26.31 | 26.31 | 26.31 | 26.31 | 400.0 |
| 2016-01-05 04:45:00 | AAPL | Stock | 26.3175 | 26.3175 | 26.3175 | 26.3175 | 808.0 |
| 2016-01-05 04:50:00 | AAPL | Stock | 26.3175 | 26.32 | 26.3175 | 26.32 | 1368.0 |
| 2016-01-05 04:55:00 | AAPL | Stock | 26.32 | 26.32 | 26.32 | 26.32 | 400.0 |
| 2016-01-05 05:00:00 | AAPL | Stock | 26.3075 | 26.3075 | 26.2525 | 26.2525 | 4600.0 |
| 2016-01-05 05:05:00 | AAPL | Stock | 26.27 | 26.27 | 26.27 | 26.27 | 2000.0 |
| 2016-01-05 05:10:00 | AAPL | Stock | 26.32 | 26.32 | 26.27 | 26.27 | 2728.0 |
| 2016-01-05 05:15:00 | AAPL | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 400.0 |
| 2016-01-05 05:45:00 | AAPL | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 800.0 |
| 2016-01-05 05:55:00 | AAPL | Stock | 26.225 | 26.225 | 26.225 | 26.225 | 800.0 |
| 2016-01-05 06:20:00 | AAPL | Stock | 26.285 | 26.285 | 26.2375 | 26.2375 | 800.0 |
| 2016-01-05 06:35:00 | AAPL | Stock | 26.28 | 26.28 | 26.28 | 26.28 | 800.0 |
| 2016-01-05 06:40:00 | AAPL | Stock | 26.285 | 26.285 | 26.2625 | 26.2625 | 800.0 |
| 2016-01-05 07:00:00 | AAPL | Stock | 26.2625 | 26.32 | 26.2625 | 26.32 | 3940.0 |
| 2016-01-05 07:10:00 | AAPL | Stock | 26.2675 | 26.2675 | 26.2625 | 26.2625 | 14600.0 |
| 2016-01-05 07:15:00 | AAPL | Stock | 26.23 | 26.2375 | 26.225 | 26.23 | 17144.0 |
| 2016-01-05 07:20:00 | AAPL | Stock | 26.24 | 26.245 | 26.24 | 26.245 | 8000.0 |
| 2016-01-05 07:25:00 | AAPL | Stock | 26.25 | 26.2625 | 26.25 | 26.2625 | 2000.0 |
| 2016-01-05 07:30:00 | AAPL | Stock | 26.2525 | 26.2525 | 26.2175 | 26.2175 | 15480.0 |
| 2016-01-05 07:35:00 | AAPL | Stock | 26.2075 | 26.2075 | 26.185 | 26.1875 | 37148.0 |
| 2016-01-05 07:40:00 | AAPL | Stock | 26.1875 | 26.1875 | 26.175 | 26.1875 | 23728.0 |
| 2016-01-05 07:45:00 | AAPL | Stock | 26.1875 | 26.215 | 26.1875 | 26.215 | 3200.0 |
| 2016-01-05 07:50:00 | AAPL | Stock | 26.2125 | 26.2125 | 26.1975 | 26.2 | 4000.0 |
| 2016-01-05 07:55:00 | AAPL | Stock | 26.235 | 26.255 | 26.235 | 26.255 | 2800.0 |
| 2016-01-05 08:00:00 | AAPL | Stock | 26.2475 | 26.3 | 26.1875 | 26.2975 | 68012.0 |
| 2016-01-05 08:05:00 | AAPL | Stock | 26.2975 | 26.325 | 26.275 | 26.3025 | 34948.0 |
| 2016-01-05 08:10:00 | AAPL | Stock | 26.3025 | 26.3275 | 26.275 | 26.2875 | 33600.0 |
| 2016-01-05 08:15:00 | AAPL | Stock | 26.3 | 26.35 | 26.295 | 26.35 | 20296.0 |
| 2016-01-05 08:20:00 | AAPL | Stock | 26.35 | 26.37 | 26.325 | 26.325 | 51400.0 |
| 2016-01-05 08:25:00 | AAPL | Stock | 26.3125 | 26.345 | 26.3 | 26.3 | 38780.0 |
| 2016-01-05 08:30:00 | AAPL | Stock | 26.3275 | 26.34 | 26.325 | 26.34 | 14424.0 |
| 2016-01-05 08:35:00 | AAPL | Stock | 26.3375 | 26.36 | 26.315 | 26.3225 | 89052.0 |
| 2016-01-05 08:40:00 | AAPL | Stock | 26.325 | 26.3425 | 26.3 | 26.33 | 15908.0 |
| 2016-01-05 08:45:00 | AAPL | Stock | 26.3325 | 26.3325 | 26.295 | 26.295 | 38052.0 |
| 2016-01-05 08:50:00 | AAPL | Stock | 26.295 | 26.3625 | 26.2875 | 26.35 | 119008.0 |
| 2016-01-05 08:55:00 | AAPL | Stock | 26.3475 | 26.3625 | 26.325 | 26.3375 | 44756.0 |
| 2016-01-05 09:00:00 | AAPL | Stock | 26.35 | 26.35 | 26.28 | 26.28 | 66360.0 |
| 2016-01-05 09:05:00 | AAPL | Stock | 26.2925 | 26.3375 | 26.2925 | 26.3375 | 66464.0 |
| 2016-01-05 09:10:00 | AAPL | Stock | 26.3225 | 26.3225 | 26.3125 | 26.3125 | 12200.0 |
| 2016-01-05 09:15:00 | AAPL | Stock | 26.3225 | 26.3325 | 26.3175 | 26.3275 | 28436.0 |
| 2016-01-05 09:20:00 | AAPL | Stock | 26.3325 | 26.375 | 26.325 | 26.375 | 52996.0 |
| 2016-01-05 09:25:00 | AAPL | Stock | 26.3775 | 26.435 | 26.375 | 26.435 | 77336.0 |
| 2016-01-05 09:30:00 | AAPL | Stock | 26.4375 | 26.4625 | 26.1825 | 26.2275 | 6434520.0 |
| 2016-01-05 09:35:00 | AAPL | Stock | 26.2338 | 26.2675 | 26.095 | 26.15 | 3857156.0 |
| 2016-01-05 09:40:00 | AAPL | Stock | 26.15 | 26.2625 | 26.0925 | 26.2412 | 3652540.0 |
| 2016-01-05 09:45:00 | AAPL | Stock | 26.2412 | 26.2638 | 26.0975 | 26.0975 | 2984492.0 |
| 2016-01-05 09:50:00 | AAPL | Stock | 26.1 | 26.1225 | 26.025 | 26.0475 | 3175472.0 |
> showing 50 of 368,567 rows — these rows as CSV