PREVIEW / etf_30min / 2016-03-30
file: by_date/etf_30min/2016/2016-03-30.parquet size: 394 KB rows: 13,453
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-03-30 04:00:00 | SPY | ETF | 205.92 | 206.3 | 205.92 | 206.17 | 42497.0 |
| 2016-03-30 04:30:00 | SPY | ETF | 206.17 | 206.22 | 206.12 | 206.17 | 20897.0 |
| 2016-03-30 05:00:00 | SPY | ETF | 206.14 | 206.3 | 206.13 | 206.3 | 38985.0 |
| 2016-03-30 05:30:00 | SPY | ETF | 206.31 | 206.31 | 206.14 | 206.24 | 7016.0 |
| 2016-03-30 06:00:00 | SPY | ETF | 206.25 | 206.5 | 206.25 | 206.5 | 91751.0 |
| 2016-03-30 06:30:00 | SPY | ETF | 206.46 | 206.57 | 206.31 | 206.33 | 85809.0 |
| 2016-03-30 07:00:00 | SPY | ETF | 206.38 | 206.46 | 206.25 | 206.41 | 53251.0 |
| 2016-03-30 07:30:00 | SPY | ETF | 206.41 | 206.45 | 206.31 | 206.31 | 282209.0 |
| 2016-03-30 08:00:00 | SPY | ETF | 206.31 | 206.43 | 205.34 | 206.1 | 523206.0 |
| 2016-03-30 08:30:00 | SPY | ETF | 206.12 | 206.38 | 206.07 | 206.38 | 312058.0 |
| 2016-03-30 09:00:00 | SPY | ETF | 206.38 | 206.4 | 206.18 | 206.3 | 802160.0 |
| 2016-03-30 09:30:00 | SPY | ETF | 206.3 | 206.78 | 206.07 | 206.545 | 12629087.0 |
| 2016-03-30 10:00:00 | SPY | ETF | 206.545 | 206.6 | 206.34 | 206.36 | 5576286.0 |
| 2016-03-30 10:30:00 | SPY | ETF | 206.36 | 206.78 | 206.36 | 206.63 | 7249383.0 |
| 2016-03-30 11:00:00 | SPY | ETF | 206.63 | 206.87 | 206.18 | 206.22 | 6138560.0 |
| 2016-03-30 11:30:00 | SPY | ETF | 206.22 | 206.22 | 205.9 | 206.18 | 6211523.0 |
| 2016-03-30 12:00:00 | SPY | ETF | 206.19 | 206.31 | 205.95 | 206.01 | 2926254.0 |
| 2016-03-30 12:30:00 | SPY | ETF | 206.01 | 206.14 | 205.79 | 205.92 | 3351528.0 |
| 2016-03-30 13:00:00 | SPY | ETF | 205.92 | 205.99 | 205.68 | 205.74 | 3908312.0 |
| 2016-03-30 13:30:00 | SPY | ETF | 205.74 | 206.1 | 205.59 | 205.98 | 3494844.0 |
| 2016-03-30 14:00:00 | SPY | ETF | 205.98 | 206.22 | 205.92 | 206.18 | 3739890.0 |
| 2016-03-30 14:30:00 | SPY | ETF | 206.185 | 206.29 | 205.96 | 206.2 | 5380220.0 |
| 2016-03-30 15:00:00 | SPY | ETF | 206.2 | 206.49 | 206.17 | 206.4301 | 5707860.0 |
| 2016-03-30 15:30:00 | SPY | ETF | 206.435 | 206.46 | 205.93 | 206.07 | 9727934.0 |
| 2016-03-30 16:00:00 | SPY | ETF | 206.08 | 206.3701 | 205.1115 | 205.98 | 3784096.0 |
| 2016-03-30 16:30:00 | SPY | ETF | 205.97 | 206.08 | 205.95 | 206.02 | 446949.0 |
| 2016-03-30 17:00:00 | SPY | ETF | 206.02 | 206.06 | 205.96 | 205.96 | 52817.0 |
| 2016-03-30 17:30:00 | SPY | ETF | 205.98 | 206.02 | 205.92 | 205.97 | 2543342.0 |
| 2016-03-30 18:00:00 | SPY | ETF | 205.96 | 206.04 | 205.92 | 205.93 | 38159.0 |
| 2016-03-30 18:30:00 | SPY | ETF | 205.93 | 205.93 | 205.87 | 205.9 | 26118.0 |
| 2016-03-30 19:00:00 | SPY | ETF | 205.92 | 205.94 | 205.83 | 205.87 | 62817.0 |
| 2016-03-30 19:30:00 | SPY | ETF | 205.88 | 205.92 | 205.86 | 205.88 | 28552.0 |
| 2016-03-30 20:00:00 | SPY | ETF | 206.02 | 206.02 | 206.02 | 206.02 | 146.0 |
| 2016-03-30 04:00:00 | QQQ | ETF | 109.27 | 109.39 | 109.27 | 109.37 | 579.0 |
| 2016-03-30 05:00:00 | QQQ | ETF | 109.38 | 109.4 | 109.38 | 109.4 | 843.0 |
| 2016-03-30 06:00:00 | QQQ | ETF | 109.42 | 109.6 | 109.42 | 109.6 | 22595.0 |
| 2016-03-30 06:30:00 | QQQ | ETF | 109.59 | 109.65 | 109.52 | 109.52 | 7499.0 |
| 2016-03-30 07:00:00 | QQQ | ETF | 109.54 | 109.57 | 109.51 | 109.57 | 16178.0 |
| 2016-03-30 07:30:00 | QQQ | ETF | 109.59 | 109.62 | 109.55 | 109.55 | 31582.0 |
| 2016-03-30 08:00:00 | QQQ | ETF | 109.52 | 109.6 | 109.44 | 109.44 | 46746.0 |
| 2016-03-30 08:30:00 | QQQ | ETF | 109.44 | 109.52 | 109.42 | 109.52 | 42848.0 |
| 2016-03-30 09:00:00 | QQQ | ETF | 109.52 | 109.52 | 109.4 | 109.48 | 415332.0 |
| 2016-03-30 09:30:00 | QQQ | ETF | 109.48 | 110.0 | 109.34 | 109.91 | 4183177.0 |
| 2016-03-30 10:00:00 | QQQ | ETF | 109.92 | 110.04 | 109.84 | 109.85 | 1854128.0 |
| 2016-03-30 10:30:00 | QQQ | ETF | 109.85 | 109.98 | 109.76 | 109.86 | 1797970.0 |
| 2016-03-30 11:00:00 | QQQ | ETF | 109.86 | 109.96 | 109.35 | 109.38 | 1893187.0 |
| 2016-03-30 11:30:00 | QQQ | ETF | 109.38 | 109.41 | 109.181 | 109.39 | 1906036.0 |
| 2016-03-30 12:00:00 | QQQ | ETF | 109.39 | 109.4478 | 109.15 | 109.245 | 1248413.0 |
| 2016-03-30 12:30:00 | QQQ | ETF | 109.25 | 109.31 | 109.14 | 109.26 | 646314.0 |
| 2016-03-30 13:00:00 | QQQ | ETF | 109.25 | 109.33 | 109.18 | 109.2 | 885257.0 |
> showing 50 of 13,453 rows — these rows as CSV