PREVIEW / etf_30min / 2011-12-15
file: by_date/etf_30min/2011/2011-12-15.parquet size: 280 KB rows: 9,579
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-15 04:00:00 | SPY | ETF | 122.02 | 122.53 | 122.02 | 122.2 | 11538.0 |
| 2011-12-15 04:30:00 | SPY | ETF | 122.06 | 122.06 | 121.81 | 122.0 | 5872.0 |
| 2011-12-15 05:00:00 | SPY | ETF | 122.06 | 122.14 | 122.06 | 122.14 | 5900.0 |
| 2011-12-15 05:30:00 | SPY | ETF | 122.16 | 122.41 | 122.16 | 122.34 | 5500.0 |
| 2011-12-15 06:00:00 | SPY | ETF | 122.47 | 122.49 | 122.29 | 122.29 | 9300.0 |
| 2011-12-15 06:30:00 | SPY | ETF | 122.34 | 122.35 | 122.21 | 122.23 | 89600.0 |
| 2011-12-15 07:00:00 | SPY | ETF | 122.23 | 122.67 | 122.21 | 122.59 | 236677.0 |
| 2011-12-15 07:30:00 | SPY | ETF | 122.62 | 122.7 | 122.4 | 122.62 | 408167.0 |
| 2011-12-15 08:00:00 | SPY | ETF | 122.62 | 122.81 | 122.24 | 122.75 | 1876861.0 |
| 2011-12-15 08:30:00 | SPY | ETF | 122.78 | 123.25 | 122.73 | 123.16 | 2940061.0 |
| 2011-12-15 09:00:00 | SPY | ETF | 123.17 | 123.25 | 122.98 | 123.03 | 2172796.0 |
| 2011-12-15 09:30:00 | SPY | ETF | 123.03 | 123.14 | 122.79 | 122.96 | 16931840.0 |
| 2011-12-15 10:00:00 | SPY | ETF | 122.95 | 123.2 | 122.45 | 122.56 | 14248911.0 |
| 2011-12-15 10:30:00 | SPY | ETF | 122.56 | 122.58 | 121.99 | 122.2 | 17137179.0 |
| 2011-12-15 11:00:00 | SPY | ETF | 122.21 | 122.61 | 122.14 | 122.54 | 11012966.0 |
| 2011-12-15 11:30:00 | SPY | ETF | 122.54 | 122.64 | 122.15 | 122.31 | 7642157.0 |
| 2011-12-15 12:00:00 | SPY | ETF | 122.31 | 122.78 | 122.3 | 122.7 | 8174925.0 |
| 2011-12-15 12:30:00 | SPY | ETF | 122.71 | 122.77 | 122.39 | 122.48 | 8308173.0 |
| 2011-12-15 13:00:00 | SPY | ETF | 122.47 | 122.61 | 122.41 | 122.47 | 6323491.0 |
| 2011-12-15 13:30:00 | SPY | ETF | 122.47 | 122.66 | 122.19 | 122.4 | 14465241.0 |
| 2011-12-15 14:00:00 | SPY | ETF | 122.39 | 122.57 | 122.3 | 122.31 | 5535039.0 |
| 2011-12-15 14:30:00 | SPY | ETF | 122.31 | 122.35 | 122.07 | 122.18 | 8032443.0 |
| 2011-12-15 15:00:00 | SPY | ETF | 122.18 | 122.55 | 122.15 | 122.38 | 15607246.0 |
| 2011-12-15 15:30:00 | SPY | ETF | 122.38 | 122.54 | 122.02 | 122.189 | 28612028.0 |
| 2011-12-15 16:00:00 | SPY | ETF | 122.17 | 122.9 | 121.7652 | 122.38 | 13465093.0 |
| 2011-12-15 16:30:00 | SPY | ETF | 122.39 | 122.43 | 122.28 | 122.34 | 3794097.0 |
| 2011-12-15 17:00:00 | SPY | ETF | 122.36 | 122.41 | 122.31 | 122.41 | 1219590.0 |
| 2011-12-15 17:30:00 | SPY | ETF | 122.5 | 122.53 | 122.1568 | 122.47 | 1505714.0 |
| 2011-12-15 18:00:00 | SPY | ETF | 122.47 | 122.55 | 122.15 | 122.46 | 329451.0 |
| 2011-12-15 18:30:00 | SPY | ETF | 122.48 | 122.65 | 122.45 | 122.6 | 65710.0 |
| 2011-12-15 19:00:00 | SPY | ETF | 122.63 | 122.71 | 122.58 | 122.65 | 107414.0 |
| 2011-12-15 19:30:00 | SPY | ETF | 122.68 | 122.69 | 122.6 | 122.6 | 67709.0 |
| 2011-12-15 05:30:00 | QQQ | ETF | 55.08 | 55.15 | 55.08 | 55.15 | 5200.0 |
| 2011-12-15 06:00:00 | QQQ | ETF | 55.15 | 55.15 | 55.08 | 55.11 | 1400.0 |
| 2011-12-15 06:30:00 | QQQ | ETF | 55.03 | 55.05 | 55.02 | 55.02 | 800.0 |
| 2011-12-15 07:00:00 | QQQ | ETF | 55.08 | 55.29 | 55.04 | 55.25 | 93024.0 |
| 2011-12-15 07:30:00 | QQQ | ETF | 55.29 | 55.3 | 55.2 | 55.28 | 39290.0 |
| 2011-12-15 08:00:00 | QQQ | ETF | 55.27 | 55.34 | 55.25 | 55.33 | 421147.0 |
| 2011-12-15 08:30:00 | QQQ | ETF | 55.33 | 55.47 | 55.33 | 55.44 | 430483.0 |
| 2011-12-15 09:00:00 | QQQ | ETF | 55.43 | 55.46 | 55.32 | 55.39 | 312505.0 |
| 2011-12-15 09:30:00 | QQQ | ETF | 55.36 | 55.42 | 55.13 | 55.17 | 4172196.0 |
| 2011-12-15 10:00:00 | QQQ | ETF | 55.16 | 55.26 | 54.95 | 54.97 | 6145251.0 |
| 2011-12-15 10:30:00 | QQQ | ETF | 54.96 | 54.97 | 54.72 | 54.78 | 6692522.0 |
| 2011-12-15 11:00:00 | QQQ | ETF | 54.789 | 54.9 | 54.69 | 54.87 | 4192402.0 |
| 2011-12-15 11:30:00 | QQQ | ETF | 54.87 | 54.92 | 54.66 | 54.71 | 3783499.0 |
| 2011-12-15 12:00:00 | QQQ | ETF | 54.7081 | 54.945 | 54.7075 | 54.922 | 2617298.0 |
| 2011-12-15 12:30:00 | QQQ | ETF | 54.93 | 54.99 | 54.85 | 54.88 | 1778011.0 |
| 2011-12-15 13:00:00 | QQQ | ETF | 54.88 | 54.96 | 54.86 | 54.91 | 1180090.0 |
| 2011-12-15 13:30:00 | QQQ | ETF | 54.91 | 54.99 | 54.79 | 54.88 | 2705519.0 |
| 2011-12-15 14:00:00 | QQQ | ETF | 54.89 | 54.97 | 54.84 | 54.85 | 1503966.0 |
> showing 50 of 9,579 rows — these rows as CSV