PREVIEW / stock_5min / 2020-05-04
file: by_date/stock_5min/2020/2020-05-04.parquet size: 6.3 MB rows: 397,290 symbols: 2,373
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-04 04:00:00 | AAPL | Stock | 72.0625 | 72.0625 | 71.7875 | 71.985 | 7140.0 |
| 2020-05-04 04:05:00 | AAPL | Stock | 72.0 | 72.0 | 71.905 | 72.0 | 3064.0 |
| 2020-05-04 04:15:00 | AAPL | Stock | 71.975 | 71.975 | 71.965 | 71.975 | 2400.0 |
| 2020-05-04 04:25:00 | AAPL | Stock | 72.01 | 72.01 | 72.01 | 72.01 | 400.0 |
| 2020-05-04 04:30:00 | AAPL | Stock | 72.015 | 72.015 | 71.92 | 71.92 | 4508.0 |
| 2020-05-04 04:40:00 | AAPL | Stock | 71.9725 | 71.9725 | 71.9725 | 71.9725 | 604.0 |
| 2020-05-04 04:45:00 | AAPL | Stock | 72.0 | 72.0 | 72.0 | 72.0 | 400.0 |
| 2020-05-04 04:50:00 | AAPL | Stock | 72.0625 | 72.0625 | 72.0 | 72.0 | 7520.0 |
| 2020-05-04 04:55:00 | AAPL | Stock | 72.025 | 72.05 | 72.025 | 72.05 | 880.0 |
| 2020-05-04 05:00:00 | AAPL | Stock | 71.965 | 71.965 | 71.96 | 71.96 | 2604.0 |
| 2020-05-04 05:05:00 | AAPL | Stock | 71.9075 | 71.9075 | 71.875 | 71.9 | 8744.0 |
| 2020-05-04 05:10:00 | AAPL | Stock | 71.88 | 71.88 | 71.88 | 71.88 | 400.0 |
| 2020-05-04 05:15:00 | AAPL | Stock | 71.885 | 71.885 | 71.88 | 71.88 | 3968.0 |
| 2020-05-04 05:20:00 | AAPL | Stock | 71.91 | 71.91 | 71.91 | 71.91 | 1440.0 |
| 2020-05-04 05:25:00 | AAPL | Stock | 71.8125 | 71.8125 | 71.775 | 71.7775 | 2248.0 |
| 2020-05-04 05:30:00 | AAPL | Stock | 71.775 | 71.775 | 71.7675 | 71.7675 | 1400.0 |
| 2020-05-04 05:35:00 | AAPL | Stock | 71.7675 | 71.7675 | 71.7675 | 71.7675 | 740.0 |
| 2020-05-04 05:40:00 | AAPL | Stock | 71.775 | 71.775 | 71.775 | 71.775 | 400.0 |
| 2020-05-04 05:50:00 | AAPL | Stock | 71.8375 | 71.845 | 71.8375 | 71.845 | 6400.0 |
| 2020-05-04 06:00:00 | AAPL | Stock | 71.755 | 71.755 | 71.755 | 71.755 | 400.0 |
| 2020-05-04 06:05:00 | AAPL | Stock | 71.85 | 71.85 | 71.85 | 71.85 | 848.0 |
| 2020-05-04 06:10:00 | AAPL | Stock | 71.9075 | 71.91 | 71.9075 | 71.9075 | 5936.0 |
| 2020-05-04 06:15:00 | AAPL | Stock | 71.995 | 72.0425 | 71.9675 | 71.995 | 4912.0 |
| 2020-05-04 06:20:00 | AAPL | Stock | 72.005 | 72.005 | 71.995 | 71.995 | 4000.0 |
| 2020-05-04 06:25:00 | AAPL | Stock | 71.9825 | 71.9825 | 71.9825 | 71.9825 | 400.0 |
| 2020-05-04 06:30:00 | AAPL | Stock | 72.0 | 72.0 | 71.9825 | 71.9825 | 4144.0 |
| 2020-05-04 06:40:00 | AAPL | Stock | 71.925 | 71.965 | 71.925 | 71.96 | 3136.0 |
| 2020-05-04 06:50:00 | AAPL | Stock | 71.925 | 71.925 | 71.8525 | 71.8525 | 6020.0 |
| 2020-05-04 06:55:00 | AAPL | Stock | 71.86 | 71.86 | 71.8525 | 71.8525 | 3600.0 |
| 2020-05-04 07:00:00 | AAPL | Stock | 71.8 | 71.925 | 71.8 | 71.89 | 39372.0 |
| 2020-05-04 07:05:00 | AAPL | Stock | 71.9125 | 71.9125 | 71.7525 | 71.7875 | 25288.0 |
| 2020-05-04 07:10:00 | AAPL | Stock | 71.7875 | 71.8875 | 71.7375 | 71.875 | 32776.0 |
| 2020-05-04 07:15:00 | AAPL | Stock | 71.8775 | 72.0 | 71.8025 | 71.905 | 32996.0 |
| 2020-05-04 07:20:00 | AAPL | Stock | 71.915 | 71.975 | 71.9125 | 71.9125 | 6120.0 |
| 2020-05-04 07:25:00 | AAPL | Stock | 71.95 | 72.0 | 71.95 | 72.0 | 11992.0 |
| 2020-05-04 07:30:00 | AAPL | Stock | 71.9825 | 72.0625 | 71.9825 | 72.0625 | 11376.0 |
| 2020-05-04 07:35:00 | AAPL | Stock | 72.12 | 72.355 | 72.12 | 72.355 | 19300.0 |
| 2020-05-04 07:40:00 | AAPL | Stock | 72.335 | 72.45 | 72.1775 | 72.1775 | 56896.0 |
| 2020-05-04 07:45:00 | AAPL | Stock | 72.21 | 72.265 | 72.21 | 72.2125 | 22380.0 |
| 2020-05-04 07:50:00 | AAPL | Stock | 72.2125 | 72.375 | 72.175 | 72.375 | 51444.0 |
| 2020-05-04 07:55:00 | AAPL | Stock | 72.3475 | 72.3475 | 72.18 | 72.23 | 23004.0 |
| 2020-05-04 08:00:00 | AAPL | Stock | 71.78 | 72.412 | 71.755 | 72.1575 | 166048.0 |
| 2020-05-04 08:05:00 | AAPL | Stock | 72.1575 | 72.3675 | 72.1 | 72.33 | 53944.0 |
| 2020-05-04 08:10:00 | AAPL | Stock | 72.35 | 72.4725 | 72.3475 | 72.4725 | 49524.0 |
| 2020-05-04 08:15:00 | AAPL | Stock | 72.415 | 72.43 | 72.2822 | 72.2875 | 59220.0 |
| 2020-05-04 08:20:00 | AAPL | Stock | 72.2825 | 72.325 | 72.2575 | 72.325 | 50600.0 |
| 2020-05-04 08:25:00 | AAPL | Stock | 72.355 | 72.4475 | 72.3525 | 72.4375 | 37856.0 |
| 2020-05-04 08:30:00 | AAPL | Stock | 72.4375 | 72.495 | 72.375 | 72.375 | 69144.0 |
| 2020-05-04 08:35:00 | AAPL | Stock | 72.34 | 72.425 | 72.34 | 72.355 | 41152.0 |
| 2020-05-04 08:40:00 | AAPL | Stock | 72.3875 | 72.45 | 72.375 | 72.395 | 36256.0 |
> showing 50 of 397,290 rows — these rows as CSV