PREVIEW / etf_30min / 2003-09-11
file: by_date/etf_30min/2003/2003-09-11.parquet size: 24 KB rows: 718
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-11 08:00:00 | SPY | ETF | 101.96 | 102.05 | 101.95 | 101.95 | 24900.0 |
| 2003-09-11 08:30:00 | SPY | ETF | 101.92 | 102.02 | 101.7 | 102.0 | 165900.0 |
| 2003-09-11 09:00:00 | SPY | ETF | 102.01 | 102.19 | 101.99 | 102.09 | 64500.0 |
| 2003-09-11 09:30:00 | SPY | ETF | 102.1 | 102.39 | 102.07 | 102.14 | 5398400.0 |
| 2003-09-11 10:00:00 | SPY | ETF | 102.155 | 102.44 | 102.03 | 102.15 | 3846800.0 |
| 2003-09-11 10:30:00 | SPY | ETF | 102.127 | 102.3 | 102.05 | 102.12 | 1732000.0 |
| 2003-09-11 11:00:00 | SPY | ETF | 102.11 | 102.15 | 101.84 | 102.03 | 2264100.0 |
| 2003-09-11 11:30:00 | SPY | ETF | 102.02 | 102.47 | 101.98 | 102.29 | 4616900.0 |
| 2003-09-11 12:00:00 | SPY | ETF | 102.3 | 102.47 | 102.26 | 102.38 | 807700.0 |
| 2003-09-11 12:30:00 | SPY | ETF | 102.38 | 102.47 | 102.27 | 102.45 | 1185400.0 |
| 2003-09-11 13:00:00 | SPY | ETF | 102.45 | 102.62 | 102.43 | 102.55 | 2077200.0 |
| 2003-09-11 13:30:00 | SPY | ETF | 102.512 | 102.6 | 102.4 | 102.48 | 1196000.0 |
| 2003-09-11 14:00:00 | SPY | ETF | 102.47 | 102.74 | 102.46 | 102.66 | 2709200.0 |
| 2003-09-11 14:30:00 | SPY | ETF | 102.65 | 102.76 | 102.58 | 102.65 | 1238600.0 |
| 2003-09-11 15:00:00 | SPY | ETF | 102.65 | 102.7 | 102.41 | 102.57 | 1480600.0 |
| 2003-09-11 15:30:00 | SPY | ETF | 102.55 | 102.55 | 102.19 | 102.267 | 3001700.0 |
| 2003-09-11 16:00:00 | SPY | ETF | 102.2 | 102.36 | 102.2 | 102.35 | 2542100.0 |
| 2003-09-11 16:30:00 | SPY | ETF | 102.34 | 102.4121 | 102.3 | 102.34 | 65300.0 |
| 2003-09-11 17:00:00 | SPY | ETF | 102.3 | 102.34 | 102.3 | 102.33 | 13200.0 |
| 2003-09-11 17:30:00 | SPY | ETF | 102.33 | 102.34 | 102.31 | 102.31 | 900.0 |
| 2003-09-11 18:00:00 | SPY | ETF | 102.31 | 102.31 | 102.26 | 102.26 | 391900.0 |
| 2003-09-11 18:30:00 | SPY | ETF | 102.34 | 102.34 | 102.34 | 102.34 | 3000.0 |
| 2003-09-11 19:30:00 | SPY | ETF | 102.34 | 102.34 | 102.26 | 102.31 | 1600.0 |
| 2003-09-11 08:00:00 | QQQ | ETF | 33.22 | 33.24 | 33.19 | 33.22 | 43400.0 |
| 2003-09-11 08:30:00 | QQQ | ETF | 33.19 | 33.32 | 33.12 | 33.3 | 393500.0 |
| 2003-09-11 09:00:00 | QQQ | ETF | 33.3 | 33.32 | 33.25 | 33.29 | 163600.0 |
| 2003-09-11 09:30:00 | QQQ | ETF | 33.278 | 33.47 | 33.26 | 33.32 | 10595400.0 |
| 2003-09-11 10:00:00 | QQQ | ETF | 33.32 | 33.44 | 33.17 | 33.22 | 9013600.0 |
| 2003-09-11 10:30:00 | QQQ | ETF | 33.229 | 33.33 | 33.08 | 33.15 | 6095600.0 |
| 2003-09-11 11:00:00 | QQQ | ETF | 33.15 | 33.17 | 33.01 | 33.111 | 6833800.0 |
| 2003-09-11 11:30:00 | QQQ | ETF | 33.111 | 33.39 | 33.06 | 33.336 | 7609300.0 |
| 2003-09-11 12:00:00 | QQQ | ETF | 33.338 | 33.46 | 33.32 | 33.39 | 4514800.0 |
| 2003-09-11 12:30:00 | QQQ | ETF | 33.385 | 33.57 | 33.35 | 33.55 | 5603900.0 |
| 2003-09-11 13:00:00 | QQQ | ETF | 33.55 | 33.64 | 33.5 | 33.53 | 6225800.0 |
| 2003-09-11 13:30:00 | QQQ | ETF | 33.524 | 33.57 | 33.45 | 33.54 | 2411600.0 |
| 2003-09-11 14:00:00 | QQQ | ETF | 33.54 | 33.68 | 33.53 | 33.639 | 5073500.0 |
| 2003-09-11 14:30:00 | QQQ | ETF | 33.64 | 33.78 | 33.62 | 33.75 | 4956200.0 |
| 2003-09-11 15:00:00 | QQQ | ETF | 33.75 | 33.78 | 33.58 | 33.658 | 4802100.0 |
| 2003-09-11 15:30:00 | QQQ | ETF | 33.661 | 33.68 | 33.5 | 33.56 | 7798500.0 |
| 2003-09-11 16:00:00 | QQQ | ETF | 33.56 | 33.66 | 33.54 | 33.63 | 2430600.0 |
| 2003-09-11 16:30:00 | QQQ | ETF | 33.65 | 33.7 | 33.62 | 33.62 | 100200.0 |
| 2003-09-11 17:00:00 | QQQ | ETF | 33.622 | 33.66 | 33.622 | 33.65 | 14200.0 |
| 2003-09-11 17:30:00 | QQQ | ETF | 33.66 | 33.66 | 33.62 | 33.625 | 24100.0 |
| 2003-09-11 18:00:00 | QQQ | ETF | 33.65 | 33.66 | 33.62 | 33.65 | 18000.0 |
| 2003-09-11 18:30:00 | QQQ | ETF | 33.64 | 33.65 | 33.63 | 33.63 | 3900.0 |
| 2003-09-11 19:00:00 | QQQ | ETF | 33.63 | 33.63 | 33.63 | 33.63 | 100.0 |
| 2003-09-11 19:30:00 | QQQ | ETF | 33.64 | 33.65 | 33.63 | 33.63 | 11700.0 |
| 2003-09-11 09:30:00 | IWM | ETF | 50.19 | 50.35 | 50.11 | 50.29 | 956400.0 |
| 2003-09-11 10:00:00 | IWM | ETF | 50.29 | 50.515 | 50.285 | 50.3 | 784200.0 |
| 2003-09-11 10:30:00 | IWM | ETF | 50.275 | 50.395 | 50.19 | 50.19 | 265200.0 |
> showing 50 of 718 rows — these rows as CSV