PREVIEW / stock_5min / 2014-11-12
file: by_date/stock_5min/2014/2014-11-12.parquet size: 5.4 MB rows: 356,438 symbols: 3,549
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-12 04:00:00 | AAPL | Stock | 27.35 | 27.35 | 27.33 | 27.33 | 2660.0 |
| 2014-11-12 04:15:00 | AAPL | Stock | 27.33 | 27.3375 | 27.33 | 27.3375 | 4540.0 |
| 2014-11-12 04:25:00 | AAPL | Stock | 27.3975 | 27.3975 | 27.3975 | 27.3975 | 3200.0 |
| 2014-11-12 04:35:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3375 | 27.3375 | 1200.0 |
| 2014-11-12 04:40:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3375 | 27.3375 | 400.0 |
| 2014-11-12 05:05:00 | AAPL | Stock | 27.3225 | 27.335 | 27.3225 | 27.335 | 7200.0 |
| 2014-11-12 05:30:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3625 | 27.3625 | 2000.0 |
| 2014-11-12 05:35:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3625 | 27.3625 | 2000.0 |
| 2014-11-12 05:40:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 400.0 |
| 2014-11-12 05:45:00 | AAPL | Stock | 27.3075 | 27.35 | 27.3075 | 27.35 | 1600.0 |
| 2014-11-12 05:55:00 | AAPL | Stock | 27.375 | 27.375 | 27.375 | 27.375 | 800.0 |
| 2014-11-12 06:00:00 | AAPL | Stock | 27.35 | 27.375 | 27.35 | 27.35 | 2880.0 |
| 2014-11-12 06:05:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 800.0 |
| 2014-11-12 06:35:00 | AAPL | Stock | 27.315 | 27.315 | 27.31 | 27.31 | 1200.0 |
| 2014-11-12 06:40:00 | AAPL | Stock | 27.31 | 27.31 | 27.3075 | 27.31 | 2800.0 |
| 2014-11-12 06:50:00 | AAPL | Stock | 27.315 | 27.315 | 27.3125 | 27.3125 | 6400.0 |
| 2014-11-12 06:55:00 | AAPL | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 400.0 |
| 2014-11-12 07:00:00 | AAPL | Stock | 27.3325 | 27.345 | 27.3325 | 27.34 | 4000.0 |
| 2014-11-12 07:05:00 | AAPL | Stock | 27.35 | 27.35 | 27.335 | 27.3425 | 18584.0 |
| 2014-11-12 07:10:00 | AAPL | Stock | 27.345 | 27.345 | 27.3375 | 27.3375 | 7584.0 |
| 2014-11-12 07:15:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3375 | 27.3375 | 816.0 |
| 2014-11-12 07:20:00 | AAPL | Stock | 27.3375 | 27.35 | 27.3375 | 27.35 | 3200.0 |
| 2014-11-12 07:25:00 | AAPL | Stock | 27.34 | 27.34 | 27.34 | 27.34 | 4080.0 |
| 2014-11-12 07:30:00 | AAPL | Stock | 27.34 | 27.34 | 27.3375 | 27.3375 | 4940.0 |
| 2014-11-12 07:35:00 | AAPL | Stock | 27.34 | 27.34 | 27.3375 | 27.3375 | 7672.0 |
| 2014-11-12 07:40:00 | AAPL | Stock | 27.3475 | 27.35 | 27.3475 | 27.35 | 2800.0 |
| 2014-11-12 07:50:00 | AAPL | Stock | 27.35 | 27.3625 | 27.35 | 27.3625 | 9800.0 |
| 2014-11-12 07:55:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 400.0 |
| 2014-11-12 08:00:00 | AAPL | Stock | 27.3575 | 27.3675 | 27.325 | 27.3625 | 106332.0 |
| 2014-11-12 08:05:00 | AAPL | Stock | 27.2075 | 27.355 | 27.2075 | 27.3375 | 68708.0 |
| 2014-11-12 08:10:00 | AAPL | Stock | 27.3425 | 27.3675 | 27.34 | 27.3675 | 26432.0 |
| 2014-11-12 08:15:00 | AAPL | Stock | 27.3675 | 27.3675 | 27.355 | 27.355 | 6800.0 |
| 2014-11-12 08:20:00 | AAPL | Stock | 27.355 | 27.3625 | 27.3525 | 27.3625 | 20128.0 |
| 2014-11-12 08:25:00 | AAPL | Stock | 27.3525 | 27.3525 | 27.345 | 27.35 | 35436.0 |
| 2014-11-12 08:30:00 | AAPL | Stock | 27.345 | 27.35 | 27.3325 | 27.345 | 25840.0 |
| 2014-11-12 08:35:00 | AAPL | Stock | 27.345 | 27.35 | 27.345 | 27.35 | 23664.0 |
| 2014-11-12 08:40:00 | AAPL | Stock | 27.35 | 27.35 | 27.3425 | 27.3425 | 7600.0 |
| 2014-11-12 08:45:00 | AAPL | Stock | 27.35 | 27.35 | 27.3425 | 27.345 | 25640.0 |
| 2014-11-12 08:50:00 | AAPL | Stock | 27.345 | 27.3475 | 27.34 | 27.3425 | 20140.0 |
| 2014-11-12 08:55:00 | AAPL | Stock | 27.3425 | 27.3425 | 27.3375 | 27.3425 | 12672.0 |
| 2014-11-12 09:00:00 | AAPL | Stock | 27.3375 | 27.345 | 27.3375 | 27.345 | 20504.0 |
| 2014-11-12 09:05:00 | AAPL | Stock | 27.345 | 27.345 | 27.3425 | 27.345 | 11504.0 |
| 2014-11-12 09:10:00 | AAPL | Stock | 27.34 | 27.345 | 27.34 | 27.345 | 12500.0 |
| 2014-11-12 09:15:00 | AAPL | Stock | 27.34 | 27.3475 | 27.34 | 27.345 | 4516.0 |
| 2014-11-12 09:20:00 | AAPL | Stock | 27.3475 | 27.3475 | 27.34 | 27.34 | 14136.0 |
| 2014-11-12 09:25:00 | AAPL | Stock | 27.3425 | 27.3575 | 27.3375 | 27.355 | 67552.0 |
| 2014-11-12 09:30:00 | AAPL | Stock | 27.345 | 27.475 | 27.3425 | 27.46 | 6680292.0 |
| 2014-11-12 09:35:00 | AAPL | Stock | 27.4575 | 27.5625 | 27.45 | 27.5575 | 10246844.0 |
| 2014-11-12 09:40:00 | AAPL | Stock | 27.555 | 27.6075 | 27.5225 | 27.5825 | 6414912.0 |
| 2014-11-12 09:45:00 | AAPL | Stock | 27.5825 | 27.6175 | 27.5375 | 27.5775 | 4141792.0 |
> showing 50 of 356,438 rows — these rows as CSV