PREVIEW / stock_5min / 2020-02-03
file: by_date/stock_5min/2020/2020-02-03.parquet size: 6.0 MB rows: 373,240 symbols: 2,431
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-03 04:00:00 | AAPL | Stock | 77.5525 | 77.6875 | 77.55 | 77.6625 | 22800.0 |
| 2020-02-03 04:05:00 | AAPL | Stock | 77.6075 | 77.6075 | 77.5 | 77.55 | 11840.0 |
| 2020-02-03 04:10:00 | AAPL | Stock | 77.54 | 77.6125 | 77.54 | 77.6125 | 3328.0 |
| 2020-02-03 04:15:00 | AAPL | Stock | 77.6 | 77.6125 | 77.575 | 77.6125 | 3644.0 |
| 2020-02-03 04:20:00 | AAPL | Stock | 77.55 | 77.55 | 77.5 | 77.5 | 2684.0 |
| 2020-02-03 04:25:00 | AAPL | Stock | 77.465 | 77.465 | 77.465 | 77.465 | 400.0 |
| 2020-02-03 04:30:00 | AAPL | Stock | 77.4625 | 77.4625 | 77.445 | 77.445 | 1428.0 |
| 2020-02-03 04:35:00 | AAPL | Stock | 77.4 | 77.4 | 77.35 | 77.35 | 14348.0 |
| 2020-02-03 04:40:00 | AAPL | Stock | 77.305 | 77.305 | 77.125 | 77.125 | 16140.0 |
| 2020-02-03 04:45:00 | AAPL | Stock | 77.1325 | 77.15 | 77.0575 | 77.15 | 7972.0 |
| 2020-02-03 04:50:00 | AAPL | Stock | 77.155 | 77.155 | 77.155 | 77.155 | 1876.0 |
| 2020-02-03 04:55:00 | AAPL | Stock | 77.04 | 77.04 | 76.76 | 76.8 | 24548.0 |
| 2020-02-03 05:00:00 | AAPL | Stock | 76.6875 | 76.6875 | 76.2775 | 76.3 | 23088.0 |
| 2020-02-03 05:05:00 | AAPL | Stock | 76.2775 | 76.4025 | 76.25 | 76.375 | 20680.0 |
| 2020-02-03 05:10:00 | AAPL | Stock | 76.5 | 76.545 | 76.5 | 76.545 | 10192.0 |
| 2020-02-03 05:15:00 | AAPL | Stock | 76.6275 | 76.65 | 76.625 | 76.625 | 10320.0 |
| 2020-02-03 05:20:00 | AAPL | Stock | 76.625 | 76.625 | 76.5025 | 76.5025 | 2000.0 |
| 2020-02-03 05:25:00 | AAPL | Stock | 76.5525 | 76.5525 | 76.5525 | 76.5525 | 1200.0 |
| 2020-02-03 05:30:00 | AAPL | Stock | 76.5575 | 76.5575 | 76.5575 | 76.5575 | 3380.0 |
| 2020-02-03 05:35:00 | AAPL | Stock | 76.55 | 76.6125 | 76.5325 | 76.6125 | 3224.0 |
| 2020-02-03 05:40:00 | AAPL | Stock | 76.58 | 76.6125 | 76.5075 | 76.5075 | 4888.0 |
| 2020-02-03 05:45:00 | AAPL | Stock | 76.61 | 76.6125 | 76.61 | 76.6125 | 1564.0 |
| 2020-02-03 05:50:00 | AAPL | Stock | 76.6525 | 76.6525 | 76.65 | 76.65 | 1160.0 |
| 2020-02-03 05:55:00 | AAPL | Stock | 76.57 | 76.71 | 76.57 | 76.71 | 7600.0 |
| 2020-02-03 06:00:00 | AAPL | Stock | 76.68 | 76.825 | 76.68 | 76.825 | 14792.0 |
| 2020-02-03 06:05:00 | AAPL | Stock | 76.875 | 76.8875 | 76.8675 | 76.8675 | 10808.0 |
| 2020-02-03 06:10:00 | AAPL | Stock | 76.8475 | 76.85 | 76.8475 | 76.85 | 2048.0 |
| 2020-02-03 06:15:00 | AAPL | Stock | 76.845 | 76.85 | 76.845 | 76.845 | 3484.0 |
| 2020-02-03 06:20:00 | AAPL | Stock | 76.8275 | 76.8275 | 76.75 | 76.75 | 2904.0 |
| 2020-02-03 06:25:00 | AAPL | Stock | 76.75 | 76.75 | 76.75 | 76.75 | 5320.0 |
| 2020-02-03 06:30:00 | AAPL | Stock | 76.7225 | 76.75 | 76.7225 | 76.7475 | 4800.0 |
| 2020-02-03 06:35:00 | AAPL | Stock | 76.7475 | 76.75 | 76.7475 | 76.75 | 2332.0 |
| 2020-02-03 06:40:00 | AAPL | Stock | 76.75 | 76.75 | 76.75 | 76.75 | 8788.0 |
| 2020-02-03 06:45:00 | AAPL | Stock | 76.75 | 76.805 | 76.75 | 76.805 | 7176.0 |
| 2020-02-03 06:50:00 | AAPL | Stock | 76.76 | 76.845 | 76.73 | 76.8125 | 12096.0 |
| 2020-02-03 06:55:00 | AAPL | Stock | 76.8125 | 76.845 | 76.8 | 76.8425 | 5260.0 |
| 2020-02-03 07:00:00 | AAPL | Stock | 76.7875 | 76.9 | 76.58 | 76.58 | 93216.0 |
| 2020-02-03 07:05:00 | AAPL | Stock | 76.58 | 76.58 | 76.3775 | 76.4 | 71048.0 |
| 2020-02-03 07:10:00 | AAPL | Stock | 76.3875 | 76.5 | 76.375 | 76.5 | 28120.0 |
| 2020-02-03 07:15:00 | AAPL | Stock | 76.485 | 76.5 | 76.405 | 76.425 | 32244.0 |
| 2020-02-03 07:20:00 | AAPL | Stock | 76.45 | 76.5 | 76.405 | 76.5 | 35216.0 |
| 2020-02-03 07:25:00 | AAPL | Stock | 76.5425 | 76.685 | 76.5425 | 76.675 | 35556.0 |
| 2020-02-03 07:30:00 | AAPL | Stock | 76.7 | 76.8975 | 76.7 | 76.8975 | 46308.0 |
| 2020-02-03 07:35:00 | AAPL | Stock | 76.8975 | 77.02 | 76.8775 | 77.02 | 98528.0 |
| 2020-02-03 07:40:00 | AAPL | Stock | 77.0175 | 77.0175 | 76.925 | 76.9575 | 85536.0 |
| 2020-02-03 07:45:00 | AAPL | Stock | 76.9925 | 76.9925 | 76.8775 | 76.935 | 22056.0 |
| 2020-02-03 07:50:00 | AAPL | Stock | 76.88 | 76.89 | 76.725 | 76.75 | 74220.0 |
| 2020-02-03 07:55:00 | AAPL | Stock | 76.7575 | 76.775 | 76.7025 | 76.75 | 63972.0 |
| 2020-02-03 08:00:00 | AAPL | Stock | 76.5 | 77.0225 | 76.375 | 76.8275 | 356480.0 |
| 2020-02-03 08:05:00 | AAPL | Stock | 76.825 | 76.85 | 76.7772 | 76.8125 | 38380.0 |
> showing 50 of 373,240 rows — these rows as CSV