PREVIEW / etf_1hour / 2015-01-05
file: by_date/etf_1hour/2015/2015-01-05.parquet size: 247 KB rows: 7,844
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-05 04:00:00 | SPY | ETF | 205.11 | 205.11 | 204.63 | 204.65 | 35646.0 |
| 2015-01-05 05:00:00 | SPY | ETF | 204.65 | 204.72 | 204.39 | 204.39 | 38212.0 |
| 2015-01-05 06:00:00 | SPY | ETF | 204.37 | 204.69 | 204.37 | 204.44 | 36990.0 |
| 2015-01-05 07:00:00 | SPY | ETF | 204.41 | 204.69 | 204.4 | 204.52 | 223942.0 |
| 2015-01-05 08:00:00 | SPY | ETF | 204.54 | 205.43 | 203.82 | 204.0 | 1344754.0 |
| 2015-01-05 09:00:00 | SPY | ETF | 204.0 | 204.37 | 203.09 | 203.121 | 17184635.0 |
| 2015-01-05 10:00:00 | SPY | ETF | 203.12 | 203.5 | 202.5 | 202.8 | 25680772.0 |
| 2015-01-05 11:00:00 | SPY | ETF | 202.8 | 202.89 | 202.15 | 202.69 | 23039187.0 |
| 2015-01-05 12:00:00 | SPY | ETF | 202.69 | 202.79 | 201.66 | 201.93 | 15906531.0 |
| 2015-01-05 13:00:00 | SPY | ETF | 201.93 | 202.16 | 201.56 | 201.995 | 18790158.0 |
| 2015-01-05 14:00:00 | SPY | ETF | 201.995 | 202.02 | 201.37 | 201.4401 | 16255174.0 |
| 2015-01-05 15:00:00 | SPY | ETF | 201.44 | 202.32 | 201.35 | 201.8 | 34513634.0 |
| 2015-01-05 16:00:00 | SPY | ETF | 201.8 | 202.2334 | 201.63 | 202.14 | 9372036.0 |
| 2015-01-05 17:00:00 | SPY | ETF | 202.14 | 202.18 | 201.72 | 201.72 | 1319645.0 |
| 2015-01-05 18:00:00 | SPY | ETF | 202.15 | 202.31 | 202.15 | 202.3 | 152856.0 |
| 2015-01-05 19:00:00 | SPY | ETF | 202.28 | 202.28 | 201.91 | 201.96 | 89605.0 |
| 2015-01-05 20:00:00 | SPY | ETF | 201.7163 | 201.7163 | 201.7163 | 201.7163 | 385000.0 |
| 2015-01-05 05:00:00 | QQQ | ETF | 102.6 | 102.6 | 102.51 | 102.51 | 17450.0 |
| 2015-01-05 06:00:00 | QQQ | ETF | 102.57 | 102.65 | 102.57 | 102.64 | 8600.0 |
| 2015-01-05 07:00:00 | QQQ | ETF | 102.56 | 102.69 | 102.56 | 102.67 | 27307.0 |
| 2015-01-05 08:00:00 | QQQ | ETF | 102.62 | 102.94 | 102.33 | 102.39 | 141539.0 |
| 2015-01-05 09:00:00 | QQQ | ETF | 102.42 | 102.61 | 102.03 | 102.06 | 5093482.0 |
| 2015-01-05 10:00:00 | QQQ | ETF | 102.055 | 102.3332 | 101.76 | 101.955 | 5540175.0 |
| 2015-01-05 11:00:00 | QQQ | ETF | 101.96 | 102.12 | 101.6099 | 102.01 | 3691099.0 |
| 2015-01-05 12:00:00 | QQQ | ETF | 102.0 | 102.06 | 101.47 | 101.6 | 2574033.0 |
| 2015-01-05 13:00:00 | QQQ | ETF | 101.605 | 101.67 | 101.33 | 101.555 | 2655363.0 |
| 2015-01-05 14:00:00 | QQQ | ETF | 101.55 | 101.59 | 101.14 | 101.245 | 3432494.0 |
| 2015-01-05 15:00:00 | QQQ | ETF | 101.245 | 101.66 | 101.185 | 101.42 | 7387280.0 |
| 2015-01-05 16:00:00 | QQQ | ETF | 101.43 | 103.0572 | 101.34 | 101.62 | 2160680.0 |
| 2015-01-05 17:00:00 | QQQ | ETF | 101.62 | 101.62 | 101.58 | 101.6 | 53704.0 |
| 2015-01-05 18:00:00 | QQQ | ETF | 101.62 | 101.66 | 101.43 | 101.66 | 174368.0 |
| 2015-01-05 19:00:00 | QQQ | ETF | 101.65 | 101.66 | 101.47 | 101.47 | 10800.0 |
| 2015-01-05 06:00:00 | IWM | ETF | 118.46 | 118.46 | 118.46 | 118.46 | 2150.0 |
| 2015-01-05 07:00:00 | IWM | ETF | 118.44 | 118.57 | 118.43 | 118.5 | 14850.0 |
| 2015-01-05 08:00:00 | IWM | ETF | 118.49 | 118.97 | 117.99 | 118.05 | 132104.0 |
| 2015-01-05 09:00:00 | IWM | ETF | 118.1 | 118.48 | 117.77 | 118.06 | 6721721.0 |
| 2015-01-05 10:00:00 | IWM | ETF | 118.05 | 118.71 | 117.92 | 118.45 | 6376984.0 |
| 2015-01-05 11:00:00 | IWM | ETF | 118.45 | 118.605 | 117.9 | 118.38 | 5345394.0 |
| 2015-01-05 12:00:00 | IWM | ETF | 118.37 | 118.48 | 117.66 | 117.75 | 3685703.0 |
| 2015-01-05 13:00:00 | IWM | ETF | 117.755 | 117.83 | 117.26 | 117.47 | 3798810.0 |
| 2015-01-05 14:00:00 | IWM | ETF | 117.47 | 117.51 | 116.79 | 117.16 | 5177891.0 |
| 2015-01-05 15:00:00 | IWM | ETF | 117.155 | 117.58 | 117.09 | 117.41 | 6347803.0 |
| 2015-01-05 16:00:00 | IWM | ETF | 117.4 | 117.65 | 117.28 | 117.65 | 3837849.0 |
| 2015-01-05 17:00:00 | IWM | ETF | 117.63 | 117.67 | 117.62 | 117.62 | 4700.0 |
| 2015-01-05 18:00:00 | IWM | ETF | 117.61 | 117.61 | 117.5 | 117.5 | 1700.0 |
| 2015-01-05 19:00:00 | IWM | ETF | 117.55 | 117.6 | 117.44 | 117.44 | 3700.0 |
| 2015-01-05 07:00:00 | DIA | ETF | 177.27 | 177.27 | 177.27 | 177.27 | 200.0 |
| 2015-01-05 08:00:00 | DIA | ETF | 177.24 | 177.55 | 176.79 | 176.79 | 33659.0 |
| 2015-01-05 09:00:00 | DIA | ETF | 176.87 | 177.21 | 176.129 | 176.17 | 774324.0 |
| 2015-01-05 10:00:00 | DIA | ETF | 176.16 | 176.46 | 175.61 | 175.79 | 1243859.0 |
> showing 50 of 7,844 rows — these rows as CSV