PREVIEW / etf_1hour / 2017-05-10
file: by_date/etf_1hour/2017/2017-05-10.parquet size: 275 KB rows: 8,908
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-05-10 04:00:00 | SPY | ETF | 239.02 | 239.08 | 239.0 | 239.08 | 4321.0 |
| 2017-05-10 05:00:00 | SPY | ETF | 239.08 | 239.14 | 239.03 | 239.11 | 4416.0 |
| 2017-05-10 06:00:00 | SPY | ETF | 239.13 | 239.17 | 239.05 | 239.05 | 13885.0 |
| 2017-05-10 07:00:00 | SPY | ETF | 239.12 | 239.31 | 239.05 | 239.28 | 205466.0 |
| 2017-05-10 08:00:00 | SPY | ETF | 239.26 | 239.43 | 239.08 | 239.33 | 264496.0 |
| 2017-05-10 09:00:00 | SPY | ETF | 239.33 | 239.48 | 239.2 | 239.41 | 7177636.0 |
| 2017-05-10 10:00:00 | SPY | ETF | 239.41 | 239.53 | 239.15 | 239.3999 | 7556520.0 |
| 2017-05-10 11:00:00 | SPY | ETF | 239.41 | 239.7771 | 239.37 | 239.65 | 6940648.0 |
| 2017-05-10 12:00:00 | SPY | ETF | 239.659 | 239.76 | 239.62 | 239.76 | 5988293.0 |
| 2017-05-10 13:00:00 | SPY | ETF | 239.76 | 239.85 | 239.66 | 239.72 | 4230862.0 |
| 2017-05-10 14:00:00 | SPY | ETF | 239.72 | 239.8 | 239.57 | 239.75 | 3232358.0 |
| 2017-05-10 15:00:00 | SPY | ETF | 239.75 | 239.87 | 239.581 | 239.85 | 12606076.0 |
| 2017-05-10 16:00:00 | SPY | ETF | 239.85 | 239.89 | 239.5963 | 239.7 | 4076209.0 |
| 2017-05-10 17:00:00 | SPY | ETF | 239.7 | 239.87 | 239.62 | 239.7 | 584336.0 |
| 2017-05-10 18:00:00 | SPY | ETF | 239.69 | 239.867 | 239.67 | 239.71 | 42421.0 |
| 2017-05-10 19:00:00 | SPY | ETF | 239.7 | 239.75 | 239.65 | 239.75 | 22900.0 |
| 2017-05-10 04:00:00 | QQQ | ETF | 138.17 | 138.21 | 138.15 | 138.15 | 4243.0 |
| 2017-05-10 07:00:00 | QQQ | ETF | 138.27 | 138.37 | 138.27 | 138.36 | 22668.0 |
| 2017-05-10 08:00:00 | QQQ | ETF | 138.34 | 138.39 | 138.34 | 138.34 | 30974.0 |
| 2017-05-10 09:00:00 | QQQ | ETF | 138.33 | 138.42 | 138.02 | 138.11 | 1853326.0 |
| 2017-05-10 10:00:00 | QQQ | ETF | 138.11 | 138.16 | 137.91 | 137.955 | 2741500.0 |
| 2017-05-10 11:00:00 | QQQ | ETF | 137.96 | 138.3 | 137.94 | 138.195 | 1334085.0 |
| 2017-05-10 12:00:00 | QQQ | ETF | 138.195 | 138.36 | 138.155 | 138.3407 | 801817.0 |
| 2017-05-10 13:00:00 | QQQ | ETF | 138.3462 | 138.41 | 138.25 | 138.38 | 1073954.0 |
| 2017-05-10 14:00:00 | QQQ | ETF | 138.37 | 138.41 | 138.2884 | 138.37 | 1156370.0 |
| 2017-05-10 15:00:00 | QQQ | ETF | 138.37 | 138.45 | 138.12 | 138.38 | 7178386.0 |
| 2017-05-10 16:00:00 | QQQ | ETF | 138.39 | 138.42 | 138.2359 | 138.35 | 757955.0 |
| 2017-05-10 17:00:00 | QQQ | ETF | 138.38 | 138.38 | 138.35 | 138.35 | 292900.0 |
| 2017-05-10 18:00:00 | QQQ | ETF | 138.27 | 138.32 | 138.27 | 138.32 | 6900.0 |
| 2017-05-10 19:00:00 | QQQ | ETF | 138.3 | 138.32 | 138.25 | 138.32 | 2800.0 |
| 2017-05-10 04:00:00 | IWM | ETF | 137.66 | 137.67 | 137.66 | 137.67 | 3500.0 |
| 2017-05-10 05:00:00 | IWM | ETF | 137.8 | 137.8 | 137.71 | 137.72 | 3900.0 |
| 2017-05-10 06:00:00 | IWM | ETF | 137.8 | 137.8 | 137.8 | 137.8 | 300.0 |
| 2017-05-10 07:00:00 | IWM | ETF | 137.8 | 137.98 | 137.75 | 137.98 | 14003.0 |
| 2017-05-10 08:00:00 | IWM | ETF | 137.93 | 138.12 | 137.93 | 138.03 | 44250.0 |
| 2017-05-10 09:00:00 | IWM | ETF | 137.96 | 138.79 | 137.86 | 138.71 | 2624526.0 |
| 2017-05-10 10:00:00 | IWM | ETF | 138.71 | 139.15 | 138.1 | 138.46 | 3662225.0 |
| 2017-05-10 11:00:00 | IWM | ETF | 138.465 | 138.75 | 138.29 | 138.52 | 1580055.0 |
| 2017-05-10 12:00:00 | IWM | ETF | 138.52 | 139.01 | 138.51 | 139.005 | 1049211.0 |
| 2017-05-10 13:00:00 | IWM | ETF | 139.0017 | 139.48 | 139.0017 | 139.09 | 1629496.0 |
| 2017-05-10 14:00:00 | IWM | ETF | 139.09 | 139.26 | 138.98 | 139.16 | 1699680.0 |
| 2017-05-10 15:00:00 | IWM | ETF | 139.17 | 139.325 | 138.975 | 139.19 | 3351551.0 |
| 2017-05-10 16:00:00 | IWM | ETF | 139.21 | 139.21 | 138.517 | 139.1 | 1920276.0 |
| 2017-05-10 17:00:00 | IWM | ETF | 139.21 | 139.21 | 139.06 | 139.07 | 440840.0 |
| 2017-05-10 18:00:00 | IWM | ETF | 139.19 | 139.19 | 139.15 | 139.15 | 12557.0 |
| 2017-05-10 19:00:00 | IWM | ETF | 139.08 | 139.1886 | 139.08 | 139.14 | 600597.0 |
| 2017-05-10 04:00:00 | DIA | ETF | 209.05 | 209.05 | 209.02 | 209.02 | 300.0 |
| 2017-05-10 06:00:00 | DIA | ETF | 209.03 | 209.03 | 209.03 | 209.03 | 100.0 |
| 2017-05-10 07:00:00 | DIA | ETF | 209.04 | 209.12 | 209.04 | 209.12 | 500.0 |
| 2017-05-10 08:00:00 | DIA | ETF | 209.13 | 209.27 | 209.13 | 209.27 | 940.0 |
> showing 50 of 8,908 rows — these rows as CSV