PREVIEW / stock_5min / 2018-10-03
file: by_date/stock_5min/2018/2018-10-03.parquet size: 5.8 MB rows: 362,225 symbols: 2,794
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-03 04:00:00 | AAPL | Stock | 57.5 | 57.5575 | 57.5 | 57.5575 | 1704.0 |
| 2018-10-03 04:15:00 | AAPL | Stock | 57.5875 | 57.5875 | 57.5875 | 57.5875 | 800.0 |
| 2018-10-03 04:25:00 | AAPL | Stock | 57.5875 | 57.5875 | 57.5875 | 57.5875 | 1760.0 |
| 2018-10-03 04:30:00 | AAPL | Stock | 57.575 | 57.575 | 57.575 | 57.575 | 800.0 |
| 2018-10-03 04:45:00 | AAPL | Stock | 57.5875 | 57.5875 | 57.5875 | 57.5875 | 400.0 |
| 2018-10-03 04:50:00 | AAPL | Stock | 57.6125 | 57.6125 | 57.6125 | 57.6125 | 400.0 |
| 2018-10-03 05:00:00 | AAPL | Stock | 57.59 | 57.5925 | 57.5875 | 57.5875 | 5200.0 |
| 2018-10-03 05:05:00 | AAPL | Stock | 57.5625 | 57.5625 | 57.5375 | 57.5375 | 2400.0 |
| 2018-10-03 05:20:00 | AAPL | Stock | 57.5 | 57.525 | 57.5 | 57.525 | 2032.0 |
| 2018-10-03 05:35:00 | AAPL | Stock | 57.5275 | 57.5275 | 57.5275 | 57.5275 | 800.0 |
| 2018-10-03 05:45:00 | AAPL | Stock | 57.575 | 57.575 | 57.575 | 57.575 | 1200.0 |
| 2018-10-03 05:50:00 | AAPL | Stock | 57.575 | 57.575 | 57.575 | 57.575 | 1200.0 |
| 2018-10-03 05:55:00 | AAPL | Stock | 57.55 | 57.55 | 57.55 | 57.55 | 4000.0 |
| 2018-10-03 06:05:00 | AAPL | Stock | 57.575 | 57.575 | 57.5725 | 57.5725 | 1600.0 |
| 2018-10-03 06:25:00 | AAPL | Stock | 57.57 | 57.5725 | 57.57 | 57.5725 | 7620.0 |
| 2018-10-03 06:30:00 | AAPL | Stock | 57.545 | 57.545 | 57.5325 | 57.5325 | 1228.0 |
| 2018-10-03 06:35:00 | AAPL | Stock | 57.55 | 57.55 | 57.55 | 57.55 | 2000.0 |
| 2018-10-03 06:40:00 | AAPL | Stock | 57.55 | 57.55 | 57.55 | 57.55 | 800.0 |
| 2018-10-03 07:00:00 | AAPL | Stock | 57.525 | 57.5525 | 57.4625 | 57.5225 | 17676.0 |
| 2018-10-03 07:05:00 | AAPL | Stock | 57.525 | 57.5625 | 57.525 | 57.5625 | 10724.0 |
| 2018-10-03 07:10:00 | AAPL | Stock | 57.5625 | 57.5975 | 57.5625 | 57.5975 | 6508.0 |
| 2018-10-03 07:15:00 | AAPL | Stock | 57.5675 | 57.5725 | 57.5675 | 57.5725 | 1560.0 |
| 2018-10-03 07:20:00 | AAPL | Stock | 57.5675 | 57.5675 | 57.5675 | 57.5675 | 5928.0 |
| 2018-10-03 07:25:00 | AAPL | Stock | 57.58 | 57.58 | 57.58 | 57.58 | 7920.0 |
| 2018-10-03 07:30:00 | AAPL | Stock | 57.5675 | 57.575 | 57.545 | 57.55 | 12136.0 |
| 2018-10-03 07:35:00 | AAPL | Stock | 57.54 | 57.54 | 57.525 | 57.525 | 10096.0 |
| 2018-10-03 07:40:00 | AAPL | Stock | 57.535 | 57.57 | 57.535 | 57.57 | 10728.0 |
| 2018-10-03 07:45:00 | AAPL | Stock | 57.555 | 57.555 | 57.5275 | 57.5275 | 9200.0 |
| 2018-10-03 07:50:00 | AAPL | Stock | 57.5425 | 57.5425 | 57.5375 | 57.54 | 6536.0 |
| 2018-10-03 07:55:00 | AAPL | Stock | 57.5425 | 57.55 | 57.5425 | 57.55 | 7200.0 |
| 2018-10-03 08:00:00 | AAPL | Stock | 57.5 | 57.5925 | 57.4625 | 57.5625 | 116124.0 |
| 2018-10-03 08:05:00 | AAPL | Stock | 57.57 | 57.62 | 57.57 | 57.6175 | 42020.0 |
| 2018-10-03 08:10:00 | AAPL | Stock | 57.62 | 57.62 | 57.605 | 57.605 | 25176.0 |
| 2018-10-03 08:15:00 | AAPL | Stock | 57.605 | 57.65 | 57.6 | 57.65 | 43596.0 |
| 2018-10-03 08:20:00 | AAPL | Stock | 57.6375 | 57.6475 | 57.5825 | 57.59 | 29448.0 |
| 2018-10-03 08:25:00 | AAPL | Stock | 57.5825 | 57.6 | 57.5375 | 57.5375 | 38412.0 |
| 2018-10-03 08:30:00 | AAPL | Stock | 57.5375 | 57.5625 | 57.5375 | 57.5625 | 16696.0 |
| 2018-10-03 08:35:00 | AAPL | Stock | 57.575 | 57.5875 | 57.55 | 57.55 | 15176.0 |
| 2018-10-03 08:40:00 | AAPL | Stock | 57.565 | 57.6 | 57.565 | 57.6 | 17968.0 |
| 2018-10-03 08:45:00 | AAPL | Stock | 57.6125 | 57.6125 | 57.6 | 57.61 | 19676.0 |
| 2018-10-03 08:50:00 | AAPL | Stock | 57.6 | 57.6125 | 57.6 | 57.6125 | 11780.0 |
| 2018-10-03 08:55:00 | AAPL | Stock | 57.6175 | 57.62 | 57.605 | 57.61 | 10276.0 |
| 2018-10-03 09:00:00 | AAPL | Stock | 57.61 | 57.61 | 57.58 | 57.6075 | 28972.0 |
| 2018-10-03 09:05:00 | AAPL | Stock | 57.585 | 57.6075 | 57.585 | 57.5925 | 17008.0 |
| 2018-10-03 09:10:00 | AAPL | Stock | 57.5875 | 57.5975 | 57.575 | 57.5875 | 19096.0 |
| 2018-10-03 09:15:00 | AAPL | Stock | 57.59 | 57.605 | 57.59 | 57.6025 | 34492.0 |
| 2018-10-03 09:20:00 | AAPL | Stock | 57.595 | 57.7 | 57.545 | 57.545 | 72248.0 |
| 2018-10-03 09:25:00 | AAPL | Stock | 57.5375 | 57.5625 | 57.505 | 57.535 | 111716.0 |
| 2018-10-03 09:30:00 | AAPL | Stock | 57.5125 | 57.9175 | 57.445 | 57.8525 | 5723972.0 |
| 2018-10-03 09:35:00 | AAPL | Stock | 57.8525 | 57.88 | 57.785 | 57.84 | 2542896.0 |
> showing 50 of 362,225 rows — these rows as CSV