PREVIEW / etf_30min / 2004-11-30
file: by_date/etf_30min/2004/2004-11-30.parquet size: 38 KB rows: 1,322
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-11-30 08:00:00 | SPY | ETF | 117.69 | 117.86 | 117.69 | 117.81 | 20300.0 |
| 2004-11-30 08:30:00 | SPY | ETF | 117.84 | 117.98 | 117.81 | 117.9 | 220400.0 |
| 2004-11-30 09:00:00 | SPY | ETF | 117.95 | 118.02 | 117.92 | 118.01 | 63000.0 |
| 2004-11-30 09:30:00 | SPY | ETF | 118.0 | 118.2 | 117.75 | 117.93 | 8080700.0 |
| 2004-11-30 10:00:00 | SPY | ETF | 117.92 | 118.19 | 117.75 | 117.85 | 6637000.0 |
| 2004-11-30 10:30:00 | SPY | ETF | 117.86 | 117.96 | 117.64 | 117.76 | 3040500.0 |
| 2004-11-30 11:00:00 | SPY | ETF | 117.76 | 117.93 | 117.68 | 117.88 | 1632700.0 |
| 2004-11-30 11:30:00 | SPY | ETF | 117.88 | 118.02 | 117.7 | 117.94 | 2137100.0 |
| 2004-11-30 12:00:00 | SPY | ETF | 117.94 | 118.24 | 117.85 | 118.03 | 4888000.0 |
| 2004-11-30 12:30:00 | SPY | ETF | 118.03 | 118.14 | 117.92 | 117.94 | 2165800.0 |
| 2004-11-30 13:00:00 | SPY | ETF | 117.94 | 118.08 | 117.93 | 117.99 | 1098600.0 |
| 2004-11-30 13:30:00 | SPY | ETF | 117.98 | 117.99 | 117.77 | 117.87 | 2347600.0 |
| 2004-11-30 14:00:00 | SPY | ETF | 117.86 | 118.0 | 117.78 | 117.79 | 2159500.0 |
| 2004-11-30 14:30:00 | SPY | ETF | 117.79 | 117.95 | 117.71 | 117.8 | 2255600.0 |
| 2004-11-30 15:00:00 | SPY | ETF | 117.81 | 118.09 | 117.78 | 117.95 | 3125400.0 |
| 2004-11-30 15:30:00 | SPY | ETF | 117.95 | 118.07 | 117.72 | 117.73 | 4440300.0 |
| 2004-11-30 16:00:00 | SPY | ETF | 117.72 | 117.9484 | 117.64 | 117.8 | 4680500.0 |
| 2004-11-30 16:30:00 | SPY | ETF | 117.82 | 118.0 | 117.82 | 118.0 | 180300.0 |
| 2004-11-30 17:00:00 | SPY | ETF | 118.0 | 118.12 | 117.98 | 118.04 | 482200.0 |
| 2004-11-30 17:30:00 | SPY | ETF | 118.04 | 118.06 | 117.71 | 118.06 | 496300.0 |
| 2004-11-30 18:00:00 | SPY | ETF | 118.06 | 118.06 | 118.02 | 118.02 | 2000.0 |
| 2004-11-30 19:30:00 | SPY | ETF | 117.96 | 117.96 | 117.96 | 117.96 | 200.0 |
| 2004-11-30 08:00:00 | QQQ | ETF | 39.19 | 39.26 | 39.16 | 39.24 | 67900.0 |
| 2004-11-30 08:30:00 | QQQ | ETF | 39.26 | 39.3 | 39.22 | 39.29 | 416900.0 |
| 2004-11-30 09:00:00 | QQQ | ETF | 39.29 | 39.3 | 39.27 | 39.3 | 191800.0 |
| 2004-11-30 08:30:00 | IWM | ETF | 63.07 | 63.125 | 63.05 | 63.05 | 42000.0 |
| 2004-11-30 09:00:00 | IWM | ETF | 63.22 | 63.23 | 63.22 | 63.23 | 6000.0 |
| 2004-11-30 09:30:00 | IWM | ETF | 63.23 | 63.345 | 63.06 | 63.195 | 1880600.0 |
| 2004-11-30 10:00:00 | IWM | ETF | 63.205 | 63.345 | 63.13 | 63.18 | 1861400.0 |
| 2004-11-30 10:30:00 | IWM | ETF | 63.185 | 63.29 | 63.135 | 63.17 | 963000.0 |
| 2004-11-30 11:00:00 | IWM | ETF | 63.155 | 63.31 | 63.11 | 63.28 | 711800.0 |
| 2004-11-30 11:30:00 | IWM | ETF | 63.295 | 63.435 | 63.285 | 63.425 | 742800.0 |
| 2004-11-30 12:00:00 | IWM | ETF | 63.415 | 63.49 | 63.375 | 63.42 | 821600.0 |
| 2004-11-30 12:30:00 | IWM | ETF | 63.435 | 63.49 | 63.33 | 63.36 | 618800.0 |
| 2004-11-30 13:00:00 | IWM | ETF | 63.355 | 63.455 | 63.34 | 63.36 | 230200.0 |
| 2004-11-30 13:30:00 | IWM | ETF | 63.36 | 63.37 | 63.185 | 63.295 | 634000.0 |
| 2004-11-30 14:00:00 | IWM | ETF | 63.275 | 63.355 | 63.24 | 63.25 | 335200.0 |
| 2004-11-30 14:30:00 | IWM | ETF | 63.25 | 63.36 | 63.185 | 63.25 | 712800.0 |
| 2004-11-30 15:00:00 | IWM | ETF | 63.25 | 63.435 | 63.245 | 63.32 | 917400.0 |
| 2004-11-30 15:30:00 | IWM | ETF | 63.32 | 63.375 | 63.15 | 63.15 | 1334600.0 |
| 2004-11-30 16:00:00 | IWM | ETF | 63.135 | 63.44 | 63.065 | 63.4 | 730600.0 |
| 2004-11-30 16:30:00 | IWM | ETF | 63.405 | 63.415 | 63.405 | 63.415 | 8200.0 |
| 2004-11-30 17:00:00 | IWM | ETF | 63.46 | 63.47 | 63.4 | 63.44 | 54200.0 |
| 2004-11-30 17:30:00 | IWM | ETF | 63.36 | 63.36 | 63.36 | 63.36 | 6000.0 |
| 2004-11-30 18:30:00 | IWM | ETF | 63.405 | 63.405 | 63.405 | 63.405 | 800.0 |
| 2004-11-30 08:30:00 | DIA | ETF | 104.55 | 104.59 | 104.47 | 104.47 | 9700.0 |
| 2004-11-30 09:00:00 | DIA | ETF | 104.58 | 104.65 | 104.58 | 104.62 | 1400.0 |
| 2004-11-30 09:30:00 | DIA | ETF | 104.6 | 104.76 | 104.34 | 104.49 | 899400.0 |
| 2004-11-30 10:00:00 | DIA | ETF | 104.51 | 104.75 | 104.35 | 104.43 | 988900.0 |
| 2004-11-30 10:30:00 | DIA | ETF | 104.38 | 104.46 | 104.21 | 104.27 | 568000.0 |
> showing 50 of 1,322 rows — these rows as CSV