PREVIEW / etf_30min / 2015-07-07
file: by_date/etf_30min/2015/2015-07-07.parquet size: 408 KB rows: 13,728
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-07 04:00:00 | SPY | ETF | 208.16 | 208.3 | 208.15 | 208.24 | 15776.0 |
| 2015-07-07 04:30:00 | SPY | ETF | 208.25 | 208.25 | 208.01 | 208.06 | 24269.0 |
| 2015-07-07 05:00:00 | SPY | ETF | 208.08 | 208.2 | 207.96 | 207.96 | 5203.0 |
| 2015-07-07 05:30:00 | SPY | ETF | 207.96 | 208.05 | 207.87 | 207.97 | 38943.0 |
| 2015-07-07 06:00:00 | SPY | ETF | 208.0 | 208.0 | 207.76 | 207.76 | 28259.0 |
| 2015-07-07 06:30:00 | SPY | ETF | 207.85 | 207.85 | 207.57 | 207.57 | 96251.0 |
| 2015-07-07 07:00:00 | SPY | ETF | 207.58 | 207.6 | 207.25 | 207.5 | 189335.0 |
| 2015-07-07 07:30:00 | SPY | ETF | 207.58 | 207.65 | 207.27 | 207.45 | 282055.0 |
| 2015-07-07 08:00:00 | SPY | ETF | 207.81 | 207.81 | 206.72 | 207.37 | 281213.0 |
| 2015-07-07 08:30:00 | SPY | ETF | 207.37 | 207.5 | 207.29 | 207.3 | 268174.0 |
| 2015-07-07 09:00:00 | SPY | ETF | 207.3 | 207.3 | 206.83 | 206.95 | 920087.0 |
| 2015-07-07 09:30:00 | SPY | ETF | 206.96 | 206.99 | 205.84 | 205.96 | 12801277.0 |
| 2015-07-07 10:00:00 | SPY | ETF | 205.96 | 205.9608 | 205.08 | 205.19 | 18233772.0 |
| 2015-07-07 10:30:00 | SPY | ETF | 205.19 | 205.2 | 204.35 | 204.91 | 15260289.0 |
| 2015-07-07 11:00:00 | SPY | ETF | 204.9 | 205.06 | 204.36 | 204.48 | 13093436.0 |
| 2015-07-07 11:30:00 | SPY | ETF | 204.48 | 205.65 | 204.11 | 205.43 | 14947554.0 |
| 2015-07-07 12:00:00 | SPY | ETF | 205.44 | 205.55 | 205.18 | 205.4 | 6259552.0 |
| 2015-07-07 12:30:00 | SPY | ETF | 205.39 | 206.54 | 205.37 | 206.37 | 10553760.0 |
| 2015-07-07 13:00:00 | SPY | ETF | 206.365 | 206.9 | 206.03 | 206.551 | 11251379.0 |
| 2015-07-07 13:30:00 | SPY | ETF | 206.555 | 206.74 | 206.35 | 206.49 | 4888163.0 |
| 2015-07-07 14:00:00 | SPY | ETF | 206.49 | 206.61 | 206.0 | 206.23 | 6327221.0 |
| 2015-07-07 14:30:00 | SPY | ETF | 206.24 | 207.89 | 206.18 | 207.79 | 15915348.0 |
| 2015-07-07 15:00:00 | SPY | ETF | 207.795 | 208.11 | 207.45 | 207.92 | 14484961.0 |
| 2015-07-07 15:30:00 | SPY | ETF | 207.91 | 208.17 | 207.55 | 207.99 | 18095102.0 |
| 2015-07-07 16:00:00 | SPY | ETF | 207.99 | 208.19 | 207.84 | 207.97 | 6009247.0 |
| 2015-07-07 16:30:00 | SPY | ETF | 207.96 | 208.03 | 207.83 | 207.87 | 976328.0 |
| 2015-07-07 17:00:00 | SPY | ETF | 207.87 | 207.98 | 207.83 | 207.83 | 407699.0 |
| 2015-07-07 17:30:00 | SPY | ETF | 207.82 | 207.88 | 207.82 | 207.84 | 36689.0 |
| 2015-07-07 18:00:00 | SPY | ETF | 207.83 | 207.85 | 207.54 | 207.6 | 136649.0 |
| 2015-07-07 18:30:00 | SPY | ETF | 207.58 | 207.66 | 207.57 | 207.64 | 64241.0 |
| 2015-07-07 19:00:00 | SPY | ETF | 207.63 | 207.65 | 207.44 | 207.52 | 66991.0 |
| 2015-07-07 19:30:00 | SPY | ETF | 207.52 | 207.58 | 207.48 | 207.52 | 83971.0 |
| 2015-07-07 04:00:00 | QQQ | ETF | 108.45 | 108.45 | 108.45 | 108.45 | 1000.0 |
| 2015-07-07 04:30:00 | QQQ | ETF | 108.48 | 108.48 | 108.48 | 108.48 | 6250.0 |
| 2015-07-07 06:30:00 | QQQ | ETF | 108.17 | 108.23 | 108.15 | 108.15 | 3000.0 |
| 2015-07-07 07:00:00 | QQQ | ETF | 108.11 | 108.11 | 107.96 | 108.05 | 43827.0 |
| 2015-07-07 07:30:00 | QQQ | ETF | 108.12 | 108.12 | 107.94 | 107.98 | 10329.0 |
| 2015-07-07 08:00:00 | QQQ | ETF | 108.05 | 108.05 | 107.9 | 107.95 | 44107.0 |
| 2015-07-07 08:30:00 | QQQ | ETF | 107.98 | 108.07 | 107.92 | 108.01 | 36811.0 |
| 2015-07-07 09:00:00 | QQQ | ETF | 108.0 | 108.0 | 107.76 | 107.83 | 233960.0 |
| 2015-07-07 09:30:00 | QQQ | ETF | 107.82 | 107.85 | 107.08 | 107.13 | 4234042.0 |
| 2015-07-07 10:00:00 | QQQ | ETF | 107.13 | 107.13 | 106.58 | 106.65 | 4262821.0 |
| 2015-07-07 10:30:00 | QQQ | ETF | 106.67 | 106.67 | 105.99 | 106.4 | 4547649.0 |
| 2015-07-07 11:00:00 | QQQ | ETF | 106.4 | 106.425 | 106.0 | 106.08 | 2892170.0 |
| 2015-07-07 11:30:00 | QQQ | ETF | 106.08 | 106.64 | 105.83 | 106.51 | 3375614.0 |
| 2015-07-07 12:00:00 | QQQ | ETF | 106.52 | 106.56 | 106.345 | 106.46 | 1559048.0 |
| 2015-07-07 12:30:00 | QQQ | ETF | 106.45 | 107.12 | 106.44 | 107.03 | 2175556.0 |
| 2015-07-07 13:00:00 | QQQ | ETF | 107.03 | 107.37 | 106.86 | 107.23 | 2940925.0 |
| 2015-07-07 13:30:00 | QQQ | ETF | 107.24 | 107.34 | 107.105 | 107.2 | 1215715.0 |
| 2015-07-07 14:00:00 | QQQ | ETF | 107.21 | 107.29 | 106.92 | 107.04 | 1189982.0 |
> showing 50 of 13,728 rows — these rows as CSV