PREVIEW / stock_5min / 2018-12-03
file: by_date/stock_5min/2018/2018-12-03.parquet size: 5.9 MB rows: 370,618 symbols: 2,739
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-12-03 04:00:00 | AAPL | Stock | 46.05 | 46.4625 | 46.05 | 46.345 | 82852.0 |
| 2018-12-03 04:05:00 | AAPL | Stock | 46.345 | 46.345 | 46.125 | 46.25 | 50456.0 |
| 2018-12-03 04:10:00 | AAPL | Stock | 46.23 | 46.23 | 46.2 | 46.2 | 14384.0 |
| 2018-12-03 04:15:00 | AAPL | Stock | 46.2 | 46.225 | 46.1625 | 46.175 | 24172.0 |
| 2018-12-03 04:20:00 | AAPL | Stock | 46.175 | 46.175 | 46.1625 | 46.1625 | 4896.0 |
| 2018-12-03 04:30:00 | AAPL | Stock | 46.2 | 46.25 | 46.1825 | 46.225 | 17560.0 |
| 2018-12-03 04:35:00 | AAPL | Stock | 46.25 | 46.3125 | 46.25 | 46.3125 | 6200.0 |
| 2018-12-03 04:40:00 | AAPL | Stock | 46.33 | 46.33 | 46.3 | 46.3 | 4928.0 |
| 2018-12-03 04:45:00 | AAPL | Stock | 46.315 | 46.315 | 46.2625 | 46.2625 | 1100.0 |
| 2018-12-03 04:50:00 | AAPL | Stock | 46.2625 | 46.3275 | 46.2625 | 46.3275 | 4400.0 |
| 2018-12-03 04:55:00 | AAPL | Stock | 46.33 | 46.3325 | 46.33 | 46.3325 | 1200.0 |
| 2018-12-03 05:00:00 | AAPL | Stock | 46.35 | 46.375 | 46.35 | 46.36 | 20804.0 |
| 2018-12-03 05:05:00 | AAPL | Stock | 46.3725 | 46.3725 | 46.3125 | 46.3125 | 1228.0 |
| 2018-12-03 05:10:00 | AAPL | Stock | 46.3125 | 46.3375 | 46.275 | 46.3375 | 17356.0 |
| 2018-12-03 05:15:00 | AAPL | Stock | 46.325 | 46.4025 | 46.3125 | 46.4025 | 11708.0 |
| 2018-12-03 05:20:00 | AAPL | Stock | 46.3625 | 46.3625 | 46.2525 | 46.2625 | 10556.0 |
| 2018-12-03 05:25:00 | AAPL | Stock | 46.325 | 46.36 | 46.2775 | 46.2775 | 2600.0 |
| 2018-12-03 05:30:00 | AAPL | Stock | 46.3525 | 46.3525 | 46.2875 | 46.3 | 24320.0 |
| 2018-12-03 05:35:00 | AAPL | Stock | 46.29 | 46.375 | 46.25 | 46.26 | 20180.0 |
| 2018-12-03 05:40:00 | AAPL | Stock | 46.2625 | 46.2625 | 46.2125 | 46.25 | 27384.0 |
| 2018-12-03 05:45:00 | AAPL | Stock | 46.25 | 46.325 | 46.245 | 46.2575 | 9644.0 |
| 2018-12-03 05:50:00 | AAPL | Stock | 46.26 | 46.3225 | 46.25 | 46.2525 | 7344.0 |
| 2018-12-03 05:55:00 | AAPL | Stock | 46.2875 | 46.2875 | 46.25 | 46.275 | 10404.0 |
| 2018-12-03 06:00:00 | AAPL | Stock | 46.2525 | 46.2525 | 46.25 | 46.25 | 1248.0 |
| 2018-12-03 06:05:00 | AAPL | Stock | 46.25 | 46.2775 | 46.235 | 46.2375 | 20516.0 |
| 2018-12-03 06:10:00 | AAPL | Stock | 46.2225 | 46.2475 | 46.1375 | 46.1375 | 14796.0 |
| 2018-12-03 06:15:00 | AAPL | Stock | 46.175 | 46.2375 | 46.15 | 46.155 | 32564.0 |
| 2018-12-03 06:20:00 | AAPL | Stock | 46.175 | 46.175 | 46.14 | 46.14 | 5544.0 |
| 2018-12-03 06:25:00 | AAPL | Stock | 46.125 | 46.1525 | 46.05 | 46.1 | 63764.0 |
| 2018-12-03 06:30:00 | AAPL | Stock | 46.1 | 46.125 | 46.085 | 46.125 | 9476.0 |
| 2018-12-03 06:35:00 | AAPL | Stock | 46.125 | 46.125 | 46.125 | 46.125 | 800.0 |
| 2018-12-03 06:40:00 | AAPL | Stock | 46.125 | 46.125 | 46.0825 | 46.1 | 12792.0 |
| 2018-12-03 06:45:00 | AAPL | Stock | 46.1 | 46.225 | 46.07 | 46.225 | 112516.0 |
| 2018-12-03 06:50:00 | AAPL | Stock | 46.1725 | 46.1725 | 46.115 | 46.115 | 7916.0 |
| 2018-12-03 06:55:00 | AAPL | Stock | 46.125 | 46.125 | 46.0975 | 46.1125 | 17088.0 |
| 2018-12-03 07:00:00 | AAPL | Stock | 46.1725 | 46.2225 | 46.0375 | 46.1175 | 144420.0 |
| 2018-12-03 07:05:00 | AAPL | Stock | 46.1 | 46.25 | 46.0375 | 46.05 | 122388.0 |
| 2018-12-03 07:10:00 | AAPL | Stock | 46.05 | 46.075 | 46.025 | 46.06 | 67216.0 |
| 2018-12-03 07:15:00 | AAPL | Stock | 46.0425 | 46.1025 | 46.0375 | 46.0625 | 18856.0 |
| 2018-12-03 07:20:00 | AAPL | Stock | 46.075 | 46.125 | 46.075 | 46.125 | 66388.0 |
| 2018-12-03 07:25:00 | AAPL | Stock | 46.12 | 46.18 | 46.1075 | 46.125 | 79096.0 |
| 2018-12-03 07:30:00 | AAPL | Stock | 46.1075 | 46.145 | 46.1 | 46.1 | 41860.0 |
| 2018-12-03 07:35:00 | AAPL | Stock | 46.105 | 46.125 | 46.0775 | 46.1 | 21708.0 |
| 2018-12-03 07:40:00 | AAPL | Stock | 46.1 | 46.15 | 46.055 | 46.15 | 100252.0 |
| 2018-12-03 07:45:00 | AAPL | Stock | 46.14 | 46.175 | 46.025 | 46.025 | 80032.0 |
| 2018-12-03 07:50:00 | AAPL | Stock | 46.045 | 46.1 | 46.045 | 46.065 | 55024.0 |
| 2018-12-03 07:55:00 | AAPL | Stock | 46.0625 | 46.1 | 46.04 | 46.1 | 40584.0 |
| 2018-12-03 08:00:00 | AAPL | Stock | 46.1 | 46.215 | 46.025 | 46.15 | 479184.0 |
| 2018-12-03 08:05:00 | AAPL | Stock | 46.1375 | 46.1575 | 46.125 | 46.145 | 98964.0 |
| 2018-12-03 08:10:00 | AAPL | Stock | 46.15 | 46.1575 | 46.08 | 46.1125 | 187748.0 |
> showing 50 of 370,618 rows — these rows as CSV