PREVIEW / etf_30min / 2002-05-22
file: by_date/etf_30min/2002/2002-05-22.parquet size: 18 KB rows: 517
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-22 09:30:00 | SPY | ETF | 108.22 | 108.64 | 108.18 | 108.56 | 1881100.0 |
| 2002-05-22 10:00:00 | SPY | ETF | 108.57 | 109.08 | 108.53 | 108.84 | 3339700.0 |
| 2002-05-22 10:30:00 | SPY | ETF | 108.81 | 109.02 | 108.3 | 108.45 | 1025800.0 |
| 2002-05-22 11:00:00 | SPY | ETF | 108.41 | 108.7 | 108.27 | 108.42 | 710100.0 |
| 2002-05-22 11:30:00 | SPY | ETF | 108.45 | 108.6 | 108.06 | 108.15 | 705700.0 |
| 2002-05-22 12:00:00 | SPY | ETF | 108.14 | 108.3 | 108.09 | 108.29 | 258500.0 |
| 2002-05-22 12:30:00 | SPY | ETF | 108.29 | 108.59 | 108.21 | 108.44 | 480900.0 |
| 2002-05-22 13:00:00 | SPY | ETF | 108.36 | 108.55 | 108.32 | 108.49 | 302000.0 |
| 2002-05-22 13:30:00 | SPY | ETF | 108.52 | 108.64 | 108.35 | 108.47 | 392100.0 |
| 2002-05-22 14:00:00 | SPY | ETF | 108.49 | 108.65 | 108.16 | 108.32 | 777600.0 |
| 2002-05-22 14:30:00 | SPY | ETF | 108.32 | 108.5 | 108.0 | 108.11 | 775600.0 |
| 2002-05-22 15:00:00 | SPY | ETF | 108.11 | 108.58 | 108.04 | 108.57 | 1289300.0 |
| 2002-05-22 15:30:00 | SPY | ETF | 108.56 | 109.12 | 108.39 | 109.05 | 2821400.0 |
| 2002-05-22 16:00:00 | SPY | ETF | 109.06 | 109.2 | 108.85 | 109.0 | 958800.0 |
| 2002-05-22 16:30:00 | SPY | ETF | 108.92 | 108.95 | 108.85 | 108.85 | 16200.0 |
| 2002-05-22 17:00:00 | SPY | ETF | 108.9 | 108.95 | 108.9 | 108.95 | 1400.0 |
| 2002-05-22 17:30:00 | SPY | ETF | 109.0 | 109.1 | 109.0 | 109.1 | 5600.0 |
| 2002-05-22 18:00:00 | SPY | ETF | 109.02 | 109.02 | 108.92 | 108.96 | 900.0 |
| 2002-05-22 09:30:00 | QQQ | ETF | 30.97 | 31.4 | 30.85 | 31.38 | 14684100.0 |
| 2002-05-22 10:00:00 | QQQ | ETF | 31.38 | 31.59 | 31.25 | 31.31 | 8395400.0 |
| 2002-05-22 10:30:00 | QQQ | ETF | 31.3 | 31.45 | 31.02 | 31.05 | 5561800.0 |
| 2002-05-22 11:00:00 | QQQ | ETF | 31.05 | 31.21 | 30.92 | 31.01 | 5757500.0 |
| 2002-05-22 11:30:00 | QQQ | ETF | 31.02 | 31.1 | 30.82 | 30.91 | 4989300.0 |
| 2002-05-22 12:00:00 | QQQ | ETF | 30.9 | 31.0 | 30.86 | 30.96 | 2004500.0 |
| 2002-05-22 12:30:00 | QQQ | ETF | 30.96 | 31.18 | 30.94 | 30.98 | 3450000.0 |
| 2002-05-22 13:00:00 | QQQ | ETF | 30.98 | 31.08 | 30.96 | 31.02 | 1696200.0 |
| 2002-05-22 13:30:00 | QQQ | ETF | 31.02 | 31.13 | 30.96 | 31.05 | 3261500.0 |
| 2002-05-22 14:00:00 | QQQ | ETF | 31.04 | 31.14 | 30.73 | 30.84 | 5461000.0 |
| 2002-05-22 14:30:00 | QQQ | ETF | 30.84 | 30.92 | 30.65 | 30.69 | 5990100.0 |
| 2002-05-22 15:00:00 | QQQ | ETF | 30.69 | 31.12 | 30.66 | 31.1 | 5580000.0 |
| 2002-05-22 15:30:00 | QQQ | ETF | 31.12 | 31.47 | 30.97 | 31.45 | 15475800.0 |
| 2002-05-22 16:00:00 | QQQ | ETF | 31.45 | 31.5 | 31.26 | 31.28 | 4036100.0 |
| 2002-05-22 16:30:00 | QQQ | ETF | 31.28 | 31.4 | 30.89 | 31.3 | 817000.0 |
| 2002-05-22 17:00:00 | QQQ | ETF | 31.3 | 31.4 | 31.3 | 31.35 | 63500.0 |
| 2002-05-22 17:30:00 | QQQ | ETF | 31.34 | 31.38 | 31.33 | 31.35 | 26200.0 |
| 2002-05-22 18:00:00 | QQQ | ETF | 31.34 | 31.45 | 31.32 | 31.45 | 5600.0 |
| 2002-05-22 09:30:00 | IWM | ETF | 49.15 | 49.375 | 49.105 | 49.375 | 100800.0 |
| 2002-05-22 10:00:00 | IWM | ETF | 49.4 | 49.59 | 49.36 | 49.44 | 211600.0 |
| 2002-05-22 10:30:00 | IWM | ETF | 49.4 | 49.45 | 49.155 | 49.225 | 73800.0 |
| 2002-05-22 11:00:00 | IWM | ETF | 49.11 | 49.25 | 49.03 | 49.1 | 114000.0 |
| 2002-05-22 11:30:00 | IWM | ETF | 49.1 | 49.1 | 48.925 | 48.93 | 245000.0 |
| 2002-05-22 12:00:00 | IWM | ETF | 48.95 | 49.0 | 48.93 | 48.975 | 128200.0 |
| 2002-05-22 12:30:00 | IWM | ETF | 48.99 | 49.04 | 48.99 | 49.015 | 110800.0 |
| 2002-05-22 13:00:00 | IWM | ETF | 49.01 | 49.05 | 48.915 | 48.93 | 84600.0 |
| 2002-05-22 13:30:00 | IWM | ETF | 49.0 | 49.04 | 48.965 | 49.03 | 20800.0 |
| 2002-05-22 14:00:00 | IWM | ETF | 49.03 | 49.05 | 48.895 | 48.895 | 56600.0 |
| 2002-05-22 14:30:00 | IWM | ETF | 48.97 | 48.975 | 48.81 | 48.895 | 92200.0 |
| 2002-05-22 15:00:00 | IWM | ETF | 48.75 | 48.92 | 48.675 | 48.92 | 265800.0 |
| 2002-05-22 15:30:00 | IWM | ETF | 48.965 | 49.15 | 48.905 | 49.145 | 425400.0 |
| 2002-05-22 16:00:00 | IWM | ETF | 49.2 | 49.2 | 49.0 | 49.0 | 9600.0 |
> showing 50 of 517 rows — these rows as CSV