PREVIEW / stock_5min / 2017-05-25
file: by_date/stock_5min/2017/2017-05-25.parquet size: 5.4 MB rows: 349,254 symbols: 3,037
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-25 04:40:00 | AAPL | Stock | 38.3575 | 38.3575 | 38.3575 | 38.3575 | 400.0 |
| 2017-05-25 05:00:00 | AAPL | Stock | 38.3925 | 38.3925 | 38.3925 | 38.3925 | 1200.0 |
| 2017-05-25 05:05:00 | AAPL | Stock | 38.395 | 38.395 | 38.395 | 38.395 | 1544.0 |
| 2017-05-25 05:25:00 | AAPL | Stock | 38.3975 | 38.3975 | 38.3975 | 38.3975 | 800.0 |
| 2017-05-25 05:35:00 | AAPL | Stock | 38.41 | 38.4125 | 38.41 | 38.4125 | 800.0 |
| 2017-05-25 06:05:00 | AAPL | Stock | 38.4025 | 38.4025 | 38.3875 | 38.3875 | 2400.0 |
| 2017-05-25 06:15:00 | AAPL | Stock | 38.4125 | 38.4125 | 38.4125 | 38.4125 | 480.0 |
| 2017-05-25 06:20:00 | AAPL | Stock | 38.4125 | 38.4225 | 38.4125 | 38.4225 | 1704.0 |
| 2017-05-25 06:40:00 | AAPL | Stock | 38.4325 | 38.44 | 38.4325 | 38.44 | 2000.0 |
| 2017-05-25 06:45:00 | AAPL | Stock | 38.4425 | 38.4425 | 38.3875 | 38.3975 | 25136.0 |
| 2017-05-25 06:50:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 2600.0 |
| 2017-05-25 07:00:00 | AAPL | Stock | 38.4125 | 38.435 | 38.4125 | 38.435 | 13012.0 |
| 2017-05-25 07:05:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 2000.0 |
| 2017-05-25 07:10:00 | AAPL | Stock | 38.42 | 38.4425 | 38.42 | 38.4225 | 7356.0 |
| 2017-05-25 07:15:00 | AAPL | Stock | 38.425 | 38.4425 | 38.425 | 38.4425 | 6328.0 |
| 2017-05-25 07:20:00 | AAPL | Stock | 38.4425 | 38.4525 | 38.4175 | 38.4175 | 17216.0 |
| 2017-05-25 07:25:00 | AAPL | Stock | 38.45 | 38.45 | 38.375 | 38.4275 | 17200.0 |
| 2017-05-25 07:30:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 664.0 |
| 2017-05-25 07:35:00 | AAPL | Stock | 38.425 | 38.425 | 38.4125 | 38.4125 | 800.0 |
| 2017-05-25 07:40:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 2492.0 |
| 2017-05-25 07:45:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.43 | 38.43 | 800.0 |
| 2017-05-25 07:50:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 400.0 |
| 2017-05-25 07:55:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 400.0 |
| 2017-05-25 08:00:00 | AAPL | Stock | 38.4375 | 38.4425 | 38.4 | 38.4125 | 43420.0 |
| 2017-05-25 08:05:00 | AAPL | Stock | 38.42 | 38.42 | 38.405 | 38.405 | 18740.0 |
| 2017-05-25 08:10:00 | AAPL | Stock | 38.4075 | 38.4075 | 38.4075 | 38.4075 | 1200.0 |
| 2017-05-25 08:15:00 | AAPL | Stock | 38.405 | 38.415 | 38.4025 | 38.415 | 16696.0 |
| 2017-05-25 08:20:00 | AAPL | Stock | 38.415 | 38.425 | 38.415 | 38.425 | 14744.0 |
| 2017-05-25 08:25:00 | AAPL | Stock | 38.43 | 38.435 | 38.43 | 38.435 | 2220.0 |
| 2017-05-25 08:30:00 | AAPL | Stock | 38.4375 | 38.4425 | 38.425 | 38.4375 | 33932.0 |
| 2017-05-25 08:35:00 | AAPL | Stock | 38.4425 | 38.4675 | 38.4425 | 38.4675 | 59964.0 |
| 2017-05-25 08:40:00 | AAPL | Stock | 38.4675 | 38.47 | 38.46 | 38.47 | 22640.0 |
| 2017-05-25 08:45:00 | AAPL | Stock | 38.47 | 38.475 | 38.4525 | 38.46 | 29988.0 |
| 2017-05-25 08:50:00 | AAPL | Stock | 38.4625 | 38.475 | 38.4625 | 38.47 | 16696.0 |
| 2017-05-25 08:55:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4425 | 38.4425 | 23768.0 |
| 2017-05-25 09:00:00 | AAPL | Stock | 38.4475 | 38.4475 | 38.425 | 38.425 | 16084.0 |
| 2017-05-25 09:05:00 | AAPL | Stock | 38.415 | 38.415 | 38.3825 | 38.3875 | 44120.0 |
| 2017-05-25 09:10:00 | AAPL | Stock | 38.375 | 38.41 | 38.375 | 38.41 | 81920.0 |
| 2017-05-25 09:15:00 | AAPL | Stock | 38.41 | 38.41 | 38.3925 | 38.4 | 13180.0 |
| 2017-05-25 09:20:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 6508.0 |
| 2017-05-25 09:25:00 | AAPL | Stock | 38.4 | 38.4375 | 38.4 | 38.4375 | 7836.0 |
| 2017-05-25 09:30:00 | AAPL | Stock | 38.4325 | 38.4675 | 38.2625 | 38.2925 | 3189548.0 |
| 2017-05-25 09:35:00 | AAPL | Stock | 38.2945 | 38.4175 | 38.2875 | 38.3415 | 2200448.0 |
| 2017-05-25 09:40:00 | AAPL | Stock | 38.3412 | 38.373 | 38.275 | 38.2925 | 1308092.0 |
| 2017-05-25 09:45:00 | AAPL | Stock | 38.3 | 38.3375 | 38.2825 | 38.3075 | 967604.0 |
| 2017-05-25 09:50:00 | AAPL | Stock | 38.3075 | 38.325 | 38.265 | 38.3025 | 1367540.0 |
| 2017-05-25 09:55:00 | AAPL | Stock | 38.3013 | 38.3075 | 38.2625 | 38.285 | 1065024.0 |
| 2017-05-25 10:00:00 | AAPL | Stock | 38.285 | 38.2965 | 38.2575 | 38.2845 | 931956.0 |
| 2017-05-25 10:05:00 | AAPL | Stock | 38.2838 | 38.3725 | 38.2825 | 38.3662 | 1293244.0 |
| 2017-05-25 10:10:00 | AAPL | Stock | 38.3662 | 38.4175 | 38.3575 | 38.4175 | 1407844.0 |
> showing 50 of 349,254 rows — these rows as CSV