PREVIEW / etf_30min / 2002-05-10
file: by_date/etf_30min/2002/2002-05-10.parquet size: 18 KB rows: 482
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-10 09:30:00 | SPY | ETF | 107.91 | 107.96 | 107.29 | 107.29 | 2089600.0 |
| 2002-05-10 10:00:00 | SPY | ETF | 107.3 | 107.35 | 106.65 | 106.94 | 2750700.0 |
| 2002-05-10 10:30:00 | SPY | ETF | 106.89 | 107.07 | 106.72 | 106.92 | 1247800.0 |
| 2002-05-10 11:00:00 | SPY | ETF | 106.94 | 107.19 | 106.83 | 107.0 | 644900.0 |
| 2002-05-10 11:30:00 | SPY | ETF | 107.02 | 107.07 | 106.85 | 106.93 | 464300.0 |
| 2002-05-10 12:00:00 | SPY | ETF | 106.92 | 107.15 | 106.47 | 106.55 | 491200.0 |
| 2002-05-10 12:30:00 | SPY | ETF | 106.54 | 106.78 | 106.38 | 106.78 | 864600.0 |
| 2002-05-10 13:00:00 | SPY | ETF | 106.76 | 106.79 | 106.46 | 106.62 | 539600.0 |
| 2002-05-10 13:30:00 | SPY | ETF | 106.6 | 106.7 | 106.31 | 106.59 | 1298200.0 |
| 2002-05-10 14:00:00 | SPY | ETF | 106.58 | 106.88 | 106.54 | 106.71 | 609300.0 |
| 2002-05-10 14:30:00 | SPY | ETF | 106.67 | 106.72 | 106.12 | 106.14 | 1014500.0 |
| 2002-05-10 15:00:00 | SPY | ETF | 106.21 | 106.25 | 105.95 | 105.99 | 1326500.0 |
| 2002-05-10 15:30:00 | SPY | ETF | 105.98 | 106.08 | 105.72 | 105.98 | 2779800.0 |
| 2002-05-10 16:00:00 | SPY | ETF | 105.88 | 107.76 | 105.52 | 106.62 | 2069700.0 |
| 2002-05-10 16:30:00 | SPY | ETF | 105.75 | 105.89 | 105.7 | 105.74 | 17800.0 |
| 2002-05-10 17:00:00 | SPY | ETF | 105.7 | 105.74 | 105.7 | 105.74 | 600.0 |
| 2002-05-10 09:30:00 | QQQ | ETF | 31.0 | 31.09 | 30.48 | 30.52 | 11799400.0 |
| 2002-05-10 10:00:00 | QQQ | ETF | 30.52 | 30.59 | 30.15 | 30.35 | 14565100.0 |
| 2002-05-10 10:30:00 | QQQ | ETF | 30.35 | 30.5 | 30.26 | 30.43 | 8504200.0 |
| 2002-05-10 11:00:00 | QQQ | ETF | 30.43 | 30.6 | 30.35 | 30.4 | 5450400.0 |
| 2002-05-10 11:30:00 | QQQ | ETF | 30.4 | 30.42 | 30.23 | 30.29 | 4458300.0 |
| 2002-05-10 12:00:00 | QQQ | ETF | 30.3 | 30.4 | 29.89 | 29.95 | 11655000.0 |
| 2002-05-10 12:30:00 | QQQ | ETF | 29.93 | 29.97 | 29.78 | 29.96 | 7033800.0 |
| 2002-05-10 13:00:00 | QQQ | ETF | 29.95 | 29.99 | 29.77 | 29.92 | 4968700.0 |
| 2002-05-10 13:30:00 | QQQ | ETF | 29.95 | 29.95 | 29.61 | 29.79 | 6279200.0 |
| 2002-05-10 14:00:00 | QQQ | ETF | 29.76 | 30.04 | 29.76 | 29.87 | 6804400.0 |
| 2002-05-10 14:30:00 | QQQ | ETF | 29.86 | 29.89 | 29.58 | 29.63 | 6025900.0 |
| 2002-05-10 15:00:00 | QQQ | ETF | 29.61 | 29.74 | 29.5 | 29.61 | 8547500.0 |
| 2002-05-10 15:30:00 | QQQ | ETF | 29.61 | 29.72 | 29.53 | 29.65 | 8393200.0 |
| 2002-05-10 16:00:00 | QQQ | ETF | 29.62 | 29.84 | 29.5 | 29.54 | 5016300.0 |
| 2002-05-10 16:30:00 | QQQ | ETF | 29.53 | 29.58 | 29.5 | 29.58 | 70000.0 |
| 2002-05-10 17:00:00 | QQQ | ETF | 29.53 | 29.57 | 29.52 | 29.57 | 12500.0 |
| 2002-05-10 17:30:00 | QQQ | ETF | 29.55 | 29.91 | 29.51 | 29.64 | 65900.0 |
| 2002-05-10 18:00:00 | QQQ | ETF | 29.62 | 29.68 | 29.58 | 29.65 | 23100.0 |
| 2002-05-10 09:30:00 | IWM | ETF | 50.02 | 50.02 | 49.69 | 49.69 | 445400.0 |
| 2002-05-10 10:00:00 | IWM | ETF | 49.575 | 49.625 | 49.18 | 49.195 | 186400.0 |
| 2002-05-10 10:30:00 | IWM | ETF | 49.2 | 49.355 | 49.17 | 49.34 | 82800.0 |
| 2002-05-10 11:00:00 | IWM | ETF | 49.365 | 49.45 | 49.35 | 49.445 | 61000.0 |
| 2002-05-10 11:30:00 | IWM | ETF | 49.45 | 49.45 | 49.345 | 49.445 | 57200.0 |
| 2002-05-10 12:00:00 | IWM | ETF | 49.35 | 49.445 | 49.16 | 49.16 | 21000.0 |
| 2002-05-10 12:30:00 | IWM | ETF | 49.24 | 49.25 | 49.145 | 49.25 | 278000.0 |
| 2002-05-10 13:00:00 | IWM | ETF | 49.275 | 49.275 | 49.17 | 49.185 | 12200.0 |
| 2002-05-10 13:30:00 | IWM | ETF | 49.19 | 49.21 | 49.09 | 49.15 | 40600.0 |
| 2002-05-10 14:00:00 | IWM | ETF | 49.165 | 49.325 | 49.165 | 49.22 | 37800.0 |
| 2002-05-10 14:30:00 | IWM | ETF | 49.25 | 49.25 | 48.95 | 48.95 | 109800.0 |
| 2002-05-10 15:00:00 | IWM | ETF | 49.025 | 49.1 | 49.025 | 49.1 | 62200.0 |
| 2002-05-10 15:30:00 | IWM | ETF | 49.05 | 49.105 | 48.97 | 49.095 | 37200.0 |
| 2002-05-10 16:00:00 | IWM | ETF | 49.05 | 49.065 | 49.0 | 49.065 | 45600.0 |
| 2002-05-10 09:30:00 | DIA | ETF | 100.73 | 100.75 | 100.25 | 100.25 | 947100.0 |
| 2002-05-10 10:00:00 | DIA | ETF | 100.25 | 100.35 | 99.92 | 100.18 | 829100.0 |
> showing 50 of 482 rows — these rows as CSV