PREVIEW / etf_30min / 2003-07-23
file: by_date/etf_30min/2003/2003-07-23.parquet size: 23 KB rows: 670
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-23 08:00:00 | SPY | ETF | 99.35 | 99.47 | 99.35 | 99.41 | 4700.0 |
| 2003-07-23 08:30:00 | SPY | ETF | 99.42 | 99.45 | 99.4 | 99.42 | 7800.0 |
| 2003-07-23 09:00:00 | SPY | ETF | 99.45 | 99.45 | 99.27 | 99.27 | 9200.0 |
| 2003-07-23 09:30:00 | SPY | ETF | 99.21 | 99.35 | 98.54 | 98.6 | 5835200.0 |
| 2003-07-23 10:00:00 | SPY | ETF | 98.57 | 98.67 | 98.37 | 98.62 | 3439300.0 |
| 2003-07-23 10:30:00 | SPY | ETF | 98.62 | 98.88 | 98.55 | 98.68 | 1824200.0 |
| 2003-07-23 11:00:00 | SPY | ETF | 98.68 | 98.83 | 98.47 | 98.81 | 1436500.0 |
| 2003-07-23 11:30:00 | SPY | ETF | 98.81 | 98.86 | 98.48 | 98.5 | 1097600.0 |
| 2003-07-23 12:00:00 | SPY | ETF | 98.54 | 98.62 | 98.28 | 98.429 | 1740200.0 |
| 2003-07-23 12:30:00 | SPY | ETF | 98.4 | 98.59 | 98.35 | 98.42 | 697000.0 |
| 2003-07-23 13:00:00 | SPY | ETF | 98.44 | 98.75 | 98.39 | 98.73 | 1274300.0 |
| 2003-07-23 13:30:00 | SPY | ETF | 98.72 | 99.0 | 98.64 | 98.94 | 2336800.0 |
| 2003-07-23 14:00:00 | SPY | ETF | 98.94 | 99.33 | 98.91 | 99.189 | 4614100.0 |
| 2003-07-23 14:30:00 | SPY | ETF | 99.2 | 99.37 | 99.03 | 99.13 | 2351300.0 |
| 2003-07-23 15:00:00 | SPY | ETF | 99.12 | 99.22 | 98.92 | 99.12 | 1504900.0 |
| 2003-07-23 15:30:00 | SPY | ETF | 99.14 | 99.31 | 99.01 | 99.231 | 2197800.0 |
| 2003-07-23 16:00:00 | SPY | ETF | 99.245 | 99.35 | 99.13 | 99.24 | 875400.0 |
| 2003-07-23 16:30:00 | SPY | ETF | 99.26 | 99.33 | 99.25 | 99.3 | 18400.0 |
| 2003-07-23 17:00:00 | SPY | ETF | 99.25 | 99.25 | 99.23 | 99.23 | 67000.0 |
| 2003-07-23 17:30:00 | SPY | ETF | 99.21 | 99.26 | 99.21 | 99.26 | 12700.0 |
| 2003-07-23 18:00:00 | SPY | ETF | 99.331 | 99.331 | 99.25 | 99.28 | 6700.0 |
| 2003-07-23 18:30:00 | SPY | ETF | 99.27 | 99.27 | 99.27 | 99.27 | 500.0 |
| 2003-07-23 19:00:00 | SPY | ETF | 99.32 | 99.32 | 99.25 | 99.25 | 1400.0 |
| 2003-07-23 19:30:00 | SPY | ETF | 99.25 | 99.32 | 99.25 | 99.3 | 1000.0 |
| 2003-07-23 08:00:00 | QQQ | ETF | 31.42 | 31.5 | 31.42 | 31.46 | 33800.0 |
| 2003-07-23 08:30:00 | QQQ | ETF | 31.47 | 31.48 | 31.43 | 31.47 | 55300.0 |
| 2003-07-23 09:00:00 | QQQ | ETF | 31.46 | 31.46 | 31.37 | 31.37 | 57300.0 |
| 2003-07-23 09:30:00 | QQQ | ETF | 31.38 | 31.44 | 31.13 | 31.16 | 10622000.0 |
| 2003-07-23 10:00:00 | QQQ | ETF | 31.15 | 31.2 | 30.99 | 31.18 | 6375800.0 |
| 2003-07-23 10:30:00 | QQQ | ETF | 31.18 | 31.34 | 31.14 | 31.19 | 4271800.0 |
| 2003-07-23 11:00:00 | QQQ | ETF | 31.182 | 31.24 | 31.08 | 31.22 | 2490500.0 |
| 2003-07-23 11:30:00 | QQQ | ETF | 31.22 | 31.25 | 31.089 | 31.11 | 1866100.0 |
| 2003-07-23 12:00:00 | QQQ | ETF | 31.1 | 31.14 | 31.02 | 31.11 | 2221600.0 |
| 2003-07-23 12:30:00 | QQQ | ETF | 31.118 | 31.19 | 31.08 | 31.13 | 1017100.0 |
| 2003-07-23 13:00:00 | QQQ | ETF | 31.14 | 31.254 | 31.11 | 31.25 | 2585600.0 |
| 2003-07-23 13:30:00 | QQQ | ETF | 31.25 | 31.37 | 31.2 | 31.32 | 5217400.0 |
| 2003-07-23 14:00:00 | QQQ | ETF | 31.322 | 31.54 | 31.31 | 31.499 | 6657900.0 |
| 2003-07-23 14:30:00 | QQQ | ETF | 31.49 | 31.62 | 31.44 | 31.5 | 6587100.0 |
| 2003-07-23 15:00:00 | QQQ | ETF | 31.5 | 31.54 | 31.41 | 31.46 | 3041100.0 |
| 2003-07-23 15:30:00 | QQQ | ETF | 31.49 | 31.59 | 31.45 | 31.518 | 5104900.0 |
| 2003-07-23 16:00:00 | QQQ | ETF | 31.52 | 31.64 | 31.48 | 31.57 | 2704600.0 |
| 2003-07-23 16:30:00 | QQQ | ETF | 31.57 | 31.59 | 31.514 | 31.54 | 958900.0 |
| 2003-07-23 17:00:00 | QQQ | ETF | 31.54 | 31.57 | 31.5 | 31.5 | 101100.0 |
| 2003-07-23 17:30:00 | QQQ | ETF | 31.52 | 31.53 | 31.49 | 31.53 | 143000.0 |
| 2003-07-23 18:00:00 | QQQ | ETF | 31.53 | 31.53 | 31.51 | 31.52 | 12400.0 |
| 2003-07-23 18:30:00 | QQQ | ETF | 31.5 | 31.53 | 31.49 | 31.49 | 13600.0 |
| 2003-07-23 19:00:00 | QQQ | ETF | 31.48 | 31.51 | 31.48 | 31.51 | 5200.0 |
| 2003-07-23 19:30:00 | QQQ | ETF | 31.52 | 31.52 | 31.51 | 31.51 | 7100.0 |
| 2003-07-23 09:30:00 | IWM | ETF | 46.275 | 46.4 | 46.145 | 46.18 | 429200.0 |
| 2003-07-23 10:00:00 | IWM | ETF | 46.15 | 46.155 | 45.955 | 46.035 | 304800.0 |
> showing 50 of 670 rows — these rows as CSV