PREVIEW / etf_5min / 2012-02-06
file: by_date/etf_5min/2012/2012-02-06.parquet size: 873 KB rows: 37,579
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-06 04:00:00 | SPY | ETF | 134.1 | 134.1 | 133.7 | 133.73 | 4838.0 |
| 2012-02-06 04:05:00 | SPY | ETF | 133.65 | 133.75 | 133.59 | 133.6 | 2139.0 |
| 2012-02-06 04:10:00 | SPY | ETF | 133.58 | 133.59 | 133.56 | 133.57 | 33300.0 |
| 2012-02-06 04:15:00 | SPY | ETF | 133.55 | 133.55 | 133.51 | 133.51 | 33850.0 |
| 2012-02-06 04:20:00 | SPY | ETF | 133.54 | 133.59 | 133.54 | 133.59 | 200.0 |
| 2012-02-06 04:25:00 | SPY | ETF | 133.59 | 133.59 | 133.55 | 133.57 | 3500.0 |
| 2012-02-06 04:50:00 | SPY | ETF | 133.77 | 133.77 | 133.77 | 133.77 | 2700.0 |
| 2012-02-06 05:10:00 | SPY | ETF | 133.74 | 133.74 | 133.74 | 133.74 | 1200.0 |
| 2012-02-06 05:30:00 | SPY | ETF | 133.78 | 133.78 | 133.78 | 133.78 | 100.0 |
| 2012-02-06 05:35:00 | SPY | ETF | 133.74 | 133.74 | 133.74 | 133.74 | 200.0 |
| 2012-02-06 05:40:00 | SPY | ETF | 133.79 | 133.86 | 133.77 | 133.84 | 1551.0 |
| 2012-02-06 05:45:00 | SPY | ETF | 133.78 | 133.78 | 133.78 | 133.78 | 200.0 |
| 2012-02-06 05:50:00 | SPY | ETF | 133.72 | 133.75 | 133.72 | 133.74 | 3450.0 |
| 2012-02-06 06:10:00 | SPY | ETF | 133.8 | 133.8 | 133.8 | 133.8 | 100.0 |
| 2012-02-06 06:20:00 | SPY | ETF | 133.8 | 133.89 | 133.8 | 133.89 | 5450.0 |
| 2012-02-06 06:25:00 | SPY | ETF | 133.87 | 133.87 | 133.87 | 133.87 | 500.0 |
| 2012-02-06 06:30:00 | SPY | ETF | 133.87 | 133.87 | 133.84 | 133.84 | 1600.0 |
| 2012-02-06 06:35:00 | SPY | ETF | 133.94 | 133.94 | 133.89 | 133.89 | 8900.0 |
| 2012-02-06 06:40:00 | SPY | ETF | 133.88 | 133.88 | 133.8 | 133.8 | 12900.0 |
| 2012-02-06 06:45:00 | SPY | ETF | 133.81 | 133.81 | 133.71 | 133.71 | 6800.0 |
| 2012-02-06 06:50:00 | SPY | ETF | 133.7 | 133.71 | 133.64 | 133.64 | 35415.0 |
| 2012-02-06 06:55:00 | SPY | ETF | 133.69 | 133.84 | 133.67 | 133.79 | 4650.0 |
| 2012-02-06 07:00:00 | SPY | ETF | 133.8 | 133.88 | 133.77 | 133.88 | 7850.0 |
| 2012-02-06 07:05:00 | SPY | ETF | 133.88 | 133.9 | 133.87 | 133.87 | 26500.0 |
| 2012-02-06 07:10:00 | SPY | ETF | 133.9 | 133.9 | 133.85 | 133.9 | 4000.0 |
| 2012-02-06 07:15:00 | SPY | ETF | 133.92 | 133.96 | 133.9 | 133.96 | 27965.0 |
| 2012-02-06 07:20:00 | SPY | ETF | 133.97 | 134.06 | 133.97 | 134.04 | 17900.0 |
| 2012-02-06 07:25:00 | SPY | ETF | 134.05 | 134.06 | 134.02 | 134.03 | 65800.0 |
| 2012-02-06 07:30:00 | SPY | ETF | 134.03 | 134.05 | 133.94 | 133.99 | 110199.0 |
| 2012-02-06 07:35:00 | SPY | ETF | 134.0 | 134.03 | 133.97 | 133.97 | 79160.0 |
| 2012-02-06 07:40:00 | SPY | ETF | 133.98 | 133.98 | 133.9 | 133.98 | 94517.0 |
| 2012-02-06 07:45:00 | SPY | ETF | 133.98 | 134.05 | 133.98 | 134.03 | 232149.0 |
| 2012-02-06 07:50:00 | SPY | ETF | 134.04 | 134.04 | 133.95 | 133.96 | 47175.0 |
| 2012-02-06 07:55:00 | SPY | ETF | 133.95 | 134.0 | 133.93 | 134.0 | 8119.0 |
| 2012-02-06 08:00:00 | SPY | ETF | 133.97 | 134.03 | 133.92 | 133.95 | 62608.0 |
| 2012-02-06 08:05:00 | SPY | ETF | 133.96 | 134.0 | 133.94 | 133.97 | 32952.0 |
| 2012-02-06 08:10:00 | SPY | ETF | 133.98 | 133.98 | 133.87 | 133.88 | 53796.0 |
| 2012-02-06 08:15:00 | SPY | ETF | 133.87 | 133.95 | 133.85 | 133.95 | 61357.0 |
| 2012-02-06 08:20:00 | SPY | ETF | 133.95 | 133.98 | 133.88 | 133.9 | 111733.0 |
| 2012-02-06 08:25:00 | SPY | ETF | 133.9 | 133.95 | 133.87 | 133.9 | 7630.0 |
| 2012-02-06 08:30:00 | SPY | ETF | 133.91 | 133.97 | 133.88 | 133.93 | 60710.0 |
| 2012-02-06 08:35:00 | SPY | ETF | 133.91 | 133.91 | 133.82 | 133.84 | 111631.0 |
| 2012-02-06 08:40:00 | SPY | ETF | 133.86 | 133.88 | 133.74 | 133.82 | 146190.0 |
| 2012-02-06 08:45:00 | SPY | ETF | 133.82 | 133.87 | 133.8 | 133.81 | 76047.0 |
| 2012-02-06 08:50:00 | SPY | ETF | 133.81 | 133.84 | 133.8 | 133.83 | 70123.0 |
| 2012-02-06 08:55:00 | SPY | ETF | 133.82 | 133.86 | 133.72 | 133.72 | 82790.0 |
| 2012-02-06 09:00:00 | SPY | ETF | 133.73 | 133.83 | 133.71 | 133.81 | 143576.0 |
| 2012-02-06 09:05:00 | SPY | ETF | 133.8 | 133.92 | 133.78 | 133.89 | 97840.0 |
| 2012-02-06 09:10:00 | SPY | ETF | 133.88 | 133.95 | 133.86 | 133.9 | 180157.0 |
| 2012-02-06 09:15:00 | SPY | ETF | 133.9 | 133.99 | 133.9 | 133.98 | 79782.0 |
> showing 50 of 37,579 rows — these rows as CSV