PREVIEW / stock_5min / 2018-09-12
file: by_date/stock_5min/2018/2018-09-12.parquet size: 5.6 MB rows: 355,233 symbols: 2,791
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-09-12 04:00:00 | AAPL | Stock | 56.25 | 56.375 | 56.25 | 56.315 | 33604.0 |
| 2018-09-12 04:05:00 | AAPL | Stock | 56.3025 | 56.315 | 56.3025 | 56.315 | 1600.0 |
| 2018-09-12 04:10:00 | AAPL | Stock | 56.365 | 56.375 | 56.3025 | 56.3025 | 11240.0 |
| 2018-09-12 04:15:00 | AAPL | Stock | 56.3 | 56.3 | 56.3 | 56.3 | 2560.0 |
| 2018-09-12 04:20:00 | AAPL | Stock | 56.3475 | 56.35 | 56.3175 | 56.3175 | 2000.0 |
| 2018-09-12 04:25:00 | AAPL | Stock | 56.325 | 56.325 | 56.305 | 56.305 | 16456.0 |
| 2018-09-12 04:30:00 | AAPL | Stock | 56.2775 | 56.2775 | 56.275 | 56.275 | 1788.0 |
| 2018-09-12 04:35:00 | AAPL | Stock | 56.2875 | 56.3325 | 56.28 | 56.325 | 5092.0 |
| 2018-09-12 04:40:00 | AAPL | Stock | 56.28 | 56.32 | 56.28 | 56.32 | 1260.0 |
| 2018-09-12 04:45:00 | AAPL | Stock | 56.315 | 56.315 | 56.2925 | 56.2925 | 4200.0 |
| 2018-09-12 04:55:00 | AAPL | Stock | 56.3175 | 56.32 | 56.3175 | 56.32 | 1640.0 |
| 2018-09-12 05:05:00 | AAPL | Stock | 56.31 | 56.31 | 56.31 | 56.31 | 1960.0 |
| 2018-09-12 05:15:00 | AAPL | Stock | 56.295 | 56.2975 | 56.2775 | 56.2975 | 2800.0 |
| 2018-09-12 05:20:00 | AAPL | Stock | 56.2825 | 56.2975 | 56.2825 | 56.2975 | 4548.0 |
| 2018-09-12 05:25:00 | AAPL | Stock | 56.295 | 56.2975 | 56.275 | 56.275 | 10184.0 |
| 2018-09-12 05:30:00 | AAPL | Stock | 56.255 | 56.265 | 56.255 | 56.265 | 1200.0 |
| 2018-09-12 05:40:00 | AAPL | Stock | 56.2975 | 56.2975 | 56.2975 | 56.2975 | 800.0 |
| 2018-09-12 05:45:00 | AAPL | Stock | 56.2975 | 56.2975 | 56.295 | 56.2975 | 9312.0 |
| 2018-09-12 05:50:00 | AAPL | Stock | 56.2975 | 56.3 | 56.2975 | 56.3 | 3624.0 |
| 2018-09-12 05:55:00 | AAPL | Stock | 56.2875 | 56.2875 | 56.2875 | 56.2875 | 456.0 |
| 2018-09-12 06:00:00 | AAPL | Stock | 56.285 | 56.285 | 56.2575 | 56.2575 | 1240.0 |
| 2018-09-12 06:05:00 | AAPL | Stock | 56.27 | 56.285 | 56.255 | 56.255 | 9544.0 |
| 2018-09-12 06:10:00 | AAPL | Stock | 56.28 | 56.28 | 56.2725 | 56.2725 | 4540.0 |
| 2018-09-12 06:15:00 | AAPL | Stock | 56.2725 | 56.2725 | 56.27 | 56.27 | 4400.0 |
| 2018-09-12 06:20:00 | AAPL | Stock | 56.2675 | 56.2675 | 56.2425 | 56.25 | 8964.0 |
| 2018-09-12 06:25:00 | AAPL | Stock | 56.2425 | 56.265 | 56.2425 | 56.265 | 13932.0 |
| 2018-09-12 06:30:00 | AAPL | Stock | 56.2525 | 56.265 | 56.2525 | 56.265 | 1660.0 |
| 2018-09-12 06:40:00 | AAPL | Stock | 56.2525 | 56.2525 | 56.23 | 56.235 | 10948.0 |
| 2018-09-12 06:45:00 | AAPL | Stock | 56.24 | 56.24 | 56.2 | 56.2 | 7880.0 |
| 2018-09-12 06:50:00 | AAPL | Stock | 56.19 | 56.225 | 56.19 | 56.225 | 2800.0 |
| 2018-09-12 06:55:00 | AAPL | Stock | 56.24 | 56.245 | 56.24 | 56.245 | 4948.0 |
| 2018-09-12 07:00:00 | AAPL | Stock | 56.205 | 56.325 | 56.205 | 56.2975 | 78208.0 |
| 2018-09-12 07:05:00 | AAPL | Stock | 56.2975 | 56.31 | 56.2575 | 56.2625 | 16748.0 |
| 2018-09-12 07:10:00 | AAPL | Stock | 56.275 | 56.275 | 56.15 | 56.2 | 96900.0 |
| 2018-09-12 07:15:00 | AAPL | Stock | 56.1975 | 56.225 | 56.175 | 56.175 | 67352.0 |
| 2018-09-12 07:20:00 | AAPL | Stock | 56.1875 | 56.235 | 56.175 | 56.1875 | 33736.0 |
| 2018-09-12 07:25:00 | AAPL | Stock | 56.2125 | 56.23 | 56.165 | 56.23 | 19120.0 |
| 2018-09-12 07:30:00 | AAPL | Stock | 56.205 | 56.2125 | 56.1375 | 56.14 | 20608.0 |
| 2018-09-12 07:35:00 | AAPL | Stock | 56.175 | 56.2 | 56.1275 | 56.195 | 31104.0 |
| 2018-09-12 07:40:00 | AAPL | Stock | 56.185 | 56.1875 | 56.15 | 56.18 | 9088.0 |
| 2018-09-12 07:45:00 | AAPL | Stock | 56.175 | 56.1875 | 56.1375 | 56.165 | 54856.0 |
| 2018-09-12 07:50:00 | AAPL | Stock | 56.1675 | 56.175 | 56.15 | 56.1725 | 18340.0 |
| 2018-09-12 07:55:00 | AAPL | Stock | 56.1675 | 56.2125 | 56.1625 | 56.21 | 29100.0 |
| 2018-09-12 08:00:00 | AAPL | Stock | 56.22 | 56.325 | 56.1325 | 56.25 | 269484.0 |
| 2018-09-12 08:05:00 | AAPL | Stock | 56.25 | 56.25 | 56.2125 | 56.2275 | 49736.0 |
| 2018-09-12 08:10:00 | AAPL | Stock | 56.2275 | 56.27 | 56.2175 | 56.2175 | 56044.0 |
| 2018-09-12 08:15:00 | AAPL | Stock | 56.2175 | 56.2375 | 56.205 | 56.225 | 52908.0 |
| 2018-09-12 08:20:00 | AAPL | Stock | 56.225 | 56.2375 | 56.1875 | 56.2025 | 69968.0 |
| 2018-09-12 08:25:00 | AAPL | Stock | 56.2025 | 56.2525 | 56.175 | 56.21 | 72860.0 |
| 2018-09-12 08:30:00 | AAPL | Stock | 56.24 | 56.24 | 56.1775 | 56.2 | 56188.0 |
> showing 50 of 355,233 rows — these rows as CSV