PREVIEW / stock_5min / 2020-07-02
file: by_date/stock_5min/2020/2020-07-02.parquet size: 6.5 MB rows: 412,113 symbols: 2,435
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-07-02 04:00:00 | AAPL | Stock | 91.3475 | 91.475 | 91.2625 | 91.475 | 2332.0 |
| 2020-07-02 04:05:00 | AAPL | Stock | 91.475 | 91.475 | 91.4 | 91.4 | 1196.0 |
| 2020-07-02 04:15:00 | AAPL | Stock | 91.5 | 91.5 | 91.5 | 91.5 | 4368.0 |
| 2020-07-02 04:25:00 | AAPL | Stock | 91.5 | 91.5 | 91.5 | 91.5 | 1032.0 |
| 2020-07-02 04:40:00 | AAPL | Stock | 91.5025 | 91.5025 | 91.5025 | 91.5025 | 488.0 |
| 2020-07-02 04:45:00 | AAPL | Stock | 91.5025 | 91.5025 | 91.5 | 91.5 | 800.0 |
| 2020-07-02 05:00:00 | AAPL | Stock | 91.46 | 91.46 | 91.4275 | 91.4275 | 1012.0 |
| 2020-07-02 05:15:00 | AAPL | Stock | 91.4 | 91.48 | 91.4 | 91.48 | 2400.0 |
| 2020-07-02 05:20:00 | AAPL | Stock | 91.48 | 91.525 | 91.48 | 91.525 | 2900.0 |
| 2020-07-02 05:25:00 | AAPL | Stock | 91.5 | 91.5 | 91.5 | 91.5 | 400.0 |
| 2020-07-02 05:30:00 | AAPL | Stock | 91.46 | 91.46 | 91.45 | 91.45 | 6772.0 |
| 2020-07-02 05:35:00 | AAPL | Stock | 91.41 | 91.41 | 91.41 | 91.41 | 400.0 |
| 2020-07-02 05:45:00 | AAPL | Stock | 91.3775 | 91.3775 | 91.3775 | 91.3775 | 400.0 |
| 2020-07-02 05:50:00 | AAPL | Stock | 91.38 | 91.38 | 91.3775 | 91.3775 | 1764.0 |
| 2020-07-02 05:55:00 | AAPL | Stock | 91.38 | 91.38 | 91.38 | 91.38 | 1396.0 |
| 2020-07-02 06:05:00 | AAPL | Stock | 91.3975 | 91.4 | 91.3775 | 91.3775 | 5316.0 |
| 2020-07-02 06:10:00 | AAPL | Stock | 91.3775 | 91.4 | 91.3775 | 91.4 | 4400.0 |
| 2020-07-02 06:15:00 | AAPL | Stock | 91.4 | 91.4 | 91.375 | 91.375 | 9348.0 |
| 2020-07-02 06:40:00 | AAPL | Stock | 91.35 | 91.35 | 91.35 | 91.35 | 400.0 |
| 2020-07-02 06:45:00 | AAPL | Stock | 91.375 | 91.375 | 91.375 | 91.375 | 1824.0 |
| 2020-07-02 06:50:00 | AAPL | Stock | 91.4525 | 91.4525 | 91.4525 | 91.4525 | 1080.0 |
| 2020-07-02 07:00:00 | AAPL | Stock | 91.375 | 91.47 | 91.375 | 91.4025 | 21444.0 |
| 2020-07-02 07:05:00 | AAPL | Stock | 91.4025 | 91.44 | 91.4 | 91.4325 | 17020.0 |
| 2020-07-02 07:10:00 | AAPL | Stock | 91.44 | 91.4825 | 91.44 | 91.4825 | 13360.0 |
| 2020-07-02 07:15:00 | AAPL | Stock | 91.48 | 91.495 | 91.48 | 91.485 | 4936.0 |
| 2020-07-02 07:20:00 | AAPL | Stock | 91.4875 | 91.4925 | 91.4325 | 91.4675 | 7764.0 |
| 2020-07-02 07:25:00 | AAPL | Stock | 91.4375 | 91.455 | 91.43 | 91.455 | 8040.0 |
| 2020-07-02 07:30:00 | AAPL | Stock | 91.4575 | 91.4875 | 91.4575 | 91.4875 | 10000.0 |
| 2020-07-02 07:35:00 | AAPL | Stock | 91.4925 | 91.4925 | 91.45 | 91.45 | 11872.0 |
| 2020-07-02 07:40:00 | AAPL | Stock | 91.45 | 91.45 | 91.4175 | 91.435 | 13336.0 |
| 2020-07-02 07:45:00 | AAPL | Stock | 91.425 | 91.5 | 91.3825 | 91.3825 | 46120.0 |
| 2020-07-02 07:50:00 | AAPL | Stock | 91.38 | 91.425 | 91.38 | 91.42 | 12956.0 |
| 2020-07-02 07:55:00 | AAPL | Stock | 91.425 | 91.455 | 91.425 | 91.455 | 14724.0 |
| 2020-07-02 08:00:00 | AAPL | Stock | 91.435 | 91.4975 | 91.3525 | 91.45 | 126168.0 |
| 2020-07-02 08:05:00 | AAPL | Stock | 91.455 | 91.455 | 91.33 | 91.4475 | 30196.0 |
| 2020-07-02 08:10:00 | AAPL | Stock | 91.3575 | 91.4125 | 91.3575 | 91.4125 | 18800.0 |
| 2020-07-02 08:15:00 | AAPL | Stock | 91.3875 | 91.4 | 91.345 | 91.392 | 23692.0 |
| 2020-07-02 08:20:00 | AAPL | Stock | 91.375 | 91.4025 | 91.375 | 91.4025 | 1720.0 |
| 2020-07-02 08:25:00 | AAPL | Stock | 91.4583 | 91.4583 | 91.345 | 91.455 | 26432.0 |
| 2020-07-02 08:30:00 | AAPL | Stock | 91.45 | 91.85 | 91.45 | 91.825 | 249468.0 |
| 2020-07-02 08:35:00 | AAPL | Stock | 91.8 | 91.8 | 91.6475 | 91.68 | 74780.0 |
| 2020-07-02 08:40:00 | AAPL | Stock | 91.6775 | 91.75 | 91.65 | 91.6525 | 94532.0 |
| 2020-07-02 08:45:00 | AAPL | Stock | 91.655 | 91.8125 | 91.625 | 91.7375 | 103136.0 |
| 2020-07-02 08:50:00 | AAPL | Stock | 91.77 | 91.85 | 91.7 | 91.7775 | 78120.0 |
| 2020-07-02 08:55:00 | AAPL | Stock | 91.7975 | 91.82 | 91.7225 | 91.8025 | 71200.0 |
| 2020-07-02 09:00:00 | AAPL | Stock | 91.8025 | 91.875 | 91.7775 | 91.8 | 93740.0 |
| 2020-07-02 09:05:00 | AAPL | Stock | 91.8 | 91.8125 | 91.6625 | 91.74 | 63548.0 |
| 2020-07-02 09:10:00 | AAPL | Stock | 91.7375 | 91.75 | 91.68 | 91.7225 | 20592.0 |
| 2020-07-02 09:15:00 | AAPL | Stock | 91.7175 | 91.75 | 91.6875 | 91.7325 | 23860.0 |
| 2020-07-02 09:20:00 | AAPL | Stock | 91.7225 | 91.7875 | 91.7125 | 91.7875 | 34236.0 |
> showing 50 of 412,113 rows — these rows as CSV