PREVIEW / etf_30min / 2002-08-09
file: by_date/etf_30min/2002/2002-08-09.parquet size: 20 KB rows: 551
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-09 09:30:00 | SPY | ETF | 90.1 | 90.23 | 89.35 | 89.61 | 4989500.0 |
| 2002-08-09 10:00:00 | SPY | ETF | 89.59 | 90.14 | 89.5 | 89.87 | 3244300.0 |
| 2002-08-09 10:30:00 | SPY | ETF | 89.88 | 90.79 | 89.6 | 90.62 | 3341300.0 |
| 2002-08-09 11:00:00 | SPY | ETF | 90.6 | 91.39 | 90.43 | 91.27 | 4444900.0 |
| 2002-08-09 11:30:00 | SPY | ETF | 91.3 | 91.4 | 90.9 | 91.2 | 2274300.0 |
| 2002-08-09 12:00:00 | SPY | ETF | 91.13 | 91.19 | 90.8 | 90.98 | 1444200.0 |
| 2002-08-09 12:30:00 | SPY | ETF | 90.99 | 91.01 | 90.52 | 90.79 | 1731700.0 |
| 2002-08-09 13:00:00 | SPY | ETF | 90.76 | 90.78 | 90.3 | 90.63 | 1749600.0 |
| 2002-08-09 13:30:00 | SPY | ETF | 90.64 | 91.37 | 90.6 | 91.2 | 2784500.0 |
| 2002-08-09 14:00:00 | SPY | ETF | 91.19 | 91.56 | 90.79 | 91.5 | 2533600.0 |
| 2002-08-09 14:30:00 | SPY | ETF | 91.52 | 91.94 | 91.15 | 91.39 | 4189200.0 |
| 2002-08-09 15:00:00 | SPY | ETF | 91.39 | 91.8 | 91.28 | 91.62 | 2221800.0 |
| 2002-08-09 15:30:00 | SPY | ETF | 91.67 | 91.85 | 91.0 | 91.24 | 3975800.0 |
| 2002-08-09 16:00:00 | SPY | ETF | 91.26 | 91.45 | 91.15 | 91.29 | 1563300.0 |
| 2002-08-09 09:30:00 | QQQ | ETF | 23.2 | 23.21 | 22.95 | 23.01 | 10962900.0 |
| 2002-08-09 10:00:00 | QQQ | ETF | 23.0 | 23.21 | 22.97 | 23.03 | 7138800.0 |
| 2002-08-09 10:30:00 | QQQ | ETF | 23.03 | 23.27 | 22.88 | 23.21 | 9443600.0 |
| 2002-08-09 11:00:00 | QQQ | ETF | 23.21 | 23.51 | 23.11 | 23.47 | 9678300.0 |
| 2002-08-09 11:30:00 | QQQ | ETF | 23.48 | 23.51 | 23.3 | 23.35 | 6492000.0 |
| 2002-08-09 12:00:00 | QQQ | ETF | 23.35 | 23.45 | 23.22 | 23.36 | 4216700.0 |
| 2002-08-09 12:30:00 | QQQ | ETF | 23.37 | 23.38 | 23.2 | 23.31 | 3592900.0 |
| 2002-08-09 13:00:00 | QQQ | ETF | 23.3 | 23.32 | 23.11 | 23.26 | 3349200.0 |
| 2002-08-09 13:30:00 | QQQ | ETF | 23.25 | 23.52 | 23.24 | 23.45 | 6812700.0 |
| 2002-08-09 14:00:00 | QQQ | ETF | 23.46 | 23.61 | 23.31 | 23.6 | 5190600.0 |
| 2002-08-09 14:30:00 | QQQ | ETF | 23.61 | 23.71 | 23.4 | 23.51 | 10966500.0 |
| 2002-08-09 15:00:00 | QQQ | ETF | 23.5 | 23.6 | 23.43 | 23.55 | 3880400.0 |
| 2002-08-09 15:30:00 | QQQ | ETF | 23.55 | 23.6 | 23.29 | 23.29 | 7861100.0 |
| 2002-08-09 16:00:00 | QQQ | ETF | 23.29 | 23.33 | 23.25 | 23.33 | 1088600.0 |
| 2002-08-09 09:30:00 | IWM | ETF | 38.3 | 38.485 | 38.22 | 38.22 | 268600.0 |
| 2002-08-09 10:00:00 | IWM | ETF | 38.35 | 38.495 | 38.31 | 38.495 | 46800.0 |
| 2002-08-09 10:30:00 | IWM | ETF | 38.41 | 38.645 | 38.375 | 38.62 | 54400.0 |
| 2002-08-09 11:00:00 | IWM | ETF | 38.65 | 38.88 | 38.56 | 38.815 | 37600.0 |
| 2002-08-09 11:30:00 | IWM | ETF | 38.845 | 38.935 | 38.795 | 38.885 | 68400.0 |
| 2002-08-09 12:00:00 | IWM | ETF | 38.805 | 38.845 | 38.77 | 38.82 | 16600.0 |
| 2002-08-09 12:30:00 | IWM | ETF | 38.795 | 38.795 | 38.69 | 38.715 | 23400.0 |
| 2002-08-09 13:00:00 | IWM | ETF | 38.715 | 38.715 | 38.59 | 38.67 | 197800.0 |
| 2002-08-09 13:30:00 | IWM | ETF | 38.665 | 38.83 | 38.665 | 38.77 | 28600.0 |
| 2002-08-09 14:00:00 | IWM | ETF | 38.77 | 38.835 | 38.65 | 38.835 | 103600.0 |
| 2002-08-09 14:30:00 | IWM | ETF | 38.81 | 38.975 | 38.8 | 38.805 | 214000.0 |
| 2002-08-09 15:00:00 | IWM | ETF | 38.815 | 39.045 | 38.815 | 39.045 | 436600.0 |
| 2002-08-09 15:30:00 | IWM | ETF | 39.04 | 39.095 | 38.635 | 38.66 | 387600.0 |
| 2002-08-09 16:00:00 | IWM | ETF | 38.555 | 38.555 | 38.505 | 38.505 | 5200.0 |
| 2002-08-09 09:30:00 | DIA | ETF | 86.55 | 86.73 | 85.82 | 86.04 | 1503500.0 |
| 2002-08-09 10:00:00 | DIA | ETF | 86.04 | 86.58 | 85.95 | 86.15 | 973600.0 |
| 2002-08-09 10:30:00 | DIA | ETF | 86.15 | 87.02 | 85.96 | 86.9 | 995600.0 |
| 2002-08-09 11:00:00 | DIA | ETF | 86.87 | 87.54 | 86.59 | 87.4 | 1081300.0 |
| 2002-08-09 11:30:00 | DIA | ETF | 87.41 | 87.52 | 86.95 | 87.25 | 771300.0 |
| 2002-08-09 12:00:00 | DIA | ETF | 87.23 | 87.32 | 86.9 | 87.03 | 501700.0 |
| 2002-08-09 12:30:00 | DIA | ETF | 87.12 | 87.12 | 86.7 | 86.95 | 534300.0 |
| 2002-08-09 13:00:00 | DIA | ETF | 86.93 | 86.99 | 86.48 | 86.83 | 573900.0 |
> showing 50 of 551 rows — these rows as CSV