PREVIEW / etf_30min / 2002-08-13
file: by_date/etf_30min/2002/2002-08-13.parquet size: 20 KB rows: 566
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-13 09:30:00 | SPY | ETF | 90.15 | 90.6 | 90.08 | 90.43 | 2106800.0 |
| 2002-08-13 10:00:00 | SPY | ETF | 90.4 | 90.82 | 90.26 | 90.68 | 2333600.0 |
| 2002-08-13 10:30:00 | SPY | ETF | 90.68 | 91.39 | 90.64 | 91.36 | 2296200.0 |
| 2002-08-13 11:00:00 | SPY | ETF | 91.3 | 91.66 | 91.26 | 91.53 | 1675500.0 |
| 2002-08-13 11:30:00 | SPY | ETF | 91.53 | 91.58 | 91.3 | 91.41 | 990200.0 |
| 2002-08-13 12:00:00 | SPY | ETF | 91.4 | 91.45 | 91.17 | 91.26 | 2289800.0 |
| 2002-08-13 12:30:00 | SPY | ETF | 91.28 | 91.48 | 91.2 | 91.3 | 594500.0 |
| 2002-08-13 13:00:00 | SPY | ETF | 91.27 | 91.4 | 91.07 | 91.28 | 1094800.0 |
| 2002-08-13 13:30:00 | SPY | ETF | 91.25 | 91.4 | 90.96 | 91.35 | 1170400.0 |
| 2002-08-13 14:00:00 | SPY | ETF | 91.34 | 91.58 | 90.26 | 90.68 | 8406600.0 |
| 2002-08-13 14:30:00 | SPY | ETF | 90.68 | 91.35 | 90.12 | 90.5 | 7936100.0 |
| 2002-08-13 15:00:00 | SPY | ETF | 90.51 | 90.75 | 89.63 | 89.75 | 3979400.0 |
| 2002-08-13 15:30:00 | SPY | ETF | 89.66 | 89.77 | 88.67 | 88.75 | 9908400.0 |
| 2002-08-13 16:00:00 | SPY | ETF | 88.73 | 88.99 | 88.66 | 88.97 | 1705800.0 |
| 2002-08-13 09:30:00 | QQQ | ETF | 23.23 | 23.52 | 23.17 | 23.4 | 8121300.0 |
| 2002-08-13 10:00:00 | QQQ | ETF | 23.41 | 23.68 | 23.36 | 23.62 | 5129400.0 |
| 2002-08-13 10:30:00 | QQQ | ETF | 23.65 | 23.85 | 23.6 | 23.81 | 5945200.0 |
| 2002-08-13 11:00:00 | QQQ | ETF | 23.8 | 23.87 | 23.74 | 23.81 | 3318700.0 |
| 2002-08-13 11:30:00 | QQQ | ETF | 23.84 | 23.84 | 23.7 | 23.71 | 2454000.0 |
| 2002-08-13 12:00:00 | QQQ | ETF | 23.71 | 23.74 | 23.56 | 23.64 | 2677500.0 |
| 2002-08-13 12:30:00 | QQQ | ETF | 23.64 | 23.7 | 23.6 | 23.64 | 1297400.0 |
| 2002-08-13 13:00:00 | QQQ | ETF | 23.63 | 23.65 | 23.46 | 23.51 | 2464100.0 |
| 2002-08-13 13:30:00 | QQQ | ETF | 23.52 | 23.61 | 23.45 | 23.56 | 2168400.0 |
| 2002-08-13 14:00:00 | QQQ | ETF | 23.56 | 23.75 | 23.1 | 23.27 | 12366100.0 |
| 2002-08-13 14:30:00 | QQQ | ETF | 23.27 | 23.49 | 23.11 | 23.21 | 9748100.0 |
| 2002-08-13 15:00:00 | QQQ | ETF | 23.21 | 23.35 | 22.86 | 22.86 | 7556500.0 |
| 2002-08-13 15:30:00 | QQQ | ETF | 22.88 | 22.91 | 22.55 | 22.6 | 17905800.0 |
| 2002-08-13 16:00:00 | QQQ | ETF | 22.6 | 22.65 | 22.57 | 22.6 | 508300.0 |
| 2002-08-13 09:30:00 | IWM | ETF | 38.55 | 38.73 | 38.44 | 38.7 | 165600.0 |
| 2002-08-13 10:00:00 | IWM | ETF | 38.665 | 38.825 | 38.61 | 38.825 | 182200.0 |
| 2002-08-13 10:30:00 | IWM | ETF | 38.815 | 38.9 | 38.8 | 38.895 | 92200.0 |
| 2002-08-13 11:00:00 | IWM | ETF | 38.91 | 38.91 | 38.82 | 38.895 | 35200.0 |
| 2002-08-13 11:30:00 | IWM | ETF | 38.87 | 38.895 | 38.735 | 38.735 | 123200.0 |
| 2002-08-13 12:00:00 | IWM | ETF | 38.75 | 38.8 | 38.575 | 38.6 | 69400.0 |
| 2002-08-13 12:30:00 | IWM | ETF | 38.6 | 38.67 | 38.6 | 38.615 | 23200.0 |
| 2002-08-13 13:00:00 | IWM | ETF | 38.615 | 38.65 | 38.52 | 38.545 | 32200.0 |
| 2002-08-13 13:30:00 | IWM | ETF | 38.58 | 38.58 | 38.5 | 38.5 | 19600.0 |
| 2002-08-13 14:00:00 | IWM | ETF | 38.51 | 38.75 | 38.18 | 38.295 | 295200.0 |
| 2002-08-13 14:30:00 | IWM | ETF | 38.21 | 38.52 | 38.11 | 38.12 | 133000.0 |
| 2002-08-13 15:00:00 | IWM | ETF | 38.15 | 38.3 | 37.825 | 37.825 | 194400.0 |
| 2002-08-13 15:30:00 | IWM | ETF | 37.825 | 37.975 | 37.575 | 37.65 | 591600.0 |
| 2002-08-13 16:00:00 | IWM | ETF | 37.575 | 37.645 | 37.45 | 37.5 | 56400.0 |
| 2002-08-13 09:30:00 | DIA | ETF | 86.53 | 86.61 | 86.2 | 86.39 | 754500.0 |
| 2002-08-13 10:00:00 | DIA | ETF | 86.39 | 86.93 | 86.3 | 86.75 | 389700.0 |
| 2002-08-13 10:30:00 | DIA | ETF | 86.71 | 87.36 | 86.65 | 87.35 | 567700.0 |
| 2002-08-13 11:00:00 | DIA | ETF | 87.31 | 87.66 | 87.2 | 87.53 | 696900.0 |
| 2002-08-13 11:30:00 | DIA | ETF | 87.5 | 87.55 | 87.26 | 87.35 | 251400.0 |
| 2002-08-13 12:00:00 | DIA | ETF | 87.32 | 87.43 | 87.13 | 87.25 | 235000.0 |
| 2002-08-13 12:30:00 | DIA | ETF | 87.25 | 87.45 | 87.18 | 87.25 | 162700.0 |
| 2002-08-13 13:00:00 | DIA | ETF | 87.22 | 87.27 | 86.95 | 87.11 | 519900.0 |
> showing 50 of 566 rows — these rows as CSV