PREVIEW / stock_5min / 2018-04-13
file: by_date/stock_5min/2018/2018-04-13.parquet size: 5.3 MB rows: 347,577 symbols: 2,854
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-04-13 04:05:00 | AAPL | Stock | 43.4975 | 43.4975 | 43.4975 | 43.4975 | 1592.0 |
| 2018-04-13 04:20:00 | AAPL | Stock | 43.495 | 43.495 | 43.495 | 43.495 | 4000.0 |
| 2018-04-13 06:05:00 | AAPL | Stock | 43.58 | 43.5825 | 43.58 | 43.5825 | 4800.0 |
| 2018-04-13 06:25:00 | AAPL | Stock | 43.5825 | 43.5825 | 43.5825 | 43.5825 | 2640.0 |
| 2018-04-13 06:40:00 | AAPL | Stock | 43.5825 | 43.5825 | 43.5825 | 43.5825 | 676.0 |
| 2018-04-13 06:50:00 | AAPL | Stock | 43.5975 | 43.6 | 43.5975 | 43.6 | 832.0 |
| 2018-04-13 06:55:00 | AAPL | Stock | 43.6025 | 43.6025 | 43.6025 | 43.6025 | 400.0 |
| 2018-04-13 07:00:00 | AAPL | Stock | 43.605 | 43.635 | 43.6 | 43.635 | 16740.0 |
| 2018-04-13 07:05:00 | AAPL | Stock | 43.66 | 43.6625 | 43.63 | 43.6325 | 11800.0 |
| 2018-04-13 07:10:00 | AAPL | Stock | 43.63 | 43.635 | 43.6275 | 43.6275 | 7600.0 |
| 2018-04-13 07:15:00 | AAPL | Stock | 43.625 | 43.6375 | 43.6225 | 43.6375 | 16480.0 |
| 2018-04-13 07:20:00 | AAPL | Stock | 43.625 | 43.6375 | 43.625 | 43.6375 | 7720.0 |
| 2018-04-13 07:25:00 | AAPL | Stock | 43.65 | 43.6525 | 43.6375 | 43.6375 | 6468.0 |
| 2018-04-13 07:30:00 | AAPL | Stock | 43.6375 | 43.66 | 43.6375 | 43.66 | 1600.0 |
| 2018-04-13 07:35:00 | AAPL | Stock | 43.67 | 43.67 | 43.6275 | 43.63 | 22580.0 |
| 2018-04-13 07:40:00 | AAPL | Stock | 43.63 | 43.6475 | 43.63 | 43.6425 | 2800.0 |
| 2018-04-13 07:45:00 | AAPL | Stock | 43.64 | 43.64 | 43.64 | 43.64 | 980.0 |
| 2018-04-13 07:50:00 | AAPL | Stock | 43.6375 | 43.655 | 43.6375 | 43.655 | 3200.0 |
| 2018-04-13 07:55:00 | AAPL | Stock | 43.655 | 43.655 | 43.6375 | 43.6375 | 2400.0 |
| 2018-04-13 08:00:00 | AAPL | Stock | 43.6625 | 43.7 | 43.63 | 43.675 | 48624.0 |
| 2018-04-13 08:05:00 | AAPL | Stock | 43.69 | 43.69 | 43.675 | 43.6875 | 14040.0 |
| 2018-04-13 08:10:00 | AAPL | Stock | 43.6875 | 43.725 | 43.6875 | 43.725 | 44724.0 |
| 2018-04-13 08:15:00 | AAPL | Stock | 43.7225 | 43.7475 | 43.72 | 43.7475 | 26172.0 |
| 2018-04-13 08:20:00 | AAPL | Stock | 43.745 | 43.7475 | 43.745 | 43.7475 | 800.0 |
| 2018-04-13 08:25:00 | AAPL | Stock | 43.7375 | 43.7475 | 43.72 | 43.72 | 10192.0 |
| 2018-04-13 08:30:00 | AAPL | Stock | 43.73 | 43.7475 | 43.725 | 43.7325 | 20548.0 |
| 2018-04-13 08:35:00 | AAPL | Stock | 43.7375 | 43.7425 | 43.705 | 43.72 | 20436.0 |
| 2018-04-13 08:40:00 | AAPL | Stock | 43.7325 | 43.7425 | 43.7275 | 43.7275 | 8948.0 |
| 2018-04-13 08:45:00 | AAPL | Stock | 43.7275 | 43.7375 | 43.71 | 43.735 | 10808.0 |
| 2018-04-13 08:50:00 | AAPL | Stock | 43.735 | 43.735 | 43.715 | 43.73 | 6312.0 |
| 2018-04-13 08:55:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7175 | 43.73 | 15312.0 |
| 2018-04-13 09:00:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.725 | 43.7375 | 9020.0 |
| 2018-04-13 09:05:00 | AAPL | Stock | 43.725 | 43.7325 | 43.72 | 43.7325 | 2280.0 |
| 2018-04-13 09:10:00 | AAPL | Stock | 43.7275 | 43.74 | 43.72 | 43.72 | 6536.0 |
| 2018-04-13 09:15:00 | AAPL | Stock | 43.72 | 43.725 | 43.7175 | 43.7175 | 6580.0 |
| 2018-04-13 09:20:00 | AAPL | Stock | 43.7225 | 43.7225 | 43.6925 | 43.7 | 30932.0 |
| 2018-04-13 09:25:00 | AAPL | Stock | 43.6875 | 43.7325 | 43.6875 | 43.6975 | 48620.0 |
| 2018-04-13 09:30:00 | AAPL | Stock | 43.69 | 43.8875 | 43.69 | 43.8375 | 4650460.0 |
| 2018-04-13 09:35:00 | AAPL | Stock | 43.8388 | 43.8825 | 43.79 | 43.8575 | 2141676.0 |
| 2018-04-13 09:40:00 | AAPL | Stock | 43.855 | 43.96 | 43.8525 | 43.8875 | 2526100.0 |
| 2018-04-13 09:45:00 | AAPL | Stock | 43.89 | 43.9425 | 43.8528 | 43.8925 | 1339848.0 |
| 2018-04-13 09:50:00 | AAPL | Stock | 43.895 | 43.9125 | 43.825 | 43.835 | 1044740.0 |
| 2018-04-13 09:55:00 | AAPL | Stock | 43.8362 | 43.8425 | 43.78 | 43.8125 | 1464304.0 |
| 2018-04-13 10:00:00 | AAPL | Stock | 43.81 | 43.8225 | 43.7328 | 43.755 | 1481700.0 |
| 2018-04-13 10:05:00 | AAPL | Stock | 43.755 | 43.8025 | 43.615 | 43.645 | 1748368.0 |
| 2018-04-13 10:10:00 | AAPL | Stock | 43.6475 | 43.7 | 43.5962 | 43.66 | 1383652.0 |
| 2018-04-13 10:15:00 | AAPL | Stock | 43.6575 | 43.7212 | 43.65 | 43.7065 | 1428176.0 |
| 2018-04-13 10:20:00 | AAPL | Stock | 43.705 | 43.705 | 43.6175 | 43.63 | 1027112.0 |
| 2018-04-13 10:25:00 | AAPL | Stock | 43.6325 | 43.635 | 43.475 | 43.524 | 1376188.0 |
| 2018-04-13 10:30:00 | AAPL | Stock | 43.5225 | 43.6025 | 43.4625 | 43.5925 | 1164156.0 |
> showing 50 of 347,577 rows — these rows as CSV