PREVIEW / etf_30min / 2002-06-04
file: by_date/etf_30min/2002/2002-06-04.parquet size: 19 KB rows: 530
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-04 09:30:00 | SPY | ETF | 104.15 | 104.45 | 103.77 | 104.33 | 4369600.0 |
| 2002-06-04 10:00:00 | SPY | ETF | 104.33 | 104.71 | 103.92 | 104.2 | 2211000.0 |
| 2002-06-04 10:30:00 | SPY | ETF | 104.22 | 104.28 | 103.9 | 104.04 | 761800.0 |
| 2002-06-04 11:00:00 | SPY | ETF | 104.08 | 104.42 | 103.7 | 103.78 | 1289200.0 |
| 2002-06-04 11:30:00 | SPY | ETF | 103.76 | 104.18 | 103.72 | 104.05 | 978900.0 |
| 2002-06-04 12:00:00 | SPY | ETF | 104.07 | 104.18 | 103.9 | 103.94 | 535800.0 |
| 2002-06-04 12:30:00 | SPY | ETF | 103.92 | 103.97 | 103.55 | 103.73 | 1090300.0 |
| 2002-06-04 13:00:00 | SPY | ETF | 103.7 | 104.11 | 103.65 | 103.92 | 1209900.0 |
| 2002-06-04 13:30:00 | SPY | ETF | 103.95 | 104.62 | 103.92 | 104.55 | 1983900.0 |
| 2002-06-04 14:00:00 | SPY | ETF | 104.6 | 105.15 | 104.23 | 105.11 | 2201200.0 |
| 2002-06-04 14:30:00 | SPY | ETF | 105.12 | 105.2 | 104.25 | 104.34 | 1407600.0 |
| 2002-06-04 15:00:00 | SPY | ETF | 104.32 | 104.42 | 103.9 | 103.92 | 1656300.0 |
| 2002-06-04 15:30:00 | SPY | ETF | 103.91 | 104.67 | 103.57 | 104.41 | 2941400.0 |
| 2002-06-04 16:00:00 | SPY | ETF | 104.49 | 104.75 | 104.26 | 104.68 | 1358800.0 |
| 2002-06-04 16:30:00 | SPY | ETF | 104.68 | 104.77 | 104.58 | 104.77 | 50400.0 |
| 2002-06-04 17:00:00 | SPY | ETF | 104.8 | 104.82 | 104.7 | 104.79 | 2800.0 |
| 2002-06-04 17:30:00 | SPY | ETF | 104.79 | 104.85 | 104.7 | 104.7 | 3100.0 |
| 2002-06-04 18:00:00 | SPY | ETF | 104.71 | 104.89 | 104.71 | 104.89 | 12300.0 |
| 2002-06-04 09:30:00 | QQQ | ETF | 28.75 | 29.1 | 28.65 | 29.06 | 14203200.0 |
| 2002-06-04 10:00:00 | QQQ | ETF | 29.08 | 29.22 | 28.75 | 28.91 | 8720500.0 |
| 2002-06-04 10:30:00 | QQQ | ETF | 28.88 | 28.95 | 28.7 | 28.8 | 5736800.0 |
| 2002-06-04 11:00:00 | QQQ | ETF | 28.8 | 29.07 | 28.7 | 28.76 | 6159700.0 |
| 2002-06-04 11:30:00 | QQQ | ETF | 28.75 | 29.0 | 28.72 | 28.9 | 3224200.0 |
| 2002-06-04 12:00:00 | QQQ | ETF | 28.9 | 28.98 | 28.79 | 28.82 | 2683100.0 |
| 2002-06-04 12:30:00 | QQQ | ETF | 28.81 | 28.83 | 28.61 | 28.65 | 4441600.0 |
| 2002-06-04 13:00:00 | QQQ | ETF | 28.65 | 28.95 | 28.65 | 28.88 | 3451100.0 |
| 2002-06-04 13:30:00 | QQQ | ETF | 28.87 | 29.34 | 28.82 | 29.3 | 8604000.0 |
| 2002-06-04 14:00:00 | QQQ | ETF | 29.26 | 29.64 | 29.13 | 29.64 | 9252300.0 |
| 2002-06-04 14:30:00 | QQQ | ETF | 29.65 | 29.68 | 29.1 | 29.12 | 6887700.0 |
| 2002-06-04 15:00:00 | QQQ | ETF | 29.16 | 29.31 | 28.85 | 28.85 | 8972600.0 |
| 2002-06-04 15:30:00 | QQQ | ETF | 28.85 | 29.35 | 28.74 | 29.34 | 10002700.0 |
| 2002-06-04 16:00:00 | QQQ | ETF | 29.35 | 29.44 | 28.74 | 29.35 | 1640700.0 |
| 2002-06-04 16:30:00 | QQQ | ETF | 29.35 | 29.4 | 29.3 | 29.37 | 63800.0 |
| 2002-06-04 17:00:00 | QQQ | ETF | 29.37 | 29.38 | 29.32 | 29.33 | 67600.0 |
| 2002-06-04 17:30:00 | QQQ | ETF | 29.35 | 29.38 | 29.33 | 29.34 | 47300.0 |
| 2002-06-04 18:00:00 | QQQ | ETF | 29.36 | 29.4 | 29.32 | 29.38 | 31300.0 |
| 2002-06-04 09:30:00 | IWM | ETF | 47.05 | 47.3 | 47.05 | 47.185 | 316800.0 |
| 2002-06-04 10:00:00 | IWM | ETF | 47.195 | 47.4 | 47.05 | 47.05 | 121600.0 |
| 2002-06-04 10:30:00 | IWM | ETF | 47.07 | 47.15 | 46.97 | 46.995 | 325400.0 |
| 2002-06-04 11:00:00 | IWM | ETF | 47.0 | 47.075 | 46.85 | 46.965 | 241800.0 |
| 2002-06-04 11:30:00 | IWM | ETF | 46.895 | 46.935 | 46.85 | 46.875 | 116000.0 |
| 2002-06-04 12:00:00 | IWM | ETF | 46.905 | 46.915 | 46.805 | 46.85 | 297600.0 |
| 2002-06-04 12:30:00 | IWM | ETF | 46.8 | 46.8 | 46.51 | 46.51 | 173400.0 |
| 2002-06-04 13:00:00 | IWM | ETF | 46.505 | 46.72 | 46.505 | 46.72 | 53000.0 |
| 2002-06-04 13:30:00 | IWM | ETF | 46.68 | 46.925 | 46.68 | 46.88 | 279000.0 |
| 2002-06-04 14:00:00 | IWM | ETF | 46.88 | 47.215 | 46.795 | 47.2 | 555400.0 |
| 2002-06-04 14:30:00 | IWM | ETF | 47.15 | 47.355 | 47.0 | 47.005 | 436800.0 |
| 2002-06-04 15:00:00 | IWM | ETF | 47.035 | 47.11 | 46.845 | 46.845 | 185200.0 |
| 2002-06-04 15:30:00 | IWM | ETF | 46.8 | 47.2 | 46.675 | 47.2 | 730000.0 |
| 2002-06-04 16:00:00 | IWM | ETF | 47.13 | 47.15 | 46.84 | 46.84 | 261800.0 |
> showing 50 of 530 rows — these rows as CSV