PREVIEW / stock_5min / 2018-09-10
file: by_date/stock_5min/2018/2018-09-10.parquet size: 5.5 MB rows: 353,013 symbols: 2,772
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-09-10 04:00:00 | AAPL | Stock | 55.25 | 55.475 | 55.25 | 55.475 | 4140.0 |
| 2018-09-10 04:05:00 | AAPL | Stock | 55.3625 | 55.425 | 55.3625 | 55.425 | 6536.0 |
| 2018-09-10 04:10:00 | AAPL | Stock | 55.45 | 55.45 | 55.45 | 55.45 | 856.0 |
| 2018-09-10 04:15:00 | AAPL | Stock | 55.375 | 55.3775 | 55.375 | 55.3775 | 4616.0 |
| 2018-09-10 04:20:00 | AAPL | Stock | 55.385 | 55.385 | 55.32 | 55.32 | 51464.0 |
| 2018-09-10 04:25:00 | AAPL | Stock | 55.32 | 55.32 | 55.28 | 55.3025 | 12392.0 |
| 2018-09-10 04:30:00 | AAPL | Stock | 55.3025 | 55.3025 | 55.2775 | 55.28 | 5360.0 |
| 2018-09-10 04:50:00 | AAPL | Stock | 55.375 | 55.375 | 55.375 | 55.375 | 3768.0 |
| 2018-09-10 05:15:00 | AAPL | Stock | 55.345 | 55.345 | 55.345 | 55.345 | 1900.0 |
| 2018-09-10 05:25:00 | AAPL | Stock | 55.335 | 55.335 | 55.335 | 55.335 | 2000.0 |
| 2018-09-10 05:30:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 2208.0 |
| 2018-09-10 05:35:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 400.0 |
| 2018-09-10 05:40:00 | AAPL | Stock | 55.255 | 55.255 | 55.25 | 55.25 | 2000.0 |
| 2018-09-10 05:45:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 800.0 |
| 2018-09-10 05:50:00 | AAPL | Stock | 55.2525 | 55.2525 | 55.25 | 55.25 | 1600.0 |
| 2018-09-10 06:05:00 | AAPL | Stock | 55.1775 | 55.1775 | 55.175 | 55.175 | 1600.0 |
| 2018-09-10 06:10:00 | AAPL | Stock | 55.2475 | 55.2475 | 55.2475 | 55.2475 | 400.0 |
| 2018-09-10 06:15:00 | AAPL | Stock | 55.3 | 55.365 | 55.3 | 55.365 | 10280.0 |
| 2018-09-10 06:20:00 | AAPL | Stock | 55.3725 | 55.375 | 55.35 | 55.35 | 13280.0 |
| 2018-09-10 06:25:00 | AAPL | Stock | 55.39 | 55.445 | 55.39 | 55.445 | 4428.0 |
| 2018-09-10 06:30:00 | AAPL | Stock | 55.4425 | 55.47 | 55.4425 | 55.47 | 14800.0 |
| 2018-09-10 06:35:00 | AAPL | Stock | 55.5 | 55.57 | 55.4475 | 55.4975 | 33288.0 |
| 2018-09-10 06:40:00 | AAPL | Stock | 55.475 | 55.5 | 55.45 | 55.5 | 14136.0 |
| 2018-09-10 06:45:00 | AAPL | Stock | 55.5 | 55.5 | 55.48 | 55.48 | 3616.0 |
| 2018-09-10 06:50:00 | AAPL | Stock | 55.47 | 55.5 | 55.47 | 55.5 | 11560.0 |
| 2018-09-10 06:55:00 | AAPL | Stock | 55.5075 | 55.5075 | 55.5 | 55.5 | 4240.0 |
| 2018-09-10 07:00:00 | AAPL | Stock | 55.48 | 55.5 | 55.445 | 55.5 | 39788.0 |
| 2018-09-10 07:05:00 | AAPL | Stock | 55.5 | 55.5625 | 55.5 | 55.5375 | 20288.0 |
| 2018-09-10 07:10:00 | AAPL | Stock | 55.525 | 55.55 | 55.525 | 55.545 | 14080.0 |
| 2018-09-10 07:15:00 | AAPL | Stock | 55.55 | 55.56 | 55.5475 | 55.5475 | 8900.0 |
| 2018-09-10 07:20:00 | AAPL | Stock | 55.5475 | 55.5875 | 55.5475 | 55.5875 | 14868.0 |
| 2018-09-10 07:25:00 | AAPL | Stock | 55.5925 | 55.61 | 55.5875 | 55.61 | 11112.0 |
| 2018-09-10 07:30:00 | AAPL | Stock | 55.6125 | 55.6125 | 55.575 | 55.5875 | 19544.0 |
| 2018-09-10 07:35:00 | AAPL | Stock | 55.5875 | 55.5875 | 55.5475 | 55.55 | 13336.0 |
| 2018-09-10 07:40:00 | AAPL | Stock | 55.5275 | 55.6125 | 55.525 | 55.6 | 55584.0 |
| 2018-09-10 07:45:00 | AAPL | Stock | 55.6 | 55.6 | 55.5875 | 55.5875 | 9680.0 |
| 2018-09-10 07:50:00 | AAPL | Stock | 55.6 | 55.6125 | 55.575 | 55.5875 | 19976.0 |
| 2018-09-10 07:55:00 | AAPL | Stock | 55.575 | 55.59 | 55.5625 | 55.575 | 6720.0 |
| 2018-09-10 08:00:00 | AAPL | Stock | 55.4875 | 55.6225 | 55.45 | 55.6225 | 143920.0 |
| 2018-09-10 08:05:00 | AAPL | Stock | 55.615 | 55.615 | 55.5875 | 55.5875 | 20448.0 |
| 2018-09-10 08:10:00 | AAPL | Stock | 55.5875 | 55.5875 | 55.5375 | 55.5425 | 35632.0 |
| 2018-09-10 08:15:00 | AAPL | Stock | 55.57 | 55.585 | 55.55 | 55.5625 | 29624.0 |
| 2018-09-10 08:20:00 | AAPL | Stock | 55.5725 | 55.6125 | 55.5625 | 55.6075 | 18648.0 |
| 2018-09-10 08:25:00 | AAPL | Stock | 55.5875 | 55.595 | 55.5575 | 55.595 | 30848.0 |
| 2018-09-10 08:30:00 | AAPL | Stock | 55.6175 | 55.6175 | 55.58 | 55.58 | 14964.0 |
| 2018-09-10 08:35:00 | AAPL | Stock | 55.575 | 55.575 | 55.525 | 55.5375 | 46212.0 |
| 2018-09-10 08:40:00 | AAPL | Stock | 55.5325 | 55.5525 | 55.475 | 55.4825 | 56344.0 |
| 2018-09-10 08:45:00 | AAPL | Stock | 55.485 | 55.5 | 55.46 | 55.4675 | 38556.0 |
| 2018-09-10 08:50:00 | AAPL | Stock | 55.46 | 55.495 | 55.46 | 55.4775 | 56816.0 |
| 2018-09-10 08:55:00 | AAPL | Stock | 55.475 | 55.495 | 55.465 | 55.465 | 70780.0 |
> showing 50 of 353,013 rows — these rows as CSV