PREVIEW / etf_30min / 2002-01-24
file: by_date/etf_30min/2002/2002-01-24.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-24 09:30:00 | SPY | ETF | 113.64 | 113.93 | 113.5 | 113.78 | 1816600.0 |
| 2002-01-24 10:00:00 | SPY | ETF | 113.83 | 114.25 | 113.8 | 113.84 | 2147400.0 |
| 2002-01-24 10:30:00 | SPY | ETF | 113.8 | 113.98 | 113.64 | 113.91 | 1018100.0 |
| 2002-01-24 11:00:00 | SPY | ETF | 113.87 | 113.96 | 113.66 | 113.86 | 575300.0 |
| 2002-01-24 11:30:00 | SPY | ETF | 113.87 | 114.13 | 113.7 | 114.04 | 406800.0 |
| 2002-01-24 12:00:00 | SPY | ETF | 114.0 | 114.21 | 113.86 | 114.02 | 577000.0 |
| 2002-01-24 12:30:00 | SPY | ETF | 113.98 | 114.15 | 113.9 | 114.02 | 306900.0 |
| 2002-01-24 13:00:00 | SPY | ETF | 114.04 | 114.05 | 113.75 | 113.78 | 388100.0 |
| 2002-01-24 13:30:00 | SPY | ETF | 113.77 | 113.99 | 113.4 | 113.45 | 828700.0 |
| 2002-01-24 14:00:00 | SPY | ETF | 113.46 | 113.71 | 113.37 | 113.68 | 586100.0 |
| 2002-01-24 14:30:00 | SPY | ETF | 113.68 | 113.8 | 113.52 | 113.62 | 462800.0 |
| 2002-01-24 15:00:00 | SPY | ETF | 113.66 | 113.85 | 113.4 | 113.58 | 488600.0 |
| 2002-01-24 15:30:00 | SPY | ETF | 113.59 | 113.77 | 113.32 | 113.54 | 1485900.0 |
| 2002-01-24 16:00:00 | SPY | ETF | 113.48 | 113.72 | 113.35 | 113.55 | 728500.0 |
| 2002-01-24 16:30:00 | SPY | ETF | 113.5 | 113.65 | 113.4 | 113.45 | 109400.0 |
| 2002-01-24 17:00:00 | SPY | ETF | 113.54 | 113.54 | 113.47 | 113.47 | 1700.0 |
| 2002-01-24 17:30:00 | SPY | ETF | 113.59 | 113.62 | 113.46 | 113.47 | 19700.0 |
| 2002-01-24 18:00:00 | SPY | ETF | 113.4 | 113.55 | 113.4 | 113.43 | 700.0 |
| 2002-01-24 09:30:00 | QQQ | ETF | 38.94 | 39.3 | 38.85 | 39.12 | 9579200.0 |
| 2002-01-24 10:00:00 | QQQ | ETF | 39.13 | 39.51 | 39.05 | 39.09 | 13763100.0 |
| 2002-01-24 10:30:00 | QQQ | ETF | 39.05 | 39.25 | 38.92 | 39.21 | 8657500.0 |
| 2002-01-24 11:00:00 | QQQ | ETF | 39.2 | 39.26 | 39.08 | 39.18 | 4368500.0 |
| 2002-01-24 11:30:00 | QQQ | ETF | 39.15 | 39.36 | 39.05 | 39.27 | 3402400.0 |
| 2002-01-24 12:00:00 | QQQ | ETF | 39.27 | 39.36 | 39.12 | 39.21 | 2600900.0 |
| 2002-01-24 12:30:00 | QQQ | ETF | 39.2 | 39.32 | 39.18 | 39.27 | 2175800.0 |
| 2002-01-24 13:00:00 | QQQ | ETF | 39.26 | 39.28 | 39.03 | 39.04 | 2420800.0 |
| 2002-01-24 13:30:00 | QQQ | ETF | 39.03 | 39.2 | 38.85 | 38.88 | 5463600.0 |
| 2002-01-24 14:00:00 | QQQ | ETF | 38.88 | 39.08 | 38.77 | 39.01 | 3688900.0 |
| 2002-01-24 14:30:00 | QQQ | ETF | 39.05 | 39.14 | 38.89 | 39.04 | 3057000.0 |
| 2002-01-24 15:00:00 | QQQ | ETF | 39.04 | 39.25 | 39.04 | 39.14 | 3995700.0 |
| 2002-01-24 15:30:00 | QQQ | ETF | 39.1 | 39.21 | 38.86 | 38.96 | 5692000.0 |
| 2002-01-24 16:00:00 | QQQ | ETF | 38.96 | 39.09 | 38.88 | 38.89 | 1374700.0 |
| 2002-01-24 16:30:00 | QQQ | ETF | 38.92 | 39.06 | 38.46 | 38.61 | 1426800.0 |
| 2002-01-24 17:00:00 | QQQ | ETF | 38.61 | 38.96 | 38.59 | 38.71 | 4036200.0 |
| 2002-01-24 17:30:00 | QQQ | ETF | 38.7 | 38.93 | 38.65 | 38.65 | 94500.0 |
| 2002-01-24 18:00:00 | QQQ | ETF | 38.65 | 38.67 | 38.57 | 38.59 | 75700.0 |
| 2002-01-24 09:30:00 | IWM | ETF | 47.55 | 47.765 | 47.55 | 47.66 | 40400.0 |
| 2002-01-24 10:00:00 | IWM | ETF | 47.75 | 47.89 | 47.68 | 47.75 | 40800.0 |
| 2002-01-24 10:30:00 | IWM | ETF | 47.8 | 47.875 | 47.65 | 47.75 | 290200.0 |
| 2002-01-24 11:00:00 | IWM | ETF | 47.775 | 47.775 | 47.725 | 47.75 | 2000.0 |
| 2002-01-24 11:30:00 | IWM | ETF | 47.745 | 47.825 | 47.7 | 47.74 | 14800.0 |
| 2002-01-24 12:00:00 | IWM | ETF | 47.875 | 47.875 | 47.71 | 47.72 | 63400.0 |
| 2002-01-24 12:30:00 | IWM | ETF | 47.815 | 47.815 | 47.715 | 47.72 | 34800.0 |
| 2002-01-24 13:00:00 | IWM | ETF | 47.72 | 47.785 | 47.68 | 47.68 | 152200.0 |
| 2002-01-24 13:30:00 | IWM | ETF | 47.745 | 47.75 | 47.56 | 47.56 | 54000.0 |
| 2002-01-24 14:00:00 | IWM | ETF | 47.55 | 47.675 | 47.55 | 47.675 | 6800.0 |
| 2002-01-24 14:30:00 | IWM | ETF | 47.685 | 47.725 | 47.61 | 47.7 | 26600.0 |
| 2002-01-24 15:00:00 | IWM | ETF | 47.75 | 47.785 | 47.68 | 47.75 | 46800.0 |
| 2002-01-24 15:30:00 | IWM | ETF | 47.745 | 47.775 | 47.63 | 47.65 | 105800.0 |
| 2002-01-24 16:00:00 | IWM | ETF | 47.6 | 47.725 | 47.6 | 47.675 | 70000.0 |
> showing 50 of 467 rows — these rows as CSV