PREVIEW / stock_5min / 2018-10-11
file: by_date/stock_5min/2018/2018-10-11.parquet size: 6.0 MB rows: 376,450 symbols: 2,784
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-11 04:00:00 | AAPL | Stock | 53.5 | 53.5 | 53.375 | 53.375 | 4624.0 |
| 2018-10-11 04:05:00 | AAPL | Stock | 53.5 | 53.5 | 53.1 | 53.1 | 1968.0 |
| 2018-10-11 04:15:00 | AAPL | Stock | 53.19 | 53.19 | 53.13 | 53.175 | 1600.0 |
| 2018-10-11 04:25:00 | AAPL | Stock | 53.1575 | 53.375 | 53.1575 | 53.375 | 19616.0 |
| 2018-10-11 04:30:00 | AAPL | Stock | 53.2875 | 53.385 | 53.24 | 53.31 | 38176.0 |
| 2018-10-11 04:35:00 | AAPL | Stock | 53.3425 | 53.3975 | 53.34 | 53.3975 | 8400.0 |
| 2018-10-11 04:45:00 | AAPL | Stock | 53.3325 | 53.3725 | 53.3075 | 53.3075 | 37444.0 |
| 2018-10-11 04:50:00 | AAPL | Stock | 53.25 | 53.25 | 53.2375 | 53.2475 | 4084.0 |
| 2018-10-11 04:55:00 | AAPL | Stock | 53.18 | 53.2175 | 53.1375 | 53.1625 | 10240.0 |
| 2018-10-11 05:00:00 | AAPL | Stock | 53.125 | 53.145 | 53.12 | 53.145 | 9284.0 |
| 2018-10-11 05:05:00 | AAPL | Stock | 53.1475 | 53.15 | 53.145 | 53.15 | 7484.0 |
| 2018-10-11 05:10:00 | AAPL | Stock | 53.05 | 53.05 | 53.0 | 53.03 | 10320.0 |
| 2018-10-11 05:15:00 | AAPL | Stock | 53.1025 | 53.1025 | 53.1025 | 53.1025 | 9640.0 |
| 2018-10-11 05:20:00 | AAPL | Stock | 53.0625 | 53.1 | 53.0625 | 53.07 | 5720.0 |
| 2018-10-11 05:30:00 | AAPL | Stock | 53.0875 | 53.0875 | 53.07 | 53.07 | 1760.0 |
| 2018-10-11 05:35:00 | AAPL | Stock | 53.1 | 53.15 | 53.0875 | 53.15 | 11096.0 |
| 2018-10-11 05:40:00 | AAPL | Stock | 53.15 | 53.175 | 53.15 | 53.175 | 6400.0 |
| 2018-10-11 05:45:00 | AAPL | Stock | 53.2 | 53.2475 | 53.2 | 53.2475 | 4376.0 |
| 2018-10-11 05:50:00 | AAPL | Stock | 53.15 | 53.3 | 53.15 | 53.25 | 13028.0 |
| 2018-10-11 05:55:00 | AAPL | Stock | 53.255 | 53.2875 | 53.205 | 53.205 | 18660.0 |
| 2018-10-11 06:00:00 | AAPL | Stock | 53.2125 | 53.2125 | 53.2125 | 53.2125 | 400.0 |
| 2018-10-11 06:05:00 | AAPL | Stock | 53.2575 | 53.3075 | 53.2575 | 53.3075 | 4952.0 |
| 2018-10-11 06:10:00 | AAPL | Stock | 53.19 | 53.19 | 53.19 | 53.19 | 400.0 |
| 2018-10-11 06:15:00 | AAPL | Stock | 53.19 | 53.2475 | 53.19 | 53.205 | 4984.0 |
| 2018-10-11 06:20:00 | AAPL | Stock | 53.1725 | 53.1725 | 53.0875 | 53.1025 | 6040.0 |
| 2018-10-11 06:25:00 | AAPL | Stock | 53.175 | 53.175 | 53.1 | 53.1 | 4200.0 |
| 2018-10-11 06:30:00 | AAPL | Stock | 53.1 | 53.1225 | 53.075 | 53.095 | 5180.0 |
| 2018-10-11 06:35:00 | AAPL | Stock | 53.0775 | 53.11 | 53.075 | 53.11 | 21876.0 |
| 2018-10-11 06:40:00 | AAPL | Stock | 53.125 | 53.125 | 53.0625 | 53.0625 | 1800.0 |
| 2018-10-11 06:45:00 | AAPL | Stock | 53.075 | 53.15 | 53.0725 | 53.15 | 13072.0 |
| 2018-10-11 06:50:00 | AAPL | Stock | 53.175 | 53.2375 | 53.1375 | 53.205 | 21224.0 |
| 2018-10-11 06:55:00 | AAPL | Stock | 53.2075 | 53.2075 | 53.2075 | 53.2075 | 400.0 |
| 2018-10-11 07:00:00 | AAPL | Stock | 53.21 | 53.225 | 53.1375 | 53.1625 | 40452.0 |
| 2018-10-11 07:05:00 | AAPL | Stock | 53.1825 | 53.23 | 53.165 | 53.165 | 38592.0 |
| 2018-10-11 07:10:00 | AAPL | Stock | 53.165 | 53.225 | 53.125 | 53.1625 | 33344.0 |
| 2018-10-11 07:15:00 | AAPL | Stock | 53.1875 | 53.295 | 53.165 | 53.2875 | 46844.0 |
| 2018-10-11 07:20:00 | AAPL | Stock | 53.2875 | 53.375 | 53.2125 | 53.35 | 69900.0 |
| 2018-10-11 07:25:00 | AAPL | Stock | 53.35 | 53.35 | 53.225 | 53.2675 | 34012.0 |
| 2018-10-11 07:30:00 | AAPL | Stock | 53.225 | 53.2325 | 53.0625 | 53.085 | 58488.0 |
| 2018-10-11 07:35:00 | AAPL | Stock | 53.075 | 53.125 | 53.055 | 53.055 | 47484.0 |
| 2018-10-11 07:40:00 | AAPL | Stock | 53.07 | 53.165 | 53.07 | 53.14 | 61360.0 |
| 2018-10-11 07:45:00 | AAPL | Stock | 53.1675 | 53.2875 | 53.1625 | 53.275 | 41800.0 |
| 2018-10-11 07:50:00 | AAPL | Stock | 53.2775 | 53.415 | 53.2775 | 53.35 | 60280.0 |
| 2018-10-11 07:55:00 | AAPL | Stock | 53.3625 | 53.375 | 53.21 | 53.275 | 40148.0 |
| 2018-10-11 08:00:00 | AAPL | Stock | 53.175 | 53.4 | 53.055 | 53.3125 | 377248.0 |
| 2018-10-11 08:05:00 | AAPL | Stock | 53.3475 | 53.3475 | 53.2125 | 53.3 | 111776.0 |
| 2018-10-11 08:10:00 | AAPL | Stock | 53.3175 | 53.35 | 53.2825 | 53.3125 | 118240.0 |
| 2018-10-11 08:15:00 | AAPL | Stock | 53.2875 | 53.425 | 53.2875 | 53.425 | 112796.0 |
| 2018-10-11 08:20:00 | AAPL | Stock | 53.425 | 53.46 | 53.375 | 53.45 | 107412.0 |
| 2018-10-11 08:25:00 | AAPL | Stock | 53.45 | 53.5 | 53.375 | 53.5 | 94640.0 |
> showing 50 of 376,450 rows — these rows as CSV