PREVIEW / stock_5min / 2020-05-19
file: by_date/stock_5min/2020/2020-05-19.parquet size: 6.3 MB rows: 400,284 symbols: 2,388
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-19 04:00:00 | AAPL | Stock | 79.0025 | 79.0125 | 78.9375 | 78.9375 | 7168.0 |
| 2020-05-19 04:05:00 | AAPL | Stock | 78.875 | 78.875 | 78.79 | 78.79 | 2000.0 |
| 2020-05-19 04:10:00 | AAPL | Stock | 78.685 | 78.685 | 78.65 | 78.65 | 1960.0 |
| 2020-05-19 04:20:00 | AAPL | Stock | 78.625 | 78.625 | 78.625 | 78.625 | 3200.0 |
| 2020-05-19 04:25:00 | AAPL | Stock | 78.5275 | 78.585 | 78.5025 | 78.5025 | 4032.0 |
| 2020-05-19 04:30:00 | AAPL | Stock | 78.5325 | 78.5825 | 78.5325 | 78.575 | 1804.0 |
| 2020-05-19 04:35:00 | AAPL | Stock | 78.5725 | 78.5725 | 78.5725 | 78.5725 | 400.0 |
| 2020-05-19 04:40:00 | AAPL | Stock | 78.535 | 78.625 | 78.535 | 78.625 | 1600.0 |
| 2020-05-19 04:45:00 | AAPL | Stock | 78.6375 | 78.6625 | 78.625 | 78.625 | 2000.0 |
| 2020-05-19 05:15:00 | AAPL | Stock | 78.6375 | 78.64 | 78.6375 | 78.64 | 1200.0 |
| 2020-05-19 05:20:00 | AAPL | Stock | 78.6175 | 78.6175 | 78.6175 | 78.6175 | 400.0 |
| 2020-05-19 05:40:00 | AAPL | Stock | 78.625 | 78.625 | 78.625 | 78.625 | 1488.0 |
| 2020-05-19 06:00:00 | AAPL | Stock | 78.5375 | 78.5375 | 78.52 | 78.52 | 2740.0 |
| 2020-05-19 06:10:00 | AAPL | Stock | 78.5 | 78.5 | 78.5 | 78.5 | 400.0 |
| 2020-05-19 06:15:00 | AAPL | Stock | 78.5 | 78.5 | 78.4125 | 78.4125 | 1560.0 |
| 2020-05-19 06:25:00 | AAPL | Stock | 78.3875 | 78.3875 | 78.3875 | 78.3875 | 800.0 |
| 2020-05-19 06:30:00 | AAPL | Stock | 78.425 | 78.425 | 78.425 | 78.425 | 400.0 |
| 2020-05-19 06:40:00 | AAPL | Stock | 78.58 | 78.58 | 78.58 | 78.58 | 400.0 |
| 2020-05-19 06:45:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 400.0 |
| 2020-05-19 06:50:00 | AAPL | Stock | 78.61 | 78.61 | 78.575 | 78.575 | 800.0 |
| 2020-05-19 06:55:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 600.0 |
| 2020-05-19 07:00:00 | AAPL | Stock | 78.575 | 78.7 | 78.525 | 78.7 | 10448.0 |
| 2020-05-19 07:05:00 | AAPL | Stock | 78.7 | 78.74 | 78.7 | 78.735 | 8012.0 |
| 2020-05-19 07:10:00 | AAPL | Stock | 78.7975 | 78.8 | 78.7525 | 78.7775 | 4436.0 |
| 2020-05-19 07:15:00 | AAPL | Stock | 78.805 | 78.875 | 78.805 | 78.8675 | 8960.0 |
| 2020-05-19 07:20:00 | AAPL | Stock | 78.9375 | 78.95 | 78.8625 | 78.9375 | 12436.0 |
| 2020-05-19 07:25:00 | AAPL | Stock | 78.95 | 78.9725 | 78.9 | 78.9625 | 29636.0 |
| 2020-05-19 07:30:00 | AAPL | Stock | 78.9375 | 78.955 | 78.9025 | 78.9375 | 12240.0 |
| 2020-05-19 07:35:00 | AAPL | Stock | 78.9125 | 78.925 | 78.9125 | 78.9125 | 8912.0 |
| 2020-05-19 07:40:00 | AAPL | Stock | 78.9725 | 78.9875 | 78.9725 | 78.9875 | 6992.0 |
| 2020-05-19 07:45:00 | AAPL | Stock | 78.9975 | 78.9975 | 78.9375 | 78.95 | 16100.0 |
| 2020-05-19 07:50:00 | AAPL | Stock | 78.95 | 78.95 | 78.875 | 78.875 | 10304.0 |
| 2020-05-19 07:55:00 | AAPL | Stock | 78.88 | 78.88 | 78.875 | 78.875 | 14456.0 |
| 2020-05-19 08:00:00 | AAPL | Stock | 78.6225 | 79.0 | 78.575 | 78.7875 | 49372.0 |
| 2020-05-19 08:05:00 | AAPL | Stock | 78.8 | 78.83 | 78.8 | 78.83 | 4532.0 |
| 2020-05-19 08:10:00 | AAPL | Stock | 78.8625 | 78.8625 | 78.7875 | 78.8292 | 10860.0 |
| 2020-05-19 08:15:00 | AAPL | Stock | 78.775 | 78.8 | 78.775 | 78.7875 | 8400.0 |
| 2020-05-19 08:20:00 | AAPL | Stock | 78.8125 | 78.82 | 78.7575 | 78.7875 | 7224.0 |
| 2020-05-19 08:25:00 | AAPL | Stock | 78.7875 | 78.815 | 78.7575 | 78.815 | 18928.0 |
| 2020-05-19 08:30:00 | AAPL | Stock | 78.8375 | 78.9625 | 78.8375 | 78.8375 | 22692.0 |
| 2020-05-19 08:35:00 | AAPL | Stock | 78.8375 | 78.9 | 78.8375 | 78.9 | 6548.0 |
| 2020-05-19 08:40:00 | AAPL | Stock | 78.895 | 78.895 | 78.8875 | 78.8875 | 3744.0 |
| 2020-05-19 08:45:00 | AAPL | Stock | 78.9425 | 78.945 | 78.9 | 78.9425 | 14248.0 |
| 2020-05-19 08:50:00 | AAPL | Stock | 78.9375 | 78.96 | 78.925 | 78.9375 | 12836.0 |
| 2020-05-19 08:55:00 | AAPL | Stock | 78.9375 | 78.975 | 78.9375 | 78.95 | 20452.0 |
| 2020-05-19 09:00:00 | AAPL | Stock | 78.9428 | 78.97 | 78.85 | 78.85 | 24856.0 |
| 2020-05-19 09:05:00 | AAPL | Stock | 78.85 | 78.9625 | 78.835 | 78.9625 | 39200.0 |
| 2020-05-19 09:10:00 | AAPL | Stock | 78.9425 | 78.945 | 78.9125 | 78.9125 | 8172.0 |
| 2020-05-19 09:15:00 | AAPL | Stock | 78.925 | 78.9375 | 78.8875 | 78.8975 | 21680.0 |
| 2020-05-19 09:20:00 | AAPL | Stock | 78.9 | 78.925 | 78.9 | 78.905 | 4396.0 |
> showing 50 of 400,284 rows — these rows as CSV