PREVIEW / stock_5min / 2018-01-30
file: by_date/stock_5min/2018/2018-01-30.parquet size: 5.9 MB rows: 377,340 symbols: 2,895
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-01-30 04:00:00 | AAPL | Stock | 42.0 | 42.0 | 41.8025 | 41.805 | 1200.0 |
| 2018-01-30 04:50:00 | AAPL | Stock | 41.775 | 41.775 | 41.775 | 41.775 | 400.0 |
| 2018-01-30 04:55:00 | AAPL | Stock | 41.7775 | 41.8 | 41.7775 | 41.8 | 3992.0 |
| 2018-01-30 05:15:00 | AAPL | Stock | 41.775 | 41.775 | 41.7275 | 41.7275 | 27232.0 |
| 2018-01-30 05:25:00 | AAPL | Stock | 41.7 | 41.7175 | 41.6825 | 41.6825 | 7260.0 |
| 2018-01-30 05:30:00 | AAPL | Stock | 41.685 | 41.6875 | 41.6725 | 41.675 | 9324.0 |
| 2018-01-30 05:35:00 | AAPL | Stock | 41.65 | 41.65 | 41.625 | 41.625 | 8652.0 |
| 2018-01-30 05:40:00 | AAPL | Stock | 41.53 | 41.55 | 41.53 | 41.55 | 2000.0 |
| 2018-01-30 05:45:00 | AAPL | Stock | 41.5525 | 41.5525 | 41.52 | 41.52 | 9252.0 |
| 2018-01-30 05:50:00 | AAPL | Stock | 41.6 | 41.6 | 41.575 | 41.575 | 2792.0 |
| 2018-01-30 06:00:00 | AAPL | Stock | 41.595 | 41.6 | 41.595 | 41.6 | 10260.0 |
| 2018-01-30 06:05:00 | AAPL | Stock | 41.59 | 41.59 | 41.5875 | 41.5875 | 800.0 |
| 2018-01-30 06:10:00 | AAPL | Stock | 41.575 | 41.59 | 41.5375 | 41.5375 | 10368.0 |
| 2018-01-30 06:15:00 | AAPL | Stock | 41.55 | 41.55 | 41.55 | 41.55 | 1600.0 |
| 2018-01-30 06:20:00 | AAPL | Stock | 41.5475 | 41.5475 | 41.5075 | 41.5275 | 10868.0 |
| 2018-01-30 06:25:00 | AAPL | Stock | 41.5475 | 41.55 | 41.5475 | 41.55 | 7260.0 |
| 2018-01-30 06:30:00 | AAPL | Stock | 41.55 | 41.5675 | 41.53 | 41.5675 | 5600.0 |
| 2018-01-30 06:35:00 | AAPL | Stock | 41.5825 | 41.5825 | 41.5825 | 41.5825 | 1200.0 |
| 2018-01-30 06:40:00 | AAPL | Stock | 41.575 | 41.6225 | 41.575 | 41.6125 | 14020.0 |
| 2018-01-30 06:45:00 | AAPL | Stock | 41.625 | 41.66 | 41.6 | 41.6 | 33008.0 |
| 2018-01-30 06:50:00 | AAPL | Stock | 41.6225 | 41.6525 | 41.6125 | 41.6125 | 10392.0 |
| 2018-01-30 06:55:00 | AAPL | Stock | 41.6025 | 41.6425 | 41.6025 | 41.6425 | 2800.0 |
| 2018-01-30 07:00:00 | AAPL | Stock | 41.6225 | 41.6675 | 41.6225 | 41.65 | 31640.0 |
| 2018-01-30 07:05:00 | AAPL | Stock | 41.6475 | 41.65 | 41.575 | 41.59 | 42692.0 |
| 2018-01-30 07:10:00 | AAPL | Stock | 41.5875 | 41.6 | 41.5875 | 41.59 | 10312.0 |
| 2018-01-30 07:15:00 | AAPL | Stock | 41.5875 | 41.5875 | 41.5625 | 41.5625 | 10220.0 |
| 2018-01-30 07:20:00 | AAPL | Stock | 41.56 | 41.56 | 41.525 | 41.5375 | 23784.0 |
| 2018-01-30 07:25:00 | AAPL | Stock | 41.5375 | 41.55 | 41.53 | 41.5375 | 16160.0 |
| 2018-01-30 07:30:00 | AAPL | Stock | 41.53 | 41.53 | 41.4525 | 41.4525 | 37128.0 |
| 2018-01-30 07:35:00 | AAPL | Stock | 41.4625 | 41.4875 | 41.415 | 41.45 | 51592.0 |
| 2018-01-30 07:40:00 | AAPL | Stock | 41.4375 | 41.45 | 41.4175 | 41.425 | 45476.0 |
| 2018-01-30 07:45:00 | AAPL | Stock | 41.4225 | 41.4375 | 41.4125 | 41.425 | 22184.0 |
| 2018-01-30 07:50:00 | AAPL | Stock | 41.41 | 41.4975 | 41.375 | 41.4775 | 71860.0 |
| 2018-01-30 07:55:00 | AAPL | Stock | 41.4725 | 41.4775 | 41.4125 | 41.425 | 25320.0 |
| 2018-01-30 08:00:00 | AAPL | Stock | 41.475 | 41.6975 | 41.3775 | 41.5 | 258868.0 |
| 2018-01-30 08:05:00 | AAPL | Stock | 41.5 | 41.54 | 41.455 | 41.475 | 78372.0 |
| 2018-01-30 08:10:00 | AAPL | Stock | 41.4625 | 41.5125 | 41.445 | 41.49 | 182244.0 |
| 2018-01-30 08:15:00 | AAPL | Stock | 41.475 | 41.5125 | 41.475 | 41.5 | 30480.0 |
| 2018-01-30 08:20:00 | AAPL | Stock | 41.5 | 41.5125 | 41.45 | 41.5125 | 154640.0 |
| 2018-01-30 08:25:00 | AAPL | Stock | 41.5125 | 41.5475 | 41.5075 | 41.52 | 111144.0 |
| 2018-01-30 08:30:00 | AAPL | Stock | 41.5125 | 41.555 | 41.5 | 41.5375 | 47200.0 |
| 2018-01-30 08:35:00 | AAPL | Stock | 41.53 | 41.5725 | 41.5275 | 41.56 | 56936.0 |
| 2018-01-30 08:40:00 | AAPL | Stock | 41.5475 | 41.565 | 41.525 | 41.565 | 50064.0 |
| 2018-01-30 08:45:00 | AAPL | Stock | 41.5725 | 41.5725 | 41.5125 | 41.525 | 38668.0 |
| 2018-01-30 08:50:00 | AAPL | Stock | 41.525 | 41.525 | 41.4275 | 41.475 | 85328.0 |
| 2018-01-30 08:55:00 | AAPL | Stock | 41.475 | 41.495 | 41.4375 | 41.445 | 63632.0 |
| 2018-01-30 09:00:00 | AAPL | Stock | 41.4725 | 41.475 | 41.3825 | 41.4575 | 197052.0 |
| 2018-01-30 09:05:00 | AAPL | Stock | 41.475 | 41.5 | 41.4625 | 41.485 | 89480.0 |
| 2018-01-30 09:10:00 | AAPL | Stock | 41.4825 | 41.4875 | 41.4175 | 41.4175 | 98244.0 |
| 2018-01-30 09:15:00 | AAPL | Stock | 41.4075 | 41.4325 | 41.375 | 41.38 | 120372.0 |
> showing 50 of 377,340 rows — these rows as CSV