PREVIEW / etf_30min / 2015-11-11
file: by_date/etf_30min/2015/2015-11-11.parquet size: 364 KB rows: 12,270
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-11-11 04:00:00 | SPY | ETF | 208.93 | 209.11 | 208.93 | 208.94 | 1695.0 |
| 2015-11-11 04:30:00 | SPY | ETF | 208.99 | 209.06 | 208.99 | 209.06 | 1350.0 |
| 2015-11-11 05:00:00 | SPY | ETF | 208.99 | 209.04 | 208.99 | 209.04 | 1700.0 |
| 2015-11-11 05:30:00 | SPY | ETF | 208.84 | 208.91 | 208.84 | 208.86 | 2500.0 |
| 2015-11-11 06:00:00 | SPY | ETF | 208.84 | 208.94 | 208.78 | 208.89 | 21764.0 |
| 2015-11-11 06:30:00 | SPY | ETF | 208.92 | 209.24 | 208.92 | 209.22 | 64965.0 |
| 2015-11-11 07:00:00 | SPY | ETF | 209.22 | 209.32 | 209.13 | 209.21 | 65811.0 |
| 2015-11-11 07:30:00 | SPY | ETF | 209.2 | 209.41 | 209.2 | 209.38 | 179585.0 |
| 2015-11-11 08:00:00 | SPY | ETF | 208.9 | 209.42 | 208.9 | 209.15 | 684794.0 |
| 2015-11-11 08:30:00 | SPY | ETF | 209.17 | 209.2 | 209.06 | 209.16 | 189472.0 |
| 2015-11-11 09:00:00 | SPY | ETF | 209.16 | 209.17 | 208.85 | 208.85 | 467974.0 |
| 2015-11-11 09:30:00 | SPY | ETF | 208.88 | 208.9 | 208.35 | 208.4 | 9798137.0 |
| 2015-11-11 10:00:00 | SPY | ETF | 208.41 | 208.5 | 207.98 | 208.11 | 5483753.0 |
| 2015-11-11 10:30:00 | SPY | ETF | 208.11 | 208.2 | 207.68 | 207.9801 | 5819297.0 |
| 2015-11-11 11:00:00 | SPY | ETF | 207.99 | 208.12 | 207.79 | 208.11 | 4156543.0 |
| 2015-11-11 11:30:00 | SPY | ETF | 208.11 | 208.46 | 208.11 | 208.38 | 3803425.0 |
| 2015-11-11 12:00:00 | SPY | ETF | 208.38 | 208.83 | 208.29 | 208.71 | 3529639.0 |
| 2015-11-11 12:30:00 | SPY | ETF | 208.71 | 208.94 | 208.66 | 208.71 | 2617153.0 |
| 2015-11-11 13:00:00 | SPY | ETF | 208.71 | 208.72 | 208.07 | 208.164 | 3950833.0 |
| 2015-11-11 13:30:00 | SPY | ETF | 208.16 | 208.37 | 208.01 | 208.13 | 3034207.0 |
| 2015-11-11 14:00:00 | SPY | ETF | 208.13 | 208.43 | 208.04 | 208.43 | 3329986.0 |
| 2015-11-11 14:30:00 | SPY | ETF | 208.43 | 208.47 | 207.84 | 207.84 | 4154154.0 |
| 2015-11-11 15:00:00 | SPY | ETF | 207.84 | 208.05 | 207.74 | 208.04 | 5388161.0 |
| 2015-11-11 15:30:00 | SPY | ETF | 208.03 | 208.07 | 207.66 | 207.71 | 7638374.0 |
| 2015-11-11 16:00:00 | SPY | ETF | 207.71 | 207.818 | 207.53 | 207.62 | 2838025.0 |
| 2015-11-11 16:30:00 | SPY | ETF | 207.62 | 207.66 | 207.51 | 207.6 | 124483.0 |
| 2015-11-11 17:00:00 | SPY | ETF | 207.53 | 207.61 | 207.52 | 207.59 | 76687.0 |
| 2015-11-11 17:30:00 | SPY | ETF | 207.59 | 207.61 | 207.53 | 207.54 | 26691.0 |
| 2015-11-11 18:00:00 | SPY | ETF | 207.55 | 207.63 | 207.53 | 207.6 | 43415.0 |
| 2015-11-11 18:30:00 | SPY | ETF | 207.63 | 207.64 | 207.57 | 207.61 | 20793.0 |
| 2015-11-11 19:00:00 | SPY | ETF | 207.61 | 207.61 | 207.55 | 207.6 | 14848.0 |
| 2015-11-11 19:30:00 | SPY | ETF | 207.61 | 207.71 | 207.61 | 207.71 | 29972.0 |
| 2015-11-11 04:00:00 | QQQ | ETF | 113.58 | 113.7 | 113.58 | 113.7 | 1199.0 |
| 2015-11-11 04:30:00 | QQQ | ETF | 113.67 | 113.67 | 113.67 | 113.67 | 2000.0 |
| 2015-11-11 05:00:00 | QQQ | ETF | 113.6 | 113.6 | 113.6 | 113.6 | 1000.0 |
| 2015-11-11 05:30:00 | QQQ | ETF | 113.61 | 113.62 | 113.61 | 113.62 | 10000.0 |
| 2015-11-11 06:00:00 | QQQ | ETF | 113.61 | 113.62 | 113.61 | 113.62 | 300.0 |
| 2015-11-11 06:30:00 | QQQ | ETF | 113.58 | 113.69 | 113.58 | 113.69 | 1100.0 |
| 2015-11-11 07:00:00 | QQQ | ETF | 113.73 | 113.75 | 113.65 | 113.69 | 11170.0 |
| 2015-11-11 07:30:00 | QQQ | ETF | 113.72 | 113.81 | 113.72 | 113.81 | 5700.0 |
| 2015-11-11 08:00:00 | QQQ | ETF | 113.81 | 114.4 | 113.68 | 113.72 | 235800.0 |
| 2015-11-11 08:30:00 | QQQ | ETF | 113.72 | 113.72 | 113.65 | 113.71 | 136803.0 |
| 2015-11-11 09:00:00 | QQQ | ETF | 113.7 | 113.7 | 113.57 | 113.57 | 56105.0 |
| 2015-11-11 09:30:00 | QQQ | ETF | 113.59 | 113.61 | 113.17 | 113.21 | 3371267.0 |
| 2015-11-11 10:00:00 | QQQ | ETF | 113.21 | 113.3199 | 113.02 | 113.3 | 1256044.0 |
| 2015-11-11 10:30:00 | QQQ | ETF | 113.29 | 113.3654 | 112.95 | 113.15 | 1417192.0 |
| 2015-11-11 11:00:00 | QQQ | ETF | 113.16 | 113.4 | 113.0275 | 113.4 | 1275878.0 |
| 2015-11-11 11:30:00 | QQQ | ETF | 113.41 | 113.6 | 113.41 | 113.57 | 813149.0 |
| 2015-11-11 12:00:00 | QQQ | ETF | 113.57 | 114.07 | 113.52 | 113.961 | 2360167.0 |
| 2015-11-11 12:30:00 | QQQ | ETF | 113.97 | 114.14 | 113.93 | 113.97 | 1698508.0 |
> showing 50 of 12,270 rows — these rows as CSV