PREVIEW / etf_5min / 2014-02-26
file: by_date/etf_5min/2014/2014-02-26.parquet size: 1017 KB rows: 43,376
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-02-26 04:00:00 | SPY | ETF | 185.57 | 185.57 | 185.53 | 185.53 | 20601.0 |
| 2014-02-26 04:10:00 | SPY | ETF | 185.5 | 185.52 | 185.5 | 185.52 | 410.0 |
| 2014-02-26 04:15:00 | SPY | ETF | 185.52 | 185.52 | 185.5 | 185.5 | 200.0 |
| 2014-02-26 04:20:00 | SPY | ETF | 185.48 | 185.48 | 185.48 | 185.48 | 100.0 |
| 2014-02-26 04:25:00 | SPY | ETF | 185.46 | 185.46 | 185.44 | 185.44 | 4243.0 |
| 2014-02-26 04:30:00 | SPY | ETF | 185.42 | 185.42 | 185.42 | 185.42 | 1105.0 |
| 2014-02-26 04:40:00 | SPY | ETF | 185.39 | 185.39 | 185.39 | 185.39 | 130.0 |
| 2014-02-26 04:45:00 | SPY | ETF | 185.43 | 185.44 | 185.43 | 185.44 | 1100.0 |
| 2014-02-26 04:50:00 | SPY | ETF | 185.39 | 185.39 | 185.38 | 185.38 | 1206.0 |
| 2014-02-26 04:55:00 | SPY | ETF | 185.39 | 185.39 | 185.39 | 185.39 | 100.0 |
| 2014-02-26 05:00:00 | SPY | ETF | 185.47 | 185.47 | 185.47 | 185.47 | 250.0 |
| 2014-02-26 05:05:00 | SPY | ETF | 185.47 | 185.51 | 185.47 | 185.51 | 7742.0 |
| 2014-02-26 05:10:00 | SPY | ETF | 185.52 | 185.52 | 185.49 | 185.49 | 215.0 |
| 2014-02-26 05:15:00 | SPY | ETF | 185.56 | 185.56 | 185.56 | 185.56 | 115.0 |
| 2014-02-26 05:20:00 | SPY | ETF | 185.48 | 185.48 | 185.48 | 185.48 | 217.0 |
| 2014-02-26 05:50:00 | SPY | ETF | 185.47 | 185.47 | 185.47 | 185.47 | 172.0 |
| 2014-02-26 05:55:00 | SPY | ETF | 185.48 | 185.48 | 185.48 | 185.48 | 248.0 |
| 2014-02-26 06:15:00 | SPY | ETF | 185.47 | 185.48 | 185.47 | 185.48 | 417.0 |
| 2014-02-26 06:25:00 | SPY | ETF | 185.51 | 185.51 | 185.51 | 185.51 | 1500.0 |
| 2014-02-26 06:30:00 | SPY | ETF | 185.5 | 185.5 | 185.5 | 185.5 | 1000.0 |
| 2014-02-26 06:35:00 | SPY | ETF | 185.56 | 185.56 | 185.56 | 185.56 | 201.0 |
| 2014-02-26 06:40:00 | SPY | ETF | 185.52 | 185.52 | 185.52 | 185.52 | 123.0 |
| 2014-02-26 06:45:00 | SPY | ETF | 185.52 | 185.56 | 185.5 | 185.5 | 1408.0 |
| 2014-02-26 06:50:00 | SPY | ETF | 185.42 | 185.42 | 185.42 | 185.42 | 200.0 |
| 2014-02-26 06:55:00 | SPY | ETF | 185.45 | 185.45 | 185.45 | 185.45 | 135.0 |
| 2014-02-26 07:00:00 | SPY | ETF | 185.47 | 185.48 | 185.47 | 185.47 | 3500.0 |
| 2014-02-26 07:05:00 | SPY | ETF | 185.45 | 185.49 | 185.45 | 185.46 | 4977.0 |
| 2014-02-26 07:10:00 | SPY | ETF | 185.46 | 185.46 | 185.46 | 185.46 | 46100.0 |
| 2014-02-26 07:15:00 | SPY | ETF | 185.48 | 185.51 | 185.48 | 185.49 | 92636.0 |
| 2014-02-26 07:20:00 | SPY | ETF | 185.48 | 185.48 | 185.46 | 185.48 | 1783.0 |
| 2014-02-26 07:25:00 | SPY | ETF | 185.46 | 185.46 | 185.42 | 185.42 | 22100.0 |
| 2014-02-26 07:30:00 | SPY | ETF | 185.41 | 185.41 | 185.35 | 185.35 | 2850.0 |
| 2014-02-26 07:35:00 | SPY | ETF | 185.31 | 185.38 | 185.31 | 185.31 | 40564.0 |
| 2014-02-26 07:40:00 | SPY | ETF | 185.31 | 185.31 | 185.28 | 185.28 | 21750.0 |
| 2014-02-26 07:45:00 | SPY | ETF | 185.33 | 185.39 | 185.33 | 185.39 | 31000.0 |
| 2014-02-26 07:50:00 | SPY | ETF | 185.42 | 185.45 | 185.41 | 185.41 | 8900.0 |
| 2014-02-26 07:55:00 | SPY | ETF | 185.43 | 185.44 | 185.41 | 185.41 | 10400.0 |
| 2014-02-26 08:00:00 | SPY | ETF | 185.48 | 185.64 | 185.33 | 185.33 | 37485.0 |
| 2014-02-26 08:05:00 | SPY | ETF | 185.36 | 185.38 | 185.34 | 185.35 | 107169.0 |
| 2014-02-26 08:10:00 | SPY | ETF | 185.37 | 185.38 | 185.29 | 185.3 | 67077.0 |
| 2014-02-26 08:15:00 | SPY | ETF | 185.29 | 185.33 | 185.29 | 185.33 | 11465.0 |
| 2014-02-26 08:20:00 | SPY | ETF | 185.33 | 185.37 | 185.28 | 185.36 | 51378.0 |
| 2014-02-26 08:25:00 | SPY | ETF | 185.35 | 185.35 | 185.3 | 185.3 | 31000.0 |
| 2014-02-26 08:30:00 | SPY | ETF | 185.32 | 185.35 | 185.3 | 185.33 | 14301.0 |
| 2014-02-26 08:35:00 | SPY | ETF | 185.36 | 185.46 | 185.36 | 185.44 | 66211.0 |
| 2014-02-26 08:40:00 | SPY | ETF | 185.43 | 185.44 | 185.38 | 185.38 | 52590.0 |
| 2014-02-26 08:45:00 | SPY | ETF | 185.42 | 185.42 | 185.36 | 185.38 | 63815.0 |
| 2014-02-26 08:50:00 | SPY | ETF | 185.38 | 185.4 | 185.36 | 185.4 | 30830.0 |
| 2014-02-26 08:55:00 | SPY | ETF | 185.39 | 185.39 | 185.27 | 185.32 | 43382.0 |
| 2014-02-26 09:00:00 | SPY | ETF | 185.32 | 185.35 | 185.31 | 185.32 | 26374.0 |
> showing 50 of 43,376 rows — these rows as CSV