PREVIEW / etf_5min / 2016-11-07
file: by_date/etf_5min/2016/2016-11-07.parquet size: 1.2 MB rows: 53,520
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-11-07 04:00:00 | SPY | ETF | 209.86 | 211.3 | 209.86 | 211.3 | 13023.0 |
| 2016-11-07 04:05:00 | SPY | ETF | 211.27 | 211.3 | 210.92 | 211.22 | 10798.0 |
| 2016-11-07 04:10:00 | SPY | ETF | 211.2 | 211.36 | 211.2 | 211.36 | 3891.0 |
| 2016-11-07 04:15:00 | SPY | ETF | 211.29 | 211.4 | 211.29 | 211.4 | 3901.0 |
| 2016-11-07 04:20:00 | SPY | ETF | 211.45 | 211.47 | 211.45 | 211.45 | 1781.0 |
| 2016-11-07 04:25:00 | SPY | ETF | 211.5 | 211.61 | 211.5 | 211.61 | 823.0 |
| 2016-11-07 04:30:00 | SPY | ETF | 211.6 | 211.64 | 211.55 | 211.64 | 9171.0 |
| 2016-11-07 04:35:00 | SPY | ETF | 211.63 | 211.66 | 211.6 | 211.6 | 5833.0 |
| 2016-11-07 04:40:00 | SPY | ETF | 211.59 | 211.62 | 211.59 | 211.59 | 1192.0 |
| 2016-11-07 04:45:00 | SPY | ETF | 211.6 | 211.6 | 211.57 | 211.6 | 3681.0 |
| 2016-11-07 04:50:00 | SPY | ETF | 211.58 | 211.63 | 211.57 | 211.63 | 7336.0 |
| 2016-11-07 04:55:00 | SPY | ETF | 211.57 | 211.61 | 211.53 | 211.54 | 3244.0 |
| 2016-11-07 05:00:00 | SPY | ETF | 211.54 | 211.54 | 211.52 | 211.53 | 4407.0 |
| 2016-11-07 05:05:00 | SPY | ETF | 211.53 | 211.53 | 211.46 | 211.48 | 1785.0 |
| 2016-11-07 05:10:00 | SPY | ETF | 211.48 | 211.48 | 211.44 | 211.46 | 14056.0 |
| 2016-11-07 05:15:00 | SPY | ETF | 211.42 | 211.42 | 211.39 | 211.39 | 5872.0 |
| 2016-11-07 05:20:00 | SPY | ETF | 211.4 | 211.4 | 211.37 | 211.38 | 5500.0 |
| 2016-11-07 05:25:00 | SPY | ETF | 211.37 | 211.39 | 211.28 | 211.29 | 7140.0 |
| 2016-11-07 05:30:00 | SPY | ETF | 211.31 | 211.36 | 211.3 | 211.36 | 5797.0 |
| 2016-11-07 05:35:00 | SPY | ETF | 211.36 | 211.43 | 211.36 | 211.43 | 4248.0 |
| 2016-11-07 05:40:00 | SPY | ETF | 211.4 | 211.41 | 211.4 | 211.41 | 700.0 |
| 2016-11-07 05:45:00 | SPY | ETF | 211.37 | 211.4 | 211.37 | 211.4 | 843.0 |
| 2016-11-07 05:50:00 | SPY | ETF | 211.43 | 211.52 | 211.38 | 211.42 | 4495.0 |
| 2016-11-07 05:55:00 | SPY | ETF | 211.45 | 211.45 | 211.4 | 211.44 | 8802.0 |
| 2016-11-07 06:00:00 | SPY | ETF | 211.48 | 211.51 | 211.46 | 211.46 | 7413.0 |
| 2016-11-07 06:05:00 | SPY | ETF | 211.4 | 211.4 | 211.37 | 211.38 | 2950.0 |
| 2016-11-07 06:10:00 | SPY | ETF | 211.38 | 211.4 | 211.32 | 211.32 | 20442.0 |
| 2016-11-07 06:15:00 | SPY | ETF | 211.32 | 211.36 | 211.29 | 211.29 | 13251.0 |
| 2016-11-07 06:20:00 | SPY | ETF | 211.32 | 211.36 | 211.29 | 211.35 | 18819.0 |
| 2016-11-07 06:25:00 | SPY | ETF | 211.35 | 211.35 | 211.27 | 211.33 | 7283.0 |
| 2016-11-07 06:30:00 | SPY | ETF | 211.35 | 211.35 | 211.3 | 211.33 | 9101.0 |
| 2016-11-07 06:35:00 | SPY | ETF | 211.32 | 211.35 | 211.3 | 211.35 | 11518.0 |
| 2016-11-07 06:40:00 | SPY | ETF | 211.35 | 211.38 | 211.3 | 211.3 | 68016.0 |
| 2016-11-07 06:45:00 | SPY | ETF | 211.35 | 211.37 | 211.3 | 211.3 | 15399.0 |
| 2016-11-07 06:50:00 | SPY | ETF | 211.3 | 211.31 | 211.26 | 211.3 | 8404.0 |
| 2016-11-07 06:55:00 | SPY | ETF | 211.3 | 211.32 | 211.3 | 211.3 | 2581.0 |
| 2016-11-07 07:00:00 | SPY | ETF | 211.29 | 211.31 | 211.24 | 211.24 | 83604.0 |
| 2016-11-07 07:05:00 | SPY | ETF | 211.25 | 211.28 | 211.23 | 211.23 | 15247.0 |
| 2016-11-07 07:10:00 | SPY | ETF | 211.24 | 211.26 | 211.2 | 211.2 | 61937.0 |
| 2016-11-07 07:15:00 | SPY | ETF | 211.2 | 211.25 | 211.2 | 211.22 | 88876.0 |
| 2016-11-07 07:20:00 | SPY | ETF | 211.21 | 211.23 | 211.17 | 211.17 | 64824.0 |
| 2016-11-07 07:25:00 | SPY | ETF | 211.19 | 211.2 | 211.1 | 211.11 | 26416.0 |
| 2016-11-07 07:30:00 | SPY | ETF | 211.11 | 211.21 | 211.11 | 211.2 | 11726.0 |
| 2016-11-07 07:35:00 | SPY | ETF | 211.2 | 211.23 | 211.2 | 211.22 | 56234.0 |
| 2016-11-07 07:40:00 | SPY | ETF | 211.22 | 211.33 | 211.22 | 211.28 | 122347.0 |
| 2016-11-07 07:45:00 | SPY | ETF | 211.29 | 211.37 | 211.29 | 211.3 | 48028.0 |
| 2016-11-07 07:50:00 | SPY | ETF | 211.3 | 211.3 | 211.24 | 211.26 | 94207.0 |
| 2016-11-07 07:55:00 | SPY | ETF | 211.26 | 211.28 | 211.23 | 211.27 | 68860.0 |
| 2016-11-07 08:00:00 | SPY | ETF | 211.27 | 211.32 | 211.12 | 211.32 | 184541.0 |
| 2016-11-07 08:05:00 | SPY | ETF | 211.33 | 211.36 | 211.31 | 211.35 | 116744.0 |
> showing 50 of 53,520 rows — these rows as CSV