PREVIEW / etf_5min / 2017-08-25
file: by_date/etf_5min/2017/2017-08-25.parquet size: 1.2 MB rows: 50,082
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-08-25 04:10:00 | SPY | ETF | 244.46 | 244.46 | 244.45 | 244.45 | 200.0 |
| 2017-08-25 04:15:00 | SPY | ETF | 244.45 | 244.45 | 244.45 | 244.45 | 1735.0 |
| 2017-08-25 04:20:00 | SPY | ETF | 244.42 | 244.42 | 244.42 | 244.42 | 102.0 |
| 2017-08-25 04:25:00 | SPY | ETF | 244.45 | 244.45 | 244.45 | 244.45 | 1255.0 |
| 2017-08-25 04:30:00 | SPY | ETF | 244.45 | 244.45 | 244.45 | 244.45 | 105.0 |
| 2017-08-25 04:40:00 | SPY | ETF | 244.45 | 244.45 | 244.45 | 244.45 | 401.0 |
| 2017-08-25 04:55:00 | SPY | ETF | 244.45 | 244.45 | 244.4 | 244.4 | 713.0 |
| 2017-08-25 05:05:00 | SPY | ETF | 244.32 | 244.32 | 244.3 | 244.3 | 502.0 |
| 2017-08-25 05:10:00 | SPY | ETF | 244.33 | 244.33 | 244.3 | 244.3 | 502.0 |
| 2017-08-25 05:30:00 | SPY | ETF | 244.53 | 244.53 | 244.49 | 244.49 | 507.0 |
| 2017-08-25 05:45:00 | SPY | ETF | 244.52 | 244.52 | 244.52 | 244.52 | 101.0 |
| 2017-08-25 05:55:00 | SPY | ETF | 244.75 | 244.75 | 244.72 | 244.72 | 1731.0 |
| 2017-08-25 06:00:00 | SPY | ETF | 244.8 | 244.8 | 244.77 | 244.77 | 1197.0 |
| 2017-08-25 06:10:00 | SPY | ETF | 244.75 | 244.75 | 244.75 | 244.75 | 100.0 |
| 2017-08-25 06:15:00 | SPY | ETF | 244.77 | 244.79 | 244.77 | 244.79 | 1703.0 |
| 2017-08-25 06:20:00 | SPY | ETF | 244.83 | 244.83 | 244.82 | 244.83 | 5421.0 |
| 2017-08-25 06:35:00 | SPY | ETF | 244.78 | 244.78 | 244.78 | 244.78 | 378.0 |
| 2017-08-25 06:40:00 | SPY | ETF | 244.82 | 244.82 | 244.82 | 244.82 | 100.0 |
| 2017-08-25 06:45:00 | SPY | ETF | 244.85 | 244.93 | 244.85 | 244.9 | 5103.0 |
| 2017-08-25 06:50:00 | SPY | ETF | 244.85 | 244.87 | 244.85 | 244.87 | 27501.0 |
| 2017-08-25 06:55:00 | SPY | ETF | 244.92 | 244.93 | 244.92 | 244.93 | 8703.0 |
| 2017-08-25 07:00:00 | SPY | ETF | 244.97 | 245.06 | 244.96 | 245.0 | 44929.0 |
| 2017-08-25 07:05:00 | SPY | ETF | 245.0 | 245.02 | 244.96 | 244.96 | 9298.0 |
| 2017-08-25 07:10:00 | SPY | ETF | 244.95 | 244.95 | 244.89 | 244.91 | 45868.0 |
| 2017-08-25 07:15:00 | SPY | ETF | 244.92 | 244.93 | 244.9 | 244.93 | 3505.0 |
| 2017-08-25 07:20:00 | SPY | ETF | 244.93 | 244.94 | 244.91 | 244.94 | 32750.0 |
| 2017-08-25 07:25:00 | SPY | ETF | 244.96 | 244.96 | 244.92 | 244.92 | 3081.0 |
| 2017-08-25 07:30:00 | SPY | ETF | 244.92 | 244.96 | 244.92 | 244.96 | 2320.0 |
| 2017-08-25 07:35:00 | SPY | ETF | 244.96 | 244.96 | 244.94 | 244.94 | 2500.0 |
| 2017-08-25 07:40:00 | SPY | ETF | 244.98 | 245.08 | 244.98 | 245.07 | 20572.0 |
| 2017-08-25 07:45:00 | SPY | ETF | 245.05 | 245.09 | 245.05 | 245.08 | 12101.0 |
| 2017-08-25 07:50:00 | SPY | ETF | 245.09 | 245.15 | 245.09 | 245.15 | 39486.0 |
| 2017-08-25 07:55:00 | SPY | ETF | 245.15 | 245.15 | 245.09 | 245.09 | 17201.0 |
| 2017-08-25 08:00:00 | SPY | ETF | 245.08 | 245.09 | 244.93 | 245.04 | 26393.0 |
| 2017-08-25 08:05:00 | SPY | ETF | 245.04 | 245.04 | 245.0 | 245.02 | 24394.0 |
| 2017-08-25 08:10:00 | SPY | ETF | 245.02 | 245.06 | 245.0 | 245.06 | 59934.0 |
| 2017-08-25 08:15:00 | SPY | ETF | 245.05 | 245.07 | 244.99 | 245.01 | 21002.0 |
| 2017-08-25 08:20:00 | SPY | ETF | 244.99 | 244.99 | 244.92 | 244.92 | 22935.0 |
| 2017-08-25 08:25:00 | SPY | ETF | 244.92 | 244.98 | 244.92 | 244.96 | 9301.0 |
| 2017-08-25 08:30:00 | SPY | ETF | 244.98 | 245.02 | 244.91 | 244.92 | 30270.0 |
| 2017-08-25 08:35:00 | SPY | ETF | 244.92 | 244.92 | 244.89 | 244.92 | 13373.0 |
| 2017-08-25 08:40:00 | SPY | ETF | 244.94 | 244.96 | 244.9 | 244.91 | 93615.0 |
| 2017-08-25 08:45:00 | SPY | ETF | 244.9 | 244.94 | 244.86 | 244.89 | 153186.0 |
| 2017-08-25 08:50:00 | SPY | ETF | 244.88 | 244.93 | 244.87 | 244.93 | 37713.0 |
| 2017-08-25 08:55:00 | SPY | ETF | 244.92 | 245.01 | 244.92 | 244.99 | 31171.0 |
| 2017-08-25 09:00:00 | SPY | ETF | 244.99 | 245.01 | 244.96 | 245.0 | 32031.0 |
| 2017-08-25 09:05:00 | SPY | ETF | 245.01 | 245.04 | 244.97 | 245.04 | 169689.0 |
| 2017-08-25 09:10:00 | SPY | ETF | 245.03 | 245.04 | 244.96 | 244.97 | 38087.0 |
| 2017-08-25 09:15:00 | SPY | ETF | 244.97 | 244.97 | 244.89 | 244.92 | 72438.0 |
| 2017-08-25 09:20:00 | SPY | ETF | 244.91 | 244.95 | 244.9 | 244.9 | 14524.0 |
> showing 50 of 50,082 rows — these rows as CSV