PREVIEW / etf_30min / 2002-06-25
file: by_date/etf_30min/2002/2002-06-25.parquet size: 19 KB rows: 504
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-06-25 09:30:00 | SPY | ETF | 100.3 | 100.48 | 99.97 | 100.04 | 2995300.0 |
| 2002-06-25 10:00:00 | SPY | ETF | 100.07 | 100.64 | 99.85 | 100.61 | 2781600.0 |
| 2002-06-25 10:30:00 | SPY | ETF | 100.61 | 100.89 | 100.3 | 100.45 | 2063700.0 |
| 2002-06-25 11:00:00 | SPY | ETF | 100.46 | 100.8 | 100.13 | 100.29 | 2316300.0 |
| 2002-06-25 11:30:00 | SPY | ETF | 100.3 | 100.53 | 100.07 | 100.47 | 1409700.0 |
| 2002-06-25 12:00:00 | SPY | ETF | 100.46 | 100.59 | 100.02 | 100.02 | 871600.0 |
| 2002-06-25 12:30:00 | SPY | ETF | 100.02 | 100.17 | 99.6 | 99.77 | 1676400.0 |
| 2002-06-25 13:00:00 | SPY | ETF | 99.77 | 99.97 | 99.52 | 99.82 | 1079200.0 |
| 2002-06-25 13:30:00 | SPY | ETF | 99.8 | 99.85 | 98.91 | 98.98 | 2044500.0 |
| 2002-06-25 14:00:00 | SPY | ETF | 98.96 | 99.45 | 98.8 | 98.95 | 1887200.0 |
| 2002-06-25 14:30:00 | SPY | ETF | 98.99 | 99.13 | 98.43 | 98.52 | 2353500.0 |
| 2002-06-25 15:00:00 | SPY | ETF | 98.52 | 98.89 | 98.21 | 98.36 | 1821500.0 |
| 2002-06-25 15:30:00 | SPY | ETF | 98.34 | 98.4 | 97.54 | 97.9 | 2404800.0 |
| 2002-06-25 16:00:00 | SPY | ETF | 97.9 | 99.57 | 97.47 | 97.6 | 3161700.0 |
| 2002-06-25 16:30:00 | SPY | ETF | 97.56 | 97.74 | 97.56 | 97.73 | 61400.0 |
| 2002-06-25 17:00:00 | SPY | ETF | 97.57 | 97.62 | 97.5 | 97.53 | 4700.0 |
| 2002-06-25 17:30:00 | SPY | ETF | 97.53 | 100.83 | 97.48 | 100.83 | 33000.0 |
| 2002-06-25 18:00:00 | SPY | ETF | 97.53 | 97.53 | 96.81 | 96.92 | 29800.0 |
| 2002-06-25 09:30:00 | QQQ | ETF | 26.58 | 26.72 | 26.3 | 26.37 | 14420300.0 |
| 2002-06-25 10:00:00 | QQQ | ETF | 26.37 | 26.69 | 26.11 | 26.5 | 12667700.0 |
| 2002-06-25 10:30:00 | QQQ | ETF | 26.5 | 26.59 | 26.27 | 26.34 | 6958600.0 |
| 2002-06-25 11:00:00 | QQQ | ETF | 26.34 | 26.55 | 26.2 | 26.25 | 7525200.0 |
| 2002-06-25 11:30:00 | QQQ | ETF | 26.25 | 26.43 | 26.16 | 26.41 | 3295600.0 |
| 2002-06-25 12:00:00 | QQQ | ETF | 26.41 | 26.45 | 26.1 | 26.19 | 5729300.0 |
| 2002-06-25 12:30:00 | QQQ | ETF | 26.18 | 26.27 | 25.86 | 25.93 | 11948500.0 |
| 2002-06-25 13:00:00 | QQQ | ETF | 25.94 | 26.05 | 25.77 | 25.91 | 5052700.0 |
| 2002-06-25 13:30:00 | QQQ | ETF | 25.91 | 25.96 | 25.52 | 25.59 | 10910500.0 |
| 2002-06-25 14:00:00 | QQQ | ETF | 25.59 | 25.88 | 25.52 | 25.63 | 9274500.0 |
| 2002-06-25 14:30:00 | QQQ | ETF | 25.63 | 25.74 | 25.49 | 25.53 | 7654900.0 |
| 2002-06-25 15:00:00 | QQQ | ETF | 25.53 | 25.72 | 25.43 | 25.51 | 6287800.0 |
| 2002-06-25 15:30:00 | QQQ | ETF | 25.51 | 25.54 | 25.3 | 25.47 | 9243700.0 |
| 2002-06-25 16:00:00 | QQQ | ETF | 25.47 | 25.49 | 25.37 | 25.44 | 3562400.0 |
| 2002-06-25 16:30:00 | QQQ | ETF | 25.4 | 25.5 | 25.4 | 25.43 | 121200.0 |
| 2002-06-25 17:00:00 | QQQ | ETF | 25.46 | 25.48 | 25.3 | 25.38 | 463700.0 |
| 2002-06-25 17:30:00 | QQQ | ETF | 25.38 | 25.39 | 25.35 | 25.38 | 97400.0 |
| 2002-06-25 18:00:00 | QQQ | ETF | 25.39 | 25.4 | 24.5 | 24.99 | 264100.0 |
| 2002-06-25 09:30:00 | IWM | ETF | 45.95 | 46.02 | 45.8 | 45.85 | 82000.0 |
| 2002-06-25 10:00:00 | IWM | ETF | 45.9 | 45.955 | 45.69 | 45.955 | 199200.0 |
| 2002-06-25 10:30:00 | IWM | ETF | 46.015 | 46.175 | 45.905 | 45.925 | 119400.0 |
| 2002-06-25 11:00:00 | IWM | ETF | 45.98 | 46.035 | 45.84 | 45.84 | 42600.0 |
| 2002-06-25 11:30:00 | IWM | ETF | 45.83 | 45.93 | 45.83 | 45.91 | 18000.0 |
| 2002-06-25 12:00:00 | IWM | ETF | 45.95 | 45.97 | 45.82 | 45.825 | 43800.0 |
| 2002-06-25 12:30:00 | IWM | ETF | 45.81 | 45.81 | 45.515 | 45.56 | 82400.0 |
| 2002-06-25 13:00:00 | IWM | ETF | 45.54 | 45.63 | 45.505 | 45.53 | 34400.0 |
| 2002-06-25 13:30:00 | IWM | ETF | 45.505 | 45.545 | 45.135 | 45.225 | 179800.0 |
| 2002-06-25 14:00:00 | IWM | ETF | 45.15 | 45.27 | 45.135 | 45.135 | 86800.0 |
| 2002-06-25 14:30:00 | IWM | ETF | 45.1 | 45.175 | 45.005 | 45.005 | 107600.0 |
| 2002-06-25 15:00:00 | IWM | ETF | 45.09 | 45.12 | 44.99 | 44.99 | 69200.0 |
| 2002-06-25 15:30:00 | IWM | ETF | 44.955 | 45.03 | 44.78 | 44.975 | 175800.0 |
| 2002-06-25 16:00:00 | IWM | ETF | 44.925 | 45.01 | 44.85 | 44.85 | 37000.0 |
> showing 50 of 504 rows — these rows as CSV