PREVIEW / etf_5min / 2017-02-28
file: by_date/etf_5min/2017/2017-02-28.parquet size: 1.3 MB rows: 55,799
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-28 04:00:00 | SPY | ETF | 236.94 | 236.94 | 236.94 | 236.94 | 250.0 |
| 2017-02-28 04:10:00 | SPY | ETF | 236.86 | 236.86 | 236.86 | 236.86 | 200.0 |
| 2017-02-28 04:20:00 | SPY | ETF | 236.92 | 236.92 | 236.92 | 236.92 | 400.0 |
| 2017-02-28 04:25:00 | SPY | ETF | 236.96 | 236.96 | 236.96 | 236.96 | 100.0 |
| 2017-02-28 04:40:00 | SPY | ETF | 236.93 | 236.93 | 236.93 | 236.93 | 100.0 |
| 2017-02-28 04:50:00 | SPY | ETF | 237.0 | 237.05 | 237.0 | 237.05 | 1500.0 |
| 2017-02-28 05:00:00 | SPY | ETF | 237.05 | 237.05 | 237.01 | 237.01 | 500.0 |
| 2017-02-28 05:10:00 | SPY | ETF | 236.96 | 236.96 | 236.96 | 236.96 | 100.0 |
| 2017-02-28 05:30:00 | SPY | ETF | 237.1 | 237.1 | 237.1 | 237.1 | 501.0 |
| 2017-02-28 05:55:00 | SPY | ETF | 236.9 | 236.9 | 236.9 | 236.9 | 204.0 |
| 2017-02-28 06:35:00 | SPY | ETF | 237.02 | 237.02 | 237.02 | 237.02 | 100.0 |
| 2017-02-28 06:40:00 | SPY | ETF | 237.06 | 237.06 | 237.04 | 237.04 | 403.0 |
| 2017-02-28 06:50:00 | SPY | ETF | 237.04 | 237.04 | 237.03 | 237.03 | 602.0 |
| 2017-02-28 06:55:00 | SPY | ETF | 237.03 | 237.04 | 237.03 | 237.04 | 1300.0 |
| 2017-02-28 07:05:00 | SPY | ETF | 237.01 | 237.01 | 236.98 | 236.98 | 2204.0 |
| 2017-02-28 07:10:00 | SPY | ETF | 237.0 | 237.0 | 237.0 | 237.0 | 100.0 |
| 2017-02-28 07:15:00 | SPY | ETF | 236.95 | 236.95 | 236.95 | 236.95 | 1464.0 |
| 2017-02-28 07:20:00 | SPY | ETF | 236.95 | 236.95 | 236.88 | 236.88 | 2393.0 |
| 2017-02-28 07:25:00 | SPY | ETF | 236.91 | 236.92 | 236.89 | 236.92 | 2058.0 |
| 2017-02-28 07:30:00 | SPY | ETF | 236.92 | 236.95 | 236.92 | 236.95 | 35002.0 |
| 2017-02-28 07:35:00 | SPY | ETF | 236.95 | 236.95 | 236.95 | 236.95 | 1100.0 |
| 2017-02-28 07:40:00 | SPY | ETF | 236.96 | 236.98 | 236.94 | 236.94 | 3212.0 |
| 2017-02-28 07:45:00 | SPY | ETF | 236.97 | 236.99 | 236.95 | 236.98 | 13098.0 |
| 2017-02-28 07:50:00 | SPY | ETF | 236.93 | 236.94 | 236.9 | 236.9 | 1354.0 |
| 2017-02-28 07:55:00 | SPY | ETF | 236.91 | 236.91 | 236.88 | 236.88 | 2168.0 |
| 2017-02-28 08:00:00 | SPY | ETF | 236.89 | 237.01 | 236.78 | 236.82 | 16117.0 |
| 2017-02-28 08:05:00 | SPY | ETF | 236.8 | 236.83 | 236.76 | 236.77 | 17380.0 |
| 2017-02-28 08:10:00 | SPY | ETF | 236.78 | 236.83 | 236.78 | 236.82 | 13633.0 |
| 2017-02-28 08:15:00 | SPY | ETF | 236.83 | 236.83 | 236.79 | 236.79 | 5868.0 |
| 2017-02-28 08:20:00 | SPY | ETF | 236.82 | 236.85 | 236.82 | 236.85 | 3315.0 |
| 2017-02-28 08:25:00 | SPY | ETF | 236.85 | 236.88 | 236.85 | 236.85 | 2046.0 |
| 2017-02-28 08:30:00 | SPY | ETF | 236.82 | 236.87 | 236.82 | 236.86 | 9670.0 |
| 2017-02-28 08:35:00 | SPY | ETF | 236.84 | 236.84 | 236.8 | 236.8 | 23030.0 |
| 2017-02-28 08:40:00 | SPY | ETF | 236.79 | 236.82 | 236.77 | 236.77 | 14246.0 |
| 2017-02-28 08:45:00 | SPY | ETF | 236.8 | 236.82 | 236.77 | 236.79 | 1964.0 |
| 2017-02-28 08:50:00 | SPY | ETF | 236.79 | 236.85 | 236.77 | 236.81 | 24740.0 |
| 2017-02-28 08:55:00 | SPY | ETF | 236.83 | 236.9 | 236.82 | 236.87 | 9856.0 |
| 2017-02-28 09:00:00 | SPY | ETF | 236.88 | 236.9 | 236.87 | 236.88 | 2937.0 |
| 2017-02-28 09:05:00 | SPY | ETF | 236.89 | 236.9 | 236.82 | 236.82 | 5520.0 |
| 2017-02-28 09:10:00 | SPY | ETF | 236.83 | 236.89 | 236.83 | 236.89 | 5767.0 |
| 2017-02-28 09:15:00 | SPY | ETF | 236.84 | 236.84 | 236.81 | 236.83 | 14549.0 |
| 2017-02-28 09:20:00 | SPY | ETF | 236.83 | 236.84 | 236.8 | 236.8 | 112865.0 |
| 2017-02-28 09:25:00 | SPY | ETF | 236.8 | 236.81 | 236.66 | 236.67 | 258775.0 |
| 2017-02-28 09:30:00 | SPY | ETF | 236.67 | 236.82 | 236.64 | 236.73 | 1690248.0 |
| 2017-02-28 09:35:00 | SPY | ETF | 236.73 | 236.79 | 236.69 | 236.72 | 619407.0 |
| 2017-02-28 09:40:00 | SPY | ETF | 236.72 | 236.84 | 236.69 | 236.79 | 815480.0 |
| 2017-02-28 09:45:00 | SPY | ETF | 236.7911 | 236.83 | 236.72 | 236.74 | 760948.0 |
| 2017-02-28 09:50:00 | SPY | ETF | 236.74 | 236.75 | 236.61 | 236.635 | 1740615.0 |
| 2017-02-28 09:55:00 | SPY | ETF | 236.63 | 236.71 | 236.62 | 236.6899 | 554296.0 |
| 2017-02-28 10:00:00 | SPY | ETF | 236.69 | 236.85 | 236.67 | 236.8 | 849901.0 |
> showing 50 of 55,799 rows — these rows as CSV