PREVIEW / stock_5min / 2020-04-23
file: by_date/stock_5min/2020/2020-04-23.parquet size: 6.3 MB rows: 396,782 symbols: 2,383
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-04-23 04:00:00 | AAPL | Stock | 68.565 | 68.565 | 68.565 | 68.565 | 800.0 |
| 2020-04-23 04:05:00 | AAPL | Stock | 68.55 | 68.55 | 68.55 | 68.55 | 400.0 |
| 2020-04-23 05:00:00 | AAPL | Stock | 68.7 | 68.7 | 68.675 | 68.675 | 1280.0 |
| 2020-04-23 05:20:00 | AAPL | Stock | 68.85 | 68.9225 | 68.85 | 68.9 | 4380.0 |
| 2020-04-23 05:25:00 | AAPL | Stock | 68.88 | 68.88 | 68.88 | 68.88 | 540.0 |
| 2020-04-23 05:30:00 | AAPL | Stock | 68.9225 | 68.9225 | 68.9225 | 68.9225 | 1340.0 |
| 2020-04-23 05:35:00 | AAPL | Stock | 68.99 | 68.99 | 68.99 | 68.99 | 800.0 |
| 2020-04-23 06:00:00 | AAPL | Stock | 68.95 | 68.95 | 68.95 | 68.95 | 796.0 |
| 2020-04-23 06:05:00 | AAPL | Stock | 68.89 | 68.89 | 68.8875 | 68.8875 | 800.0 |
| 2020-04-23 06:15:00 | AAPL | Stock | 68.775 | 68.775 | 68.7 | 68.7 | 1496.0 |
| 2020-04-23 06:20:00 | AAPL | Stock | 68.5 | 68.5 | 68.5 | 68.5 | 1600.0 |
| 2020-04-23 06:30:00 | AAPL | Stock | 68.575 | 68.575 | 68.5025 | 68.5025 | 1584.0 |
| 2020-04-23 06:40:00 | AAPL | Stock | 68.625 | 68.625 | 68.5325 | 68.5325 | 1792.0 |
| 2020-04-23 06:45:00 | AAPL | Stock | 68.625 | 68.69 | 68.625 | 68.69 | 1212.0 |
| 2020-04-23 06:50:00 | AAPL | Stock | 68.685 | 68.685 | 68.685 | 68.685 | 400.0 |
| 2020-04-23 07:00:00 | AAPL | Stock | 68.7475 | 68.7475 | 68.5825 | 68.675 | 12484.0 |
| 2020-04-23 07:05:00 | AAPL | Stock | 68.7225 | 68.8175 | 68.7225 | 68.8125 | 9892.0 |
| 2020-04-23 07:10:00 | AAPL | Stock | 68.8375 | 68.8775 | 68.81 | 68.8775 | 9692.0 |
| 2020-04-23 07:15:00 | AAPL | Stock | 68.85 | 68.85 | 68.7875 | 68.7875 | 4556.0 |
| 2020-04-23 07:20:00 | AAPL | Stock | 68.8125 | 68.85 | 68.8 | 68.85 | 8120.0 |
| 2020-04-23 07:25:00 | AAPL | Stock | 68.83 | 68.8775 | 68.83 | 68.8625 | 22736.0 |
| 2020-04-23 07:30:00 | AAPL | Stock | 68.855 | 68.8775 | 68.855 | 68.8775 | 11128.0 |
| 2020-04-23 07:35:00 | AAPL | Stock | 68.85 | 68.85 | 68.8325 | 68.8325 | 6160.0 |
| 2020-04-23 07:40:00 | AAPL | Stock | 68.83 | 68.8425 | 68.8075 | 68.8075 | 3960.0 |
| 2020-04-23 07:45:00 | AAPL | Stock | 68.755 | 68.8175 | 68.75 | 68.7725 | 9676.0 |
| 2020-04-23 07:50:00 | AAPL | Stock | 68.785 | 68.785 | 68.725 | 68.78 | 14276.0 |
| 2020-04-23 07:55:00 | AAPL | Stock | 68.7925 | 68.8275 | 68.7925 | 68.8275 | 7180.0 |
| 2020-04-23 08:00:00 | AAPL | Stock | 68.8127 | 68.875 | 68.5825 | 68.7375 | 46492.0 |
| 2020-04-23 08:05:00 | AAPL | Stock | 68.7 | 68.7625 | 68.65 | 68.655 | 15712.0 |
| 2020-04-23 08:10:00 | AAPL | Stock | 68.65 | 68.75 | 68.65 | 68.75 | 14644.0 |
| 2020-04-23 08:15:00 | AAPL | Stock | 68.725 | 68.75 | 68.725 | 68.735 | 6736.0 |
| 2020-04-23 08:20:00 | AAPL | Stock | 68.76 | 68.7875 | 68.7525 | 68.7525 | 18692.0 |
| 2020-04-23 08:25:00 | AAPL | Stock | 68.75 | 68.8775 | 68.75 | 68.8775 | 29412.0 |
| 2020-04-23 08:30:00 | AAPL | Stock | 68.8775 | 69.0975 | 68.8125 | 68.9025 | 61812.0 |
| 2020-04-23 08:35:00 | AAPL | Stock | 68.9475 | 69.06 | 68.895 | 69.0475 | 28940.0 |
| 2020-04-23 08:40:00 | AAPL | Stock | 69.0125 | 69.0125 | 68.9275 | 69.0 | 26348.0 |
| 2020-04-23 08:45:00 | AAPL | Stock | 69.0125 | 69.105 | 68.975 | 69.08 | 89652.0 |
| 2020-04-23 08:50:00 | AAPL | Stock | 69.05 | 69.1225 | 68.975 | 69.1 | 80752.0 |
| 2020-04-23 08:55:00 | AAPL | Stock | 69.0625 | 69.11 | 68.99 | 69.005 | 33964.0 |
| 2020-04-23 09:00:00 | AAPL | Stock | 69.0725 | 69.075 | 68.9625 | 68.9925 | 12200.0 |
| 2020-04-23 09:05:00 | AAPL | Stock | 68.975 | 69.0675 | 68.94 | 69.0675 | 84584.0 |
| 2020-04-23 09:10:00 | AAPL | Stock | 69.05 | 69.1675 | 69.03 | 69.0775 | 33504.0 |
| 2020-04-23 09:15:00 | AAPL | Stock | 69.08 | 69.17 | 69.08 | 69.1375 | 13988.0 |
| 2020-04-23 09:20:00 | AAPL | Stock | 69.175 | 69.2 | 69.1275 | 69.175 | 22384.0 |
| 2020-04-23 09:25:00 | AAPL | Stock | 69.1275 | 69.1925 | 68.9625 | 68.9625 | 71048.0 |
| 2020-04-23 09:30:00 | AAPL | Stock | 68.98 | 69.4675 | 68.7925 | 69.4375 | 4049828.0 |
| 2020-04-23 09:35:00 | AAPL | Stock | 69.4375 | 69.7325 | 69.4375 | 69.4775 | 2446612.0 |
| 2020-04-23 09:40:00 | AAPL | Stock | 69.4925 | 69.7525 | 69.4275 | 69.6525 | 2322884.0 |
| 2020-04-23 09:45:00 | AAPL | Stock | 69.6445 | 69.7 | 69.49 | 69.5675 | 1582480.0 |
| 2020-04-23 09:50:00 | AAPL | Stock | 69.565 | 69.65 | 69.4375 | 69.53 | 1365732.0 |
> showing 50 of 396,782 rows — these rows as CSV