PREVIEW / stock_5min / 2020-02-04
file: by_date/stock_5min/2020/2020-02-04.parquet size: 6.1 MB rows: 375,739 symbols: 2,442
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-02-04 04:00:00 | AAPL | Stock | 78.09 | 78.3125 | 78.075 | 78.3125 | 19676.0 |
| 2020-02-04 04:05:00 | AAPL | Stock | 78.2475 | 78.2475 | 78.225 | 78.225 | 4076.0 |
| 2020-02-04 04:10:00 | AAPL | Stock | 78.1825 | 78.25 | 78.175 | 78.25 | 13548.0 |
| 2020-02-04 04:15:00 | AAPL | Stock | 78.255 | 78.255 | 78.2 | 78.2 | 5724.0 |
| 2020-02-04 04:20:00 | AAPL | Stock | 78.2975 | 78.2975 | 78.2375 | 78.2375 | 3948.0 |
| 2020-02-04 04:25:00 | AAPL | Stock | 78.2625 | 78.2975 | 78.2525 | 78.2975 | 12604.0 |
| 2020-02-04 04:30:00 | AAPL | Stock | 78.39 | 78.3975 | 78.3375 | 78.3375 | 2136.0 |
| 2020-02-04 04:35:00 | AAPL | Stock | 78.3775 | 78.4 | 78.3775 | 78.4 | 3644.0 |
| 2020-02-04 04:40:00 | AAPL | Stock | 78.4 | 78.4575 | 78.4 | 78.4575 | 1468.0 |
| 2020-02-04 04:45:00 | AAPL | Stock | 78.4625 | 78.5275 | 78.4625 | 78.5275 | 8032.0 |
| 2020-02-04 04:50:00 | AAPL | Stock | 78.5275 | 78.61 | 78.5 | 78.55 | 9040.0 |
| 2020-02-04 04:55:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 4012.0 |
| 2020-02-04 05:00:00 | AAPL | Stock | 78.5975 | 78.6 | 78.5575 | 78.5575 | 5600.0 |
| 2020-02-04 05:05:00 | AAPL | Stock | 78.56 | 78.5875 | 78.55 | 78.55 | 4756.0 |
| 2020-02-04 05:15:00 | AAPL | Stock | 78.5 | 78.5 | 78.5 | 78.5 | 1600.0 |
| 2020-02-04 05:20:00 | AAPL | Stock | 78.4775 | 78.5175 | 78.4775 | 78.5175 | 5248.0 |
| 2020-02-04 05:25:00 | AAPL | Stock | 78.5275 | 78.5275 | 78.5175 | 78.5175 | 800.0 |
| 2020-02-04 05:30:00 | AAPL | Stock | 78.525 | 78.525 | 78.5175 | 78.5175 | 800.0 |
| 2020-02-04 05:35:00 | AAPL | Stock | 78.525 | 78.525 | 78.475 | 78.4975 | 37856.0 |
| 2020-02-04 05:40:00 | AAPL | Stock | 78.46 | 78.46 | 78.46 | 78.46 | 2392.0 |
| 2020-02-04 05:45:00 | AAPL | Stock | 78.4925 | 78.4975 | 78.4925 | 78.4925 | 2592.0 |
| 2020-02-04 05:50:00 | AAPL | Stock | 78.4625 | 78.4625 | 78.45 | 78.45 | 1004.0 |
| 2020-02-04 05:55:00 | AAPL | Stock | 78.4625 | 78.4625 | 78.4625 | 78.4625 | 3060.0 |
| 2020-02-04 06:00:00 | AAPL | Stock | 78.3875 | 78.39 | 78.38 | 78.39 | 4360.0 |
| 2020-02-04 06:05:00 | AAPL | Stock | 78.4175 | 78.4175 | 78.3775 | 78.3775 | 5864.0 |
| 2020-02-04 06:10:00 | AAPL | Stock | 78.425 | 78.4725 | 78.425 | 78.4725 | 6852.0 |
| 2020-02-04 06:15:00 | AAPL | Stock | 78.4675 | 78.4675 | 78.4475 | 78.4475 | 1992.0 |
| 2020-02-04 06:20:00 | AAPL | Stock | 78.4475 | 78.4475 | 78.445 | 78.445 | 1160.0 |
| 2020-02-04 06:25:00 | AAPL | Stock | 78.445 | 78.45 | 78.445 | 78.45 | 1348.0 |
| 2020-02-04 06:30:00 | AAPL | Stock | 78.4375 | 78.4375 | 78.4375 | 78.4375 | 400.0 |
| 2020-02-04 06:35:00 | AAPL | Stock | 78.4825 | 78.5 | 78.4825 | 78.5 | 7196.0 |
| 2020-02-04 06:40:00 | AAPL | Stock | 78.45 | 78.47 | 78.45 | 78.47 | 3752.0 |
| 2020-02-04 06:45:00 | AAPL | Stock | 78.47 | 78.5125 | 78.47 | 78.5125 | 6600.0 |
| 2020-02-04 06:50:00 | AAPL | Stock | 78.5075 | 78.525 | 78.5075 | 78.525 | 5040.0 |
| 2020-02-04 06:55:00 | AAPL | Stock | 78.5275 | 78.5625 | 78.525 | 78.5625 | 4428.0 |
| 2020-02-04 07:00:00 | AAPL | Stock | 78.515 | 78.55 | 78.4 | 78.4 | 110704.0 |
| 2020-02-04 07:05:00 | AAPL | Stock | 78.3875 | 78.43 | 78.3875 | 78.43 | 32688.0 |
| 2020-02-04 07:10:00 | AAPL | Stock | 78.425 | 78.495 | 78.3875 | 78.455 | 15576.0 |
| 2020-02-04 07:15:00 | AAPL | Stock | 78.455 | 78.455 | 78.4425 | 78.4425 | 2000.0 |
| 2020-02-04 07:20:00 | AAPL | Stock | 78.4425 | 78.4425 | 78.38 | 78.395 | 22452.0 |
| 2020-02-04 07:25:00 | AAPL | Stock | 78.4 | 78.535 | 78.4 | 78.535 | 62112.0 |
| 2020-02-04 07:30:00 | AAPL | Stock | 78.5375 | 78.625 | 78.5375 | 78.625 | 57104.0 |
| 2020-02-04 07:35:00 | AAPL | Stock | 78.655 | 78.845 | 78.65 | 78.8 | 80932.0 |
| 2020-02-04 07:40:00 | AAPL | Stock | 78.8125 | 78.895 | 78.7775 | 78.87 | 65588.0 |
| 2020-02-04 07:45:00 | AAPL | Stock | 78.85 | 78.9 | 78.805 | 78.8825 | 87316.0 |
| 2020-02-04 07:50:00 | AAPL | Stock | 78.8875 | 78.9275 | 78.8875 | 78.9125 | 27960.0 |
| 2020-02-04 07:55:00 | AAPL | Stock | 78.9225 | 78.9625 | 78.9 | 78.9375 | 17140.0 |
| 2020-02-04 08:00:00 | AAPL | Stock | 78.925 | 78.97 | 77.3575 | 78.85 | 364204.0 |
| 2020-02-04 08:05:00 | AAPL | Stock | 78.8725 | 78.8975 | 78.85 | 78.8875 | 40976.0 |
| 2020-02-04 08:10:00 | AAPL | Stock | 78.885 | 78.885 | 78.8525 | 78.8625 | 35580.0 |
> showing 50 of 375,739 rows — these rows as CSV