PREVIEW / etf_30min / 2004-04-06
file: by_date/etf_30min/2004/2004-04-06.parquet size: 34 KB rows: 1,206
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-06 08:00:00 | SPY | ETF | 115.02 | 115.02 | 114.61 | 114.79 | 27100.0 |
| 2004-04-06 08:30:00 | SPY | ETF | 114.75 | 114.85 | 114.74 | 114.8 | 23300.0 |
| 2004-04-06 09:00:00 | SPY | ETF | 114.81 | 114.83 | 114.79 | 114.79 | 23100.0 |
| 2004-04-06 09:30:00 | SPY | ETF | 114.83 | 114.94 | 114.7 | 114.89 | 3510400.0 |
| 2004-04-06 10:00:00 | SPY | ETF | 114.89 | 115.05 | 114.84 | 114.99 | 3093600.0 |
| 2004-04-06 10:30:00 | SPY | ETF | 114.99 | 115.06 | 114.79 | 114.91 | 2495100.0 |
| 2004-04-06 11:00:00 | SPY | ETF | 114.9 | 114.91 | 114.73 | 114.81 | 1432000.0 |
| 2004-04-06 11:30:00 | SPY | ETF | 114.79 | 114.86 | 114.62 | 114.74 | 2764300.0 |
| 2004-04-06 12:00:00 | SPY | ETF | 114.74 | 114.82 | 114.64 | 114.77 | 1146900.0 |
| 2004-04-06 12:30:00 | SPY | ETF | 114.78 | 114.83 | 114.68 | 114.71 | 669800.0 |
| 2004-04-06 13:00:00 | SPY | ETF | 114.7 | 114.87 | 114.68 | 114.84 | 825500.0 |
| 2004-04-06 13:30:00 | SPY | ETF | 114.83 | 115.01 | 114.81 | 114.86 | 1292500.0 |
| 2004-04-06 14:00:00 | SPY | ETF | 114.85 | 115.02 | 114.81 | 114.94 | 1399900.0 |
| 2004-04-06 14:30:00 | SPY | ETF | 114.94 | 115.18 | 114.94 | 115.02 | 1716500.0 |
| 2004-04-06 15:00:00 | SPY | ETF | 115.01 | 115.11 | 114.87 | 114.9 | 1471900.0 |
| 2004-04-06 15:30:00 | SPY | ETF | 114.91 | 115.16 | 114.85 | 115.08 | 1883000.0 |
| 2004-04-06 16:00:00 | SPY | ETF | 115.08 | 115.14 | 114.86 | 114.89 | 1785900.0 |
| 2004-04-06 16:30:00 | SPY | ETF | 114.88 | 115.11 | 114.65 | 114.69 | 1055200.0 |
| 2004-04-06 17:00:00 | SPY | ETF | 114.71 | 114.74 | 114.66 | 114.71 | 151900.0 |
| 2004-04-06 17:30:00 | SPY | ETF | 114.68 | 114.75 | 114.65 | 114.75 | 43600.0 |
| 2004-04-06 18:00:00 | SPY | ETF | 114.68 | 114.68 | 114.58 | 114.66 | 15100.0 |
| 2004-04-06 18:30:00 | SPY | ETF | 114.62 | 114.64 | 114.58 | 114.61 | 9000.0 |
| 2004-04-06 08:00:00 | QQQ | ETF | 37.37 | 37.38 | 37.08 | 37.18 | 320300.0 |
| 2004-04-06 08:30:00 | QQQ | ETF | 37.16 | 37.17 | 37.12 | 37.13 | 166300.0 |
| 2004-04-06 09:00:00 | QQQ | ETF | 37.13 | 37.16 | 37.13 | 37.16 | 88700.0 |
| 2004-04-06 09:30:00 | QQQ | ETF | 37.16 | 37.23 | 37.1 | 37.1375 | 10906000.0 |
| 2004-04-06 10:00:00 | QQQ | ETF | 37.14 | 37.24 | 37.117 | 37.22 | 6603000.0 |
| 2004-04-06 10:30:00 | QQQ | ETF | 37.23 | 37.25 | 37.1 | 37.12 | 6636200.0 |
| 2004-04-06 11:00:00 | QQQ | ETF | 37.12 | 37.14 | 37.01 | 37.061 | 7681900.0 |
| 2004-04-06 11:30:00 | QQQ | ETF | 37.07 | 37.07 | 36.98 | 37.03 | 4569000.0 |
| 2004-04-06 12:00:00 | QQQ | ETF | 37.028 | 37.05 | 36.92 | 36.978 | 4277700.0 |
| 2004-04-06 12:30:00 | QQQ | ETF | 36.97 | 37.01 | 36.94 | 36.96 | 3698600.0 |
| 2004-04-06 13:00:00 | QQQ | ETF | 36.96 | 37.05 | 36.95 | 37.035 | 3742600.0 |
| 2004-04-06 13:30:00 | QQQ | ETF | 37.035 | 37.09 | 36.95 | 36.979 | 6448800.0 |
| 2004-04-06 14:00:00 | QQQ | ETF | 37.0 | 37.07 | 36.95 | 37.06 | 5778900.0 |
| 2004-04-06 14:30:00 | QQQ | ETF | 37.06 | 37.141 | 37.04 | 37.08 | 6941800.0 |
| 2004-04-06 15:00:00 | QQQ | ETF | 37.09 | 37.106 | 36.96 | 36.978 | 6571800.0 |
| 2004-04-06 15:30:00 | QQQ | ETF | 36.98 | 37.12 | 36.95 | 37.06 | 10965300.0 |
| 2004-04-06 16:00:00 | QQQ | ETF | 37.067 | 37.12 | 36.93 | 36.95 | 6216200.0 |
| 2004-04-06 16:30:00 | QQQ | ETF | 36.95 | 36.96 | 36.88 | 36.89 | 993100.0 |
| 2004-04-06 17:00:00 | QQQ | ETF | 36.87 | 36.9 | 36.87 | 36.88 | 117700.0 |
| 2004-04-06 17:30:00 | QQQ | ETF | 36.88 | 36.9 | 36.87 | 36.88 | 11000.0 |
| 2004-04-06 18:00:00 | QQQ | ETF | 36.87 | 36.87 | 36.82 | 36.83 | 72100.0 |
| 2004-04-06 18:30:00 | QQQ | ETF | 36.83 | 36.86 | 36.8 | 36.86 | 21000.0 |
| 2004-04-06 19:00:00 | QQQ | ETF | 36.83 | 36.87 | 36.83 | 36.85 | 1000.0 |
| 2004-04-06 19:30:00 | QQQ | ETF | 36.83 | 36.85 | 36.83 | 36.85 | 2000.0 |
| 2004-04-06 08:00:00 | IWM | ETF | 60.065 | 60.065 | 60.055 | 60.055 | 2000.0 |
| 2004-04-06 08:30:00 | IWM | ETF | 60.115 | 60.2 | 60.05 | 60.05 | 9000.0 |
| 2004-04-06 09:00:00 | IWM | ETF | 60.025 | 60.025 | 59.975 | 60.0 | 5800.0 |
| 2004-04-06 09:30:00 | IWM | ETF | 60.025 | 60.24 | 59.935 | 60.165 | 1615200.0 |
> showing 50 of 1,206 rows — these rows as CSV