PREVIEW / etf_30min / 2016-02-08
file: by_date/etf_30min/2016/2016-02-08.parquet size: 420 KB rows: 14,254
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-08 04:00:00 | SPY | ETF | 188.1 | 188.11 | 186.29 | 186.66 | 51941.0 |
| 2016-02-08 04:30:00 | SPY | ETF | 186.64 | 186.8 | 185.12 | 185.54 | 120983.0 |
| 2016-02-08 05:00:00 | SPY | ETF | 185.53 | 186.11 | 185.3 | 185.75 | 46969.0 |
| 2016-02-08 05:30:00 | SPY | ETF | 185.84 | 186.19 | 185.69 | 185.71 | 43158.0 |
| 2016-02-08 06:00:00 | SPY | ETF | 185.71 | 185.89 | 185.49 | 185.87 | 39676.0 |
| 2016-02-08 06:30:00 | SPY | ETF | 185.92 | 186.34 | 185.87 | 186.0 | 85085.0 |
| 2016-02-08 07:00:00 | SPY | ETF | 186.04 | 186.06 | 185.35 | 185.84 | 437309.0 |
| 2016-02-08 07:30:00 | SPY | ETF | 185.88 | 185.89 | 185.2 | 185.28 | 892029.0 |
| 2016-02-08 08:00:00 | SPY | ETF | 185.29 | 185.89 | 185.05 | 185.65 | 1017298.0 |
| 2016-02-08 08:30:00 | SPY | ETF | 185.65 | 186.1 | 185.6 | 186.08 | 642021.0 |
| 2016-02-08 09:00:00 | SPY | ETF | 186.06 | 187.98 | 185.5 | 185.77 | 906840.0 |
| 2016-02-08 09:30:00 | SPY | ETF | 185.77 | 185.87 | 184.27 | 184.58 | 25015371.0 |
| 2016-02-08 10:00:00 | SPY | ETF | 184.57 | 185.08 | 183.93 | 184.13 | 16663595.0 |
| 2016-02-08 10:30:00 | SPY | ETF | 184.13 | 184.98 | 184.05 | 184.21 | 12096131.0 |
| 2016-02-08 11:00:00 | SPY | ETF | 184.215 | 184.48 | 183.29 | 184.07 | 14708129.0 |
| 2016-02-08 11:30:00 | SPY | ETF | 184.075 | 185.75 | 183.38 | 184.222 | 9206625.0 |
| 2016-02-08 12:00:00 | SPY | ETF | 184.229 | 184.73 | 184.1 | 184.535 | 6844631.0 |
| 2016-02-08 12:30:00 | SPY | ETF | 184.5399 | 185.75 | 184.21 | 184.3239 | 7679872.0 |
| 2016-02-08 13:00:00 | SPY | ETF | 184.33 | 184.36 | 183.48 | 183.75 | 6560082.0 |
| 2016-02-08 13:30:00 | SPY | ETF | 183.76 | 183.94 | 183.04 | 183.05 | 10548249.0 |
| 2016-02-08 14:00:00 | SPY | ETF | 183.06 | 183.57 | 182.93 | 183.2 | 11077241.0 |
| 2016-02-08 14:30:00 | SPY | ETF | 183.21 | 183.71 | 182.8 | 183.34 | 10796489.0 |
| 2016-02-08 15:00:00 | SPY | ETF | 183.345 | 184.57 | 183.28 | 184.34 | 17541209.0 |
| 2016-02-08 15:30:00 | SPY | ETF | 184.3401 | 186.12 | 184.315 | 185.37 | 29069234.0 |
| 2016-02-08 16:00:00 | SPY | ETF | 185.39 | 185.94 | 185.32 | 185.82 | 5935536.0 |
| 2016-02-08 16:30:00 | SPY | ETF | 185.84 | 186.0 | 185.72 | 185.75 | 1423194.0 |
| 2016-02-08 17:00:00 | SPY | ETF | 185.74 | 185.75 | 185.52 | 185.67 | 80964.0 |
| 2016-02-08 17:30:00 | SPY | ETF | 185.65 | 185.67 | 185.42 | 185.56 | 393224.0 |
| 2016-02-08 18:00:00 | SPY | ETF | 185.53 | 185.54 | 184.97 | 185.02 | 205103.0 |
| 2016-02-08 18:30:00 | SPY | ETF | 185.03 | 185.35 | 184.95 | 185.22 | 88504.0 |
| 2016-02-08 19:00:00 | SPY | ETF | 185.24 | 185.31 | 185.05 | 185.3 | 27558.0 |
| 2016-02-08 19:30:00 | SPY | ETF | 185.26 | 185.33 | 184.9 | 185.01 | 61044.0 |
| 2016-02-08 04:00:00 | QQQ | ETF | 98.3 | 98.3 | 97.21 | 97.28 | 1405.0 |
| 2016-02-08 04:30:00 | QQQ | ETF | 97.35 | 97.39 | 96.5 | 96.55 | 20951.0 |
| 2016-02-08 05:00:00 | QQQ | ETF | 96.6 | 96.77 | 96.28 | 96.58 | 9649.0 |
| 2016-02-08 05:30:00 | QQQ | ETF | 96.84 | 96.84 | 96.55 | 96.55 | 5500.0 |
| 2016-02-08 06:00:00 | QQQ | ETF | 96.44 | 96.6 | 96.41 | 96.56 | 8600.0 |
| 2016-02-08 06:30:00 | QQQ | ETF | 96.68 | 96.68 | 96.4 | 96.51 | 17399.0 |
| 2016-02-08 07:00:00 | QQQ | ETF | 96.48 | 96.48 | 95.85 | 96.2 | 30698.0 |
| 2016-02-08 07:30:00 | QQQ | ETF | 96.24 | 96.25 | 95.81 | 96.0 | 106137.0 |
| 2016-02-08 08:00:00 | QQQ | ETF | 95.97 | 98.12 | 95.84 | 96.17 | 271251.0 |
| 2016-02-08 08:30:00 | QQQ | ETF | 96.17 | 96.46 | 96.14 | 96.42 | 91409.0 |
| 2016-02-08 09:00:00 | QQQ | ETF | 96.42 | 96.45 | 96.14 | 96.33 | 346155.0 |
| 2016-02-08 09:30:00 | QQQ | ETF | 96.33 | 96.5524 | 95.8 | 96.23 | 13000331.0 |
| 2016-02-08 10:00:00 | QQQ | ETF | 96.23 | 96.57 | 95.62 | 95.67 | 6955660.0 |
| 2016-02-08 10:30:00 | QQQ | ETF | 95.67 | 96.38 | 95.615 | 95.79 | 6274036.0 |
| 2016-02-08 11:00:00 | QQQ | ETF | 95.78 | 95.96 | 95.15 | 95.68 | 7086155.0 |
| 2016-02-08 11:30:00 | QQQ | ETF | 95.68 | 95.9099 | 95.28 | 95.9 | 4069653.0 |
| 2016-02-08 12:00:00 | QQQ | ETF | 95.9 | 96.305 | 95.73 | 96.1 | 3274831.0 |
| 2016-02-08 12:30:00 | QQQ | ETF | 96.11 | 96.32 | 95.71 | 95.8 | 3106406.0 |
> showing 50 of 14,254 rows — these rows as CSV