PREVIEW / etf_1hour / 2015-02-11
file: by_date/etf_1hour/2015/2015-02-11.parquet size: 236 KB rows: 7,499
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.64 | 206.52 | 206.52 | 4149.0 |
| 2015-02-11 06:00:00 | SPY | ETF | 206.55 | 206.59 | 206.29 | 206.47 | 69730.0 |
| 2015-02-11 07:00:00 | SPY | ETF | 206.46 | 206.56 | 206.34 | 206.37 | 78270.0 |
| 2015-02-11 08:00:00 | SPY | ETF | 206.4 | 206.61 | 206.28 | 206.39 | 396013.0 |
| 2015-02-11 09:00:00 | SPY | ETF | 206.4 | 206.91 | 206.39 | 206.9 | 7892366.0 |
| 2015-02-11 10:00:00 | SPY | ETF | 206.89 | 206.94 | 206.38 | 206.69 | 10371419.0 |
| 2015-02-11 11:00:00 | SPY | ETF | 206.68 | 207.04 | 206.63 | 206.805 | 9284215.0 |
| 2015-02-11 12:00:00 | SPY | ETF | 206.805 | 206.95 | 206.3 | 206.39 | 7321944.0 |
| 2015-02-11 13:00:00 | SPY | ETF | 206.39 | 206.66 | 205.83 | 206.47 | 13860804.0 |
| 2015-02-11 14:00:00 | SPY | ETF | 206.465 | 206.88 | 206.21 | 206.691 | 9430424.0 |
| 2015-02-11 15:00:00 | SPY | ETF | 206.7 | 207.45 | 206.6 | 206.94 | 18732434.0 |
| 2015-02-11 16:00:00 | SPY | ETF | 206.93 | 208.44 | 206.6886 | 207.92 | 11650971.0 |
| 2015-02-11 17:00:00 | SPY | ETF | 207.9 | 208.03 | 207.64 | 207.65 | 590660.0 |
| 2015-02-11 18:00:00 | SPY | ETF | 207.67 | 207.72 | 207.15 | 207.16 | 581018.0 |
| 2015-02-11 19:00:00 | SPY | ETF | 207.14 | 207.4 | 207.06 | 207.19 | 98917.0 |
| 2015-02-11 04:00:00 | QQQ | ETF | 104.35 | 104.35 | 104.3 | 104.31 | 1450.0 |
| 2015-02-11 05:00: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.25 | 104.3 | 14279.0 |
| 2015-02-11 07:00:00 | QQQ | ETF | 104.34 | 104.35 | 104.26 | 104.3 | 28862.0 |
| 2015-02-11 08:00:00 | QQQ | ETF | 104.28 | 104.43 | 104.25 | 104.37 | 72476.0 |
| 2015-02-11 09:00:00 | QQQ | ETF | 104.37 | 104.785 | 104.37 | 104.77 | 3368759.0 |
| 2015-02-11 10:00:00 | QQQ | ETF | 104.77 | 104.9 | 104.5831 | 104.83 | 3073999.0 |
| 2015-02-11 11:00:00 | QQQ | ETF | 104.82 | 104.95 | 104.7101 | 104.88 | 2466932.0 |
| 2015-02-11 12:00:00 | QQQ | ETF | 104.88 | 104.89 | 104.55 | 104.59 | 1695037.0 |
| 2015-02-11 13:00:00 | QQQ | ETF | 104.59 | 104.71 | 104.32 | 104.63 | 2426858.0 |
| 2015-02-11 14:00:00 | QQQ | ETF | 104.62 | 104.8499 | 104.56 | 104.7599 | 1804821.0 |
| 2015-02-11 15:00:00 | QQQ | ETF | 104.76 | 105.02 | 104.66 | 104.79 | 3953928.0 |
| 2015-02-11 16:00:00 | QQQ | ETF | 104.78 | 105.48 | 104.575 | 105.22 | 658241.0 |
| 2015-02-11 17:00:00 | QQQ | ETF | 105.24 | 105.31 | 105.18 | 105.18 | 28962.0 |
| 2015-02-11 18:00:00 | QQQ | ETF | 105.18 | 105.18 | 104.87 | 104.92 | 96741.0 |
| 2015-02-11 19:00:00 | QQQ | ETF | 104.92 | 105.04 | 104.88 | 104.93 | 57406.0 |
| 2015-02-11 07:00:00 | IWM | ETF | 119.23 | 119.42 | 119.1 | 119.1 | 2300.0 |
| 2015-02-11 08:00:00 | IWM | ETF | 119.16 | 119.31 | 119.06 | 119.26 | 49997.0 |
| 2015-02-11 09:00:00 | IWM | ETF | 119.25 | 119.61 | 119.07 | 119.47 | 2525199.0 |
| 2015-02-11 10:00:00 | IWM | ETF | 119.46 | 119.63 | 118.97 | 119.61 | 2844690.0 |
| 2015-02-11 11:00:00 | IWM | ETF | 119.61 | 119.82 | 119.47 | 119.605 | 2513178.0 |
| 2015-02-11 12:00:00 | IWM | ETF | 119.58 | 119.65 | 119.18 | 119.22 | 1305945.0 |
| 2015-02-11 13:00:00 | IWM | ETF | 119.23 | 119.3 | 118.62 | 119.23 | 2929688.0 |
| 2015-02-11 14:00:00 | IWM | ETF | 119.22 | 119.57 | 119.08 | 119.45 | 2210643.0 |
| 2015-02-11 15:00:00 | IWM | ETF | 119.46 | 119.79 | 119.3 | 119.46 | 4137297.0 |
| 2015-02-11 16:00:00 | IWM | ETF | 119.47 | 120.41 | 119.38 | 120.08 | 1732694.0 |
| 2015-02-11 17:00:00 | IWM | ETF | 120.06 | 120.16 | 120.0 | 120.03 | 157162.0 |
| 2015-02-11 18:00:00 | IWM | ETF | 119.85 | 119.85 | 119.45 | 119.5 | 46314.0 |
| 2015-02-11 19:00:00 | IWM | ETF | 119.59 | 119.69 | 119.55 | 119.56 | 3475.0 |
| 2015-02-11 07:00:00 | DIA | ETF | 178.05 | 178.15 | 178.03 | 178.06 | 500.0 |
| 2015-02-11 08:00:00 | DIA | ETF | 178.5435 | 178.5435 | 178.5435 | 178.5435 | 550000.0 |
| 2015-02-11 09:00:00 | DIA | ETF | 178.05 | 178.44 | 178.04 | 178.36 | 607383.0 |
| 2015-02-11 10:00:00 | DIA | ETF | 178.35 | 178.37 | 177.92 | 178.13 | 576526.0 |
| 2015-02-11 11:00:00 | DIA | ETF | 178.13 | 178.6 | 178.12 | 178.42 | 403320.0 |
> showing 50 of 7,499 rows — these rows as CSV