PREVIEW / etf_5min / 2016-02-10
file: by_date/etf_5min/2016/2016-02-10.parquet size: 1.2 MB rows: 51,963
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-10 04:00:00 | SPY | ETF | 186.58 | 186.88 | 186.52 | 186.88 | 15756.0 |
| 2016-02-10 04:05:00 | SPY | ETF | 186.93 | 186.95 | 186.83 | 186.83 | 11826.0 |
| 2016-02-10 04:10:00 | SPY | ETF | 186.75 | 186.78 | 186.7 | 186.78 | 2191.0 |
| 2016-02-10 04:15:00 | SPY | ETF | 186.81 | 186.83 | 186.71 | 186.71 | 1820.0 |
| 2016-02-10 04:20:00 | SPY | ETF | 186.76 | 186.76 | 186.58 | 186.58 | 1020.0 |
| 2016-02-10 04:25:00 | SPY | ETF | 186.61 | 186.8 | 186.52 | 186.72 | 6000.0 |
| 2016-02-10 04:30:00 | SPY | ETF | 186.77 | 186.81 | 186.51 | 186.81 | 9651.0 |
| 2016-02-10 04:35:00 | SPY | ETF | 186.74 | 186.74 | 186.74 | 186.74 | 100.0 |
| 2016-02-10 04:40:00 | SPY | ETF | 186.89 | 187.02 | 186.89 | 186.98 | 28932.0 |
| 2016-02-10 04:45:00 | SPY | ETF | 186.98 | 187.18 | 186.92 | 187.13 | 34253.0 |
| 2016-02-10 04:50:00 | SPY | ETF | 187.17 | 187.2 | 187.02 | 187.02 | 4820.0 |
| 2016-02-10 04:55:00 | SPY | ETF | 187.11 | 187.14 | 187.01 | 187.04 | 5190.0 |
| 2016-02-10 05:00:00 | SPY | ETF | 187.1 | 187.33 | 187.1 | 187.33 | 7436.0 |
| 2016-02-10 05:05:00 | SPY | ETF | 187.31 | 187.31 | 187.25 | 187.25 | 1300.0 |
| 2016-02-10 05:10:00 | SPY | ETF | 187.19 | 187.19 | 187.04 | 187.13 | 7362.0 |
| 2016-02-10 05:15:00 | SPY | ETF | 187.1 | 187.3 | 187.08 | 187.28 | 4245.0 |
| 2016-02-10 05:20:00 | SPY | ETF | 187.3 | 187.62 | 187.3 | 187.47 | 11214.0 |
| 2016-02-10 05:25:00 | SPY | ETF | 187.48 | 187.59 | 187.44 | 187.46 | 9958.0 |
| 2016-02-10 05:30:00 | SPY | ETF | 187.53 | 187.53 | 187.28 | 187.28 | 9228.0 |
| 2016-02-10 05:35:00 | SPY | ETF | 187.3 | 187.41 | 187.24 | 187.41 | 1807.0 |
| 2016-02-10 05:40:00 | SPY | ETF | 187.3 | 187.33 | 187.22 | 187.32 | 22780.0 |
| 2016-02-10 05:45:00 | SPY | ETF | 187.29 | 187.36 | 187.26 | 187.27 | 1899.0 |
| 2016-02-10 05:50:00 | SPY | ETF | 187.35 | 187.41 | 187.22 | 187.41 | 7339.0 |
| 2016-02-10 05:55:00 | SPY | ETF | 187.33 | 187.46 | 187.33 | 187.36 | 5500.0 |
| 2016-02-10 06:00:00 | SPY | ETF | 187.39 | 187.54 | 187.39 | 187.43 | 5135.0 |
| 2016-02-10 06:05:00 | SPY | ETF | 187.44 | 187.45 | 187.12 | 187.19 | 13698.0 |
| 2016-02-10 06:10:00 | SPY | ETF | 187.19 | 187.22 | 187.08 | 187.11 | 5326.0 |
| 2016-02-10 06:15:00 | SPY | ETF | 187.11 | 187.19 | 187.02 | 187.18 | 4615.0 |
| 2016-02-10 06:20:00 | SPY | ETF | 187.18 | 187.18 | 187.04 | 187.08 | 14799.0 |
| 2016-02-10 06:25:00 | SPY | ETF | 187.04 | 187.37 | 187.04 | 187.31 | 9957.0 |
| 2016-02-10 06:30:00 | SPY | ETF | 187.35 | 187.36 | 187.21 | 187.31 | 34955.0 |
| 2016-02-10 06:35:00 | SPY | ETF | 187.23 | 187.23 | 187.04 | 187.18 | 16427.0 |
| 2016-02-10 06:40:00 | SPY | ETF | 187.11 | 187.36 | 187.1 | 187.34 | 12644.0 |
| 2016-02-10 06:45:00 | SPY | ETF | 187.26 | 187.27 | 187.12 | 187.12 | 6405.0 |
| 2016-02-10 06:50:00 | SPY | ETF | 187.12 | 187.38 | 187.12 | 187.3 | 19275.0 |
| 2016-02-10 06:55:00 | SPY | ETF | 187.28 | 187.28 | 187.14 | 187.19 | 16338.0 |
| 2016-02-10 07:00:00 | SPY | ETF | 187.24 | 187.29 | 187.11 | 187.23 | 44384.0 |
| 2016-02-10 07:05:00 | SPY | ETF | 187.2 | 187.43 | 187.17 | 187.38 | 30633.0 |
| 2016-02-10 07:10:00 | SPY | ETF | 187.36 | 187.45 | 187.27 | 187.38 | 16094.0 |
| 2016-02-10 07:15:00 | SPY | ETF | 187.4 | 187.49 | 187.33 | 187.36 | 12153.0 |
| 2016-02-10 07:20:00 | SPY | ETF | 187.37 | 187.41 | 187.26 | 187.3 | 6425.0 |
| 2016-02-10 07:25:00 | SPY | ETF | 187.33 | 187.33 | 187.11 | 187.18 | 47052.0 |
| 2016-02-10 07:30:00 | SPY | ETF | 187.21 | 187.43 | 187.16 | 187.4 | 73666.0 |
| 2016-02-10 07:35:00 | SPY | ETF | 187.38 | 187.43 | 187.35 | 187.39 | 25270.0 |
| 2016-02-10 07:40:00 | SPY | ETF | 187.41 | 187.47 | 187.34 | 187.45 | 62261.0 |
| 2016-02-10 07:45:00 | SPY | ETF | 187.46 | 187.73 | 187.46 | 187.72 | 141174.0 |
| 2016-02-10 07:50:00 | SPY | ETF | 187.67 | 187.73 | 187.6 | 187.63 | 32691.0 |
| 2016-02-10 07:55:00 | SPY | ETF | 187.6 | 187.62 | 187.51 | 187.62 | 32102.0 |
| 2016-02-10 08:00:00 | SPY | ETF | 186.695 | 187.73 | 186.695 | 187.39 | 146816.0 |
| 2016-02-10 08:05:00 | SPY | ETF | 187.39 | 187.44 | 187.27 | 187.39 | 218046.0 |
> showing 50 of 51,963 rows — these rows as CSV