PREVIEW / etf_30min / 2004-04-21
file: by_date/etf_30min/2004/2004-04-21.parquet size: 37 KB rows: 1,210
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-04-21 08:00:00 | SPY | ETF | 112.3 | 112.3 | 112.03 | 112.12 | 22500.0 |
| 2004-04-21 08:30:00 | SPY | ETF | 112.11 | 112.34 | 112.1 | 112.33 | 17300.0 |
| 2004-04-21 09:00:00 | SPY | ETF | 112.32 | 112.33 | 112.2 | 112.2 | 111500.0 |
| 2004-04-21 09:30:00 | SPY | ETF | 112.2 | 112.38 | 111.87 | 112.34 | 7352600.0 |
| 2004-04-21 10:00:00 | SPY | ETF | 112.34 | 112.72 | 112.24 | 112.43 | 8220500.0 |
| 2004-04-21 10:30:00 | SPY | ETF | 112.4 | 112.56 | 111.96 | 112.07 | 3441000.0 |
| 2004-04-21 11:00:00 | SPY | ETF | 112.08 | 112.32 | 111.89 | 112.2 | 4248100.0 |
| 2004-04-21 11:30:00 | SPY | ETF | 112.19 | 112.6 | 111.91 | 112.59 | 3310300.0 |
| 2004-04-21 12:00:00 | SPY | ETF | 112.59 | 112.79 | 112.48 | 112.71 | 3028700.0 |
| 2004-04-21 12:30:00 | SPY | ETF | 112.71 | 112.75 | 112.37 | 112.45 | 1819800.0 |
| 2004-04-21 13:00:00 | SPY | ETF | 112.45 | 112.64 | 112.43 | 112.44 | 863000.0 |
| 2004-04-21 13:30:00 | SPY | ETF | 112.44 | 112.76 | 112.44 | 112.75 | 731500.0 |
| 2004-04-21 14:00:00 | SPY | ETF | 112.75 | 112.93 | 112.6 | 112.84 | 3271200.0 |
| 2004-04-21 14:30:00 | SPY | ETF | 112.84 | 112.95 | 112.48 | 112.53 | 2142900.0 |
| 2004-04-21 15:00:00 | SPY | ETF | 112.5221 | 112.82 | 112.52 | 112.67 | 2420200.0 |
| 2004-04-21 15:30:00 | SPY | ETF | 112.68 | 112.87 | 112.62 | 112.81 | 3155900.0 |
| 2004-04-21 16:00:00 | SPY | ETF | 112.81 | 112.85 | 112.67 | 112.8 | 1689400.0 |
| 2004-04-21 16:30:00 | SPY | ETF | 112.86 | 112.91 | 112.82 | 112.9 | 152100.0 |
| 2004-04-21 17:00:00 | SPY | ETF | 112.94 | 113.03 | 112.75 | 112.75 | 52800.0 |
| 2004-04-21 17:30:00 | SPY | ETF | 112.93 | 112.93 | 112.7 | 112.7 | 63300.0 |
| 2004-04-21 18:00:00 | SPY | ETF | 112.7 | 112.71 | 112.64 | 112.68 | 55800.0 |
| 2004-04-21 19:00:00 | SPY | ETF | 112.77 | 112.77 | 112.77 | 112.77 | 400.0 |
| 2004-04-21 19:30:00 | SPY | ETF | 112.77 | 112.79 | 112.74 | 112.74 | 900.0 |
| 2004-04-21 08:00:00 | QQQ | ETF | 35.8 | 35.87 | 35.8 | 35.87 | 113600.0 |
| 2004-04-21 08:30:00 | QQQ | ETF | 35.87 | 35.96 | 35.86 | 35.96 | 218600.0 |
| 2004-04-21 09:00:00 | QQQ | ETF | 35.96 | 35.96 | 35.91 | 35.93 | 262700.0 |
| 2004-04-21 09:30:00 | QQQ | ETF | 35.92 | 35.952 | 35.68 | 35.92 | 23030900.0 |
| 2004-04-21 10:00:00 | QQQ | ETF | 35.92 | 36.07 | 35.843 | 35.87 | 14944300.0 |
| 2004-04-21 10:30:00 | QQQ | ETF | 35.86 | 35.99 | 35.74 | 35.776 | 8447500.0 |
| 2004-04-21 11:00:00 | QQQ | ETF | 35.786 | 35.84 | 35.649 | 35.83 | 10656000.0 |
| 2004-04-21 11:30:00 | QQQ | ETF | 35.82 | 36.02 | 35.681 | 35.99 | 7070000.0 |
| 2004-04-21 12:00:00 | QQQ | ETF | 36.0 | 36.04 | 35.93 | 36.0 | 6039300.0 |
| 2004-04-21 12:30:00 | QQQ | ETF | 36.007 | 36.04 | 35.88 | 35.9 | 4536300.0 |
| 2004-04-21 13:00:00 | QQQ | ETF | 35.91 | 36.011 | 35.9 | 35.94 | 3257000.0 |
| 2004-04-21 13:30:00 | QQQ | ETF | 35.922 | 36.019 | 35.91 | 36.0 | 2640000.0 |
| 2004-04-21 14:00:00 | QQQ | ETF | 36.0 | 36.08 | 35.92 | 36.034 | 7528700.0 |
| 2004-04-21 14:30:00 | QQQ | ETF | 36.04 | 36.1 | 35.93 | 35.97 | 7215300.0 |
| 2004-04-21 15:00:00 | QQQ | ETF | 35.96 | 36.06 | 35.95 | 36.0 | 4627200.0 |
| 2004-04-21 15:30:00 | QQQ | ETF | 36.02 | 36.11 | 35.985 | 36.075 | 6236500.0 |
| 2004-04-21 16:00:00 | QQQ | ETF | 36.08 | 36.2 | 35.96 | 36.17 | 2255700.0 |
| 2004-04-21 16:30:00 | QQQ | ETF | 36.171 | 36.22 | 35.15 | 36.2 | 1085300.0 |
| 2004-04-21 17:00:00 | QQQ | ETF | 36.21 | 36.24 | 35.98 | 36.0 | 1658900.0 |
| 2004-04-21 17:30:00 | QQQ | ETF | 36.0 | 36.0 | 35.8 | 35.85 | 1008300.0 |
| 2004-04-21 18:00:00 | QQQ | ETF | 35.86 | 35.95 | 35.86 | 35.92 | 447000.0 |
| 2004-04-21 18:30:00 | QQQ | ETF | 35.93 | 35.96 | 35.93 | 35.96 | 23800.0 |
| 2004-04-21 19:00:00 | QQQ | ETF | 35.96 | 36.02 | 35.96 | 36.02 | 24600.0 |
| 2004-04-21 19:30:00 | QQQ | ETF | 36.02 | 36.04 | 36.02 | 36.04 | 8900.0 |
| 2004-04-21 08:30:00 | IWM | ETF | 57.425 | 57.515 | 57.425 | 57.51 | 5800.0 |
| 2004-04-21 09:00:00 | IWM | ETF | 57.54 | 57.54 | 57.54 | 57.54 | 600.0 |
| 2004-04-21 09:30:00 | IWM | ETF | 57.5 | 57.585 | 57.02 | 57.45 | 1959000.0 |
> showing 50 of 1,210 rows — these rows as CSV