PREVIEW / etf_30min / 2004-07-06
file: by_date/etf_30min/2004/2004-07-06.parquet size: 35 KB rows: 1,180
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-06 08:00:00 | SPY | ETF | 112.33 | 112.36 | 112.18 | 112.36 | 28000.0 |
| 2004-07-06 08:30:00 | SPY | ETF | 112.32 | 112.37 | 112.32 | 112.36 | 118900.0 |
| 2004-07-06 09:00:00 | SPY | ETF | 112.35 | 112.38 | 112.3 | 112.35 | 171200.0 |
| 2004-07-06 09:30:00 | SPY | ETF | 112.37 | 112.45 | 112.16 | 112.37 | 4792600.0 |
| 2004-07-06 10:00:00 | SPY | ETF | 112.37 | 112.43 | 112.17 | 112.35 | 3152100.0 |
| 2004-07-06 10:30:00 | SPY | ETF | 112.35 | 112.41 | 112.23 | 112.24 | 2125300.0 |
| 2004-07-06 11:00:00 | SPY | ETF | 112.24 | 112.29 | 111.87 | 112.05 | 4013200.0 |
| 2004-07-06 11:30:00 | SPY | ETF | 112.05 | 112.08 | 111.72 | 111.84 | 3587700.0 |
| 2004-07-06 12:00:00 | SPY | ETF | 111.84 | 112.0 | 111.73 | 111.95 | 2056900.0 |
| 2004-07-06 12:30:00 | SPY | ETF | 111.95 | 111.99 | 111.8 | 111.9 | 1168800.0 |
| 2004-07-06 13:00:00 | SPY | ETF | 111.9 | 111.98 | 111.8 | 111.87 | 891800.0 |
| 2004-07-06 13:30:00 | SPY | ETF | 111.88 | 111.94 | 111.73 | 111.74 | 1129200.0 |
| 2004-07-06 14:00:00 | SPY | ETF | 111.75 | 111.89 | 111.63 | 111.66 | 2232500.0 |
| 2004-07-06 14:30:00 | SPY | ETF | 111.66 | 111.92 | 111.64 | 111.82 | 2905700.0 |
| 2004-07-06 15:00:00 | SPY | ETF | 111.82 | 112.15 | 111.79 | 112.11 | 2351400.0 |
| 2004-07-06 15:30:00 | SPY | ETF | 112.11 | 112.29 | 111.92 | 111.96 | 3345200.0 |
| 2004-07-06 16:00:00 | SPY | ETF | 111.96 | 111.99 | 111.82 | 111.85 | 1393000.0 |
| 2004-07-06 16:30:00 | SPY | ETF | 111.88 | 111.91 | 111.82 | 111.88 | 49500.0 |
| 2004-07-06 17:00:00 | SPY | ETF | 111.92 | 111.94 | 111.92 | 111.93 | 2700.0 |
| 2004-07-06 17:30:00 | SPY | ETF | 111.92 | 111.92 | 111.92 | 111.92 | 10000.0 |
| 2004-07-06 18:00:00 | SPY | ETF | 111.91 | 111.91 | 111.89 | 111.89 | 2100.0 |
| 2004-07-06 18:30:00 | SPY | ETF | 111.94 | 111.94 | 111.94 | 111.94 | 900.0 |
| 2004-07-06 19:00:00 | SPY | ETF | 111.9 | 111.9 | 111.9 | 111.9 | 100.0 |
| 2004-07-06 08:00:00 | QQQ | ETF | 36.66 | 36.66 | 36.56 | 36.62 | 102100.0 |
| 2004-07-06 08:30:00 | QQQ | ETF | 36.62 | 36.62 | 36.58 | 36.6 | 90300.0 |
| 2004-07-06 09:00:00 | QQQ | ETF | 36.59 | 36.61 | 36.57 | 36.59 | 227900.0 |
| 2004-07-06 09:30:00 | QQQ | ETF | 36.59 | 36.6 | 36.31 | 36.4 | 19297600.0 |
| 2004-07-06 10:00:00 | QQQ | ETF | 36.4 | 36.41 | 36.239 | 36.33 | 12445500.0 |
| 2004-07-06 10:30:00 | QQQ | ETF | 36.331 | 36.36 | 36.25 | 36.25 | 6443600.0 |
| 2004-07-06 11:00:00 | QQQ | ETF | 36.25 | 36.27 | 36.06 | 36.13 | 12498800.0 |
| 2004-07-06 11:30:00 | QQQ | ETF | 36.13 | 36.13 | 35.91 | 36.0 | 15351400.0 |
| 2004-07-06 12:00:00 | QQQ | ETF | 36.0 | 36.08 | 35.96 | 36.07 | 6193600.0 |
| 2004-07-06 12:30:00 | QQQ | ETF | 36.067 | 36.08 | 35.98 | 36.05 | 4567800.0 |
| 2004-07-06 13:00:00 | QQQ | ETF | 36.06 | 36.08 | 36.0 | 36.03 | 3385500.0 |
| 2004-07-06 13:30:00 | QQQ | ETF | 36.021 | 36.03 | 35.92 | 35.93 | 3585400.0 |
| 2004-07-06 14:00:00 | QQQ | ETF | 35.938 | 36.0 | 35.84 | 35.87 | 8448200.0 |
| 2004-07-06 14:30:00 | QQQ | ETF | 35.863 | 36.0 | 35.83 | 35.96 | 6065100.0 |
| 2004-07-06 15:00:00 | QQQ | ETF | 35.96 | 36.09 | 35.94 | 36.05 | 7436300.0 |
| 2004-07-06 15:30:00 | QQQ | ETF | 36.05 | 36.14 | 35.96 | 35.99 | 14149500.0 |
| 2004-07-06 16:00:00 | QQQ | ETF | 36.01 | 36.07 | 35.94 | 36.0 | 3504800.0 |
| 2004-07-06 16:30:00 | QQQ | ETF | 36.01 | 36.04 | 35.99 | 36.04 | 360900.0 |
| 2004-07-06 17:00:00 | QQQ | ETF | 36.02 | 36.05 | 36.003 | 36.02 | 176400.0 |
| 2004-07-06 17:30:00 | QQQ | ETF | 36.02 | 36.04 | 36.0 | 36.029 | 91100.0 |
| 2004-07-06 18:00:00 | QQQ | ETF | 36.029 | 36.04 | 36.015 | 36.02 | 11800.0 |
| 2004-07-06 18:30:00 | QQQ | ETF | 36.03 | 36.03 | 36.03 | 36.03 | 1400.0 |
| 2004-07-06 19:00:00 | QQQ | ETF | 36.05 | 36.06 | 36.04 | 36.06 | 8400.0 |
| 2004-07-06 19:30:00 | QQQ | ETF | 36.06 | 36.07 | 36.06 | 36.07 | 9000.0 |
| 2004-07-06 08:30:00 | IWM | ETF | 57.65 | 57.65 | 57.62 | 57.62 | 4000.0 |
| 2004-07-06 09:30:00 | IWM | ETF | 57.735 | 57.78 | 57.435 | 57.505 | 2709800.0 |
| 2004-07-06 10:00:00 | IWM | ETF | 57.505 | 57.515 | 57.2 | 57.33 | 1204400.0 |
> showing 50 of 1,180 rows — these rows as CSV