PREVIEW / stock_5min / 2019-01-16
file: by_date/stock_5min/2019/2019-01-16.parquet size: 5.6 MB rows: 356,076 symbols: 2,684
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-01-16 04:00:00 | AAPL | Stock | 38.375 | 38.375 | 38.3575 | 38.3575 | 3688.0 |
| 2019-01-16 04:05:00 | AAPL | Stock | 38.3675 | 38.3675 | 38.3675 | 38.3675 | 800.0 |
| 2019-01-16 04:10:00 | AAPL | Stock | 38.3675 | 38.3675 | 38.3675 | 38.3675 | 1620.0 |
| 2019-01-16 04:15:00 | AAPL | Stock | 38.415 | 38.415 | 38.415 | 38.415 | 800.0 |
| 2019-01-16 04:20:00 | AAPL | Stock | 38.3125 | 38.325 | 38.3125 | 38.3225 | 3600.0 |
| 2019-01-16 04:50:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 828.0 |
| 2019-01-16 04:55:00 | AAPL | Stock | 38.3 | 38.3 | 38.275 | 38.275 | 1936.0 |
| 2019-01-16 05:35:00 | AAPL | Stock | 38.3025 | 38.3025 | 38.235 | 38.235 | 4900.0 |
| 2019-01-16 05:40:00 | AAPL | Stock | 38.25 | 38.25 | 38.235 | 38.235 | 2888.0 |
| 2019-01-16 06:05:00 | AAPL | Stock | 38.205 | 38.205 | 38.205 | 38.205 | 716.0 |
| 2019-01-16 06:10:00 | AAPL | Stock | 38.205 | 38.205 | 38.15 | 38.15 | 9372.0 |
| 2019-01-16 06:55:00 | AAPL | Stock | 38.2375 | 38.2375 | 38.2375 | 38.2375 | 800.0 |
| 2019-01-16 07:00:00 | AAPL | Stock | 38.2475 | 38.25 | 38.2375 | 38.245 | 6780.0 |
| 2019-01-16 07:05:00 | AAPL | Stock | 38.23 | 38.2325 | 38.225 | 38.225 | 12340.0 |
| 2019-01-16 07:10:00 | AAPL | Stock | 38.2125 | 38.225 | 38.205 | 38.225 | 6580.0 |
| 2019-01-16 07:15:00 | AAPL | Stock | 38.22 | 38.25 | 38.2025 | 38.2125 | 13780.0 |
| 2019-01-16 07:20:00 | AAPL | Stock | 38.2075 | 38.2475 | 38.195 | 38.2475 | 11120.0 |
| 2019-01-16 07:25:00 | AAPL | Stock | 38.2475 | 38.25 | 38.2325 | 38.2325 | 9468.0 |
| 2019-01-16 07:30:00 | AAPL | Stock | 38.245 | 38.245 | 38.245 | 38.245 | 2000.0 |
| 2019-01-16 07:35:00 | AAPL | Stock | 38.2475 | 38.2875 | 38.2475 | 38.285 | 47248.0 |
| 2019-01-16 07:40:00 | AAPL | Stock | 38.285 | 38.3025 | 38.285 | 38.3 | 38000.0 |
| 2019-01-16 07:45:00 | AAPL | Stock | 38.33 | 38.35 | 38.3125 | 38.35 | 7784.0 |
| 2019-01-16 07:50:00 | AAPL | Stock | 38.325 | 38.325 | 38.325 | 38.325 | 800.0 |
| 2019-01-16 07:55:00 | AAPL | Stock | 38.3125 | 38.315 | 38.3 | 38.3 | 5148.0 |
| 2019-01-16 08:00:00 | AAPL | Stock | 38.275 | 38.345 | 38.2 | 38.3375 | 99204.0 |
| 2019-01-16 08:05:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3 | 38.31 | 16952.0 |
| 2019-01-16 08:10:00 | AAPL | Stock | 38.29 | 38.325 | 38.29 | 38.3125 | 41564.0 |
| 2019-01-16 08:15:00 | AAPL | Stock | 38.3175 | 38.3225 | 38.275 | 38.275 | 18160.0 |
| 2019-01-16 08:20:00 | AAPL | Stock | 38.3 | 38.3125 | 38.2825 | 38.31 | 35252.0 |
| 2019-01-16 08:25:00 | AAPL | Stock | 38.3 | 38.3125 | 38.275 | 38.275 | 66580.0 |
| 2019-01-16 08:30:00 | AAPL | Stock | 38.3 | 38.3 | 38.265 | 38.265 | 42176.0 |
| 2019-01-16 08:35:00 | AAPL | Stock | 38.2625 | 38.295 | 38.2625 | 38.28 | 15968.0 |
| 2019-01-16 08:40:00 | AAPL | Stock | 38.2825 | 38.2998 | 38.2825 | 38.2998 | 2500.0 |
| 2019-01-16 08:45:00 | AAPL | Stock | 38.2825 | 38.3 | 38.2825 | 38.3 | 6400.0 |
| 2019-01-16 08:50:00 | AAPL | Stock | 38.2975 | 38.2975 | 38.25 | 38.25 | 206292.0 |
| 2019-01-16 08:55:00 | AAPL | Stock | 38.24 | 38.24 | 38.23 | 38.23 | 2792.0 |
| 2019-01-16 09:00:00 | AAPL | Stock | 38.2325 | 38.2675 | 38.19 | 38.25 | 52440.0 |
| 2019-01-16 09:05:00 | AAPL | Stock | 38.26 | 38.26 | 38.2075 | 38.2375 | 11212.0 |
| 2019-01-16 09:10:00 | AAPL | Stock | 38.225 | 38.2475 | 38.2175 | 38.2325 | 20516.0 |
| 2019-01-16 09:15:00 | AAPL | Stock | 38.245 | 38.25 | 38.24 | 38.25 | 19588.0 |
| 2019-01-16 09:20:00 | AAPL | Stock | 38.25 | 38.265 | 38.24 | 38.26 | 32596.0 |
| 2019-01-16 09:25:00 | AAPL | Stock | 38.2475 | 38.2725 | 38.24 | 38.2625 | 63584.0 |
| 2019-01-16 09:30:00 | AAPL | Stock | 38.25 | 38.659 | 38.25 | 38.625 | 6041072.0 |
| 2019-01-16 09:35:00 | AAPL | Stock | 38.6317 | 38.7375 | 38.6225 | 38.7242 | 3297248.0 |
| 2019-01-16 09:40:00 | AAPL | Stock | 38.72 | 38.7925 | 38.685 | 38.765 | 3224776.0 |
| 2019-01-16 09:45:00 | AAPL | Stock | 38.763 | 38.91 | 38.7575 | 38.8825 | 3103332.0 |
| 2019-01-16 09:50:00 | AAPL | Stock | 38.8808 | 38.97 | 38.8475 | 38.91 | 2694172.0 |
| 2019-01-16 09:55:00 | AAPL | Stock | 38.91 | 38.9125 | 38.7875 | 38.8125 | 2298624.0 |
| 2019-01-16 10:00:00 | AAPL | Stock | 38.813 | 38.8862 | 38.7825 | 38.8575 | 2534960.0 |
| 2019-01-16 10:05:00 | AAPL | Stock | 38.8575 | 38.9375 | 38.85 | 38.9125 | 2533596.0 |
> showing 50 of 356,076 rows — these rows as CSV