PREVIEW / etf_30min / 2015-02-11
file: by_date/etf_30min/2015/2015-02-11.parquet size: 376 KB rows: 12,651
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-02-11 04:00:00 | SPY | ETF | 206.52 | 206.52 | 206.5 | 206.52 | 1110.0 |
| 2015-02-11 05:00:00 | SPY | ETF | 206.59 | 206.59 | 206.59 | 206.59 | 1300.0 |
| 2015-02-11 05:30:00 | SPY | ETF | 206.62 | 206.64 | 206.52 | 206.52 | 2849.0 |
| 2015-02-11 06:00:00 | SPY | ETF | 206.55 | 206.59 | 206.3 | 206.4 | 35490.0 |
| 2015-02-11 06:30:00 | SPY | ETF | 206.36 | 206.48 | 206.29 | 206.47 | 34240.0 |
| 2015-02-11 07:00:00 | SPY | ETF | 206.46 | 206.49 | 206.4 | 206.48 | 15324.0 |
| 2015-02-11 07:30:00 | SPY | ETF | 206.48 | 206.56 | 206.34 | 206.37 | 62946.0 |
| 2015-02-11 08:00:00 | SPY | ETF | 206.4 | 206.52 | 206.28 | 206.42 | 177815.0 |
| 2015-02-11 08:30:00 | SPY | ETF | 206.43 | 206.61 | 206.35 | 206.39 | 218198.0 |
| 2015-02-11 09:00:00 | SPY | ETF | 206.4 | 206.62 | 206.39 | 206.61 | 299975.0 |
| 2015-02-11 09:30:00 | SPY | ETF | 206.61 | 206.91 | 206.45 | 206.9 | 7592391.0 |
| 2015-02-11 10:00:00 | SPY | ETF | 206.89 | 206.94 | 206.473 | 206.58 | 5128114.0 |
| 2015-02-11 10:30:00 | SPY | ETF | 206.58 | 206.79 | 206.38 | 206.69 | 5243305.0 |
| 2015-02-11 11:00:00 | SPY | ETF | 206.68 | 207.04 | 206.66 | 206.84 | 5712304.0 |
| 2015-02-11 11:30:00 | SPY | ETF | 206.84 | 206.96 | 206.63 | 206.805 | 3571911.0 |
| 2015-02-11 12:00:00 | SPY | ETF | 206.805 | 206.9 | 206.64 | 206.83 | 2599578.0 |
| 2015-02-11 12:30:00 | SPY | ETF | 206.83 | 206.95 | 206.3 | 206.39 | 4722366.0 |
| 2015-02-11 13:00:00 | SPY | ETF | 206.39 | 206.48 | 205.83 | 206.13 | 7705211.0 |
| 2015-02-11 13:30:00 | SPY | ETF | 206.13 | 206.66 | 205.96 | 206.47 | 6155593.0 |
| 2015-02-11 14:00:00 | SPY | ETF | 206.465 | 206.68 | 206.21 | 206.35 | 5608109.0 |
| 2015-02-11 14:30:00 | SPY | ETF | 206.3501 | 206.88 | 206.34 | 206.691 | 3822315.0 |
| 2015-02-11 15:00:00 | SPY | ETF | 206.7 | 207.45 | 206.6 | 207.2181 | 6748822.0 |
| 2015-02-11 15:30:00 | SPY | ETF | 207.22 | 207.32 | 206.6 | 206.94 | 11983612.0 |
| 2015-02-11 16:00:00 | SPY | ETF | 206.93 | 207.11 | 206.6886 | 207.11 | 4399245.0 |
| 2015-02-11 16:30:00 | SPY | ETF | 207.1 | 208.44 | 207.1 | 207.92 | 7251726.0 |
| 2015-02-11 17:00:00 | SPY | ETF | 207.9 | 208.03 | 207.77 | 207.8 | 403508.0 |
| 2015-02-11 17:30:00 | SPY | ETF | 207.8 | 207.85 | 207.64 | 207.65 | 187152.0 |
| 2015-02-11 18:00:00 | SPY | ETF | 207.67 | 207.72 | 207.2 | 207.32 | 482868.0 |
| 2015-02-11 18:30:00 | SPY | ETF | 207.28 | 207.36 | 207.15 | 207.16 | 98150.0 |
| 2015-02-11 19:00:00 | SPY | ETF | 207.14 | 207.4 | 207.11 | 207.28 | 45545.0 |
| 2015-02-11 19:30:00 | SPY | ETF | 207.25 | 207.26 | 207.06 | 207.19 | 53372.0 |
| 2015-02-11 04:00:00 | QQQ | ETF | 104.35 | 104.35 | 104.31 | 104.31 | 1100.0 |
| 2015-02-11 04:30:00 | QQQ | ETF | 104.3 | 104.31 | 104.3 | 104.31 | 350.0 |
| 2015-02-11 05:30:00 | QQQ | ETF | 104.36 | 104.39 | 104.34 | 104.34 | 11800.0 |
| 2015-02-11 06:00:00 | QQQ | ETF | 104.32 | 104.36 | 104.27 | 104.27 | 8779.0 |
| 2015-02-11 06:30:00 | QQQ | ETF | 104.25 | 104.3 | 104.25 | 104.3 | 5500.0 |
| 2015-02-11 07:00:00 | QQQ | ETF | 104.34 | 104.35 | 104.28 | 104.33 | 20099.0 |
| 2015-02-11 07:30:00 | QQQ | ETF | 104.3 | 104.32 | 104.26 | 104.3 | 8763.0 |
| 2015-02-11 08:00:00 | QQQ | ETF | 104.28 | 104.36 | 104.25 | 104.34 | 29453.0 |
| 2015-02-11 08:30:00 | QQQ | ETF | 104.34 | 104.43 | 104.34 | 104.37 | 43023.0 |
| 2015-02-11 09:00:00 | QQQ | ETF | 104.37 | 104.51 | 104.37 | 104.51 | 115320.0 |
| 2015-02-11 09:30:00 | QQQ | ETF | 104.51 | 104.785 | 104.41 | 104.77 | 3253439.0 |
| 2015-02-11 10:00:00 | QQQ | ETF | 104.77 | 104.8 | 104.5831 | 104.68 | 1399589.0 |
| 2015-02-11 10:30:00 | QQQ | ETF | 104.68 | 104.9 | 104.6 | 104.83 | 1674410.0 |
| 2015-02-11 11:00:00 | QQQ | ETF | 104.82 | 104.95 | 104.77 | 104.81 | 1678867.0 |
| 2015-02-11 11:30:00 | QQQ | ETF | 104.81 | 104.93 | 104.7101 | 104.88 | 788065.0 |
| 2015-02-11 12:00:00 | QQQ | ETF | 104.88 | 104.89 | 104.79 | 104.81 | 815523.0 |
| 2015-02-11 12:30:00 | QQQ | ETF | 104.815 | 104.86 | 104.55 | 104.59 | 879514.0 |
| 2015-02-11 13:00:00 | QQQ | ETF | 104.59 | 104.64 | 104.32 | 104.51 | 1435849.0 |
| 2015-02-11 13:30:00 | QQQ | ETF | 104.53 | 104.71 | 104.389 | 104.63 | 991009.0 |
> showing 50 of 12,651 rows — these rows as CSV