PREVIEW / stock_5min / 2018-03-15
file: by_date/stock_5min/2018/2018-03-15.parquet size: 5.6 MB rows: 361,997 symbols: 2,867
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-03-15 04:35:00 | AAPL | Stock | 44.6075 | 44.6075 | 44.6075 | 44.6075 | 3832.0 |
| 2018-03-15 04:40:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.6375 | 44.6375 | 2000.0 |
| 2018-03-15 04:45:00 | AAPL | Stock | 44.6375 | 44.7175 | 44.6375 | 44.7175 | 5200.0 |
| 2018-03-15 05:25:00 | AAPL | Stock | 44.7175 | 44.7175 | 44.7175 | 44.7175 | 1360.0 |
| 2018-03-15 05:45:00 | AAPL | Stock | 44.7125 | 44.7125 | 44.7 | 44.7 | 2356.0 |
| 2018-03-15 05:50:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 1600.0 |
| 2018-03-15 06:05:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 400.0 |
| 2018-03-15 06:15:00 | AAPL | Stock | 44.61 | 44.61 | 44.61 | 44.61 | 400.0 |
| 2018-03-15 06:25:00 | AAPL | Stock | 44.645 | 44.645 | 44.645 | 44.645 | 800.0 |
| 2018-03-15 06:40:00 | AAPL | Stock | 44.5875 | 44.5875 | 44.5875 | 44.5875 | 400.0 |
| 2018-03-15 06:50:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 3340.0 |
| 2018-03-15 06:55:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 660.0 |
| 2018-03-15 07:00:00 | AAPL | Stock | 44.595 | 44.5975 | 44.535 | 44.55 | 7756.0 |
| 2018-03-15 07:05:00 | AAPL | Stock | 44.555 | 44.5925 | 44.545 | 44.5775 | 29400.0 |
| 2018-03-15 07:10:00 | AAPL | Stock | 44.5775 | 44.5825 | 44.5625 | 44.5625 | 34864.0 |
| 2018-03-15 07:15:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 5800.0 |
| 2018-03-15 07:20:00 | AAPL | Stock | 44.575 | 44.575 | 44.5575 | 44.5575 | 3000.0 |
| 2018-03-15 07:25:00 | AAPL | Stock | 44.565 | 44.575 | 44.565 | 44.57 | 4100.0 |
| 2018-03-15 07:30:00 | AAPL | Stock | 44.575 | 44.575 | 44.56 | 44.56 | 900.0 |
| 2018-03-15 07:35:00 | AAPL | Stock | 44.57 | 44.58 | 44.5625 | 44.58 | 4676.0 |
| 2018-03-15 07:45:00 | AAPL | Stock | 44.6 | 44.6 | 44.6 | 44.6 | 400.0 |
| 2018-03-15 07:50:00 | AAPL | Stock | 44.58 | 44.61 | 44.58 | 44.61 | 5076.0 |
| 2018-03-15 07:55:00 | AAPL | Stock | 44.58 | 44.58 | 44.5575 | 44.58 | 11012.0 |
| 2018-03-15 08:00:00 | AAPL | Stock | 44.59 | 44.59 | 44.545 | 44.5775 | 37232.0 |
| 2018-03-15 08:05:00 | AAPL | Stock | 44.5725 | 44.5825 | 44.56 | 44.5625 | 16276.0 |
| 2018-03-15 08:10:00 | AAPL | Stock | 44.5625 | 44.5825 | 44.5375 | 44.5375 | 19516.0 |
| 2018-03-15 08:15:00 | AAPL | Stock | 44.55 | 44.57 | 44.54 | 44.5675 | 19476.0 |
| 2018-03-15 08:20:00 | AAPL | Stock | 44.5675 | 44.5875 | 44.5525 | 44.575 | 28872.0 |
| 2018-03-15 08:25:00 | AAPL | Stock | 44.5625 | 44.5725 | 44.55 | 44.55 | 8292.0 |
| 2018-03-15 08:30:00 | AAPL | Stock | 44.545 | 44.6 | 44.535 | 44.5925 | 51576.0 |
| 2018-03-15 08:35:00 | AAPL | Stock | 44.59 | 44.6575 | 44.5875 | 44.6425 | 43372.0 |
| 2018-03-15 08:40:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.59 | 44.625 | 29512.0 |
| 2018-03-15 08:50:00 | AAPL | Stock | 44.605 | 44.605 | 44.58 | 44.585 | 18760.0 |
| 2018-03-15 08:55:00 | AAPL | Stock | 44.6075 | 44.6375 | 44.6075 | 44.6275 | 64476.0 |
| 2018-03-15 09:00:00 | AAPL | Stock | 44.625 | 44.635 | 44.6175 | 44.625 | 4320.0 |
| 2018-03-15 09:05:00 | AAPL | Stock | 44.625 | 44.6575 | 44.625 | 44.6575 | 36756.0 |
| 2018-03-15 09:10:00 | AAPL | Stock | 44.6575 | 44.6875 | 44.6525 | 44.6875 | 41448.0 |
| 2018-03-15 09:15:00 | AAPL | Stock | 44.6825 | 44.6825 | 44.655 | 44.6825 | 12740.0 |
| 2018-03-15 09:20:00 | AAPL | Stock | 44.68 | 44.71 | 44.675 | 44.71 | 43272.0 |
| 2018-03-15 09:25:00 | AAPL | Stock | 44.71 | 44.71 | 44.6125 | 44.625 | 68136.0 |
| 2018-03-15 09:30:00 | AAPL | Stock | 44.625 | 44.7075 | 44.6075 | 44.6375 | 3103120.0 |
| 2018-03-15 09:35:00 | AAPL | Stock | 44.6375 | 44.6908 | 44.5675 | 44.67 | 1609508.0 |
| 2018-03-15 09:40:00 | AAPL | Stock | 44.665 | 44.6825 | 44.6125 | 44.67 | 1690848.0 |
| 2018-03-15 09:45:00 | AAPL | Stock | 44.6675 | 44.675 | 44.58 | 44.6062 | 1789740.0 |
| 2018-03-15 09:50:00 | AAPL | Stock | 44.605 | 44.6725 | 44.605 | 44.6575 | 1736500.0 |
| 2018-03-15 09:55:00 | AAPL | Stock | 44.655 | 44.6675 | 44.615 | 44.6622 | 886264.0 |
| 2018-03-15 10:00:00 | AAPL | Stock | 44.66 | 44.83 | 44.66 | 44.8275 | 2228996.0 |
| 2018-03-15 10:05:00 | AAPL | Stock | 44.8225 | 44.875 | 44.815 | 44.865 | 1740424.0 |
| 2018-03-15 10:10:00 | AAPL | Stock | 44.8675 | 44.89 | 44.7875 | 44.7925 | 1349812.0 |
| 2018-03-15 10:15:00 | AAPL | Stock | 44.7925 | 44.8512 | 44.7875 | 44.8125 | 1031232.0 |
> showing 50 of 361,997 rows — these rows as CSV