PREVIEW / stock_5min / 2018-06-15
file: by_date/stock_5min/2018/2018-06-15.parquet size: 5.7 MB rows: 366,634 symbols: 2,815
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-15 04:15:00 | AAPL | Stock | 47.545 | 47.545 | 47.545 | 47.545 | 744.0 |
| 2018-06-15 04:30:00 | AAPL | Stock | 47.6225 | 47.6225 | 47.6225 | 47.6225 | 800.0 |
| 2018-06-15 04:40:00 | AAPL | Stock | 47.6825 | 47.6825 | 47.6825 | 47.6825 | 908.0 |
| 2018-06-15 05:10:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 828.0 |
| 2018-06-15 05:30:00 | AAPL | Stock | 47.585 | 47.585 | 47.585 | 47.585 | 800.0 |
| 2018-06-15 05:55:00 | AAPL | Stock | 47.585 | 47.585 | 47.5725 | 47.5725 | 6536.0 |
| 2018-06-15 06:00:00 | AAPL | Stock | 47.5725 | 47.575 | 47.5725 | 47.575 | 15200.0 |
| 2018-06-15 06:15:00 | AAPL | Stock | 47.5725 | 47.5725 | 47.5725 | 47.5725 | 400.0 |
| 2018-06-15 06:20:00 | AAPL | Stock | 47.545 | 47.545 | 47.51 | 47.51 | 2796.0 |
| 2018-06-15 06:25:00 | AAPL | Stock | 47.5025 | 47.5075 | 47.5 | 47.5075 | 3932.0 |
| 2018-06-15 06:30:00 | AAPL | Stock | 47.4525 | 47.455 | 47.4525 | 47.455 | 3600.0 |
| 2018-06-15 06:35:00 | AAPL | Stock | 47.4575 | 47.4575 | 47.4575 | 47.4575 | 704.0 |
| 2018-06-15 06:45:00 | AAPL | Stock | 47.48 | 47.48 | 47.48 | 47.48 | 7836.0 |
| 2018-06-15 06:50:00 | AAPL | Stock | 47.505 | 47.505 | 47.505 | 47.505 | 1680.0 |
| 2018-06-15 07:00:00 | AAPL | Stock | 47.5475 | 47.57 | 47.5 | 47.5025 | 37868.0 |
| 2018-06-15 07:05:00 | AAPL | Stock | 47.5225 | 47.525 | 47.5025 | 47.5025 | 3780.0 |
| 2018-06-15 07:10:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 564.0 |
| 2018-06-15 07:15:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 11724.0 |
| 2018-06-15 07:20:00 | AAPL | Stock | 47.515 | 47.5225 | 47.515 | 47.52 | 2800.0 |
| 2018-06-15 07:25:00 | AAPL | Stock | 47.5175 | 47.5175 | 47.5 | 47.5025 | 2420.0 |
| 2018-06-15 07:30:00 | AAPL | Stock | 47.545 | 47.55 | 47.5375 | 47.5375 | 2000.0 |
| 2018-06-15 07:35:00 | AAPL | Stock | 47.575 | 47.5875 | 47.57 | 47.575 | 4400.0 |
| 2018-06-15 07:40:00 | AAPL | Stock | 47.58 | 47.58 | 47.5475 | 47.575 | 6812.0 |
| 2018-06-15 07:45:00 | AAPL | Stock | 47.575 | 47.5825 | 47.575 | 47.5825 | 3800.0 |
| 2018-06-15 07:50:00 | AAPL | Stock | 47.605 | 47.635 | 47.605 | 47.6275 | 10476.0 |
| 2018-06-15 07:55:00 | AAPL | Stock | 47.6375 | 47.6375 | 47.6025 | 47.6025 | 5948.0 |
| 2018-06-15 08:00:00 | AAPL | Stock | 47.575 | 47.8 | 47.5 | 47.55 | 76696.0 |
| 2018-06-15 08:05:00 | AAPL | Stock | 47.5525 | 47.575 | 47.55 | 47.5525 | 7884.0 |
| 2018-06-15 08:10:00 | AAPL | Stock | 47.55 | 47.5825 | 47.55 | 47.5825 | 9620.0 |
| 2018-06-15 08:15:00 | AAPL | Stock | 47.5825 | 47.5825 | 47.555 | 47.5625 | 13160.0 |
| 2018-06-15 08:20:00 | AAPL | Stock | 47.5625 | 47.5625 | 47.5575 | 47.5575 | 5124.0 |
| 2018-06-15 08:25:00 | AAPL | Stock | 47.5625 | 47.5725 | 47.5375 | 47.5625 | 8184.0 |
| 2018-06-15 08:30:00 | AAPL | Stock | 47.545 | 47.5625 | 47.5 | 47.5 | 18484.0 |
| 2018-06-15 08:35:00 | AAPL | Stock | 47.5075 | 47.5375 | 47.4875 | 47.5375 | 55980.0 |
| 2018-06-15 08:40:00 | AAPL | Stock | 47.53 | 47.53 | 47.5 | 47.525 | 31988.0 |
| 2018-06-15 08:45:00 | AAPL | Stock | 47.5025 | 47.5025 | 47.475 | 47.475 | 77092.0 |
| 2018-06-15 08:50:00 | AAPL | Stock | 47.4775 | 47.495 | 47.4775 | 47.4775 | 11932.0 |
| 2018-06-15 08:55:00 | AAPL | Stock | 47.4775 | 47.48 | 47.45 | 47.4725 | 73408.0 |
| 2018-06-15 09:00:00 | AAPL | Stock | 47.4625 | 47.475 | 47.455 | 47.4625 | 30620.0 |
| 2018-06-15 09:05:00 | AAPL | Stock | 47.4725 | 47.475 | 47.445 | 47.445 | 22340.0 |
| 2018-06-15 09:10:00 | AAPL | Stock | 47.4375 | 47.465 | 47.425 | 47.44 | 22732.0 |
| 2018-06-15 09:15:00 | AAPL | Stock | 47.44 | 47.445 | 47.4125 | 47.4125 | 33576.0 |
| 2018-06-15 09:20:00 | AAPL | Stock | 47.4225 | 47.4375 | 47.375 | 47.4325 | 59892.0 |
| 2018-06-15 09:25:00 | AAPL | Stock | 47.4325 | 47.68 | 47.4125 | 47.5075 | 747956.0 |
| 2018-06-15 09:30:00 | AAPL | Stock | 47.51 | 47.54 | 47.375 | 47.45 | 29272456.0 |
| 2018-06-15 09:35:00 | AAPL | Stock | 47.45 | 47.485 | 47.34 | 47.417 | 2548392.0 |
| 2018-06-15 09:40:00 | AAPL | Stock | 47.4125 | 47.4125 | 47.2575 | 47.2925 | 2462112.0 |
| 2018-06-15 09:45:00 | AAPL | Stock | 47.2938 | 47.41 | 47.2178 | 47.3775 | 2996036.0 |
| 2018-06-15 09:50:00 | AAPL | Stock | 47.38 | 47.3975 | 47.3175 | 47.34 | 1209948.0 |
| 2018-06-15 09:55:00 | AAPL | Stock | 47.345 | 47.3925 | 47.315 | 47.315 | 1187096.0 |
> showing 50 of 366,634 rows — these rows as CSV