PREVIEW / stock_5min / 2019-06-06
file: by_date/stock_5min/2019/2019-06-06.parquet size: 5.6 MB rows: 356,962 symbols: 2,606
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-06-06 04:15:00 | AAPL | Stock | 45.7575 | 45.7575 | 45.7575 | 45.7575 | 400.0 |
| 2019-06-06 04:25:00 | AAPL | Stock | 45.785 | 45.785 | 45.785 | 45.785 | 1992.0 |
| 2019-06-06 04:35:00 | AAPL | Stock | 45.85 | 45.85 | 45.83 | 45.85 | 6024.0 |
| 2019-06-06 04:50:00 | AAPL | Stock | 45.85 | 45.85 | 45.85 | 45.85 | 2736.0 |
| 2019-06-06 04:55:00 | AAPL | Stock | 45.85 | 45.85 | 45.85 | 45.85 | 1200.0 |
| 2019-06-06 05:05:00 | AAPL | Stock | 45.8025 | 45.8025 | 45.79 | 45.79 | 2112.0 |
| 2019-06-06 05:10:00 | AAPL | Stock | 45.8375 | 45.8375 | 45.8375 | 45.8375 | 2424.0 |
| 2019-06-06 05:30:00 | AAPL | Stock | 45.825 | 45.825 | 45.825 | 45.825 | 1536.0 |
| 2019-06-06 05:35:00 | AAPL | Stock | 45.8775 | 45.8775 | 45.8775 | 45.8775 | 2320.0 |
| 2019-06-06 05:45:00 | AAPL | Stock | 45.865 | 45.865 | 45.865 | 45.865 | 400.0 |
| 2019-06-06 06:00:00 | AAPL | Stock | 45.845 | 45.845 | 45.845 | 45.845 | 3936.0 |
| 2019-06-06 06:15:00 | AAPL | Stock | 45.85 | 45.85 | 45.85 | 45.85 | 800.0 |
| 2019-06-06 06:25:00 | AAPL | Stock | 45.85 | 45.85 | 45.84 | 45.84 | 2000.0 |
| 2019-06-06 06:30:00 | AAPL | Stock | 45.8675 | 45.87 | 45.865 | 45.865 | 1920.0 |
| 2019-06-06 06:35:00 | AAPL | Stock | 45.8425 | 45.8425 | 45.835 | 45.835 | 800.0 |
| 2019-06-06 06:45:00 | AAPL | Stock | 45.8425 | 45.8425 | 45.835 | 45.835 | 3120.0 |
| 2019-06-06 06:55:00 | AAPL | Stock | 45.8375 | 45.85 | 45.825 | 45.85 | 1884.0 |
| 2019-06-06 07:00:00 | AAPL | Stock | 45.85 | 45.8675 | 45.84 | 45.8675 | 12752.0 |
| 2019-06-06 07:10:00 | AAPL | Stock | 45.84 | 45.8625 | 45.825 | 45.8625 | 20272.0 |
| 2019-06-06 07:15:00 | AAPL | Stock | 45.875 | 45.895 | 45.875 | 45.895 | 4800.0 |
| 2019-06-06 07:20:00 | AAPL | Stock | 45.8825 | 45.8825 | 45.8575 | 45.8575 | 2524.0 |
| 2019-06-06 07:30:00 | AAPL | Stock | 45.9 | 45.9 | 45.8625 | 45.8875 | 10700.0 |
| 2019-06-06 07:35:00 | AAPL | Stock | 45.8875 | 45.8875 | 45.8575 | 45.8575 | 1988.0 |
| 2019-06-06 07:40:00 | AAPL | Stock | 45.8575 | 45.8575 | 45.8125 | 45.8375 | 8712.0 |
| 2019-06-06 07:45:00 | AAPL | Stock | 45.8625 | 45.8625 | 45.7875 | 45.7875 | 12408.0 |
| 2019-06-06 07:50:00 | AAPL | Stock | 45.8 | 45.8375 | 45.8 | 45.825 | 11000.0 |
| 2019-06-06 07:55:00 | AAPL | Stock | 45.85 | 45.88 | 45.8375 | 45.88 | 8628.0 |
| 2019-06-06 08:00:00 | AAPL | Stock | 45.865 | 45.9175 | 45.8 | 45.83 | 61452.0 |
| 2019-06-06 08:05:00 | AAPL | Stock | 45.815 | 45.815 | 45.81 | 45.8125 | 2792.0 |
| 2019-06-06 08:10:00 | AAPL | Stock | 45.8125 | 45.83 | 45.8 | 45.825 | 12408.0 |
| 2019-06-06 08:15:00 | AAPL | Stock | 45.8125 | 45.845 | 45.8 | 45.845 | 15224.0 |
| 2019-06-06 08:20:00 | AAPL | Stock | 45.82 | 45.875 | 45.82 | 45.875 | 31016.0 |
| 2019-06-06 08:25:00 | AAPL | Stock | 45.8575 | 45.885 | 45.8525 | 45.885 | 15308.0 |
| 2019-06-06 08:30:00 | AAPL | Stock | 45.8675 | 45.8875 | 45.825 | 45.8725 | 16880.0 |
| 2019-06-06 08:35:00 | AAPL | Stock | 45.8525 | 45.8825 | 45.825 | 45.8725 | 24232.0 |
| 2019-06-06 08:40:00 | AAPL | Stock | 45.875 | 45.895 | 45.7025 | 45.7025 | 56688.0 |
| 2019-06-06 08:45:00 | AAPL | Stock | 45.73 | 45.75 | 45.65 | 45.6525 | 34456.0 |
| 2019-06-06 08:50:00 | AAPL | Stock | 45.6275 | 45.67 | 45.58 | 45.67 | 29708.0 |
| 2019-06-06 08:55:00 | AAPL | Stock | 45.7075 | 45.7375 | 45.6875 | 45.6875 | 39460.0 |
| 2019-06-06 09:00:00 | AAPL | Stock | 45.6975 | 45.71 | 45.675 | 45.6975 | 36732.0 |
| 2019-06-06 09:05:00 | AAPL | Stock | 45.695 | 45.85 | 45.68 | 45.7975 | 46424.0 |
| 2019-06-06 09:10:00 | AAPL | Stock | 45.7875 | 45.7875 | 45.7525 | 45.7875 | 24916.0 |
| 2019-06-06 09:15:00 | AAPL | Stock | 45.825 | 45.825 | 45.7625 | 45.7625 | 15452.0 |
| 2019-06-06 09:20:00 | AAPL | Stock | 45.7675 | 45.8 | 45.7525 | 45.8 | 11004.0 |
| 2019-06-06 09:25:00 | AAPL | Stock | 45.8225 | 45.8225 | 45.725 | 45.78 | 23316.0 |
| 2019-06-06 09:30:00 | AAPL | Stock | 45.7725 | 45.88 | 45.64 | 45.8488 | 2973444.0 |
| 2019-06-06 09:35:00 | AAPL | Stock | 45.8525 | 45.975 | 45.7975 | 45.9425 | 1640752.0 |
| 2019-06-06 09:40:00 | AAPL | Stock | 45.9425 | 45.9475 | 45.675 | 45.7475 | 1883476.0 |
| 2019-06-06 09:45:00 | AAPL | Stock | 45.745 | 45.77 | 45.64 | 45.6765 | 1184524.0 |
| 2019-06-06 09:50:00 | AAPL | Stock | 45.68 | 45.725 | 45.5675 | 45.6358 | 1123448.0 |
> showing 50 of 356,962 rows — these rows as CSV