PREVIEW / stock_5min / 2019-05-20
file: by_date/stock_5min/2019/2019-05-20.parquet size: 5.6 MB rows: 356,791 symbols: 2,589
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-20 04:00:00 | AAPL | Stock | 47.325 | 47.3875 | 47.325 | 47.3625 | 10756.0 |
| 2019-05-20 04:05:00 | AAPL | Stock | 47.3625 | 47.3625 | 47.3625 | 47.3625 | 400.0 |
| 2019-05-20 04:15:00 | AAPL | Stock | 47.45 | 47.45 | 47.45 | 47.45 | 400.0 |
| 2019-05-20 04:20:00 | AAPL | Stock | 47.43 | 47.43 | 47.4 | 47.4 | 6000.0 |
| 2019-05-20 04:25:00 | AAPL | Stock | 47.42 | 47.42 | 47.3625 | 47.3625 | 7712.0 |
| 2019-05-20 04:30:00 | AAPL | Stock | 47.3325 | 47.3325 | 47.0 | 47.0 | 25848.0 |
| 2019-05-20 04:35:00 | AAPL | Stock | 47.0 | 47.0 | 46.875 | 46.88 | 6592.0 |
| 2019-05-20 04:40:00 | AAPL | Stock | 47.0 | 47.0 | 46.9025 | 47.0 | 11664.0 |
| 2019-05-20 04:45:00 | AAPL | Stock | 46.97 | 46.98 | 46.9025 | 46.925 | 22300.0 |
| 2019-05-20 04:50:00 | AAPL | Stock | 46.925 | 46.925 | 46.75 | 46.75 | 12528.0 |
| 2019-05-20 04:55:00 | AAPL | Stock | 46.75 | 46.75 | 46.7 | 46.715 | 12964.0 |
| 2019-05-20 05:00:00 | AAPL | Stock | 46.705 | 46.75 | 46.705 | 46.75 | 11252.0 |
| 2019-05-20 05:05:00 | AAPL | Stock | 46.85 | 46.85 | 46.845 | 46.85 | 3924.0 |
| 2019-05-20 05:10:00 | AAPL | Stock | 46.825 | 46.825 | 46.7625 | 46.7625 | 6368.0 |
| 2019-05-20 05:15:00 | AAPL | Stock | 46.75 | 46.79 | 46.75 | 46.7775 | 9764.0 |
| 2019-05-20 05:20:00 | AAPL | Stock | 46.7275 | 46.735 | 46.615 | 46.675 | 15868.0 |
| 2019-05-20 05:25:00 | AAPL | Stock | 46.6125 | 46.75 | 46.6125 | 46.75 | 9604.0 |
| 2019-05-20 05:30:00 | AAPL | Stock | 46.7525 | 46.7525 | 46.7525 | 46.7525 | 1200.0 |
| 2019-05-20 05:35:00 | AAPL | Stock | 46.6975 | 46.7025 | 46.6975 | 46.7025 | 844.0 |
| 2019-05-20 05:40:00 | AAPL | Stock | 46.73 | 46.75 | 46.73 | 46.75 | 12120.0 |
| 2019-05-20 05:45:00 | AAPL | Stock | 46.7475 | 46.7475 | 46.7475 | 46.7475 | 1732.0 |
| 2019-05-20 05:50:00 | AAPL | Stock | 46.725 | 46.7775 | 46.7025 | 46.75 | 5640.0 |
| 2019-05-20 05:55:00 | AAPL | Stock | 46.7375 | 46.75 | 46.7 | 46.7375 | 13120.0 |
| 2019-05-20 06:00:00 | AAPL | Stock | 46.6325 | 46.6325 | 46.6325 | 46.6325 | 852.0 |
| 2019-05-20 06:05:00 | AAPL | Stock | 46.6275 | 46.6275 | 46.5 | 46.5625 | 51788.0 |
| 2019-05-20 06:10:00 | AAPL | Stock | 46.5575 | 46.5575 | 46.4275 | 46.4325 | 72980.0 |
| 2019-05-20 06:15:00 | AAPL | Stock | 46.4325 | 46.4325 | 46.305 | 46.3125 | 41204.0 |
| 2019-05-20 06:20:00 | AAPL | Stock | 46.33 | 46.3625 | 46.2625 | 46.35 | 35864.0 |
| 2019-05-20 06:25:00 | AAPL | Stock | 46.3625 | 46.365 | 46.235 | 46.25 | 40656.0 |
| 2019-05-20 06:30:00 | AAPL | Stock | 46.2275 | 46.35 | 46.2275 | 46.29 | 26064.0 |
| 2019-05-20 06:35:00 | AAPL | Stock | 46.2875 | 46.2875 | 46.205 | 46.25 | 33604.0 |
| 2019-05-20 06:40:00 | AAPL | Stock | 46.3075 | 46.3075 | 46.175 | 46.2175 | 30136.0 |
| 2019-05-20 06:45:00 | AAPL | Stock | 46.1875 | 46.215 | 46.175 | 46.1875 | 11864.0 |
| 2019-05-20 06:50:00 | AAPL | Stock | 46.1775 | 46.1825 | 46.175 | 46.175 | 2892.0 |
| 2019-05-20 06:55:00 | AAPL | Stock | 46.125 | 46.135 | 46.035 | 46.05 | 54620.0 |
| 2019-05-20 07:00:00 | AAPL | Stock | 46.0475 | 46.2 | 46.0475 | 46.17 | 83264.0 |
| 2019-05-20 07:05:00 | AAPL | Stock | 46.12 | 46.125 | 46.005 | 46.0375 | 67632.0 |
| 2019-05-20 07:10:00 | AAPL | Stock | 46.0375 | 46.0875 | 45.9625 | 46.025 | 106560.0 |
| 2019-05-20 07:15:00 | AAPL | Stock | 46.06 | 46.2 | 46.06 | 46.175 | 129472.0 |
| 2019-05-20 07:20:00 | AAPL | Stock | 46.1375 | 46.18 | 46.1375 | 46.17 | 13688.0 |
| 2019-05-20 07:25:00 | AAPL | Stock | 46.1525 | 46.2175 | 46.1375 | 46.2125 | 84276.0 |
| 2019-05-20 07:30:00 | AAPL | Stock | 46.21 | 46.21 | 46.125 | 46.15 | 32696.0 |
| 2019-05-20 07:35:00 | AAPL | Stock | 46.15 | 46.2 | 46.05 | 46.1 | 85808.0 |
| 2019-05-20 07:40:00 | AAPL | Stock | 46.1025 | 46.15 | 46.0625 | 46.065 | 57612.0 |
| 2019-05-20 07:45:00 | AAPL | Stock | 46.1325 | 46.1375 | 46.0275 | 46.075 | 48268.0 |
| 2019-05-20 07:50:00 | AAPL | Stock | 46.0625 | 46.145 | 46.025 | 46.065 | 75620.0 |
| 2019-05-20 07:55:00 | AAPL | Stock | 46.1 | 46.12 | 46.04 | 46.0825 | 58340.0 |
| 2019-05-20 08:00:00 | AAPL | Stock | 46.0975 | 46.2 | 45.875 | 45.9125 | 340580.0 |
| 2019-05-20 08:05:00 | AAPL | Stock | 45.93 | 46.025 | 45.875 | 46.025 | 122796.0 |
| 2019-05-20 08:10:00 | AAPL | Stock | 46.005 | 46.125 | 45.9225 | 46.125 | 110228.0 |
> showing 50 of 356,791 rows — these rows as CSV