PREVIEW / etf_30min / 2002-06-06
file: by_date/etf_30min/2002/2002-06-06.parquet size: 19 KB rows: 522
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-06 09:30:00 | SPY | ETF | 105.54 | 105.6 | 104.75 | 104.87 | 2184100.0 |
| 2002-06-06 10:00:00 | SPY | ETF | 104.8 | 104.98 | 104.36 | 104.64 | 1982800.0 |
| 2002-06-06 10:30:00 | SPY | ETF | 104.68 | 104.74 | 104.41 | 104.51 | 934700.0 |
| 2002-06-06 11:00:00 | SPY | ETF | 104.51 | 104.59 | 103.85 | 103.95 | 1611100.0 |
| 2002-06-06 11:30:00 | SPY | ETF | 103.95 | 104.09 | 103.7 | 104.09 | 1317100.0 |
| 2002-06-06 12:00:00 | SPY | ETF | 104.1 | 104.23 | 103.86 | 103.92 | 756700.0 |
| 2002-06-06 12:30:00 | SPY | ETF | 103.9 | 104.08 | 103.57 | 103.91 | 1039600.0 |
| 2002-06-06 13:00:00 | SPY | ETF | 103.91 | 104.36 | 103.82 | 104.19 | 1190800.0 |
| 2002-06-06 13:30:00 | SPY | ETF | 104.19 | 104.23 | 103.95 | 104.03 | 568100.0 |
| 2002-06-06 14:00:00 | SPY | ETF | 104.01 | 104.12 | 103.8 | 103.89 | 422700.0 |
| 2002-06-06 14:30:00 | SPY | ETF | 103.86 | 103.95 | 103.15 | 103.39 | 2186600.0 |
| 2002-06-06 15:00:00 | SPY | ETF | 103.4 | 103.7 | 103.21 | 103.7 | 1308800.0 |
| 2002-06-06 15:30:00 | SPY | ETF | 103.68 | 103.7 | 103.3 | 103.42 | 2346400.0 |
| 2002-06-06 16:00:00 | SPY | ETF | 103.45 | 104.05 | 101.9 | 101.9 | 2112300.0 |
| 2002-06-06 16:30:00 | SPY | ETF | 101.95 | 103.46 | 101.81 | 102.2 | 1059000.0 |
| 2002-06-06 17:00:00 | SPY | ETF | 102.2 | 103.5 | 102.15 | 102.2 | 537600.0 |
| 2002-06-06 17:30:00 | SPY | ETF | 102.19 | 103.54 | 101.84 | 102.08 | 362100.0 |
| 2002-06-06 18:00:00 | SPY | ETF | 102.1 | 102.18 | 102.08 | 102.18 | 5700.0 |
| 2002-06-06 09:30:00 | QQQ | ETF | 29.5 | 29.51 | 29.1 | 29.17 | 10964000.0 |
| 2002-06-06 10:00:00 | QQQ | ETF | 29.2 | 29.26 | 28.93 | 29.1 | 11254800.0 |
| 2002-06-06 10:30:00 | QQQ | ETF | 29.09 | 29.17 | 29.0 | 29.09 | 5716100.0 |
| 2002-06-06 11:00:00 | QQQ | ETF | 29.1 | 29.14 | 28.8 | 28.85 | 8605600.0 |
| 2002-06-06 11:30:00 | QQQ | ETF | 28.82 | 28.98 | 28.7 | 28.96 | 7095700.0 |
| 2002-06-06 12:00:00 | QQQ | ETF | 28.96 | 29.09 | 28.85 | 28.92 | 3710400.0 |
| 2002-06-06 12:30:00 | QQQ | ETF | 28.9 | 29.12 | 28.81 | 29.0 | 3063200.0 |
| 2002-06-06 13:00:00 | QQQ | ETF | 29.01 | 29.17 | 28.94 | 29.08 | 3869500.0 |
| 2002-06-06 13:30:00 | QQQ | ETF | 29.08 | 29.13 | 28.94 | 28.99 | 3163200.0 |
| 2002-06-06 14:00:00 | QQQ | ETF | 28.97 | 29.05 | 28.89 | 28.93 | 2928600.0 |
| 2002-06-06 14:30:00 | QQQ | ETF | 28.98 | 29.0 | 28.63 | 28.81 | 8181900.0 |
| 2002-06-06 15:00:00 | QQQ | ETF | 28.82 | 29.02 | 28.72 | 28.97 | 4100000.0 |
| 2002-06-06 15:30:00 | QQQ | ETF | 28.97 | 29.01 | 28.8 | 28.84 | 5507700.0 |
| 2002-06-06 16:00:00 | QQQ | ETF | 28.82 | 28.98 | 27.6 | 27.65 | 3813000.0 |
| 2002-06-06 16:30:00 | QQQ | ETF | 27.65 | 28.35 | 27.5 | 27.98 | 1162600.0 |
| 2002-06-06 17:00:00 | QQQ | ETF | 27.98 | 28.9 | 27.86 | 27.88 | 2235500.0 |
| 2002-06-06 17:30:00 | QQQ | ETF | 27.87 | 28.93 | 27.5 | 27.85 | 2103400.0 |
| 2002-06-06 18:00:00 | QQQ | ETF | 27.85 | 27.86 | 27.72 | 27.85 | 553900.0 |
| 2002-06-06 09:30:00 | IWM | ETF | 47.275 | 47.3 | 46.98 | 46.98 | 34200.0 |
| 2002-06-06 10:00:00 | IWM | ETF | 47.08 | 47.08 | 46.87 | 46.885 | 91000.0 |
| 2002-06-06 10:30:00 | IWM | ETF | 46.895 | 46.96 | 46.7 | 46.82 | 181200.0 |
| 2002-06-06 11:00:00 | IWM | ETF | 46.805 | 46.805 | 46.53 | 46.55 | 112600.0 |
| 2002-06-06 11:30:00 | IWM | ETF | 46.53 | 46.68 | 46.425 | 46.65 | 225800.0 |
| 2002-06-06 12:00:00 | IWM | ETF | 46.675 | 46.7 | 46.6 | 46.66 | 62800.0 |
| 2002-06-06 12:30:00 | IWM | ETF | 46.66 | 46.66 | 46.5 | 46.625 | 42000.0 |
| 2002-06-06 13:00:00 | IWM | ETF | 46.625 | 46.69 | 46.525 | 46.69 | 52800.0 |
| 2002-06-06 13:30:00 | IWM | ETF | 46.775 | 46.775 | 46.525 | 46.525 | 181200.0 |
| 2002-06-06 14:00:00 | IWM | ETF | 46.64 | 46.645 | 46.545 | 46.6 | 17000.0 |
| 2002-06-06 14:30:00 | IWM | ETF | 46.585 | 46.6 | 46.34 | 46.45 | 99200.0 |
| 2002-06-06 15:00:00 | IWM | ETF | 46.435 | 46.47 | 46.36 | 46.41 | 57200.0 |
| 2002-06-06 15:30:00 | IWM | ETF | 46.45 | 46.52 | 46.275 | 46.345 | 90000.0 |
| 2002-06-06 16:00:00 | IWM | ETF | 46.275 | 46.405 | 46.275 | 46.38 | 280800.0 |
> showing 50 of 522 rows — these rows as CSV