PREVIEW / stock_5min / 2016-05-05
file: by_date/stock_5min/2016/2016-05-05.parquet size: 5.4 MB rows: 357,066 symbols: 3,298
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-05-05 05:15:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 3040.0 |
| 2016-05-05 05:20:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 400.0 |
| 2016-05-05 05:25:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 3200.0 |
| 2016-05-05 05:30:00 | AAPL | Stock | 23.5975 | 23.5975 | 23.5975 | 23.5975 | 1200.0 |
| 2016-05-05 05:50:00 | AAPL | Stock | 23.57 | 23.5875 | 23.57 | 23.5875 | 2132.0 |
| 2016-05-05 06:00:00 | AAPL | Stock | 23.575 | 23.575 | 23.575 | 23.575 | 2600.0 |
| 2016-05-05 06:20:00 | AAPL | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 2000.0 |
| 2016-05-05 06:30:00 | AAPL | Stock | 23.5125 | 23.525 | 23.5 | 23.525 | 5116.0 |
| 2016-05-05 06:35:00 | AAPL | Stock | 23.5375 | 23.5375 | 23.5375 | 23.5375 | 400.0 |
| 2016-05-05 07:00:00 | AAPL | Stock | 23.55 | 23.55 | 23.525 | 23.55 | 2644.0 |
| 2016-05-05 07:05:00 | AAPL | Stock | 23.52 | 23.52 | 23.5125 | 23.5125 | 7400.0 |
| 2016-05-05 07:10:00 | AAPL | Stock | 23.505 | 23.505 | 23.5 | 23.5 | 2604.0 |
| 2016-05-05 07:25:00 | AAPL | Stock | 23.5 | 23.5125 | 23.5 | 23.5125 | 4996.0 |
| 2016-05-05 07:30:00 | AAPL | Stock | 23.495 | 23.495 | 23.495 | 23.495 | 1600.0 |
| 2016-05-05 07:35:00 | AAPL | Stock | 23.52 | 23.52 | 23.5125 | 23.5125 | 8772.0 |
| 2016-05-05 07:40:00 | AAPL | Stock | 23.5125 | 23.525 | 23.5125 | 23.525 | 4000.0 |
| 2016-05-05 07:45:00 | AAPL | Stock | 23.5225 | 23.525 | 23.52 | 23.52 | 2000.0 |
| 2016-05-05 07:50:00 | AAPL | Stock | 23.525 | 23.525 | 23.5125 | 23.5125 | 5672.0 |
| 2016-05-05 07:55:00 | AAPL | Stock | 23.5125 | 23.5125 | 23.5125 | 23.5125 | 508.0 |
| 2016-05-05 08:00:00 | AAPL | Stock | 23.52 | 23.5625 | 23.5 | 23.51 | 46840.0 |
| 2016-05-05 08:05:00 | AAPL | Stock | 23.5125 | 23.5225 | 23.51 | 23.52 | 31956.0 |
| 2016-05-05 08:10:00 | AAPL | Stock | 23.525 | 23.525 | 23.51 | 23.51 | 2200.0 |
| 2016-05-05 08:15:00 | AAPL | Stock | 23.5125 | 23.5125 | 23.5125 | 23.5125 | 4000.0 |
| 2016-05-05 08:20:00 | AAPL | Stock | 23.5225 | 23.5225 | 23.5075 | 23.51 | 26228.0 |
| 2016-05-05 08:25:00 | AAPL | Stock | 23.51 | 23.515 | 23.51 | 23.515 | 15376.0 |
| 2016-05-05 08:30:00 | AAPL | Stock | 23.515 | 23.52 | 23.5125 | 23.52 | 6680.0 |
| 2016-05-05 08:35:00 | AAPL | Stock | 23.515 | 23.525 | 23.515 | 23.525 | 57524.0 |
| 2016-05-05 08:40:00 | AAPL | Stock | 23.5375 | 23.5375 | 23.5275 | 23.53 | 22216.0 |
| 2016-05-05 08:45:00 | AAPL | Stock | 23.53 | 23.53 | 23.5225 | 23.53 | 22700.0 |
| 2016-05-05 08:50:00 | AAPL | Stock | 23.525 | 23.53 | 23.525 | 23.525 | 11416.0 |
| 2016-05-05 08:55:00 | AAPL | Stock | 23.5275 | 23.5275 | 23.51 | 23.51 | 7600.0 |
| 2016-05-05 09:00:00 | AAPL | Stock | 23.52 | 23.52 | 23.5075 | 23.5125 | 13288.0 |
| 2016-05-05 09:05:00 | AAPL | Stock | 23.51 | 23.525 | 23.51 | 23.5175 | 10960.0 |
| 2016-05-05 09:10:00 | AAPL | Stock | 23.5225 | 23.5275 | 23.515 | 23.515 | 40288.0 |
| 2016-05-05 09:15:00 | AAPL | Stock | 23.515 | 23.53 | 23.515 | 23.525 | 16884.0 |
| 2016-05-05 09:20:00 | AAPL | Stock | 23.525 | 23.53 | 23.5125 | 23.5225 | 30996.0 |
| 2016-05-05 09:25:00 | AAPL | Stock | 23.5075 | 23.5225 | 23.405 | 23.4975 | 81168.0 |
| 2016-05-05 09:30:00 | AAPL | Stock | 23.5 | 23.5175 | 23.375 | 23.39 | 5314952.0 |
| 2016-05-05 09:35:00 | AAPL | Stock | 23.39 | 23.4 | 23.3175 | 23.3825 | 3525500.0 |
| 2016-05-05 09:40:00 | AAPL | Stock | 23.3825 | 23.3838 | 23.33 | 23.3622 | 2116136.0 |
| 2016-05-05 09:45:00 | AAPL | Stock | 23.3625 | 23.3625 | 23.25 | 23.275 | 3986576.0 |
| 2016-05-05 09:50:00 | AAPL | Stock | 23.2775 | 23.325 | 23.2675 | 23.2925 | 3043980.0 |
| 2016-05-05 09:55:00 | AAPL | Stock | 23.2925 | 23.335 | 23.2625 | 23.2798 | 2256084.0 |
| 2016-05-05 10:00:00 | AAPL | Stock | 23.2775 | 23.3325 | 23.2625 | 23.3255 | 2114240.0 |
| 2016-05-05 10:05:00 | AAPL | Stock | 23.3268 | 23.3325 | 23.2925 | 23.3175 | 1546900.0 |
| 2016-05-05 10:10:00 | AAPL | Stock | 23.3158 | 23.385 | 23.3008 | 23.3662 | 2652132.0 |
| 2016-05-05 10:15:00 | AAPL | Stock | 23.3675 | 23.3825 | 23.2975 | 23.31 | 1998148.0 |
| 2016-05-05 10:20:00 | AAPL | Stock | 23.31 | 23.315 | 23.25 | 23.255 | 2154996.0 |
| 2016-05-05 10:25:00 | AAPL | Stock | 23.2575 | 23.28 | 23.2075 | 23.225 | 3794892.0 |
| 2016-05-05 10:30:00 | AAPL | Stock | 23.2225 | 23.27 | 23.21 | 23.27 | 2403492.0 |
> showing 50 of 357,066 rows — these rows as CSV