PREVIEW / etf_30min / 2017-02-27
file: by_date/etf_30min/2017/2017-02-27.parquet size: 431 KB rows: 14,788
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-27 04:00:00 | SPY | ETF | 236.8 | 237.12 | 236.8 | 236.94 | 1515.0 |
| 2017-02-27 04:30:00 | SPY | ETF | 236.9 | 236.9 | 236.7 | 236.7 | 1946.0 |
| 2017-02-27 05:00:00 | SPY | ETF | 236.77 | 236.77 | 236.75 | 236.75 | 713.0 |
| 2017-02-27 05:30:00 | SPY | ETF | 236.75 | 236.75 | 236.65 | 236.65 | 9116.0 |
| 2017-02-27 06:00:00 | SPY | ETF | 236.7 | 236.74 | 236.7 | 236.71 | 6804.0 |
| 2017-02-27 06:30:00 | SPY | ETF | 236.68 | 236.8 | 236.62 | 236.8 | 6827.0 |
| 2017-02-27 07:00:00 | SPY | ETF | 236.74 | 236.76 | 236.66 | 236.72 | 37348.0 |
| 2017-02-27 07:30:00 | SPY | ETF | 236.7 | 236.73 | 236.57 | 236.64 | 123828.0 |
| 2017-02-27 08:00:00 | SPY | ETF | 236.61 | 236.77 | 236.44 | 236.51 | 265977.0 |
| 2017-02-27 08:30:00 | SPY | ETF | 236.55 | 236.7 | 236.52 | 236.63 | 165611.0 |
| 2017-02-27 09:00:00 | SPY | ETF | 236.63 | 236.8 | 236.62 | 236.62 | 371369.0 |
| 2017-02-27 09:30:00 | SPY | ETF | 236.64 | 236.85 | 236.35 | 236.849 | 5923761.0 |
| 2017-02-27 10:00:00 | SPY | ETF | 236.84 | 237.0 | 236.46 | 236.9608 | 4941591.0 |
| 2017-02-27 10:30:00 | SPY | ETF | 236.965 | 237.09 | 236.83 | 236.84 | 3810831.0 |
| 2017-02-27 11:00:00 | SPY | ETF | 236.84 | 237.03 | 236.75 | 236.86 | 3028479.0 |
| 2017-02-27 11:30:00 | SPY | ETF | 236.88 | 236.88 | 236.67 | 236.68 | 2450382.0 |
| 2017-02-27 12:00:00 | SPY | ETF | 236.68 | 236.88 | 236.62 | 236.86 | 3013480.0 |
| 2017-02-27 12:30:00 | SPY | ETF | 236.85 | 236.9 | 236.72 | 236.73 | 1356495.0 |
| 2017-02-27 13:00:00 | SPY | ETF | 236.735 | 237.005 | 236.73 | 236.96 | 3021018.0 |
| 2017-02-27 13:30:00 | SPY | ETF | 236.96 | 237.07 | 236.96 | 237.01 | 2283753.0 |
| 2017-02-27 14:00:00 | SPY | ETF | 237.02 | 237.17 | 236.93 | 237.08 | 2388348.0 |
| 2017-02-27 14:30:00 | SPY | ETF | 237.09 | 237.2 | 237.07 | 237.12 | 2193303.0 |
| 2017-02-27 15:00:00 | SPY | ETF | 237.12 | 237.29 | 237.12 | 237.26 | 3642133.0 |
| 2017-02-27 15:30:00 | SPY | ETF | 237.255 | 237.31 | 237.04 | 237.13 | 7939162.0 |
| 2017-02-27 16:00:00 | SPY | ETF | 237.13 | 237.135 | 237.0 | 237.1 | 6881677.0 |
| 2017-02-27 16:30:00 | SPY | ETF | 237.11 | 237.11 | 236.74 | 236.79 | 1069095.0 |
| 2017-02-27 17:00:00 | SPY | ETF | 236.79 | 236.85 | 236.78 | 236.85 | 27103.0 |
| 2017-02-27 17:30:00 | SPY | ETF | 236.84 | 236.87 | 236.75 | 236.81 | 86973.0 |
| 2017-02-27 18:00:00 | SPY | ETF | 236.82 | 236.9 | 236.81 | 236.84 | 14986.0 |
| 2017-02-27 18:30:00 | SPY | ETF | 236.83 | 236.86 | 236.81 | 236.82 | 4927.0 |
| 2017-02-27 19:00:00 | SPY | ETF | 236.82 | 236.88 | 236.79 | 236.88 | 5057.0 |
| 2017-02-27 19:30:00 | SPY | ETF | 236.91 | 236.93 | 236.86 | 236.87 | 20703.0 |
| 2017-02-27 04:00:00 | QQQ | ETF | 130.28 | 130.3 | 130.23 | 130.3 | 5547.0 |
| 2017-02-27 04:30:00 | QQQ | ETF | 130.25 | 130.25 | 130.19 | 130.19 | 615.0 |
| 2017-02-27 05:00:00 | QQQ | ETF | 130.14 | 130.14 | 130.14 | 130.14 | 100.0 |
| 2017-02-27 05:30:00 | QQQ | ETF | 130.14 | 130.14 | 130.08 | 130.1 | 1401.0 |
| 2017-02-27 06:00:00 | QQQ | ETF | 130.1 | 130.13 | 130.1 | 130.13 | 17000.0 |
| 2017-02-27 06:30:00 | QQQ | ETF | 130.2 | 130.21 | 130.2 | 130.2 | 10096.0 |
| 2017-02-27 07:00:00 | QQQ | ETF | 130.17 | 130.17 | 130.1 | 130.12 | 14097.0 |
| 2017-02-27 07:30:00 | QQQ | ETF | 130.11 | 130.13 | 130.04 | 130.06 | 31369.0 |
| 2017-02-27 08:00:00 | QQQ | ETF | 130.06 | 130.07 | 129.98 | 130.0 | 109327.0 |
| 2017-02-27 08:30:00 | QQQ | ETF | 129.99 | 130.06 | 129.98 | 129.99 | 72770.0 |
| 2017-02-27 09:00:00 | QQQ | ETF | 130.05 | 130.09 | 130.0 | 130.01 | 103179.0 |
| 2017-02-27 09:30:00 | QQQ | ETF | 130.02 | 130.11 | 129.8 | 130.11 | 1657804.0 |
| 2017-02-27 10:00:00 | QQQ | ETF | 130.101 | 130.14 | 129.88 | 130.095 | 759839.0 |
| 2017-02-27 10:30:00 | QQQ | ETF | 130.1 | 130.1757 | 130.05 | 130.09 | 1289458.0 |
| 2017-02-27 11:00:00 | QQQ | ETF | 130.09 | 130.26 | 130.09 | 130.18 | 736821.0 |
| 2017-02-27 11:30:00 | QQQ | ETF | 130.18 | 130.1946 | 130.09 | 130.1035 | 528314.0 |
| 2017-02-27 12:00:00 | QQQ | ETF | 130.1 | 130.18 | 130.07 | 130.1341 | 435764.0 |
| 2017-02-27 12:30:00 | QQQ | ETF | 130.14 | 130.18 | 130.07 | 130.08 | 503366.0 |
> showing 50 of 14,788 rows — these rows as CSV