PREVIEW / etf_30min / 2015-10-19
file: by_date/etf_30min/2015/2015-10-19.parquet size: 371 KB rows: 12,571
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-19 04:00:00 | SPY | ETF | 203.4 | 203.4 | 203.05 | 203.05 | 10517.0 |
| 2015-10-19 04:30:00 | SPY | ETF | 203.2 | 203.3 | 203.16 | 203.16 | 3321.0 |
| 2015-10-19 05:00:00 | SPY | ETF | 203.16 | 203.16 | 202.95 | 203.04 | 17535.0 |
| 2015-10-19 05:30:00 | SPY | ETF | 203.04 | 203.06 | 202.98 | 203.03 | 4733.0 |
| 2015-10-19 06:00:00 | SPY | ETF | 203.03 | 203.1 | 202.95 | 203.02 | 102358.0 |
| 2015-10-19 06:30:00 | SPY | ETF | 203.03 | 203.03 | 202.9 | 202.9 | 1308.0 |
| 2015-10-19 07:00:00 | SPY | ETF | 202.96 | 202.98 | 202.76 | 202.88 | 47080.0 |
| 2015-10-19 07:30:00 | SPY | ETF | 202.93 | 202.97 | 202.59 | 202.66 | 187081.0 |
| 2015-10-19 08:00:00 | SPY | ETF | 202.68 | 202.86 | 202.46 | 202.61 | 411321.0 |
| 2015-10-19 08:30:00 | SPY | ETF | 202.58 | 203.27 | 202.32 | 202.34 | 703950.0 |
| 2015-10-19 09:00:00 | SPY | ETF | 202.34 | 202.52 | 202.27 | 202.52 | 486665.0 |
| 2015-10-19 09:30:00 | SPY | ETF | 202.5 | 202.9 | 202.13 | 202.87 | 9063677.0 |
| 2015-10-19 10:00:00 | SPY | ETF | 202.875 | 203.075 | 202.63 | 202.78 | 6226749.0 |
| 2015-10-19 10:30:00 | SPY | ETF | 202.78 | 202.93 | 202.49 | 202.91 | 4466541.0 |
| 2015-10-19 11:00:00 | SPY | ETF | 202.91 | 203.05 | 202.67 | 202.95 | 3774758.0 |
| 2015-10-19 11:30:00 | SPY | ETF | 202.95 | 203.37 | 202.94 | 203.21 | 4207865.0 |
| 2015-10-19 12:00:00 | SPY | ETF | 203.21 | 203.34 | 202.85 | 202.99 | 3180033.0 |
| 2015-10-19 12:30:00 | SPY | ETF | 202.98 | 203.16 | 202.87 | 203.0134 | 2455344.0 |
| 2015-10-19 13:00:00 | SPY | ETF | 203.015 | 203.1 | 202.57 | 202.5801 | 3045945.0 |
| 2015-10-19 13:30:00 | SPY | ETF | 202.58 | 202.74 | 202.35 | 202.7 | 4514436.0 |
| 2015-10-19 14:00:00 | SPY | ETF | 202.705 | 202.795 | 202.51 | 202.555 | 2632028.0 |
| 2015-10-19 14:30:00 | SPY | ETF | 202.55 | 202.9 | 202.54 | 202.86 | 4441051.0 |
| 2015-10-19 15:00:00 | SPY | ETF | 202.86 | 203.26 | 202.81 | 203.085 | 6958898.0 |
| 2015-10-19 15:30:00 | SPY | ETF | 203.085 | 203.37 | 202.92 | 203.33 | 12066117.0 |
| 2015-10-19 16:00:00 | SPY | ETF | 203.32 | 203.44 | 202.9643 | 203.37 | 4575126.0 |
| 2015-10-19 16:30:00 | SPY | ETF | 203.37 | 203.42 | 203.3 | 203.38 | 184050.0 |
| 2015-10-19 17:00:00 | SPY | ETF | 203.35 | 203.39 | 203.34 | 203.39 | 1503917.0 |
| 2015-10-19 17:30:00 | SPY | ETF | 203.38 | 203.39 | 203.3 | 203.31 | 17967.0 |
| 2015-10-19 18:00:00 | SPY | ETF | 203.31 | 203.35 | 203.22 | 203.28 | 66528.0 |
| 2015-10-19 18:30:00 | SPY | ETF | 203.28 | 203.28 | 203.2 | 203.25 | 28989.0 |
| 2015-10-19 19:00:00 | SPY | ETF | 203.23 | 203.24 | 203.16 | 203.23 | 15636.0 |
| 2015-10-19 19:30:00 | SPY | ETF | 203.24 | 203.28 | 203.19 | 203.24 | 30228.0 |
| 2015-10-19 04:00:00 | QQQ | ETF | 108.3 | 108.32 | 108.3 | 108.32 | 8450.0 |
| 2015-10-19 04:30:00 | QQQ | ETF | 108.3 | 108.39 | 108.28 | 108.39 | 12750.0 |
| 2015-10-19 05:00:00 | QQQ | ETF | 108.29 | 108.29 | 108.24 | 108.24 | 2700.0 |
| 2015-10-19 05:30:00 | QQQ | ETF | 108.23 | 108.28 | 108.23 | 108.26 | 5500.0 |
| 2015-10-19 06:00:00 | QQQ | ETF | 108.24 | 108.28 | 108.23 | 108.28 | 4300.0 |
| 2015-10-19 06:30:00 | QQQ | ETF | 108.27 | 108.27 | 108.23 | 108.23 | 3500.0 |
| 2015-10-19 07:00:00 | QQQ | ETF | 108.22 | 108.23 | 108.11 | 108.16 | 4350.0 |
| 2015-10-19 07:30:00 | QQQ | ETF | 108.16 | 108.16 | 108.05 | 108.05 | 13582.0 |
| 2015-10-19 08:00:00 | QQQ | ETF | 108.07 | 108.07 | 107.96 | 107.96 | 36615.0 |
| 2015-10-19 08:30:00 | QQQ | ETF | 107.97 | 107.97 | 107.77 | 107.79 | 67845.0 |
| 2015-10-19 09:00:00 | QQQ | ETF | 107.8 | 107.96 | 107.77 | 107.96 | 66806.0 |
| 2015-10-19 09:30:00 | QQQ | ETF | 107.98 | 108.29 | 107.74 | 108.2799 | 2556672.0 |
| 2015-10-19 10:00:00 | QQQ | ETF | 108.28 | 108.47 | 108.11 | 108.3 | 3123586.0 |
| 2015-10-19 10:30:00 | QQQ | ETF | 108.3072 | 108.47 | 108.06 | 108.46 | 1423097.0 |
| 2015-10-19 11:00:00 | QQQ | ETF | 108.46 | 108.61 | 108.33 | 108.53 | 1445824.0 |
| 2015-10-19 11:30:00 | QQQ | ETF | 108.5306 | 108.81 | 108.5306 | 108.76 | 1343375.0 |
| 2015-10-19 12:00:00 | QQQ | ETF | 108.75 | 108.81 | 108.45 | 108.54 | 936844.0 |
| 2015-10-19 12:30:00 | QQQ | ETF | 108.53 | 108.701 | 108.46 | 108.5786 | 887905.0 |
> showing 50 of 12,571 rows — these rows as CSV