PREVIEW / etf_30min / 2016-08-30
file: by_date/etf_30min/2016/2016-08-30.parquet size: 389 KB rows: 13,290
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-30 04:00:00 | SPY | ETF | 218.33 | 218.33 | 218.33 | 218.33 | 500.0 |
| 2016-08-30 04:30:00 | SPY | ETF | 218.33 | 218.48 | 218.32 | 218.45 | 4157.0 |
| 2016-08-30 05:00:00 | SPY | ETF | 218.38 | 218.38 | 218.34 | 218.34 | 1203.0 |
| 2016-08-30 05:30:00 | SPY | ETF | 218.35 | 218.35 | 218.26 | 218.26 | 20611.0 |
| 2016-08-30 06:00:00 | SPY | ETF | 218.26 | 218.26 | 218.13 | 218.21 | 15267.0 |
| 2016-08-30 06:30:00 | SPY | ETF | 218.18 | 218.35 | 218.12 | 218.35 | 39470.0 |
| 2016-08-30 07:00:00 | SPY | ETF | 218.33 | 218.35 | 218.3 | 218.31 | 11028.0 |
| 2016-08-30 07:30:00 | SPY | ETF | 218.29 | 218.34 | 218.27 | 218.3 | 17285.0 |
| 2016-08-30 08:00:00 | SPY | ETF | 218.28 | 218.39 | 218.28 | 218.31 | 105161.0 |
| 2016-08-30 08:30:00 | SPY | ETF | 218.3 | 218.34 | 218.22 | 218.25 | 126158.0 |
| 2016-08-30 09:00:00 | SPY | ETF | 218.3 | 218.35 | 218.25 | 218.25 | 389048.0 |
| 2016-08-30 09:30:00 | SPY | ETF | 218.26 | 218.59 | 218.19 | 218.32 | 5160350.0 |
| 2016-08-30 10:00:00 | SPY | ETF | 218.33 | 218.45 | 217.76 | 217.94 | 5890195.0 |
| 2016-08-30 10:30:00 | SPY | ETF | 217.94 | 217.98 | 217.61 | 217.82 | 6320774.0 |
| 2016-08-30 11:00:00 | SPY | ETF | 217.83 | 218.02 | 217.73 | 217.79 | 3420278.0 |
| 2016-08-30 11:30:00 | SPY | ETF | 217.79 | 217.97 | 217.7 | 217.92 | 2156711.0 |
| 2016-08-30 12:00:00 | SPY | ETF | 217.92 | 218.08 | 217.9 | 217.99 | 2062745.0 |
| 2016-08-30 12:30:00 | SPY | ETF | 217.98 | 218.1 | 217.85 | 217.8737 | 2795686.0 |
| 2016-08-30 13:00:00 | SPY | ETF | 217.87 | 217.96 | 217.8 | 217.86 | 1301061.0 |
| 2016-08-30 13:30:00 | SPY | ETF | 217.86 | 217.91 | 217.66 | 217.74 | 2422330.0 |
| 2016-08-30 14:00:00 | SPY | ETF | 217.74 | 217.74 | 217.35 | 217.5 | 4968153.0 |
| 2016-08-30 14:30:00 | SPY | ETF | 217.51 | 217.67 | 217.39 | 217.63 | 2789040.0 |
| 2016-08-30 15:00:00 | SPY | ETF | 217.635 | 217.8039 | 217.515 | 217.75 | 3560188.0 |
| 2016-08-30 15:30:00 | SPY | ETF | 217.75 | 217.98 | 217.65 | 217.97 | 8446106.0 |
| 2016-08-30 16:00:00 | SPY | ETF | 217.97 | 218.1 | 217.9 | 217.99 | 4311245.0 |
| 2016-08-30 16:30:00 | SPY | ETF | 218.0 | 218.07 | 218.0 | 218.02 | 401945.0 |
| 2016-08-30 17:00:00 | SPY | ETF | 218.0 | 218.04 | 217.99 | 218.0 | 109944.0 |
| 2016-08-30 17:30:00 | SPY | ETF | 218.02 | 218.04 | 218.0 | 218.04 | 15680.0 |
| 2016-08-30 18:00:00 | SPY | ETF | 218.05 | 218.05 | 217.97 | 217.97 | 497353.0 |
| 2016-08-30 18:30:00 | SPY | ETF | 217.97 | 217.99 | 217.97 | 217.99 | 2200.0 |
| 2016-08-30 19:00:00 | SPY | ETF | 217.99 | 217.99 | 217.9 | 217.9 | 4335.0 |
| 2016-08-30 19:30:00 | SPY | ETF | 217.94 | 218.0 | 217.89 | 217.91 | 14136.0 |
| 2016-08-30 04:30:00 | QQQ | ETF | 116.93 | 116.97 | 116.93 | 116.97 | 200.0 |
| 2016-08-30 05:30:00 | QQQ | ETF | 116.8 | 116.8 | 116.79 | 116.79 | 2483.0 |
| 2016-08-30 06:00:00 | QQQ | ETF | 116.69 | 116.69 | 116.67 | 116.67 | 4698.0 |
| 2016-08-30 06:30:00 | QQQ | ETF | 116.65 | 116.67 | 116.65 | 116.67 | 1100.0 |
| 2016-08-30 07:00:00 | QQQ | ETF | 116.73 | 116.76 | 116.73 | 116.76 | 13350.0 |
| 2016-08-30 07:30:00 | QQQ | ETF | 116.74 | 116.76 | 116.72 | 116.76 | 6500.0 |
| 2016-08-30 08:00:00 | QQQ | ETF | 116.74 | 116.81 | 116.74 | 116.76 | 14663.0 |
| 2016-08-30 08:30:00 | QQQ | ETF | 116.75 | 116.78 | 116.68 | 116.71 | 87906.0 |
| 2016-08-30 09:00:00 | QQQ | ETF | 116.73 | 116.78 | 116.72 | 116.73 | 69462.0 |
| 2016-08-30 09:30:00 | QQQ | ETF | 116.73 | 117.09 | 116.73 | 116.97 | 1898544.0 |
| 2016-08-30 10:00:00 | QQQ | ETF | 116.98 | 117.06 | 116.54 | 116.6692 | 1404356.0 |
| 2016-08-30 10:30:00 | QQQ | ETF | 116.66 | 116.68 | 116.32 | 116.49 | 1500111.0 |
| 2016-08-30 11:00:00 | QQQ | ETF | 116.48 | 116.66 | 116.44 | 116.47 | 1004534.0 |
| 2016-08-30 11:30:00 | QQQ | ETF | 116.4754 | 116.53 | 116.39 | 116.4601 | 659744.0 |
| 2016-08-30 12:00:00 | QQQ | ETF | 116.46 | 116.599 | 116.458 | 116.52 | 583224.0 |
| 2016-08-30 12:30:00 | QQQ | ETF | 116.52 | 116.62 | 116.49 | 116.49 | 341283.0 |
| 2016-08-30 13:00:00 | QQQ | ETF | 116.49 | 116.53 | 116.43 | 116.465 | 352893.0 |
| 2016-08-30 13:30:00 | QQQ | ETF | 116.47 | 116.5 | 116.33 | 116.4 | 388291.0 |
> showing 50 of 13,290 rows — these rows as CSV