PREVIEW / etf_1hour / 2015-07-07
file: by_date/etf_1hour/2015/2015-07-07.parquet size: 255 KB rows: 8,167
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-07-07 04:00:00 | SPY | ETF | 208.16 | 208.3 | 208.01 | 208.06 | 40045.0 |
| 2015-07-07 05:00:00 | SPY | ETF | 208.08 | 208.2 | 207.87 | 207.97 | 44146.0 |
| 2015-07-07 06:00:00 | SPY | ETF | 208.0 | 208.0 | 207.57 | 207.57 | 124510.0 |
| 2015-07-07 07:00:00 | SPY | ETF | 207.58 | 207.65 | 207.25 | 207.45 | 471390.0 |
| 2015-07-07 08:00:00 | SPY | ETF | 207.81 | 207.81 | 206.72 | 207.3 | 549387.0 |
| 2015-07-07 09:00:00 | SPY | ETF | 207.3 | 207.3 | 205.84 | 205.96 | 13721364.0 |
| 2015-07-07 10:00:00 | SPY | ETF | 205.96 | 205.9608 | 204.35 | 204.91 | 33494061.0 |
| 2015-07-07 11:00:00 | SPY | ETF | 204.9 | 205.65 | 204.11 | 205.43 | 28040990.0 |
| 2015-07-07 12:00:00 | SPY | ETF | 205.44 | 206.54 | 205.18 | 206.37 | 16813312.0 |
| 2015-07-07 13:00:00 | SPY | ETF | 206.365 | 206.9 | 206.03 | 206.49 | 16139542.0 |
| 2015-07-07 14:00:00 | SPY | ETF | 206.49 | 207.89 | 206.0 | 207.79 | 22242569.0 |
| 2015-07-07 15:00:00 | SPY | ETF | 207.795 | 208.17 | 207.45 | 207.99 | 32580063.0 |
| 2015-07-07 16:00:00 | SPY | ETF | 207.99 | 208.19 | 207.83 | 207.87 | 6985575.0 |
| 2015-07-07 17:00:00 | SPY | ETF | 207.87 | 207.98 | 207.82 | 207.84 | 444388.0 |
| 2015-07-07 18:00:00 | SPY | ETF | 207.83 | 207.85 | 207.54 | 207.64 | 200890.0 |
| 2015-07-07 19:00:00 | SPY | ETF | 207.63 | 207.65 | 207.44 | 207.52 | 150962.0 |
| 2015-07-07 04:00:00 | QQQ | ETF | 108.45 | 108.48 | 108.45 | 108.48 | 7250.0 |
| 2015-07-07 06:00:00 | QQQ | ETF | 108.17 | 108.23 | 108.15 | 108.15 | 3000.0 |
| 2015-07-07 07:00:00 | QQQ | ETF | 108.11 | 108.12 | 107.94 | 107.98 | 54156.0 |
| 2015-07-07 08:00:00 | QQQ | ETF | 108.05 | 108.07 | 107.9 | 108.01 | 80918.0 |
| 2015-07-07 09:00:00 | QQQ | ETF | 108.0 | 108.0 | 107.08 | 107.13 | 4468002.0 |
| 2015-07-07 10:00:00 | QQQ | ETF | 107.13 | 107.13 | 105.99 | 106.4 | 8810470.0 |
| 2015-07-07 11:00:00 | QQQ | ETF | 106.4 | 106.64 | 105.83 | 106.51 | 6267784.0 |
| 2015-07-07 12:00:00 | QQQ | ETF | 106.52 | 107.12 | 106.345 | 107.03 | 3734604.0 |
| 2015-07-07 13:00:00 | QQQ | ETF | 107.03 | 107.37 | 106.86 | 107.2 | 4156640.0 |
| 2015-07-07 14:00:00 | QQQ | ETF | 107.21 | 107.97 | 106.92 | 107.95 | 4570052.0 |
| 2015-07-07 15:00:00 | QQQ | ETF | 107.95 | 108.07 | 107.69 | 107.89 | 7016348.0 |
| 2015-07-07 16:00:00 | QQQ | ETF | 107.95 | 108.06 | 107.89 | 107.93 | 557279.0 |
| 2015-07-07 17:00:00 | QQQ | ETF | 107.98 | 107.98 | 107.95 | 107.95 | 4120.0 |
| 2015-07-07 18:00:00 | QQQ | ETF | 107.93 | 107.93 | 107.81 | 107.84 | 12571.0 |
| 2015-07-07 19:00:00 | QQQ | ETF | 107.79 | 107.79 | 107.73 | 107.74 | 15024.0 |
| 2015-07-07 07:00:00 | IWM | ETF | 124.12 | 124.3 | 124.03 | 124.04 | 27660.0 |
| 2015-07-07 08:00:00 | IWM | ETF | 124.12 | 124.21 | 124.06 | 124.1 | 142594.0 |
| 2015-07-07 09:00:00 | IWM | ETF | 124.05 | 124.05 | 122.78 | 122.9 | 3711631.0 |
| 2015-07-07 10:00:00 | IWM | ETF | 122.89 | 122.92 | 121.5848 | 122.14 | 10222600.0 |
| 2015-07-07 11:00:00 | IWM | ETF | 122.14 | 122.685 | 121.53 | 122.47 | 5234486.0 |
| 2015-07-07 12:00:00 | IWM | ETF | 122.48 | 123.295 | 122.25 | 123.27 | 3108648.0 |
| 2015-07-07 13:00:00 | IWM | ETF | 123.27 | 123.44 | 122.92 | 123.08 | 3723191.0 |
| 2015-07-07 14:00:00 | IWM | ETF | 123.08 | 123.92 | 122.61 | 123.9 | 3982662.0 |
| 2015-07-07 15:00:00 | IWM | ETF | 123.91 | 123.99 | 123.6 | 123.895 | 5968862.0 |
| 2015-07-07 16:00:00 | IWM | ETF | 123.89 | 123.95 | 123.8 | 123.8 | 782820.0 |
| 2015-07-07 17:00:00 | IWM | ETF | 123.86 | 123.91 | 123.76 | 123.76 | 120673.0 |
| 2015-07-07 18:00:00 | IWM | ETF | 123.85 | 123.92 | 123.85 | 123.85 | 600.0 |
| 2015-07-07 19:00:00 | IWM | ETF | 123.82 | 123.83 | 123.77 | 123.77 | 900.0 |
| 2015-07-07 05:00:00 | DIA | ETF | 177.6 | 177.6 | 177.6 | 177.6 | 100.0 |
| 2015-07-07 07:00:00 | DIA | ETF | 177.3 | 177.3 | 177.12 | 177.12 | 700.0 |
| 2015-07-07 08:00:00 | DIA | ETF | 177.24 | 177.33 | 177.12 | 177.15 | 1800.0 |
| 2015-07-07 09:00:00 | DIA | ETF | 177.12 | 177.12 | 175.91 | 176.0 | 523757.0 |
| 2015-07-07 10:00:00 | DIA | ETF | 175.99 | 175.99 | 174.71 | 175.08 | 1471120.0 |
| 2015-07-07 11:00:00 | DIA | ETF | 175.09 | 175.62 | 174.44 | 175.42 | 1297975.0 |
> showing 50 of 8,167 rows — these rows as CSV