PREVIEW / etf_1hour / 2015-08-19
file: by_date/etf_1hour/2015/2015-08-19.parquet size: 246 KB rows: 7,780
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-08-19 04:00:00 | SPY | ETF | 209.66 | 209.66 | 209.06 | 209.23 | 50285.0 |
| 2015-08-19 05:00:00 | SPY | ETF | 209.2 | 209.54 | 209.2 | 209.42 | 13032.0 |
| 2015-08-19 06:00:00 | SPY | ETF | 209.43 | 209.75 | 209.43 | 209.62 | 50696.0 |
| 2015-08-19 07:00:00 | SPY | ETF | 209.64 | 209.64 | 209.33 | 209.34 | 339183.0 |
| 2015-08-19 08:00:00 | SPY | ETF | 209.37 | 209.62 | 209.25 | 209.38 | 435399.0 |
| 2015-08-19 09:00:00 | SPY | ETF | 209.39 | 209.9 | 208.16 | 208.28 | 18376651.0 |
| 2015-08-19 10:00:00 | SPY | ETF | 208.28 | 208.83 | 207.73 | 207.9 | 19719354.0 |
| 2015-08-19 11:00:00 | SPY | ETF | 207.9 | 208.175 | 207.35 | 207.71 | 19461151.0 |
| 2015-08-19 12:00:00 | SPY | ETF | 207.71 | 208.25 | 207.55 | 208.11 | 11890953.0 |
| 2015-08-19 13:00:00 | SPY | ETF | 208.11 | 208.87 | 208.02 | 208.37 | 19635968.0 |
| 2015-08-19 14:00:00 | SPY | ETF | 208.3601 | 210.01 | 208.22 | 208.355 | 34705441.0 |
| 2015-08-19 15:00:00 | SPY | ETF | 208.36 | 208.97 | 208.08 | 208.32 | 31487069.0 |
| 2015-08-19 16:00:00 | SPY | ETF | 208.31 | 208.84 | 207.5014 | 208.0 | 8634637.0 |
| 2015-08-19 17:00:00 | SPY | ETF | 207.98 | 208.32 | 207.86 | 208.0 | 1339241.0 |
| 2015-08-19 18:00:00 | SPY | ETF | 207.97 | 208.1 | 207.95 | 208.08 | 103898.0 |
| 2015-08-19 19:00:00 | SPY | ETF | 208.07 | 208.18 | 208.03 | 208.1 | 54488.0 |
| 2015-08-19 04:00:00 | QQQ | ETF | 110.5 | 110.66 | 110.4 | 110.4 | 34600.0 |
| 2015-08-19 05:00:00 | QQQ | ETF | 110.61 | 110.61 | 110.61 | 110.61 | 500.0 |
| 2015-08-19 06:00:00 | QQQ | ETF | 110.68 | 110.76 | 110.62 | 110.67 | 19300.0 |
| 2015-08-19 07:00:00 | QQQ | ETF | 110.69 | 110.73 | 110.65 | 110.67 | 90900.0 |
| 2015-08-19 08:00:00 | QQQ | ETF | 110.67 | 110.77 | 110.64 | 110.69 | 37828.0 |
| 2015-08-19 09:00:00 | QQQ | ETF | 110.71 | 110.71 | 109.9 | 109.99 | 5062802.0 |
| 2015-08-19 10:00:00 | QQQ | ETF | 110.0 | 110.43 | 109.84 | 109.96 | 5505414.0 |
| 2015-08-19 11:00:00 | QQQ | ETF | 109.94 | 110.11 | 109.49 | 109.7 | 4254035.0 |
| 2015-08-19 12:00:00 | QQQ | ETF | 109.69 | 110.02 | 109.61 | 109.97 | 3022441.0 |
| 2015-08-19 13:00:00 | QQQ | ETF | 109.97 | 110.4 | 109.93 | 110.18 | 4338087.0 |
| 2015-08-19 14:00:00 | QQQ | ETF | 110.18 | 111.105 | 110.05 | 110.08 | 7534514.0 |
| 2015-08-19 15:00:00 | QQQ | ETF | 110.08 | 110.48 | 109.94 | 110.15 | 5806029.0 |
| 2015-08-19 16:00:00 | QQQ | ETF | 110.14 | 110.15 | 109.87 | 109.99 | 844823.0 |
| 2015-08-19 17:00:00 | QQQ | ETF | 109.99 | 110.0 | 109.91 | 109.93 | 9099.0 |
| 2015-08-19 18:00:00 | QQQ | ETF | 109.95 | 110.01 | 109.95 | 110.01 | 22898.0 |
| 2015-08-19 19:00:00 | QQQ | ETF | 110.01 | 110.04 | 110.0 | 110.02 | 11196.0 |
| 2015-08-19 04:00:00 | IWM | ETF | 120.37 | 120.37 | 120.31 | 120.31 | 200.0 |
| 2015-08-19 05:00:00 | IWM | ETF | 119.9 | 119.9 | 119.9 | 119.9 | 100.0 |
| 2015-08-19 06:00:00 | IWM | ETF | 120.22 | 120.27 | 120.21 | 120.21 | 6200.0 |
| 2015-08-19 07:00:00 | IWM | ETF | 120.19 | 120.39 | 120.05 | 120.17 | 78600.0 |
| 2015-08-19 08:00:00 | IWM | ETF | 120.1 | 120.24 | 119.99 | 120.08 | 87323.0 |
| 2015-08-19 09:00:00 | IWM | ETF | 120.0 | 120.0 | 119.23 | 119.63 | 5105734.0 |
| 2015-08-19 10:00:00 | IWM | ETF | 119.64 | 120.01 | 118.88 | 119.0 | 6459771.0 |
| 2015-08-19 11:00:00 | IWM | ETF | 118.99 | 119.25 | 118.74 | 119.01 | 4025400.0 |
| 2015-08-19 12:00:00 | IWM | ETF | 119.01 | 119.56 | 118.97 | 119.41 | 2485563.0 |
| 2015-08-19 13:00:00 | IWM | ETF | 119.41 | 119.96 | 119.36 | 119.49 | 4139533.0 |
| 2015-08-19 14:00:00 | IWM | ETF | 119.49 | 120.5 | 119.47 | 119.6835 | 8919118.0 |
| 2015-08-19 15:00:00 | IWM | ETF | 119.69 | 119.915 | 119.41 | 119.43 | 5768127.0 |
| 2015-08-19 16:00:00 | IWM | ETF | 119.42 | 119.44 | 119.12 | 119.17 | 1094202.0 |
| 2015-08-19 17:00:00 | IWM | ETF | 119.24 | 119.29 | 119.22 | 119.25 | 21591.0 |
| 2015-08-19 18:00:00 | IWM | ETF | 119.37 | 119.37 | 119.37 | 119.37 | 156.0 |
| 2015-08-19 07:00:00 | DIA | ETF | 174.82 | 174.82 | 174.71 | 174.71 | 1490.0 |
| 2015-08-19 08:00:00 | DIA | ETF | 174.71 | 174.79 | 174.6 | 174.6 | 7550.0 |
| 2015-08-19 09:00:00 | DIA | ETF | 174.57 | 174.57 | 173.7 | 173.8 | 989434.0 |
> showing 50 of 7,780 rows — these rows as CSV