PREVIEW / etf_30min / 2002-01-22
file: by_date/etf_30min/2002/2002-01-22.parquet size: 18 KB rows: 467
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-22 09:30:00 | SPY | ETF | 113.75 | 113.87 | 113.55 | 113.7 | 1568100.0 |
| 2002-01-22 10:00:00 | SPY | ETF | 113.68 | 113.93 | 113.42 | 113.44 | 1571300.0 |
| 2002-01-22 10:30:00 | SPY | ETF | 113.43 | 113.46 | 113.03 | 113.17 | 1268700.0 |
| 2002-01-22 11:00:00 | SPY | ETF | 113.18 | 113.2 | 112.84 | 113.01 | 821800.0 |
| 2002-01-22 11:30:00 | SPY | ETF | 113.0 | 113.19 | 112.84 | 112.84 | 424800.0 |
| 2002-01-22 12:00:00 | SPY | ETF | 112.79 | 112.91 | 112.52 | 112.66 | 811400.0 |
| 2002-01-22 12:30:00 | SPY | ETF | 112.67 | 112.97 | 112.6 | 112.97 | 286300.0 |
| 2002-01-22 13:00:00 | SPY | ETF | 112.98 | 112.98 | 112.35 | 112.47 | 617000.0 |
| 2002-01-22 13:30:00 | SPY | ETF | 112.49 | 112.55 | 112.26 | 112.52 | 469400.0 |
| 2002-01-22 14:00:00 | SPY | ETF | 112.52 | 112.68 | 112.2 | 112.3 | 645800.0 |
| 2002-01-22 14:30:00 | SPY | ETF | 112.27 | 112.57 | 112.27 | 112.35 | 533700.0 |
| 2002-01-22 15:00:00 | SPY | ETF | 112.32 | 112.6 | 112.07 | 112.18 | 787100.0 |
| 2002-01-22 15:30:00 | SPY | ETF | 112.16 | 112.41 | 112.02 | 112.25 | 960900.0 |
| 2002-01-22 16:00:00 | SPY | ETF | 112.22 | 112.5 | 112.2 | 112.48 | 599200.0 |
| 2002-01-22 16:30:00 | SPY | ETF | 112.4 | 112.44 | 112.4 | 112.44 | 8000.0 |
| 2002-01-22 17:30:00 | SPY | ETF | 112.42 | 112.47 | 112.4 | 112.47 | 1800.0 |
| 2002-01-22 18:00:00 | SPY | ETF | 112.46 | 112.5 | 112.4 | 112.5 | 1600.0 |
| 2002-01-22 09:30:00 | QQQ | ETF | 39.0 | 39.02 | 38.65 | 38.85 | 9420000.0 |
| 2002-01-22 10:00:00 | QQQ | ETF | 38.83 | 38.99 | 38.45 | 38.47 | 7938700.0 |
| 2002-01-22 10:30:00 | QQQ | ETF | 38.5 | 38.5 | 37.9 | 38.06 | 10106600.0 |
| 2002-01-22 11:00:00 | QQQ | ETF | 38.06 | 38.1 | 37.77 | 37.92 | 8978000.0 |
| 2002-01-22 11:30:00 | QQQ | ETF | 37.91 | 38.05 | 37.79 | 37.79 | 3750400.0 |
| 2002-01-22 12:00:00 | QQQ | ETF | 37.79 | 37.9 | 37.62 | 37.71 | 4493300.0 |
| 2002-01-22 12:30:00 | QQQ | ETF | 37.72 | 37.92 | 37.67 | 37.9 | 3634900.0 |
| 2002-01-22 13:00:00 | QQQ | ETF | 37.88 | 37.92 | 37.48 | 37.56 | 5607900.0 |
| 2002-01-22 13:30:00 | QQQ | ETF | 37.55 | 37.67 | 37.46 | 37.63 | 3829200.0 |
| 2002-01-22 14:00:00 | QQQ | ETF | 37.65 | 37.75 | 37.44 | 37.48 | 3864400.0 |
| 2002-01-22 14:30:00 | QQQ | ETF | 37.52 | 37.67 | 37.45 | 37.48 | 3219400.0 |
| 2002-01-22 15:00:00 | QQQ | ETF | 37.5 | 37.7 | 37.33 | 37.41 | 5358900.0 |
| 2002-01-22 15:30:00 | QQQ | ETF | 37.42 | 37.62 | 37.34 | 37.39 | 8013000.0 |
| 2002-01-22 16:00:00 | QQQ | ETF | 37.4 | 37.47 | 37.28 | 37.35 | 1818800.0 |
| 2002-01-22 16:30:00 | QQQ | ETF | 37.35 | 37.55 | 37.3 | 37.53 | 175900.0 |
| 2002-01-22 17:00:00 | QQQ | ETF | 37.54 | 37.55 | 37.44 | 37.49 | 96600.0 |
| 2002-01-22 17:30:00 | QQQ | ETF | 37.45 | 37.49 | 37.42 | 37.42 | 44200.0 |
| 2002-01-22 18:00:00 | QQQ | ETF | 37.47 | 37.52 | 37.42 | 37.45 | 15900.0 |
| 2002-01-22 09:30:00 | IWM | ETF | 47.375 | 47.545 | 47.265 | 47.4 | 73800.0 |
| 2002-01-22 10:00:00 | IWM | ETF | 47.44 | 47.44 | 47.205 | 47.205 | 120600.0 |
| 2002-01-22 10:30:00 | IWM | ETF | 47.2 | 47.2 | 46.995 | 47.0 | 211600.0 |
| 2002-01-22 11:00:00 | IWM | ETF | 46.995 | 46.995 | 46.86 | 46.95 | 14600.0 |
| 2002-01-22 11:30:00 | IWM | ETF | 46.945 | 47.01 | 46.855 | 46.975 | 111200.0 |
| 2002-01-22 12:00:00 | IWM | ETF | 46.85 | 46.925 | 46.825 | 46.84 | 47400.0 |
| 2002-01-22 12:30:00 | IWM | ETF | 46.9 | 46.97 | 46.855 | 46.97 | 41800.0 |
| 2002-01-22 13:00:00 | IWM | ETF | 46.95 | 46.96 | 46.835 | 46.84 | 92200.0 |
| 2002-01-22 13:30:00 | IWM | ETF | 46.845 | 46.9 | 46.765 | 46.855 | 27000.0 |
| 2002-01-22 14:00:00 | IWM | ETF | 46.89 | 46.92 | 46.785 | 46.785 | 127600.0 |
| 2002-01-22 14:30:00 | IWM | ETF | 46.875 | 46.89 | 46.825 | 46.87 | 13600.0 |
| 2002-01-22 15:00:00 | IWM | ETF | 46.86 | 46.91 | 46.75 | 46.82 | 182200.0 |
| 2002-01-22 15:30:00 | IWM | ETF | 46.75 | 46.8 | 46.675 | 46.725 | 51400.0 |
| 2002-01-22 16:00:00 | IWM | ETF | 46.555 | 46.65 | 46.555 | 46.65 | 145800.0 |
| 2002-01-22 09:30:00 | DIA | ETF | 98.34 | 98.55 | 98.13 | 98.32 | 188700.0 |
> showing 50 of 467 rows — these rows as CSV