PREVIEW / etf_5min / 2018-03-02
file: by_date/etf_5min/2018/2018-03-02.parquet size: 1.4 MB rows: 61,203
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 |
|---|---|---|---|---|---|---|---|
| 2018-03-02 04:00:00 | SPY | ETF | 267.79 | 267.79 | 267.57 | 267.63 | 7612.0 |
| 2018-03-02 04:05:00 | SPY | ETF | 267.69 | 267.69 | 267.69 | 267.69 | 100.0 |
| 2018-03-02 04:10:00 | SPY | ETF | 267.57 | 267.57 | 267.46 | 267.46 | 4225.0 |
| 2018-03-02 04:15:00 | SPY | ETF | 267.46 | 267.55 | 267.36 | 267.36 | 510.0 |
| 2018-03-02 04:20:00 | SPY | ETF | 267.43 | 267.57 | 267.33 | 267.48 | 804.0 |
| 2018-03-02 04:25:00 | SPY | ETF | 267.24 | 267.39 | 267.22 | 267.39 | 4143.0 |
| 2018-03-02 04:30:00 | SPY | ETF | 267.33 | 267.33 | 267.0 | 267.07 | 14698.0 |
| 2018-03-02 04:35:00 | SPY | ETF | 267.04 | 267.37 | 267.04 | 267.37 | 3105.0 |
| 2018-03-02 04:40:00 | SPY | ETF | 267.37 | 267.37 | 267.37 | 267.37 | 900.0 |
| 2018-03-02 04:45:00 | SPY | ETF | 267.27 | 267.27 | 267.27 | 267.27 | 505.0 |
| 2018-03-02 04:50:00 | SPY | ETF | 267.1 | 267.1 | 267.05 | 267.08 | 841.0 |
| 2018-03-02 04:55:00 | SPY | ETF | 267.08 | 267.15 | 267.04 | 267.04 | 5383.0 |
| 2018-03-02 05:00:00 | SPY | ETF | 267.08 | 267.1 | 266.9 | 266.92 | 8818.0 |
| 2018-03-02 05:05:00 | SPY | ETF | 267.0 | 267.03 | 266.87 | 267.0 | 15549.0 |
| 2018-03-02 05:10:00 | SPY | ETF | 267.0 | 267.03 | 267.0 | 267.03 | 1634.0 |
| 2018-03-02 05:15:00 | SPY | ETF | 267.11 | 267.23 | 267.08 | 267.23 | 14029.0 |
| 2018-03-02 05:20:00 | SPY | ETF | 267.07 | 267.07 | 266.94 | 266.94 | 1020.0 |
| 2018-03-02 05:25:00 | SPY | ETF | 267.1 | 267.19 | 267.1 | 267.19 | 2706.0 |
| 2018-03-02 05:30:00 | SPY | ETF | 267.22 | 267.25 | 267.08 | 267.18 | 4244.0 |
| 2018-03-02 05:35:00 | SPY | ETF | 267.28 | 267.43 | 267.16 | 267.16 | 3452.0 |
| 2018-03-02 05:40:00 | SPY | ETF | 267.09 | 267.09 | 266.87 | 266.91 | 38429.0 |
| 2018-03-02 05:45:00 | SPY | ETF | 266.85 | 266.86 | 266.72 | 266.78 | 13951.0 |
| 2018-03-02 05:50:00 | SPY | ETF | 266.75 | 266.75 | 266.48 | 266.72 | 12020.0 |
| 2018-03-02 05:55:00 | SPY | ETF | 266.77 | 266.92 | 266.48 | 266.61 | 10907.0 |
| 2018-03-02 06:00:00 | SPY | ETF | 266.46 | 266.51 | 266.29 | 266.32 | 14236.0 |
| 2018-03-02 06:05:00 | SPY | ETF | 266.25 | 266.41 | 266.19 | 266.41 | 14193.0 |
| 2018-03-02 06:10:00 | SPY | ETF | 266.39 | 266.39 | 266.14 | 266.27 | 9441.0 |
| 2018-03-02 06:15:00 | SPY | ETF | 266.33 | 266.63 | 266.26 | 266.63 | 13159.0 |
| 2018-03-02 06:20:00 | SPY | ETF | 266.59 | 266.69 | 266.38 | 266.69 | 8656.0 |
| 2018-03-02 06:25:00 | SPY | ETF | 266.44 | 266.48 | 266.26 | 266.27 | 8349.0 |
| 2018-03-02 06:30:00 | SPY | ETF | 266.13 | 266.24 | 266.02 | 266.24 | 7666.0 |
| 2018-03-02 06:35:00 | SPY | ETF | 266.24 | 266.46 | 266.19 | 266.46 | 7381.0 |
| 2018-03-02 06:40:00 | SPY | ETF | 266.46 | 266.46 | 266.34 | 266.34 | 9331.0 |
| 2018-03-02 06:45:00 | SPY | ETF | 266.39 | 266.57 | 266.35 | 266.51 | 8072.0 |
| 2018-03-02 06:50:00 | SPY | ETF | 266.52 | 266.71 | 266.47 | 266.62 | 6200.0 |
| 2018-03-02 06:55:00 | SPY | ETF | 266.6 | 266.84 | 266.6 | 266.67 | 40086.0 |
| 2018-03-02 07:00:00 | SPY | ETF | 266.68 | 266.74 | 266.39 | 266.39 | 45543.0 |
| 2018-03-02 07:05:00 | SPY | ETF | 266.52 | 266.78 | 266.52 | 266.78 | 17666.0 |
| 2018-03-02 07:10:00 | SPY | ETF | 266.75 | 266.86 | 266.57 | 266.59 | 18790.0 |
| 2018-03-02 07:15:00 | SPY | ETF | 266.58 | 266.86 | 266.54 | 266.76 | 9063.0 |
| 2018-03-02 07:20:00 | SPY | ETF | 266.85 | 266.89 | 266.59 | 266.86 | 13862.0 |
| 2018-03-02 07:25:00 | SPY | ETF | 266.85 | 266.9 | 266.67 | 266.76 | 31121.0 |
| 2018-03-02 07:30:00 | SPY | ETF | 266.73 | 266.77 | 266.68 | 266.68 | 21002.0 |
| 2018-03-02 07:35:00 | SPY | ETF | 266.68 | 266.85 | 266.4 | 266.4 | 14373.0 |
| 2018-03-02 07:40:00 | SPY | ETF | 266.46 | 266.46 | 266.21 | 266.27 | 49759.0 |
| 2018-03-02 07:45:00 | SPY | ETF | 266.2 | 266.2 | 265.89 | 266.03 | 147228.0 |
| 2018-03-02 07:50:00 | SPY | ETF | 266.06 | 266.3 | 265.83 | 265.83 | 85905.0 |
| 2018-03-02 07:55:00 | SPY | ETF | 265.85 | 265.9 | 265.7 | 265.8 | 161473.0 |
| 2018-03-02 08:00:00 | SPY | ETF | 267.24 | 268.32 | 265.42 | 265.58 | 262062.0 |
| 2018-03-02 08:05:00 | SPY | ETF | 265.53 | 266.12 | 265.52 | 266.05 | 151248.0 |
> showing 50 of 61,203 rows — these rows as CSV