PREVIEW / etf_30min / 2015-07-27
file: by_date/etf_30min/2015/2015-07-27.parquet size: 395 KB rows: 13,466
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-07-27 04:00:00 | SPY | ETF | 207.86 | 208.25 | 207.55 | 208.21 | 14567.0 |
| 2015-07-27 04:30:00 | SPY | ETF | 208.27 | 208.27 | 208.15 | 208.25 | 6330.0 |
| 2015-07-27 05:00:00 | SPY | ETF | 208.11 | 208.18 | 208.05 | 208.06 | 7871.0 |
| 2015-07-27 05:30:00 | SPY | ETF | 208.05 | 208.06 | 207.7 | 207.7 | 17573.0 |
| 2015-07-27 06:00:00 | SPY | ETF | 207.77 | 207.8 | 207.61 | 207.72 | 83981.0 |
| 2015-07-27 06:30:00 | SPY | ETF | 207.74 | 207.76 | 207.5 | 207.5 | 161306.0 |
| 2015-07-27 07:00:00 | SPY | ETF | 207.5 | 207.5 | 207.04 | 207.25 | 327833.0 |
| 2015-07-27 07:30:00 | SPY | ETF | 207.28 | 207.46 | 207.25 | 207.27 | 147291.0 |
| 2015-07-27 08:00:00 | SPY | ETF | 207.3 | 208.61 | 207.05 | 207.19 | 960492.0 |
| 2015-07-27 08:30:00 | SPY | ETF | 207.23 | 207.29 | 207.08 | 207.22 | 601825.0 |
| 2015-07-27 09:00:00 | SPY | ETF | 207.21 | 207.32 | 206.79 | 206.94 | 967961.0 |
| 2015-07-27 09:30:00 | SPY | ETF | 206.94 | 207.08 | 206.26 | 206.9 | 19063979.0 |
| 2015-07-27 10:00:00 | SPY | ETF | 206.9 | 207.16 | 206.4 | 206.91 | 9670675.0 |
| 2015-07-27 10:30:00 | SPY | ETF | 206.9 | 207.55 | 206.87 | 207.16 | 10479711.0 |
| 2015-07-27 11:00:00 | SPY | ETF | 207.16 | 207.47 | 206.8 | 206.931 | 6195827.0 |
| 2015-07-27 11:30:00 | SPY | ETF | 206.94 | 207.16 | 206.75 | 207.08 | 5040921.0 |
| 2015-07-27 12:00:00 | SPY | ETF | 207.09 | 207.135 | 206.76 | 206.95 | 2918843.0 |
| 2015-07-27 12:30:00 | SPY | ETF | 206.95 | 207.01 | 206.64 | 206.74 | 3409510.0 |
| 2015-07-27 13:00:00 | SPY | ETF | 206.73 | 206.88 | 206.53 | 206.66 | 4370497.0 |
| 2015-07-27 13:30:00 | SPY | ETF | 206.67 | 206.955 | 206.5 | 206.85 | 4868501.0 |
| 2015-07-27 14:00:00 | SPY | ETF | 206.84 | 207.13 | 206.75 | 206.88 | 5414937.0 |
| 2015-07-27 14:30:00 | SPY | ETF | 206.89 | 207.01 | 206.68 | 206.83 | 7295418.0 |
| 2015-07-27 15:00:00 | SPY | ETF | 206.82 | 206.825 | 206.49 | 206.5201 | 9268376.0 |
| 2015-07-27 15:30:00 | SPY | ETF | 206.53 | 206.82 | 206.31 | 206.76 | 22619241.0 |
| 2015-07-27 16:00:00 | SPY | ETF | 206.76 | 207.14 | 206.7035 | 207.1 | 5734351.0 |
| 2015-07-27 16:30:00 | SPY | ETF | 207.12 | 207.13 | 207.04 | 207.09 | 1704768.0 |
| 2015-07-27 17:00:00 | SPY | ETF | 207.08 | 207.15 | 207.05 | 207.13 | 92804.0 |
| 2015-07-27 17:30:00 | SPY | ETF | 207.12 | 207.16 | 207.09 | 207.16 | 42166.0 |
| 2015-07-27 18:00:00 | SPY | ETF | 207.17 | 207.25 | 207.09 | 207.12 | 355638.0 |
| 2015-07-27 18:30:00 | SPY | ETF | 207.12 | 207.22 | 206.79 | 207.19 | 4555480.0 |
| 2015-07-27 19:00:00 | SPY | ETF | 207.19 | 207.27 | 207.175 | 207.21 | 90258.0 |
| 2015-07-27 19:30:00 | SPY | ETF | 207.2 | 207.24 | 207.18 | 207.2 | 162131.0 |
| 2015-07-27 04:00:00 | QQQ | ETF | 111.0 | 111.0 | 111.0 | 111.0 | 200.0 |
| 2015-07-27 04:30:00 | QQQ | ETF | 111.15 | 111.15 | 111.15 | 111.15 | 100.0 |
| 2015-07-27 05:00:00 | QQQ | ETF | 111.1 | 111.1 | 111.1 | 111.1 | 100.0 |
| 2015-07-27 05:30:00 | QQQ | ETF | 110.99 | 110.99 | 110.88 | 110.88 | 12500.0 |
| 2015-07-27 06:00:00 | QQQ | ETF | 110.9 | 110.9 | 110.83 | 110.83 | 9950.0 |
| 2015-07-27 06:30:00 | QQQ | ETF | 110.83 | 110.83 | 110.77 | 110.77 | 9700.0 |
| 2015-07-27 07:00:00 | QQQ | ETF | 110.71 | 110.71 | 110.44 | 110.55 | 65215.0 |
| 2015-07-27 07:30:00 | QQQ | ETF | 110.58 | 110.7 | 110.56 | 110.58 | 64343.0 |
| 2015-07-27 08:00:00 | QQQ | ETF | 110.6 | 110.65 | 110.48 | 110.6 | 97272.0 |
| 2015-07-27 08:30:00 | QQQ | ETF | 110.58 | 110.62 | 110.47 | 110.62 | 93650.0 |
| 2015-07-27 09:00:00 | QQQ | ETF | 110.65 | 110.67 | 110.41 | 110.46 | 165542.0 |
| 2015-07-27 09:30:00 | QQQ | ETF | 110.47 | 110.6696 | 110.02 | 110.615 | 6512631.0 |
| 2015-07-27 10:00:00 | QQQ | ETF | 110.61 | 110.64 | 110.23 | 110.53 | 3342565.0 |
| 2015-07-27 10:30:00 | QQQ | ETF | 110.52 | 110.946 | 110.49 | 110.68 | 2682945.0 |
| 2015-07-27 11:00:00 | QQQ | ETF | 110.68 | 110.87 | 110.3684 | 110.42 | 1660021.0 |
| 2015-07-27 11:30:00 | QQQ | ETF | 110.43 | 110.49 | 110.26 | 110.43 | 1587271.0 |
| 2015-07-27 12:00:00 | QQQ | ETF | 110.44 | 110.48 | 110.22 | 110.39 | 641008.0 |
| 2015-07-27 12:30:00 | QQQ | ETF | 110.389 | 110.4277 | 110.15 | 110.21 | 619631.0 |
> showing 50 of 13,466 rows — these rows as CSV