PREVIEW / etf_1hour / 2015-02-19
file: by_date/etf_1hour/2015/2015-02-19.parquet size: 235 KB rows: 7,455
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-19 04:00:00 | SPY | ETF | 209.64 | 209.75 | 209.62 | 209.62 | 26741.0 |
| 2015-02-19 05:00:00 | SPY | ETF | 209.74 | 209.8 | 209.59 | 209.8 | 47622.0 |
| 2015-02-19 06:00:00 | SPY | ETF | 209.77 | 210.05 | 209.7 | 210.02 | 107028.0 |
| 2015-02-19 07:00:00 | SPY | ETF | 210.02 | 210.41 | 209.5 | 209.66 | 747345.0 |
| 2015-02-19 08:00:00 | SPY | ETF | 209.65 | 210.12 | 209.53 | 209.58 | 1278486.0 |
| 2015-02-19 09:00:00 | SPY | ETF | 209.56 | 209.7245 | 209.24 | 209.61 | 9871325.0 |
| 2015-02-19 10:00:00 | SPY | ETF | 209.61 | 210.115 | 209.4 | 209.9897 | 14154514.0 |
| 2015-02-19 11:00:00 | SPY | ETF | 209.985 | 210.42 | 209.9 | 210.28 | 11521664.0 |
| 2015-02-19 12:00:00 | SPY | ETF | 210.28 | 210.37 | 209.66 | 209.93 | 12600282.0 |
| 2015-02-19 13:00:00 | SPY | ETF | 209.9379 | 210.08 | 209.7 | 210.06 | 8638534.0 |
| 2015-02-19 14:00:00 | SPY | ETF | 210.07 | 210.16 | 209.85 | 210.08 | 7202718.0 |
| 2015-02-19 15:00:00 | SPY | ETF | 210.08 | 210.23 | 209.78 | 210.01 | 17168493.0 |
| 2015-02-19 16:00:00 | SPY | ETF | 210.02 | 210.13 | 209.9512 | 210.11 | 6411829.0 |
| 2015-02-19 17:00:00 | SPY | ETF | 210.12 | 210.12 | 210.05 | 210.11 | 36752.0 |
| 2015-02-19 18:00:00 | SPY | ETF | 210.08 | 210.08 | 209.96 | 209.97 | 50015.0 |
| 2015-02-19 19:00:00 | SPY | ETF | 210.02 | 210.02 | 209.93 | 210.01 | 26694.0 |
| 2015-02-19 05:00:00 | QQQ | ETF | 107.04 | 107.1 | 107.04 | 107.1 | 7500.0 |
| 2015-02-19 06:00:00 | QQQ | ETF | 107.04 | 107.08 | 107.04 | 107.08 | 1450.0 |
| 2015-02-19 07:00:00 | QQQ | ETF | 107.22 | 107.36 | 106.97 | 107.13 | 178425.0 |
| 2015-02-19 08:00:00 | QQQ | ETF | 107.09 | 107.18 | 107.071 | 107.09 | 183311.0 |
| 2015-02-19 09:00:00 | QQQ | ETF | 107.1 | 107.43 | 107.02 | 107.39 | 2913306.0 |
| 2015-02-19 10:00:00 | QQQ | ETF | 107.38 | 107.63 | 107.25 | 107.5664 | 2846370.0 |
| 2015-02-19 11:00:00 | QQQ | ETF | 107.57 | 107.72 | 107.46 | 107.66 | 3605283.0 |
| 2015-02-19 12:00:00 | QQQ | ETF | 107.66 | 107.68 | 107.42 | 107.55 | 1580781.0 |
| 2015-02-19 13:00:00 | QQQ | ETF | 107.5663 | 107.69 | 107.51 | 107.675 | 1354831.0 |
| 2015-02-19 14:00:00 | QQQ | ETF | 107.68 | 107.725 | 107.55 | 107.6499 | 970805.0 |
| 2015-02-19 15:00:00 | QQQ | ETF | 107.65 | 107.76 | 107.56 | 107.69 | 3201288.0 |
| 2015-02-19 16:00:00 | QQQ | ETF | 107.68 | 107.78 | 107.68 | 107.78 | 436977.0 |
| 2015-02-19 17:00:00 | QQQ | ETF | 107.78 | 107.78 | 107.72 | 107.74 | 10155.0 |
| 2015-02-19 18:00:00 | QQQ | ETF | 107.7 | 107.72 | 107.7 | 107.7 | 5840.0 |
| 2015-02-19 19:00:00 | QQQ | ETF | 107.71 | 107.71 | 107.7 | 107.71 | 7700.0 |
| 2015-02-19 07:00:00 | IWM | ETF | 122.13 | 122.25 | 121.75 | 121.95 | 15841.0 |
| 2015-02-19 08:00:00 | IWM | ETF | 121.92 | 121.98 | 121.76 | 121.83 | 52443.0 |
| 2015-02-19 09:00:00 | IWM | ETF | 121.79 | 121.92 | 121.54 | 121.79 | 1822709.0 |
| 2015-02-19 10:00:00 | IWM | ETF | 121.78 | 122.22 | 121.595 | 122.09 | 3205233.0 |
| 2015-02-19 11:00:00 | IWM | ETF | 122.1 | 122.29 | 121.97 | 122.14 | 2087685.0 |
| 2015-02-19 12:00:00 | IWM | ETF | 122.145 | 122.27 | 122.04 | 122.18 | 1410022.0 |
| 2015-02-19 13:00:00 | IWM | ETF | 122.1861 | 122.38 | 122.1 | 122.33 | 1132098.0 |
| 2015-02-19 14:00:00 | IWM | ETF | 122.33 | 122.37 | 121.93 | 122.164 | 1712261.0 |
| 2015-02-19 15:00:00 | IWM | ETF | 122.16 | 122.32 | 121.95 | 122.08 | 2681718.0 |
| 2015-02-19 16:00:00 | IWM | ETF | 122.08 | 122.23 | 122.05 | 122.18 | 1271611.0 |
| 2015-02-19 17:00:00 | IWM | ETF | 122.16 | 122.2 | 122.16 | 122.2 | 3564.0 |
| 2015-02-19 18:00:00 | IWM | ETF | 122.18 | 122.18 | 122.18 | 122.18 | 200.0 |
| 2015-02-19 19:00:00 | IWM | ETF | 122.15 | 122.15 | 122.15 | 122.15 | 200.0 |
| 2015-02-19 07:00:00 | DIA | ETF | 180.69 | 180.69 | 180.1 | 180.1 | 500.0 |
| 2015-02-19 08:00:00 | DIA | ETF | 180.1 | 180.22 | 180.06 | 180.1 | 700.0 |
| 2015-02-19 09:00:00 | DIA | ETF | 180.02 | 180.02 | 179.43 | 179.69 | 497768.0 |
| 2015-02-19 10:00:00 | DIA | ETF | 179.7 | 180.2 | 179.5 | 180.09 | 376284.0 |
| 2015-02-19 11:00:00 | DIA | ETF | 180.09 | 180.41 | 180.03 | 180.3025 | 314636.0 |
| 2015-02-19 12:00:00 | DIA | ETF | 180.33 | 180.427 | 179.85 | 180.053 | 369447.0 |
> showing 50 of 7,455 rows — these rows as CSV