PREVIEW / etf_1hour / 2015-01-12
file: by_date/etf_1hour/2015/2015-01-12.parquet size: 239 KB rows: 7,608
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-01-12 04:00:00 | SPY | ETF | 204.49 | 204.94 | 204.16 | 204.89 | 177268.0 |
| 2015-01-12 05:00:00 | SPY | ETF | 204.92 | 205.14 | 204.86 | 205.05 | 46875.0 |
| 2015-01-12 06:00:00 | SPY | ETF | 204.99 | 205.17 | 204.88 | 205.15 | 69801.0 |
| 2015-01-12 07:00:00 | SPY | ETF | 205.13 | 205.15 | 204.72 | 204.74 | 510076.0 |
| 2015-01-12 08:00:00 | SPY | ETF | 204.72 | 205.06 | 203.89 | 204.29 | 1015725.0 |
| 2015-01-12 09:00:00 | SPY | ETF | 204.27 | 204.6 | 202.08 | 202.36 | 22181379.0 |
| 2015-01-12 10:00:00 | SPY | ETF | 202.37 | 203.11 | 201.92 | 203.1 | 23632840.0 |
| 2015-01-12 11:00:00 | SPY | ETF | 203.11 | 203.3 | 202.53 | 202.755 | 15942606.0 |
| 2015-01-12 12:00:00 | SPY | ETF | 202.76 | 203.18 | 202.56 | 202.64 | 9429791.0 |
| 2015-01-12 13:00:00 | SPY | ETF | 202.65 | 202.86 | 202.31 | 202.65 | 8711641.0 |
| 2015-01-12 14:00:00 | SPY | ETF | 202.66 | 202.87 | 202.07 | 202.46 | 13515464.0 |
| 2015-01-12 15:00:00 | SPY | ETF | 202.45 | 203.05 | 202.0 | 202.62 | 26542831.0 |
| 2015-01-12 16:00:00 | SPY | ETF | 202.62 | 202.88 | 202.53 | 202.8 | 10891990.0 |
| 2015-01-12 17:00:00 | SPY | ETF | 202.79 | 202.8 | 202.65 | 202.72 | 115200.0 |
| 2015-01-12 18:00:00 | SPY | ETF | 202.73 | 202.94 | 202.73 | 202.8 | 300736.0 |
| 2015-01-12 19:00:00 | SPY | ETF | 202.8 | 202.83 | 202.69 | 202.69 | 35725.0 |
| 2015-01-12 04:00:00 | QQQ | ETF | 102.82 | 102.9 | 102.65 | 102.82 | 38150.0 |
| 2015-01-12 05:00:00 | QQQ | ETF | 103.01 | 103.01 | 103.01 | 103.01 | 800.0 |
| 2015-01-12 06:00:00 | QQQ | ETF | 103.04 | 103.15 | 103.04 | 103.15 | 5982.0 |
| 2015-01-12 07:00:00 | QQQ | ETF | 103.07 | 103.1 | 102.92 | 102.93 | 55678.0 |
| 2015-01-12 08:00:00 | QQQ | ETF | 102.91 | 103.13 | 102.62 | 102.75 | 273945.0 |
| 2015-01-12 09:00:00 | QQQ | ETF | 102.76 | 102.93 | 101.54 | 101.64 | 4716698.0 |
| 2015-01-12 10:00:00 | QQQ | ETF | 101.65 | 102.05 | 101.32 | 102.05 | 5748913.0 |
| 2015-01-12 11:00:00 | QQQ | ETF | 102.04 | 102.1199 | 101.61 | 101.735 | 2775702.0 |
| 2015-01-12 12:00:00 | QQQ | ETF | 101.75 | 102.03 | 101.65 | 101.7 | 1466266.0 |
| 2015-01-12 13:00:00 | QQQ | ETF | 101.7 | 101.8 | 101.46 | 101.7 | 1657963.0 |
| 2015-01-12 14:00:00 | QQQ | ETF | 101.7 | 101.805 | 101.34 | 101.54 | 2407177.0 |
| 2015-01-12 15:00:00 | QQQ | ETF | 101.54 | 101.83 | 101.285 | 101.59 | 5152847.0 |
| 2015-01-12 16:00:00 | QQQ | ETF | 101.59 | 101.78 | 101.55 | 101.72 | 836574.0 |
| 2015-01-12 17:00:00 | QQQ | ETF | 101.74 | 101.74 | 101.68 | 101.69 | 16100.0 |
| 2015-01-12 18:00:00 | QQQ | ETF | 101.72 | 101.83 | 101.72 | 101.77 | 8665.0 |
| 2015-01-12 19:00:00 | QQQ | ETF | 101.79 | 101.79 | 101.68 | 101.68 | 12100.0 |
| 2015-01-12 07:00:00 | IWM | ETF | 118.02 | 118.16 | 117.95 | 117.95 | 40704.0 |
| 2015-01-12 08:00:00 | IWM | ETF | 118.0 | 118.05 | 117.46 | 117.55 | 176316.0 |
| 2015-01-12 09:00:00 | IWM | ETF | 117.61 | 118.01 | 116.55 | 116.66 | 4566916.0 |
| 2015-01-12 10:00:00 | IWM | ETF | 116.66 | 117.39 | 116.23 | 117.38 | 4652749.0 |
| 2015-01-12 11:00:00 | IWM | ETF | 117.39 | 117.5 | 117.07 | 117.22 | 1938267.0 |
| 2015-01-12 12:00:00 | IWM | ETF | 117.21 | 117.4 | 117.03 | 117.14 | 1051858.0 |
| 2015-01-12 13:00:00 | IWM | ETF | 117.14 | 117.23 | 116.9 | 117.145 | 1761898.0 |
| 2015-01-12 14:00:00 | IWM | ETF | 117.15 | 117.26 | 116.985 | 117.19 | 1663987.0 |
| 2015-01-12 15:00:00 | IWM | ETF | 117.19 | 117.3 | 116.67 | 117.2 | 5449988.0 |
| 2015-01-12 16:00:00 | IWM | ETF | 117.2 | 117.45 | 117.15 | 117.36 | 3526883.0 |
| 2015-01-12 17:00:00 | IWM | ETF | 117.35 | 117.42 | 117.35 | 117.35 | 6147.0 |
| 2015-01-12 05:00:00 | DIA | ETF | 178.0 | 178.0 | 178.0 | 178.0 | 100.0 |
| 2015-01-12 07:00:00 | DIA | ETF | 177.9 | 177.9 | 177.75 | 177.75 | 13057.0 |
| 2015-01-12 08:00:00 | DIA | ETF | 177.9 | 177.9 | 177.1 | 177.24 | 11090.0 |
| 2015-01-12 09:00:00 | DIA | ETF | 177.3 | 177.63 | 175.54 | 175.8 | 1051521.0 |
| 2015-01-12 10:00:00 | DIA | ETF | 175.816 | 176.64 | 175.46 | 176.63 | 836726.0 |
| 2015-01-12 11:00:00 | DIA | ETF | 176.6699 | 176.82 | 176.17 | 176.34 | 549170.0 |
| 2015-01-12 12:00:00 | DIA | ETF | 176.34 | 176.739 | 176.15 | 176.23 | 236990.0 |
> showing 50 of 7,608 rows — these rows as CSV