PREVIEW / stock_5min / 2018-12-21
file: by_date/stock_5min/2018/2018-12-21.parquet size: 6.2 MB rows: 389,393 symbols: 2,746
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-21 04:00:00 | AAPL | Stock | 39.25 | 39.25 | 39.17 | 39.17 | 1676.0 |
| 2018-12-21 04:05:00 | AAPL | Stock | 39.205 | 39.205 | 39.205 | 39.205 | 400.0 |
| 2018-12-21 04:30:00 | AAPL | Stock | 39.0675 | 39.25 | 39.0675 | 39.25 | 3600.0 |
| 2018-12-21 04:35:00 | AAPL | Stock | 39.18 | 39.18 | 39.18 | 39.18 | 860.0 |
| 2018-12-21 04:45:00 | AAPL | Stock | 39.1175 | 39.1175 | 39.1175 | 39.1175 | 800.0 |
| 2018-12-21 05:00:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 800.0 |
| 2018-12-21 05:15:00 | AAPL | Stock | 39.12 | 39.12 | 39.1175 | 39.1175 | 1400.0 |
| 2018-12-21 05:20:00 | AAPL | Stock | 39.2 | 39.2 | 39.2 | 39.2 | 800.0 |
| 2018-12-21 05:25:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 400.0 |
| 2018-12-21 05:30:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 1060.0 |
| 2018-12-21 05:40:00 | AAPL | Stock | 39.2025 | 39.2025 | 39.2025 | 39.2025 | 400.0 |
| 2018-12-21 05:50:00 | AAPL | Stock | 39.17 | 39.2525 | 39.17 | 39.25 | 2936.0 |
| 2018-12-21 05:55:00 | AAPL | Stock | 39.255 | 39.255 | 39.255 | 39.255 | 2396.0 |
| 2018-12-21 06:05:00 | AAPL | Stock | 39.3025 | 39.3025 | 39.3025 | 39.3025 | 3964.0 |
| 2018-12-21 06:10:00 | AAPL | Stock | 39.3525 | 39.3525 | 39.3525 | 39.3525 | 2000.0 |
| 2018-12-21 06:40:00 | AAPL | Stock | 39.32 | 39.32 | 39.32 | 39.32 | 7600.0 |
| 2018-12-21 06:45:00 | AAPL | Stock | 39.3325 | 39.3325 | 39.3325 | 39.3325 | 400.0 |
| 2018-12-21 06:55:00 | AAPL | Stock | 39.355 | 39.3625 | 39.355 | 39.3625 | 1200.0 |
| 2018-12-21 07:00:00 | AAPL | Stock | 39.335 | 39.365 | 39.1125 | 39.3225 | 30088.0 |
| 2018-12-21 07:05:00 | AAPL | Stock | 39.2975 | 39.3225 | 39.2975 | 39.3125 | 5960.0 |
| 2018-12-21 07:10:00 | AAPL | Stock | 39.3125 | 39.3125 | 39.275 | 39.275 | 13376.0 |
| 2018-12-21 07:15:00 | AAPL | Stock | 39.2775 | 39.295 | 39.2675 | 39.2775 | 20620.0 |
| 2018-12-21 07:20:00 | AAPL | Stock | 39.2625 | 39.2675 | 39.225 | 39.225 | 13584.0 |
| 2018-12-21 07:25:00 | AAPL | Stock | 39.215 | 39.2175 | 39.175 | 39.175 | 6788.0 |
| 2018-12-21 07:30:00 | AAPL | Stock | 39.195 | 39.2275 | 39.195 | 39.225 | 14340.0 |
| 2018-12-21 07:35:00 | AAPL | Stock | 39.1875 | 39.2 | 39.15 | 39.15 | 15264.0 |
| 2018-12-21 07:40:00 | AAPL | Stock | 39.155 | 39.1725 | 39.1 | 39.1025 | 14952.0 |
| 2018-12-21 07:45:00 | AAPL | Stock | 39.1075 | 39.15 | 39.1 | 39.15 | 21980.0 |
| 2018-12-21 07:50:00 | AAPL | Stock | 39.18 | 39.2325 | 39.175 | 39.2275 | 7888.0 |
| 2018-12-21 07:55:00 | AAPL | Stock | 39.2075 | 39.2075 | 39.2 | 39.2075 | 4068.0 |
| 2018-12-21 08:00:00 | AAPL | Stock | 39.2125 | 39.3725 | 39.1025 | 39.2 | 100896.0 |
| 2018-12-21 08:05:00 | AAPL | Stock | 39.2 | 39.22 | 39.175 | 39.2 | 19844.0 |
| 2018-12-21 08:10:00 | AAPL | Stock | 39.18 | 39.28 | 39.18 | 39.28 | 20208.0 |
| 2018-12-21 08:15:00 | AAPL | Stock | 39.25 | 39.3125 | 39.25 | 39.3125 | 36048.0 |
| 2018-12-21 08:20:00 | AAPL | Stock | 39.325 | 39.3725 | 39.305 | 39.3725 | 25124.0 |
| 2018-12-21 08:25:00 | AAPL | Stock | 39.3625 | 39.4 | 39.35 | 39.35 | 42736.0 |
| 2018-12-21 08:30:00 | AAPL | Stock | 39.35 | 39.4225 | 39.35 | 39.4225 | 67596.0 |
| 2018-12-21 08:35:00 | AAPL | Stock | 39.43 | 39.55 | 39.395 | 39.52 | 126868.0 |
| 2018-12-21 08:40:00 | AAPL | Stock | 39.5125 | 39.5325 | 39.4375 | 39.44 | 66484.0 |
| 2018-12-21 08:45:00 | AAPL | Stock | 39.44 | 39.4875 | 39.415 | 39.415 | 48544.0 |
| 2018-12-21 08:50:00 | AAPL | Stock | 39.4025 | 39.46 | 39.4 | 39.46 | 24196.0 |
| 2018-12-21 08:55:00 | AAPL | Stock | 39.43 | 39.43 | 39.3475 | 39.375 | 800904.0 |
| 2018-12-21 09:00:00 | AAPL | Stock | 39.4 | 39.4725 | 39.4 | 39.4475 | 45528.0 |
| 2018-12-21 09:05:00 | AAPL | Stock | 39.4 | 39.4475 | 39.4 | 39.425 | 20556.0 |
| 2018-12-21 09:10:00 | AAPL | Stock | 39.425 | 39.475 | 39.425 | 39.475 | 24016.0 |
| 2018-12-21 09:15:00 | AAPL | Stock | 39.475 | 39.5125 | 39.45 | 39.5025 | 47292.0 |
| 2018-12-21 09:20:00 | AAPL | Stock | 39.5 | 39.535 | 39.475 | 39.49 | 79260.0 |
| 2018-12-21 09:25:00 | AAPL | Stock | 39.475 | 39.4825 | 38.775 | 39.39 | 2366692.0 |
| 2018-12-21 09:30:00 | AAPL | Stock | 39.215 | 39.395 | 38.93 | 39.3825 | 36723052.0 |
| 2018-12-21 09:35:00 | AAPL | Stock | 39.385 | 39.515 | 39.32 | 39.467 | 3708068.0 |
> showing 50 of 389,393 rows — these rows as CSV