PREVIEW / stock_5min / 2018-10-30
file: by_date/stock_5min/2018/2018-10-30.parquet size: 5.7 MB rows: 361,373 symbols: 2,760
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-10-30 04:00:00 | AAPL | Stock | 53.2775 | 53.45 | 53.2775 | 53.45 | 5100.0 |
| 2018-10-30 04:10:00 | AAPL | Stock | 53.5 | 53.6925 | 53.5 | 53.6625 | 5740.0 |
| 2018-10-30 04:15:00 | AAPL | Stock | 53.575 | 53.6 | 53.475 | 53.475 | 2592.0 |
| 2018-10-30 04:20:00 | AAPL | Stock | 53.55 | 53.625 | 53.55 | 53.625 | 4480.0 |
| 2018-10-30 04:25:00 | AAPL | Stock | 53.625 | 53.625 | 53.625 | 53.625 | 1920.0 |
| 2018-10-30 04:30:00 | AAPL | Stock | 53.65 | 53.65 | 53.565 | 53.565 | 1480.0 |
| 2018-10-30 04:35:00 | AAPL | Stock | 53.5575 | 53.5575 | 53.5575 | 53.5575 | 6000.0 |
| 2018-10-30 04:40:00 | AAPL | Stock | 53.525 | 53.5625 | 53.5 | 53.5 | 9572.0 |
| 2018-10-30 04:45:00 | AAPL | Stock | 53.5025 | 53.5025 | 53.5025 | 53.5025 | 2308.0 |
| 2018-10-30 04:50:00 | AAPL | Stock | 53.4975 | 53.5 | 53.4975 | 53.5 | 4000.0 |
| 2018-10-30 04:55:00 | AAPL | Stock | 53.5125 | 53.5125 | 53.45 | 53.45 | 800.0 |
| 2018-10-30 05:05:00 | AAPL | Stock | 53.375 | 53.375 | 53.375 | 53.375 | 2100.0 |
| 2018-10-30 05:10:00 | AAPL | Stock | 53.3575 | 53.3575 | 53.3575 | 53.3575 | 1992.0 |
| 2018-10-30 05:15:00 | AAPL | Stock | 53.3 | 53.3 | 53.255 | 53.255 | 1600.0 |
| 2018-10-30 05:20:00 | AAPL | Stock | 53.25 | 53.25 | 53.1 | 53.1 | 11516.0 |
| 2018-10-30 05:25:00 | AAPL | Stock | 53.1 | 53.17 | 53.1 | 53.17 | 2920.0 |
| 2018-10-30 05:30:00 | AAPL | Stock | 53.1325 | 53.175 | 53.1325 | 53.175 | 2000.0 |
| 2018-10-30 05:35:00 | AAPL | Stock | 53.0625 | 53.0625 | 53.0625 | 53.0625 | 496.0 |
| 2018-10-30 05:40:00 | AAPL | Stock | 53.175 | 53.175 | 53.125 | 53.175 | 43040.0 |
| 2018-10-30 05:50:00 | AAPL | Stock | 53.1875 | 53.1875 | 53.1775 | 53.1775 | 8240.0 |
| 2018-10-30 05:55:00 | AAPL | Stock | 53.2325 | 53.2325 | 53.2325 | 53.2325 | 3600.0 |
| 2018-10-30 06:10:00 | AAPL | Stock | 53.2075 | 53.2425 | 53.205 | 53.2425 | 6616.0 |
| 2018-10-30 06:15:00 | AAPL | Stock | 53.2425 | 53.3 | 53.2425 | 53.3 | 3600.0 |
| 2018-10-30 06:20:00 | AAPL | Stock | 53.335 | 53.375 | 53.33 | 53.33 | 9200.0 |
| 2018-10-30 06:25:00 | AAPL | Stock | 53.34 | 53.34 | 53.325 | 53.325 | 2800.0 |
| 2018-10-30 06:30:00 | AAPL | Stock | 53.3725 | 53.3725 | 53.3725 | 53.3725 | 1716.0 |
| 2018-10-30 06:35:00 | AAPL | Stock | 53.3 | 53.3 | 53.3 | 53.3 | 2400.0 |
| 2018-10-30 06:40:00 | AAPL | Stock | 53.2025 | 53.25 | 53.2025 | 53.25 | 3600.0 |
| 2018-10-30 06:45:00 | AAPL | Stock | 53.25 | 53.25 | 53.25 | 53.25 | 800.0 |
| 2018-10-30 06:55:00 | AAPL | Stock | 53.22 | 53.22 | 53.22 | 53.22 | 3800.0 |
| 2018-10-30 07:00:00 | AAPL | Stock | 53.22 | 53.325 | 53.22 | 53.25 | 47712.0 |
| 2018-10-30 07:05:00 | AAPL | Stock | 53.2075 | 53.2075 | 53.0725 | 53.075 | 35800.0 |
| 2018-10-30 07:10:00 | AAPL | Stock | 53.1225 | 53.175 | 53.0825 | 53.1525 | 43484.0 |
| 2018-10-30 07:15:00 | AAPL | Stock | 53.1525 | 53.175 | 53.1525 | 53.175 | 9996.0 |
| 2018-10-30 07:20:00 | AAPL | Stock | 53.155 | 53.3 | 53.155 | 53.2325 | 23064.0 |
| 2018-10-30 07:25:00 | AAPL | Stock | 53.2125 | 53.3275 | 53.2 | 53.2575 | 8744.0 |
| 2018-10-30 07:30:00 | AAPL | Stock | 53.295 | 53.3475 | 53.2875 | 53.3475 | 20144.0 |
| 2018-10-30 07:35:00 | AAPL | Stock | 53.3325 | 53.3725 | 53.32 | 53.34 | 43608.0 |
| 2018-10-30 07:40:00 | AAPL | Stock | 53.3575 | 53.4 | 53.3475 | 53.375 | 28120.0 |
| 2018-10-30 07:45:00 | AAPL | Stock | 53.35 | 53.37 | 53.2775 | 53.3125 | 40352.0 |
| 2018-10-30 07:50:00 | AAPL | Stock | 53.2875 | 53.2875 | 53.205 | 53.2425 | 16468.0 |
| 2018-10-30 07:55:00 | AAPL | Stock | 53.2325 | 53.3 | 53.2275 | 53.3 | 24224.0 |
| 2018-10-30 08:00:00 | AAPL | Stock | 53.3125 | 53.4475 | 53.06 | 53.4475 | 275964.0 |
| 2018-10-30 08:05:00 | AAPL | Stock | 53.4375 | 53.4625 | 53.4 | 53.4375 | 36248.0 |
| 2018-10-30 08:10:00 | AAPL | Stock | 53.4375 | 53.4375 | 53.35 | 53.36 | 29724.0 |
| 2018-10-30 08:15:00 | AAPL | Stock | 53.35 | 53.3775 | 53.305 | 53.375 | 40592.0 |
| 2018-10-30 08:20:00 | AAPL | Stock | 53.3725 | 53.3725 | 53.3 | 53.3 | 22536.0 |
| 2018-10-30 08:25:00 | AAPL | Stock | 53.285 | 53.31 | 53.2725 | 53.2975 | 24920.0 |
| 2018-10-30 08:30:00 | AAPL | Stock | 53.27 | 53.325 | 53.26 | 53.29 | 35484.0 |
| 2018-10-30 08:35:00 | AAPL | Stock | 53.2725 | 53.29 | 53.1875 | 53.1875 | 41432.0 |
> showing 50 of 361,373 rows — these rows as CSV