PREVIEW / etf_30min / 2002-08-23
file: by_date/etf_30min/2002/2002-08-23.parquet size: 20 KB rows: 555
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-08-23 09:30:00 | SPY | ETF | 96.01 | 96.15 | 95.72 | 95.89 | 4287100.0 |
| 2002-08-23 10:00:00 | SPY | ETF | 95.89 | 95.93 | 95.14 | 95.35 | 3696000.0 |
| 2002-08-23 10:30:00 | SPY | ETF | 95.38 | 95.64 | 95.22 | 95.36 | 1264600.0 |
| 2002-08-23 11:00:00 | SPY | ETF | 95.4 | 95.49 | 95.0 | 95.2 | 1343300.0 |
| 2002-08-23 11:30:00 | SPY | ETF | 95.21 | 95.39 | 95.0 | 95.06 | 810000.0 |
| 2002-08-23 12:00:00 | SPY | ETF | 95.05 | 95.25 | 94.84 | 94.95 | 1623500.0 |
| 2002-08-23 12:30:00 | SPY | ETF | 94.95 | 95.05 | 94.76 | 94.97 | 1920400.0 |
| 2002-08-23 13:00:00 | SPY | ETF | 94.98 | 95.15 | 94.7 | 94.94 | 877600.0 |
| 2002-08-23 13:30:00 | SPY | ETF | 94.92 | 95.32 | 94.85 | 95.11 | 1100700.0 |
| 2002-08-23 14:00:00 | SPY | ETF | 95.11 | 95.4 | 94.9 | 95.39 | 1106400.0 |
| 2002-08-23 14:30:00 | SPY | ETF | 95.37 | 95.4 | 94.75 | 94.75 | 1256400.0 |
| 2002-08-23 15:00:00 | SPY | ETF | 94.78 | 94.84 | 94.17 | 94.17 | 3838800.0 |
| 2002-08-23 15:30:00 | SPY | ETF | 94.24 | 94.67 | 94.15 | 94.52 | 3023900.0 |
| 2002-08-23 16:00:00 | SPY | ETF | 94.55 | 94.65 | 94.41 | 94.6 | 846500.0 |
| 2002-08-23 09:30:00 | QQQ | ETF | 25.8 | 25.81 | 25.61 | 25.65 | 9144100.0 |
| 2002-08-23 10:00:00 | QQQ | ETF | 25.66 | 25.69 | 25.35 | 25.43 | 9832600.0 |
| 2002-08-23 10:30:00 | QQQ | ETF | 25.43 | 25.51 | 25.38 | 25.42 | 4381200.0 |
| 2002-08-23 11:00:00 | QQQ | ETF | 25.41 | 25.47 | 25.22 | 25.35 | 5035600.0 |
| 2002-08-23 11:30:00 | QQQ | ETF | 25.32 | 25.45 | 25.3 | 25.33 | 2981900.0 |
| 2002-08-23 12:00:00 | QQQ | ETF | 25.32 | 25.39 | 25.21 | 25.25 | 3549600.0 |
| 2002-08-23 12:30:00 | QQQ | ETF | 25.25 | 25.26 | 25.15 | 25.2 | 3095200.0 |
| 2002-08-23 13:00:00 | QQQ | ETF | 25.2 | 25.3 | 25.16 | 25.2 | 4008700.0 |
| 2002-08-23 13:30:00 | QQQ | ETF | 25.2 | 25.37 | 25.18 | 25.28 | 3230800.0 |
| 2002-08-23 14:00:00 | QQQ | ETF | 25.28 | 25.37 | 25.19 | 25.36 | 2984500.0 |
| 2002-08-23 14:30:00 | QQQ | ETF | 25.36 | 25.38 | 25.16 | 25.17 | 4077600.0 |
| 2002-08-23 15:00:00 | QQQ | ETF | 25.18 | 25.19 | 24.95 | 25.0 | 9686000.0 |
| 2002-08-23 15:30:00 | QQQ | ETF | 25.0 | 25.18 | 24.98 | 25.13 | 9023500.0 |
| 2002-08-23 16:00:00 | QQQ | ETF | 25.13 | 25.2 | 25.11 | 25.15 | 560300.0 |
| 2002-08-23 09:30:00 | IWM | ETF | 40.6 | 40.85 | 40.555 | 40.645 | 253000.0 |
| 2002-08-23 10:00:00 | IWM | ETF | 40.715 | 40.715 | 40.465 | 40.545 | 55200.0 |
| 2002-08-23 10:30:00 | IWM | ETF | 40.545 | 40.6 | 40.475 | 40.6 | 50600.0 |
| 2002-08-23 11:00:00 | IWM | ETF | 40.515 | 40.59 | 40.415 | 40.45 | 67600.0 |
| 2002-08-23 11:30:00 | IWM | ETF | 40.425 | 40.48 | 40.365 | 40.365 | 180000.0 |
| 2002-08-23 12:00:00 | IWM | ETF | 40.355 | 40.38 | 40.125 | 40.125 | 275800.0 |
| 2002-08-23 12:30:00 | IWM | ETF | 40.175 | 40.22 | 40.025 | 40.22 | 325600.0 |
| 2002-08-23 13:00:00 | IWM | ETF | 40.17 | 40.255 | 40.165 | 40.175 | 157400.0 |
| 2002-08-23 13:30:00 | IWM | ETF | 40.235 | 40.375 | 40.235 | 40.325 | 90200.0 |
| 2002-08-23 14:00:00 | IWM | ETF | 40.3 | 40.39 | 40.25 | 40.37 | 128800.0 |
| 2002-08-23 14:30:00 | IWM | ETF | 40.33 | 40.39 | 40.245 | 40.3 | 106400.0 |
| 2002-08-23 15:00:00 | IWM | ETF | 40.215 | 40.26 | 40.09 | 40.1 | 189400.0 |
| 2002-08-23 15:30:00 | IWM | ETF | 40.06 | 40.14 | 39.9 | 40.025 | 185400.0 |
| 2002-08-23 16:00:00 | IWM | ETF | 39.975 | 40.0 | 39.825 | 39.825 | 110400.0 |
| 2002-08-23 09:30:00 | DIA | ETF | 89.89 | 91.0 | 89.78 | 89.93 | 726200.0 |
| 2002-08-23 10:00:00 | DIA | ETF | 89.99 | 89.99 | 89.34 | 89.5 | 899000.0 |
| 2002-08-23 10:30:00 | DIA | ETF | 89.51 | 89.75 | 89.4 | 89.52 | 404800.0 |
| 2002-08-23 11:00:00 | DIA | ETF | 89.52 | 89.61 | 89.21 | 89.34 | 327700.0 |
| 2002-08-23 11:30:00 | DIA | ETF | 89.36 | 89.53 | 89.14 | 89.25 | 483500.0 |
| 2002-08-23 12:00:00 | DIA | ETF | 89.23 | 89.39 | 88.95 | 89.07 | 402500.0 |
| 2002-08-23 12:30:00 | DIA | ETF | 89.06 | 89.21 | 88.91 | 89.1 | 420700.0 |
| 2002-08-23 13:00:00 | DIA | ETF | 89.1 | 89.31 | 88.86 | 89.11 | 671700.0 |
> showing 50 of 555 rows — these rows as CSV