PREVIEW / etf_30min / 2003-07-21
file: by_date/etf_30min/2003/2003-07-21.parquet size: 23 KB rows: 684
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-21 08:00:00 | SPY | ETF | 99.46 | 99.46 | 99.36 | 99.39 | 17300.0 |
| 2003-07-21 08:30:00 | SPY | ETF | 99.38 | 99.4 | 99.34 | 99.4 | 10600.0 |
| 2003-07-21 09:00:00 | SPY | ETF | 99.4 | 99.48 | 99.33 | 99.48 | 15800.0 |
| 2003-07-21 09:30:00 | SPY | ETF | 99.45 | 99.49 | 98.9 | 98.98 | 3784100.0 |
| 2003-07-21 10:00:00 | SPY | ETF | 99.03 | 99.07 | 98.57 | 98.64 | 3446000.0 |
| 2003-07-21 10:30:00 | SPY | ETF | 98.59 | 98.7 | 98.37 | 98.55 | 2046100.0 |
| 2003-07-21 11:00:00 | SPY | ETF | 98.56 | 98.59 | 98.22 | 98.32 | 2221900.0 |
| 2003-07-21 11:30:00 | SPY | ETF | 98.31 | 98.32 | 98.07 | 98.1 | 1852500.0 |
| 2003-07-21 12:00:00 | SPY | ETF | 98.1 | 98.19 | 98.02 | 98.13 | 1392100.0 |
| 2003-07-21 12:30:00 | SPY | ETF | 98.13 | 98.3 | 98.1 | 98.25 | 2590600.0 |
| 2003-07-21 13:00:00 | SPY | ETF | 98.28 | 98.36 | 98.22 | 98.3 | 745800.0 |
| 2003-07-21 13:30:00 | SPY | ETF | 98.31 | 98.32 | 98.11 | 98.198 | 1017300.0 |
| 2003-07-21 14:00:00 | SPY | ETF | 98.2 | 98.47 | 98.13 | 98.31 | 1669100.0 |
| 2003-07-21 14:30:00 | SPY | ETF | 98.28 | 98.3 | 97.95 | 98.0 | 2485300.0 |
| 2003-07-21 15:00:00 | SPY | ETF | 98.0 | 98.16 | 97.85 | 98.13 | 2649400.0 |
| 2003-07-21 15:30:00 | SPY | ETF | 98.13 | 98.28 | 98.09 | 98.24 | 2409700.0 |
| 2003-07-21 16:00:00 | SPY | ETF | 98.24 | 98.41 | 98.161 | 98.25 | 1165700.0 |
| 2003-07-21 16:30:00 | SPY | ETF | 98.25 | 98.28 | 98.2 | 98.2 | 43600.0 |
| 2003-07-21 17:00:00 | SPY | ETF | 98.3 | 98.4 | 98.28 | 98.35 | 377400.0 |
| 2003-07-21 17:30:00 | SPY | ETF | 98.35 | 98.4 | 98.35 | 98.4 | 1000.0 |
| 2003-07-21 18:00:00 | SPY | ETF | 98.37 | 98.38 | 98.36 | 98.36 | 3900.0 |
| 2003-07-21 18:30:00 | SPY | ETF | 98.38 | 98.38 | 98.32 | 98.32 | 25200.0 |
| 2003-07-21 19:00:00 | SPY | ETF | 98.32 | 98.32 | 98.29 | 98.29 | 22900.0 |
| 2003-07-21 08:00:00 | QQQ | ETF | 31.3 | 31.31 | 31.26 | 31.28 | 43400.0 |
| 2003-07-21 08:30:00 | QQQ | ETF | 31.26 | 31.28 | 31.23 | 31.24 | 25700.0 |
| 2003-07-21 09:00:00 | QQQ | ETF | 31.24 | 31.27 | 31.23 | 31.26 | 50400.0 |
| 2003-07-21 09:30:00 | QQQ | ETF | 31.24 | 31.3 | 31.02 | 31.1 | 11228300.0 |
| 2003-07-21 10:00:00 | QQQ | ETF | 31.11 | 31.12 | 30.8 | 30.847 | 9852300.0 |
| 2003-07-21 10:30:00 | QQQ | ETF | 30.86 | 30.9 | 30.7 | 30.76 | 9760900.0 |
| 2003-07-21 11:00:00 | QQQ | ETF | 30.76 | 30.83 | 30.63 | 30.73 | 8071200.0 |
| 2003-07-21 11:30:00 | QQQ | ETF | 30.71 | 30.77 | 30.61 | 30.67 | 6677200.0 |
| 2003-07-21 12:00:00 | QQQ | ETF | 30.65 | 30.741 | 30.61 | 30.74 | 3594200.0 |
| 2003-07-21 12:30:00 | QQQ | ETF | 30.73 | 30.81 | 30.71 | 30.77 | 2578400.0 |
| 2003-07-21 13:00:00 | QQQ | ETF | 30.77 | 30.82 | 30.74 | 30.79 | 2552900.0 |
| 2003-07-21 13:30:00 | QQQ | ETF | 30.78 | 30.81 | 30.719 | 30.76 | 1764700.0 |
| 2003-07-21 14:00:00 | QQQ | ETF | 30.76 | 30.89 | 30.74 | 30.84 | 7721900.0 |
| 2003-07-21 14:30:00 | QQQ | ETF | 30.84 | 30.842 | 30.66 | 30.72 | 5710400.0 |
| 2003-07-21 15:00:00 | QQQ | ETF | 30.7 | 30.79 | 30.63 | 30.79 | 4846100.0 |
| 2003-07-21 15:30:00 | QQQ | ETF | 30.79 | 30.87 | 30.7 | 30.83 | 7809100.0 |
| 2003-07-21 16:00:00 | QQQ | ETF | 30.83 | 30.94 | 30.74 | 30.74 | 2843600.0 |
| 2003-07-21 16:30:00 | QQQ | ETF | 30.75 | 30.85 | 30.69 | 30.84 | 572600.0 |
| 2003-07-21 17:00:00 | QQQ | ETF | 30.85 | 30.97 | 30.83 | 30.92 | 1237300.0 |
| 2003-07-21 17:30:00 | QQQ | ETF | 30.92 | 30.96 | 30.91 | 30.931 | 419600.0 |
| 2003-07-21 18:00:00 | QQQ | ETF | 30.948 | 30.95 | 30.9 | 30.93 | 110900.0 |
| 2003-07-21 18:30:00 | QQQ | ETF | 30.92 | 30.92 | 30.87 | 30.87 | 104500.0 |
| 2003-07-21 19:00:00 | QQQ | ETF | 30.87 | 30.96 | 30.86 | 30.91 | 41800.0 |
| 2003-07-21 19:30:00 | QQQ | ETF | 30.89 | 30.92 | 30.89 | 30.91 | 29700.0 |
| 2003-07-21 09:30:00 | IWM | ETF | 46.055 | 46.175 | 46.025 | 46.04 | 233800.0 |
| 2003-07-21 10:00:00 | IWM | ETF | 46.04 | 46.04 | 45.62 | 45.675 | 478600.0 |
| 2003-07-21 10:30:00 | IWM | ETF | 45.665 | 45.68 | 45.45 | 45.52 | 450000.0 |
> showing 50 of 684 rows — these rows as CSV