PREVIEW / etf_5min / 2016-06-24
file: by_date/etf_5min/2016/2016-06-24.parquet size: 1.4 MB rows: 62,845
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-06-24 04:00:00 | SPY | ETF | 204.6 | 204.74 | 204.03 | 204.17 | 48988.0 |
| 2016-06-24 04:05:00 | SPY | ETF | 204.11 | 204.36 | 203.7 | 203.88 | 41464.0 |
| 2016-06-24 04:10:00 | SPY | ETF | 203.98 | 204.19 | 203.67 | 204.08 | 38154.0 |
| 2016-06-24 04:15:00 | SPY | ETF | 204.15 | 204.51 | 203.91 | 204.51 | 20996.0 |
| 2016-06-24 04:20:00 | SPY | ETF | 204.43 | 204.46 | 204.12 | 204.3 | 15345.0 |
| 2016-06-24 04:25:00 | SPY | ETF | 204.46 | 204.79 | 204.46 | 204.6 | 20145.0 |
| 2016-06-24 04:30:00 | SPY | ETF | 204.55 | 204.55 | 204.06 | 204.08 | 31388.0 |
| 2016-06-24 04:35:00 | SPY | ETF | 204.21 | 204.47 | 204.12 | 204.25 | 42390.0 |
| 2016-06-24 04:40:00 | SPY | ETF | 204.24 | 204.3 | 204.09 | 204.16 | 20185.0 |
| 2016-06-24 04:45:00 | SPY | ETF | 204.24 | 204.38 | 204.17 | 204.17 | 19940.0 |
| 2016-06-24 04:50:00 | SPY | ETF | 204.17 | 204.3 | 203.77 | 203.86 | 46704.0 |
| 2016-06-24 04:55:00 | SPY | ETF | 203.8 | 203.89 | 203.33 | 203.33 | 36278.0 |
| 2016-06-24 05:00:00 | SPY | ETF | 203.33 | 203.68 | 203.27 | 203.54 | 113182.0 |
| 2016-06-24 05:05:00 | SPY | ETF | 203.61 | 203.85 | 203.44 | 203.85 | 5764.0 |
| 2016-06-24 05:10:00 | SPY | ETF | 203.89 | 203.97 | 203.74 | 203.74 | 53985.0 |
| 2016-06-24 05:15:00 | SPY | ETF | 203.72 | 203.92 | 203.72 | 203.88 | 12155.0 |
| 2016-06-24 05:20:00 | SPY | ETF | 203.83 | 204.16 | 203.83 | 204.05 | 116613.0 |
| 2016-06-24 05:25:00 | SPY | ETF | 204.05 | 204.29 | 204.03 | 204.25 | 39346.0 |
| 2016-06-24 05:30:00 | SPY | ETF | 204.2 | 204.35 | 204.18 | 204.33 | 22020.0 |
| 2016-06-24 05:35:00 | SPY | ETF | 204.3 | 204.3 | 204.09 | 204.14 | 35510.0 |
| 2016-06-24 05:40:00 | SPY | ETF | 204.2 | 204.2 | 203.8 | 203.8 | 12887.0 |
| 2016-06-24 05:45:00 | SPY | ETF | 203.74 | 203.86 | 203.59 | 203.69 | 77150.0 |
| 2016-06-24 05:50:00 | SPY | ETF | 203.71 | 203.78 | 203.3 | 203.36 | 23274.0 |
| 2016-06-24 05:55:00 | SPY | ETF | 203.38 | 203.63 | 203.34 | 203.52 | 11270.0 |
| 2016-06-24 06:00:00 | SPY | ETF | 203.59 | 203.65 | 202.99 | 203.1 | 48189.0 |
| 2016-06-24 06:05:00 | SPY | ETF | 203.12 | 203.12 | 202.89 | 203.04 | 54670.0 |
| 2016-06-24 06:10:00 | SPY | ETF | 203.04 | 203.47 | 202.8 | 203.33 | 73096.0 |
| 2016-06-24 06:15:00 | SPY | ETF | 203.34 | 203.74 | 203.34 | 203.6 | 74725.0 |
| 2016-06-24 06:20:00 | SPY | ETF | 203.6 | 203.75 | 203.55 | 203.62 | 114361.0 |
| 2016-06-24 06:25:00 | SPY | ETF | 203.55 | 203.63 | 203.11 | 203.38 | 118110.0 |
| 2016-06-24 06:30:00 | SPY | ETF | 203.4 | 203.4 | 202.95 | 202.98 | 139170.0 |
| 2016-06-24 06:35:00 | SPY | ETF | 202.97 | 203.25 | 202.97 | 203.01 | 179435.0 |
| 2016-06-24 06:40:00 | SPY | ETF | 203.01 | 203.01 | 202.7 | 202.83 | 161187.0 |
| 2016-06-24 06:45:00 | SPY | ETF | 202.78 | 202.86 | 202.09 | 202.25 | 248285.0 |
| 2016-06-24 06:50:00 | SPY | ETF | 202.25 | 202.66 | 202.25 | 202.63 | 277617.0 |
| 2016-06-24 06:55:00 | SPY | ETF | 202.63 | 203.46 | 202.45 | 203.17 | 341493.0 |
| 2016-06-24 07:00:00 | SPY | ETF | 203.14 | 203.4 | 203.0 | 203.15 | 193784.0 |
| 2016-06-24 07:05:00 | SPY | ETF | 203.15 | 203.23 | 202.92 | 203.1 | 112121.0 |
| 2016-06-24 07:10:00 | SPY | ETF | 203.1 | 203.29 | 203.03 | 203.23 | 96770.0 |
| 2016-06-24 07:15:00 | SPY | ETF | 203.28 | 203.37 | 202.91 | 202.92 | 143992.0 |
| 2016-06-24 07:20:00 | SPY | ETF | 202.94 | 203.13 | 202.88 | 203.0 | 250015.0 |
| 2016-06-24 07:25:00 | SPY | ETF | 203.0 | 203.04 | 202.71 | 203.0 | 366483.0 |
| 2016-06-24 07:30:00 | SPY | ETF | 203.01 | 203.41 | 202.98 | 203.31 | 173365.0 |
| 2016-06-24 07:35:00 | SPY | ETF | 203.22 | 203.77 | 203.19 | 203.59 | 358600.0 |
| 2016-06-24 07:40:00 | SPY | ETF | 203.55 | 203.67 | 203.35 | 203.35 | 283420.0 |
| 2016-06-24 07:45:00 | SPY | ETF | 203.35 | 203.44 | 203.15 | 203.21 | 290728.0 |
| 2016-06-24 07:50:00 | SPY | ETF | 203.2 | 203.55 | 203.2 | 203.25 | 242548.0 |
| 2016-06-24 07:55:00 | SPY | ETF | 203.25 | 203.28 | 203.04 | 203.09 | 215331.0 |
| 2016-06-24 08:00:00 | SPY | ETF | 203.09 | 209.85 | 200.25 | 203.66 | 1559991.0 |
| 2016-06-24 08:05:00 | SPY | ETF | 203.65 | 204.18 | 203.5 | 203.8 | 652014.0 |
> showing 50 of 62,845 rows — these rows as CSV