PREVIEW / etf_5min / 2014-09-11
file: by_date/etf_5min/2014/2014-09-11.parquet size: 980 KB rows: 41,494
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-11 04:00:00 | SPY | ETF | 199.85 | 199.88 | 199.84 | 199.84 | 3461.0 |
| 2014-09-11 04:05:00 | SPY | ETF | 199.83 | 199.83 | 199.81 | 199.81 | 600.0 |
| 2014-09-11 04:10:00 | SPY | ETF | 199.86 | 199.86 | 199.86 | 199.86 | 182.0 |
| 2014-09-11 04:15:00 | SPY | ETF | 199.78 | 199.82 | 199.78 | 199.78 | 25710.0 |
| 2014-09-11 04:35:00 | SPY | ETF | 199.73 | 199.73 | 199.59 | 199.6 | 12351.0 |
| 2014-09-11 04:40:00 | SPY | ETF | 199.58 | 199.58 | 199.44 | 199.44 | 700.0 |
| 2014-09-11 04:45:00 | SPY | ETF | 199.49 | 199.52 | 199.49 | 199.5 | 440.0 |
| 2014-09-11 04:55:00 | SPY | ETF | 199.54 | 199.56 | 199.54 | 199.56 | 300.0 |
| 2014-09-11 05:00:00 | SPY | ETF | 199.56 | 199.56 | 199.56 | 199.56 | 200.0 |
| 2014-09-11 05:10:00 | SPY | ETF | 199.53 | 199.53 | 199.53 | 199.53 | 7350.0 |
| 2014-09-11 05:25:00 | SPY | ETF | 199.54 | 199.54 | 199.54 | 199.54 | 124.0 |
| 2014-09-11 05:30:00 | SPY | ETF | 199.58 | 199.64 | 199.58 | 199.63 | 649.0 |
| 2014-09-11 05:35:00 | SPY | ETF | 199.63 | 199.64 | 199.63 | 199.63 | 2011.0 |
| 2014-09-11 05:40:00 | SPY | ETF | 199.6 | 199.61 | 199.6 | 199.61 | 1700.0 |
| 2014-09-11 05:45:00 | SPY | ETF | 199.61 | 199.64 | 199.61 | 199.64 | 555.0 |
| 2014-09-11 06:10:00 | SPY | ETF | 199.63 | 199.63 | 199.63 | 199.63 | 3425.0 |
| 2014-09-11 06:20:00 | SPY | ETF | 199.73 | 199.73 | 199.73 | 199.73 | 103.0 |
| 2014-09-11 06:25:00 | SPY | ETF | 199.7 | 199.7 | 199.7 | 199.7 | 100.0 |
| 2014-09-11 06:30:00 | SPY | ETF | 199.69 | 199.69 | 199.65 | 199.65 | 583.0 |
| 2014-09-11 06:35:00 | SPY | ETF | 199.61 | 199.61 | 199.56 | 199.58 | 3262.0 |
| 2014-09-11 06:40:00 | SPY | ETF | 199.55 | 199.59 | 199.54 | 199.57 | 2965.0 |
| 2014-09-11 06:45:00 | SPY | ETF | 199.57 | 199.6 | 199.5 | 199.58 | 31597.0 |
| 2014-09-11 06:50:00 | SPY | ETF | 199.58 | 199.6 | 199.55 | 199.6 | 8527.0 |
| 2014-09-11 06:55:00 | SPY | ETF | 199.6 | 199.6 | 199.52 | 199.52 | 6072.0 |
| 2014-09-11 07:00:00 | SPY | ETF | 199.52 | 199.56 | 199.48 | 199.56 | 15400.0 |
| 2014-09-11 07:05:00 | SPY | ETF | 199.53 | 199.57 | 199.51 | 199.57 | 6062.0 |
| 2014-09-11 07:10:00 | SPY | ETF | 199.53 | 199.54 | 199.47 | 199.47 | 14300.0 |
| 2014-09-11 07:15:00 | SPY | ETF | 199.46 | 199.5 | 199.4 | 199.5 | 29725.0 |
| 2014-09-11 07:25:00 | SPY | ETF | 199.49 | 199.57 | 199.46 | 199.57 | 31432.0 |
| 2014-09-11 07:30:00 | SPY | ETF | 199.58 | 199.59 | 199.56 | 199.56 | 13351.0 |
| 2014-09-11 07:35:00 | SPY | ETF | 199.59 | 199.62 | 199.59 | 199.62 | 6935.0 |
| 2014-09-11 07:40:00 | SPY | ETF | 199.58 | 199.61 | 199.51 | 199.54 | 71700.0 |
| 2014-09-11 07:45:00 | SPY | ETF | 199.54 | 199.59 | 199.51 | 199.59 | 6821.0 |
| 2014-09-11 07:50:00 | SPY | ETF | 199.58 | 199.59 | 199.55 | 199.56 | 52507.0 |
| 2014-09-11 07:55:00 | SPY | ETF | 199.51 | 199.52 | 199.31 | 199.34 | 77587.0 |
| 2014-09-11 08:00:00 | SPY | ETF | 199.34 | 199.87 | 199.29 | 199.87 | 148536.0 |
| 2014-09-11 08:05:00 | SPY | ETF | 199.38 | 199.39 | 199.32 | 199.39 | 117215.0 |
| 2014-09-11 08:10:00 | SPY | ETF | 199.37 | 199.41 | 199.34 | 199.38 | 24632.0 |
| 2014-09-11 08:15:00 | SPY | ETF | 199.38 | 199.41 | 199.31 | 199.34 | 99610.0 |
| 2014-09-11 08:20:00 | SPY | ETF | 199.32 | 199.35 | 199.31 | 199.34 | 30851.0 |
| 2014-09-11 08:25:00 | SPY | ETF | 199.34 | 199.46 | 199.25 | 199.42 | 105304.0 |
| 2014-09-11 08:30:00 | SPY | ETF | 199.38 | 199.46 | 199.37 | 199.39 | 42151.0 |
| 2014-09-11 08:35:00 | SPY | ETF | 199.39 | 199.39 | 199.14 | 199.16 | 187959.0 |
| 2014-09-11 08:40:00 | SPY | ETF | 199.16 | 199.26 | 199.16 | 199.25 | 182403.0 |
| 2014-09-11 08:45:00 | SPY | ETF | 199.22 | 199.33 | 199.2 | 199.26 | 43132.0 |
| 2014-09-11 08:50:00 | SPY | ETF | 199.26 | 199.26 | 199.11 | 199.14 | 168620.0 |
| 2014-09-11 08:55:00 | SPY | ETF | 199.13 | 199.2 | 199.12 | 199.19 | 82113.0 |
| 2014-09-11 09:00:00 | SPY | ETF | 199.16 | 199.28 | 199.16 | 199.25 | 146379.0 |
| 2014-09-11 09:05:00 | SPY | ETF | 199.25 | 199.29 | 199.25 | 199.27 | 102618.0 |
| 2014-09-11 09:10:00 | SPY | ETF | 199.25 | 199.3 | 199.23 | 199.24 | 66415.0 |
> showing 50 of 41,494 rows — these rows as CSV