PREVIEW / etf_30min / 2003-02-07
file: by_date/etf_30min/2003/2003-02-07.parquet size: 21 KB rows: 622
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-02-07 08:00:00 | SPY | ETF | 84.65 | 84.68 | 84.6 | 84.67 | 18100.0 |
| 2003-02-07 08:30:00 | SPY | ETF | 84.68 | 85.37 | 84.48 | 85.04 | 206300.0 |
| 2003-02-07 09:00:00 | SPY | ETF | 85.09 | 85.11 | 84.9 | 84.9 | 32600.0 |
| 2003-02-07 09:30:00 | SPY | ETF | 84.91 | 84.99 | 84.16 | 84.33 | 7366500.0 |
| 2003-02-07 10:00:00 | SPY | ETF | 84.25 | 84.49 | 83.55 | 83.55 | 5213100.0 |
| 2003-02-07 10:30:00 | SPY | ETF | 83.63 | 84.0 | 83.4 | 83.77 | 3651900.0 |
| 2003-02-07 11:00:00 | SPY | ETF | 83.75 | 84.0 | 83.54 | 83.56 | 1899200.0 |
| 2003-02-07 11:30:00 | SPY | ETF | 83.56 | 83.94 | 83.5 | 83.89 | 1764200.0 |
| 2003-02-07 12:00:00 | SPY | ETF | 83.89 | 83.94 | 83.47 | 83.55 | 1476400.0 |
| 2003-02-07 12:30:00 | SPY | ETF | 83.58 | 83.74 | 83.48 | 83.54 | 1244700.0 |
| 2003-02-07 13:00:00 | SPY | ETF | 83.54 | 83.58 | 83.26 | 83.37 | 1809100.0 |
| 2003-02-07 13:30:00 | SPY | ETF | 83.37 | 83.48 | 83.19 | 83.33 | 1304100.0 |
| 2003-02-07 14:00:00 | SPY | ETF | 83.32 | 83.45 | 83.12 | 83.35 | 1761200.0 |
| 2003-02-07 14:30:00 | SPY | ETF | 83.31 | 83.38 | 83.02 | 83.02 | 1773000.0 |
| 2003-02-07 15:00:00 | SPY | ETF | 83.05 | 83.35 | 82.97 | 83.33 | 2819900.0 |
| 2003-02-07 15:30:00 | SPY | ETF | 83.33 | 83.48 | 83.16 | 83.27 | 4915900.0 |
| 2003-02-07 16:00:00 | SPY | ETF | 83.27 | 83.59 | 83.19 | 83.35 | 2262200.0 |
| 2003-02-07 16:30:00 | SPY | ETF | 83.35 | 83.36 | 83.25 | 83.35 | 101400.0 |
| 2003-02-07 17:00:00 | SPY | ETF | 83.35 | 83.35 | 83.34 | 83.35 | 1800.0 |
| 2003-02-07 17:30:00 | SPY | ETF | 83.35 | 83.35 | 83.21 | 83.24 | 3100.0 |
| 2003-02-07 18:30:00 | SPY | ETF | 83.32 | 83.32 | 83.32 | 83.32 | 200.0 |
| 2003-02-07 19:00:00 | SPY | ETF | 83.3 | 83.32 | 83.3 | 83.32 | 900.0 |
| 2003-02-07 19:30:00 | SPY | ETF | 83.32 | 83.32 | 83.24 | 83.24 | 800.0 |
| 2003-02-07 20:00:00 | SPY | ETF | 83.23 | 83.23 | 83.23 | 83.23 | 100.0 |
| 2003-02-07 08:00:00 | QQQ | ETF | 24.25 | 24.25 | 24.19 | 24.24 | 37600.0 |
| 2003-02-07 08:30:00 | QQQ | ETF | 24.24 | 24.55 | 24.24 | 24.48 | 199500.0 |
| 2003-02-07 09:00:00 | QQQ | ETF | 24.48 | 24.48 | 24.38 | 24.38 | 44000.0 |
| 2003-02-07 09:30:00 | QQQ | ETF | 24.36 | 24.45 | 23.95 | 24.09 | 10213900.0 |
| 2003-02-07 10:00:00 | QQQ | ETF | 24.08 | 24.19 | 23.89 | 23.91 | 8170400.0 |
| 2003-02-07 10:30:00 | QQQ | ETF | 23.91 | 24.06 | 23.82 | 24.0 | 10562100.0 |
| 2003-02-07 11:00:00 | QQQ | ETF | 23.98 | 24.06 | 23.91 | 23.91 | 2809700.0 |
| 2003-02-07 11:30:00 | QQQ | ETF | 23.91 | 24.05 | 23.87 | 24.03 | 3685200.0 |
| 2003-02-07 12:00:00 | QQQ | ETF | 24.03 | 24.06 | 23.9 | 23.95 | 2075300.0 |
| 2003-02-07 12:30:00 | QQQ | ETF | 23.96 | 24.0 | 23.9 | 23.91 | 2014900.0 |
| 2003-02-07 13:00:00 | QQQ | ETF | 23.91 | 23.95 | 23.76 | 23.82 | 5202200.0 |
| 2003-02-07 13:30:00 | QQQ | ETF | 23.82 | 23.85 | 23.75 | 23.82 | 3361000.0 |
| 2003-02-07 14:00:00 | QQQ | ETF | 23.82 | 23.87 | 23.74 | 23.83 | 3067700.0 |
| 2003-02-07 14:30:00 | QQQ | ETF | 23.82 | 23.85 | 23.68 | 23.68 | 3608900.0 |
| 2003-02-07 15:00:00 | QQQ | ETF | 23.68 | 23.79 | 23.65 | 23.78 | 5978000.0 |
| 2003-02-07 15:30:00 | QQQ | ETF | 23.78 | 23.86 | 23.71 | 23.79 | 4296100.0 |
| 2003-02-07 16:00:00 | QQQ | ETF | 23.8 | 23.85 | 23.71 | 23.79 | 2293000.0 |
| 2003-02-07 16:30:00 | QQQ | ETF | 23.79 | 23.86 | 23.75 | 23.86 | 77400.0 |
| 2003-02-07 17:00:00 | QQQ | ETF | 23.83 | 23.86 | 23.8 | 23.8 | 35500.0 |
| 2003-02-07 17:30:00 | QQQ | ETF | 23.82 | 23.82 | 23.78 | 23.78 | 13200.0 |
| 2003-02-07 18:00:00 | QQQ | ETF | 23.77 | 23.8 | 23.76 | 23.78 | 12700.0 |
| 2003-02-07 18:30:00 | QQQ | ETF | 23.79 | 23.79 | 23.79 | 23.79 | 100.0 |
| 2003-02-07 19:00:00 | QQQ | ETF | 23.79 | 23.79 | 23.76 | 23.76 | 1100.0 |
| 2003-02-07 19:30:00 | QQQ | ETF | 23.79 | 23.82 | 23.78 | 23.82 | 8300.0 |
| 2003-02-07 08:30:00 | IWM | ETF | 36.44 | 36.44 | 36.44 | 36.44 | 1000.0 |
| 2003-02-07 09:30:00 | IWM | ETF | 36.52 | 36.6 | 36.235 | 36.25 | 258400.0 |
> showing 50 of 622 rows — these rows as CSV