PREVIEW / etf_30min / 2005-11-04
file: by_date/etf_30min/2005/2005-11-04.parquet size: 50 KB rows: 1,770
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-04 07:00:00 | SPY | ETF | 122.2 | 122.2 | 122.13 | 122.13 | 82500.0 |
| 2005-11-04 07:30:00 | SPY | ETF | 122.16 | 122.18 | 122.15 | 122.15 | 60800.0 |
| 2005-11-04 08:00:00 | SPY | ETF | 122.15 | 122.2 | 122.02 | 122.2 | 1387800.0 |
| 2005-11-04 08:30:00 | SPY | ETF | 122.16 | 122.28 | 121.96 | 122.18 | 1641000.0 |
| 2005-11-04 09:00:00 | SPY | ETF | 122.18 | 122.49 | 122.18 | 122.38 | 2237600.0 |
| 2005-11-04 09:30:00 | SPY | ETF | 122.4 | 122.46 | 122.15 | 122.32 | 5390200.0 |
| 2005-11-04 10:00:00 | SPY | ETF | 122.3201 | 122.43 | 121.91 | 122.03 | 6772700.0 |
| 2005-11-04 10:30:00 | SPY | ETF | 122.02 | 122.08 | 121.55 | 121.67 | 9194800.0 |
| 2005-11-04 11:00:00 | SPY | ETF | 121.67 | 121.87 | 121.63 | 121.78 | 3346200.0 |
| 2005-11-04 11:30:00 | SPY | ETF | 121.76 | 121.99 | 121.61 | 121.8 | 4659200.0 |
| 2005-11-04 12:00:00 | SPY | ETF | 121.84 | 122.0 | 121.68 | 121.94 | 4931700.0 |
| 2005-11-04 12:30:00 | SPY | ETF | 121.93 | 122.04 | 121.83 | 121.94 | 2245400.0 |
| 2005-11-04 13:00:00 | SPY | ETF | 121.96 | 122.0 | 121.74 | 121.86 | 2140300.0 |
| 2005-11-04 13:30:00 | SPY | ETF | 121.87 | 121.9 | 121.73 | 121.74 | 2269400.0 |
| 2005-11-04 14:00:00 | SPY | ETF | 121.74 | 122.05 | 121.65 | 121.9 | 2002800.0 |
| 2005-11-04 14:30:00 | SPY | ETF | 121.9 | 121.95 | 121.65 | 121.86 | 1872400.0 |
| 2005-11-04 15:00:00 | SPY | ETF | 121.86 | 121.96 | 121.76 | 121.88 | 1618600.0 |
| 2005-11-04 15:30:00 | SPY | ETF | 121.91 | 122.22 | 121.86 | 122.11 | 5820500.0 |
| 2005-11-04 16:00:00 | SPY | ETF | 122.12 | 122.17 | 120.11 | 122.05 | 906500.0 |
| 2005-11-04 16:30:00 | SPY | ETF | 122.17 | 122.17 | 122.05 | 122.1 | 33700.0 |
| 2005-11-04 17:00:00 | SPY | ETF | 122.08 | 122.13 | 122.03 | 122.06 | 39600.0 |
| 2005-11-04 17:30:00 | SPY | ETF | 122.06 | 122.06 | 122.01 | 122.01 | 6400.0 |
| 2005-11-04 18:00:00 | SPY | ETF | 122.1 | 122.11 | 122.1 | 122.11 | 900.0 |
| 2005-11-04 09:30:00 | QQQ | ETF | 40.0 | 40.13 | 39.97 | 40.11 | 14972400.0 |
| 2005-11-04 10:00:00 | QQQ | ETF | 40.12 | 40.23 | 40.0 | 40.04 | 12843600.0 |
| 2005-11-04 10:30:00 | QQQ | ETF | 40.04 | 40.07 | 39.84 | 39.9 | 12168200.0 |
| 2005-11-04 11:00:00 | QQQ | ETF | 39.9 | 40.03 | 39.9 | 39.99 | 7552600.0 |
| 2005-11-04 11:30:00 | QQQ | ETF | 39.98 | 40.01 | 39.88 | 39.97 | 5635600.0 |
| 2005-11-04 12:00:00 | QQQ | ETF | 39.97 | 40.0 | 39.9 | 39.95 | 2210900.0 |
| 2005-11-04 12:30:00 | QQQ | ETF | 39.96 | 40.0 | 39.94 | 39.98 | 2399600.0 |
| 2005-11-04 13:00:00 | QQQ | ETF | 39.98 | 39.99 | 39.9 | 39.95 | 2235100.0 |
| 2005-11-04 13:30:00 | QQQ | ETF | 39.96 | 40.0 | 39.9 | 39.92 | 1834800.0 |
| 2005-11-04 14:00:00 | QQQ | ETF | 39.93 | 40.05 | 39.9 | 39.98 | 4494500.0 |
| 2005-11-04 14:30:00 | QQQ | ETF | 39.99 | 40.0 | 39.87 | 39.96 | 5703300.0 |
| 2005-11-04 15:00:00 | QQQ | ETF | 39.96 | 39.99 | 39.91 | 39.97 | 3196300.0 |
| 2005-11-04 15:30:00 | QQQ | ETF | 39.96 | 40.13 | 38.98 | 40.06 | 11828500.0 |
| 2005-11-04 07:00:00 | IWM | ETF | 65.62 | 65.67 | 65.62 | 65.63 | 40000.0 |
| 2005-11-04 07:30:00 | IWM | ETF | 65.64 | 65.64 | 65.62 | 65.62 | 36000.0 |
| 2005-11-04 08:00:00 | IWM | ETF | 65.64 | 65.66 | 65.55 | 65.6 | 637000.0 |
| 2005-11-04 08:30:00 | IWM | ETF | 65.58 | 65.6 | 65.49 | 65.49 | 160600.0 |
| 2005-11-04 09:00:00 | IWM | ETF | 65.51 | 65.7 | 65.49 | 65.56 | 669000.0 |
| 2005-11-04 09:30:00 | IWM | ETF | 65.58 | 65.77 | 65.4 | 65.62 | 3962000.0 |
| 2005-11-04 10:00:00 | IWM | ETF | 65.62 | 65.7 | 65.34 | 65.45 | 2482100.0 |
| 2005-11-04 10:30:00 | IWM | ETF | 65.44 | 65.48 | 65.04 | 65.18 | 2900200.0 |
| 2005-11-04 11:00:00 | IWM | ETF | 65.15 | 65.3 | 65.12 | 65.2 | 1494300.0 |
| 2005-11-04 11:30:00 | IWM | ETF | 65.2 | 65.24 | 65.05 | 65.19 | 1881400.0 |
| 2005-11-04 12:00:00 | IWM | ETF | 65.18 | 65.33 | 65.09 | 65.3 | 1079900.0 |
| 2005-11-04 12:30:00 | IWM | ETF | 65.28 | 65.49 | 65.26 | 65.39 | 2038200.0 |
| 2005-11-04 13:00:00 | IWM | ETF | 65.38 | 65.4 | 65.15 | 65.23 | 1089900.0 |
| 2005-11-04 13:30:00 | IWM | ETF | 65.22 | 65.29 | 65.16 | 65.17 | 827200.0 |
> showing 50 of 1,770 rows — these rows as CSV