PREVIEW / etf_1hour / 2017-02-17
file: by_date/etf_1hour/2017/2017-02-17.parquet size: 273 KB rows: 8,852
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-17 04:00:00 | SPY | ETF | 234.5 | 234.5 | 234.08 | 234.21 | 39735.0 |
| 2017-02-17 05:00:00 | SPY | ETF | 234.03 | 234.16 | 234.0 | 234.06 | 70301.0 |
| 2017-02-17 06:00:00 | SPY | ETF | 234.01 | 234.23 | 233.86 | 234.23 | 50285.0 |
| 2017-02-17 07:00:00 | SPY | ETF | 234.23 | 234.29 | 234.15 | 234.2 | 119851.0 |
| 2017-02-17 08:00:00 | SPY | ETF | 234.25 | 234.25 | 233.85 | 234.1 | 1355419.0 |
| 2017-02-17 09:00:00 | SPY | ETF | 234.11 | 234.45 | 233.87 | 234.3173 | 11240012.0 |
| 2017-02-17 10:00:00 | SPY | ETF | 234.31 | 234.49 | 234.17 | 234.21 | 8465374.0 |
| 2017-02-17 11:00:00 | SPY | ETF | 234.21 | 234.35 | 233.98 | 234.25 | 7838115.0 |
| 2017-02-17 12:00:00 | SPY | ETF | 234.26 | 234.44 | 234.2 | 234.395 | 3936937.0 |
| 2017-02-17 13:00:00 | SPY | ETF | 234.39 | 234.45 | 234.24 | 234.38 | 5122616.0 |
| 2017-02-17 14:00:00 | SPY | ETF | 234.38 | 234.71 | 234.36 | 234.575 | 4786117.0 |
| 2017-02-17 15:00:00 | SPY | ETF | 234.58 | 235.07 | 234.57 | 235.06 | 18680839.0 |
| 2017-02-17 16:00:00 | SPY | ETF | 235.06 | 235.1299 | 234.95 | 235.04 | 10475371.0 |
| 2017-02-17 17:00:00 | SPY | ETF | 235.03 | 235.1 | 235.0 | 235.06 | 3169196.0 |
| 2017-02-17 18:00:00 | SPY | ETF | 235.05 | 235.15 | 235.01 | 235.11 | 250122.0 |
| 2017-02-17 19:00:00 | SPY | ETF | 235.13 | 235.13 | 235.07 | 235.1 | 42669.0 |
| 2017-02-17 04:00:00 | QQQ | ETF | 129.0 | 129.01 | 128.94 | 129.01 | 1100.0 |
| 2017-02-17 05:00:00 | QQQ | ETF | 128.99 | 128.99 | 128.95 | 128.97 | 1350.0 |
| 2017-02-17 06:00:00 | QQQ | ETF | 128.95 | 129.08 | 128.91 | 129.05 | 24286.0 |
| 2017-02-17 07:00:00 | QQQ | ETF | 129.04 | 129.11 | 129.0 | 129.06 | 30045.0 |
| 2017-02-17 08:00:00 | QQQ | ETF | 129.04 | 129.1 | 128.92 | 129.08 | 229806.0 |
| 2017-02-17 09:00:00 | QQQ | ETF | 129.07 | 129.35 | 128.99 | 129.31 | 2488999.0 |
| 2017-02-17 10:00:00 | QQQ | ETF | 129.32 | 129.47 | 129.24 | 129.31 | 1840780.0 |
| 2017-02-17 11:00:00 | QQQ | ETF | 129.31 | 129.38 | 129.19 | 129.34 | 1142517.0 |
| 2017-02-17 12:00:00 | QQQ | ETF | 129.34 | 129.49 | 129.3 | 129.4857 | 740577.0 |
| 2017-02-17 13:00:00 | QQQ | ETF | 129.49 | 129.51 | 129.4 | 129.4469 | 737983.0 |
| 2017-02-17 14:00:00 | QQQ | ETF | 129.445 | 129.62 | 129.4344 | 129.551 | 1169935.0 |
| 2017-02-17 15:00:00 | QQQ | ETF | 129.56 | 129.82 | 129.555 | 129.82 | 3067635.0 |
| 2017-02-17 16:00:00 | QQQ | ETF | 129.81 | 129.89 | 129.4487 | 129.89 | 878886.0 |
| 2017-02-17 17:00:00 | QQQ | ETF | 129.84 | 129.87 | 129.82 | 129.84 | 572704.0 |
| 2017-02-17 18:00:00 | QQQ | ETF | 129.86 | 129.86 | 129.84 | 129.85 | 2311.0 |
| 2017-02-17 19:00:00 | QQQ | ETF | 129.85 | 129.88 | 129.81 | 129.81 | 16361.0 |
| 2017-02-17 04:00:00 | IWM | ETF | 138.9 | 138.9 | 138.23 | 138.23 | 6962.0 |
| 2017-02-17 05:00:00 | IWM | ETF | 138.23 | 138.27 | 138.22 | 138.27 | 3717.0 |
| 2017-02-17 06:00:00 | IWM | ETF | 138.21 | 138.43 | 138.2 | 138.37 | 9111.0 |
| 2017-02-17 07:00:00 | IWM | ETF | 138.42 | 138.47 | 138.24 | 138.31 | 58843.0 |
| 2017-02-17 08:00:00 | IWM | ETF | 138.29 | 138.6841 | 137.84 | 138.18 | 266450.0 |
| 2017-02-17 09:00:00 | IWM | ETF | 138.15 | 138.87 | 138.1 | 138.79 | 2847226.0 |
| 2017-02-17 10:00:00 | IWM | ETF | 138.79 | 139.03 | 138.44 | 138.4583 | 3765792.0 |
| 2017-02-17 11:00:00 | IWM | ETF | 138.45 | 138.71 | 138.3 | 138.62 | 3029799.0 |
| 2017-02-17 12:00:00 | IWM | ETF | 138.62 | 138.83 | 138.49 | 138.64 | 1975812.0 |
| 2017-02-17 13:00:00 | IWM | ETF | 138.65 | 138.8 | 138.54 | 138.75 | 1075487.0 |
| 2017-02-17 14:00:00 | IWM | ETF | 138.7599 | 139.01 | 138.7401 | 138.85 | 1176068.0 |
| 2017-02-17 15:00:00 | IWM | ETF | 138.85 | 139.16 | 138.84 | 139.12 | 3637130.0 |
| 2017-02-17 16:00:00 | IWM | ETF | 139.13 | 139.23 | 138.9 | 139.11 | 4273925.0 |
| 2017-02-17 17:00:00 | IWM | ETF | 139.11 | 139.12 | 139.04 | 139.11 | 1389036.0 |
| 2017-02-17 18:00:00 | IWM | ETF | 139.11 | 139.11 | 139.04 | 139.04 | 210.0 |
| 2017-02-17 19:00:00 | IWM | ETF | 139.17 | 139.19 | 139.13 | 139.19 | 3067.0 |
| 2017-02-17 04:00:00 | DIA | ETF | 205.85 | 205.86 | 205.39 | 205.39 | 2465.0 |
| 2017-02-17 06:00:00 | DIA | ETF | 205.46 | 205.46 | 205.46 | 205.46 | 2000.0 |
> showing 50 of 8,852 rows — these rows as CSV