PREVIEW / etf_30min / 2011-02-28
file: by_date/etf_30min/2011/2011-02-28.parquet size: 285 KB rows: 9,493
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-02-28 04:00:00 | SPY | ETF | 132.02 | 132.18 | 132.02 | 132.18 | 6300.0 |
| 2011-02-28 04:30:00 | SPY | ETF | 132.15 | 132.15 | 131.98 | 132.0 | 1850.0 |
| 2011-02-28 05:00:00 | SPY | ETF | 132.15 | 132.15 | 132.15 | 132.15 | 200.0 |
| 2011-02-28 05:30:00 | SPY | ETF | 132.05 | 132.05 | 132.05 | 132.05 | 400.0 |
| 2011-02-28 06:00:00 | SPY | ETF | 131.97 | 132.19 | 131.97 | 132.19 | 5300.0 |
| 2011-02-28 06:30:00 | SPY | ETF | 132.22 | 132.29 | 132.22 | 132.27 | 41250.0 |
| 2011-02-28 07:00:00 | SPY | ETF | 132.25 | 132.53 | 132.25 | 132.53 | 417702.0 |
| 2011-02-28 07:30:00 | SPY | ETF | 132.57 | 133.0 | 132.57 | 132.91 | 527084.0 |
| 2011-02-28 08:00:00 | SPY | ETF | 132.89 | 133.05 | 131.09 | 132.96 | 994151.0 |
| 2011-02-28 08:30:00 | SPY | ETF | 132.97 | 132.99 | 132.8 | 132.87 | 1208354.0 |
| 2011-02-28 09:00:00 | SPY | ETF | 132.89 | 132.91 | 132.75 | 132.82 | 789287.0 |
| 2011-02-28 09:30:00 | SPY | ETF | 132.82 | 133.19 | 132.73 | 133.03 | 17776688.0 |
| 2011-02-28 10:00:00 | SPY | ETF | 133.03 | 133.32 | 132.95 | 133.17 | 10880956.0 |
| 2011-02-28 10:30:00 | SPY | ETF | 133.18 | 133.28 | 133.05 | 133.2 | 6603535.0 |
| 2011-02-28 11:00:00 | SPY | ETF | 133.2 | 133.23 | 132.91 | 132.91 | 6460768.0 |
| 2011-02-28 11:30:00 | SPY | ETF | 132.92 | 132.99 | 132.8 | 132.89 | 7115719.0 |
| 2011-02-28 12:00:00 | SPY | ETF | 132.89 | 132.96 | 132.81 | 132.95 | 3479066.0 |
| 2011-02-28 12:30:00 | SPY | ETF | 132.94 | 133.04 | 132.621 | 132.6601 | 5966975.0 |
| 2011-02-28 13:00:00 | SPY | ETF | 132.66 | 132.69 | 132.41 | 132.49 | 6998851.0 |
| 2011-02-28 13:30:00 | SPY | ETF | 132.48 | 132.65 | 132.45 | 132.46 | 5316525.0 |
| 2011-02-28 14:00:00 | SPY | ETF | 132.46 | 132.74 | 132.38 | 132.72 | 6320057.0 |
| 2011-02-28 14:30:00 | SPY | ETF | 132.73 | 132.86 | 132.66 | 132.86 | 6221268.0 |
| 2011-02-28 15:00:00 | SPY | ETF | 132.85 | 132.9 | 132.67 | 132.895 | 8045902.0 |
| 2011-02-28 15:30:00 | SPY | ETF | 132.9 | 133.16 | 132.85 | 133.14 | 22438059.0 |
| 2011-02-28 16:00:00 | SPY | ETF | 133.14 | 133.32 | 132.9114 | 133.1 | 18259021.0 |
| 2011-02-28 16:30:00 | SPY | ETF | 133.1 | 133.17 | 133.04 | 133.07 | 1057331.0 |
| 2011-02-28 17:00:00 | SPY | ETF | 133.08 | 133.12 | 132.3283 | 133.08 | 1677880.0 |
| 2011-02-28 17:30:00 | SPY | ETF | 133.08 | 133.13 | 133.08 | 133.11 | 31570.0 |
| 2011-02-28 18:00:00 | SPY | ETF | 133.11 | 133.21 | 133.09 | 133.19 | 112647.0 |
| 2011-02-28 18:30:00 | SPY | ETF | 133.22 | 133.24 | 133.08 | 133.24 | 63165.0 |
| 2011-02-28 19:00:00 | SPY | ETF | 133.26 | 133.3 | 133.26 | 133.27 | 53850.0 |
| 2011-02-28 19:30:00 | SPY | ETF | 133.27 | 133.39 | 133.27 | 133.37 | 66072.0 |
| 2011-02-28 04:00:00 | QQQ | ETF | 57.54 | 57.55 | 57.54 | 57.55 | 2100.0 |
| 2011-02-28 05:30:00 | QQQ | ETF | 57.55 | 57.55 | 57.55 | 57.55 | 200.0 |
| 2011-02-28 06:00:00 | QQQ | ETF | 57.58 | 57.61 | 57.57 | 57.61 | 10200.0 |
| 2011-02-28 06:30:00 | QQQ | ETF | 57.66 | 57.69 | 57.66 | 57.69 | 300.0 |
| 2011-02-28 07:00:00 | QQQ | ETF | 57.69 | 57.77 | 57.66 | 57.71 | 115732.0 |
| 2011-02-28 07:30:00 | QQQ | ETF | 57.81 | 57.92 | 57.76 | 57.88 | 65708.0 |
| 2011-02-28 08:00:00 | QQQ | ETF | 57.9 | 57.96 | 57.86 | 57.93 | 191019.0 |
| 2011-02-28 08:30:00 | QQQ | ETF | 57.93 | 57.93 | 57.83 | 57.85 | 380489.0 |
| 2011-02-28 09:00:00 | QQQ | ETF | 57.87 | 57.89 | 57.81 | 57.88 | 389171.0 |
| 2011-02-28 09:30:00 | QQQ | ETF | 57.88 | 58.05 | 57.82 | 57.95 | 5882630.0 |
| 2011-02-28 10:00:00 | QQQ | ETF | 57.96 | 58.03 | 57.86 | 57.995 | 4155143.0 |
| 2011-02-28 10:30:00 | QQQ | ETF | 57.985 | 58.03 | 57.86 | 57.949 | 3255285.0 |
| 2011-02-28 11:00:00 | QQQ | ETF | 57.95 | 57.96 | 57.79 | 57.79 | 2322486.0 |
| 2011-02-28 11:30:00 | QQQ | ETF | 57.79 | 57.81 | 57.7 | 57.77 | 2674346.0 |
| 2011-02-28 12:00:00 | QQQ | ETF | 57.77 | 57.8 | 57.73 | 57.7419 | 1173849.0 |
| 2011-02-28 12:30:00 | QQQ | ETF | 57.75 | 57.81 | 57.54 | 57.565 | 3096314.0 |
| 2011-02-28 13:00:00 | QQQ | ETF | 57.57 | 57.57 | 57.45 | 57.49 | 4193890.0 |
| 2011-02-28 13:30:00 | QQQ | ETF | 57.49 | 57.59 | 57.46 | 57.48 | 2828123.0 |
> showing 50 of 9,493 rows — these rows as CSV