PREVIEW / etf_30min / 2003-01-28
file: by_date/etf_30min/2003/2003-01-28.parquet size: 23 KB rows: 676
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-28 08:00:00 | SPY | ETF | 85.17 | 85.25 | 85.0 | 85.2 | 30800.0 |
| 2003-01-28 08:30:00 | SPY | ETF | 85.26 | 85.52 | 85.02 | 85.52 | 68900.0 |
| 2003-01-28 09:00:00 | SPY | ETF | 85.54 | 85.75 | 85.5 | 85.69 | 88600.0 |
| 2003-01-28 09:30:00 | SPY | ETF | 85.6 | 85.87 | 85.38 | 85.5 | 4700600.0 |
| 2003-01-28 10:00:00 | SPY | ETF | 85.48 | 86.1 | 85.3 | 85.85 | 8365000.0 |
| 2003-01-28 10:30:00 | SPY | ETF | 85.87 | 85.99 | 85.13 | 85.2 | 3376300.0 |
| 2003-01-28 11:00:00 | SPY | ETF | 85.2 | 85.47 | 85.13 | 85.4 | 7275700.0 |
| 2003-01-28 11:30:00 | SPY | ETF | 85.41 | 85.72 | 85.3 | 85.53 | 2480700.0 |
| 2003-01-28 12:00:00 | SPY | ETF | 85.54 | 85.67 | 85.24 | 85.31 | 1045100.0 |
| 2003-01-28 12:30:00 | SPY | ETF | 85.29 | 85.64 | 85.24 | 85.54 | 728500.0 |
| 2003-01-28 13:00:00 | SPY | ETF | 85.57 | 85.82 | 85.53 | 85.74 | 1457400.0 |
| 2003-01-28 13:30:00 | SPY | ETF | 85.74 | 85.92 | 85.62 | 85.9 | 1139500.0 |
| 2003-01-28 14:00:00 | SPY | ETF | 85.89 | 86.26 | 85.86 | 86.09 | 4223100.0 |
| 2003-01-28 14:30:00 | SPY | ETF | 86.19 | 86.24 | 85.9 | 85.97 | 2028700.0 |
| 2003-01-28 15:00:00 | SPY | ETF | 85.97 | 86.23 | 85.76 | 86.19 | 2439400.0 |
| 2003-01-28 15:30:00 | SPY | ETF | 86.22 | 86.4 | 86.08 | 86.11 | 2886100.0 |
| 2003-01-28 16:00:00 | SPY | ETF | 86.1 | 86.12 | 85.77 | 85.89 | 1413500.0 |
| 2003-01-28 16:30:00 | SPY | ETF | 85.88 | 86.0 | 85.85 | 85.94 | 129100.0 |
| 2003-01-28 17:00:00 | SPY | ETF | 85.92 | 85.99 | 85.91 | 85.97 | 102800.0 |
| 2003-01-28 17:30:00 | SPY | ETF | 85.97 | 85.98 | 85.91 | 85.92 | 4900.0 |
| 2003-01-28 18:00:00 | SPY | ETF | 85.95 | 86.0 | 85.93 | 85.93 | 10200.0 |
| 2003-01-28 18:30:00 | SPY | ETF | 85.95 | 85.95 | 85.92 | 85.92 | 4900.0 |
| 2003-01-28 19:00:00 | SPY | ETF | 85.95 | 85.95 | 85.9 | 85.9 | 2200.0 |
| 2003-01-28 19:30:00 | SPY | ETF | 85.91 | 85.95 | 85.91 | 85.91 | 2000.0 |
| 2003-01-28 08:00:00 | QQQ | ETF | 24.6 | 24.69 | 24.56 | 24.69 | 43300.0 |
| 2003-01-28 08:30:00 | QQQ | ETF | 24.69 | 24.76 | 24.61 | 24.76 | 76700.0 |
| 2003-01-28 09:00:00 | QQQ | ETF | 24.77 | 24.85 | 24.76 | 24.78 | 117000.0 |
| 2003-01-28 09:30:00 | QQQ | ETF | 24.76 | 24.87 | 24.63 | 24.69 | 9347800.0 |
| 2003-01-28 10:00:00 | QQQ | ETF | 24.73 | 24.91 | 24.46 | 24.74 | 9960600.0 |
| 2003-01-28 10:30:00 | QQQ | ETF | 24.75 | 24.77 | 24.42 | 24.46 | 5324300.0 |
| 2003-01-28 11:00:00 | QQQ | ETF | 24.45 | 24.63 | 24.44 | 24.63 | 3563400.0 |
| 2003-01-28 11:30:00 | QQQ | ETF | 24.63 | 24.73 | 24.59 | 24.65 | 2870900.0 |
| 2003-01-28 12:00:00 | QQQ | ETF | 24.63 | 24.69 | 24.54 | 24.55 | 1990100.0 |
| 2003-01-28 12:30:00 | QQQ | ETF | 24.56 | 24.65 | 24.51 | 24.61 | 1403900.0 |
| 2003-01-28 13:00:00 | QQQ | ETF | 24.63 | 24.72 | 24.62 | 24.7 | 1460300.0 |
| 2003-01-28 13:30:00 | QQQ | ETF | 24.71 | 24.78 | 24.66 | 24.77 | 2457400.0 |
| 2003-01-28 14:00:00 | QQQ | ETF | 24.75 | 24.98 | 24.75 | 24.92 | 5928500.0 |
| 2003-01-28 14:30:00 | QQQ | ETF | 24.93 | 24.95 | 24.82 | 24.86 | 2796300.0 |
| 2003-01-28 15:00:00 | QQQ | ETF | 24.85 | 24.98 | 24.78 | 24.93 | 3454500.0 |
| 2003-01-28 15:30:00 | QQQ | ETF | 24.93 | 25.05 | 24.86 | 24.88 | 6722400.0 |
| 2003-01-28 16:00:00 | QQQ | ETF | 24.87 | 24.89 | 24.75 | 24.81 | 1972100.0 |
| 2003-01-28 16:30:00 | QQQ | ETF | 24.79 | 24.85 | 24.79 | 24.83 | 418100.0 |
| 2003-01-28 17:00:00 | QQQ | ETF | 24.82 | 24.85 | 24.8 | 24.83 | 56800.0 |
| 2003-01-28 17:30:00 | QQQ | ETF | 24.83 | 24.85 | 24.82 | 24.84 | 26200.0 |
| 2003-01-28 18:00:00 | QQQ | ETF | 24.84 | 24.89 | 24.83 | 24.87 | 51900.0 |
| 2003-01-28 18:30:00 | QQQ | ETF | 24.86 | 24.89 | 24.85 | 24.86 | 20200.0 |
| 2003-01-28 19:00:00 | QQQ | ETF | 24.86 | 24.87 | 24.85 | 24.85 | 3600.0 |
| 2003-01-28 19:30:00 | QQQ | ETF | 24.85 | 24.85 | 24.8 | 24.81 | 11400.0 |
| 2003-01-28 09:30:00 | IWM | ETF | 36.9 | 36.98 | 36.72 | 36.785 | 250200.0 |
| 2003-01-28 10:00:00 | IWM | ETF | 36.9 | 36.995 | 36.675 | 36.845 | 282800.0 |
> showing 50 of 676 rows — these rows as CSV