PREVIEW / stock_5min / 2019-03-18
file: by_date/stock_5min/2019/2019-03-18.parquet size: 5.8 MB rows: 365,536 symbols: 2,663
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-03-18 04:05:00 | AAPL | Stock | 46.675 | 46.71 | 46.675 | 46.71 | 3200.0 |
| 2019-03-18 04:10:00 | AAPL | Stock | 46.71 | 46.71 | 46.71 | 46.71 | 684.0 |
| 2019-03-18 04:25:00 | AAPL | Stock | 46.6625 | 46.6625 | 46.6625 | 46.6625 | 2000.0 |
| 2019-03-18 04:40:00 | AAPL | Stock | 46.635 | 46.635 | 46.635 | 46.635 | 500.0 |
| 2019-03-18 04:45:00 | AAPL | Stock | 46.66 | 46.66 | 46.66 | 46.66 | 488.0 |
| 2019-03-18 05:00:00 | AAPL | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 1568.0 |
| 2019-03-18 05:20:00 | AAPL | Stock | 46.625 | 46.65 | 46.625 | 46.65 | 1600.0 |
| 2019-03-18 05:25:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 1988.0 |
| 2019-03-18 05:35:00 | AAPL | Stock | 46.605 | 46.605 | 46.605 | 46.605 | 1844.0 |
| 2019-03-18 05:55:00 | AAPL | Stock | 46.625 | 46.625 | 46.6225 | 46.6225 | 3588.0 |
| 2019-03-18 06:00:00 | AAPL | Stock | 46.62 | 46.6225 | 46.62 | 46.6225 | 4000.0 |
| 2019-03-18 06:10:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 992.0 |
| 2019-03-18 06:25:00 | AAPL | Stock | 46.5875 | 46.5875 | 46.5875 | 46.5875 | 400.0 |
| 2019-03-18 06:55:00 | AAPL | Stock | 46.5875 | 46.5875 | 46.525 | 46.525 | 2400.0 |
| 2019-03-18 07:00:00 | AAPL | Stock | 46.53 | 46.55 | 46.475 | 46.5225 | 25276.0 |
| 2019-03-18 07:05:00 | AAPL | Stock | 46.525 | 46.565 | 46.5125 | 46.565 | 6536.0 |
| 2019-03-18 07:10:00 | AAPL | Stock | 46.565 | 46.5975 | 46.565 | 46.5975 | 4092.0 |
| 2019-03-18 07:20:00 | AAPL | Stock | 46.595 | 46.6025 | 46.58 | 46.58 | 13364.0 |
| 2019-03-18 07:25:00 | AAPL | Stock | 46.5775 | 46.58 | 46.5675 | 46.575 | 30184.0 |
| 2019-03-18 07:30:00 | AAPL | Stock | 46.575 | 46.575 | 46.525 | 46.525 | 12952.0 |
| 2019-03-18 07:35:00 | AAPL | Stock | 46.525 | 46.53 | 46.525 | 46.525 | 5820.0 |
| 2019-03-18 07:40:00 | AAPL | Stock | 46.525 | 46.53 | 46.5 | 46.5 | 15520.0 |
| 2019-03-18 07:45:00 | AAPL | Stock | 46.5025 | 46.5025 | 46.48 | 46.49 | 34004.0 |
| 2019-03-18 07:50:00 | AAPL | Stock | 46.48 | 46.5 | 46.47 | 46.4875 | 7400.0 |
| 2019-03-18 07:55:00 | AAPL | Stock | 46.52 | 46.525 | 46.52 | 46.525 | 4800.0 |
| 2019-03-18 08:00:00 | AAPL | Stock | 46.525 | 46.6475 | 46.49 | 46.5375 | 136272.0 |
| 2019-03-18 08:05:00 | AAPL | Stock | 46.545 | 46.545 | 46.4675 | 46.4675 | 20868.0 |
| 2019-03-18 08:10:00 | AAPL | Stock | 46.4925 | 46.55 | 46.4875 | 46.4875 | 23552.0 |
| 2019-03-18 08:15:00 | AAPL | Stock | 46.5375 | 46.5375 | 46.5375 | 46.5375 | 828.0 |
| 2019-03-18 08:20:00 | AAPL | Stock | 46.5375 | 46.555 | 46.525 | 46.525 | 17840.0 |
| 2019-03-18 08:25:00 | AAPL | Stock | 46.53 | 46.53 | 46.47 | 46.505 | 20296.0 |
| 2019-03-18 08:30:00 | AAPL | Stock | 46.505 | 46.515 | 46.47 | 46.48 | 11524.0 |
| 2019-03-18 08:35:00 | AAPL | Stock | 46.475 | 46.55 | 46.475 | 46.525 | 36568.0 |
| 2019-03-18 08:40:00 | AAPL | Stock | 46.535 | 46.545 | 46.535 | 46.545 | 6760.0 |
| 2019-03-18 08:45:00 | AAPL | Stock | 46.525 | 46.53 | 46.52 | 46.52 | 5680.0 |
| 2019-03-18 08:50:00 | AAPL | Stock | 46.52 | 46.5495 | 46.5025 | 46.525 | 19600.0 |
| 2019-03-18 08:55:00 | AAPL | Stock | 46.5 | 46.5175 | 46.4875 | 46.5 | 20572.0 |
| 2019-03-18 09:00:00 | AAPL | Stock | 46.51 | 46.53 | 46.5 | 46.53 | 10416.0 |
| 2019-03-18 09:05:00 | AAPL | Stock | 46.52 | 46.52 | 46.4375 | 46.4375 | 44188.0 |
| 2019-03-18 09:10:00 | AAPL | Stock | 46.46 | 46.475 | 46.45 | 46.475 | 29936.0 |
| 2019-03-18 09:15:00 | AAPL | Stock | 46.475 | 46.475 | 46.43 | 46.43 | 37960.0 |
| 2019-03-18 09:20:00 | AAPL | Stock | 46.425 | 46.4325 | 46.375 | 46.4325 | 49028.0 |
| 2019-03-18 09:25:00 | AAPL | Stock | 46.4375 | 46.455 | 46.4 | 46.4325 | 77908.0 |
| 2019-03-18 09:30:00 | AAPL | Stock | 46.45 | 46.745 | 46.4475 | 46.614 | 4421084.0 |
| 2019-03-18 09:35:00 | AAPL | Stock | 46.6112 | 46.7175 | 46.5975 | 46.67 | 1712096.0 |
| 2019-03-18 09:40:00 | AAPL | Stock | 46.6725 | 46.79 | 46.6525 | 46.7625 | 2019876.0 |
| 2019-03-18 09:45:00 | AAPL | Stock | 46.7625 | 46.82 | 46.725 | 46.805 | 2639148.0 |
| 2019-03-18 09:50:00 | AAPL | Stock | 46.81 | 46.9115 | 46.8 | 46.8375 | 2564256.0 |
| 2019-03-18 09:55:00 | AAPL | Stock | 46.8375 | 46.8475 | 46.7625 | 46.8325 | 1704384.0 |
| 2019-03-18 10:00:00 | AAPL | Stock | 46.83 | 46.9125 | 46.8225 | 46.8775 | 2185020.0 |
> showing 50 of 365,536 rows — these rows as CSV