PREVIEW / etf_1hour / 2015-03-30
file: by_date/etf_1hour/2015/2015-03-30.parquet size: 239 KB rows: 7,619
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-30 04:00:00 | SPY | ETF | 206.23 | 207.3 | 206.23 | 207.08 | 34194.0 |
| 2015-03-30 05:00:00 | SPY | ETF | 207.06 | 207.15 | 207.01 | 207.06 | 36191.0 |
| 2015-03-30 06:00:00 | SPY | ETF | 207.03 | 207.05 | 206.62 | 206.62 | 44232.0 |
| 2015-03-30 07:00:00 | SPY | ETF | 206.65 | 206.83 | 206.61 | 206.76 | 277866.0 |
| 2015-03-30 08:00:00 | SPY | ETF | 206.76 | 206.92 | 206.06 | 206.76 | 495637.0 |
| 2015-03-30 09:00:00 | SPY | ETF | 206.75 | 208.05 | 205.74 | 207.93 | 15919735.0 |
| 2015-03-30 10:00:00 | SPY | ETF | 207.935 | 208.1 | 207.52 | 207.84 | 13911135.0 |
| 2015-03-30 11:00:00 | SPY | ETF | 207.85 | 208.0 | 207.665 | 207.93 | 7448424.0 |
| 2015-03-30 12:00:00 | SPY | ETF | 207.93 | 208.23 | 207.9 | 208.18 | 9004097.0 |
| 2015-03-30 13:00:00 | SPY | ETF | 208.18 | 208.48 | 208.14 | 208.2749 | 7303043.0 |
| 2015-03-30 14:00:00 | SPY | ETF | 208.274 | 208.54 | 208.27 | 208.52 | 6935805.0 |
| 2015-03-30 15:00:00 | SPY | ETF | 208.53 | 208.61 | 208.245 | 208.26 | 17872937.0 |
| 2015-03-30 16:00:00 | SPY | ETF | 208.27 | 208.33 | 207.8679 | 207.89 | 13504632.0 |
| 2015-03-30 17:00:00 | SPY | ETF | 207.89 | 208.25 | 207.88 | 207.96 | 1397309.0 |
| 2015-03-30 18:00:00 | SPY | ETF | 207.96 | 208.11 | 207.95 | 208.01 | 134371.0 |
| 2015-03-30 19:00:00 | SPY | ETF | 208.0 | 208.07 | 207.98 | 208.03 | 43626.0 |
| 2015-03-30 04:00:00 | QQQ | ETF | 106.1 | 106.53 | 106.1 | 106.48 | 8070.0 |
| 2015-03-30 05:00:00 | QQQ | ETF | 106.45 | 106.48 | 106.45 | 106.48 | 8473.0 |
| 2015-03-30 06:00:00 | QQQ | ETF | 106.48 | 106.48 | 106.23 | 106.23 | 3900.0 |
| 2015-03-30 07:00:00 | QQQ | ETF | 106.23 | 106.34 | 106.16 | 106.23 | 70190.0 |
| 2015-03-30 08:00:00 | QQQ | ETF | 106.22 | 106.3 | 106.19 | 106.19 | 127500.0 |
| 2015-03-30 09:00:00 | QQQ | ETF | 106.2 | 106.775 | 106.16 | 106.66 | 5861359.0 |
| 2015-03-30 10:00:00 | QQQ | ETF | 106.66 | 106.82 | 106.22 | 106.42 | 4556804.0 |
| 2015-03-30 11:00:00 | QQQ | ETF | 106.42 | 106.6 | 106.3 | 106.44 | 2232305.0 |
| 2015-03-30 12:00:00 | QQQ | ETF | 106.4301 | 106.64 | 106.39 | 106.59 | 2003869.0 |
| 2015-03-30 13:00:00 | QQQ | ETF | 106.6 | 106.76 | 106.5 | 106.6699 | 1983675.0 |
| 2015-03-30 14:00:00 | QQQ | ETF | 106.66 | 106.8 | 106.54 | 106.66 | 1402649.0 |
| 2015-03-30 15:00:00 | QQQ | ETF | 106.66 | 106.8 | 106.59 | 106.73 | 5839612.0 |
| 2015-03-30 16:00:00 | QQQ | ETF | 106.74 | 106.89 | 106.5669 | 106.65 | 2753756.0 |
| 2015-03-30 17:00:00 | QQQ | ETF | 106.66 | 106.73 | 106.65 | 106.68 | 1132634.0 |
| 2015-03-30 18:00:00 | QQQ | ETF | 106.68 | 106.75 | 106.67 | 106.7 | 19832.0 |
| 2015-03-30 19:00:00 | QQQ | ETF | 106.68 | 106.73 | 106.68 | 106.7 | 1800.0 |
| 2015-03-30 04:00:00 | IWM | ETF | 123.53 | 123.89 | 123.53 | 123.89 | 360.0 |
| 2015-03-30 07:00:00 | IWM | ETF | 123.65 | 123.71 | 123.65 | 123.69 | 16896.0 |
| 2015-03-30 08:00:00 | IWM | ETF | 123.65 | 123.8 | 123.63 | 123.73 | 98293.0 |
| 2015-03-30 09:00:00 | IWM | ETF | 123.73 | 124.35 | 123.69 | 124.29 | 3145932.0 |
| 2015-03-30 10:00:00 | IWM | ETF | 124.28 | 124.42 | 124.06 | 124.36 | 2696475.0 |
| 2015-03-30 11:00:00 | IWM | ETF | 124.36 | 124.48 | 124.3 | 124.43 | 1520164.0 |
| 2015-03-30 12:00:00 | IWM | ETF | 124.44 | 124.85 | 124.42 | 124.82 | 1798334.0 |
| 2015-03-30 13:00:00 | IWM | ETF | 124.83 | 124.95 | 124.72 | 124.8 | 1591835.0 |
| 2015-03-30 14:00:00 | IWM | ETF | 124.795 | 124.98 | 124.79 | 124.96 | 1187135.0 |
| 2015-03-30 15:00:00 | IWM | ETF | 124.96 | 124.99 | 124.69 | 124.77 | 4432849.0 |
| 2015-03-30 16:00:00 | IWM | ETF | 124.78 | 124.8695 | 124.4145 | 124.6 | 2088283.0 |
| 2015-03-30 17:00:00 | IWM | ETF | 124.77 | 124.77 | 124.55 | 124.55 | 685085.0 |
| 2015-03-30 18:00:00 | IWM | ETF | 124.61 | 124.61 | 124.53 | 124.53 | 400.0 |
| 2015-03-30 19:00:00 | IWM | ETF | 124.54 | 124.54 | 124.54 | 124.54 | 100.0 |
| 2015-03-30 07:00:00 | DIA | ETF | 177.94 | 177.95 | 177.88 | 177.9 | 1100.0 |
| 2015-03-30 08:00:00 | DIA | ETF | 177.909 | 178.09 | 177.84 | 178.05 | 6209.0 |
| 2015-03-30 09:00:00 | DIA | ETF | 178.1 | 179.53 | 176.81 | 179.43 | 1464622.0 |
| 2015-03-30 10:00:00 | DIA | ETF | 179.42 | 179.6 | 179.21 | 179.46 | 1021908.0 |
> showing 50 of 7,619 rows — these rows as CSV