PREVIEW / stock_5min / 2014-10-17
file: by_date/stock_5min/2014/2014-10-17.parquet size: 5.6 MB rows: 369,236 symbols: 3,557
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-10-17 04:00:00 | AAPL | Stock | 24.185 | 24.2225 | 24.1375 | 24.2225 | 5616.0 |
| 2014-10-17 04:10:00 | AAPL | Stock | 24.2625 | 24.2625 | 24.2625 | 24.2625 | 1600.0 |
| 2014-10-17 04:15:00 | AAPL | Stock | 24.295 | 24.295 | 24.295 | 24.295 | 2000.0 |
| 2014-10-17 04:20:00 | AAPL | Stock | 24.295 | 24.295 | 24.2925 | 24.2925 | 2800.0 |
| 2014-10-17 04:25:00 | AAPL | Stock | 24.295 | 24.3 | 24.295 | 24.3 | 1640.0 |
| 2014-10-17 04:35:00 | AAPL | Stock | 24.3225 | 24.3225 | 24.3025 | 24.32 | 1200.0 |
| 2014-10-17 04:40:00 | AAPL | Stock | 24.3 | 24.3 | 24.3 | 24.3 | 4800.0 |
| 2014-10-17 04:45:00 | AAPL | Stock | 24.3 | 24.3 | 24.3 | 24.3 | 3200.0 |
| 2014-10-17 04:55:00 | AAPL | Stock | 24.32 | 24.325 | 24.32 | 24.325 | 15976.0 |
| 2014-10-17 05:00:00 | AAPL | Stock | 24.33 | 24.33 | 24.33 | 24.33 | 400.0 |
| 2014-10-17 05:05:00 | AAPL | Stock | 24.33 | 24.33 | 24.3225 | 24.3225 | 1600.0 |
| 2014-10-17 05:20:00 | AAPL | Stock | 24.3475 | 24.3475 | 24.3475 | 24.3475 | 4760.0 |
| 2014-10-17 05:30:00 | AAPL | Stock | 24.37 | 24.37 | 24.3675 | 24.3675 | 2000.0 |
| 2014-10-17 05:35:00 | AAPL | Stock | 24.3675 | 24.37 | 24.355 | 24.37 | 3860.0 |
| 2014-10-17 05:40:00 | AAPL | Stock | 24.37 | 24.3975 | 24.37 | 24.3975 | 4692.0 |
| 2014-10-17 06:00:00 | AAPL | Stock | 24.3975 | 24.4 | 24.3975 | 24.4 | 5688.0 |
| 2014-10-17 06:05:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 3200.0 |
| 2014-10-17 06:10:00 | AAPL | Stock | 24.4125 | 24.4175 | 24.4125 | 24.4175 | 5200.0 |
| 2014-10-17 06:15:00 | AAPL | Stock | 24.42 | 24.42 | 24.35 | 24.35 | 42396.0 |
| 2014-10-17 06:20:00 | AAPL | Stock | 24.4125 | 24.415 | 24.4125 | 24.415 | 20080.0 |
| 2014-10-17 06:25:00 | AAPL | Stock | 24.3775 | 24.4225 | 24.375 | 24.4225 | 4808.0 |
| 2014-10-17 06:30:00 | AAPL | Stock | 24.42 | 24.42 | 24.405 | 24.405 | 7884.0 |
| 2014-10-17 06:35:00 | AAPL | Stock | 24.42 | 24.42 | 24.3775 | 24.3775 | 8600.0 |
| 2014-10-17 06:40:00 | AAPL | Stock | 24.4 | 24.4 | 24.3775 | 24.3775 | 21600.0 |
| 2014-10-17 06:45:00 | AAPL | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 3400.0 |
| 2014-10-17 06:50:00 | AAPL | Stock | 24.3775 | 24.3775 | 24.3575 | 24.3575 | 9004.0 |
| 2014-10-17 06:55:00 | AAPL | Stock | 24.3575 | 24.38 | 24.3575 | 24.38 | 3788.0 |
| 2014-10-17 07:00:00 | AAPL | Stock | 24.38 | 24.38 | 24.3425 | 24.3425 | 32872.0 |
| 2014-10-17 07:05:00 | AAPL | Stock | 24.35 | 24.35 | 24.3225 | 24.33 | 18468.0 |
| 2014-10-17 07:10:00 | AAPL | Stock | 24.3275 | 24.33 | 24.31 | 24.3125 | 53720.0 |
| 2014-10-17 07:15:00 | AAPL | Stock | 24.3025 | 24.3275 | 24.3 | 24.3275 | 35356.0 |
| 2014-10-17 07:20:00 | AAPL | Stock | 24.335 | 24.335 | 24.325 | 24.335 | 17680.0 |
| 2014-10-17 07:25:00 | AAPL | Stock | 24.345 | 24.345 | 24.3375 | 24.34 | 15476.0 |
| 2014-10-17 07:30:00 | AAPL | Stock | 24.34 | 24.35 | 24.3275 | 24.3475 | 26928.0 |
| 2014-10-17 07:35:00 | AAPL | Stock | 24.3375 | 24.35 | 24.3325 | 24.3475 | 8320.0 |
| 2014-10-17 07:40:00 | AAPL | Stock | 24.35 | 24.3525 | 24.3375 | 24.35 | 20616.0 |
| 2014-10-17 07:45:00 | AAPL | Stock | 24.3525 | 24.3525 | 24.3375 | 24.3375 | 29988.0 |
| 2014-10-17 07:50:00 | AAPL | Stock | 24.3375 | 24.3475 | 24.325 | 24.3475 | 37352.0 |
| 2014-10-17 07:55:00 | AAPL | Stock | 24.345 | 24.345 | 24.3325 | 24.3325 | 2600.0 |
| 2014-10-17 08:00:00 | AAPL | Stock | 24.33 | 24.415 | 24.3125 | 24.41 | 376396.0 |
| 2014-10-17 08:05:00 | AAPL | Stock | 24.41 | 24.4125 | 24.35 | 24.35 | 99364.0 |
| 2014-10-17 08:10:00 | AAPL | Stock | 24.36 | 24.3625 | 24.325 | 24.325 | 94956.0 |
| 2014-10-17 08:15:00 | AAPL | Stock | 24.3475 | 24.35 | 24.3375 | 24.35 | 21352.0 |
| 2014-10-17 08:20:00 | AAPL | Stock | 24.3475 | 24.35 | 24.33 | 24.3425 | 78124.0 |
| 2014-10-17 08:25:00 | AAPL | Stock | 24.36 | 24.3625 | 24.3425 | 24.3625 | 72608.0 |
| 2014-10-17 08:30:00 | AAPL | Stock | 24.3725 | 24.3875 | 24.3525 | 24.3875 | 116548.0 |
| 2014-10-17 08:35:00 | AAPL | Stock | 24.3875 | 24.4025 | 24.3595 | 24.3875 | 174908.0 |
| 2014-10-17 08:40:00 | AAPL | Stock | 24.3975 | 24.4 | 24.375 | 24.3775 | 68744.0 |
| 2014-10-17 08:45:00 | AAPL | Stock | 24.3775 | 24.38 | 24.3625 | 24.3625 | 67072.0 |
| 2014-10-17 08:50:00 | AAPL | Stock | 24.375 | 24.395 | 24.3625 | 24.39 | 46352.0 |
> showing 50 of 369,236 rows — these rows as CSV