PREVIEW / etf_1hour / 2015-07-08
file: by_date/etf_1hour/2015/2015-07-08.parquet size: 253 KB rows: 8,056
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-08 04:00:00 | SPY | ETF | 205.88 | 206.32 | 205.27 | 205.84 | 137299.0 |
| 2015-07-08 05:00:00 | SPY | ETF | 205.87 | 205.94 | 205.49 | 205.86 | 117750.0 |
| 2015-07-08 06:00:00 | SPY | ETF | 205.9 | 206.54 | 205.76 | 206.44 | 362435.0 |
| 2015-07-08 07:00:00 | SPY | ETF | 206.44 | 206.94 | 206.28 | 206.39 | 1132072.0 |
| 2015-07-08 08:00:00 | SPY | ETF | 206.39 | 206.94 | 206.19 | 206.44 | 1202979.0 |
| 2015-07-08 09:00:00 | SPY | ETF | 206.45 | 206.76 | 205.74 | 205.98 | 16876806.0 |
| 2015-07-08 10:00:00 | SPY | ETF | 205.97 | 206.38 | 205.33 | 206.23 | 22517075.0 |
| 2015-07-08 11:00:00 | SPY | ETF | 206.21 | 206.7645 | 204.92 | 205.18 | 20218349.0 |
| 2015-07-08 12:00:00 | SPY | ETF | 205.18 | 205.77 | 205.05 | 205.71 | 12758991.0 |
| 2015-07-08 13:00:00 | SPY | ETF | 205.71 | 205.8959 | 205.32 | 205.705 | 12611690.0 |
| 2015-07-08 14:00:00 | SPY | ETF | 205.72 | 205.77 | 204.25 | 204.51 | 25436339.0 |
| 2015-07-08 15:00:00 | SPY | ETF | 204.51 | 205.32 | 204.4 | 204.48 | 39559417.0 |
| 2015-07-08 16:00:00 | SPY | ETF | 204.5 | 207.9465 | 204.38 | 204.487 | 7969815.0 |
| 2015-07-08 17:00:00 | SPY | ETF | 204.483 | 204.9 | 204.46 | 204.55 | 1122934.0 |
| 2015-07-08 18:00:00 | SPY | ETF | 204.56 | 204.89 | 204.55 | 204.88 | 257266.0 |
| 2015-07-08 19:00:00 | SPY | ETF | 204.86 | 205.04 | 204.83 | 205.04 | 177574.0 |
| 2015-07-08 04:00:00 | QQQ | ETF | 106.81 | 106.93 | 106.5 | 106.5 | 6723.0 |
| 2015-07-08 05:00:00 | QQQ | ETF | 106.82 | 106.82 | 106.82 | 106.82 | 100.0 |
| 2015-07-08 06:00:00 | QQQ | ETF | 106.9 | 107.17 | 106.86 | 107.16 | 22500.0 |
| 2015-07-08 07:00:00 | QQQ | ETF | 107.17 | 107.46 | 107.1 | 107.15 | 83072.0 |
| 2015-07-08 08:00:00 | QQQ | ETF | 107.17 | 107.4 | 106.6933 | 107.23 | 494031.0 |
| 2015-07-08 09:00:00 | QQQ | ETF | 107.22 | 107.33 | 106.55 | 106.7 | 4627768.0 |
| 2015-07-08 10:00:00 | QQQ | ETF | 106.7085 | 107.0556 | 106.34 | 106.97 | 5712581.0 |
| 2015-07-08 11:00:00 | QQQ | ETF | 106.9701 | 106.9701 | 106.17 | 106.32 | 4148363.0 |
| 2015-07-08 12:00:00 | QQQ | ETF | 106.32 | 106.6901 | 106.27 | 106.65 | 2643992.0 |
| 2015-07-08 13:00:00 | QQQ | ETF | 106.65 | 106.85 | 106.46 | 106.7982 | 2047738.0 |
| 2015-07-08 14:00:00 | QQQ | ETF | 106.79 | 106.8225 | 105.8942 | 106.04 | 4985238.0 |
| 2015-07-08 15:00:00 | QQQ | ETF | 106.04 | 106.46 | 105.99 | 106.06 | 7895913.0 |
| 2015-07-08 16:00:00 | QQQ | ETF | 106.06 | 106.379 | 106.03 | 106.14 | 629067.0 |
| 2015-07-08 17:00:00 | QQQ | ETF | 106.137 | 106.17 | 106.09 | 106.12 | 28959.0 |
| 2015-07-08 18:00:00 | QQQ | ETF | 106.14 | 106.34 | 106.14 | 106.34 | 31795.0 |
| 2015-07-08 19:00:00 | QQQ | ETF | 106.33 | 106.41 | 106.3 | 106.36 | 22999.0 |
| 2015-07-08 04:00:00 | IWM | ETF | 122.0 | 122.27 | 122.0 | 122.27 | 1400.0 |
| 2015-07-08 05:00:00 | IWM | ETF | 122.45 | 122.45 | 122.45 | 122.45 | 100.0 |
| 2015-07-08 07:00:00 | IWM | ETF | 122.9 | 123.0 | 122.69 | 122.7 | 44600.0 |
| 2015-07-08 08:00:00 | IWM | ETF | 122.72 | 122.93 | 122.6 | 122.74 | 189480.0 |
| 2015-07-08 09:00:00 | IWM | ETF | 122.75 | 123.35 | 122.47 | 122.77 | 3721334.0 |
| 2015-07-08 10:00:00 | IWM | ETF | 122.76 | 122.96 | 122.14 | 122.81 | 6112838.0 |
| 2015-07-08 11:00:00 | IWM | ETF | 122.82 | 122.82 | 121.89 | 122.08 | 3838177.0 |
| 2015-07-08 12:00:00 | IWM | ETF | 122.08 | 122.29 | 121.75 | 122.2449 | 2923824.0 |
| 2015-07-08 13:00:00 | IWM | ETF | 122.24 | 122.3 | 121.88 | 122.21 | 2207564.0 |
| 2015-07-08 14:00:00 | IWM | ETF | 122.22 | 122.26 | 121.28 | 121.43 | 4887598.0 |
| 2015-07-08 15:00:00 | IWM | ETF | 121.42 | 122.09 | 121.41 | 122.03 | 7623152.0 |
| 2015-07-08 16:00:00 | IWM | ETF | 122.02 | 122.477 | 121.91 | 122.08 | 2875221.0 |
| 2015-07-08 17:00:00 | IWM | ETF | 122.04 | 122.15 | 122.04 | 122.15 | 13483.0 |
| 2015-07-08 18:00:00 | IWM | ETF | 122.12 | 122.16 | 122.12 | 122.15 | 2000.0 |
| 2015-07-08 19:00:00 | IWM | ETF | 122.16 | 122.24 | 122.15 | 122.19 | 1000.0 |
| 2015-07-08 04:00:00 | DIA | ETF | 176.14 | 176.14 | 175.5 | 175.5 | 200.0 |
| 2015-07-08 05:00:00 | DIA | ETF | 175.86 | 175.86 | 175.86 | 175.86 | 100.0 |
| 2015-07-08 06:00:00 | DIA | ETF | 175.89 | 175.89 | 175.89 | 175.89 | 100.0 |
> showing 50 of 8,056 rows — these rows as CSV