PREVIEW / etf_30min / 2004-12-21
file: by_date/etf_30min/2004/2004-12-21.parquet size: 41 KB rows: 1,358
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-21 08:00:00 | SPY | ETF | 119.51 | 119.55 | 119.51 | 119.55 | 3200.0 |
| 2004-12-21 08:30:00 | SPY | ETF | 119.62 | 119.65 | 119.59 | 119.59 | 107800.0 |
| 2004-12-21 09:00:00 | SPY | ETF | 119.6 | 119.65 | 119.56 | 119.58 | 66400.0 |
| 2004-12-21 09:30:00 | SPY | ETF | 119.6 | 119.89 | 119.57 | 119.67 | 5235700.0 |
| 2004-12-21 10:00:00 | SPY | ETF | 119.66 | 119.74 | 119.56 | 119.69 | 2563300.0 |
| 2004-12-21 10:30:00 | SPY | ETF | 119.68 | 119.69 | 119.46 | 119.55 | 2519700.0 |
| 2004-12-21 11:00:00 | SPY | ETF | 119.56 | 119.77 | 119.51 | 119.71 | 1734600.0 |
| 2004-12-21 11:30:00 | SPY | ETF | 119.69 | 119.97 | 119.66 | 119.91 | 4215800.0 |
| 2004-12-21 12:00:00 | SPY | ETF | 119.92 | 120.0 | 119.84 | 119.92 | 1406000.0 |
| 2004-12-21 12:30:00 | SPY | ETF | 119.9 | 120.11 | 119.85 | 120.08 | 1686700.0 |
| 2004-12-21 13:00:00 | SPY | ETF | 120.08 | 120.17 | 119.99 | 120.03 | 1184400.0 |
| 2004-12-21 13:30:00 | SPY | ETF | 120.04 | 120.12 | 119.97 | 120.08 | 949000.0 |
| 2004-12-21 14:00:00 | SPY | ETF | 120.08 | 120.33 | 120.06 | 120.32 | 1806300.0 |
| 2004-12-21 14:30:00 | SPY | ETF | 120.31 | 120.48 | 120.25 | 120.42 | 2453900.0 |
| 2004-12-21 15:00:00 | SPY | ETF | 120.44 | 120.47 | 120.25 | 120.27 | 2310400.0 |
| 2004-12-21 15:30:00 | SPY | ETF | 120.26 | 120.46 | 120.15 | 120.4 | 2714800.0 |
| 2004-12-21 16:00:00 | SPY | ETF | 120.41 | 120.46 | 120.31 | 120.37 | 1549600.0 |
| 2004-12-21 16:30:00 | SPY | ETF | 120.37 | 120.38 | 120.34 | 120.37 | 72200.0 |
| 2004-12-21 17:00:00 | SPY | ETF | 120.37 | 120.4 | 120.35 | 120.38 | 103100.0 |
| 2004-12-21 17:30:00 | SPY | ETF | 120.4 | 120.4 | 120.4 | 120.4 | 100.0 |
| 2004-12-21 18:00:00 | SPY | ETF | 120.39 | 120.39 | 120.39 | 120.39 | 200.0 |
| 2004-12-21 18:30:00 | SPY | ETF | 120.45 | 120.45 | 120.45 | 120.45 | 3300.0 |
| 2004-12-21 19:00:00 | SPY | ETF | 120.41 | 120.41 | 120.41 | 120.41 | 200.0 |
| 2004-12-21 19:30:00 | SPY | ETF | 120.38 | 120.38 | 120.38 | 120.38 | 200.0 |
| 2004-12-21 08:00:00 | QQQ | ETF | 39.32 | 39.38 | 39.32 | 39.38 | 189637.0 |
| 2004-12-21 08:30:00 | QQQ | ETF | 39.37 | 39.386 | 39.361 | 39.377 | 326796.0 |
| 2004-12-21 09:00:00 | QQQ | ETF | 39.38 | 39.42 | 39.24 | 39.387 | 449966.0 |
| 2004-12-21 09:30:00 | QQQ | ETF | 39.39 | 39.537 | 39.37 | 39.449 | 13159696.0 |
| 2004-12-21 10:00:00 | QQQ | ETF | 39.4499 | 39.48 | 39.39 | 39.421 | 7672707.0 |
| 2004-12-21 10:30:00 | QQQ | ETF | 39.42 | 39.43 | 39.278 | 39.347 | 7395758.0 |
| 2004-12-21 11:00:00 | QQQ | ETF | 39.35 | 39.39 | 39.327 | 39.365 | 3762299.0 |
| 2004-12-21 11:30:00 | QQQ | ETF | 39.366 | 39.47 | 39.34 | 39.45 | 5109779.0 |
| 2004-12-21 12:00:00 | QQQ | ETF | 39.45 | 39.5 | 39.43 | 39.491 | 3630670.0 |
| 2004-12-21 12:30:00 | QQQ | ETF | 39.49 | 39.65 | 39.45 | 39.629 | 5419294.0 |
| 2004-12-21 13:00:00 | QQQ | ETF | 39.628 | 39.65 | 39.55 | 39.57 | 3828755.0 |
| 2004-12-21 13:30:00 | QQQ | ETF | 39.56 | 39.62 | 39.55 | 39.607 | 2098248.0 |
| 2004-12-21 14:00:00 | QQQ | ETF | 39.605 | 39.65 | 39.59 | 39.642 | 4493498.0 |
| 2004-12-21 14:30:00 | QQQ | ETF | 39.64 | 39.7 | 39.64 | 39.68 | 4720139.0 |
| 2004-12-21 15:00:00 | QQQ | ETF | 39.68 | 39.71 | 39.56 | 39.578 | 4789967.0 |
| 2004-12-21 15:30:00 | QQQ | ETF | 39.57 | 39.68 | 39.53 | 39.66 | 8584749.0 |
| 2004-12-21 16:00:00 | QQQ | ETF | 39.65 | 39.68 | 39.516 | 39.63 | 2160929.0 |
| 2004-12-21 16:30:00 | QQQ | ETF | 39.61 | 39.622 | 39.58 | 39.622 | 302306.0 |
| 2004-12-21 17:00:00 | QQQ | ETF | 39.62 | 39.62 | 39.5383 | 39.5383 | 38883.0 |
| 2004-12-21 17:30:00 | QQQ | ETF | 39.63 | 39.65 | 39.62 | 39.62 | 11750.0 |
| 2004-12-21 18:00:00 | QQQ | ETF | 39.62 | 39.64 | 39.6 | 39.64 | 11170.0 |
| 2004-12-21 08:00:00 | IWM | ETF | 63.93 | 63.93 | 63.93 | 63.93 | 1000.0 |
| 2004-12-21 09:00:00 | IWM | ETF | 63.95 | 63.96 | 63.925 | 63.925 | 32000.0 |
| 2004-12-21 09:30:00 | IWM | ETF | 63.95 | 64.205 | 63.925 | 64.0 | 1389600.0 |
| 2004-12-21 10:00:00 | IWM | ETF | 64.0 | 64.02 | 63.89 | 63.95 | 737400.0 |
| 2004-12-21 10:30:00 | IWM | ETF | 63.96 | 64.01 | 63.805 | 63.88 | 845200.0 |
> showing 50 of 1,358 rows — these rows as CSV