PREVIEW / etf_30min / 2004-03-30
file: by_date/etf_30min/2004/2004-03-30.parquet size: 35 KB rows: 1,170
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-30 08:00:00 | SPY | ETF | 112.25 | 112.39 | 112.17 | 112.23 | 83800.0 |
| 2004-03-30 08:30:00 | SPY | ETF | 112.26 | 112.28 | 112.2 | 112.28 | 17900.0 |
| 2004-03-30 09:00:00 | SPY | ETF | 112.27 | 112.33 | 112.27 | 112.33 | 20700.0 |
| 2004-03-30 09:30:00 | SPY | ETF | 112.3 | 112.7 | 112.22 | 112.67 | 5611200.0 |
| 2004-03-30 10:00:00 | SPY | ETF | 112.67 | 112.72 | 112.35 | 112.55 | 3909600.0 |
| 2004-03-30 10:30:00 | SPY | ETF | 112.55 | 112.69 | 112.39 | 112.65 | 2520800.0 |
| 2004-03-30 11:00:00 | SPY | ETF | 112.65 | 112.75 | 112.49 | 112.62 | 1816500.0 |
| 2004-03-30 11:30:00 | SPY | ETF | 112.63 | 112.72 | 112.45 | 112.45 | 831600.0 |
| 2004-03-30 12:00:00 | SPY | ETF | 112.44 | 112.58 | 112.34 | 112.5 | 1807100.0 |
| 2004-03-30 12:30:00 | SPY | ETF | 112.52 | 112.55 | 112.24 | 112.36 | 1855900.0 |
| 2004-03-30 13:00:00 | SPY | ETF | 112.36 | 112.54 | 112.31 | 112.46 | 1226800.0 |
| 2004-03-30 13:30:00 | SPY | ETF | 112.45 | 112.7 | 112.41 | 112.64 | 3119900.0 |
| 2004-03-30 14:00:00 | SPY | ETF | 112.64 | 112.7 | 112.47 | 112.61 | 1813000.0 |
| 2004-03-30 14:30:00 | SPY | ETF | 112.58 | 112.84 | 112.55 | 112.74 | 1737800.0 |
| 2004-03-30 15:00:00 | SPY | ETF | 112.74 | 113.07 | 112.69 | 112.97 | 3689300.0 |
| 2004-03-30 15:30:00 | SPY | ETF | 112.95 | 113.07 | 112.8 | 112.97 | 3566500.0 |
| 2004-03-30 16:00:00 | SPY | ETF | 112.98 | 113.02 | 112.6139 | 112.92 | 1955500.0 |
| 2004-03-30 16:30:00 | SPY | ETF | 112.96 | 113.0 | 112.92 | 112.97 | 68800.0 |
| 2004-03-30 17:00:00 | SPY | ETF | 112.92 | 112.94 | 112.92 | 112.94 | 300.0 |
| 2004-03-30 17:30:00 | SPY | ETF | 112.98 | 112.98 | 112.98 | 112.98 | 300.0 |
| 2004-03-30 18:00:00 | SPY | ETF | 112.97 | 112.97 | 112.93 | 112.95 | 1200.0 |
| 2004-03-30 18:30:00 | SPY | ETF | 112.92 | 112.92 | 112.89 | 112.89 | 800.0 |
| 2004-03-30 08:00:00 | QQQ | ETF | 35.65 | 35.69 | 35.64 | 35.67 | 99100.0 |
| 2004-03-30 08:30:00 | QQQ | ETF | 35.69 | 35.69 | 35.63 | 35.66 | 141500.0 |
| 2004-03-30 09:00:00 | QQQ | ETF | 35.66 | 35.68 | 35.66 | 35.67 | 57500.0 |
| 2004-03-30 09:30:00 | QQQ | ETF | 35.67 | 35.86 | 35.6 | 35.82 | 12584700.0 |
| 2004-03-30 10:00:00 | QQQ | ETF | 35.82 | 35.85 | 35.64 | 35.74 | 9321400.0 |
| 2004-03-30 10:30:00 | QQQ | ETF | 35.739 | 35.792 | 35.63 | 35.769 | 5870300.0 |
| 2004-03-30 11:00:00 | QQQ | ETF | 35.77 | 35.85 | 35.69 | 35.78 | 7974200.0 |
| 2004-03-30 11:30:00 | QQQ | ETF | 35.775 | 35.82 | 35.68 | 35.69 | 3939500.0 |
| 2004-03-30 12:00:00 | QQQ | ETF | 35.68 | 35.73 | 35.643 | 35.68 | 5826700.0 |
| 2004-03-30 12:30:00 | QQQ | ETF | 35.687 | 35.7 | 35.517 | 35.59 | 7984300.0 |
| 2004-03-30 13:00:00 | QQQ | ETF | 35.58 | 35.67 | 35.56 | 35.63 | 3558200.0 |
| 2004-03-30 13:30:00 | QQQ | ETF | 35.63 | 35.74 | 35.57 | 35.71 | 3519100.0 |
| 2004-03-30 14:00:00 | QQQ | ETF | 35.72 | 35.76 | 35.66 | 35.71 | 4268800.0 |
| 2004-03-30 14:30:00 | QQQ | ETF | 35.71 | 35.84 | 35.66 | 35.8 | 4550400.0 |
| 2004-03-30 15:00:00 | QQQ | ETF | 35.78 | 35.94 | 35.77 | 35.859 | 9771600.0 |
| 2004-03-30 15:30:00 | QQQ | ETF | 35.86 | 35.9 | 35.81 | 35.9 | 7916100.0 |
| 2004-03-30 16:00:00 | QQQ | ETF | 35.89 | 35.96 | 35.87 | 35.93 | 2730200.0 |
| 2004-03-30 16:30:00 | QQQ | ETF | 35.93 | 35.94 | 35.91 | 35.92 | 2449100.0 |
| 2004-03-30 17:00:00 | QQQ | ETF | 35.925 | 35.94 | 35.91 | 35.938 | 76100.0 |
| 2004-03-30 17:30:00 | QQQ | ETF | 35.92 | 35.94 | 35.92 | 35.93 | 12500.0 |
| 2004-03-30 18:00:00 | QQQ | ETF | 35.94 | 35.94 | 35.63 | 35.91 | 111100.0 |
| 2004-03-30 18:30:00 | QQQ | ETF | 35.91 | 35.91 | 35.91 | 35.91 | 37000.0 |
| 2004-03-30 19:00:00 | QQQ | ETF | 35.9 | 35.9 | 35.89 | 35.89 | 9100.0 |
| 2004-03-30 19:30:00 | QQQ | ETF | 35.88 | 35.89 | 35.87 | 35.88 | 17800.0 |
| 2004-03-30 08:00:00 | IWM | ETF | 58.045 | 58.045 | 58.045 | 58.045 | 600.0 |
| 2004-03-30 09:00:00 | IWM | ETF | 57.995 | 58.01 | 57.96 | 57.96 | 2600.0 |
| 2004-03-30 09:30:00 | IWM | ETF | 58.055 | 58.37 | 58.0 | 58.35 | 1159600.0 |
| 2004-03-30 10:00:00 | IWM | ETF | 58.35 | 58.395 | 58.17 | 58.31 | 707400.0 |
> showing 50 of 1,170 rows — these rows as CSV