PREVIEW / stock_5min / 2018-11-06
file: by_date/stock_5min/2018/2018-11-06.parquet size: 5.6 MB rows: 349,830 symbols: 2,751
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-11-06 04:05:00 | AAPL | Stock | 50.4725 | 50.4725 | 50.4725 | 50.4725 | 1664.0 |
| 2018-11-06 04:10:00 | AAPL | Stock | 50.375 | 50.375 | 50.375 | 50.375 | 400.0 |
| 2018-11-06 04:50:00 | AAPL | Stock | 50.1375 | 50.1375 | 50.1375 | 50.1375 | 400.0 |
| 2018-11-06 04:55:00 | AAPL | Stock | 50.11 | 50.11 | 50.11 | 50.11 | 900.0 |
| 2018-11-06 05:10:00 | AAPL | Stock | 50.15 | 50.15 | 50.1475 | 50.1475 | 5440.0 |
| 2018-11-06 05:15:00 | AAPL | Stock | 50.07 | 50.105 | 50.065 | 50.105 | 9748.0 |
| 2018-11-06 05:20:00 | AAPL | Stock | 50.215 | 50.215 | 50.215 | 50.215 | 400.0 |
| 2018-11-06 05:30:00 | AAPL | Stock | 50.1 | 50.25 | 50.1 | 50.25 | 1200.0 |
| 2018-11-06 05:45:00 | AAPL | Stock | 50.2475 | 50.2475 | 50.2475 | 50.2475 | 800.0 |
| 2018-11-06 06:00:00 | AAPL | Stock | 50.16 | 50.16 | 50.0975 | 50.0975 | 4268.0 |
| 2018-11-06 06:10:00 | AAPL | Stock | 50.0675 | 50.16 | 50.0625 | 50.16 | 7608.0 |
| 2018-11-06 06:20:00 | AAPL | Stock | 50.15 | 50.1625 | 50.15 | 50.1625 | 3536.0 |
| 2018-11-06 06:25:00 | AAPL | Stock | 50.2 | 50.2 | 50.1 | 50.1 | 5248.0 |
| 2018-11-06 06:45:00 | AAPL | Stock | 50.205 | 50.205 | 50.175 | 50.175 | 2992.0 |
| 2018-11-06 06:50:00 | AAPL | Stock | 50.21 | 50.21 | 50.14 | 50.14 | 4280.0 |
| 2018-11-06 07:00:00 | AAPL | Stock | 50.16 | 50.2025 | 50.105 | 50.1125 | 13992.0 |
| 2018-11-06 07:05:00 | AAPL | Stock | 50.1225 | 50.1225 | 50.075 | 50.0875 | 11616.0 |
| 2018-11-06 07:10:00 | AAPL | Stock | 50.08 | 50.0875 | 50.0625 | 50.075 | 9808.0 |
| 2018-11-06 07:15:00 | AAPL | Stock | 50.075 | 50.085 | 50.0525 | 50.0525 | 10056.0 |
| 2018-11-06 07:20:00 | AAPL | Stock | 50.0625 | 50.12 | 50.0625 | 50.12 | 56444.0 |
| 2018-11-06 07:25:00 | AAPL | Stock | 50.1175 | 50.15 | 50.075 | 50.15 | 8512.0 |
| 2018-11-06 07:30:00 | AAPL | Stock | 50.1875 | 50.1875 | 50.0625 | 50.12 | 9724.0 |
| 2018-11-06 07:35:00 | AAPL | Stock | 50.135 | 50.15 | 50.135 | 50.1475 | 13084.0 |
| 2018-11-06 07:40:00 | AAPL | Stock | 50.1475 | 50.1825 | 50.1475 | 50.1825 | 2976.0 |
| 2018-11-06 07:45:00 | AAPL | Stock | 50.1825 | 50.275 | 50.1825 | 50.275 | 75432.0 |
| 2018-11-06 07:50:00 | AAPL | Stock | 50.225 | 50.325 | 50.225 | 50.25 | 26272.0 |
| 2018-11-06 07:55:00 | AAPL | Stock | 50.3 | 50.35 | 50.3 | 50.35 | 14528.0 |
| 2018-11-06 08:00:00 | AAPL | Stock | 50.1775 | 50.35 | 50.0525 | 50.305 | 96056.0 |
| 2018-11-06 08:05:00 | AAPL | Stock | 50.31 | 50.315 | 50.23 | 50.25 | 18208.0 |
| 2018-11-06 08:10:00 | AAPL | Stock | 50.255 | 50.2725 | 50.2025 | 50.21 | 33808.0 |
| 2018-11-06 08:15:00 | AAPL | Stock | 50.21 | 50.245 | 50.165 | 50.165 | 42384.0 |
| 2018-11-06 08:20:00 | AAPL | Stock | 50.1675 | 50.1975 | 50.1625 | 50.165 | 32144.0 |
| 2018-11-06 08:25:00 | AAPL | Stock | 50.1675 | 50.1875 | 50.15 | 50.15 | 9504.0 |
| 2018-11-06 08:30:00 | AAPL | Stock | 50.1525 | 50.21 | 50.15 | 50.18 | 12724.0 |
| 2018-11-06 08:35:00 | AAPL | Stock | 50.175 | 50.25 | 50.175 | 50.25 | 41532.0 |
| 2018-11-06 08:40:00 | AAPL | Stock | 50.2425 | 50.245 | 50.2175 | 50.2425 | 18260.0 |
| 2018-11-06 08:45:00 | AAPL | Stock | 50.245 | 50.2675 | 50.2425 | 50.245 | 36224.0 |
| 2018-11-06 08:50:00 | AAPL | Stock | 50.22 | 50.225 | 50.1625 | 50.1775 | 17688.0 |
| 2018-11-06 08:55:00 | AAPL | Stock | 50.165 | 50.3375 | 50.1625 | 50.325 | 119112.0 |
| 2018-11-06 09:00:00 | AAPL | Stock | 50.3325 | 50.4 | 50.325 | 50.3275 | 70084.0 |
| 2018-11-06 09:05:00 | AAPL | Stock | 50.3125 | 50.35 | 50.31 | 50.3325 | 40452.0 |
| 2018-11-06 09:10:00 | AAPL | Stock | 50.3325 | 50.355 | 50.3225 | 50.355 | 14584.0 |
| 2018-11-06 09:15:00 | AAPL | Stock | 50.3525 | 50.355 | 50.3075 | 50.325 | 36856.0 |
| 2018-11-06 09:20:00 | AAPL | Stock | 50.325 | 50.3525 | 50.305 | 50.3475 | 23796.0 |
| 2018-11-06 09:25:00 | AAPL | Stock | 50.3475 | 50.4875 | 50.325 | 50.4875 | 99652.0 |
| 2018-11-06 09:30:00 | AAPL | Stock | 50.48 | 50.885 | 50.4375 | 50.8115 | 7438924.0 |
| 2018-11-06 09:35:00 | AAPL | Stock | 50.81 | 50.9975 | 50.7825 | 50.9025 | 5136260.0 |
| 2018-11-06 09:40:00 | AAPL | Stock | 50.9025 | 50.9375 | 50.835 | 50.885 | 2759072.0 |
| 2018-11-06 09:45:00 | AAPL | Stock | 50.8875 | 51.1488 | 50.8838 | 51.1488 | 4649304.0 |
| 2018-11-06 09:50:00 | AAPL | Stock | 51.15 | 51.1675 | 51.005 | 51.0975 | 2708312.0 |
> showing 50 of 349,830 rows — these rows as CSV