PREVIEW / etf_30min / 2015-10-30
file: by_date/etf_30min/2015/2015-10-30.parquet size: 373 KB rows: 12,555
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-10-30 04:00:00 | SPY | ETF | 209.52 | 209.74 | 209.51 | 209.6 | 54219.0 |
| 2015-10-30 04:30:00 | SPY | ETF | 209.66 | 209.66 | 209.64 | 209.64 | 200.0 |
| 2015-10-30 05:00:00 | SPY | ETF | 209.59 | 209.62 | 209.35 | 209.46 | 8164.0 |
| 2015-10-30 05:30:00 | SPY | ETF | 209.38 | 209.4 | 209.34 | 209.36 | 2449.0 |
| 2015-10-30 06:00:00 | SPY | ETF | 209.2 | 209.2 | 209.02 | 209.05 | 36010.0 |
| 2015-10-30 06:30:00 | SPY | ETF | 209.04 | 209.23 | 209.03 | 209.2 | 39557.0 |
| 2015-10-30 07:00:00 | SPY | ETF | 209.2 | 209.23 | 209.07 | 209.21 | 80817.0 |
| 2015-10-30 07:30:00 | SPY | ETF | 209.2 | 209.25 | 209.14 | 209.18 | 243140.0 |
| 2015-10-30 08:00:00 | SPY | ETF | 209.15 | 209.94 | 209.05 | 209.34 | 383457.0 |
| 2015-10-30 08:30:00 | SPY | ETF | 209.34 | 209.43 | 209.29 | 209.38 | 125071.0 |
| 2015-10-30 09:00:00 | SPY | ETF | 209.36 | 209.37 | 209.06 | 209.07 | 461941.0 |
| 2015-10-30 09:30:00 | SPY | ETF | 209.06 | 209.23 | 208.56 | 208.6602 | 10372486.0 |
| 2015-10-30 10:00:00 | SPY | ETF | 208.66 | 208.82 | 208.39 | 208.58 | 7358252.0 |
| 2015-10-30 10:30:00 | SPY | ETF | 208.575 | 208.89 | 208.5 | 208.73 | 6697948.0 |
| 2015-10-30 11:00:00 | SPY | ETF | 208.73 | 208.81 | 208.47 | 208.65 | 3382931.0 |
| 2015-10-30 11:30:00 | SPY | ETF | 208.645 | 208.86 | 208.51 | 208.739 | 3741503.0 |
| 2015-10-30 12:00:00 | SPY | ETF | 208.735 | 208.96 | 208.5938 | 208.77 | 4873841.0 |
| 2015-10-30 12:30:00 | SPY | ETF | 208.78 | 209.32 | 208.78 | 209.2199 | 6950655.0 |
| 2015-10-30 13:00:00 | SPY | ETF | 209.215 | 209.35 | 209.09 | 209.23 | 5718953.0 |
| 2015-10-30 13:30:00 | SPY | ETF | 209.225 | 209.44 | 209.15 | 209.245 | 5915202.0 |
| 2015-10-30 14:00:00 | SPY | ETF | 209.245 | 209.35 | 208.8 | 208.8115 | 6468251.0 |
| 2015-10-30 14:30:00 | SPY | ETF | 208.81 | 208.88 | 208.37 | 208.41 | 9722716.0 |
| 2015-10-30 15:00:00 | SPY | ETF | 208.42 | 208.68 | 208.22 | 208.2351 | 11604955.0 |
| 2015-10-30 15:30:00 | SPY | ETF | 208.23 | 208.81 | 207.83 | 207.85 | 26325862.0 |
| 2015-10-30 16:00:00 | SPY | ETF | 207.86 | 208.06 | 207.61 | 208.04 | 14728154.0 |
| 2015-10-30 16:30:00 | SPY | ETF | 208.04 | 208.6321 | 207.9 | 208.02 | 628165.0 |
| 2015-10-30 17:00:00 | SPY | ETF | 208.0 | 208.02 | 207.96 | 207.99 | 198542.0 |
| 2015-10-30 17:30:00 | SPY | ETF | 207.99 | 208.0 | 207.94 | 208.0 | 17978.0 |
| 2015-10-30 18:00:00 | SPY | ETF | 208.0 | 208.08 | 208.0 | 208.08 | 14023.0 |
| 2015-10-30 18:30:00 | SPY | ETF | 208.08 | 208.09 | 208.05 | 208.06 | 17438.0 |
| 2015-10-30 19:00:00 | SPY | ETF | 208.04 | 208.06 | 208.04 | 208.05 | 1850.0 |
| 2015-10-30 19:30:00 | SPY | ETF | 208.06 | 208.06 | 207.98 | 208.03 | 17010.0 |
| 2015-10-30 04:00:00 | QQQ | ETF | 114.22 | 114.3 | 114.22 | 114.29 | 710.0 |
| 2015-10-30 04:30:00 | QQQ | ETF | 114.26 | 114.28 | 114.26 | 114.27 | 700.0 |
| 2015-10-30 05:30:00 | QQQ | ETF | 114.13 | 114.13 | 114.13 | 114.13 | 100.0 |
| 2015-10-30 06:00:00 | QQQ | ETF | 114.01 | 114.01 | 113.96 | 113.96 | 1800.0 |
| 2015-10-30 06:30:00 | QQQ | ETF | 113.84 | 113.84 | 113.84 | 113.84 | 500.0 |
| 2015-10-30 07:00:00 | QQQ | ETF | 113.95 | 113.95 | 113.9 | 113.9 | 825.0 |
| 2015-10-30 07:30:00 | QQQ | ETF | 113.98 | 113.98 | 113.96 | 113.97 | 4000.0 |
| 2015-10-30 08:00:00 | QQQ | ETF | 113.97 | 114.09 | 113.97 | 114.08 | 41668.0 |
| 2015-10-30 08:30:00 | QQQ | ETF | 114.05 | 114.1 | 114.03 | 114.06 | 39040.0 |
| 2015-10-30 09:00:00 | QQQ | ETF | 114.04 | 114.04 | 113.92 | 113.93 | 131342.0 |
| 2015-10-30 09:30:00 | QQQ | ETF | 113.89 | 114.08 | 113.81 | 113.95 | 2735086.0 |
| 2015-10-30 10:00:00 | QQQ | ETF | 113.95 | 114.0332 | 113.75 | 113.925 | 1728409.0 |
| 2015-10-30 10:30:00 | QQQ | ETF | 113.93 | 114.06 | 113.81 | 113.86 | 1075214.0 |
| 2015-10-30 11:00:00 | QQQ | ETF | 113.87 | 113.89 | 113.66 | 113.71 | 1199221.0 |
| 2015-10-30 11:30:00 | QQQ | ETF | 113.72 | 113.85 | 113.67 | 113.78 | 1118238.0 |
| 2015-10-30 12:00:00 | QQQ | ETF | 113.78 | 113.87 | 113.63 | 113.8 | 784533.0 |
| 2015-10-30 12:30:00 | QQQ | ETF | 113.81 | 114.06 | 113.7965 | 113.98 | 1154821.0 |
| 2015-10-30 13:00:00 | QQQ | ETF | 113.98 | 114.08 | 113.93 | 114.01 | 745345.0 |
> showing 50 of 12,555 rows — these rows as CSV