PREVIEW / etf_30min / 2003-09-24
file: by_date/etf_30min/2003/2003-09-24.parquet size: 25 KB rows: 751
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-09-24 08:00:00 | SPY | ETF | 103.13 | 103.13 | 103.1 | 103.1 | 3400.0 |
| 2003-09-24 08:30:00 | SPY | ETF | 103.1 | 103.1 | 103.04 | 103.1 | 8400.0 |
| 2003-09-24 09:00:00 | SPY | ETF | 103.09 | 103.18 | 103.09 | 103.17 | 5800.0 |
| 2003-09-24 09:30:00 | SPY | ETF | 103.118 | 103.22 | 102.87 | 102.91 | 2365900.0 |
| 2003-09-24 10:00:00 | SPY | ETF | 102.9 | 103.03 | 102.61 | 102.7 | 2973200.0 |
| 2003-09-24 10:30:00 | SPY | ETF | 102.72 | 102.86 | 102.581 | 102.68 | 1224900.0 |
| 2003-09-24 11:00:00 | SPY | ETF | 102.67 | 102.83 | 102.57 | 102.57 | 1263300.0 |
| 2003-09-24 11:30:00 | SPY | ETF | 102.6 | 102.61 | 102.15 | 102.18 | 2433500.0 |
| 2003-09-24 12:00:00 | SPY | ETF | 102.15 | 102.2 | 101.76 | 101.85 | 4214500.0 |
| 2003-09-24 12:30:00 | SPY | ETF | 101.85 | 101.95 | 101.39 | 101.66 | 3752200.0 |
| 2003-09-24 13:00:00 | SPY | ETF | 101.65 | 101.73 | 101.43 | 101.53 | 2673400.0 |
| 2003-09-24 13:30:00 | SPY | ETF | 101.48 | 101.64 | 101.25 | 101.46 | 3003400.0 |
| 2003-09-24 14:00:00 | SPY | ETF | 101.46 | 101.66 | 101.38 | 101.51 | 2294900.0 |
| 2003-09-24 14:30:00 | SPY | ETF | 101.52 | 101.61 | 101.26 | 101.37 | 1517600.0 |
| 2003-09-24 15:00:00 | SPY | ETF | 101.37 | 101.54 | 101.274 | 101.31 | 1843400.0 |
| 2003-09-24 15:30:00 | SPY | ETF | 101.31 | 101.49 | 101.07 | 101.2 | 5142500.0 |
| 2003-09-24 16:00:00 | SPY | ETF | 101.19 | 101.24 | 101.08 | 101.11 | 1532800.0 |
| 2003-09-24 16:30:00 | SPY | ETF | 101.11 | 101.15 | 101.07 | 101.07 | 72900.0 |
| 2003-09-24 17:00:00 | SPY | ETF | 101.06 | 101.24 | 101.05 | 101.18 | 33100.0 |
| 2003-09-24 17:30:00 | SPY | ETF | 101.19 | 101.19 | 101.12 | 101.135 | 11000.0 |
| 2003-09-24 18:00:00 | SPY | ETF | 101.09 | 101.11 | 101.08 | 101.11 | 6000.0 |
| 2003-09-24 18:30:00 | SPY | ETF | 101.1 | 101.15 | 101.1 | 101.11 | 1300.0 |
| 2003-09-24 19:00:00 | SPY | ETF | 101.15 | 101.15 | 101.13 | 101.13 | 1100.0 |
| 2003-09-24 19:30:00 | SPY | ETF | 101.15 | 101.16 | 101.15 | 101.16 | 900.0 |
| 2003-09-24 08:00:00 | QQQ | ETF | 34.6 | 34.6 | 34.57 | 34.58 | 29000.0 |
| 2003-09-24 08:30:00 | QQQ | ETF | 34.57 | 34.57 | 34.53 | 34.54 | 99800.0 |
| 2003-09-24 09:00:00 | QQQ | ETF | 34.54 | 34.55 | 34.51 | 34.51 | 277700.0 |
| 2003-09-24 09:30:00 | QQQ | ETF | 34.51 | 34.52 | 34.249 | 34.28 | 12452600.0 |
| 2003-09-24 10:00:00 | QQQ | ETF | 34.29 | 34.35 | 34.15 | 34.231 | 6089500.0 |
| 2003-09-24 10:30:00 | QQQ | ETF | 34.24 | 34.36 | 34.16 | 34.236 | 4253000.0 |
| 2003-09-24 11:00:00 | QQQ | ETF | 34.23 | 34.333 | 34.189 | 34.19 | 2918700.0 |
| 2003-09-24 11:30:00 | QQQ | ETF | 34.22 | 34.24 | 33.988 | 34.01 | 7461600.0 |
| 2003-09-24 12:00:00 | QQQ | ETF | 34.01 | 34.02 | 33.7 | 33.8 | 10567200.0 |
| 2003-09-24 12:30:00 | QQQ | ETF | 33.8 | 33.84 | 33.552 | 33.73 | 8598700.0 |
| 2003-09-24 13:00:00 | QQQ | ETF | 33.734 | 33.75 | 33.58 | 33.61 | 5601500.0 |
| 2003-09-24 13:30:00 | QQQ | ETF | 33.601 | 33.72 | 33.52 | 33.6 | 5890600.0 |
| 2003-09-24 14:00:00 | QQQ | ETF | 33.59 | 33.755 | 33.546 | 33.604 | 6040300.0 |
| 2003-09-24 14:30:00 | QQQ | ETF | 33.6 | 33.68 | 33.5 | 33.54 | 5418500.0 |
| 2003-09-24 15:00:00 | QQQ | ETF | 33.531 | 33.62 | 33.45 | 33.45 | 6069200.0 |
| 2003-09-24 15:30:00 | QQQ | ETF | 33.45 | 33.57 | 33.26 | 33.35 | 11977900.0 |
| 2003-09-24 16:00:00 | QQQ | ETF | 33.36 | 33.4 | 33.17 | 33.23 | 4143100.0 |
| 2003-09-24 16:30:00 | QQQ | ETF | 33.24 | 33.25 | 33.2 | 33.21 | 161300.0 |
| 2003-09-24 17:00:00 | QQQ | ETF | 33.22 | 33.38 | 33.15 | 33.32 | 1390600.0 |
| 2003-09-24 17:30:00 | QQQ | ETF | 33.32 | 33.33 | 33.17 | 33.26 | 382900.0 |
| 2003-09-24 18:00:00 | QQQ | ETF | 33.26 | 33.313 | 33.26 | 33.28 | 57900.0 |
| 2003-09-24 18:30:00 | QQQ | ETF | 33.3 | 33.31 | 33.28 | 33.3 | 17000.0 |
| 2003-09-24 19:00:00 | QQQ | ETF | 33.28 | 33.28 | 33.28 | 33.28 | 3600.0 |
| 2003-09-24 19:30:00 | QQQ | ETF | 33.3 | 33.34 | 33.27 | 33.34 | 30500.0 |
| 2003-09-24 09:30:00 | IWM | ETF | 51.9 | 51.925 | 51.635 | 51.735 | 138400.0 |
| 2003-09-24 10:00:00 | IWM | ETF | 51.74 | 51.765 | 51.55 | 51.58 | 653000.0 |
> showing 50 of 751 rows — these rows as CSV