PREVIEW / stock_5min / 2019-02-04
file: by_date/stock_5min/2019/2019-02-04.parquet size: 5.6 MB rows: 353,723 symbols: 2,657
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-04 04:50:00 | AAPL | Stock | 41.725 | 41.725 | 41.725 | 41.725 | 400.0 |
| 2019-02-04 04:55:00 | AAPL | Stock | 41.74 | 41.74 | 41.74 | 41.74 | 608.0 |
| 2019-02-04 05:00:00 | AAPL | Stock | 41.7575 | 41.79 | 41.7575 | 41.77 | 6328.0 |
| 2019-02-04 05:05:00 | AAPL | Stock | 41.7625 | 41.7625 | 41.7625 | 41.7625 | 800.0 |
| 2019-02-04 05:15:00 | AAPL | Stock | 41.7625 | 41.7625 | 41.75 | 41.75 | 800.0 |
| 2019-02-04 06:20:00 | AAPL | Stock | 41.76 | 41.7875 | 41.76 | 41.7875 | 1600.0 |
| 2019-02-04 06:25:00 | AAPL | Stock | 41.79 | 41.79 | 41.79 | 41.79 | 400.0 |
| 2019-02-04 06:40:00 | AAPL | Stock | 41.7625 | 41.7625 | 41.7575 | 41.7575 | 4000.0 |
| 2019-02-04 06:50:00 | AAPL | Stock | 41.7675 | 41.7675 | 41.7675 | 41.7675 | 800.0 |
| 2019-02-04 07:00:00 | AAPL | Stock | 41.7875 | 41.7875 | 41.7275 | 41.7725 | 18108.0 |
| 2019-02-04 07:05:00 | AAPL | Stock | 41.7875 | 41.7875 | 41.785 | 41.785 | 1492.0 |
| 2019-02-04 07:10:00 | AAPL | Stock | 41.7875 | 41.7875 | 41.775 | 41.775 | 8704.0 |
| 2019-02-04 07:15:00 | AAPL | Stock | 41.775 | 41.775 | 41.7525 | 41.7525 | 8448.0 |
| 2019-02-04 07:25:00 | AAPL | Stock | 41.765 | 41.765 | 41.7575 | 41.7625 | 2128.0 |
| 2019-02-04 07:30:00 | AAPL | Stock | 41.765 | 41.765 | 41.75 | 41.75 | 12948.0 |
| 2019-02-04 07:35:00 | AAPL | Stock | 41.73 | 41.7675 | 41.73 | 41.7675 | 5220.0 |
| 2019-02-04 07:40:00 | AAPL | Stock | 41.7675 | 41.7775 | 41.75 | 41.7625 | 19828.0 |
| 2019-02-04 07:45:00 | AAPL | Stock | 41.7625 | 41.765 | 41.7575 | 41.7625 | 3924.0 |
| 2019-02-04 07:50:00 | AAPL | Stock | 41.7675 | 41.7675 | 41.75 | 41.75 | 20208.0 |
| 2019-02-04 07:55:00 | AAPL | Stock | 41.7625 | 41.775 | 41.7625 | 41.775 | 2808.0 |
| 2019-02-04 08:00:00 | AAPL | Stock | 41.76 | 41.8 | 41.75 | 41.8 | 72336.0 |
| 2019-02-04 08:05:00 | AAPL | Stock | 41.7875 | 41.7975 | 41.75 | 41.75 | 29016.0 |
| 2019-02-04 08:10:00 | AAPL | Stock | 41.75 | 41.7625 | 41.7375 | 41.7625 | 29200.0 |
| 2019-02-04 08:15:00 | AAPL | Stock | 41.76 | 41.78 | 41.75 | 41.7775 | 15140.0 |
| 2019-02-04 08:20:00 | AAPL | Stock | 41.7825 | 41.7825 | 41.75 | 41.7725 | 27980.0 |
| 2019-02-04 08:25:00 | AAPL | Stock | 41.775 | 41.775 | 41.775 | 41.775 | 2200.0 |
| 2019-02-04 08:30:00 | AAPL | Stock | 41.7525 | 41.775 | 41.75 | 41.775 | 18696.0 |
| 2019-02-04 08:35:00 | AAPL | Stock | 41.75 | 41.75 | 41.69 | 41.7225 | 26600.0 |
| 2019-02-04 08:40:00 | AAPL | Stock | 41.705 | 41.705 | 41.6975 | 41.7 | 13988.0 |
| 2019-02-04 08:45:00 | AAPL | Stock | 41.7025 | 41.725 | 41.6875 | 41.71 | 14808.0 |
| 2019-02-04 08:50:00 | AAPL | Stock | 41.6875 | 41.7 | 41.6875 | 41.7 | 4400.0 |
| 2019-02-04 08:55:00 | AAPL | Stock | 41.7125 | 41.83 | 41.7125 | 41.825 | 45724.0 |
| 2019-02-04 09:00:00 | AAPL | Stock | 41.825 | 41.8375 | 41.7975 | 41.825 | 49264.0 |
| 2019-02-04 09:05:00 | AAPL | Stock | 41.825 | 41.8625 | 41.825 | 41.8525 | 49892.0 |
| 2019-02-04 09:10:00 | AAPL | Stock | 41.8625 | 41.87 | 41.825 | 41.84 | 57592.0 |
| 2019-02-04 09:15:00 | AAPL | Stock | 41.84 | 41.8488 | 41.8175 | 41.8275 | 69548.0 |
| 2019-02-04 09:20:00 | AAPL | Stock | 41.825 | 41.8375 | 41.825 | 41.835 | 20272.0 |
| 2019-02-04 09:25:00 | AAPL | Stock | 41.825 | 41.875 | 41.825 | 41.87 | 24036.0 |
| 2019-02-04 09:30:00 | AAPL | Stock | 41.87 | 42.075 | 41.82 | 42.0675 | 3859240.0 |
| 2019-02-04 09:35:00 | AAPL | Stock | 42.0675 | 42.16 | 42.0275 | 42.095 | 3102820.0 |
| 2019-02-04 09:40:00 | AAPL | Stock | 42.0975 | 42.1525 | 42.0025 | 42.0375 | 2190072.0 |
| 2019-02-04 09:45:00 | AAPL | Stock | 42.04 | 42.3 | 42.038 | 42.2875 | 3004844.0 |
| 2019-02-04 09:50:00 | AAPL | Stock | 42.2875 | 42.3475 | 42.255 | 42.3175 | 2826412.0 |
| 2019-02-04 09:55:00 | AAPL | Stock | 42.3125 | 42.455 | 42.2975 | 42.4425 | 2756976.0 |
| 2019-02-04 10:00:00 | AAPL | Stock | 42.4457 | 42.46 | 42.34 | 42.38 | 2430204.0 |
| 2019-02-04 10:05:00 | AAPL | Stock | 42.38 | 42.5575 | 42.3675 | 42.5475 | 3504644.0 |
| 2019-02-04 10:10:00 | AAPL | Stock | 42.545 | 42.61 | 42.485 | 42.605 | 3584564.0 |
| 2019-02-04 10:15:00 | AAPL | Stock | 42.6025 | 42.6262 | 42.5375 | 42.5475 | 2535968.0 |
| 2019-02-04 10:20:00 | AAPL | Stock | 42.5502 | 42.5702 | 42.4625 | 42.4765 | 2300344.0 |
| 2019-02-04 10:25:00 | AAPL | Stock | 42.475 | 42.5075 | 42.4375 | 42.5 | 1410604.0 |
> showing 50 of 353,723 rows — these rows as CSV