PREVIEW / etf_30min / 2010-05-11
file: by_date/etf_30min/2010/2010-05-11.parquet size: 276 KB rows: 9,120
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-11 04:00:00 | SPY | ETF | 115.28 | 115.31 | 114.99 | 114.99 | 11386.0 |
| 2010-05-11 04:30:00 | SPY | ETF | 115.12 | 115.12 | 114.68 | 114.71 | 5350.0 |
| 2010-05-11 05:00:00 | SPY | ETF | 114.76 | 114.98 | 114.71 | 114.93 | 31600.0 |
| 2010-05-11 05:30:00 | SPY | ETF | 114.93 | 114.98 | 114.83 | 114.95 | 22700.0 |
| 2010-05-11 06:00:00 | SPY | ETF | 114.92 | 115.1 | 114.88 | 115.0 | 29300.0 |
| 2010-05-11 06:30:00 | SPY | ETF | 114.95 | 115.02 | 114.7 | 114.76 | 103200.0 |
| 2010-05-11 07:00:00 | SPY | ETF | 114.72 | 114.91 | 114.53 | 114.9 | 672388.0 |
| 2010-05-11 07:30:00 | SPY | ETF | 114.93 | 115.17 | 114.83 | 114.94 | 718191.0 |
| 2010-05-11 08:00:00 | SPY | ETF | 114.97 | 116.14 | 114.6 | 114.86 | 1586461.0 |
| 2010-05-11 08:30:00 | SPY | ETF | 114.87 | 115.02 | 114.75 | 114.76 | 831289.0 |
| 2010-05-11 09:00:00 | SPY | ETF | 114.77 | 115.16 | 114.71 | 115.07 | 2648354.0 |
| 2010-05-11 09:30:00 | SPY | ETF | 115.07 | 115.79 | 114.91 | 115.57 | 39133027.0 |
| 2010-05-11 10:00:00 | SPY | ETF | 115.57 | 115.93 | 115.38 | 115.69 | 20170987.0 |
| 2010-05-11 10:30:00 | SPY | ETF | 115.69 | 115.93 | 115.49 | 115.671 | 15392167.0 |
| 2010-05-11 11:00:00 | SPY | ETF | 115.67 | 116.24 | 115.6086 | 116.2 | 15838907.0 |
| 2010-05-11 11:30:00 | SPY | ETF | 116.2 | 116.62 | 115.5 | 116.42 | 20067354.0 |
| 2010-05-11 12:00:00 | SPY | ETF | 116.43 | 116.85 | 116.2 | 116.68 | 13930016.0 |
| 2010-05-11 12:30:00 | SPY | ETF | 116.67 | 117.09 | 116.56 | 116.99 | 16314324.0 |
| 2010-05-11 13:00:00 | SPY | ETF | 117.0 | 117.04 | 116.71 | 116.908 | 9937187.0 |
| 2010-05-11 13:30:00 | SPY | ETF | 116.89 | 117.36 | 116.77 | 117.03 | 18158999.0 |
| 2010-05-11 14:00:00 | SPY | ETF | 117.04 | 117.1 | 116.28 | 116.458 | 25101063.0 |
| 2010-05-11 14:30:00 | SPY | ETF | 116.4601 | 116.51 | 116.0 | 116.19 | 24248992.0 |
| 2010-05-11 15:00:00 | SPY | ETF | 116.195 | 116.2 | 115.58 | 115.97 | 28635841.0 |
| 2010-05-11 15:30:00 | SPY | ETF | 115.97 | 116.32 | 115.78 | 115.83 | 32609252.0 |
| 2010-05-11 16:00:00 | SPY | ETF | 115.82 | 117.0 | 115.53 | 115.64 | 17831146.0 |
| 2010-05-11 16:30:00 | SPY | ETF | 115.63 | 116.2 | 115.5 | 115.52 | 6701667.0 |
| 2010-05-11 17:00:00 | SPY | ETF | 115.51 | 115.83 | 115.5 | 115.52 | 2133488.0 |
| 2010-05-11 17:30:00 | SPY | ETF | 115.5 | 115.6 | 115.5 | 115.53 | 42415.0 |
| 2010-05-11 18:00:00 | SPY | ETF | 115.53 | 115.83 | 114.76 | 115.0 | 3209110.0 |
| 2010-05-11 18:30:00 | SPY | ETF | 115.03 | 115.18 | 114.94 | 115.12 | 140453.0 |
| 2010-05-11 19:00:00 | SPY | ETF | 115.12 | 115.18 | 115.06 | 115.13 | 47716.0 |
| 2010-05-11 19:30:00 | SPY | ETF | 115.15 | 115.3 | 115.06 | 115.3 | 246483.0 |
| 2010-05-11 04:00:00 | QQQ | ETF | 47.47 | 47.47 | 47.47 | 47.47 | 1444.0 |
| 2010-05-11 04:30:00 | QQQ | ETF | 47.34 | 47.34 | 47.25 | 47.25 | 646.0 |
| 2010-05-11 05:00:00 | QQQ | ETF | 47.25 | 47.3 | 47.25 | 47.3 | 31500.0 |
| 2010-05-11 05:30:00 | QQQ | ETF | 47.29 | 47.33 | 47.25 | 47.33 | 9100.0 |
| 2010-05-11 06:00:00 | QQQ | ETF | 47.36 | 47.38 | 47.35 | 47.36 | 23879.0 |
| 2010-05-11 06:30:00 | QQQ | ETF | 47.34 | 47.34 | 47.25 | 47.28 | 5178.0 |
| 2010-05-11 07:00:00 | QQQ | ETF | 47.27 | 47.34 | 47.17 | 47.31 | 178804.0 |
| 2010-05-11 07:30:00 | QQQ | ETF | 47.33 | 47.43 | 47.31 | 47.34 | 313052.0 |
| 2010-05-11 08:00:00 | QQQ | ETF | 47.32 | 47.79 | 47.26 | 47.32 | 447988.0 |
| 2010-05-11 08:30:00 | QQQ | ETF | 47.33 | 47.38 | 47.23 | 47.27 | 525175.0 |
| 2010-05-11 09:00:00 | QQQ | ETF | 47.27 | 47.38 | 47.25 | 47.31 | 599271.0 |
| 2010-05-11 09:30:00 | QQQ | ETF | 47.31 | 47.68 | 47.2 | 47.5 | 15798697.0 |
| 2010-05-11 10:00:00 | QQQ | ETF | 47.5 | 47.66 | 47.42 | 47.59 | 6050770.0 |
| 2010-05-11 10:30:00 | QQQ | ETF | 47.59 | 47.75 | 47.45 | 47.63 | 7341964.0 |
| 2010-05-11 11:00:00 | QQQ | ETF | 47.63 | 47.94 | 47.61 | 47.925 | 5439523.0 |
| 2010-05-11 11:30:00 | QQQ | ETF | 47.93 | 48.12 | 47.841 | 48.04 | 7405923.0 |
| 2010-05-11 12:00:00 | QQQ | ETF | 48.04 | 48.245 | 48.0172 | 48.16 | 6288028.0 |
| 2010-05-11 12:30:00 | QQQ | ETF | 48.165 | 48.3 | 48.11 | 48.24 | 5476523.0 |
> showing 50 of 9,120 rows — these rows as CSV