PREVIEW / stock_5min / 2010-07-07
file: by_date/stock_5min/2010/2010-07-07.parquet size: 4.8 MB rows: 330,265 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-07 05:30:00 | AAPL | Stock | 8.85 | 8.85 | 8.85 | 8.85 | 2800.0 |
| 2010-07-07 05:50:00 | AAPL | Stock | 8.8661 | 8.8661 | 8.8661 | 8.8661 | 2800.0 |
| 2010-07-07 06:05:00 | AAPL | Stock | 8.8661 | 8.8661 | 8.8661 | 8.8661 | 2800.0 |
| 2010-07-07 06:15:00 | AAPL | Stock | 8.8661 | 8.8661 | 8.8661 | 8.8661 | 2800.0 |
| 2010-07-07 06:30:00 | AAPL | Stock | 8.8661 | 8.8661 | 8.8661 | 8.8661 | 2800.0 |
| 2010-07-07 06:45:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 5600.0 |
| 2010-07-07 06:50:00 | AAPL | Stock | 8.8796 | 8.8796 | 8.8796 | 8.8796 | 2800.0 |
| 2010-07-07 07:00:00 | AAPL | Stock | 8.8761 | 8.8761 | 8.875 | 8.875 | 57680.0 |
| 2010-07-07 07:05:00 | AAPL | Stock | 8.8696 | 8.8696 | 8.8696 | 8.8696 | 2800.0 |
| 2010-07-07 07:10:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 81200.0 |
| 2010-07-07 07:15:00 | AAPL | Stock | 8.8846 | 8.8846 | 8.875 | 8.875 | 5600.0 |
| 2010-07-07 07:25:00 | AAPL | Stock | 8.8796 | 8.8893 | 8.8796 | 8.8886 | 33600.0 |
| 2010-07-07 07:35:00 | AAPL | Stock | 8.89 | 8.89 | 8.89 | 8.89 | 8428.0 |
| 2010-07-07 07:45:00 | AAPL | Stock | 8.8829 | 8.8829 | 8.8829 | 8.8829 | 2800.0 |
| 2010-07-07 07:55:00 | AAPL | Stock | 8.8907 | 8.8929 | 8.8907 | 8.8911 | 8400.0 |
| 2010-07-07 08:00:00 | AAPL | Stock | 8.895 | 8.895 | 8.8857 | 8.8857 | 26460.0 |
| 2010-07-07 08:05:00 | AAPL | Stock | 8.8893 | 8.8929 | 8.8889 | 8.8889 | 85344.0 |
| 2010-07-07 08:10:00 | AAPL | Stock | 8.8889 | 8.8925 | 8.8768 | 8.8768 | 55160.0 |
| 2010-07-07 08:15:00 | AAPL | Stock | 8.8736 | 8.8746 | 8.8629 | 8.8679 | 89320.0 |
| 2010-07-07 08:20:00 | AAPL | Stock | 8.8664 | 8.8864 | 8.8661 | 8.8864 | 119728.0 |
| 2010-07-07 08:25:00 | AAPL | Stock | 8.8825 | 8.8875 | 8.875 | 8.875 | 174748.0 |
| 2010-07-07 08:30:00 | AAPL | Stock | 8.875 | 8.8975 | 8.875 | 8.8896 | 203000.0 |
| 2010-07-07 08:35:00 | AAPL | Stock | 8.8854 | 8.89 | 8.875 | 8.875 | 93240.0 |
| 2010-07-07 08:40:00 | AAPL | Stock | 8.8725 | 8.8786 | 8.865 | 8.8693 | 390656.0 |
| 2010-07-07 08:45:00 | AAPL | Stock | 8.8657 | 8.8821 | 8.8586 | 8.8754 | 349412.0 |
| 2010-07-07 08:50:00 | AAPL | Stock | 8.8796 | 8.8796 | 8.87 | 8.8793 | 333256.0 |
| 2010-07-07 08:55:00 | AAPL | Stock | 8.8786 | 8.8929 | 8.8786 | 8.8811 | 226212.0 |
| 2010-07-07 09:00:00 | AAPL | Stock | 8.8889 | 8.9025 | 8.8839 | 8.9014 | 223272.0 |
| 2010-07-07 09:05:00 | AAPL | Stock | 8.8996 | 8.9143 | 8.8964 | 8.9036 | 253036.0 |
| 2010-07-07 09:10:00 | AAPL | Stock | 8.9036 | 8.9271 | 8.9036 | 8.9254 | 461496.0 |
| 2010-07-07 09:15:00 | AAPL | Stock | 8.9246 | 8.9375 | 8.9179 | 8.925 | 508816.0 |
| 2010-07-07 09:20:00 | AAPL | Stock | 8.9243 | 8.9461 | 8.9196 | 8.9332 | 196364.0 |
| 2010-07-07 09:25:00 | AAPL | Stock | 8.9407 | 8.9529 | 8.9379 | 8.9454 | 504056.0 |
| 2010-07-07 09:30:00 | AAPL | Stock | 8.9461 | 8.9639 | 8.9196 | 8.958 | 24565184.0 |
| 2010-07-07 09:35:00 | AAPL | Stock | 8.9586 | 8.9879 | 8.955 | 8.958 | 19849228.0 |
| 2010-07-07 09:40:00 | AAPL | Stock | 8.958 | 8.9714 | 8.9443 | 8.9532 | 11152960.0 |
| 2010-07-07 09:45:00 | AAPL | Stock | 8.9536 | 8.9604 | 8.9286 | 8.9382 | 9485924.0 |
| 2010-07-07 09:50:00 | AAPL | Stock | 8.9379 | 8.9554 | 8.9361 | 8.955 | 7903112.0 |
| 2010-07-07 09:55:00 | AAPL | Stock | 8.955 | 8.9743 | 8.9547 | 8.9625 | 11886112.0 |
| 2010-07-07 10:00:00 | AAPL | Stock | 8.9632 | 9.0046 | 8.9611 | 9.0032 | 17143448.0 |
| 2010-07-07 10:05:00 | AAPL | Stock | 9.0026 | 9.0046 | 8.9896 | 8.9939 | 15327592.0 |
| 2010-07-07 10:10:00 | AAPL | Stock | 8.9939 | 9.0286 | 8.9893 | 9.0193 | 12807928.0 |
| 2010-07-07 10:15:00 | AAPL | Stock | 9.0182 | 9.0257 | 9.0029 | 9.0046 | 9114140.0 |
| 2010-07-07 10:20:00 | AAPL | Stock | 9.0043 | 9.0132 | 8.9864 | 9.005 | 11198880.0 |
| 2010-07-07 10:25:00 | AAPL | Stock | 9.0051 | 9.0164 | 8.9936 | 8.995 | 6185844.0 |
| 2010-07-07 10:30:00 | AAPL | Stock | 8.9964 | 9.0071 | 8.9907 | 8.9964 | 6565608.0 |
| 2010-07-07 10:35:00 | AAPL | Stock | 8.9968 | 9.0143 | 8.9936 | 9.0 | 7956872.0 |
| 2010-07-07 10:40:00 | AAPL | Stock | 9.0004 | 9.0125 | 8.9907 | 8.9936 | 6385288.0 |
| 2010-07-07 10:45:00 | AAPL | Stock | 8.9946 | 9.0268 | 8.9911 | 9.02 | 9160928.0 |
| 2010-07-07 10:50:00 | AAPL | Stock | 9.0227 | 9.0389 | 9.0121 | 9.0332 | 13953240.0 |
> showing 50 of 330,265 rows — these rows as CSV