PREVIEW / etf_30min / 2015-11-09
file: by_date/etf_30min/2015/2015-11-09.parquet size: 389 KB rows: 13,123
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-09 04:00:00 | SPY | ETF | 209.62 | 209.71 | 209.47 | 209.58 | 11808.0 |
| 2015-11-09 04:30:00 | SPY | ETF | 209.58 | 209.68 | 209.55 | 209.64 | 53966.0 |
| 2015-11-09 05:00:00 | SPY | ETF | 209.59 | 209.64 | 209.33 | 209.34 | 21856.0 |
| 2015-11-09 05:30:00 | SPY | ETF | 209.4 | 209.47 | 209.34 | 209.36 | 2172.0 |
| 2015-11-09 06:00:00 | SPY | ETF | 209.42 | 209.54 | 209.42 | 209.45 | 8004.0 |
| 2015-11-09 06:30:00 | SPY | ETF | 209.44 | 209.44 | 209.3 | 209.42 | 49895.0 |
| 2015-11-09 07:00:00 | SPY | ETF | 209.45 | 209.52 | 209.41 | 209.41 | 57100.0 |
| 2015-11-09 07:30:00 | SPY | ETF | 209.43 | 209.46 | 209.32 | 209.43 | 45997.0 |
| 2015-11-09 08:00:00 | SPY | ETF | 209.46 | 209.72 | 209.39 | 209.47 | 241386.0 |
| 2015-11-09 08:30:00 | SPY | ETF | 209.48 | 209.63 | 209.43 | 209.43 | 157758.0 |
| 2015-11-09 09:00:00 | SPY | ETF | 209.43 | 209.49 | 209.31 | 209.31 | 412888.0 |
| 2015-11-09 09:30:00 | SPY | ETF | 209.31 | 209.49 | 208.59 | 208.62 | 12758917.0 |
| 2015-11-09 10:00:00 | SPY | ETF | 208.62 | 208.73 | 207.92 | 208.09 | 11594333.0 |
| 2015-11-09 10:30:00 | SPY | ETF | 208.08 | 208.31 | 207.92 | 208.2299 | 10013191.0 |
| 2015-11-09 11:00:00 | SPY | ETF | 208.2201 | 209.33 | 207.22 | 207.269 | 12303135.0 |
| 2015-11-09 11:30:00 | SPY | ETF | 207.265 | 207.56 | 207.13 | 207.18 | 8536761.0 |
| 2015-11-09 12:00:00 | SPY | ETF | 207.17 | 207.47 | 206.95 | 207.46 | 7228832.0 |
| 2015-11-09 12:30:00 | SPY | ETF | 207.46 | 207.74 | 207.35 | 207.72 | 4465461.0 |
| 2015-11-09 13:00:00 | SPY | ETF | 207.71 | 207.81 | 207.22 | 207.529 | 5902440.0 |
| 2015-11-09 13:30:00 | SPY | ETF | 207.53 | 207.82 | 207.39 | 207.69 | 4740746.0 |
| 2015-11-09 14:00:00 | SPY | ETF | 207.69 | 207.92 | 207.53 | 207.79 | 5073130.0 |
| 2015-11-09 14:30:00 | SPY | ETF | 207.79 | 207.95 | 207.41 | 207.61 | 7500069.0 |
| 2015-11-09 15:00:00 | SPY | ETF | 207.61 | 207.755 | 207.28 | 207.7 | 8377338.0 |
| 2015-11-09 15:30:00 | SPY | ETF | 207.7 | 208.48 | 207.69 | 208.06 | 19108548.0 |
| 2015-11-09 16:00:00 | SPY | ETF | 208.05 | 208.21 | 207.97 | 208.0 | 7421875.0 |
| 2015-11-09 16:30:00 | SPY | ETF | 208.03 | 210.0788 | 207.88 | 207.93 | 4164764.0 |
| 2015-11-09 17:00:00 | SPY | ETF | 207.98 | 208.08 | 207.89 | 207.96 | 52234.0 |
| 2015-11-09 17:30:00 | SPY | ETF | 207.93 | 207.97 | 207.93 | 207.95 | 4396.0 |
| 2015-11-09 18:00:00 | SPY | ETF | 207.99 | 208.02 | 207.73 | 207.93 | 76657.0 |
| 2015-11-09 18:30:00 | SPY | ETF | 207.94 | 207.98 | 207.93 | 207.95 | 10195.0 |
| 2015-11-09 19:00:00 | SPY | ETF | 207.98 | 208.21 | 207.94 | 208.13 | 48069.0 |
| 2015-11-09 19:30:00 | SPY | ETF | 208.15 | 208.18 | 208.04 | 208.07 | 13017.0 |
| 2015-11-09 04:00:00 | QQQ | ETF | 114.6 | 114.7 | 114.6 | 114.7 | 660.0 |
| 2015-11-09 04:30:00 | QQQ | ETF | 114.65 | 114.66 | 114.65 | 114.66 | 566.0 |
| 2015-11-09 05:00:00 | QQQ | ETF | 114.56 | 114.56 | 114.54 | 114.54 | 1200.0 |
| 2015-11-09 05:30:00 | QQQ | ETF | 114.54 | 114.54 | 114.5 | 114.5 | 500.0 |
| 2015-11-09 06:00:00 | QQQ | ETF | 114.57 | 114.57 | 114.57 | 114.57 | 1500.0 |
| 2015-11-09 06:30:00 | QQQ | ETF | 114.51 | 114.53 | 114.51 | 114.53 | 260.0 |
| 2015-11-09 07:00:00 | QQQ | ETF | 114.55 | 114.55 | 114.48 | 114.48 | 2126.0 |
| 2015-11-09 07:30:00 | QQQ | ETF | 114.45 | 114.45 | 114.38 | 114.4 | 17150.0 |
| 2015-11-09 08:00:00 | QQQ | ETF | 114.57 | 114.58 | 114.38 | 114.44 | 12250.0 |
| 2015-11-09 08:30:00 | QQQ | ETF | 114.45 | 114.51 | 114.45 | 114.48 | 11042.0 |
| 2015-11-09 09:00:00 | QQQ | ETF | 114.42 | 114.46 | 114.34 | 114.38 | 101103.0 |
| 2015-11-09 09:30:00 | QQQ | ETF | 114.36 | 114.51 | 114.13 | 114.14 | 3806337.0 |
| 2015-11-09 10:00:00 | QQQ | ETF | 114.14 | 114.19 | 113.6199 | 113.7 | 2772216.0 |
| 2015-11-09 10:30:00 | QQQ | ETF | 113.695 | 113.82 | 113.58 | 113.769 | 1749901.0 |
| 2015-11-09 11:00:00 | QQQ | ETF | 113.765 | 113.78 | 112.97 | 113.0 | 3167645.0 |
| 2015-11-09 11:30:00 | QQQ | ETF | 113.01 | 113.17 | 112.91 | 112.93 | 1927798.0 |
| 2015-11-09 12:00:00 | QQQ | ETF | 112.94 | 113.24 | 112.865 | 113.234 | 1492530.0 |
| 2015-11-09 12:30:00 | QQQ | ETF | 113.23 | 113.3 | 113.12 | 113.28 | 906560.0 |
> showing 50 of 13,123 rows — these rows as CSV