PREVIEW / etf_5min / 2016-02-24
file: by_date/etf_5min/2016/2016-02-24.parquet size: 1.2 MB rows: 49,831
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-24 04:00:00 | SPY | ETF | 192.04 | 192.04 | 192.04 | 192.04 | 830.0 |
| 2016-02-24 04:05:00 | SPY | ETF | 191.89 | 191.89 | 191.76 | 191.76 | 2106.0 |
| 2016-02-24 04:10:00 | SPY | ETF | 191.74 | 191.74 | 191.71 | 191.71 | 695.0 |
| 2016-02-24 04:15:00 | SPY | ETF | 191.65 | 191.74 | 191.65 | 191.65 | 6911.0 |
| 2016-02-24 04:20:00 | SPY | ETF | 191.57 | 191.57 | 191.23 | 191.29 | 10460.0 |
| 2016-02-24 04:25:00 | SPY | ETF | 191.25 | 191.33 | 191.18 | 191.27 | 6020.0 |
| 2016-02-24 04:30:00 | SPY | ETF | 191.28 | 191.28 | 191.19 | 191.24 | 1812.0 |
| 2016-02-24 04:35:00 | SPY | ETF | 191.2 | 191.2 | 191.06 | 191.06 | 2233.0 |
| 2016-02-24 04:40:00 | SPY | ETF | 191.13 | 191.33 | 191.13 | 191.24 | 2533.0 |
| 2016-02-24 04:45:00 | SPY | ETF | 191.18 | 191.18 | 191.15 | 191.15 | 530.0 |
| 2016-02-24 04:50:00 | SPY | ETF | 191.18 | 191.33 | 191.17 | 191.33 | 1388.0 |
| 2016-02-24 04:55:00 | SPY | ETF | 191.46 | 191.47 | 191.45 | 191.47 | 4934.0 |
| 2016-02-24 05:00:00 | SPY | ETF | 191.46 | 191.5 | 191.46 | 191.5 | 389.0 |
| 2016-02-24 05:05:00 | SPY | ETF | 191.5 | 191.5 | 191.24 | 191.24 | 2871.0 |
| 2016-02-24 05:10:00 | SPY | ETF | 191.11 | 191.11 | 190.95 | 191.05 | 11967.0 |
| 2016-02-24 05:15:00 | SPY | ETF | 191.06 | 191.06 | 190.87 | 190.96 | 20087.0 |
| 2016-02-24 05:20:00 | SPY | ETF | 190.91 | 191.04 | 190.88 | 191.04 | 11303.0 |
| 2016-02-24 05:25:00 | SPY | ETF | 190.97 | 191.09 | 190.97 | 191.09 | 7954.0 |
| 2016-02-24 05:30:00 | SPY | ETF | 191.09 | 191.27 | 191.06 | 191.21 | 23631.0 |
| 2016-02-24 05:35:00 | SPY | ETF | 191.05 | 191.05 | 191.05 | 191.05 | 325.0 |
| 2016-02-24 05:40:00 | SPY | ETF | 191.04 | 191.06 | 190.98 | 191.06 | 2844.0 |
| 2016-02-24 05:45:00 | SPY | ETF | 190.98 | 190.98 | 190.84 | 190.84 | 5710.0 |
| 2016-02-24 05:50:00 | SPY | ETF | 190.88 | 190.89 | 190.8 | 190.89 | 1540.0 |
| 2016-02-24 05:55:00 | SPY | ETF | 190.84 | 191.0 | 190.84 | 190.9 | 10348.0 |
| 2016-02-24 06:00:00 | SPY | ETF | 190.94 | 190.95 | 190.9 | 190.9 | 31933.0 |
| 2016-02-24 06:05:00 | SPY | ETF | 190.95 | 190.99 | 190.93 | 190.93 | 3234.0 |
| 2016-02-24 06:10:00 | SPY | ETF | 190.97 | 191.04 | 190.97 | 190.97 | 2077.0 |
| 2016-02-24 06:15:00 | SPY | ETF | 190.98 | 190.98 | 190.82 | 190.89 | 10082.0 |
| 2016-02-24 06:20:00 | SPY | ETF | 190.94 | 190.96 | 190.89 | 190.93 | 6802.0 |
| 2016-02-24 06:25:00 | SPY | ETF | 190.97 | 190.97 | 190.89 | 190.89 | 2072.0 |
| 2016-02-24 06:30:00 | SPY | ETF | 190.87 | 190.94 | 190.77 | 190.92 | 11037.0 |
| 2016-02-24 06:35:00 | SPY | ETF | 190.89 | 190.92 | 190.88 | 190.9 | 7037.0 |
| 2016-02-24 06:40:00 | SPY | ETF | 190.89 | 190.89 | 190.68 | 190.68 | 49978.0 |
| 2016-02-24 06:45:00 | SPY | ETF | 190.68 | 190.71 | 190.56 | 190.56 | 54619.0 |
| 2016-02-24 06:50:00 | SPY | ETF | 190.63 | 190.66 | 190.55 | 190.66 | 34594.0 |
| 2016-02-24 06:55:00 | SPY | ETF | 190.71 | 190.74 | 190.59 | 190.59 | 23295.0 |
| 2016-02-24 07:00:00 | SPY | ETF | 190.56 | 190.68 | 190.52 | 190.63 | 18558.0 |
| 2016-02-24 07:05:00 | SPY | ETF | 190.64 | 190.64 | 190.57 | 190.58 | 27572.0 |
| 2016-02-24 07:10:00 | SPY | ETF | 190.56 | 190.6 | 190.5 | 190.58 | 85501.0 |
| 2016-02-24 07:15:00 | SPY | ETF | 190.51 | 190.52 | 190.2 | 190.4 | 79433.0 |
| 2016-02-24 07:20:00 | SPY | ETF | 190.36 | 190.44 | 190.33 | 190.36 | 56235.0 |
| 2016-02-24 07:25:00 | SPY | ETF | 190.4 | 190.51 | 190.38 | 190.44 | 77774.0 |
| 2016-02-24 07:30:00 | SPY | ETF | 190.47 | 190.48 | 190.39 | 190.47 | 8386.0 |
| 2016-02-24 07:35:00 | SPY | ETF | 190.47 | 190.54 | 190.37 | 190.51 | 24373.0 |
| 2016-02-24 07:40:00 | SPY | ETF | 190.52 | 190.55 | 190.48 | 190.49 | 113653.0 |
| 2016-02-24 07:45:00 | SPY | ETF | 190.52 | 190.52 | 190.37 | 190.48 | 69581.0 |
| 2016-02-24 07:50:00 | SPY | ETF | 190.47 | 190.74 | 190.47 | 190.72 | 72818.0 |
| 2016-02-24 07:55:00 | SPY | ETF | 190.7 | 190.7 | 190.55 | 190.56 | 53966.0 |
| 2016-02-24 08:00:00 | SPY | ETF | 190.59 | 190.75 | 190.35 | 190.71 | 177256.0 |
| 2016-02-24 08:05:00 | SPY | ETF | 190.71 | 190.79 | 190.67 | 190.71 | 75347.0 |
> showing 50 of 49,831 rows — these rows as CSV