PREVIEW / etf_5min / 2016-07-14
file: by_date/etf_5min/2016/2016-07-14.parquet size: 1.2 MB rows: 52,030
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-07-14 04:00:00 | SPY | ETF | 216.0 | 216.35 | 215.2 | 216.26 | 10403.0 |
| 2016-07-14 04:05:00 | SPY | ETF | 216.28 | 216.38 | 216.28 | 216.37 | 2332.0 |
| 2016-07-14 04:10:00 | SPY | ETF | 216.38 | 216.43 | 216.32 | 216.37 | 86371.0 |
| 2016-07-14 04:15:00 | SPY | ETF | 216.36 | 216.39 | 216.35 | 216.37 | 1800.0 |
| 2016-07-14 04:20:00 | SPY | ETF | 216.36 | 216.42 | 216.3 | 216.3 | 25166.0 |
| 2016-07-14 04:25:00 | SPY | ETF | 216.33 | 216.33 | 216.3 | 216.3 | 8600.0 |
| 2016-07-14 04:30:00 | SPY | ETF | 216.27 | 216.33 | 216.27 | 216.33 | 5102.0 |
| 2016-07-14 04:35:00 | SPY | ETF | 216.31 | 216.31 | 216.31 | 216.31 | 1100.0 |
| 2016-07-14 04:40:00 | SPY | ETF | 216.36 | 216.36 | 216.35 | 216.35 | 2401.0 |
| 2016-07-14 04:45:00 | SPY | ETF | 216.31 | 216.31 | 216.31 | 216.31 | 2942.0 |
| 2016-07-14 04:50:00 | SPY | ETF | 216.28 | 216.31 | 216.28 | 216.28 | 910.0 |
| 2016-07-14 05:00:00 | SPY | ETF | 216.3 | 216.3 | 216.28 | 216.3 | 2700.0 |
| 2016-07-14 05:05:00 | SPY | ETF | 216.27 | 216.3 | 216.27 | 216.3 | 702.0 |
| 2016-07-14 05:10:00 | SPY | ETF | 216.3 | 216.32 | 216.3 | 216.32 | 260.0 |
| 2016-07-14 05:15:00 | SPY | ETF | 216.45 | 216.5 | 216.42 | 216.45 | 13432.0 |
| 2016-07-14 05:20:00 | SPY | ETF | 216.45 | 216.45 | 216.36 | 216.36 | 13204.0 |
| 2016-07-14 05:25:00 | SPY | ETF | 216.36 | 216.36 | 216.36 | 216.36 | 3000.0 |
| 2016-07-14 05:30:00 | SPY | ETF | 216.38 | 216.38 | 216.37 | 216.37 | 3800.0 |
| 2016-07-14 05:35:00 | SPY | ETF | 216.41 | 216.56 | 216.41 | 216.56 | 4245.0 |
| 2016-07-14 05:40:00 | SPY | ETF | 216.5 | 216.5 | 216.49 | 216.49 | 30200.0 |
| 2016-07-14 05:45:00 | SPY | ETF | 216.46 | 216.5 | 216.46 | 216.5 | 2799.0 |
| 2016-07-14 05:50:00 | SPY | ETF | 216.48 | 216.6 | 216.48 | 216.6 | 5412.0 |
| 2016-07-14 05:55:00 | SPY | ETF | 216.77 | 217.15 | 216.77 | 217.06 | 91750.0 |
| 2016-07-14 06:00:00 | SPY | ETF | 217.06 | 217.06 | 216.85 | 216.86 | 62101.0 |
| 2016-07-14 06:05:00 | SPY | ETF | 216.86 | 216.95 | 216.86 | 216.93 | 4555.0 |
| 2016-07-14 06:10:00 | SPY | ETF | 216.93 | 216.93 | 216.82 | 216.82 | 5408.0 |
| 2016-07-14 06:15:00 | SPY | ETF | 216.81 | 216.81 | 216.76 | 216.76 | 11834.0 |
| 2016-07-14 06:20:00 | SPY | ETF | 216.76 | 216.76 | 216.53 | 216.55 | 22857.0 |
| 2016-07-14 06:25:00 | SPY | ETF | 216.63 | 216.63 | 216.55 | 216.55 | 8325.0 |
| 2016-07-14 06:30:00 | SPY | ETF | 216.6 | 216.63 | 216.54 | 216.54 | 5693.0 |
| 2016-07-14 06:35:00 | SPY | ETF | 216.51 | 216.6 | 216.51 | 216.57 | 9086.0 |
| 2016-07-14 06:40:00 | SPY | ETF | 216.56 | 216.63 | 216.53 | 216.53 | 13037.0 |
| 2016-07-14 06:45:00 | SPY | ETF | 216.55 | 216.55 | 216.41 | 216.52 | 99427.0 |
| 2016-07-14 06:50:00 | SPY | ETF | 216.48 | 216.63 | 216.45 | 216.6 | 98211.0 |
| 2016-07-14 06:55:00 | SPY | ETF | 216.49 | 216.62 | 216.48 | 216.62 | 80209.0 |
| 2016-07-14 07:00:00 | SPY | ETF | 216.58 | 216.58 | 216.04 | 216.24 | 248455.0 |
| 2016-07-14 07:05:00 | SPY | ETF | 216.25 | 216.26 | 216.04 | 216.04 | 51615.0 |
| 2016-07-14 07:10:00 | SPY | ETF | 216.02 | 216.13 | 216.0 | 216.13 | 25191.0 |
| 2016-07-14 07:15:00 | SPY | ETF | 216.08 | 216.29 | 216.04 | 216.29 | 39605.0 |
| 2016-07-14 07:20:00 | SPY | ETF | 216.29 | 216.31 | 216.22 | 216.24 | 63241.0 |
| 2016-07-14 07:25:00 | SPY | ETF | 216.26 | 216.46 | 216.26 | 216.46 | 49680.0 |
| 2016-07-14 07:30:00 | SPY | ETF | 216.46 | 216.55 | 216.44 | 216.55 | 65025.0 |
| 2016-07-14 07:35:00 | SPY | ETF | 216.56 | 216.67 | 216.56 | 216.59 | 43250.0 |
| 2016-07-14 07:40:00 | SPY | ETF | 216.59 | 216.84 | 216.51 | 216.74 | 74842.0 |
| 2016-07-14 07:45:00 | SPY | ETF | 216.75 | 216.84 | 216.69 | 216.69 | 101644.0 |
| 2016-07-14 07:50:00 | SPY | ETF | 216.7 | 216.72 | 216.61 | 216.66 | 23051.0 |
| 2016-07-14 07:55:00 | SPY | ETF | 216.69 | 216.89 | 216.69 | 216.77 | 109955.0 |
| 2016-07-14 08:00:00 | SPY | ETF | 216.78 | 216.83 | 214.789 | 214.789 | 152116.0 |
| 2016-07-14 08:05:00 | SPY | ETF | 216.74 | 216.74 | 216.66 | 216.68 | 93297.0 |
| 2016-07-14 08:10:00 | SPY | ETF | 216.67 | 216.7 | 216.65 | 216.7 | 52330.0 |
> showing 50 of 52,030 rows — these rows as CSV