PREVIEW / etf_30min / 2002-09-06
file: by_date/etf_30min/2002/2002-09-06.parquet size: 18 KB rows: 521
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-09-06 09:30:00 | SPY | ETF | 89.75 | 90.45 | 89.71 | 89.84 | 7733400.0 |
| 2002-09-06 10:00:00 | SPY | ETF | 89.86 | 90.05 | 89.34 | 89.44 | 4548100.0 |
| 2002-09-06 10:30:00 | SPY | ETF | 89.5 | 90.1 | 89.37 | 89.93 | 2888300.0 |
| 2002-09-06 11:00:00 | SPY | ETF | 89.95 | 90.25 | 89.52 | 90.17 | 2469000.0 |
| 2002-09-06 11:30:00 | SPY | ETF | 90.18 | 90.23 | 89.83 | 89.91 | 1673500.0 |
| 2002-09-06 12:00:00 | SPY | ETF | 89.94 | 90.15 | 89.76 | 90.13 | 1070100.0 |
| 2002-09-06 12:30:00 | SPY | ETF | 90.12 | 90.18 | 89.93 | 90.12 | 832900.0 |
| 2002-09-06 13:00:00 | SPY | ETF | 90.14 | 90.33 | 90.07 | 90.27 | 1615500.0 |
| 2002-09-06 13:30:00 | SPY | ETF | 90.3 | 90.3 | 89.95 | 90.03 | 1093000.0 |
| 2002-09-06 14:00:00 | SPY | ETF | 90.0 | 90.2 | 89.84 | 90.2 | 1976700.0 |
| 2002-09-06 14:30:00 | SPY | ETF | 90.17 | 90.34 | 89.92 | 90.22 | 1031700.0 |
| 2002-09-06 15:00:00 | SPY | ETF | 90.25 | 90.57 | 90.16 | 90.21 | 3499400.0 |
| 2002-09-06 15:30:00 | SPY | ETF | 90.21 | 90.38 | 89.72 | 89.86 | 3332600.0 |
| 2002-09-06 16:00:00 | SPY | ETF | 89.86 | 90.08 | 89.74 | 90.0 | 1248200.0 |
| 2002-09-06 09:30:00 | QQQ | ETF | 22.66 | 22.9 | 22.65 | 22.8 | 14697800.0 |
| 2002-09-06 10:00:00 | QQQ | ETF | 22.81 | 22.93 | 22.6 | 22.73 | 11451800.0 |
| 2002-09-06 10:30:00 | QQQ | ETF | 22.75 | 22.95 | 22.66 | 22.92 | 8316900.0 |
| 2002-09-06 11:00:00 | QQQ | ETF | 22.9 | 22.99 | 22.75 | 22.99 | 6317200.0 |
| 2002-09-06 11:30:00 | QQQ | ETF | 22.96 | 23.0 | 22.82 | 22.86 | 4371600.0 |
| 2002-09-06 12:00:00 | QQQ | ETF | 22.85 | 22.98 | 22.84 | 22.92 | 3204300.0 |
| 2002-09-06 12:30:00 | QQQ | ETF | 22.97 | 23.02 | 22.92 | 23.0 | 3863900.0 |
| 2002-09-06 13:00:00 | QQQ | ETF | 23.0 | 23.11 | 22.99 | 23.07 | 4576900.0 |
| 2002-09-06 13:30:00 | QQQ | ETF | 23.09 | 23.11 | 22.98 | 23.0 | 2930400.0 |
| 2002-09-06 14:00:00 | QQQ | ETF | 23.0 | 23.09 | 22.93 | 23.07 | 2834600.0 |
| 2002-09-06 14:30:00 | QQQ | ETF | 23.07 | 23.11 | 22.98 | 23.08 | 3267400.0 |
| 2002-09-06 15:00:00 | QQQ | ETF | 23.07 | 23.22 | 23.04 | 23.12 | 7353000.0 |
| 2002-09-06 15:30:00 | QQQ | ETF | 23.13 | 23.19 | 22.85 | 22.9 | 9851300.0 |
| 2002-09-06 16:00:00 | QQQ | ETF | 22.91 | 22.92 | 22.85 | 22.85 | 1099500.0 |
| 2002-09-06 09:30:00 | IWM | ETF | 38.4 | 38.65 | 38.4 | 38.47 | 67400.0 |
| 2002-09-06 10:00:00 | IWM | ETF | 38.46 | 38.62 | 38.46 | 38.6 | 96400.0 |
| 2002-09-06 10:30:00 | IWM | ETF | 38.53 | 38.94 | 38.53 | 38.94 | 145200.0 |
| 2002-09-06 11:00:00 | IWM | ETF | 38.94 | 39.0 | 38.755 | 39.0 | 58600.0 |
| 2002-09-06 11:30:00 | IWM | ETF | 38.975 | 39.0 | 38.865 | 38.865 | 13800.0 |
| 2002-09-06 12:00:00 | IWM | ETF | 38.87 | 38.95 | 38.825 | 38.875 | 23800.0 |
| 2002-09-06 12:30:00 | IWM | ETF | 38.875 | 38.975 | 38.875 | 38.925 | 10200.0 |
| 2002-09-06 13:00:00 | IWM | ETF | 38.97 | 39.055 | 38.85 | 39.0 | 71000.0 |
| 2002-09-06 13:30:00 | IWM | ETF | 39.0 | 39.05 | 38.935 | 38.975 | 86200.0 |
| 2002-09-06 14:00:00 | IWM | ETF | 38.975 | 39.06 | 38.925 | 39.06 | 46800.0 |
| 2002-09-06 14:30:00 | IWM | ETF | 39.08 | 39.1 | 39.025 | 39.1 | 30200.0 |
| 2002-09-06 15:00:00 | IWM | ETF | 39.06 | 39.19 | 39.035 | 39.035 | 338600.0 |
| 2002-09-06 15:30:00 | IWM | ETF | 39.05 | 39.16 | 38.945 | 39.16 | 552800.0 |
| 2002-09-06 16:00:00 | IWM | ETF | 39.2 | 39.2 | 39.15 | 39.15 | 186800.0 |
| 2002-09-06 09:30:00 | DIA | ETF | 84.31 | 84.99 | 84.2 | 84.34 | 1736200.0 |
| 2002-09-06 10:00:00 | DIA | ETF | 84.34 | 84.65 | 83.9 | 83.96 | 1273800.0 |
| 2002-09-06 10:30:00 | DIA | ETF | 84.01 | 84.48 | 83.9 | 84.3 | 1013000.0 |
| 2002-09-06 11:00:00 | DIA | ETF | 84.29 | 84.59 | 84.01 | 84.54 | 525800.0 |
| 2002-09-06 11:30:00 | DIA | ETF | 84.52 | 84.59 | 84.28 | 84.38 | 535200.0 |
| 2002-09-06 12:00:00 | DIA | ETF | 84.39 | 84.55 | 84.2 | 84.52 | 435300.0 |
| 2002-09-06 12:30:00 | DIA | ETF | 84.5 | 84.61 | 84.32 | 84.53 | 209400.0 |
| 2002-09-06 13:00:00 | DIA | ETF | 84.56 | 84.8 | 84.38 | 84.75 | 418400.0 |
> showing 50 of 521 rows — these rows as CSV