PREVIEW / etf_30min / 2004-07-21
file: by_date/etf_30min/2004/2004-07-21.parquet size: 39 KB rows: 1,192
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-21 08:00:00 | SPY | ETF | 111.79 | 111.84 | 111.78 | 111.8 | 34200.0 |
| 2004-07-21 08:30:00 | SPY | ETF | 111.81 | 111.81 | 111.73 | 111.76 | 23100.0 |
| 2004-07-21 09:00:00 | SPY | ETF | 111.75 | 111.93 | 111.75 | 111.81 | 71300.0 |
| 2004-07-21 09:30:00 | SPY | ETF | 111.82 | 111.95 | 111.67 | 111.75 | 7361900.0 |
| 2004-07-21 10:00:00 | SPY | ETF | 111.75 | 112.06 | 111.65 | 111.93 | 3824300.0 |
| 2004-07-21 10:30:00 | SPY | ETF | 111.93 | 111.96 | 111.76 | 111.8 | 2514100.0 |
| 2004-07-21 11:00:00 | SPY | ETF | 111.79 | 111.81 | 111.51 | 111.63 | 3282100.0 |
| 2004-07-21 11:30:00 | SPY | ETF | 111.62 | 111.69 | 111.45 | 111.45 | 1680000.0 |
| 2004-07-21 12:00:00 | SPY | ETF | 111.45 | 111.49 | 111.23 | 111.33 | 3763300.0 |
| 2004-07-21 12:30:00 | SPY | ETF | 111.33 | 111.49 | 111.25 | 111.37 | 1981400.0 |
| 2004-07-21 13:00:00 | SPY | ETF | 111.38 | 111.43 | 111.07 | 111.14 | 2205900.0 |
| 2004-07-21 13:30:00 | SPY | ETF | 111.14 | 111.22 | 110.93 | 111.0 | 2434900.0 |
| 2004-07-21 14:00:00 | SPY | ETF | 110.98 | 111.01 | 110.72 | 110.83 | 3379900.0 |
| 2004-07-21 14:30:00 | SPY | ETF | 110.84 | 111.0 | 110.65 | 110.67 | 2760600.0 |
| 2004-07-21 15:00:00 | SPY | ETF | 110.67 | 110.7 | 110.3 | 110.37 | 4544600.0 |
| 2004-07-21 15:30:00 | SPY | ETF | 110.4 | 110.49 | 109.76 | 109.79 | 6546600.0 |
| 2004-07-21 16:00:00 | SPY | ETF | 109.81 | 109.94 | 109.4 | 109.42 | 2272000.0 |
| 2004-07-21 16:30:00 | SPY | ETF | 109.42 | 109.58 | 109.42 | 109.5 | 279200.0 |
| 2004-07-21 17:00:00 | SPY | ETF | 109.5 | 109.58 | 109.45 | 109.48 | 689400.0 |
| 2004-07-21 17:30:00 | SPY | ETF | 109.49 | 109.59 | 109.47 | 109.5 | 7400.0 |
| 2004-07-21 18:00:00 | SPY | ETF | 109.5 | 109.51 | 109.46 | 109.51 | 14800.0 |
| 2004-07-21 18:30:00 | SPY | ETF | 109.52 | 109.52 | 109.51 | 109.51 | 600.0 |
| 2004-07-21 19:00:00 | SPY | ETF | 109.55 | 109.55 | 109.55 | 109.55 | 200.0 |
| 2004-07-21 19:30:00 | SPY | ETF | 109.53 | 109.53 | 109.53 | 109.53 | 500.0 |
| 2004-07-21 08:00:00 | QQQ | ETF | 35.68 | 35.68 | 35.57 | 35.61 | 125400.0 |
| 2004-07-21 08:30:00 | QQQ | ETF | 35.6 | 35.61 | 35.53 | 35.55 | 170200.0 |
| 2004-07-21 09:00:00 | QQQ | ETF | 35.57 | 35.7 | 35.56 | 35.57 | 732400.0 |
| 2004-07-21 09:30:00 | QQQ | ETF | 35.57 | 35.65 | 35.35 | 35.4 | 19230000.0 |
| 2004-07-21 10:00:00 | QQQ | ETF | 35.394 | 35.58 | 35.355 | 35.46 | 8077500.0 |
| 2004-07-21 10:30:00 | QQQ | ETF | 35.466 | 35.47 | 35.32 | 35.38 | 5595800.0 |
| 2004-07-21 11:00:00 | QQQ | ETF | 35.378 | 35.39 | 35.24 | 35.31 | 10594300.0 |
| 2004-07-21 11:30:00 | QQQ | ETF | 35.31 | 35.34 | 35.206 | 35.206 | 3732700.0 |
| 2004-07-21 12:00:00 | QQQ | ETF | 35.22 | 35.22 | 35.02 | 35.08 | 12812600.0 |
| 2004-07-21 12:30:00 | QQQ | ETF | 35.08 | 35.15 | 35.02 | 35.096 | 6995600.0 |
| 2004-07-21 13:00:00 | QQQ | ETF | 35.09 | 35.11 | 34.87 | 34.93 | 8886300.0 |
| 2004-07-21 13:30:00 | QQQ | ETF | 34.93 | 34.96 | 34.81 | 34.86 | 7007800.0 |
| 2004-07-21 14:00:00 | QQQ | ETF | 34.86 | 34.9 | 34.8 | 34.82 | 6150200.0 |
| 2004-07-21 14:30:00 | QQQ | ETF | 34.836 | 34.93 | 34.75 | 34.779 | 5776700.0 |
| 2004-07-21 15:00:00 | QQQ | ETF | 34.78 | 34.79 | 34.58 | 34.618 | 13379700.0 |
| 2004-07-21 15:30:00 | QQQ | ETF | 34.618 | 34.68 | 34.5 | 34.53 | 16474700.0 |
| 2004-07-21 16:00:00 | QQQ | ETF | 34.52 | 34.54 | 34.22 | 34.27 | 6682500.0 |
| 2004-07-21 16:30:00 | QQQ | ETF | 34.25 | 34.36 | 34.25 | 34.35 | 807100.0 |
| 2004-07-21 17:00:00 | QQQ | ETF | 34.35 | 34.37 | 34.34 | 34.37 | 190300.0 |
| 2004-07-21 17:30:00 | QQQ | ETF | 34.38 | 34.39 | 34.36 | 34.38 | 56200.0 |
| 2004-07-21 18:00:00 | QQQ | ETF | 34.37 | 34.39 | 34.36 | 34.372 | 33000.0 |
| 2004-07-21 18:30:00 | QQQ | ETF | 34.37 | 34.4 | 34.37 | 34.4 | 4800.0 |
| 2004-07-21 19:00:00 | QQQ | ETF | 34.38 | 34.38 | 34.38 | 34.38 | 4200.0 |
| 2004-07-21 19:30:00 | QQQ | ETF | 34.41 | 34.41 | 34.38 | 34.38 | 5100.0 |
| 2004-07-21 08:30:00 | IWM | ETF | 56.555 | 56.555 | 56.555 | 56.555 | 1000.0 |
| 2004-07-21 09:00:00 | IWM | ETF | 56.5 | 56.55 | 56.44 | 56.44 | 39000.0 |
> showing 50 of 1,192 rows — these rows as CSV