PREVIEW / stock_5min / 2020-05-14
file: by_date/stock_5min/2020/2020-05-14.parquet size: 6.5 MB rows: 411,614 symbols: 2,397
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-14 04:00:00 | AAPL | Stock | 77.0 | 77.0 | 76.9725 | 76.9725 | 1120.0 |
| 2020-05-14 04:10:00 | AAPL | Stock | 76.9075 | 76.92 | 76.9075 | 76.92 | 1108.0 |
| 2020-05-14 04:20:00 | AAPL | Stock | 76.95 | 76.9625 | 76.95 | 76.9625 | 1816.0 |
| 2020-05-14 04:30:00 | AAPL | Stock | 76.975 | 76.975 | 76.975 | 76.975 | 5160.0 |
| 2020-05-14 04:40:00 | AAPL | Stock | 76.975 | 76.975 | 76.975 | 76.975 | 1864.0 |
| 2020-05-14 04:45:00 | AAPL | Stock | 76.965 | 76.975 | 76.8775 | 76.8775 | 11756.0 |
| 2020-05-14 04:50:00 | AAPL | Stock | 76.8575 | 76.95 | 76.8275 | 76.95 | 8988.0 |
| 2020-05-14 04:55:00 | AAPL | Stock | 76.925 | 76.925 | 76.925 | 76.925 | 1200.0 |
| 2020-05-14 05:05:00 | AAPL | Stock | 76.9675 | 77.0 | 76.965 | 77.0 | 12760.0 |
| 2020-05-14 05:15:00 | AAPL | Stock | 77.05 | 77.05 | 77.05 | 77.05 | 1440.0 |
| 2020-05-14 05:20:00 | AAPL | Stock | 77.0575 | 77.0575 | 77.0575 | 77.0575 | 2352.0 |
| 2020-05-14 05:30:00 | AAPL | Stock | 77.095 | 77.125 | 77.095 | 77.125 | 2588.0 |
| 2020-05-14 05:40:00 | AAPL | Stock | 77.2 | 77.2 | 77.2 | 77.2 | 1200.0 |
| 2020-05-14 05:45:00 | AAPL | Stock | 77.125 | 77.125 | 77.125 | 77.125 | 1208.0 |
| 2020-05-14 05:50:00 | AAPL | Stock | 77.25 | 77.28 | 77.25 | 77.28 | 1440.0 |
| 2020-05-14 05:55:00 | AAPL | Stock | 77.2525 | 77.2525 | 77.2525 | 77.2525 | 3248.0 |
| 2020-05-14 06:05:00 | AAPL | Stock | 77.2 | 77.2 | 77.0025 | 77.0025 | 2796.0 |
| 2020-05-14 06:10:00 | AAPL | Stock | 76.9325 | 76.9325 | 76.8 | 76.92 | 8044.0 |
| 2020-05-14 06:15:00 | AAPL | Stock | 76.955 | 76.955 | 76.9125 | 76.9125 | 3876.0 |
| 2020-05-14 06:20:00 | AAPL | Stock | 76.9125 | 76.9125 | 76.9125 | 76.9125 | 920.0 |
| 2020-05-14 06:25:00 | AAPL | Stock | 76.9125 | 76.9125 | 76.9125 | 76.9125 | 400.0 |
| 2020-05-14 06:30:00 | AAPL | Stock | 76.9575 | 76.9575 | 76.9425 | 76.9425 | 856.0 |
| 2020-05-14 06:35:00 | AAPL | Stock | 76.9125 | 76.915 | 76.9125 | 76.915 | 1224.0 |
| 2020-05-14 06:40:00 | AAPL | Stock | 76.945 | 77.0 | 76.945 | 76.95 | 8304.0 |
| 2020-05-14 06:45:00 | AAPL | Stock | 76.95 | 76.95 | 76.95 | 76.95 | 848.0 |
| 2020-05-14 06:50:00 | AAPL | Stock | 76.9375 | 76.95 | 76.9375 | 76.95 | 912.0 |
| 2020-05-14 06:55:00 | AAPL | Stock | 76.8625 | 76.8625 | 76.7825 | 76.7825 | 8408.0 |
| 2020-05-14 07:00:00 | AAPL | Stock | 76.8175 | 77.0 | 76.7825 | 76.95 | 18096.0 |
| 2020-05-14 07:05:00 | AAPL | Stock | 76.9325 | 76.9675 | 76.875 | 76.875 | 7980.0 |
| 2020-05-14 07:10:00 | AAPL | Stock | 76.8425 | 76.875 | 76.775 | 76.7925 | 13244.0 |
| 2020-05-14 07:15:00 | AAPL | Stock | 76.775 | 76.7925 | 76.635 | 76.635 | 33764.0 |
| 2020-05-14 07:20:00 | AAPL | Stock | 76.63 | 76.63 | 76.4725 | 76.525 | 46284.0 |
| 2020-05-14 07:25:00 | AAPL | Stock | 76.5 | 76.5 | 76.455 | 76.4675 | 26252.0 |
| 2020-05-14 07:30:00 | AAPL | Stock | 76.44 | 76.5 | 76.4125 | 76.4525 | 32264.0 |
| 2020-05-14 07:35:00 | AAPL | Stock | 76.475 | 76.5625 | 76.45 | 76.56 | 21676.0 |
| 2020-05-14 07:40:00 | AAPL | Stock | 76.505 | 76.505 | 76.2575 | 76.2575 | 16964.0 |
| 2020-05-14 07:45:00 | AAPL | Stock | 76.27 | 76.375 | 76.2625 | 76.35 | 7688.0 |
| 2020-05-14 07:50:00 | AAPL | Stock | 76.3125 | 76.35 | 76.25 | 76.2875 | 18204.0 |
| 2020-05-14 07:55:00 | AAPL | Stock | 76.3125 | 76.3125 | 76.1275 | 76.1675 | 25436.0 |
| 2020-05-14 08:00:00 | AAPL | Stock | 76.9 | 77.0 | 76.045 | 76.175 | 164364.0 |
| 2020-05-14 08:05:00 | AAPL | Stock | 76.1675 | 76.1675 | 76.035 | 76.035 | 13320.0 |
| 2020-05-14 08:10:00 | AAPL | Stock | 76.0325 | 76.125 | 76.0 | 76.0525 | 44596.0 |
| 2020-05-14 08:15:00 | AAPL | Stock | 76.05 | 76.1175 | 76.025 | 76.025 | 18888.0 |
| 2020-05-14 08:20:00 | AAPL | Stock | 76.0225 | 76.0225 | 75.9002 | 75.9375 | 44104.0 |
| 2020-05-14 08:25:00 | AAPL | Stock | 75.95 | 76.0 | 75.925 | 75.9975 | 53284.0 |
| 2020-05-14 08:30:00 | AAPL | Stock | 75.995 | 76.12 | 75.7525 | 75.8125 | 121900.0 |
| 2020-05-14 08:35:00 | AAPL | Stock | 75.825 | 75.875 | 75.745 | 75.87 | 95948.0 |
| 2020-05-14 08:40:00 | AAPL | Stock | 75.85 | 75.8975 | 75.63 | 75.645 | 112968.0 |
| 2020-05-14 08:45:00 | AAPL | Stock | 75.645 | 75.7 | 75.615 | 75.64 | 80660.0 |
| 2020-05-14 08:50:00 | AAPL | Stock | 75.6575 | 75.7475 | 75.5575 | 75.73 | 85608.0 |
> showing 50 of 411,614 rows — these rows as CSV