PREVIEW / stock_5min / 2018-11-21
file: by_date/stock_5min/2018/2018-11-21.parquet size: 5.4 MB rows: 346,459 symbols: 2,716
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-11-21 04:00:00 | AAPL | Stock | 44.5125 | 44.6925 | 44.5125 | 44.6 | 12372.0 |
| 2018-11-21 04:05:00 | AAPL | Stock | 44.625 | 44.625 | 44.6 | 44.6125 | 4040.0 |
| 2018-11-21 04:10:00 | AAPL | Stock | 44.6725 | 44.6925 | 44.6725 | 44.6925 | 23700.0 |
| 2018-11-21 04:15:00 | AAPL | Stock | 44.725 | 44.725 | 44.6725 | 44.675 | 6536.0 |
| 2018-11-21 04:20:00 | AAPL | Stock | 44.675 | 44.675 | 44.675 | 44.675 | 400.0 |
| 2018-11-21 04:30:00 | AAPL | Stock | 44.665 | 44.665 | 44.665 | 44.665 | 5900.0 |
| 2018-11-21 04:35:00 | AAPL | Stock | 44.615 | 44.615 | 44.615 | 44.615 | 604.0 |
| 2018-11-21 04:40:00 | AAPL | Stock | 44.6 | 44.6 | 44.6 | 44.6 | 552.0 |
| 2018-11-21 04:45:00 | AAPL | Stock | 44.6 | 44.6575 | 44.6 | 44.6575 | 3924.0 |
| 2018-11-21 04:50:00 | AAPL | Stock | 44.625 | 44.65 | 44.625 | 44.65 | 8800.0 |
| 2018-11-21 04:55:00 | AAPL | Stock | 44.66 | 44.66 | 44.66 | 44.66 | 1560.0 |
| 2018-11-21 05:00:00 | AAPL | Stock | 44.6075 | 44.7 | 44.605 | 44.7 | 3284.0 |
| 2018-11-21 05:05:00 | AAPL | Stock | 44.675 | 44.6775 | 44.6725 | 44.6775 | 5596.0 |
| 2018-11-21 05:15:00 | AAPL | Stock | 44.6675 | 44.6875 | 44.6675 | 44.6875 | 11216.0 |
| 2018-11-21 05:40:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 560.0 |
| 2018-11-21 05:45:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 996.0 |
| 2018-11-21 05:50:00 | AAPL | Stock | 44.575 | 44.65 | 44.575 | 44.65 | 3760.0 |
| 2018-11-21 05:55:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.6375 | 44.6375 | 400.0 |
| 2018-11-21 06:00:00 | AAPL | Stock | 44.5575 | 44.5575 | 44.5575 | 44.5575 | 800.0 |
| 2018-11-21 06:05:00 | AAPL | Stock | 44.5525 | 44.5525 | 44.5525 | 44.5525 | 400.0 |
| 2018-11-21 06:15:00 | AAPL | Stock | 44.6175 | 44.625 | 44.6175 | 44.625 | 9900.0 |
| 2018-11-21 06:20:00 | AAPL | Stock | 44.65 | 44.7 | 44.65 | 44.7 | 1600.0 |
| 2018-11-21 06:25:00 | AAPL | Stock | 44.675 | 44.675 | 44.65 | 44.6625 | 3964.0 |
| 2018-11-21 06:35:00 | AAPL | Stock | 44.7125 | 44.7325 | 44.7125 | 44.7325 | 1200.0 |
| 2018-11-21 06:40:00 | AAPL | Stock | 44.715 | 44.725 | 44.7125 | 44.7125 | 2000.0 |
| 2018-11-21 06:45:00 | AAPL | Stock | 44.675 | 44.675 | 44.0725 | 44.2975 | 66208.0 |
| 2018-11-21 06:50:00 | AAPL | Stock | 44.28 | 44.3725 | 44.2475 | 44.3475 | 20016.0 |
| 2018-11-21 06:55:00 | AAPL | Stock | 44.3475 | 44.3725 | 44.075 | 44.075 | 38604.0 |
| 2018-11-21 07:00:00 | AAPL | Stock | 44.1225 | 44.4475 | 44.1225 | 44.4475 | 58996.0 |
| 2018-11-21 07:05:00 | AAPL | Stock | 44.4475 | 44.5 | 44.3475 | 44.4175 | 76028.0 |
| 2018-11-21 07:10:00 | AAPL | Stock | 44.45 | 44.4875 | 44.3125 | 44.3125 | 40292.0 |
| 2018-11-21 07:15:00 | AAPL | Stock | 44.3475 | 44.35 | 44.2675 | 44.3125 | 42324.0 |
| 2018-11-21 07:20:00 | AAPL | Stock | 44.3575 | 44.48 | 44.3575 | 44.4525 | 33656.0 |
| 2018-11-21 07:25:00 | AAPL | Stock | 44.4625 | 44.645 | 44.4075 | 44.6325 | 89512.0 |
| 2018-11-21 07:30:00 | AAPL | Stock | 44.625 | 44.625 | 44.525 | 44.6 | 39620.0 |
| 2018-11-21 07:35:00 | AAPL | Stock | 44.61 | 44.67 | 44.575 | 44.6625 | 97936.0 |
| 2018-11-21 07:40:00 | AAPL | Stock | 44.6725 | 44.7825 | 44.6625 | 44.7825 | 138596.0 |
| 2018-11-21 07:45:00 | AAPL | Stock | 44.775 | 44.8075 | 44.7525 | 44.7875 | 32932.0 |
| 2018-11-21 07:50:00 | AAPL | Stock | 44.7975 | 44.88 | 44.78 | 44.78 | 76188.0 |
| 2018-11-21 07:55:00 | AAPL | Stock | 44.7975 | 44.8075 | 44.715 | 44.775 | 72784.0 |
| 2018-11-21 08:00:00 | AAPL | Stock | 44.4238 | 44.8625 | 44.2488 | 44.81 | 215456.0 |
| 2018-11-21 08:05:00 | AAPL | Stock | 44.81 | 44.875 | 44.7875 | 44.8025 | 93360.0 |
| 2018-11-21 08:10:00 | AAPL | Stock | 44.8025 | 44.8325 | 44.3125 | 44.7625 | 145408.0 |
| 2018-11-21 08:15:00 | AAPL | Stock | 44.7625 | 44.8725 | 44.7625 | 44.855 | 96492.0 |
| 2018-11-21 08:20:00 | AAPL | Stock | 44.8425 | 44.8675 | 44.825 | 44.8675 | 122948.0 |
| 2018-11-21 08:25:00 | AAPL | Stock | 44.8675 | 44.91 | 44.775 | 44.8 | 123004.0 |
| 2018-11-21 08:30:00 | AAPL | Stock | 44.8225 | 44.83 | 44.725 | 44.75 | 111880.0 |
| 2018-11-21 08:35:00 | AAPL | Stock | 44.7375 | 44.7375 | 44.65 | 44.6525 | 132484.0 |
| 2018-11-21 08:40:00 | AAPL | Stock | 44.6625 | 44.775 | 44.655 | 44.735 | 156140.0 |
| 2018-11-21 08:45:00 | AAPL | Stock | 44.725 | 44.78 | 44.7025 | 44.7125 | 64340.0 |
> showing 50 of 346,459 rows — these rows as CSV