PREVIEW / etf_30min / 2015-06-16
file: by_date/etf_30min/2015/2015-06-16.parquet size: 372 KB rows: 12,512
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-06-16 04:00:00 | SPY | ETF | 208.0 | 208.27 | 207.48 | 208.14 | 19223.0 |
| 2015-06-16 04:30:00 | SPY | ETF | 208.1 | 208.41 | 208.08 | 208.29 | 6145.0 |
| 2015-06-16 05:00:00 | SPY | ETF | 208.2 | 208.2 | 208.0 | 208.0 | 7800.0 |
| 2015-06-16 05:30:00 | SPY | ETF | 208.0 | 208.13 | 207.92 | 207.96 | 4921.0 |
| 2015-06-16 06:00:00 | SPY | ETF | 207.99 | 208.04 | 207.9 | 207.96 | 19695.0 |
| 2015-06-16 06:30:00 | SPY | ETF | 207.96 | 208.11 | 207.87 | 208.07 | 23020.0 |
| 2015-06-16 07:00:00 | SPY | ETF | 208.15 | 208.63 | 208.13 | 208.44 | 85195.0 |
| 2015-06-16 07:30:00 | SPY | ETF | 208.42 | 208.77 | 208.38 | 208.49 | 275223.0 |
| 2015-06-16 08:00:00 | SPY | ETF | 208.2 | 208.89 | 208.18 | 208.47 | 335974.0 |
| 2015-06-16 08:30:00 | SPY | ETF | 208.44 | 208.72 | 208.39 | 208.71 | 594447.0 |
| 2015-06-16 09:00:00 | SPY | ETF | 208.71 | 208.97 | 208.55 | 208.93 | 813799.0 |
| 2015-06-16 09:30:00 | SPY | ETF | 208.93 | 209.72 | 208.72 | 209.415 | 13740249.0 |
| 2015-06-16 10:00:00 | SPY | ETF | 209.41 | 209.56 | 208.87 | 209.22 | 10423435.0 |
| 2015-06-16 10:30:00 | SPY | ETF | 209.215 | 209.5199 | 209.05 | 209.26 | 5442046.0 |
| 2015-06-16 11:00:00 | SPY | ETF | 209.26 | 209.87 | 209.2 | 209.61 | 6100660.0 |
| 2015-06-16 11:30:00 | SPY | ETF | 209.6 | 209.74 | 209.56 | 209.67 | 4407591.0 |
| 2015-06-16 12:00:00 | SPY | ETF | 209.67 | 209.77 | 209.59 | 209.76 | 3079464.0 |
| 2015-06-16 12:30:00 | SPY | ETF | 209.75 | 210.03 | 209.75 | 209.99 | 3477024.0 |
| 2015-06-16 13:00:00 | SPY | ETF | 209.99 | 210.15 | 209.92 | 210.12 | 2894660.0 |
| 2015-06-16 13:30:00 | SPY | ETF | 210.12 | 210.23 | 210.07 | 210.1101 | 3466293.0 |
| 2015-06-16 14:00:00 | SPY | ETF | 210.12 | 210.35 | 210.12 | 210.245 | 3702987.0 |
| 2015-06-16 14:30:00 | SPY | ETF | 210.245 | 210.33 | 210.14 | 210.269 | 3970409.0 |
| 2015-06-16 15:00:00 | SPY | ETF | 210.265 | 210.34 | 210.14 | 210.24 | 5025794.0 |
| 2015-06-16 15:30:00 | SPY | ETF | 210.24 | 210.33 | 210.12 | 210.26 | 10063644.0 |
| 2015-06-16 16:00:00 | SPY | ETF | 210.27 | 210.39 | 210.175 | 210.35 | 6266236.0 |
| 2015-06-16 16:30:00 | SPY | ETF | 210.35 | 210.45 | 210.25 | 210.4 | 481703.0 |
| 2015-06-16 17:00:00 | SPY | ETF | 210.43 | 210.43 | 210.38 | 210.41 | 65936.0 |
| 2015-06-16 17:30:00 | SPY | ETF | 210.41 | 210.43 | 210.4 | 210.43 | 10031.0 |
| 2015-06-16 18:00:00 | SPY | ETF | 210.43 | 210.5 | 210.4 | 210.46 | 41009.0 |
| 2015-06-16 18:30:00 | SPY | ETF | 210.45 | 210.46 | 210.4185 | 210.45 | 13867.0 |
| 2015-06-16 19:00:00 | SPY | ETF | 210.44 | 210.45 | 210.42 | 210.44 | 11992.0 |
| 2015-06-16 19:30:00 | SPY | ETF | 210.43 | 210.45 | 210.4 | 210.43 | 78778.0 |
| 2015-06-16 04:00:00 | QQQ | ETF | 107.63 | 107.77 | 107.63 | 107.77 | 11450.0 |
| 2015-06-16 04:30:00 | QQQ | ETF | 107.71 | 107.71 | 107.71 | 107.71 | 1000.0 |
| 2015-06-16 05:30:00 | QQQ | ETF | 107.66 | 107.66 | 107.66 | 107.66 | 300.0 |
| 2015-06-16 06:00:00 | QQQ | ETF | 107.58 | 107.68 | 107.58 | 107.62 | 14600.0 |
| 2015-06-16 06:30:00 | QQQ | ETF | 107.61 | 107.7 | 107.58 | 107.63 | 20749.0 |
| 2015-06-16 07:00:00 | QQQ | ETF | 107.75 | 107.9 | 107.71 | 107.84 | 17350.0 |
| 2015-06-16 07:30:00 | QQQ | ETF | 107.85 | 108.04 | 107.84 | 107.98 | 11200.0 |
| 2015-06-16 08:00:00 | QQQ | ETF | 107.92 | 107.92 | 107.73 | 107.85 | 40151.0 |
| 2015-06-16 08:30:00 | QQQ | ETF | 107.89 | 108.03 | 107.87 | 108.03 | 61581.0 |
| 2015-06-16 09:00:00 | QQQ | ETF | 108.02 | 108.14 | 107.95 | 108.09 | 86911.0 |
| 2015-06-16 09:30:00 | QQQ | ETF | 108.1 | 108.59 | 108.05 | 108.38 | 2834171.0 |
| 2015-06-16 10:00:00 | QQQ | ETF | 108.36 | 108.52 | 108.05 | 108.3 | 1440897.0 |
| 2015-06-16 10:30:00 | QQQ | ETF | 108.29 | 108.4 | 108.2 | 108.27 | 1014029.0 |
| 2015-06-16 11:00:00 | QQQ | ETF | 108.265 | 108.6 | 108.26 | 108.46 | 983265.0 |
| 2015-06-16 11:30:00 | QQQ | ETF | 108.46 | 108.5145 | 108.42 | 108.4401 | 618484.0 |
| 2015-06-16 12:00:00 | QQQ | ETF | 108.45 | 108.54 | 108.4 | 108.5392 | 419305.0 |
| 2015-06-16 12:30:00 | QQQ | ETF | 108.54 | 108.75 | 108.54 | 108.73 | 960530.0 |
| 2015-06-16 13:00:00 | QQQ | ETF | 108.74 | 108.85 | 108.67 | 108.82 | 938531.0 |
> showing 50 of 12,512 rows — these rows as CSV