PREVIEW / stock_5min / 2019-04-22
file: by_date/stock_5min/2019/2019-04-22.parquet size: 5.6 MB rows: 352,486 symbols: 2,630
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-04-22 04:55:00 | AAPL | Stock | 50.9 | 50.9 | 50.9 | 50.9 | 400.0 |
| 2019-04-22 05:30:00 | AAPL | Stock | 50.825 | 50.825 | 50.825 | 50.825 | 400.0 |
| 2019-04-22 05:35:00 | AAPL | Stock | 50.8125 | 50.8125 | 50.8125 | 50.8125 | 400.0 |
| 2019-04-22 07:00:00 | AAPL | Stock | 50.8675 | 50.875 | 50.8675 | 50.875 | 6364.0 |
| 2019-04-22 07:05:00 | AAPL | Stock | 50.875 | 50.875 | 50.855 | 50.855 | 2560.0 |
| 2019-04-22 07:10:00 | AAPL | Stock | 50.8425 | 50.865 | 50.8375 | 50.8375 | 6444.0 |
| 2019-04-22 07:15:00 | AAPL | Stock | 50.8375 | 50.8625 | 50.8375 | 50.8375 | 2808.0 |
| 2019-04-22 07:20:00 | AAPL | Stock | 50.855 | 50.855 | 50.8275 | 50.8275 | 2936.0 |
| 2019-04-22 07:25:00 | AAPL | Stock | 50.825 | 50.825 | 50.8225 | 50.8225 | 2176.0 |
| 2019-04-22 07:30:00 | AAPL | Stock | 50.8125 | 50.825 | 50.8125 | 50.825 | 2988.0 |
| 2019-04-22 07:35:00 | AAPL | Stock | 50.8275 | 50.83 | 50.825 | 50.825 | 2744.0 |
| 2019-04-22 07:40:00 | AAPL | Stock | 50.825 | 50.825 | 50.825 | 50.825 | 1520.0 |
| 2019-04-22 07:45:00 | AAPL | Stock | 50.825 | 50.825 | 50.7825 | 50.7825 | 7796.0 |
| 2019-04-22 07:55:00 | AAPL | Stock | 50.8 | 50.8 | 50.8 | 50.8 | 2784.0 |
| 2019-04-22 08:00:00 | AAPL | Stock | 50.875 | 50.875 | 50.765 | 50.765 | 59484.0 |
| 2019-04-22 08:05:00 | AAPL | Stock | 50.7575 | 50.7875 | 50.7575 | 50.7875 | 13188.0 |
| 2019-04-22 08:10:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.775 | 50.7875 | 3200.0 |
| 2019-04-22 08:15:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.715 | 50.725 | 35880.0 |
| 2019-04-22 08:20:00 | AAPL | Stock | 50.745 | 50.75 | 50.7225 | 50.75 | 11932.0 |
| 2019-04-22 08:25:00 | AAPL | Stock | 50.76 | 50.7875 | 50.75 | 50.75 | 12136.0 |
| 2019-04-22 08:30:00 | AAPL | Stock | 50.75 | 50.75 | 50.7375 | 50.7375 | 4480.0 |
| 2019-04-22 08:35:00 | AAPL | Stock | 50.7375 | 50.745 | 50.7375 | 50.745 | 3720.0 |
| 2019-04-22 08:40:00 | AAPL | Stock | 50.7325 | 50.7475 | 50.7125 | 50.7225 | 39288.0 |
| 2019-04-22 08:45:00 | AAPL | Stock | 50.7225 | 50.7225 | 50.7125 | 50.7225 | 10704.0 |
| 2019-04-22 08:50:00 | AAPL | Stock | 50.715 | 50.715 | 50.69 | 50.7 | 39776.0 |
| 2019-04-22 08:55:00 | AAPL | Stock | 50.6925 | 50.6925 | 50.6875 | 50.6875 | 3804.0 |
| 2019-04-22 09:00:00 | AAPL | Stock | 50.7 | 50.7225 | 50.695 | 50.7125 | 19528.0 |
| 2019-04-22 09:05:00 | AAPL | Stock | 50.7225 | 50.7225 | 50.7 | 50.715 | 10944.0 |
| 2019-04-22 09:10:00 | AAPL | Stock | 50.71 | 50.74 | 50.71 | 50.74 | 48052.0 |
| 2019-04-22 09:15:00 | AAPL | Stock | 50.7175 | 50.73 | 50.7025 | 50.705 | 18500.0 |
| 2019-04-22 09:20:00 | AAPL | Stock | 50.71 | 50.7175 | 50.6925 | 50.7 | 12516.0 |
| 2019-04-22 09:25:00 | AAPL | Stock | 50.6975 | 50.71 | 50.675 | 50.6825 | 30008.0 |
| 2019-04-22 09:30:00 | AAPL | Stock | 50.665 | 51.0125 | 50.585 | 50.895 | 4880340.0 |
| 2019-04-22 09:35:00 | AAPL | Stock | 50.9072 | 51.025 | 50.8425 | 50.9925 | 1961288.0 |
| 2019-04-22 09:40:00 | AAPL | Stock | 50.985 | 51.0975 | 50.9375 | 50.97 | 1706348.0 |
| 2019-04-22 09:45:00 | AAPL | Stock | 50.9818 | 51.0 | 50.82 | 50.885 | 2000444.0 |
| 2019-04-22 09:50:00 | AAPL | Stock | 50.885 | 50.9 | 50.8275 | 50.83 | 917088.0 |
| 2019-04-22 09:55:00 | AAPL | Stock | 50.83 | 50.9175 | 50.8025 | 50.909 | 945824.0 |
| 2019-04-22 10:00:00 | AAPL | Stock | 50.9075 | 50.9092 | 50.815 | 50.8825 | 1016256.0 |
| 2019-04-22 10:05:00 | AAPL | Stock | 50.8875 | 50.9625 | 50.8713 | 50.94 | 961924.0 |
| 2019-04-22 10:10:00 | AAPL | Stock | 50.9427 | 50.945 | 50.9 | 50.9425 | 703172.0 |
| 2019-04-22 10:15:00 | AAPL | Stock | 50.9375 | 50.985 | 50.9275 | 50.95 | 718844.0 |
| 2019-04-22 10:20:00 | AAPL | Stock | 50.95 | 50.9825 | 50.9425 | 50.9575 | 397528.0 |
| 2019-04-22 10:25:00 | AAPL | Stock | 50.9575 | 51.04 | 50.9575 | 51.025 | 902772.0 |
| 2019-04-22 10:30:00 | AAPL | Stock | 51.025 | 51.03 | 50.98 | 51.03 | 541580.0 |
| 2019-04-22 10:35:00 | AAPL | Stock | 51.0312 | 51.0375 | 50.983 | 51.0025 | 375492.0 |
| 2019-04-22 10:40:00 | AAPL | Stock | 51.0075 | 51.0275 | 50.9675 | 50.9778 | 517620.0 |
| 2019-04-22 10:45:00 | AAPL | Stock | 50.9812 | 51.045 | 50.97 | 51.033 | 593316.0 |
| 2019-04-22 10:50:00 | AAPL | Stock | 51.0325 | 51.1075 | 51.0075 | 51.0975 | 659552.0 |
| 2019-04-22 10:55:00 | AAPL | Stock | 51.095 | 51.16 | 51.0725 | 51.1562 | 882084.0 |
> showing 50 of 352,486 rows — these rows as CSV