PREVIEW / stock_5min / 2019-12-11
file: by_date/stock_5min/2019/2019-12-11.parquet size: 5.8 MB rows: 365,010 symbols: 2,481
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-11 04:00:00 | AAPL | Stock | 67.13 | 67.205 | 67.1025 | 67.205 | 5872.0 |
| 2019-12-11 04:05:00 | AAPL | Stock | 67.2175 | 67.225 | 67.215 | 67.225 | 7748.0 |
| 2019-12-11 04:15:00 | AAPL | Stock | 67.2075 | 67.2075 | 67.2075 | 67.2075 | 960.0 |
| 2019-12-11 04:30:00 | AAPL | Stock | 67.15 | 67.15 | 67.15 | 67.15 | 688.0 |
| 2019-12-11 05:00:00 | AAPL | Stock | 67.1925 | 67.1925 | 67.1925 | 67.1925 | 500.0 |
| 2019-12-11 05:05:00 | AAPL | Stock | 67.25 | 67.2575 | 67.25 | 67.2575 | 1988.0 |
| 2019-12-11 05:25:00 | AAPL | Stock | 67.2675 | 67.2675 | 67.2675 | 67.2675 | 400.0 |
| 2019-12-11 05:30:00 | AAPL | Stock | 67.25 | 67.25 | 67.25 | 67.25 | 3272.0 |
| 2019-12-11 05:35:00 | AAPL | Stock | 67.225 | 67.225 | 67.2 | 67.2 | 11264.0 |
| 2019-12-11 05:40:00 | AAPL | Stock | 67.1925 | 67.1925 | 67.1925 | 67.1925 | 400.0 |
| 2019-12-11 06:00:00 | AAPL | Stock | 67.2225 | 67.24 | 67.2225 | 67.24 | 2400.0 |
| 2019-12-11 06:05:00 | AAPL | Stock | 67.2825 | 67.315 | 67.2825 | 67.315 | 1280.0 |
| 2019-12-11 06:10:00 | AAPL | Stock | 67.305 | 67.305 | 67.285 | 67.285 | 2000.0 |
| 2019-12-11 06:20:00 | AAPL | Stock | 67.3 | 67.3 | 67.3 | 67.3 | 800.0 |
| 2019-12-11 06:30:00 | AAPL | Stock | 67.2875 | 67.2875 | 67.2875 | 67.2875 | 400.0 |
| 2019-12-11 06:35:00 | AAPL | Stock | 67.34 | 67.34 | 67.34 | 67.34 | 1200.0 |
| 2019-12-11 06:40:00 | AAPL | Stock | 67.35 | 67.3825 | 67.35 | 67.3825 | 2204.0 |
| 2019-12-11 06:45:00 | AAPL | Stock | 67.4 | 67.405 | 67.4 | 67.405 | 2760.0 |
| 2019-12-11 06:55:00 | AAPL | Stock | 67.405 | 67.4075 | 67.375 | 67.375 | 3376.0 |
| 2019-12-11 07:00:00 | AAPL | Stock | 67.3625 | 67.4 | 67.35 | 67.35 | 13096.0 |
| 2019-12-11 07:05:00 | AAPL | Stock | 67.3325 | 67.3325 | 67.3125 | 67.3125 | 4112.0 |
| 2019-12-11 07:10:00 | AAPL | Stock | 67.3 | 67.31 | 67.3 | 67.31 | 3200.0 |
| 2019-12-11 07:15:00 | AAPL | Stock | 67.3125 | 67.3225 | 67.3125 | 67.3225 | 4232.0 |
| 2019-12-11 07:20:00 | AAPL | Stock | 67.33 | 67.33 | 67.3 | 67.3 | 1792.0 |
| 2019-12-11 07:25:00 | AAPL | Stock | 67.2775 | 67.2775 | 67.2775 | 67.2775 | 1920.0 |
| 2019-12-11 07:30:00 | AAPL | Stock | 67.3125 | 67.3125 | 67.3125 | 67.3125 | 400.0 |
| 2019-12-11 07:35:00 | AAPL | Stock | 67.32 | 67.325 | 67.32 | 67.325 | 2600.0 |
| 2019-12-11 07:40:00 | AAPL | Stock | 67.3325 | 67.3475 | 67.325 | 67.325 | 17060.0 |
| 2019-12-11 07:45:00 | AAPL | Stock | 67.3475 | 67.4 | 67.3475 | 67.355 | 61972.0 |
| 2019-12-11 07:50:00 | AAPL | Stock | 67.37 | 67.37 | 67.355 | 67.355 | 2400.0 |
| 2019-12-11 07:55:00 | AAPL | Stock | 67.3425 | 67.3425 | 67.3425 | 67.3425 | 800.0 |
| 2019-12-11 08:00:00 | AAPL | Stock | 67.343 | 67.4125 | 67.2875 | 67.35 | 57332.0 |
| 2019-12-11 08:05:00 | AAPL | Stock | 67.335 | 67.35 | 67.3125 | 67.3425 | 12868.0 |
| 2019-12-11 08:10:00 | AAPL | Stock | 67.325 | 67.375 | 67.3125 | 67.355 | 11844.0 |
| 2019-12-11 08:15:00 | AAPL | Stock | 67.355 | 67.355 | 67.345 | 67.345 | 2992.0 |
| 2019-12-11 08:20:00 | AAPL | Stock | 67.35 | 67.35 | 67.3125 | 67.3125 | 5044.0 |
| 2019-12-11 08:25:00 | AAPL | Stock | 67.3375 | 67.3375 | 67.3375 | 67.3375 | 1524.0 |
| 2019-12-11 08:30:00 | AAPL | Stock | 67.3375 | 67.35 | 67.325 | 67.35 | 12340.0 |
| 2019-12-11 08:35:00 | AAPL | Stock | 67.375 | 67.375 | 67.335 | 67.375 | 19804.0 |
| 2019-12-11 08:40:00 | AAPL | Stock | 67.395 | 67.4075 | 67.375 | 67.4075 | 7240.0 |
| 2019-12-11 08:45:00 | AAPL | Stock | 67.4075 | 67.4375 | 67.4 | 67.435 | 40360.0 |
| 2019-12-11 08:50:00 | AAPL | Stock | 67.435 | 67.435 | 67.42 | 67.4268 | 9096.0 |
| 2019-12-11 08:55:00 | AAPL | Stock | 67.4 | 67.4 | 67.385 | 67.4 | 14080.0 |
| 2019-12-11 09:00:00 | AAPL | Stock | 67.3875 | 67.405 | 67.3875 | 67.3925 | 8980.0 |
| 2019-12-11 09:05:00 | AAPL | Stock | 67.3925 | 67.395 | 67.3625 | 67.3625 | 8940.0 |
| 2019-12-11 09:10:00 | AAPL | Stock | 67.375 | 67.375 | 67.3375 | 67.3375 | 11036.0 |
| 2019-12-11 09:15:00 | AAPL | Stock | 67.3375 | 67.35 | 67.335 | 67.3375 | 18428.0 |
| 2019-12-11 09:20:00 | AAPL | Stock | 67.35 | 67.35 | 67.335 | 67.35 | 41096.0 |
| 2019-12-11 09:25:00 | AAPL | Stock | 67.375 | 67.375 | 67.1925 | 67.2175 | 140868.0 |
| 2019-12-11 09:30:00 | AAPL | Stock | 67.2 | 67.425 | 67.125 | 67.31 | 3285704.0 |
> showing 50 of 365,010 rows — these rows as CSV