PREVIEW / etf_1hour / 2015-05-07
file: by_date/etf_1hour/2015/2015-05-07.parquet size: 241 KB rows: 7,681
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-05-07 04:00:00 | SPY | ETF | 207.6 | 207.86 | 206.96 | 207.25 | 45674.0 |
| 2015-05-07 05:00:00 | SPY | ETF | 207.21 | 207.21 | 206.31 | 206.84 | 243423.0 |
| 2015-05-07 06:00:00 | SPY | ETF | 206.94 | 207.05 | 206.48 | 206.89 | 309281.0 |
| 2015-05-07 07:00:00 | SPY | ETF | 206.91 | 207.72 | 206.91 | 207.72 | 1079381.0 |
| 2015-05-07 08:00:00 | SPY | ETF | 207.7 | 208.21 | 206.95 | 207.56 | 2133851.0 |
| 2015-05-07 09:00:00 | SPY | ETF | 207.55 | 208.39 | 207.54 | 207.66 | 14038117.0 |
| 2015-05-07 10:00:00 | SPY | ETF | 207.65 | 208.6499 | 207.52 | 208.45 | 16949085.0 |
| 2015-05-07 11:00:00 | SPY | ETF | 208.46 | 209.02 | 208.3101 | 208.71 | 8830572.0 |
| 2015-05-07 12:00:00 | SPY | ETF | 208.71 | 209.38 | 208.6805 | 209.21 | 7166829.0 |
| 2015-05-07 13:00:00 | SPY | ETF | 209.21 | 209.36 | 208.84 | 208.95 | 6318177.0 |
| 2015-05-07 14:00:00 | SPY | ETF | 208.95 | 209.25 | 208.95 | 209.099 | 6092065.0 |
| 2015-05-07 15:00:00 | SPY | ETF | 209.09 | 209.21 | 208.62 | 208.87 | 16697346.0 |
| 2015-05-07 16:00:00 | SPY | ETF | 208.88 | 209.02 | 208.81 | 208.93 | 7524753.0 |
| 2015-05-07 17:00:00 | SPY | ETF | 208.91 | 209.08 | 208.0407 | 209.08 | 92098.0 |
| 2015-05-07 18:00:00 | SPY | ETF | 209.07 | 209.09 | 208.95 | 208.99 | 184454.0 |
| 2015-05-07 19:00:00 | SPY | ETF | 209.0 | 209.05 | 208.95 | 209.05 | 29880.0 |
| 2015-05-07 04:00:00 | QQQ | ETF | 106.6 | 106.6 | 106.23 | 106.23 | 900.0 |
| 2015-05-07 05:00:00 | QQQ | ETF | 105.9 | 106.11 | 105.8 | 105.93 | 16675.0 |
| 2015-05-07 06:00:00 | QQQ | ETF | 106.13 | 106.14 | 105.9 | 106.14 | 37200.0 |
| 2015-05-07 07:00:00 | QQQ | ETF | 106.14 | 106.62 | 106.14 | 106.62 | 117085.0 |
| 2015-05-07 08:00:00 | QQQ | ETF | 106.62 | 106.86 | 105.93 | 106.48 | 368928.0 |
| 2015-05-07 09:00:00 | QQQ | ETF | 106.54 | 107.36 | 106.49 | 106.86 | 6132930.0 |
| 2015-05-07 10:00:00 | QQQ | ETF | 106.85 | 107.35 | 106.71 | 107.17 | 5148955.0 |
| 2015-05-07 11:00:00 | QQQ | ETF | 107.18 | 107.42 | 107.0605 | 107.25 | 3211487.0 |
| 2015-05-07 12:00:00 | QQQ | ETF | 107.24 | 107.63 | 107.21 | 107.55 | 2095357.0 |
| 2015-05-07 13:00:00 | QQQ | ETF | 107.56 | 107.65 | 107.3 | 107.345 | 1686495.0 |
| 2015-05-07 14:00:00 | QQQ | ETF | 107.35 | 107.6 | 107.35 | 107.51 | 1432331.0 |
| 2015-05-07 15:00:00 | QQQ | ETF | 107.5 | 107.57 | 107.18 | 107.34 | 3411256.0 |
| 2015-05-07 16:00:00 | QQQ | ETF | 107.35 | 107.48 | 107.32 | 107.42 | 352656.0 |
| 2015-05-07 17:00:00 | QQQ | ETF | 107.42 | 107.46 | 107.42 | 107.46 | 8147.0 |
| 2015-05-07 18:00:00 | QQQ | ETF | 107.46 | 107.5 | 107.44 | 107.44 | 8370.0 |
| 2015-05-07 19:00:00 | QQQ | ETF | 107.45 | 107.5 | 107.42 | 107.5 | 4325.0 |
| 2015-05-07 04:00:00 | IWM | ETF | 121.15 | 121.15 | 120.9 | 120.9 | 300.0 |
| 2015-05-07 05:00:00 | IWM | ETF | 120.31 | 120.31 | 120.31 | 120.31 | 100.0 |
| 2015-05-07 06:00:00 | IWM | ETF | 120.6 | 120.6 | 120.45 | 120.45 | 600.0 |
| 2015-05-07 07:00:00 | IWM | ETF | 120.8 | 121.25 | 120.72 | 121.25 | 101868.0 |
| 2015-05-07 08:00:00 | IWM | ETF | 121.2 | 121.46 | 120.92 | 121.06 | 181864.0 |
| 2015-05-07 09:00:00 | IWM | ETF | 121.05 | 121.5 | 120.69 | 120.74 | 6217611.0 |
| 2015-05-07 10:00:00 | IWM | ETF | 120.72 | 121.43 | 120.57 | 121.385 | 3643123.0 |
| 2015-05-07 11:00:00 | IWM | ETF | 121.385 | 121.64 | 121.27 | 121.36 | 2236508.0 |
| 2015-05-07 12:00:00 | IWM | ETF | 121.36 | 122.23 | 121.34 | 122.01 | 2405815.0 |
| 2015-05-07 13:00:00 | IWM | ETF | 122.01 | 122.1 | 121.74 | 121.74 | 1464152.0 |
| 2015-05-07 14:00:00 | IWM | ETF | 121.74 | 121.99 | 121.74 | 121.87 | 1575052.0 |
| 2015-05-07 15:00:00 | IWM | ETF | 121.87 | 122.0 | 121.5 | 121.74 | 3914549.0 |
| 2015-05-07 16:00:00 | IWM | ETF | 121.73 | 121.96 | 121.71 | 121.94 | 848728.0 |
| 2015-05-07 17:00:00 | IWM | ETF | 121.96 | 121.99 | 121.96 | 121.97 | 1155.0 |
| 2015-05-07 19:00:00 | IWM | ETF | 121.95 | 121.95 | 121.95 | 121.95 | 200.0 |
| 2015-05-07 08:00:00 | DIA | ETF | 177.94 | 177.94 | 177.71 | 177.72 | 3968.0 |
| 2015-05-07 09:00:00 | DIA | ETF | 178.12 | 178.71 | 177.89 | 178.14 | 727044.0 |
| 2015-05-07 10:00:00 | DIA | ETF | 178.13 | 179.0 | 178.0 | 178.805 | 1032704.0 |
> showing 50 of 7,681 rows — these rows as CSV