PREVIEW / etf_5min / 2016-02-17
file: by_date/etf_5min/2016/2016-02-17.parquet size: 1.2 MB rows: 51,962
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-17 04:00:00 | SPY | ETF | 189.72 | 189.72 | 189.59 | 189.64 | 1976.0 |
| 2016-02-17 04:05:00 | SPY | ETF | 189.78 | 189.97 | 189.78 | 189.9 | 2550.0 |
| 2016-02-17 04:10:00 | SPY | ETF | 189.95 | 189.95 | 189.91 | 189.91 | 1007.0 |
| 2016-02-17 04:15:00 | SPY | ETF | 190.01 | 190.05 | 190.0 | 190.0 | 2515.0 |
| 2016-02-17 04:20:00 | SPY | ETF | 190.0 | 190.0 | 189.9 | 189.98 | 2870.0 |
| 2016-02-17 04:25:00 | SPY | ETF | 190.0 | 190.03 | 190.0 | 190.03 | 850.0 |
| 2016-02-17 04:30:00 | SPY | ETF | 190.1 | 190.23 | 190.1 | 190.14 | 2075.0 |
| 2016-02-17 04:35:00 | SPY | ETF | 190.2 | 190.5 | 190.2 | 190.33 | 2427.0 |
| 2016-02-17 04:40:00 | SPY | ETF | 190.35 | 190.35 | 190.25 | 190.25 | 205.0 |
| 2016-02-17 04:45:00 | SPY | ETF | 190.18 | 190.27 | 190.18 | 190.27 | 620.0 |
| 2016-02-17 04:50:00 | SPY | ETF | 190.31 | 190.31 | 190.23 | 190.26 | 1800.0 |
| 2016-02-17 04:55:00 | SPY | ETF | 190.18 | 190.33 | 190.18 | 190.33 | 4700.0 |
| 2016-02-17 05:00:00 | SPY | ETF | 190.4 | 190.5 | 190.33 | 190.39 | 2450.0 |
| 2016-02-17 05:05:00 | SPY | ETF | 190.4 | 190.4 | 190.34 | 190.35 | 900.0 |
| 2016-02-17 05:10:00 | SPY | ETF | 190.34 | 190.45 | 190.34 | 190.38 | 700.0 |
| 2016-02-17 05:15:00 | SPY | ETF | 190.4 | 190.44 | 190.38 | 190.44 | 11150.0 |
| 2016-02-17 05:20:00 | SPY | ETF | 190.55 | 190.58 | 190.5 | 190.56 | 2918.0 |
| 2016-02-17 05:25:00 | SPY | ETF | 190.59 | 190.74 | 190.57 | 190.68 | 4417.0 |
| 2016-02-17 05:30:00 | SPY | ETF | 190.69 | 190.73 | 190.65 | 190.69 | 16630.0 |
| 2016-02-17 05:35:00 | SPY | ETF | 190.68 | 190.79 | 190.65 | 190.75 | 7786.0 |
| 2016-02-17 05:40:00 | SPY | ETF | 190.76 | 190.96 | 190.76 | 190.93 | 11035.0 |
| 2016-02-17 05:45:00 | SPY | ETF | 190.9 | 190.9 | 190.83 | 190.83 | 2365.0 |
| 2016-02-17 05:50:00 | SPY | ETF | 190.84 | 190.84 | 190.63 | 190.65 | 3700.0 |
| 2016-02-17 05:55:00 | SPY | ETF | 190.69 | 190.75 | 190.65 | 190.7 | 20235.0 |
| 2016-02-17 06:00:00 | SPY | ETF | 190.7 | 190.7 | 190.64 | 190.66 | 1900.0 |
| 2016-02-17 06:05:00 | SPY | ETF | 190.73 | 190.75 | 190.7 | 190.7 | 5450.0 |
| 2016-02-17 06:10:00 | SPY | ETF | 190.78 | 190.78 | 190.75 | 190.75 | 1400.0 |
| 2016-02-17 06:15:00 | SPY | ETF | 190.79 | 190.84 | 190.79 | 190.84 | 680.0 |
| 2016-02-17 06:20:00 | SPY | ETF | 190.83 | 190.83 | 190.75 | 190.75 | 8715.0 |
| 2016-02-17 06:25:00 | SPY | ETF | 190.78 | 190.8 | 190.64 | 190.66 | 5300.0 |
| 2016-02-17 06:30:00 | SPY | ETF | 190.63 | 190.79 | 190.63 | 190.79 | 2043.0 |
| 2016-02-17 06:35:00 | SPY | ETF | 190.76 | 190.76 | 190.66 | 190.73 | 7940.0 |
| 2016-02-17 06:40:00 | SPY | ETF | 190.73 | 190.75 | 190.69 | 190.75 | 59277.0 |
| 2016-02-17 06:45:00 | SPY | ETF | 190.75 | 190.85 | 190.75 | 190.85 | 41485.0 |
| 2016-02-17 06:50:00 | SPY | ETF | 190.82 | 190.83 | 190.8 | 190.82 | 5100.0 |
| 2016-02-17 06:55:00 | SPY | ETF | 190.82 | 190.84 | 190.78 | 190.8 | 3815.0 |
| 2016-02-17 07:00:00 | SPY | ETF | 190.77 | 190.83 | 190.72 | 190.74 | 119431.0 |
| 2016-02-17 07:05:00 | SPY | ETF | 190.72 | 190.8 | 190.66 | 190.8 | 32149.0 |
| 2016-02-17 07:10:00 | SPY | ETF | 190.78 | 190.78 | 190.75 | 190.77 | 3805.0 |
| 2016-02-17 07:15:00 | SPY | ETF | 190.78 | 190.79 | 190.68 | 190.78 | 14635.0 |
| 2016-02-17 07:20:00 | SPY | ETF | 190.77 | 190.8 | 190.76 | 190.8 | 12220.0 |
| 2016-02-17 07:25:00 | SPY | ETF | 190.77 | 190.78 | 190.73 | 190.78 | 7420.0 |
| 2016-02-17 07:30:00 | SPY | ETF | 190.78 | 190.88 | 190.78 | 190.8 | 29788.0 |
| 2016-02-17 07:35:00 | SPY | ETF | 190.78 | 190.86 | 190.78 | 190.84 | 63505.0 |
| 2016-02-17 07:40:00 | SPY | ETF | 190.85 | 190.94 | 190.85 | 190.91 | 7955.0 |
| 2016-02-17 07:45:00 | SPY | ETF | 190.89 | 191.01 | 190.85 | 191.01 | 125196.0 |
| 2016-02-17 07:50:00 | SPY | ETF | 191.0 | 191.05 | 190.94 | 190.98 | 51773.0 |
| 2016-02-17 07:55:00 | SPY | ETF | 191.0 | 191.13 | 190.95 | 191.11 | 160429.0 |
| 2016-02-17 08:00:00 | SPY | ETF | 191.1 | 191.13 | 190.75 | 190.9 | 120223.0 |
| 2016-02-17 08:05:00 | SPY | ETF | 190.94 | 190.98 | 190.81 | 190.85 | 103101.0 |
> showing 50 of 51,962 rows — these rows as CSV