PREVIEW / etf_1hour / 2015-03-18
file: by_date/etf_1hour/2015/2015-03-18.parquet size: 243 KB rows: 7,685
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-03-18 04:00:00 | SPY | ETF | 208.18 | 208.35 | 208.04 | 208.22 | 21609.0 |
| 2015-03-18 05:00:00 | SPY | ETF | 208.15 | 208.15 | 208.03 | 208.04 | 4200.0 |
| 2015-03-18 06:00:00 | SPY | ETF | 208.04 | 208.04 | 207.24 | 207.24 | 64128.0 |
| 2015-03-18 07:00:00 | SPY | ETF | 207.47 | 207.54 | 207.08 | 207.18 | 426167.0 |
| 2015-03-18 08:00:00 | SPY | ETF | 207.18 | 207.98 | 207.08 | 207.35 | 1168953.0 |
| 2015-03-18 09:00:00 | SPY | ETF | 207.32 | 207.47 | 206.95 | 207.135 | 9739112.0 |
| 2015-03-18 10:00:00 | SPY | ETF | 207.135 | 207.57 | 207.11 | 207.51 | 11109416.0 |
| 2015-03-18 11:00:00 | SPY | ETF | 207.5 | 207.58 | 207.12 | 207.27 | 8766009.0 |
| 2015-03-18 12:00:00 | SPY | ETF | 207.27 | 207.34 | 206.95 | 207.04 | 11102764.0 |
| 2015-03-18 13:00:00 | SPY | ETF | 207.03 | 207.34 | 206.62 | 207.29 | 17164446.0 |
| 2015-03-18 14:00:00 | SPY | ETF | 207.3 | 210.37 | 207.24 | 210.11 | 76650377.0 |
| 2015-03-18 15:00:00 | SPY | ETF | 210.1 | 211.27 | 209.99 | 210.44 | 67201978.0 |
| 2015-03-18 16:00:00 | SPY | ETF | 210.44 | 210.69 | 207.952 | 210.58 | 17383476.0 |
| 2015-03-18 17:00:00 | SPY | ETF | 210.59 | 210.62 | 210.5 | 210.58 | 1314489.0 |
| 2015-03-18 18:00:00 | SPY | ETF | 210.58 | 210.72 | 210.58 | 210.6 | 181650.0 |
| 2015-03-18 19:00:00 | SPY | ETF | 210.6 | 210.99 | 210.59 | 210.81 | 165967.0 |
| 2015-03-18 07:00:00 | QQQ | ETF | 106.6 | 106.6 | 106.48 | 106.48 | 37276.0 |
| 2015-03-18 08:00:00 | QQQ | ETF | 106.5 | 106.56 | 106.44 | 106.54 | 77759.0 |
| 2015-03-18 09:00:00 | QQQ | ETF | 106.53 | 106.63 | 106.3 | 106.45 | 2405514.0 |
| 2015-03-18 10:00:00 | QQQ | ETF | 106.46 | 106.65 | 106.43 | 106.64 | 2079328.0 |
| 2015-03-18 11:00:00 | QQQ | ETF | 106.64 | 106.6965 | 106.4 | 106.494 | 1848037.0 |
| 2015-03-18 12:00:00 | QQQ | ETF | 106.49 | 106.51 | 106.32 | 106.33 | 1213705.0 |
| 2015-03-18 13:00:00 | QQQ | ETF | 106.33 | 106.4 | 106.03 | 106.375 | 2646306.0 |
| 2015-03-18 14:00:00 | QQQ | ETF | 106.3786 | 107.91 | 106.36 | 107.82 | 13587289.0 |
| 2015-03-18 15:00:00 | QQQ | ETF | 107.81 | 108.41 | 107.74 | 107.92 | 8927487.0 |
| 2015-03-18 16:00:00 | QQQ | ETF | 107.93 | 108.13 | 107.686 | 108.11 | 1799956.0 |
| 2015-03-18 17:00:00 | QQQ | ETF | 108.12 | 108.12 | 107.9487 | 108.05 | 88950.0 |
| 2015-03-18 18:00:00 | QQQ | ETF | 108.1 | 108.2 | 108.1 | 108.12 | 67440.0 |
| 2015-03-18 19:00:00 | QQQ | ETF | 108.12 | 108.28 | 108.12 | 108.2 | 12117.0 |
| 2015-03-18 07:00:00 | IWM | ETF | 123.18 | 123.24 | 123.15 | 123.17 | 20200.0 |
| 2015-03-18 08:00:00 | IWM | ETF | 123.2 | 123.34 | 123.17 | 123.25 | 128108.0 |
| 2015-03-18 09:00:00 | IWM | ETF | 123.23 | 123.43 | 122.92 | 123.28 | 2281185.0 |
| 2015-03-18 10:00:00 | IWM | ETF | 123.285 | 123.6499 | 123.21 | 123.56 | 1991844.0 |
| 2015-03-18 11:00:00 | IWM | ETF | 123.55 | 123.67 | 123.35 | 123.62 | 1643936.0 |
| 2015-03-18 12:00:00 | IWM | ETF | 123.62 | 123.685 | 123.4 | 123.43 | 1357638.0 |
| 2015-03-18 13:00:00 | IWM | ETF | 123.43 | 123.45 | 122.85 | 123.45 | 2613397.0 |
| 2015-03-18 14:00:00 | IWM | ETF | 123.4 | 124.72 | 123.4 | 124.41 | 9903799.0 |
| 2015-03-18 15:00:00 | IWM | ETF | 124.4 | 125.12 | 124.35 | 124.6 | 8173749.0 |
| 2015-03-18 16:00:00 | IWM | ETF | 124.6 | 124.81 | 123.629 | 124.65 | 3808640.0 |
| 2015-03-18 17:00:00 | IWM | ETF | 124.7 | 124.74 | 124.66 | 124.72 | 82035.0 |
| 2015-03-18 18:00:00 | IWM | ETF | 124.65 | 124.73 | 124.65 | 124.73 | 770.0 |
| 2015-03-18 19:00:00 | IWM | ETF | 124.65 | 124.81 | 124.65 | 124.81 | 13297.0 |
| 2015-03-18 07:00:00 | DIA | ETF | 177.88 | 177.9 | 177.8 | 177.8 | 800.0 |
| 2015-03-18 08:00:00 | DIA | ETF | 177.75 | 177.75 | 177.75 | 177.75 | 100.0 |
| 2015-03-18 09:00:00 | DIA | ETF | 177.68 | 177.93 | 177.41 | 177.53 | 874861.0 |
| 2015-03-18 10:00:00 | DIA | ETF | 177.54 | 177.98 | 177.52 | 177.87 | 666186.0 |
| 2015-03-18 11:00:00 | DIA | ETF | 177.87 | 177.98 | 177.48 | 177.62 | 657080.0 |
| 2015-03-18 12:00:00 | DIA | ETF | 177.6 | 177.63 | 177.2 | 177.33 | 630334.0 |
| 2015-03-18 13:00:00 | DIA | ETF | 177.32 | 177.619 | 176.97 | 177.56 | 807357.0 |
| 2015-03-18 14:00:00 | DIA | ETF | 177.64 | 180.52 | 177.59 | 180.17 | 4322097.0 |
> showing 50 of 7,685 rows — these rows as CSV