PREVIEW / etf_30min / 2015-03-30
file: by_date/etf_30min/2015/2015-03-30.parquet size: 375 KB rows: 12,636
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-03-30 04:00:00 | SPY | ETF | 206.23 | 207.3 | 206.23 | 207.08 | 26992.0 |
| 2015-03-30 04:30:00 | SPY | ETF | 207.06 | 207.15 | 207.06 | 207.08 | 7202.0 |
| 2015-03-30 05:00:00 | SPY | ETF | 207.06 | 207.15 | 207.01 | 207.15 | 29180.0 |
| 2015-03-30 05:30:00 | SPY | ETF | 207.05 | 207.09 | 207.03 | 207.06 | 7011.0 |
| 2015-03-30 06:00:00 | SPY | ETF | 207.03 | 207.05 | 206.92 | 206.92 | 3152.0 |
| 2015-03-30 06:30:00 | SPY | ETF | 206.91 | 206.92 | 206.62 | 206.62 | 41080.0 |
| 2015-03-30 07:00:00 | SPY | ETF | 206.65 | 206.78 | 206.61 | 206.78 | 131474.0 |
| 2015-03-30 07:30:00 | SPY | ETF | 206.78 | 206.83 | 206.72 | 206.76 | 146392.0 |
| 2015-03-30 08:00:00 | SPY | ETF | 206.76 | 206.86 | 206.06 | 206.86 | 236080.0 |
| 2015-03-30 08:30:00 | SPY | ETF | 206.84 | 206.92 | 206.68 | 206.76 | 259557.0 |
| 2015-03-30 09:00:00 | SPY | ETF | 206.75 | 207.0 | 205.74 | 206.98 | 481236.0 |
| 2015-03-30 09:30:00 | SPY | ETF | 206.98 | 208.05 | 206.96 | 207.93 | 15438499.0 |
| 2015-03-30 10:00:00 | SPY | ETF | 207.935 | 208.1 | 207.52 | 207.645 | 8867619.0 |
| 2015-03-30 10:30:00 | SPY | ETF | 207.66 | 207.9839 | 207.57 | 207.84 | 5043516.0 |
| 2015-03-30 11:00:00 | SPY | ETF | 207.85 | 207.95 | 207.665 | 207.88 | 4620106.0 |
| 2015-03-30 11:30:00 | SPY | ETF | 207.87 | 208.0 | 207.76 | 207.93 | 2828318.0 |
| 2015-03-30 12:00:00 | SPY | ETF | 207.93 | 208.21 | 207.9 | 208.1099 | 4509385.0 |
| 2015-03-30 12:30:00 | SPY | ETF | 208.1099 | 208.23 | 208.02 | 208.18 | 4494712.0 |
| 2015-03-30 13:00:00 | SPY | ETF | 208.18 | 208.41 | 208.16 | 208.4099 | 3441243.0 |
| 2015-03-30 13:30:00 | SPY | ETF | 208.41 | 208.48 | 208.14 | 208.2749 | 3861800.0 |
| 2015-03-30 14:00:00 | SPY | ETF | 208.274 | 208.54 | 208.27 | 208.37 | 4232513.0 |
| 2015-03-30 14:30:00 | SPY | ETF | 208.37 | 208.53 | 208.31 | 208.52 | 2703292.0 |
| 2015-03-30 15:00:00 | SPY | ETF | 208.53 | 208.61 | 208.32 | 208.405 | 6010770.0 |
| 2015-03-30 15:30:00 | SPY | ETF | 208.41 | 208.53 | 208.245 | 208.26 | 11862167.0 |
| 2015-03-30 16:00:00 | SPY | ETF | 208.27 | 208.33 | 207.8679 | 208.07 | 5434042.0 |
| 2015-03-30 16:30:00 | SPY | ETF | 208.07 | 208.3015 | 207.89 | 207.89 | 8070590.0 |
| 2015-03-30 17:00:00 | SPY | ETF | 207.89 | 208.25 | 207.88 | 208.25 | 763684.0 |
| 2015-03-30 17:30:00 | SPY | ETF | 208.25 | 208.25 | 207.92 | 207.96 | 633625.0 |
| 2015-03-30 18:00:00 | SPY | ETF | 207.96 | 208.11 | 207.95 | 208.05 | 93879.0 |
| 2015-03-30 18:30:00 | SPY | ETF | 208.03 | 208.03 | 207.95 | 208.01 | 40492.0 |
| 2015-03-30 19:00:00 | SPY | ETF | 208.0 | 208.07 | 207.98 | 208.05 | 14805.0 |
| 2015-03-30 19:30:00 | SPY | ETF | 208.03 | 208.04 | 207.99 | 208.03 | 28821.0 |
| 2015-03-30 04:00:00 | QQQ | ETF | 106.1 | 106.53 | 106.1 | 106.5 | 2970.0 |
| 2015-03-30 04:30:00 | QQQ | ETF | 106.51 | 106.51 | 106.48 | 106.48 | 5100.0 |
| 2015-03-30 05:00:00 | QQQ | ETF | 106.45 | 106.48 | 106.45 | 106.48 | 8473.0 |
| 2015-03-30 06:00:00 | QQQ | ETF | 106.48 | 106.48 | 106.48 | 106.48 | 200.0 |
| 2015-03-30 06:30:00 | QQQ | ETF | 106.26 | 106.39 | 106.23 | 106.23 | 3700.0 |
| 2015-03-30 07:00:00 | QQQ | ETF | 106.23 | 106.34 | 106.16 | 106.27 | 21200.0 |
| 2015-03-30 07:30:00 | QQQ | ETF | 106.27 | 106.3 | 106.21 | 106.23 | 48990.0 |
| 2015-03-30 08:00:00 | QQQ | ETF | 106.22 | 106.29 | 106.2 | 106.29 | 48268.0 |
| 2015-03-30 08:30:00 | QQQ | ETF | 106.28 | 106.3 | 106.19 | 106.19 | 79232.0 |
| 2015-03-30 09:00:00 | QQQ | ETF | 106.2 | 106.27 | 106.17 | 106.17 | 160505.0 |
| 2015-03-30 09:30:00 | QQQ | ETF | 106.17 | 106.775 | 106.16 | 106.66 | 5700854.0 |
| 2015-03-30 10:00:00 | QQQ | ETF | 106.66 | 106.82 | 106.22 | 106.26 | 2926158.0 |
| 2015-03-30 10:30:00 | QQQ | ETF | 106.2676 | 106.46 | 106.24 | 106.42 | 1630646.0 |
| 2015-03-30 11:00:00 | QQQ | ETF | 106.42 | 106.6 | 106.33 | 106.49 | 1283645.0 |
| 2015-03-30 11:30:00 | QQQ | ETF | 106.49 | 106.52 | 106.3 | 106.44 | 948660.0 |
| 2015-03-30 12:00:00 | QQQ | ETF | 106.4301 | 106.6 | 106.39 | 106.56 | 1236667.0 |
| 2015-03-30 12:30:00 | QQQ | ETF | 106.57 | 106.64 | 106.49 | 106.59 | 767202.0 |
| 2015-03-30 13:00:00 | QQQ | ETF | 106.6 | 106.74 | 106.58 | 106.73 | 731998.0 |
> showing 50 of 12,636 rows — these rows as CSV