PREVIEW / etf_30min / 2006-03-14
file: by_date/etf_30min/2006/2006-03-14.parquet size: 62 KB rows: 2,176
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-14 07:00:00 | SPY | ETF | 129.29 | 129.29 | 128.55 | 128.58 | 36400.0 |
| 2006-03-14 07:30:00 | SPY | ETF | 128.6 | 128.66 | 128.6 | 128.63 | 19700.0 |
| 2006-03-14 08:00:00 | SPY | ETF | 128.63 | 128.8 | 128.53 | 128.8 | 989400.0 |
| 2006-03-14 08:30:00 | SPY | ETF | 128.78 | 128.82 | 128.7 | 128.73 | 409300.0 |
| 2006-03-14 09:00:00 | SPY | ETF | 128.73 | 128.77 | 128.71 | 128.71 | 183400.0 |
| 2006-03-14 09:30:00 | SPY | ETF | 128.71 | 129.23 | 128.61 | 129.21 | 7975600.0 |
| 2006-03-14 10:00:00 | SPY | ETF | 129.21 | 129.27 | 129.0 | 129.052 | 6561300.0 |
| 2006-03-14 10:30:00 | SPY | ETF | 129.06 | 129.14 | 128.92 | 129.06 | 3371400.0 |
| 2006-03-14 11:00:00 | SPY | ETF | 129.07 | 129.26 | 129.01 | 129.2 | 3778600.0 |
| 2006-03-14 11:30:00 | SPY | ETF | 129.18 | 129.48 | 129.16 | 129.38 | 4197600.0 |
| 2006-03-14 12:00:00 | SPY | ETF | 129.38 | 129.48 | 129.33 | 129.43 | 2211400.0 |
| 2006-03-14 12:30:00 | SPY | ETF | 129.43 | 129.44 | 129.25 | 129.39 | 1947600.0 |
| 2006-03-14 13:00:00 | SPY | ETF | 129.41 | 129.83 | 129.38 | 129.79 | 8227700.0 |
| 2006-03-14 13:30:00 | SPY | ETF | 129.79 | 129.88 | 129.72 | 129.79 | 4129600.0 |
| 2006-03-14 14:00:00 | SPY | ETF | 129.79 | 130.12 | 129.72 | 130.11 | 3785500.0 |
| 2006-03-14 14:30:00 | SPY | ETF | 130.11 | 130.12 | 129.98 | 130.08 | 3902300.0 |
| 2006-03-14 15:00:00 | SPY | ETF | 130.08 | 130.2 | 130.07 | 130.09 | 3111400.0 |
| 2006-03-14 15:30:00 | SPY | ETF | 130.08 | 130.23 | 130.08 | 130.12 | 5078900.0 |
| 2006-03-14 16:00:00 | SPY | ETF | 130.12 | 130.2 | 128.8903 | 130.2 | 5331500.0 |
| 2006-03-14 16:30:00 | SPY | ETF | 130.16 | 130.17 | 130.11 | 130.15 | 82500.0 |
| 2006-03-14 17:00:00 | SPY | ETF | 130.21 | 130.22 | 129.77 | 130.19 | 72200.0 |
| 2006-03-14 17:30:00 | SPY | ETF | 130.19 | 130.23 | 130.15 | 130.15 | 6800.0 |
| 2006-03-14 18:00:00 | SPY | ETF | 130.17 | 130.17 | 130.17 | 130.17 | 1000.0 |
| 2006-03-14 18:30:00 | SPY | ETF | 130.18 | 130.2 | 130.18 | 130.19 | 1300.0 |
| 2006-03-14 19:00:00 | SPY | ETF | 130.15 | 130.16 | 130.15 | 130.15 | 3600.0 |
| 2006-03-14 19:30:00 | SPY | ETF | 130.12 | 130.12 | 130.12 | 130.12 | 200.0 |
| 2006-03-14 09:30:00 | QQQ | ETF | 40.65 | 41.03 | 40.64 | 41.02 | 21879000.0 |
| 2006-03-14 10:00:00 | QQQ | ETF | 41.02 | 41.04 | 40.8 | 40.86 | 10065400.0 |
| 2006-03-14 10:30:00 | QQQ | ETF | 40.86 | 40.89 | 40.76 | 40.87 | 4612900.0 |
| 2006-03-14 11:00:00 | QQQ | ETF | 40.87 | 41.0 | 40.85 | 40.95 | 4334900.0 |
| 2006-03-14 11:30:00 | QQQ | ETF | 40.95 | 41.03 | 40.93 | 41.0 | 4914200.0 |
| 2006-03-14 12:00:00 | QQQ | ETF | 41.01 | 41.05 | 40.95 | 40.97 | 3294900.0 |
| 2006-03-14 12:30:00 | QQQ | ETF | 40.96 | 41.01 | 40.91 | 40.99 | 5257300.0 |
| 2006-03-14 13:00:00 | QQQ | ETF | 40.99 | 41.26 | 40.98 | 41.21 | 13256400.0 |
| 2006-03-14 13:30:00 | QQQ | ETF | 41.21 | 41.23 | 41.14 | 41.2 | 7558900.0 |
| 2006-03-14 14:00:00 | QQQ | ETF | 41.19 | 41.26 | 41.15 | 41.26 | 4143200.0 |
| 2006-03-14 14:30:00 | QQQ | ETF | 41.25 | 41.33 | 41.2 | 41.31 | 8834100.0 |
| 2006-03-14 15:00:00 | QQQ | ETF | 41.31 | 41.36 | 41.28 | 41.31 | 5874900.0 |
| 2006-03-14 15:30:00 | QQQ | ETF | 41.31 | 41.42 | 41.3 | 41.36 | 11686900.0 |
| 2006-03-14 08:00:00 | IWM | ETF | 72.3 | 72.39 | 72.21 | 72.3 | 473300.0 |
| 2006-03-14 08:30:00 | IWM | ETF | 72.3 | 72.36 | 72.24 | 72.25 | 142400.0 |
| 2006-03-14 09:00:00 | IWM | ETF | 72.25 | 72.31 | 72.25 | 72.28 | 49700.0 |
| 2006-03-14 09:30:00 | IWM | ETF | 72.28 | 72.56 | 72.02 | 72.48 | 7569800.0 |
| 2006-03-14 10:00:00 | IWM | ETF | 72.48 | 72.5 | 72.25 | 72.35 | 3358700.0 |
| 2006-03-14 10:30:00 | IWM | ETF | 72.34 | 72.52 | 72.01 | 72.26 | 3025500.0 |
| 2006-03-14 11:00:00 | IWM | ETF | 72.25 | 72.7 | 72.22 | 72.66 | 3050800.0 |
| 2006-03-14 11:30:00 | IWM | ETF | 72.66 | 72.87 | 72.66 | 72.85 | 2550300.0 |
| 2006-03-14 12:00:00 | IWM | ETF | 72.86 | 72.93 | 72.79 | 72.88 | 1248000.0 |
| 2006-03-14 12:30:00 | IWM | ETF | 72.88 | 72.9 | 72.73 | 72.85 | 807600.0 |
| 2006-03-14 13:00:00 | IWM | ETF | 72.85 | 73.15 | 72.85 | 73.09 | 2614900.0 |
> showing 50 of 2,176 rows — these rows as CSV