PREVIEW / etf_30min / 2004-04-14
file: by_date/etf_30min/2004/2004-04-14.parquet size: 36 KB rows: 1,186
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-14 08:00:00 | SPY | ETF | 113.18 | 113.2 | 113.11 | 113.11 | 2400.0 |
| 2004-04-14 08:30:00 | SPY | ETF | 113.13 | 113.13 | 112.56 | 112.68 | 155000.0 |
| 2004-04-14 09:00:00 | SPY | ETF | 112.65 | 112.66 | 112.5 | 112.63 | 202000.0 |
| 2004-04-14 09:30:00 | SPY | ETF | 112.61 | 113.13 | 112.58 | 113.03 | 4354800.0 |
| 2004-04-14 10:00:00 | SPY | ETF | 113.02 | 113.45 | 112.96 | 113.12 | 5482800.0 |
| 2004-04-14 10:30:00 | SPY | ETF | 113.12 | 113.38 | 113.09 | 113.27 | 2050600.0 |
| 2004-04-14 11:00:00 | SPY | ETF | 113.27 | 113.63 | 113.23 | 113.48 | 3276400.0 |
| 2004-04-14 11:30:00 | SPY | ETF | 113.48 | 113.55 | 113.32 | 113.54 | 2337000.0 |
| 2004-04-14 12:00:00 | SPY | ETF | 113.54 | 113.64 | 113.39 | 113.53 | 1362300.0 |
| 2004-04-14 12:30:00 | SPY | ETF | 113.53 | 113.58 | 113.22 | 113.38 | 1430900.0 |
| 2004-04-14 13:00:00 | SPY | ETF | 113.36 | 113.39 | 113.11 | 113.17 | 1759800.0 |
| 2004-04-14 13:30:00 | SPY | ETF | 113.17 | 113.2888 | 113.14 | 113.24 | 4215900.0 |
| 2004-04-14 14:00:00 | SPY | ETF | 113.23 | 113.24 | 112.76 | 112.82 | 3549600.0 |
| 2004-04-14 14:30:00 | SPY | ETF | 112.82 | 112.96 | 112.62 | 112.92 | 3785700.0 |
| 2004-04-14 15:00:00 | SPY | ETF | 112.92 | 112.95 | 112.56 | 112.83 | 2581400.0 |
| 2004-04-14 15:30:00 | SPY | ETF | 112.85 | 113.17 | 112.65 | 113.15 | 3004600.0 |
| 2004-04-14 16:00:00 | SPY | ETF | 113.15 | 113.51 | 113.12 | 113.42 | 1516900.0 |
| 2004-04-14 16:30:00 | SPY | ETF | 113.41 | 113.6 | 113.4 | 113.54 | 475300.0 |
| 2004-04-14 17:00:00 | SPY | ETF | 113.58 | 113.58 | 113.54 | 113.55 | 800.0 |
| 2004-04-14 17:30:00 | SPY | ETF | 113.65 | 113.65 | 113.56 | 113.56 | 1100.0 |
| 2004-04-14 18:00:00 | SPY | ETF | 113.59 | 113.59 | 113.54 | 113.55 | 11100.0 |
| 2004-04-14 18:30:00 | SPY | ETF | 113.5 | 113.5 | 113.47 | 113.5 | 1400.0 |
| 2004-04-14 19:00:00 | SPY | ETF | 113.54 | 113.55 | 113.54 | 113.55 | 2600.0 |
| 2004-04-14 19:30:00 | SPY | ETF | 113.5 | 113.52 | 113.5 | 113.5 | 1500.0 |
| 2004-04-14 08:00:00 | QQQ | ETF | 36.46 | 36.52 | 36.45 | 36.46 | 30100.0 |
| 2004-04-14 08:30:00 | QQQ | ETF | 36.45 | 36.46 | 36.32 | 36.34 | 429900.0 |
| 2004-04-14 09:00:00 | QQQ | ETF | 36.34 | 36.41 | 36.3 | 36.4 | 309900.0 |
| 2004-04-14 09:30:00 | QQQ | ETF | 36.41 | 36.72 | 36.4 | 36.67 | 10917200.0 |
| 2004-04-14 10:00:00 | QQQ | ETF | 36.673 | 36.83 | 36.62 | 36.69 | 9476400.0 |
| 2004-04-14 10:30:00 | QQQ | ETF | 36.709 | 36.845 | 36.681 | 36.73 | 6067500.0 |
| 2004-04-14 11:00:00 | QQQ | ETF | 36.74 | 36.95 | 36.71 | 36.844 | 5719300.0 |
| 2004-04-14 11:30:00 | QQQ | ETF | 36.84 | 36.853 | 36.755 | 36.813 | 3880200.0 |
| 2004-04-14 12:00:00 | QQQ | ETF | 36.812 | 36.89 | 36.75 | 36.83 | 2309800.0 |
| 2004-04-14 12:30:00 | QQQ | ETF | 36.83 | 36.85 | 36.72 | 36.77 | 3564100.0 |
| 2004-04-14 13:00:00 | QQQ | ETF | 36.777 | 36.79 | 36.64 | 36.66 | 5575300.0 |
| 2004-04-14 13:30:00 | QQQ | ETF | 36.652 | 36.76 | 36.65 | 36.723 | 3258200.0 |
| 2004-04-14 14:00:00 | QQQ | ETF | 36.722 | 36.73 | 36.56 | 36.577 | 5304200.0 |
| 2004-04-14 14:30:00 | QQQ | ETF | 36.58 | 36.71 | 36.55 | 36.6675 | 5949300.0 |
| 2004-04-14 15:00:00 | QQQ | ETF | 36.6611 | 36.69 | 36.44 | 36.55 | 6912100.0 |
| 2004-04-14 15:30:00 | QQQ | ETF | 36.55 | 36.69 | 36.46 | 36.68 | 5396200.0 |
| 2004-04-14 16:00:00 | QQQ | ETF | 36.66 | 36.86 | 36.66 | 36.82 | 3645200.0 |
| 2004-04-14 16:30:00 | QQQ | ETF | 36.8 | 36.93 | 36.8 | 36.882 | 1424500.0 |
| 2004-04-14 17:00:00 | QQQ | ETF | 36.882 | 36.92 | 36.877 | 36.9 | 301500.0 |
| 2004-04-14 17:30:00 | QQQ | ETF | 36.9 | 36.9 | 36.86 | 36.88 | 156800.0 |
| 2004-04-14 18:00:00 | QQQ | ETF | 36.88 | 36.88 | 36.84 | 36.85 | 35600.0 |
| 2004-04-14 18:30:00 | QQQ | ETF | 36.85 | 36.87 | 36.84 | 36.87 | 12200.0 |
| 2004-04-14 19:00:00 | QQQ | ETF | 36.85 | 36.88 | 36.85 | 36.88 | 20800.0 |
| 2004-04-14 19:30:00 | QQQ | ETF | 36.86 | 36.86 | 36.85 | 36.86 | 8600.0 |
| 2004-04-14 08:30:00 | IWM | ETF | 58.2 | 58.2 | 57.9 | 57.9 | 5800.0 |
| 2004-04-14 09:00:00 | IWM | ETF | 57.825 | 57.925 | 57.825 | 57.925 | 6800.0 |
> showing 50 of 1,186 rows — these rows as CSV