PREVIEW / stock_5min / 2018-03-02
file: by_date/stock_5min/2018/2018-03-02.parquet size: 5.6 MB rows: 361,651 symbols: 2,863
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 |
|---|---|---|---|---|---|---|---|
| 2018-03-02 04:05:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 1776.0 |
| 2018-03-02 04:10:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 400.0 |
| 2018-03-02 04:25:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 5300.0 |
| 2018-03-02 04:30:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.59 | 43.59 | 3600.0 |
| 2018-03-02 04:35:00 | AAPL | Stock | 43.575 | 43.575 | 43.575 | 43.575 | 800.0 |
| 2018-03-02 04:55:00 | AAPL | Stock | 43.575 | 43.575 | 43.575 | 43.575 | 400.0 |
| 2018-03-02 05:10:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.4925 | 43.4925 | 5560.0 |
| 2018-03-02 05:15:00 | AAPL | Stock | 43.525 | 43.5325 | 43.525 | 43.5325 | 11792.0 |
| 2018-03-02 05:20:00 | AAPL | Stock | 43.52 | 43.53 | 43.4925 | 43.4925 | 6000.0 |
| 2018-03-02 05:35:00 | AAPL | Stock | 43.5325 | 43.5375 | 43.5 | 43.5375 | 12480.0 |
| 2018-03-02 05:40:00 | AAPL | Stock | 43.5 | 43.5 | 43.4875 | 43.4875 | 8040.0 |
| 2018-03-02 05:45:00 | AAPL | Stock | 43.4125 | 43.4125 | 43.4075 | 43.4075 | 3788.0 |
| 2018-03-02 05:50:00 | AAPL | Stock | 43.41 | 43.41 | 43.3875 | 43.3875 | 6324.0 |
| 2018-03-02 05:55:00 | AAPL | Stock | 43.4 | 43.415 | 43.4 | 43.415 | 2812.0 |
| 2018-03-02 06:00:00 | AAPL | Stock | 43.4 | 43.4 | 43.345 | 43.345 | 17400.0 |
| 2018-03-02 06:05:00 | AAPL | Stock | 43.345 | 43.345 | 43.235 | 43.275 | 34644.0 |
| 2018-03-02 06:10:00 | AAPL | Stock | 43.25 | 43.3125 | 43.25 | 43.3125 | 13404.0 |
| 2018-03-02 06:15:00 | AAPL | Stock | 43.2775 | 43.3025 | 43.275 | 43.3025 | 5872.0 |
| 2018-03-02 06:20:00 | AAPL | Stock | 43.305 | 43.305 | 43.2625 | 43.2625 | 25180.0 |
| 2018-03-02 06:25:00 | AAPL | Stock | 43.255 | 43.255 | 43.215 | 43.215 | 19540.0 |
| 2018-03-02 06:30:00 | AAPL | Stock | 43.19 | 43.25 | 43.1675 | 43.21 | 20196.0 |
| 2018-03-02 06:35:00 | AAPL | Stock | 43.2025 | 43.21 | 43.2025 | 43.21 | 5208.0 |
| 2018-03-02 06:40:00 | AAPL | Stock | 43.21 | 43.22 | 43.2025 | 43.22 | 5516.0 |
| 2018-03-02 06:45:00 | AAPL | Stock | 43.2175 | 43.25 | 43.2175 | 43.25 | 13992.0 |
| 2018-03-02 06:50:00 | AAPL | Stock | 43.2275 | 43.2275 | 43.2275 | 43.2275 | 640.0 |
| 2018-03-02 06:55:00 | AAPL | Stock | 43.2975 | 43.3225 | 43.2675 | 43.3225 | 12212.0 |
| 2018-03-02 07:00:00 | AAPL | Stock | 43.275 | 43.3225 | 43.2375 | 43.2375 | 60676.0 |
| 2018-03-02 07:05:00 | AAPL | Stock | 43.25 | 43.2875 | 43.25 | 43.2525 | 27656.0 |
| 2018-03-02 07:10:00 | AAPL | Stock | 43.305 | 43.3375 | 43.285 | 43.33 | 19612.0 |
| 2018-03-02 07:15:00 | AAPL | Stock | 43.2875 | 43.3175 | 43.28 | 43.3125 | 11240.0 |
| 2018-03-02 07:20:00 | AAPL | Stock | 43.3425 | 43.35 | 43.31 | 43.3425 | 23420.0 |
| 2018-03-02 07:25:00 | AAPL | Stock | 43.3425 | 43.375 | 43.29 | 43.3175 | 37664.0 |
| 2018-03-02 07:30:00 | AAPL | Stock | 43.3125 | 43.3175 | 43.3 | 43.3075 | 12988.0 |
| 2018-03-02 07:35:00 | AAPL | Stock | 43.325 | 43.325 | 43.275 | 43.2875 | 30536.0 |
| 2018-03-02 07:40:00 | AAPL | Stock | 43.29 | 43.29 | 43.2375 | 43.25 | 70692.0 |
| 2018-03-02 07:45:00 | AAPL | Stock | 43.2525 | 43.2525 | 43.1525 | 43.19 | 102852.0 |
| 2018-03-02 07:50:00 | AAPL | Stock | 43.1925 | 43.2225 | 43.175 | 43.175 | 28484.0 |
| 2018-03-02 07:55:00 | AAPL | Stock | 43.1625 | 43.1875 | 43.1375 | 43.15 | 66208.0 |
| 2018-03-02 08:00:00 | AAPL | Stock | 43.175 | 43.3425 | 43.11 | 43.1425 | 198684.0 |
| 2018-03-02 08:05:00 | AAPL | Stock | 43.125 | 43.2225 | 43.105 | 43.1875 | 82232.0 |
| 2018-03-02 08:10:00 | AAPL | Stock | 43.1875 | 43.1875 | 43.05 | 43.17 | 87096.0 |
| 2018-03-02 08:15:00 | AAPL | Stock | 43.17 | 43.175 | 43.1275 | 43.1375 | 54228.0 |
| 2018-03-02 08:20:00 | AAPL | Stock | 43.1325 | 43.1525 | 43.1 | 43.105 | 38136.0 |
| 2018-03-02 08:25:00 | AAPL | Stock | 43.105 | 43.1125 | 43.0625 | 43.1125 | 52112.0 |
| 2018-03-02 08:30:00 | AAPL | Stock | 43.1 | 43.15 | 43.065 | 43.15 | 89104.0 |
| 2018-03-02 08:35:00 | AAPL | Stock | 43.1625 | 43.2025 | 43.11 | 43.2025 | 78636.0 |
| 2018-03-02 08:40:00 | AAPL | Stock | 43.2 | 43.2375 | 43.1775 | 43.2375 | 75892.0 |
| 2018-03-02 08:45:00 | AAPL | Stock | 43.225 | 43.225 | 43.1375 | 43.1625 | 65676.0 |
| 2018-03-02 08:50:00 | AAPL | Stock | 43.1875 | 43.325 | 43.1875 | 43.31 | 118004.0 |
| 2018-03-02 08:55:00 | AAPL | Stock | 43.31 | 43.325 | 43.2575 | 43.275 | 70276.0 |
> showing 50 of 361,651 rows — these rows as CSV