PREVIEW / stock_5min / 2018-10-25
file: by_date/stock_5min/2018/2018-10-25.parquet size: 5.9 MB rows: 369,058 symbols: 2,762
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-25 04:00:00 | AAPL | Stock | 54.625 | 54.69 | 54.625 | 54.69 | 4040.0 |
| 2018-10-25 04:05:00 | AAPL | Stock | 54.5625 | 54.6875 | 54.5625 | 54.6875 | 800.0 |
| 2018-10-25 04:10:00 | AAPL | Stock | 54.615 | 54.615 | 54.58 | 54.58 | 800.0 |
| 2018-10-25 04:15:00 | AAPL | Stock | 54.655 | 54.655 | 54.655 | 54.655 | 2000.0 |
| 2018-10-25 04:25:00 | AAPL | Stock | 54.61 | 54.625 | 54.61 | 54.625 | 9480.0 |
| 2018-10-25 04:30:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 400.0 |
| 2018-10-25 04:35:00 | AAPL | Stock | 54.565 | 54.565 | 54.5625 | 54.5625 | 2800.0 |
| 2018-10-25 04:40:00 | AAPL | Stock | 54.5625 | 54.575 | 54.5 | 54.575 | 2688.0 |
| 2018-10-25 04:45:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 1600.0 |
| 2018-10-25 04:55:00 | AAPL | Stock | 54.6925 | 54.6925 | 54.6725 | 54.6725 | 800.0 |
| 2018-10-25 05:00:00 | AAPL | Stock | 54.675 | 54.75 | 54.675 | 54.75 | 5620.0 |
| 2018-10-25 05:05:00 | AAPL | Stock | 54.6475 | 54.6475 | 54.6475 | 54.6475 | 800.0 |
| 2018-10-25 05:25:00 | AAPL | Stock | 54.8225 | 54.8225 | 54.8225 | 54.8225 | 2060.0 |
| 2018-10-25 05:30:00 | AAPL | Stock | 54.8125 | 54.8125 | 54.8125 | 54.8125 | 800.0 |
| 2018-10-25 05:35:00 | AAPL | Stock | 54.8075 | 54.81 | 54.8075 | 54.81 | 6040.0 |
| 2018-10-25 05:40:00 | AAPL | Stock | 54.875 | 54.925 | 54.87 | 54.925 | 7732.0 |
| 2018-10-25 05:45:00 | AAPL | Stock | 54.8525 | 54.8525 | 54.8375 | 54.8375 | 800.0 |
| 2018-10-25 05:50:00 | AAPL | Stock | 54.8575 | 54.975 | 54.8575 | 54.97 | 5368.0 |
| 2018-10-25 05:55:00 | AAPL | Stock | 54.955 | 55.0 | 54.935 | 54.9875 | 9324.0 |
| 2018-10-25 06:00:00 | AAPL | Stock | 54.9875 | 54.9875 | 54.8575 | 54.8575 | 12280.0 |
| 2018-10-25 06:05:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 400.0 |
| 2018-10-25 06:10:00 | AAPL | Stock | 54.8375 | 54.9375 | 54.8275 | 54.9375 | 12904.0 |
| 2018-10-25 06:15:00 | AAPL | Stock | 54.8075 | 54.8725 | 54.8075 | 54.8725 | 4796.0 |
| 2018-10-25 06:20:00 | AAPL | Stock | 54.825 | 54.825 | 54.775 | 54.775 | 13324.0 |
| 2018-10-25 06:25:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 632.0 |
| 2018-10-25 06:30:00 | AAPL | Stock | 54.75 | 54.8125 | 54.75 | 54.8125 | 2672.0 |
| 2018-10-25 06:35:00 | AAPL | Stock | 54.7025 | 54.7025 | 54.7025 | 54.7025 | 952.0 |
| 2018-10-25 06:40:00 | AAPL | Stock | 54.71 | 54.75 | 54.7025 | 54.75 | 8360.0 |
| 2018-10-25 06:45:00 | AAPL | Stock | 54.8125 | 54.8125 | 54.805 | 54.805 | 2708.0 |
| 2018-10-25 06:55:00 | AAPL | Stock | 54.805 | 54.805 | 54.8 | 54.8 | 824.0 |
| 2018-10-25 07:00:00 | AAPL | Stock | 54.7325 | 54.805 | 54.625 | 54.6475 | 49032.0 |
| 2018-10-25 07:05:00 | AAPL | Stock | 54.6125 | 54.6875 | 54.5425 | 54.6875 | 45900.0 |
| 2018-10-25 07:10:00 | AAPL | Stock | 54.6825 | 54.7075 | 54.65 | 54.6975 | 24176.0 |
| 2018-10-25 07:15:00 | AAPL | Stock | 54.695 | 54.6975 | 54.65 | 54.65 | 23296.0 |
| 2018-10-25 07:20:00 | AAPL | Stock | 54.685 | 54.71 | 54.6625 | 54.6625 | 6980.0 |
| 2018-10-25 07:25:00 | AAPL | Stock | 54.6375 | 54.6625 | 54.6375 | 54.6625 | 5896.0 |
| 2018-10-25 07:30:00 | AAPL | Stock | 54.6625 | 54.7 | 54.6625 | 54.6625 | 45272.0 |
| 2018-10-25 07:35:00 | AAPL | Stock | 54.6675 | 54.6675 | 54.55 | 54.55 | 32120.0 |
| 2018-10-25 07:40:00 | AAPL | Stock | 54.525 | 54.5525 | 54.515 | 54.515 | 13960.0 |
| 2018-10-25 07:45:00 | AAPL | Stock | 54.5275 | 54.61 | 54.5175 | 54.61 | 9144.0 |
| 2018-10-25 07:50:00 | AAPL | Stock | 54.61 | 54.625 | 54.53 | 54.6225 | 36544.0 |
| 2018-10-25 07:55:00 | AAPL | Stock | 54.685 | 54.685 | 54.555 | 54.555 | 11408.0 |
| 2018-10-25 08:00:00 | AAPL | Stock | 54.715 | 54.7775 | 54.5 | 54.685 | 198492.0 |
| 2018-10-25 08:05:00 | AAPL | Stock | 54.6725 | 54.7175 | 54.58 | 54.675 | 45444.0 |
| 2018-10-25 08:10:00 | AAPL | Stock | 54.69 | 54.7 | 54.63 | 54.655 | 51640.0 |
| 2018-10-25 08:15:00 | AAPL | Stock | 54.655 | 54.655 | 54.6275 | 54.65 | 33316.0 |
| 2018-10-25 08:20:00 | AAPL | Stock | 54.63 | 54.675 | 54.575 | 54.5825 | 33620.0 |
| 2018-10-25 08:25:00 | AAPL | Stock | 54.5875 | 54.6475 | 54.585 | 54.6125 | 9968.0 |
| 2018-10-25 08:30:00 | AAPL | Stock | 54.5825 | 54.6475 | 54.5825 | 54.6275 | 7804.0 |
| 2018-10-25 08:35:00 | AAPL | Stock | 54.6 | 54.62 | 54.5 | 54.5025 | 81644.0 |
> showing 50 of 369,058 rows — these rows as CSV