PREVIEW / stock_5min / 2018-10-15
file: by_date/stock_5min/2018/2018-10-15.parquet size: 5.7 MB rows: 361,513 symbols: 2,767
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-15 04:00:00 | AAPL | Stock | 55.195 | 55.195 | 55.12 | 55.12 | 2688.0 |
| 2018-10-15 04:10:00 | AAPL | Stock | 55.1525 | 55.1525 | 55.1075 | 55.1075 | 896.0 |
| 2018-10-15 04:15:00 | AAPL | Stock | 55.075 | 55.075 | 55.0275 | 55.0275 | 5252.0 |
| 2018-10-15 04:20:00 | AAPL | Stock | 54.9575 | 54.9575 | 54.925 | 54.925 | 2840.0 |
| 2018-10-15 04:30:00 | AAPL | Stock | 54.9025 | 54.9025 | 54.8725 | 54.8725 | 800.0 |
| 2018-10-15 04:35:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 680.0 |
| 2018-10-15 04:40:00 | AAPL | Stock | 54.9625 | 54.9625 | 54.9625 | 54.9625 | 600.0 |
| 2018-10-15 04:50:00 | AAPL | Stock | 54.825 | 54.875 | 54.825 | 54.825 | 5060.0 |
| 2018-10-15 04:55:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 600.0 |
| 2018-10-15 05:20:00 | AAPL | Stock | 55.0 | 55.0375 | 55.0 | 55.0375 | 4520.0 |
| 2018-10-15 05:45:00 | AAPL | Stock | 55.05 | 55.05 | 55.05 | 55.05 | 864.0 |
| 2018-10-15 05:50:00 | AAPL | Stock | 55.05 | 55.05 | 55.0 | 55.0 | 7164.0 |
| 2018-10-15 06:00:00 | AAPL | Stock | 55.0625 | 55.0625 | 55.0625 | 55.0625 | 1800.0 |
| 2018-10-15 06:05:00 | AAPL | Stock | 55.1 | 55.1 | 55.075 | 55.075 | 3600.0 |
| 2018-10-15 06:10:00 | AAPL | Stock | 55.055 | 55.055 | 55.055 | 55.055 | 2000.0 |
| 2018-10-15 06:15:00 | AAPL | Stock | 55.075 | 55.075 | 55.0025 | 55.0025 | 11160.0 |
| 2018-10-15 06:30:00 | AAPL | Stock | 54.98 | 54.9825 | 54.9575 | 54.9575 | 4800.0 |
| 2018-10-15 06:35:00 | AAPL | Stock | 54.955 | 54.955 | 54.9475 | 54.9475 | 2000.0 |
| 2018-10-15 06:40:00 | AAPL | Stock | 54.9475 | 54.9475 | 54.92 | 54.92 | 14392.0 |
| 2018-10-15 06:45:00 | AAPL | Stock | 54.9225 | 54.97 | 54.9225 | 54.9675 | 4620.0 |
| 2018-10-15 06:50:00 | AAPL | Stock | 54.96 | 54.96 | 54.9375 | 54.9375 | 3300.0 |
| 2018-10-15 06:55:00 | AAPL | Stock | 54.9475 | 54.9575 | 54.9425 | 54.9575 | 1600.0 |
| 2018-10-15 07:00:00 | AAPL | Stock | 54.9575 | 54.97 | 54.93 | 54.9625 | 23444.0 |
| 2018-10-15 07:05:00 | AAPL | Stock | 54.96 | 55.125 | 54.9475 | 55.125 | 42320.0 |
| 2018-10-15 07:10:00 | AAPL | Stock | 55.1475 | 55.2 | 55.1425 | 55.15 | 24540.0 |
| 2018-10-15 07:15:00 | AAPL | Stock | 55.2 | 55.225 | 55.175 | 55.175 | 32768.0 |
| 2018-10-15 07:20:00 | AAPL | Stock | 55.1625 | 55.2975 | 55.16 | 55.25 | 38656.0 |
| 2018-10-15 07:25:00 | AAPL | Stock | 55.275 | 55.315 | 55.25 | 55.315 | 33704.0 |
| 2018-10-15 07:30:00 | AAPL | Stock | 55.295 | 55.315 | 55.2375 | 55.2375 | 48296.0 |
| 2018-10-15 07:35:00 | AAPL | Stock | 55.25 | 55.35 | 55.25 | 55.35 | 42668.0 |
| 2018-10-15 07:40:00 | AAPL | Stock | 55.35 | 55.3875 | 55.3275 | 55.385 | 58580.0 |
| 2018-10-15 07:45:00 | AAPL | Stock | 55.3825 | 55.4125 | 55.3625 | 55.4125 | 23156.0 |
| 2018-10-15 07:50:00 | AAPL | Stock | 55.4125 | 55.4475 | 55.375 | 55.375 | 34396.0 |
| 2018-10-15 07:55:00 | AAPL | Stock | 55.375 | 55.4375 | 55.3375 | 55.3375 | 44308.0 |
| 2018-10-15 08:00:00 | AAPL | Stock | 54.9325 | 55.4475 | 54.9312 | 55.3975 | 124776.0 |
| 2018-10-15 08:05:00 | AAPL | Stock | 55.3875 | 55.3875 | 55.325 | 55.325 | 29884.0 |
| 2018-10-15 08:10:00 | AAPL | Stock | 55.3275 | 55.425 | 55.3125 | 55.4 | 31512.0 |
| 2018-10-15 08:15:00 | AAPL | Stock | 55.3825 | 55.3975 | 55.35 | 55.3725 | 53528.0 |
| 2018-10-15 08:20:00 | AAPL | Stock | 55.3725 | 55.4225 | 55.335 | 55.4225 | 28288.0 |
| 2018-10-15 08:25:00 | AAPL | Stock | 55.425 | 55.4475 | 55.4 | 55.41 | 41228.0 |
| 2018-10-15 08:30:00 | AAPL | Stock | 55.4475 | 55.4475 | 55.3375 | 55.3375 | 42904.0 |
| 2018-10-15 08:35:00 | AAPL | Stock | 55.3275 | 55.35 | 55.2875 | 55.2875 | 48144.0 |
| 2018-10-15 08:40:00 | AAPL | Stock | 55.275 | 55.3 | 55.2575 | 55.275 | 25132.0 |
| 2018-10-15 08:45:00 | AAPL | Stock | 55.2775 | 55.2975 | 55.2025 | 55.225 | 127044.0 |
| 2018-10-15 08:50:00 | AAPL | Stock | 55.225 | 55.325 | 55.225 | 55.2875 | 34412.0 |
| 2018-10-15 08:55:00 | AAPL | Stock | 55.275 | 55.31 | 55.27 | 55.28 | 23140.0 |
| 2018-10-15 09:00:00 | AAPL | Stock | 55.3 | 55.355 | 55.295 | 55.3 | 78728.0 |
| 2018-10-15 09:05:00 | AAPL | Stock | 55.325 | 55.325 | 55.225 | 55.225 | 49880.0 |
| 2018-10-15 09:10:00 | AAPL | Stock | 55.22 | 55.245 | 55.1875 | 55.1875 | 53240.0 |
| 2018-10-15 09:15:00 | AAPL | Stock | 55.19 | 55.21 | 55.1525 | 55.17 | 68620.0 |
> showing 50 of 361,513 rows — these rows as CSV