PREVIEW / etf_30min / 2002-05-24
file: by_date/etf_30min/2002/2002-05-24.parquet size: 18 KB rows: 501
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-05-24 09:30:00 | SPY | ETF | 109.98 | 110.1 | 109.66 | 109.98 | 1069500.0 |
| 2002-05-24 10:00:00 | SPY | ETF | 109.99 | 110.2 | 109.55 | 109.76 | 1332000.0 |
| 2002-05-24 10:30:00 | SPY | ETF | 109.77 | 109.82 | 109.24 | 109.3 | 881100.0 |
| 2002-05-24 11:00:00 | SPY | ETF | 109.31 | 109.45 | 109.12 | 109.39 | 755700.0 |
| 2002-05-24 11:30:00 | SPY | ETF | 109.39 | 109.5 | 109.34 | 109.38 | 567000.0 |
| 2002-05-24 12:00:00 | SPY | ETF | 109.35 | 109.5 | 109.26 | 109.37 | 313400.0 |
| 2002-05-24 12:30:00 | SPY | ETF | 109.37 | 109.4 | 109.2 | 109.22 | 620300.0 |
| 2002-05-24 13:00:00 | SPY | ETF | 109.22 | 109.49 | 109.18 | 109.32 | 327400.0 |
| 2002-05-24 13:30:00 | SPY | ETF | 109.33 | 109.38 | 108.97 | 109.0 | 682600.0 |
| 2002-05-24 14:00:00 | SPY | ETF | 108.97 | 109.09 | 108.9 | 108.95 | 716300.0 |
| 2002-05-24 14:30:00 | SPY | ETF | 108.93 | 109.0 | 108.66 | 108.79 | 740500.0 |
| 2002-05-24 15:00:00 | SPY | ETF | 108.76 | 109.14 | 108.69 | 109.13 | 1039300.0 |
| 2002-05-24 15:30:00 | SPY | ETF | 109.14 | 109.27 | 108.78 | 108.78 | 1330500.0 |
| 2002-05-24 16:00:00 | SPY | ETF | 108.85 | 108.97 | 108.61 | 108.7 | 1467700.0 |
| 2002-05-24 16:30:00 | SPY | ETF | 108.71 | 108.85 | 108.67 | 108.85 | 5200.0 |
| 2002-05-24 17:30:00 | SPY | ETF | 108.67 | 108.67 | 108.67 | 108.67 | 200.0 |
| 2002-05-24 18:00:00 | SPY | ETF | 108.69 | 108.7 | 108.66 | 108.66 | 700.0 |
| 2002-05-24 09:30:00 | QQQ | ETF | 31.59 | 31.69 | 31.28 | 31.47 | 9590800.0 |
| 2002-05-24 10:00:00 | QQQ | ETF | 31.5 | 31.58 | 31.23 | 31.39 | 7627000.0 |
| 2002-05-24 10:30:00 | QQQ | ETF | 31.39 | 31.45 | 31.13 | 31.24 | 4885400.0 |
| 2002-05-24 11:00:00 | QQQ | ETF | 31.24 | 31.39 | 31.15 | 31.34 | 3909800.0 |
| 2002-05-24 11:30:00 | QQQ | ETF | 31.36 | 31.37 | 31.2 | 31.23 | 1919900.0 |
| 2002-05-24 12:00:00 | QQQ | ETF | 31.23 | 31.3 | 31.14 | 31.25 | 1864600.0 |
| 2002-05-24 12:30:00 | QQQ | ETF | 31.25 | 31.31 | 31.23 | 31.28 | 1316700.0 |
| 2002-05-24 13:00:00 | QQQ | ETF | 31.25 | 31.4 | 31.25 | 31.31 | 1577200.0 |
| 2002-05-24 13:30:00 | QQQ | ETF | 31.32 | 31.35 | 31.1 | 31.1 | 3110400.0 |
| 2002-05-24 14:00:00 | QQQ | ETF | 31.11 | 31.19 | 31.07 | 31.14 | 2160700.0 |
| 2002-05-24 14:30:00 | QQQ | ETF | 31.13 | 31.18 | 31.01 | 31.06 | 2632200.0 |
| 2002-05-24 15:00:00 | QQQ | ETF | 31.06 | 31.4 | 31.03 | 31.38 | 3961300.0 |
| 2002-05-24 15:30:00 | QQQ | ETF | 31.39 | 31.47 | 31.15 | 31.23 | 9213200.0 |
| 2002-05-24 16:00:00 | QQQ | ETF | 31.23 | 31.52 | 31.18 | 31.23 | 1888400.0 |
| 2002-05-24 16:30:00 | QQQ | ETF | 31.2 | 31.2 | 31.17 | 31.2 | 11400.0 |
| 2002-05-24 17:00:00 | QQQ | ETF | 31.2 | 31.24 | 31.18 | 31.22 | 4700.0 |
| 2002-05-24 17:30:00 | QQQ | ETF | 31.2 | 32.13 | 31.18 | 31.18 | 8000.0 |
| 2002-05-24 18:00:00 | QQQ | ETF | 31.2 | 31.33 | 31.2 | 31.33 | 23000.0 |
| 2002-05-24 09:30:00 | IWM | ETF | 49.75 | 49.82 | 49.55 | 49.725 | 109200.0 |
| 2002-05-24 10:00:00 | IWM | ETF | 49.8 | 49.8 | 49.615 | 49.665 | 90000.0 |
| 2002-05-24 10:30:00 | IWM | ETF | 49.655 | 49.725 | 49.575 | 49.575 | 75800.0 |
| 2002-05-24 11:00:00 | IWM | ETF | 49.58 | 49.665 | 49.55 | 49.665 | 125000.0 |
| 2002-05-24 11:30:00 | IWM | ETF | 49.665 | 49.695 | 49.65 | 49.67 | 185000.0 |
| 2002-05-24 12:00:00 | IWM | ETF | 49.665 | 49.665 | 49.605 | 49.615 | 48200.0 |
| 2002-05-24 12:30:00 | IWM | ETF | 49.61 | 49.725 | 49.61 | 49.65 | 204400.0 |
| 2002-05-24 13:00:00 | IWM | ETF | 49.725 | 49.825 | 49.65 | 49.7 | 72000.0 |
| 2002-05-24 13:30:00 | IWM | ETF | 49.765 | 49.775 | 49.655 | 49.695 | 134000.0 |
| 2002-05-24 14:00:00 | IWM | ETF | 49.725 | 49.725 | 49.64 | 49.68 | 65000.0 |
| 2002-05-24 14:30:00 | IWM | ETF | 49.68 | 49.7 | 49.555 | 49.555 | 152000.0 |
| 2002-05-24 15:00:00 | IWM | ETF | 49.56 | 49.63 | 49.525 | 49.625 | 94400.0 |
| 2002-05-24 15:30:00 | IWM | ETF | 49.65 | 49.69 | 49.215 | 49.215 | 224600.0 |
| 2002-05-24 16:00:00 | IWM | ETF | 49.275 | 49.3 | 49.185 | 49.185 | 24800.0 |
| 2002-05-24 09:30:00 | DIA | ETF | 102.0 | 102.3 | 101.84 | 102.3 | 217200.0 |
> showing 50 of 501 rows — these rows as CSV