PREVIEW / etf_30min / 2011-02-17
file: by_date/etf_30min/2011/2011-02-17.parquet size: 273 KB rows: 9,182
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-17 04:00:00 | SPY | ETF | 133.68 | 133.68 | 133.65 | 133.65 | 300.0 |
| 2011-02-17 04:30:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 1000.0 |
| 2011-02-17 05:00:00 | SPY | ETF | 133.62 | 133.64 | 133.62 | 133.63 | 700.0 |
| 2011-02-17 05:30:00 | SPY | ETF | 133.61 | 133.63 | 133.6 | 133.63 | 500.0 |
| 2011-02-17 06:30:00 | SPY | ETF | 133.57 | 133.59 | 133.55 | 133.55 | 500.0 |
| 2011-02-17 07:00:00 | SPY | ETF | 133.55 | 133.69 | 133.55 | 133.66 | 33500.0 |
| 2011-02-17 07:30:00 | SPY | ETF | 133.63 | 133.74 | 133.63 | 133.73 | 58975.0 |
| 2011-02-17 08:00:00 | SPY | ETF | 133.73 | 133.85 | 133.62 | 133.63 | 412817.0 |
| 2011-02-17 08:30:00 | SPY | ETF | 133.62 | 133.68 | 133.29 | 133.36 | 1819015.0 |
| 2011-02-17 09:00:00 | SPY | ETF | 133.37 | 133.53 | 133.36 | 133.45 | 1240881.0 |
| 2011-02-17 09:30:00 | SPY | ETF | 133.46 | 133.61 | 133.34 | 133.585 | 10075861.0 |
| 2011-02-17 10:00:00 | SPY | ETF | 133.5875 | 133.81 | 133.5 | 133.73 | 12534260.0 |
| 2011-02-17 10:30:00 | SPY | ETF | 133.735 | 133.81 | 133.6403 | 133.72 | 7011304.0 |
| 2011-02-17 11:00:00 | SPY | ETF | 133.72 | 134.09 | 133.69 | 134.07 | 11162678.0 |
| 2011-02-17 11:30:00 | SPY | ETF | 134.07 | 134.14 | 134.03 | 134.08 | 4844828.0 |
| 2011-02-17 12:00:00 | SPY | ETF | 134.0717 | 134.09 | 133.96 | 134.04 | 3786559.0 |
| 2011-02-17 12:30:00 | SPY | ETF | 134.04 | 134.11 | 134.02 | 134.02 | 3951517.0 |
| 2011-02-17 13:00:00 | SPY | ETF | 134.02 | 134.31 | 134.02 | 134.27 | 6835700.0 |
| 2011-02-17 13:30:00 | SPY | ETF | 134.26 | 134.32 | 134.21 | 134.27 | 4034818.0 |
| 2011-02-17 14:00:00 | SPY | ETF | 134.27 | 134.39 | 134.2 | 134.235 | 7952311.0 |
| 2011-02-17 14:30:00 | SPY | ETF | 134.2318 | 134.34 | 134.18 | 134.31 | 3717466.0 |
| 2011-02-17 15:00:00 | SPY | ETF | 134.31 | 134.43 | 134.26 | 134.36 | 6196592.0 |
| 2011-02-17 15:30:00 | SPY | ETF | 134.36 | 134.42 | 134.24 | 134.27 | 15119664.0 |
| 2011-02-17 16:00:00 | SPY | ETF | 134.27 | 134.3042 | 133.52 | 134.21 | 6247326.0 |
| 2011-02-17 16:30:00 | SPY | ETF | 134.21 | 134.23 | 133.892 | 134.2 | 1159010.0 |
| 2011-02-17 17:00:00 | SPY | ETF | 134.2 | 134.2 | 134.08 | 134.08 | 167993.0 |
| 2011-02-17 17:30:00 | SPY | ETF | 134.09 | 134.17 | 134.09 | 134.12 | 5789.0 |
| 2011-02-17 18:00:00 | SPY | ETF | 134.11 | 134.22 | 134.1 | 134.15 | 31978.0 |
| 2011-02-17 18:30:00 | SPY | ETF | 134.15 | 134.19 | 134.15 | 134.17 | 9310.0 |
| 2011-02-17 19:00:00 | SPY | ETF | 134.19 | 134.19 | 134.13 | 134.15 | 5194.0 |
| 2011-02-17 19:30:00 | SPY | ETF | 134.15 | 134.18 | 134.11 | 134.18 | 7994.0 |
| 2011-02-17 07:00:00 | QQQ | ETF | 58.71 | 58.74 | 58.71 | 58.71 | 33084.0 |
| 2011-02-17 07:30:00 | QQQ | ETF | 58.7 | 58.76 | 58.7 | 58.75 | 25757.0 |
| 2011-02-17 08:00:00 | QQQ | ETF | 58.76 | 58.77 | 58.71 | 58.73 | 868213.0 |
| 2011-02-17 08:30:00 | QQQ | ETF | 58.7 | 58.75 | 58.59 | 58.63 | 845137.0 |
| 2011-02-17 09:00:00 | QQQ | ETF | 58.62 | 58.68 | 58.59 | 58.59 | 1283827.0 |
| 2011-02-17 09:30:00 | QQQ | ETF | 58.59 | 58.77 | 58.55 | 58.75 | 5278285.0 |
| 2011-02-17 10:00:00 | QQQ | ETF | 58.76 | 58.86 | 58.69 | 58.77 | 4609749.0 |
| 2011-02-17 10:30:00 | QQQ | ETF | 58.78 | 58.81 | 58.66 | 58.7 | 1912177.0 |
| 2011-02-17 11:00:00 | QQQ | ETF | 58.6996 | 58.92 | 58.68 | 58.91 | 2740290.0 |
| 2011-02-17 11:30:00 | QQQ | ETF | 58.91 | 58.96 | 58.87 | 58.92 | 3421048.0 |
| 2011-02-17 12:00:00 | QQQ | ETF | 58.92 | 58.93 | 58.86 | 58.9 | 836018.0 |
| 2011-02-17 12:30:00 | QQQ | ETF | 58.8975 | 58.94 | 58.84 | 58.8501 | 951191.0 |
| 2011-02-17 13:00:00 | QQQ | ETF | 58.85 | 58.97 | 58.85 | 58.959 | 1759462.0 |
| 2011-02-17 13:30:00 | QQQ | ETF | 58.95 | 58.97 | 58.89 | 58.91 | 952574.0 |
| 2011-02-17 14:00:00 | QQQ | ETF | 58.91 | 58.975 | 58.87 | 58.88 | 1419265.0 |
| 2011-02-17 14:30:00 | QQQ | ETF | 58.88 | 58.92 | 58.86 | 58.9 | 1840580.0 |
| 2011-02-17 15:00:00 | QQQ | ETF | 58.9 | 58.94 | 58.88 | 58.9166 | 853505.0 |
| 2011-02-17 15:30:00 | QQQ | ETF | 58.92 | 58.92 | 58.82 | 58.87 | 3585296.0 |
| 2011-02-17 16:00:00 | QQQ | ETF | 58.861 | 58.9 | 58.79 | 58.82 | 1089870.0 |
> showing 50 of 9,182 rows — these rows as CSV