PREVIEW / etf_5min / 2016-02-16
file: by_date/etf_5min/2016/2016-02-16.parquet size: 1.2 MB rows: 52,811
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-16 04:00:00 | SPY | ETF | 189.47 | 189.49 | 188.91 | 188.94 | 40090.0 |
| 2016-02-16 04:05:00 | SPY | ETF | 188.96 | 189.0 | 188.82 | 188.89 | 6164.0 |
| 2016-02-16 04:10:00 | SPY | ETF | 188.9 | 188.9 | 188.64 | 188.82 | 8920.0 |
| 2016-02-16 04:15:00 | SPY | ETF | 188.91 | 189.11 | 188.91 | 189.04 | 3025.0 |
| 2016-02-16 04:20:00 | SPY | ETF | 189.0 | 189.1 | 189.0 | 189.1 | 3064.0 |
| 2016-02-16 04:25:00 | SPY | ETF | 189.07 | 189.22 | 189.07 | 189.22 | 3675.0 |
| 2016-02-16 04:30:00 | SPY | ETF | 189.24 | 189.4 | 189.15 | 189.35 | 4956.0 |
| 2016-02-16 04:35:00 | SPY | ETF | 189.32 | 189.34 | 189.24 | 189.29 | 8769.0 |
| 2016-02-16 04:40:00 | SPY | ETF | 189.3 | 189.3 | 189.09 | 189.11 | 3955.0 |
| 2016-02-16 04:45:00 | SPY | ETF | 189.0 | 189.0 | 188.95 | 188.95 | 2340.0 |
| 2016-02-16 04:50:00 | SPY | ETF | 188.9 | 188.9 | 188.73 | 188.73 | 19227.0 |
| 2016-02-16 04:55:00 | SPY | ETF | 188.67 | 188.71 | 188.67 | 188.68 | 3485.0 |
| 2016-02-16 05:00:00 | SPY | ETF | 188.82 | 188.89 | 188.54 | 188.56 | 13550.0 |
| 2016-02-16 05:05:00 | SPY | ETF | 188.52 | 188.57 | 188.45 | 188.52 | 7815.0 |
| 2016-02-16 05:10:00 | SPY | ETF | 188.45 | 188.6 | 188.42 | 188.59 | 4937.0 |
| 2016-02-16 05:15:00 | SPY | ETF | 188.59 | 188.65 | 188.53 | 188.58 | 5200.0 |
| 2016-02-16 05:20:00 | SPY | ETF | 188.66 | 188.73 | 188.66 | 188.72 | 405.0 |
| 2016-02-16 05:25:00 | SPY | ETF | 188.66 | 188.69 | 188.62 | 188.67 | 6245.0 |
| 2016-02-16 05:30:00 | SPY | ETF | 188.58 | 188.67 | 188.57 | 188.59 | 7251.0 |
| 2016-02-16 05:35:00 | SPY | ETF | 188.54 | 188.54 | 188.48 | 188.48 | 1745.0 |
| 2016-02-16 05:40:00 | SPY | ETF | 188.48 | 188.69 | 188.48 | 188.69 | 5740.0 |
| 2016-02-16 05:45:00 | SPY | ETF | 188.64 | 188.64 | 188.52 | 188.52 | 1100.0 |
| 2016-02-16 05:50:00 | SPY | ETF | 188.6 | 188.6 | 188.57 | 188.58 | 17936.0 |
| 2016-02-16 05:55:00 | SPY | ETF | 188.62 | 188.64 | 188.5 | 188.5 | 3265.0 |
| 2016-02-16 06:00:00 | SPY | ETF | 188.68 | 188.68 | 188.66 | 188.67 | 1100.0 |
| 2016-02-16 06:05:00 | SPY | ETF | 188.64 | 188.64 | 188.58 | 188.58 | 21500.0 |
| 2016-02-16 06:10:00 | SPY | ETF | 188.49 | 188.52 | 188.48 | 188.48 | 420.0 |
| 2016-02-16 06:15:00 | SPY | ETF | 188.58 | 188.64 | 188.58 | 188.62 | 3323.0 |
| 2016-02-16 06:20:00 | SPY | ETF | 188.65 | 188.72 | 188.65 | 188.72 | 1390.0 |
| 2016-02-16 06:25:00 | SPY | ETF | 188.71 | 188.71 | 188.51 | 188.51 | 400.0 |
| 2016-02-16 06:30:00 | SPY | ETF | 188.6 | 188.64 | 188.5 | 188.5 | 17600.0 |
| 2016-02-16 06:35:00 | SPY | ETF | 188.49 | 188.67 | 188.49 | 188.67 | 2400.0 |
| 2016-02-16 06:40:00 | SPY | ETF | 188.62 | 188.66 | 188.62 | 188.66 | 500.0 |
| 2016-02-16 06:45:00 | SPY | ETF | 188.58 | 188.7 | 188.5 | 188.69 | 8315.0 |
| 2016-02-16 06:50:00 | SPY | ETF | 188.73 | 188.73 | 188.67 | 188.67 | 6305.0 |
| 2016-02-16 06:55:00 | SPY | ETF | 188.7 | 189.04 | 188.7 | 189.04 | 11760.0 |
| 2016-02-16 07:00:00 | SPY | ETF | 189.04 | 189.04 | 188.86 | 188.94 | 37785.0 |
| 2016-02-16 07:05:00 | SPY | ETF | 188.99 | 189.1 | 188.98 | 189.04 | 24014.0 |
| 2016-02-16 07:10:00 | SPY | ETF | 188.99 | 189.12 | 188.91 | 189.09 | 9335.0 |
| 2016-02-16 07:15:00 | SPY | ETF | 189.05 | 189.12 | 189.01 | 189.09 | 13650.0 |
| 2016-02-16 07:20:00 | SPY | ETF | 189.08 | 189.1 | 188.98 | 188.98 | 14445.0 |
| 2016-02-16 07:25:00 | SPY | ETF | 188.95 | 189.09 | 188.95 | 189.04 | 19644.0 |
| 2016-02-16 07:30:00 | SPY | ETF | 189.05 | 189.1 | 188.95 | 188.98 | 17785.0 |
| 2016-02-16 07:35:00 | SPY | ETF | 189.01 | 189.11 | 189.0 | 189.0 | 18477.0 |
| 2016-02-16 07:40:00 | SPY | ETF | 189.0 | 189.04 | 188.92 | 188.95 | 26131.0 |
| 2016-02-16 07:45:00 | SPY | ETF | 188.97 | 189.01 | 188.9 | 188.91 | 4645.0 |
| 2016-02-16 07:50:00 | SPY | ETF | 188.91 | 188.93 | 188.8 | 188.84 | 131182.0 |
| 2016-02-16 07:55:00 | SPY | ETF | 188.84 | 188.9 | 188.74 | 188.75 | 72152.0 |
| 2016-02-16 08:00:00 | SPY | ETF | 188.75 | 189.09 | 188.57 | 188.57 | 174323.0 |
| 2016-02-16 08:05:00 | SPY | ETF | 188.57 | 189.962 | 188.34 | 188.42 | 914036.0 |
> showing 50 of 52,811 rows — these rows as CSV