PREVIEW / etf_30min / 2005-07-07
file: by_date/etf_30min/2005/2005-07-07.parquet size: 47 KB rows: 1,620
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-07-07 04:30:00 | SPY | ETF | 119.2 | 119.39 | 119.03 | 119.03 | 22200.0 |
| 2005-07-07 05:00:00 | SPY | ETF | 118.73 | 118.91 | 117.65 | 117.65 | 33400.0 |
| 2005-07-07 05:30:00 | SPY | ETF | 117.74 | 117.74 | 117.44 | 117.44 | 34900.0 |
| 2005-07-07 06:00:00 | SPY | ETF | 117.3 | 117.61 | 117.13 | 117.29 | 97700.0 |
| 2005-07-07 06:30:00 | SPY | ETF | 117.34 | 117.36 | 116.83 | 117.22 | 299900.0 |
| 2005-07-07 07:00:00 | SPY | ETF | 117.21 | 117.8 | 117.21 | 117.75 | 522200.0 |
| 2005-07-07 07:30:00 | SPY | ETF | 117.76 | 118.06 | 117.75 | 117.85 | 747300.0 |
| 2005-07-07 08:00:00 | SPY | ETF | 117.9 | 118.06 | 117.75 | 117.8 | 981600.0 |
| 2005-07-07 08:30:00 | SPY | ETF | 117.79 | 118.11 | 117.06 | 118.1 | 1197500.0 |
| 2005-07-07 09:00:00 | SPY | ETF | 118.09 | 118.33 | 118.07 | 118.29 | 907800.0 |
| 2005-07-07 09:30:00 | SPY | ETF | 118.29 | 118.9 | 118.26 | 118.49 | 19064300.0 |
| 2005-07-07 10:00:00 | SPY | ETF | 118.49 | 118.87 | 118.44 | 118.66 | 11222700.0 |
| 2005-07-07 10:30:00 | SPY | ETF | 118.66 | 118.74 | 118.4 | 118.5 | 8237000.0 |
| 2005-07-07 11:00:00 | SPY | ETF | 118.5 | 118.87 | 118.28 | 118.82 | 6701200.0 |
| 2005-07-07 11:30:00 | SPY | ETF | 118.81 | 119.12 | 118.67 | 119.1 | 4868100.0 |
| 2005-07-07 12:00:00 | SPY | ETF | 119.1 | 119.45 | 118.98 | 119.29 | 9873600.0 |
| 2005-07-07 12:30:00 | SPY | ETF | 119.28 | 119.29 | 119.03 | 119.1 | 3975100.0 |
| 2005-07-07 13:00:00 | SPY | ETF | 119.11 | 119.26 | 119.07 | 119.21 | 2642800.0 |
| 2005-07-07 13:30:00 | SPY | ETF | 119.21 | 119.54 | 119.2 | 119.36 | 3474800.0 |
| 2005-07-07 14:00:00 | SPY | ETF | 119.36 | 119.38 | 119.11 | 119.21 | 3643600.0 |
| 2005-07-07 14:30:00 | SPY | ETF | 119.22 | 119.36 | 119.07 | 119.34 | 3000200.0 |
| 2005-07-07 15:00:00 | SPY | ETF | 119.34 | 119.78 | 119.11 | 119.59 | 6674300.0 |
| 2005-07-07 15:30:00 | SPY | ETF | 119.6 | 119.89 | 119.56 | 119.77 | 6902300.0 |
| 2005-07-07 16:00:00 | SPY | ETF | 119.76 | 120.4 | 119.61 | 119.9 | 356300.0 |
| 2005-07-07 16:30:00 | SPY | ETF | 119.91 | 119.99 | 119.87 | 119.96 | 825100.0 |
| 2005-07-07 17:00:00 | SPY | ETF | 119.96 | 120.0 | 119.95 | 120.0 | 71800.0 |
| 2005-07-07 17:30:00 | SPY | ETF | 119.98 | 119.99 | 119.95 | 119.95 | 3800.0 |
| 2005-07-07 18:00:00 | SPY | ETF | 119.97 | 120.0 | 119.93 | 120.0 | 13400.0 |
| 2005-07-07 18:30:00 | SPY | ETF | 119.98 | 119.98 | 119.98 | 119.98 | 100.0 |
| 2005-07-07 19:00:00 | SPY | ETF | 119.96 | 120.09 | 119.96 | 120.09 | 2600.0 |
| 2005-07-07 19:30:00 | SPY | ETF | 120.1 | 120.13 | 120.08 | 120.13 | 3900.0 |
| 2005-07-07 09:30:00 | QQQ | ETF | 36.58 | 36.82 | 36.55 | 36.62 | 27732300.0 |
| 2005-07-07 10:00:00 | QQQ | ETF | 36.62 | 36.75 | 36.6 | 36.66 | 9408600.0 |
| 2005-07-07 10:30:00 | QQQ | ETF | 36.66 | 36.71 | 36.6 | 36.6 | 9504100.0 |
| 2005-07-07 11:00:00 | QQQ | ETF | 36.6 | 36.75 | 36.55 | 36.72 | 9948900.0 |
| 2005-07-07 11:30:00 | QQQ | ETF | 36.72 | 37.73 | 36.67 | 36.84 | 4784200.0 |
| 2005-07-07 12:00:00 | QQQ | ETF | 36.84 | 37.0 | 35.96 | 36.95 | 11043200.0 |
| 2005-07-07 12:30:00 | QQQ | ETF | 36.95 | 36.95 | 36.84 | 36.87 | 3974700.0 |
| 2005-07-07 13:00:00 | QQQ | ETF | 36.87 | 36.92 | 36.86 | 36.91 | 2224400.0 |
| 2005-07-07 13:30:00 | QQQ | ETF | 36.92 | 37.08 | 36.92 | 36.99 | 6726400.0 |
| 2005-07-07 14:00:00 | QQQ | ETF | 36.99 | 37.0 | 36.88 | 36.94 | 4354000.0 |
| 2005-07-07 14:30:00 | QQQ | ETF | 36.94 | 36.97 | 36.87 | 36.96 | 3711100.0 |
| 2005-07-07 15:00:00 | QQQ | ETF | 36.96 | 37.08 | 36.95 | 37.01 | 6217000.0 |
| 2005-07-07 15:30:00 | QQQ | ETF | 37.01 | 37.09 | 36.99 | 37.05 | 8087600.0 |
| 2005-07-07 07:00:00 | IWM | ETF | 62.99 | 63.14 | 62.99 | 63.05 | 29500.0 |
| 2005-07-07 07:30:00 | IWM | ETF | 63.15 | 63.29 | 63.14 | 63.19 | 8300.0 |
| 2005-07-07 08:00:00 | IWM | ETF | 63.19 | 63.37 | 63.11 | 63.11 | 37000.0 |
| 2005-07-07 08:30:00 | IWM | ETF | 63.11 | 63.38 | 63.11 | 63.38 | 111000.0 |
| 2005-07-07 09:00:00 | IWM | ETF | 63.38 | 63.68 | 63.38 | 63.68 | 214800.0 |
| 2005-07-07 09:30:00 | IWM | ETF | 63.69 | 64.1 | 63.69 | 63.71 | 7645300.0 |
> showing 50 of 1,620 rows — these rows as CSV