PREVIEW / etf_30min / 2015-02-18
file: by_date/etf_30min/2015/2015-02-18.parquet size: 376 KB rows: 12,617
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-02-18 04:00:00 | SPY | ETF | 210.19 | 210.19 | 210.19 | 210.19 | 400.0 |
| 2015-02-18 04:30:00 | SPY | ETF | 210.1 | 210.1 | 210.1 | 210.1 | 100.0 |
| 2015-02-18 05:00:00 | SPY | ETF | 210.09 | 210.09 | 209.84 | 209.92 | 2800.0 |
| 2015-02-18 05:30:00 | SPY | ETF | 209.93 | 209.93 | 209.88 | 209.88 | 1800.0 |
| 2015-02-18 06:00:00 | SPY | ETF | 210.02 | 210.1 | 210.0 | 210.0 | 31401.0 |
| 2015-02-18 06:30:00 | SPY | ETF | 209.92 | 210.01 | 209.92 | 210.01 | 33801.0 |
| 2015-02-18 07:00:00 | SPY | ETF | 210.01 | 210.06 | 209.94 | 209.95 | 58342.0 |
| 2015-02-18 07:30:00 | SPY | ETF | 209.95 | 209.95 | 209.85 | 209.92 | 43372.0 |
| 2015-02-18 08:00:00 | SPY | ETF | 209.95 | 209.99 | 209.77 | 209.8 | 155014.0 |
| 2015-02-18 08:30:00 | SPY | ETF | 209.78 | 209.88 | 209.73 | 209.75 | 165998.0 |
| 2015-02-18 09:00:00 | SPY | ETF | 209.74 | 209.74 | 209.48 | 209.64 | 474705.0 |
| 2015-02-18 09:30:00 | SPY | ETF | 209.66 | 209.92 | 209.49 | 209.76 | 7826402.0 |
| 2015-02-18 10:00:00 | SPY | ETF | 209.75 | 209.82 | 209.3401 | 209.45 | 6316442.0 |
| 2015-02-18 10:30:00 | SPY | ETF | 209.44 | 209.8649 | 209.4 | 209.73 | 4101441.0 |
| 2015-02-18 11:00:00 | SPY | ETF | 209.72 | 209.88 | 209.61 | 209.847 | 2889686.0 |
| 2015-02-18 11:30:00 | SPY | ETF | 209.85 | 209.905 | 209.7 | 209.73 | 2902653.0 |
| 2015-02-18 12:00:00 | SPY | ETF | 209.725 | 209.86 | 209.72 | 209.7999 | 1837500.0 |
| 2015-02-18 12:30:00 | SPY | ETF | 209.795 | 209.81 | 209.465 | 209.51 | 3510513.0 |
| 2015-02-18 13:00:00 | SPY | ETF | 209.51 | 209.66 | 209.43 | 209.55 | 2614866.0 |
| 2015-02-18 13:30:00 | SPY | ETF | 209.56 | 209.74 | 209.49 | 209.59 | 4521183.0 |
| 2015-02-18 14:00:00 | SPY | ETF | 209.59 | 210.18 | 209.57 | 209.62 | 11118008.0 |
| 2015-02-18 14:30:00 | SPY | ETF | 209.625 | 209.9 | 209.6 | 209.86 | 4426130.0 |
| 2015-02-18 15:00:00 | SPY | ETF | 209.86 | 210.22 | 209.85 | 210.13 | 7692135.0 |
| 2015-02-18 15:30:00 | SPY | ETF | 210.13 | 210.15 | 209.8756 | 210.15 | 7901160.0 |
| 2015-02-18 16:00:00 | SPY | ETF | 210.15 | 210.15 | 209.69 | 210.05 | 4821759.0 |
| 2015-02-18 16:30:00 | SPY | ETF | 210.05 | 210.07 | 209.98 | 210.01 | 2690534.0 |
| 2015-02-18 17:00:00 | SPY | ETF | 210.01 | 210.03 | 209.99 | 210.03 | 1029947.0 |
| 2015-02-18 17:30:00 | SPY | ETF | 210.02 | 210.03 | 210.02 | 210.03 | 4825.0 |
| 2015-02-18 18:00:00 | SPY | ETF | 210.03 | 210.04 | 209.97 | 209.97 | 10646.0 |
| 2015-02-18 18:30:00 | SPY | ETF | 209.99 | 209.99 | 209.97 | 209.98 | 12256.0 |
| 2015-02-18 19:00:00 | SPY | ETF | 209.97 | 209.97 | 209.91 | 209.92 | 534472.0 |
| 2015-02-18 19:30:00 | SPY | ETF | 209.92 | 209.95 | 209.91 | 209.94 | 32978.0 |
| 2015-02-18 04:00:00 | QQQ | ETF | 107.08 | 107.09 | 107.08 | 107.09 | 425.0 |
| 2015-02-18 05:30:00 | QQQ | ETF | 107.08 | 107.09 | 107.05 | 107.05 | 5000.0 |
| 2015-02-18 07:00:00 | QQQ | ETF | 106.99 | 106.99 | 106.94 | 106.94 | 6000.0 |
| 2015-02-18 07:30:00 | QQQ | ETF | 106.92 | 106.98 | 106.91 | 106.95 | 3100.0 |
| 2015-02-18 08:00:00 | QQQ | ETF | 106.95 | 107.01 | 106.92 | 106.93 | 24788.0 |
| 2015-02-18 08:30:00 | QQQ | ETF | 106.88 | 106.9 | 106.86 | 106.86 | 33768.0 |
| 2015-02-18 09:00:00 | QQQ | ETF | 106.85 | 106.9 | 106.8 | 106.88 | 113316.0 |
| 2015-02-18 09:30:00 | QQQ | ETF | 106.88 | 107.03 | 106.8201 | 106.98 | 2059057.0 |
| 2015-02-18 10:00:00 | QQQ | ETF | 106.98 | 107.02 | 106.74 | 106.79 | 1168118.0 |
| 2015-02-18 10:30:00 | QQQ | ETF | 106.79 | 107.04 | 106.79 | 106.979 | 1130510.0 |
| 2015-02-18 11:00:00 | QQQ | ETF | 106.97 | 107.01 | 106.9001 | 106.98 | 507130.0 |
| 2015-02-18 11:30:00 | QQQ | ETF | 106.98 | 107.0 | 106.89 | 106.935 | 503092.0 |
| 2015-02-18 12:00:00 | QQQ | ETF | 106.93 | 107.0 | 106.894 | 106.93 | 541474.0 |
| 2015-02-18 12:30:00 | QQQ | ETF | 106.92 | 106.95 | 106.8 | 106.83 | 613026.0 |
| 2015-02-18 13:00:00 | QQQ | ETF | 106.83 | 106.9 | 106.82 | 106.9 | 363847.0 |
| 2015-02-18 13:30:00 | QQQ | ETF | 106.91 | 106.95 | 106.82 | 106.84 | 609562.0 |
| 2015-02-18 14:00:00 | QQQ | ETF | 106.84 | 107.11 | 106.78 | 106.8237 | 1955034.0 |
| 2015-02-18 14:30:00 | QQQ | ETF | 106.825 | 107.0 | 106.81 | 106.99 | 464776.0 |
> showing 50 of 12,617 rows — these rows as CSV