PREVIEW / etf_1hour / 2017-02-03
file: by_date/etf_1hour/2017/2017-02-03.parquet size: 278 KB rows: 8,930
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-03 04:00:00 | SPY | ETF | 227.87 | 227.95 | 227.86 | 227.95 | 4540.0 |
| 2017-02-03 05:00:00 | SPY | ETF | 227.97 | 227.97 | 227.84 | 227.84 | 1800.0 |
| 2017-02-03 06:00:00 | SPY | ETF | 227.84 | 228.13 | 227.84 | 228.02 | 27232.0 |
| 2017-02-03 07:00:00 | SPY | ETF | 228.01 | 228.1 | 227.96 | 228.01 | 92430.0 |
| 2017-02-03 08:00:00 | SPY | ETF | 228.05 | 228.75 | 227.95 | 228.68 | 2001510.0 |
| 2017-02-03 09:00:00 | SPY | ETF | 228.68 | 228.86 | 228.46 | 228.7 | 9359922.0 |
| 2017-02-03 10:00:00 | SPY | ETF | 228.7 | 229.4 | 228.67 | 229.25 | 13462951.0 |
| 2017-02-03 11:00:00 | SPY | ETF | 229.255 | 229.52 | 229.08 | 229.24 | 8599130.0 |
| 2017-02-03 12:00:00 | SPY | ETF | 229.235 | 229.42 | 229.23 | 229.356 | 5026736.0 |
| 2017-02-03 13:00:00 | SPY | ETF | 229.35 | 229.43 | 229.18 | 229.21 | 4150298.0 |
| 2017-02-03 14:00:00 | SPY | ETF | 229.21 | 229.44 | 229.2 | 229.36 | 4542314.0 |
| 2017-02-03 15:00:00 | SPY | ETF | 229.36 | 229.55 | 229.25 | 229.37 | 18926752.0 |
| 2017-02-03 16:00:00 | SPY | ETF | 229.36 | 229.4437 | 227.7907 | 229.33 | 12541704.0 |
| 2017-02-03 17:00:00 | SPY | ETF | 229.31 | 229.43 | 229.25 | 229.43 | 90842.0 |
| 2017-02-03 18:00:00 | SPY | ETF | 229.34 | 229.4 | 229.34 | 229.4 | 13002.0 |
| 2017-02-03 19:00:00 | SPY | ETF | 229.4 | 229.448 | 229.38 | 229.41 | 2061632.0 |
| 2017-02-03 05:00:00 | QQQ | ETF | 125.12 | 125.13 | 125.12 | 125.13 | 800.0 |
| 2017-02-03 06:00:00 | QQQ | ETF | 125.13 | 125.28 | 125.13 | 125.26 | 25246.0 |
| 2017-02-03 07:00:00 | QQQ | ETF | 125.21 | 125.21 | 125.14 | 125.17 | 4850.0 |
| 2017-02-03 08:00:00 | QQQ | ETF | 125.16 | 125.52 | 125.08 | 125.47 | 258354.0 |
| 2017-02-03 09:00:00 | QQQ | ETF | 125.46 | 125.65 | 125.37 | 125.53 | 2159635.0 |
| 2017-02-03 10:00:00 | QQQ | ETF | 125.52 | 125.81 | 125.44 | 125.59 | 2710882.0 |
| 2017-02-03 11:00:00 | QQQ | ETF | 125.59 | 125.73 | 125.33 | 125.4401 | 1736274.0 |
| 2017-02-03 12:00:00 | QQQ | ETF | 125.45 | 125.59 | 125.44 | 125.539 | 1138660.0 |
| 2017-02-03 13:00:00 | QQQ | ETF | 125.54 | 125.6 | 125.45 | 125.51 | 1079346.0 |
| 2017-02-03 14:00:00 | QQQ | ETF | 125.51 | 125.65 | 125.5 | 125.6158 | 993867.0 |
| 2017-02-03 15:00:00 | QQQ | ETF | 125.619 | 125.71 | 125.59 | 125.68 | 3935675.0 |
| 2017-02-03 16:00:00 | QQQ | ETF | 125.68 | 125.71 | 125.6 | 125.69 | 677674.0 |
| 2017-02-03 17:00:00 | QQQ | ETF | 125.63 | 125.69 | 125.63 | 125.69 | 4297.0 |
| 2017-02-03 18:00:00 | QQQ | ETF | 125.68 | 125.69 | 125.68 | 125.69 | 662.0 |
| 2017-02-03 19:00:00 | QQQ | ETF | 125.67 | 125.69 | 125.67 | 125.69 | 1100.0 |
| 2017-02-03 05:00:00 | IWM | ETF | 135.14 | 135.15 | 135.14 | 135.15 | 400.0 |
| 2017-02-03 06:00:00 | IWM | ETF | 135.14 | 135.27 | 135.14 | 135.27 | 1500.0 |
| 2017-02-03 07:00:00 | IWM | ETF | 135.15 | 135.21 | 135.05 | 135.21 | 20166.0 |
| 2017-02-03 08:00:00 | IWM | ETF | 135.2 | 135.8 | 135.15 | 135.78 | 209621.0 |
| 2017-02-03 09:00:00 | IWM | ETF | 135.78 | 136.12 | 135.51 | 135.71 | 4379996.0 |
| 2017-02-03 10:00:00 | IWM | ETF | 135.7 | 136.54 | 135.63 | 136.33 | 3825538.0 |
| 2017-02-03 11:00:00 | IWM | ETF | 136.35 | 136.72 | 136.2 | 136.51 | 2762898.0 |
| 2017-02-03 12:00:00 | IWM | ETF | 136.515 | 136.63 | 136.31 | 136.47 | 1463866.0 |
| 2017-02-03 13:00:00 | IWM | ETF | 136.47 | 136.6 | 136.295 | 136.33 | 1354497.0 |
| 2017-02-03 14:00:00 | IWM | ETF | 136.34 | 136.613 | 136.34 | 136.5301 | 1534716.0 |
| 2017-02-03 15:00:00 | IWM | ETF | 136.54 | 136.98 | 136.505 | 136.84 | 4876500.0 |
| 2017-02-03 16:00:00 | IWM | ETF | 136.87 | 137.01 | 136.81 | 136.98 | 1395455.0 |
| 2017-02-03 17:00:00 | IWM | ETF | 137.0 | 137.0 | 136.99 | 137.0 | 6200.0 |
| 2017-02-03 18:00:00 | IWM | ETF | 136.98 | 137.0 | 136.87 | 137.0 | 761.0 |
| 2017-02-03 19:00:00 | IWM | ETF | 136.96 | 137.05 | 136.96 | 137.05 | 3278.0 |
| 2017-02-03 04:00:00 | DIA | ETF | 198.76 | 198.76 | 198.76 | 198.76 | 100.0 |
| 2017-02-03 06:00:00 | DIA | ETF | 198.97 | 198.97 | 198.97 | 198.97 | 200.0 |
| 2017-02-03 07:00:00 | DIA | ETF | 199.08 | 199.19 | 199.08 | 199.18 | 3600.0 |
| 2017-02-03 08:00:00 | DIA | ETF | 199.14 | 199.65 | 199.14 | 199.54 | 24522.0 |
> showing 50 of 8,930 rows — these rows as CSV