PREVIEW / etf_30min / 2004-03-31
file: by_date/etf_30min/2004/2004-03-31.parquet size: 35 KB rows: 1,198
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-03-31 08:00:00 | SPY | ETF | 113.19 | 113.24 | 113.19 | 113.2 | 20100.0 |
| 2004-03-31 08:30:00 | SPY | ETF | 113.15 | 113.17 | 113.09 | 113.17 | 22700.0 |
| 2004-03-31 09:00:00 | SPY | ETF | 113.15 | 113.17 | 112.97 | 112.97 | 62200.0 |
| 2004-03-31 09:30:00 | SPY | ETF | 112.99 | 113.02 | 112.64 | 112.9 | 7219700.0 |
| 2004-03-31 10:00:00 | SPY | ETF | 112.87 | 112.89 | 112.38 | 112.48 | 6716400.0 |
| 2004-03-31 10:30:00 | SPY | ETF | 112.5 | 112.78 | 112.47 | 112.74 | 2484200.0 |
| 2004-03-31 11:00:00 | SPY | ETF | 112.74 | 112.89 | 112.67 | 112.84 | 2316500.0 |
| 2004-03-31 11:30:00 | SPY | ETF | 112.83 | 112.85 | 112.64 | 112.74 | 1946700.0 |
| 2004-03-31 12:00:00 | SPY | ETF | 112.74 | 112.99 | 112.69 | 112.88 | 1331100.0 |
| 2004-03-31 12:30:00 | SPY | ETF | 112.87 | 112.94 | 112.77 | 112.85 | 704300.0 |
| 2004-03-31 13:00:00 | SPY | ETF | 112.85 | 112.92 | 112.75 | 112.86 | 877300.0 |
| 2004-03-31 13:30:00 | SPY | ETF | 112.86 | 112.88 | 112.61 | 112.67 | 1846400.0 |
| 2004-03-31 14:00:00 | SPY | ETF | 112.66 | 113.07 | 112.66 | 113.0 | 2715400.0 |
| 2004-03-31 14:30:00 | SPY | ETF | 113.0 | 113.4 | 113.0 | 113.29 | 4315800.0 |
| 2004-03-31 15:00:00 | SPY | ETF | 113.29 | 113.31 | 112.85 | 112.93 | 4319300.0 |
| 2004-03-31 15:30:00 | SPY | ETF | 112.92 | 113.09 | 112.82 | 112.87 | 4345400.0 |
| 2004-03-31 16:00:00 | SPY | ETF | 112.87 | 113.17 | 112.82 | 113.12 | 1849400.0 |
| 2004-03-31 16:30:00 | SPY | ETF | 113.13 | 113.18 | 113.12 | 113.12 | 1829800.0 |
| 2004-03-31 17:00:00 | SPY | ETF | 113.07 | 113.11 | 113.01 | 113.04 | 2900.0 |
| 2004-03-31 17:30:00 | SPY | ETF | 113.07 | 113.15 | 113.05 | 113.15 | 54200.0 |
| 2004-03-31 18:00:00 | SPY | ETF | 113.1 | 113.19 | 113.1 | 113.17 | 24700.0 |
| 2004-03-31 18:30:00 | SPY | ETF | 113.16 | 113.18 | 113.16 | 113.18 | 300.0 |
| 2004-03-31 19:00:00 | SPY | ETF | 113.19 | 113.19 | 113.16 | 113.18 | 1400.0 |
| 2004-03-31 19:30:00 | SPY | ETF | 113.18 | 113.18 | 113.16 | 113.16 | 2400.0 |
| 2004-03-31 08:00:00 | QQQ | ETF | 36.06 | 36.06 | 36.0 | 36.0 | 63200.0 |
| 2004-03-31 08:30:00 | QQQ | ETF | 36.0 | 36.01 | 35.97 | 36.0 | 38100.0 |
| 2004-03-31 09:00:00 | QQQ | ETF | 36.0 | 36.0 | 35.92 | 35.92 | 159100.0 |
| 2004-03-31 09:30:00 | QQQ | ETF | 35.92 | 35.95 | 35.78 | 35.855 | 9851700.0 |
| 2004-03-31 10:00:00 | QQQ | ETF | 35.854 | 35.854 | 35.61 | 35.67 | 12426400.0 |
| 2004-03-31 10:30:00 | QQQ | ETF | 35.67 | 35.79 | 35.64 | 35.77 | 7594500.0 |
| 2004-03-31 11:00:00 | QQQ | ETF | 35.77 | 35.79 | 35.71 | 35.77 | 3533300.0 |
| 2004-03-31 11:30:00 | QQQ | ETF | 35.77 | 35.78 | 35.67 | 35.74 | 4450300.0 |
| 2004-03-31 12:00:00 | QQQ | ETF | 35.74 | 35.84 | 35.717 | 35.792 | 4997400.0 |
| 2004-03-31 12:30:00 | QQQ | ETF | 35.78 | 35.81 | 35.74 | 35.76 | 1129100.0 |
| 2004-03-31 13:00:00 | QQQ | ETF | 35.76 | 35.8 | 35.72 | 35.762 | 1059800.0 |
| 2004-03-31 13:30:00 | QQQ | ETF | 35.76 | 35.78 | 35.66 | 35.691 | 5203400.0 |
| 2004-03-31 14:00:00 | QQQ | ETF | 35.69 | 35.88 | 35.68 | 35.84 | 4443300.0 |
| 2004-03-31 14:30:00 | QQQ | ETF | 35.84 | 36.0 | 35.84 | 35.94 | 10049700.0 |
| 2004-03-31 15:00:00 | QQQ | ETF | 35.94 | 35.95 | 35.73 | 35.77 | 5498400.0 |
| 2004-03-31 15:30:00 | QQQ | ETF | 35.77 | 35.83 | 35.66 | 35.69 | 8832300.0 |
| 2004-03-31 16:00:00 | QQQ | ETF | 35.69 | 35.85 | 35.68 | 35.81 | 3301300.0 |
| 2004-03-31 16:30:00 | QQQ | ETF | 35.81 | 35.85 | 35.81 | 35.83 | 118800.0 |
| 2004-03-31 17:00:00 | QQQ | ETF | 35.84 | 35.84 | 35.81 | 35.84 | 92300.0 |
| 2004-03-31 17:30:00 | QQQ | ETF | 35.81 | 35.83 | 35.81 | 35.81 | 25900.0 |
| 2004-03-31 18:00:00 | QQQ | ETF | 35.82 | 35.84 | 35.78 | 35.82 | 38400.0 |
| 2004-03-31 18:30:00 | QQQ | ETF | 35.82 | 35.83 | 35.82 | 35.83 | 300.0 |
| 2004-03-31 19:00:00 | QQQ | ETF | 35.84 | 35.84 | 35.83 | 35.84 | 2200.0 |
| 2004-03-31 19:30:00 | QQQ | ETF | 35.84 | 35.86 | 35.82 | 35.82 | 8500.0 |
| 2004-03-31 08:00:00 | IWM | ETF | 58.8 | 58.8 | 58.8 | 58.8 | 2000.0 |
| 2004-03-31 09:30:00 | IWM | ETF | 58.675 | 58.715 | 58.485 | 58.59 | 2065400.0 |
> showing 50 of 1,198 rows — these rows as CSV