PREVIEW / etf_30min / 2002-06-03
file: by_date/etf_30min/2002/2002-06-03.parquet size: 19 KB rows: 519
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-03 09:30:00 | SPY | ETF | 107.09 | 107.32 | 106.89 | 107.13 | 2321400.0 |
| 2002-06-03 10:00:00 | SPY | ETF | 107.15 | 107.6 | 106.52 | 106.63 | 3799100.0 |
| 2002-06-03 10:30:00 | SPY | ETF | 106.63 | 106.75 | 106.06 | 106.1 | 1560500.0 |
| 2002-06-03 11:00:00 | SPY | ETF | 106.1 | 106.26 | 105.75 | 106.15 | 999500.0 |
| 2002-06-03 11:30:00 | SPY | ETF | 106.1 | 106.18 | 105.82 | 106.02 | 416200.0 |
| 2002-06-03 12:00:00 | SPY | ETF | 105.95 | 105.98 | 105.55 | 105.77 | 1365200.0 |
| 2002-06-03 12:30:00 | SPY | ETF | 105.76 | 106.06 | 105.69 | 105.96 | 689600.0 |
| 2002-06-03 13:00:00 | SPY | ETF | 105.97 | 106.09 | 105.7 | 105.78 | 759900.0 |
| 2002-06-03 13:30:00 | SPY | ETF | 105.77 | 106.09 | 105.5 | 105.91 | 1342100.0 |
| 2002-06-03 14:00:00 | SPY | ETF | 105.97 | 106.08 | 105.79 | 105.98 | 1168000.0 |
| 2002-06-03 14:30:00 | SPY | ETF | 105.97 | 106.18 | 105.74 | 105.82 | 1342200.0 |
| 2002-06-03 15:00:00 | SPY | ETF | 105.84 | 105.97 | 105.53 | 105.56 | 1243800.0 |
| 2002-06-03 15:30:00 | SPY | ETF | 105.58 | 105.64 | 104.25 | 104.3 | 5313100.0 |
| 2002-06-03 16:00:00 | SPY | ETF | 104.25 | 105.2 | 104.13 | 104.37 | 1762300.0 |
| 2002-06-03 16:30:00 | SPY | ETF | 104.3 | 104.42 | 104.29 | 104.42 | 89800.0 |
| 2002-06-03 17:00:00 | SPY | ETF | 104.38 | 104.45 | 104.37 | 104.42 | 52300.0 |
| 2002-06-03 17:30:00 | SPY | ETF | 104.41 | 104.48 | 104.37 | 104.37 | 16600.0 |
| 2002-06-03 18:00:00 | SPY | ETF | 104.52 | 104.61 | 104.47 | 104.61 | 800.0 |
| 2002-06-03 09:30:00 | QQQ | ETF | 30.0 | 30.06 | 29.86 | 29.93 | 7496700.0 |
| 2002-06-03 10:00:00 | QQQ | ETF | 29.93 | 30.25 | 29.62 | 29.65 | 11620600.0 |
| 2002-06-03 10:30:00 | QQQ | ETF | 29.68 | 29.73 | 29.36 | 29.39 | 7706100.0 |
| 2002-06-03 11:00:00 | QQQ | ETF | 29.44 | 29.5 | 29.27 | 29.45 | 4432000.0 |
| 2002-06-03 11:30:00 | QQQ | ETF | 29.45 | 29.49 | 29.31 | 29.41 | 2537400.0 |
| 2002-06-03 12:00:00 | QQQ | ETF | 29.4 | 29.43 | 29.2 | 29.26 | 4974800.0 |
| 2002-06-03 12:30:00 | QQQ | ETF | 29.26 | 29.44 | 29.24 | 29.41 | 2457100.0 |
| 2002-06-03 13:00:00 | QQQ | ETF | 29.4 | 29.47 | 29.29 | 29.36 | 2714900.0 |
| 2002-06-03 13:30:00 | QQQ | ETF | 29.34 | 29.48 | 29.2 | 29.38 | 3415500.0 |
| 2002-06-03 14:00:00 | QQQ | ETF | 29.38 | 29.46 | 29.26 | 29.38 | 3319300.0 |
| 2002-06-03 14:30:00 | QQQ | ETF | 29.37 | 29.54 | 29.27 | 29.3 | 3921900.0 |
| 2002-06-03 15:00:00 | QQQ | ETF | 29.31 | 29.36 | 29.12 | 29.15 | 4891000.0 |
| 2002-06-03 15:30:00 | QQQ | ETF | 29.15 | 29.21 | 28.79 | 28.85 | 10637900.0 |
| 2002-06-03 16:00:00 | QQQ | ETF | 28.86 | 29.0 | 28.81 | 28.94 | 2924400.0 |
| 2002-06-03 16:30:00 | QQQ | ETF | 28.95 | 28.97 | 28.91 | 28.95 | 173400.0 |
| 2002-06-03 17:00:00 | QQQ | ETF | 28.92 | 28.96 | 28.91 | 28.91 | 20200.0 |
| 2002-06-03 17:30:00 | QQQ | ETF | 28.94 | 28.95 | 28.89 | 28.89 | 29800.0 |
| 2002-06-03 18:00:00 | QQQ | ETF | 28.9 | 28.98 | 28.9 | 28.96 | 29200.0 |
| 2002-06-03 09:30:00 | IWM | ETF | 48.475 | 48.475 | 48.21 | 48.4 | 42800.0 |
| 2002-06-03 10:00:00 | IWM | ETF | 48.365 | 48.475 | 47.925 | 47.95 | 115400.0 |
| 2002-06-03 10:30:00 | IWM | ETF | 47.905 | 47.905 | 47.6 | 47.725 | 533800.0 |
| 2002-06-03 11:00:00 | IWM | ETF | 47.7 | 47.7 | 47.6 | 47.7 | 60800.0 |
| 2002-06-03 11:30:00 | IWM | ETF | 47.7 | 47.775 | 47.605 | 47.65 | 35600.0 |
| 2002-06-03 12:00:00 | IWM | ETF | 47.6 | 47.6 | 47.525 | 47.55 | 265400.0 |
| 2002-06-03 12:30:00 | IWM | ETF | 47.55 | 47.63 | 47.55 | 47.625 | 117200.0 |
| 2002-06-03 13:00:00 | IWM | ETF | 47.615 | 47.665 | 47.61 | 47.62 | 49000.0 |
| 2002-06-03 13:30:00 | IWM | ETF | 47.62 | 47.715 | 47.58 | 47.675 | 292400.0 |
| 2002-06-03 14:00:00 | IWM | ETF | 47.72 | 47.74 | 47.655 | 47.67 | 5600.0 |
| 2002-06-03 14:30:00 | IWM | ETF | 47.74 | 47.79 | 47.67 | 47.68 | 49600.0 |
| 2002-06-03 15:00:00 | IWM | ETF | 47.7 | 47.7 | 47.59 | 47.625 | 20600.0 |
| 2002-06-03 15:30:00 | IWM | ETF | 47.64 | 47.64 | 47.145 | 47.145 | 122200.0 |
| 2002-06-03 16:00:00 | IWM | ETF | 47.08 | 47.5 | 47.08 | 47.125 | 130200.0 |
> showing 50 of 519 rows — these rows as CSV