PREVIEW / stock_5min / 2018-04-04
file: by_date/stock_5min/2018/2018-04-04.parquet size: 5.6 MB rows: 360,861 symbols: 2,869
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-04-04 04:00:00 | AAPL | Stock | 41.4375 | 41.4375 | 41.25 | 41.25 | 7888.0 |
| 2018-04-04 04:05:00 | AAPL | Stock | 41.2525 | 41.2525 | 41.175 | 41.175 | 8232.0 |
| 2018-04-04 04:20:00 | AAPL | Stock | 41.2125 | 41.2125 | 41.1125 | 41.1125 | 4572.0 |
| 2018-04-04 04:25:00 | AAPL | Stock | 41.125 | 41.125 | 41.1125 | 41.1125 | 5472.0 |
| 2018-04-04 04:35:00 | AAPL | Stock | 41.14 | 41.14 | 41.14 | 41.14 | 800.0 |
| 2018-04-04 04:40:00 | AAPL | Stock | 41.175 | 41.225 | 41.175 | 41.225 | 10112.0 |
| 2018-04-04 04:45:00 | AAPL | Stock | 41.1725 | 41.1725 | 41.17 | 41.17 | 4000.0 |
| 2018-04-04 04:50:00 | AAPL | Stock | 41.15 | 41.1925 | 41.14 | 41.14 | 5456.0 |
| 2018-04-04 04:55:00 | AAPL | Stock | 41.15 | 41.205 | 41.15 | 41.2 | 7712.0 |
| 2018-04-04 05:15:00 | AAPL | Stock | 41.105 | 41.105 | 41.0675 | 41.09 | 9104.0 |
| 2018-04-04 05:20:00 | AAPL | Stock | 41.09 | 41.09 | 41.0675 | 41.0675 | 7612.0 |
| 2018-04-04 05:30:00 | AAPL | Stock | 41.1525 | 41.1525 | 41.1275 | 41.1275 | 11060.0 |
| 2018-04-04 05:35:00 | AAPL | Stock | 41.1525 | 41.2175 | 41.1525 | 41.2175 | 6816.0 |
| 2018-04-04 05:40:00 | AAPL | Stock | 41.175 | 41.18 | 41.175 | 41.18 | 800.0 |
| 2018-04-04 05:45:00 | AAPL | Stock | 41.175 | 41.225 | 41.175 | 41.2225 | 2400.0 |
| 2018-04-04 05:55:00 | AAPL | Stock | 41.165 | 41.165 | 41.1575 | 41.1575 | 800.0 |
| 2018-04-04 06:00:00 | AAPL | Stock | 41.105 | 41.105 | 41.105 | 41.105 | 1744.0 |
| 2018-04-04 06:10:00 | AAPL | Stock | 41.09 | 41.09 | 41.005 | 41.005 | 13848.0 |
| 2018-04-04 06:15:00 | AAPL | Stock | 41.005 | 41.005 | 40.965 | 40.965 | 8164.0 |
| 2018-04-04 06:20:00 | AAPL | Stock | 40.94 | 40.9725 | 40.8975 | 40.8975 | 4464.0 |
| 2018-04-04 06:25:00 | AAPL | Stock | 40.9 | 40.9625 | 40.9 | 40.9625 | 1456.0 |
| 2018-04-04 06:30:00 | AAPL | Stock | 40.975 | 40.975 | 40.925 | 40.925 | 7100.0 |
| 2018-04-04 06:35:00 | AAPL | Stock | 41.0 | 41.05 | 40.9775 | 41.045 | 8016.0 |
| 2018-04-04 06:40:00 | AAPL | Stock | 41.025 | 41.045 | 41.025 | 41.045 | 800.0 |
| 2018-04-04 06:45:00 | AAPL | Stock | 41.045 | 41.045 | 41.045 | 41.045 | 400.0 |
| 2018-04-04 06:55:00 | AAPL | Stock | 41.0675 | 41.0725 | 41.0675 | 41.0725 | 2604.0 |
| 2018-04-04 07:00:00 | AAPL | Stock | 41.1 | 41.25 | 41.0625 | 41.2375 | 41024.0 |
| 2018-04-04 07:05:00 | AAPL | Stock | 41.24 | 41.2475 | 41.1875 | 41.2125 | 20380.0 |
| 2018-04-04 07:10:00 | AAPL | Stock | 41.2125 | 41.235 | 41.2 | 41.2 | 12400.0 |
| 2018-04-04 07:15:00 | AAPL | Stock | 41.1875 | 41.2075 | 41.1675 | 41.175 | 32856.0 |
| 2018-04-04 07:20:00 | AAPL | Stock | 41.1875 | 41.225 | 41.1625 | 41.19 | 19628.0 |
| 2018-04-04 07:25:00 | AAPL | Stock | 41.225 | 41.225 | 41.1625 | 41.19 | 38224.0 |
| 2018-04-04 07:30:00 | AAPL | Stock | 41.19 | 41.2475 | 41.175 | 41.2475 | 37976.0 |
| 2018-04-04 07:35:00 | AAPL | Stock | 41.2425 | 41.25 | 41.2125 | 41.2275 | 22960.0 |
| 2018-04-04 07:40:00 | AAPL | Stock | 41.225 | 41.25 | 41.165 | 41.195 | 26520.0 |
| 2018-04-04 07:45:00 | AAPL | Stock | 41.2175 | 41.2375 | 41.2175 | 41.2375 | 10584.0 |
| 2018-04-04 07:50:00 | AAPL | Stock | 41.225 | 41.25 | 41.2 | 41.225 | 61672.0 |
| 2018-04-04 07:55:00 | AAPL | Stock | 41.23 | 41.385 | 41.2275 | 41.3625 | 46484.0 |
| 2018-04-04 08:00:00 | AAPL | Stock | 41.175 | 41.4425 | 41.025 | 41.3925 | 232080.0 |
| 2018-04-04 08:05:00 | AAPL | Stock | 41.3875 | 41.45 | 41.375 | 41.425 | 47640.0 |
| 2018-04-04 08:10:00 | AAPL | Stock | 41.4025 | 41.475 | 41.3875 | 41.475 | 81700.0 |
| 2018-04-04 08:15:00 | AAPL | Stock | 41.45 | 41.45 | 41.3125 | 41.3125 | 79152.0 |
| 2018-04-04 08:20:00 | AAPL | Stock | 41.315 | 41.315 | 41.2 | 41.2675 | 73416.0 |
| 2018-04-04 08:25:00 | AAPL | Stock | 41.255 | 41.33 | 41.2125 | 41.3025 | 28500.0 |
| 2018-04-04 08:30:00 | AAPL | Stock | 41.2925 | 41.3125 | 41.22 | 41.2375 | 28888.0 |
| 2018-04-04 08:35:00 | AAPL | Stock | 41.25 | 41.295 | 41.2475 | 41.285 | 26052.0 |
| 2018-04-04 08:40:00 | AAPL | Stock | 41.2875 | 41.375 | 41.2875 | 41.37 | 36996.0 |
| 2018-04-04 08:45:00 | AAPL | Stock | 41.365 | 41.41 | 41.3125 | 41.35 | 37860.0 |
| 2018-04-04 08:50:00 | AAPL | Stock | 41.35 | 41.425 | 41.3425 | 41.4025 | 54764.0 |
| 2018-04-04 08:55:00 | AAPL | Stock | 41.38 | 41.41 | 41.3575 | 41.3775 | 12600.0 |
> showing 50 of 360,861 rows — these rows as CSV