PREVIEW / etf_30min / 2015-12-08
file: by_date/etf_30min/2015/2015-12-08.parquet size: 390 KB rows: 13,240
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-12-08 04:00:00 | SPY | ETF | 207.96 | 207.96 | 207.64 | 207.71 | 8418.0 |
| 2015-12-08 04:30:00 | SPY | ETF | 207.74 | 207.74 | 207.29 | 207.6 | 6109.0 |
| 2015-12-08 05:00:00 | SPY | ETF | 207.58 | 207.91 | 207.58 | 207.91 | 13107.0 |
| 2015-12-08 05:30:00 | SPY | ETF | 207.89 | 207.94 | 207.78 | 207.87 | 4904.0 |
| 2015-12-08 06:00:00 | SPY | ETF | 207.78 | 207.83 | 207.57 | 207.57 | 15588.0 |
| 2015-12-08 06:30:00 | SPY | ETF | 207.63 | 207.64 | 207.3 | 207.38 | 68014.0 |
| 2015-12-08 07:00:00 | SPY | ETF | 207.37 | 207.51 | 206.78 | 206.92 | 273378.0 |
| 2015-12-08 07:30:00 | SPY | ETF | 206.89 | 207.06 | 206.66 | 206.67 | 246771.0 |
| 2015-12-08 08:00:00 | SPY | ETF | 206.67 | 208.14 | 206.46 | 206.51 | 748893.0 |
| 2015-12-08 08:30:00 | SPY | ETF | 206.52 | 206.79 | 206.51 | 206.61 | 457011.0 |
| 2015-12-08 09:00:00 | SPY | ETF | 206.6 | 206.6 | 206.32 | 206.48 | 678164.0 |
| 2015-12-08 09:30:00 | SPY | ETF | 206.49 | 206.94 | 205.89 | 206.26 | 15577998.0 |
| 2015-12-08 10:00:00 | SPY | ETF | 206.251 | 206.83 | 205.86 | 205.98 | 11732090.0 |
| 2015-12-08 10:30:00 | SPY | ETF | 205.97 | 207.265 | 205.78 | 207.21 | 9616361.0 |
| 2015-12-08 11:00:00 | SPY | ETF | 207.215 | 208.289 | 207.21 | 207.22 | 10502248.0 |
| 2015-12-08 11:30:00 | SPY | ETF | 207.22 | 207.29 | 206.78 | 207.175 | 5542100.0 |
| 2015-12-08 12:00:00 | SPY | ETF | 207.17 | 207.18 | 206.59 | 206.85 | 3412827.0 |
| 2015-12-08 12:30:00 | SPY | ETF | 206.84 | 207.06 | 206.65 | 207.035 | 3755689.0 |
| 2015-12-08 13:00:00 | SPY | ETF | 207.045 | 207.165 | 206.48 | 206.745 | 3975551.0 |
| 2015-12-08 13:30:00 | SPY | ETF | 206.74 | 207.105 | 206.74 | 207.0762 | 3147701.0 |
| 2015-12-08 14:00:00 | SPY | ETF | 207.07 | 207.675 | 207.05 | 207.275 | 6079317.0 |
| 2015-12-08 14:30:00 | SPY | ETF | 207.29 | 207.47 | 207.07 | 207.1472 | 3568569.0 |
| 2015-12-08 15:00:00 | SPY | ETF | 207.14 | 207.23 | 206.67 | 206.7463 | 5209454.0 |
| 2015-12-08 15:30:00 | SPY | ETF | 206.75 | 208.289 | 206.58 | 206.96 | 12041138.0 |
| 2015-12-08 16:00:00 | SPY | ETF | 206.95 | 207.306 | 206.55 | 206.58 | 5055322.0 |
| 2015-12-08 16:30:00 | SPY | ETF | 206.59 | 206.95 | 206.58 | 206.76 | 262349.0 |
| 2015-12-08 17:00:00 | SPY | ETF | 206.77 | 208.289 | 206.68 | 206.69 | 554478.0 |
| 2015-12-08 17:30:00 | SPY | ETF | 206.69 | 206.74 | 206.65 | 206.69 | 11005.0 |
| 2015-12-08 18:00:00 | SPY | ETF | 206.69 | 206.99 | 206.6 | 206.76 | 59374.0 |
| 2015-12-08 18:30:00 | SPY | ETF | 206.74 | 207.04 | 206.74 | 207.03 | 60519.0 |
| 2015-12-08 19:00:00 | SPY | ETF | 207.0 | 207.08 | 206.93 | 207.08 | 69804.0 |
| 2015-12-08 19:30:00 | SPY | ETF | 207.07 | 207.25 | 207.07 | 207.2 | 82280.0 |
| 2015-12-08 04:00:00 | QQQ | ETF | 114.21 | 114.21 | 114.21 | 114.21 | 100.0 |
| 2015-12-08 04:30:00 | QQQ | ETF | 114.01 | 114.01 | 114.01 | 114.01 | 100.0 |
| 2015-12-08 05:30:00 | QQQ | ETF | 114.32 | 114.32 | 114.32 | 114.32 | 200.0 |
| 2015-12-08 06:30:00 | QQQ | ETF | 114.11 | 114.11 | 113.89 | 114.0 | 13764.0 |
| 2015-12-08 07:00:00 | QQQ | ETF | 113.99 | 113.99 | 113.65 | 113.69 | 19810.0 |
| 2015-12-08 07:30:00 | QQQ | ETF | 113.65 | 113.74 | 113.6 | 113.6 | 45159.0 |
| 2015-12-08 08:00:00 | QQQ | ETF | 113.58 | 113.81 | 113.48 | 113.5 | 151493.0 |
| 2015-12-08 08:30:00 | QQQ | ETF | 113.5 | 113.64 | 113.5 | 113.56 | 104313.0 |
| 2015-12-08 09:00:00 | QQQ | ETF | 113.54 | 113.54 | 113.38 | 113.42 | 175612.0 |
| 2015-12-08 09:30:00 | QQQ | ETF | 113.44 | 114.02 | 113.38 | 113.62 | 4650258.0 |
| 2015-12-08 10:00:00 | QQQ | ETF | 113.63 | 113.99 | 113.4 | 113.59 | 3039366.0 |
| 2015-12-08 10:30:00 | QQQ | ETF | 113.57 | 114.42 | 113.46 | 114.36 | 3626806.0 |
| 2015-12-08 11:00:00 | QQQ | ETF | 114.35 | 114.92 | 114.35 | 114.5 | 3538287.0 |
| 2015-12-08 11:30:00 | QQQ | ETF | 114.5 | 114.6 | 114.32 | 114.59 | 1541587.0 |
| 2015-12-08 12:00:00 | QQQ | ETF | 114.58 | 114.59 | 114.239 | 114.4 | 790566.0 |
| 2015-12-08 12:30:00 | QQQ | ETF | 114.39 | 114.57 | 114.28 | 114.56 | 860112.0 |
| 2015-12-08 13:00:00 | QQQ | ETF | 114.57 | 114.67 | 114.27 | 114.43 | 963733.0 |
| 2015-12-08 13:30:00 | QQQ | ETF | 114.43 | 114.64 | 114.43 | 114.62 | 994856.0 |
> showing 50 of 13,240 rows — these rows as CSV