PREVIEW / stock_5min / 2018-09-19
file: by_date/stock_5min/2018/2018-09-19.parquet size: 5.7 MB rows: 359,837 symbols: 2,773
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-19 04:00:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 2400.0 |
| 2018-09-19 04:05:00 | AAPL | Stock | 54.6825 | 54.6825 | 54.6825 | 54.6825 | 480.0 |
| 2018-09-19 04:10:00 | AAPL | Stock | 54.6825 | 54.6825 | 54.6825 | 54.6825 | 7024.0 |
| 2018-09-19 04:55:00 | AAPL | Stock | 54.6625 | 54.6625 | 54.6625 | 54.6625 | 400.0 |
| 2018-09-19 05:40:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 1200.0 |
| 2018-09-19 06:00:00 | AAPL | Stock | 54.65 | 54.65 | 54.6475 | 54.6475 | 7612.0 |
| 2018-09-19 06:05:00 | AAPL | Stock | 54.66 | 54.6625 | 54.6475 | 54.6575 | 3784.0 |
| 2018-09-19 06:10:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 400.0 |
| 2018-09-19 06:15:00 | AAPL | Stock | 54.675 | 54.71 | 54.64 | 54.64 | 5348.0 |
| 2018-09-19 06:45:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 464.0 |
| 2018-09-19 07:00:00 | AAPL | Stock | 54.685 | 54.71 | 54.65 | 54.6625 | 24688.0 |
| 2018-09-19 07:05:00 | AAPL | Stock | 54.645 | 54.69 | 54.6 | 54.6025 | 36332.0 |
| 2018-09-19 07:10:00 | AAPL | Stock | 54.6425 | 54.65 | 54.6 | 54.6 | 9624.0 |
| 2018-09-19 07:15:00 | AAPL | Stock | 54.5925 | 54.6175 | 54.5925 | 54.6175 | 5156.0 |
| 2018-09-19 07:20:00 | AAPL | Stock | 54.6225 | 54.65 | 54.6225 | 54.65 | 1336.0 |
| 2018-09-19 07:25:00 | AAPL | Stock | 54.65 | 54.65 | 54.6 | 54.6 | 2400.0 |
| 2018-09-19 07:30:00 | AAPL | Stock | 54.6 | 54.6 | 54.575 | 54.575 | 2144.0 |
| 2018-09-19 07:35:00 | AAPL | Stock | 54.57 | 54.575 | 54.5275 | 54.5375 | 7736.0 |
| 2018-09-19 07:40:00 | AAPL | Stock | 54.54 | 54.55 | 54.54 | 54.55 | 2392.0 |
| 2018-09-19 07:50:00 | AAPL | Stock | 54.5525 | 54.5525 | 54.5275 | 54.5275 | 3008.0 |
| 2018-09-19 07:55:00 | AAPL | Stock | 54.525 | 54.5275 | 54.525 | 54.525 | 1200.0 |
| 2018-09-19 08:00:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.5325 | 54.5625 | 52892.0 |
| 2018-09-19 08:05:00 | AAPL | Stock | 54.55 | 54.55 | 54.4625 | 54.4625 | 32844.0 |
| 2018-09-19 08:10:00 | AAPL | Stock | 54.4875 | 54.525 | 54.4725 | 54.4975 | 16452.0 |
| 2018-09-19 08:15:00 | AAPL | Stock | 54.4775 | 54.5 | 54.4625 | 54.5 | 22936.0 |
| 2018-09-19 08:20:00 | AAPL | Stock | 54.5 | 54.525 | 54.5 | 54.515 | 37780.0 |
| 2018-09-19 08:25:00 | AAPL | Stock | 54.5325 | 54.56 | 54.5325 | 54.5375 | 21464.0 |
| 2018-09-19 08:30:00 | AAPL | Stock | 54.5425 | 54.595 | 54.5375 | 54.575 | 32668.0 |
| 2018-09-19 08:35:00 | AAPL | Stock | 54.57 | 54.585 | 54.525 | 54.5325 | 16052.0 |
| 2018-09-19 08:40:00 | AAPL | Stock | 54.54 | 54.5625 | 54.54 | 54.56 | 11572.0 |
| 2018-09-19 08:45:00 | AAPL | Stock | 54.5325 | 54.5575 | 54.525 | 54.55 | 6720.0 |
| 2018-09-19 08:50:00 | AAPL | Stock | 54.5725 | 54.5925 | 54.5675 | 54.5775 | 13228.0 |
| 2018-09-19 08:55:00 | AAPL | Stock | 54.5775 | 54.625 | 54.575 | 54.625 | 41172.0 |
| 2018-09-19 09:00:00 | AAPL | Stock | 54.625 | 54.6275 | 54.6025 | 54.6025 | 11984.0 |
| 2018-09-19 09:05:00 | AAPL | Stock | 54.6025 | 54.6125 | 54.5775 | 54.6125 | 16236.0 |
| 2018-09-19 09:10:00 | AAPL | Stock | 54.6125 | 54.6525 | 54.58 | 54.6525 | 35248.0 |
| 2018-09-19 09:15:00 | AAPL | Stock | 54.6775 | 54.6875 | 54.6425 | 54.6575 | 30124.0 |
| 2018-09-19 09:20:00 | AAPL | Stock | 54.6625 | 54.6675 | 54.6375 | 54.6425 | 37592.0 |
| 2018-09-19 09:25:00 | AAPL | Stock | 54.6625 | 54.67 | 54.6 | 54.605 | 23156.0 |
| 2018-09-19 09:30:00 | AAPL | Stock | 54.625 | 54.905 | 54.5775 | 54.5825 | 3226724.0 |
| 2018-09-19 09:35:00 | AAPL | Stock | 54.5875 | 54.63 | 54.4475 | 54.4525 | 2383684.0 |
| 2018-09-19 09:40:00 | AAPL | Stock | 54.4525 | 54.4538 | 54.1775 | 54.2112 | 2965764.0 |
| 2018-09-19 09:45:00 | AAPL | Stock | 54.2112 | 54.3975 | 54.15 | 54.305 | 2615936.0 |
| 2018-09-19 09:50:00 | AAPL | Stock | 54.3 | 54.31 | 54.1875 | 54.2125 | 1533996.0 |
| 2018-09-19 09:55:00 | AAPL | Stock | 54.215 | 54.215 | 54.0515 | 54.0888 | 2838820.0 |
| 2018-09-19 10:00:00 | AAPL | Stock | 54.0898 | 54.22 | 54.0675 | 54.15 | 2217272.0 |
| 2018-09-19 10:05:00 | AAPL | Stock | 54.15 | 54.1725 | 54.0125 | 54.02 | 2260920.0 |
| 2018-09-19 10:10:00 | AAPL | Stock | 54.02 | 54.025 | 53.88 | 53.9425 | 3422028.0 |
| 2018-09-19 10:15:00 | AAPL | Stock | 53.9412 | 53.9475 | 53.825 | 53.87 | 2297460.0 |
| 2018-09-19 10:20:00 | AAPL | Stock | 53.865 | 54.1375 | 53.8382 | 54.1275 | 2541880.0 |
> showing 50 of 359,837 rows — these rows as CSV