PREVIEW / etf_30min / 2003-06-06
file: by_date/etf_30min/2003/2003-06-06.parquet size: 26 KB rows: 768
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-06-06 08:00:00 | SPY | ETF | 100.11 | 100.2 | 100.1 | 100.12 | 36600.0 |
| 2003-06-06 08:30:00 | SPY | ETF | 100.15 | 100.48 | 100.15 | 100.45 | 60500.0 |
| 2003-06-06 09:00:00 | SPY | ETF | 100.47 | 100.51 | 100.43 | 100.49 | 41100.0 |
| 2003-06-06 09:30:00 | SPY | ETF | 100.4 | 101.14 | 100.27 | 101.06 | 9436300.0 |
| 2003-06-06 10:00:00 | SPY | ETF | 101.07 | 101.4 | 100.88 | 100.88 | 7780300.0 |
| 2003-06-06 10:30:00 | SPY | ETF | 100.91 | 101.08 | 100.75 | 100.9 | 3688800.0 |
| 2003-06-06 11:00:00 | SPY | ETF | 100.89 | 100.94 | 100.13 | 100.31 | 4420400.0 |
| 2003-06-06 11:30:00 | SPY | ETF | 100.31 | 100.55 | 100.17 | 100.48 | 3499800.0 |
| 2003-06-06 12:00:00 | SPY | ETF | 100.47 | 100.54 | 99.91 | 100.09 | 2109300.0 |
| 2003-06-06 12:30:00 | SPY | ETF | 100.05 | 100.13 | 99.65 | 99.71 | 2567700.0 |
| 2003-06-06 13:00:00 | SPY | ETF | 99.65 | 100.06 | 99.45 | 99.96 | 3239000.0 |
| 2003-06-06 13:30:00 | SPY | ETF | 99.96 | 100.19 | 99.78 | 100.1 | 2034600.0 |
| 2003-06-06 14:00:00 | SPY | ETF | 100.11 | 100.38 | 99.97 | 100.26 | 1857800.0 |
| 2003-06-06 14:30:00 | SPY | ETF | 100.25 | 100.3 | 99.63 | 99.73 | 2914900.0 |
| 2003-06-06 15:00:00 | SPY | ETF | 99.72 | 99.86 | 99.22 | 99.25 | 3353100.0 |
| 2003-06-06 15:30:00 | SPY | ETF | 99.22 | 99.43 | 99.15 | 99.22 | 3889100.0 |
| 2003-06-06 16:00:00 | SPY | ETF | 99.22 | 99.35 | 99.2 | 99.35 | 2532000.0 |
| 2003-06-06 16:30:00 | SPY | ETF | 99.4 | 101.06 | 99.33 | 99.34 | 930000.0 |
| 2003-06-06 17:00:00 | SPY | ETF | 99.35 | 99.35 | 99.1 | 99.28 | 141800.0 |
| 2003-06-06 17:30:00 | SPY | ETF | 99.27 | 99.37 | 99.27 | 99.3 | 22000.0 |
| 2003-06-06 18:00:00 | SPY | ETF | 99.3 | 99.34 | 99.15 | 99.31 | 6800.0 |
| 2003-06-06 18:30:00 | SPY | ETF | 99.29 | 99.3 | 99.25 | 99.3 | 1900.0 |
| 2003-06-06 19:30:00 | SPY | ETF | 99.4 | 99.41 | 99.18 | 99.18 | 2700.0 |
| 2003-06-06 08:00:00 | QQQ | ETF | 30.98 | 31.04 | 30.91 | 31.0 | 151500.0 |
| 2003-06-06 08:30:00 | QQQ | ETF | 31.0 | 31.26 | 31.0 | 31.25 | 226200.0 |
| 2003-06-06 09:00:00 | QQQ | ETF | 31.26 | 31.28 | 31.18 | 31.19 | 170700.0 |
| 2003-06-06 09:30:00 | QQQ | ETF | 31.17 | 31.43 | 31.12 | 31.4 | 18576300.0 |
| 2003-06-06 10:00:00 | QQQ | ETF | 31.39 | 31.47 | 31.3 | 31.35 | 8727800.0 |
| 2003-06-06 10:30:00 | QQQ | ETF | 31.38 | 31.4 | 31.25 | 31.31 | 4902200.0 |
| 2003-06-06 11:00:00 | QQQ | ETF | 31.31 | 31.34 | 30.87 | 30.89 | 13648000.0 |
| 2003-06-06 11:30:00 | QQQ | ETF | 30.9 | 31.0 | 30.78 | 30.92 | 7407700.0 |
| 2003-06-06 12:00:00 | QQQ | ETF | 30.92 | 30.94 | 30.59 | 30.71 | 7677900.0 |
| 2003-06-06 12:30:00 | QQQ | ETF | 30.7 | 30.71 | 30.4 | 30.45 | 9467100.0 |
| 2003-06-06 13:00:00 | QQQ | ETF | 30.44 | 30.7 | 30.29 | 30.65 | 9087100.0 |
| 2003-06-06 13:30:00 | QQQ | ETF | 30.66 | 30.78 | 30.53 | 30.71 | 4298500.0 |
| 2003-06-06 14:00:00 | QQQ | ETF | 30.72 | 30.83 | 30.62 | 30.73 | 3977400.0 |
| 2003-06-06 14:30:00 | QQQ | ETF | 30.74 | 30.79 | 30.35 | 30.39 | 6776700.0 |
| 2003-06-06 15:00:00 | QQQ | ETF | 30.39 | 30.45 | 30.22 | 30.24 | 10720700.0 |
| 2003-06-06 15:30:00 | QQQ | ETF | 30.24 | 30.29 | 30.07 | 30.14 | 14134900.0 |
| 2003-06-06 16:00:00 | QQQ | ETF | 30.1 | 30.19 | 30.02 | 30.19 | 23148600.0 |
| 2003-06-06 16:30:00 | QQQ | ETF | 30.15 | 30.19 | 30.13 | 30.15 | 146300.0 |
| 2003-06-06 17:00:00 | QQQ | ETF | 30.14 | 30.17 | 30.1 | 30.13 | 171900.0 |
| 2003-06-06 17:30:00 | QQQ | ETF | 30.1 | 30.14 | 30.08 | 30.11 | 133100.0 |
| 2003-06-06 18:00:00 | QQQ | ETF | 30.1 | 30.14 | 30.08 | 30.11 | 16500.0 |
| 2003-06-06 18:30:00 | QQQ | ETF | 30.1 | 30.11 | 30.08 | 30.11 | 6200.0 |
| 2003-06-06 19:00:00 | QQQ | ETF | 30.09 | 30.15 | 30.09 | 30.13 | 6000.0 |
| 2003-06-06 19:30:00 | QQQ | ETF | 30.11 | 30.14 | 30.08 | 30.11 | 6500.0 |
| 2003-06-06 09:30:00 | IWM | ETF | 46.2 | 46.495 | 46.115 | 46.495 | 421600.0 |
| 2003-06-06 10:00:00 | IWM | ETF | 46.425 | 46.54 | 46.385 | 46.385 | 146000.0 |
| 2003-06-06 10:30:00 | IWM | ETF | 46.43 | 46.43 | 46.265 | 46.27 | 168000.0 |
> showing 50 of 768 rows — these rows as CSV