PREVIEW / etf_30min / 2002-06-24
file: by_date/etf_30min/2002/2002-06-24.parquet size: 20 KB rows: 537
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-06-24 09:30:00 | SPY | ETF | 98.61 | 99.4 | 98.4 | 98.57 | 3059500.0 |
| 2002-06-24 10:00:00 | SPY | ETF | 98.52 | 98.88 | 98.25 | 98.79 | 2071600.0 |
| 2002-06-24 10:30:00 | SPY | ETF | 98.76 | 98.83 | 98.19 | 98.32 | 1509100.0 |
| 2002-06-24 11:00:00 | SPY | ETF | 98.39 | 98.69 | 98.21 | 98.42 | 1096900.0 |
| 2002-06-24 11:30:00 | SPY | ETF | 98.4 | 98.46 | 97.43 | 97.58 | 1878000.0 |
| 2002-06-24 12:00:00 | SPY | ETF | 97.61 | 97.99 | 97.47 | 97.8 | 1178700.0 |
| 2002-06-24 12:30:00 | SPY | ETF | 97.75 | 97.8 | 97.25 | 97.63 | 1799600.0 |
| 2002-06-24 13:00:00 | SPY | ETF | 97.59 | 98.75 | 97.59 | 98.6 | 2906300.0 |
| 2002-06-24 13:30:00 | SPY | ETF | 98.65 | 99.75 | 98.45 | 99.4 | 4190200.0 |
| 2002-06-24 14:00:00 | SPY | ETF | 99.49 | 100.12 | 99.4 | 100.01 | 1737100.0 |
| 2002-06-24 14:30:00 | SPY | ETF | 100.0 | 100.69 | 99.9 | 100.32 | 2933800.0 |
| 2002-06-24 15:00:00 | SPY | ETF | 100.3 | 100.37 | 99.59 | 99.61 | 1323300.0 |
| 2002-06-24 15:30:00 | SPY | ETF | 99.58 | 99.68 | 98.9 | 99.68 | 2648700.0 |
| 2002-06-24 16:00:00 | SPY | ETF | 99.7 | 99.85 | 99.5 | 99.8 | 1613700.0 |
| 2002-06-24 16:30:00 | SPY | ETF | 99.79 | 99.9 | 99.56 | 99.9 | 670300.0 |
| 2002-06-24 17:00:00 | SPY | ETF | 99.9 | 99.97 | 99.9 | 99.9 | 4100.0 |
| 2002-06-24 17:30:00 | SPY | ETF | 99.97 | 99.99 | 99.97 | 99.99 | 1100.0 |
| 2002-06-24 18:00:00 | SPY | ETF | 99.89 | 100.04 | 99.89 | 100.04 | 400.0 |
| 2002-06-24 09:30:00 | QQQ | ETF | 25.45 | 25.87 | 25.35 | 25.46 | 12359900.0 |
| 2002-06-24 10:00:00 | QQQ | ETF | 25.46 | 25.74 | 25.36 | 25.67 | 8502800.0 |
| 2002-06-24 10:30:00 | QQQ | ETF | 25.67 | 25.72 | 25.4 | 25.5 | 5824700.0 |
| 2002-06-24 11:00:00 | QQQ | ETF | 25.5 | 25.69 | 25.43 | 25.61 | 4527100.0 |
| 2002-06-24 11:30:00 | QQQ | ETF | 25.57 | 25.62 | 25.21 | 25.3 | 6226900.0 |
| 2002-06-24 12:00:00 | QQQ | ETF | 25.31 | 25.47 | 25.26 | 25.34 | 3108200.0 |
| 2002-06-24 12:30:00 | QQQ | ETF | 25.34 | 25.45 | 25.24 | 25.44 | 2522700.0 |
| 2002-06-24 13:00:00 | QQQ | ETF | 25.44 | 25.98 | 25.42 | 25.86 | 8165600.0 |
| 2002-06-24 13:30:00 | QQQ | ETF | 25.87 | 26.4 | 25.76 | 26.3 | 13889500.0 |
| 2002-06-24 14:00:00 | QQQ | ETF | 26.23 | 26.59 | 26.23 | 26.52 | 10886600.0 |
| 2002-06-24 14:30:00 | QQQ | ETF | 26.53 | 26.79 | 26.5 | 26.71 | 12552300.0 |
| 2002-06-24 15:00:00 | QQQ | ETF | 26.72 | 26.75 | 26.41 | 26.45 | 7419300.0 |
| 2002-06-24 15:30:00 | QQQ | ETF | 26.42 | 26.49 | 26.03 | 26.35 | 12241700.0 |
| 2002-06-24 16:00:00 | QQQ | ETF | 26.35 | 26.4 | 26.21 | 26.37 | 1829800.0 |
| 2002-06-24 16:30:00 | QQQ | ETF | 26.37 | 26.46 | 25.4 | 26.36 | 125100.0 |
| 2002-06-24 17:00:00 | QQQ | ETF | 26.37 | 26.42 | 26.37 | 26.38 | 116800.0 |
| 2002-06-24 17:30:00 | QQQ | ETF | 26.38 | 26.44 | 26.37 | 26.41 | 25300.0 |
| 2002-06-24 18:00:00 | QQQ | ETF | 26.41 | 26.54 | 26.4 | 26.45 | 51500.0 |
| 2002-06-24 09:30:00 | IWM | ETF | 45.625 | 45.89 | 45.51 | 45.56 | 113400.0 |
| 2002-06-24 10:00:00 | IWM | ETF | 45.63 | 45.685 | 45.465 | 45.685 | 52400.0 |
| 2002-06-24 10:30:00 | IWM | ETF | 45.71 | 45.735 | 45.505 | 45.505 | 41200.0 |
| 2002-06-24 11:00:00 | IWM | ETF | 45.51 | 45.595 | 45.47 | 45.475 | 95400.0 |
| 2002-06-24 11:30:00 | IWM | ETF | 45.475 | 45.49 | 45.2 | 45.245 | 120200.0 |
| 2002-06-24 12:00:00 | IWM | ETF | 45.16 | 45.295 | 45.155 | 45.28 | 68200.0 |
| 2002-06-24 12:30:00 | IWM | ETF | 45.275 | 45.275 | 44.93 | 45.0 | 71200.0 |
| 2002-06-24 13:00:00 | IWM | ETF | 45.095 | 45.32 | 45.09 | 45.285 | 335200.0 |
| 2002-06-24 13:30:00 | IWM | ETF | 45.32 | 45.56 | 45.235 | 45.56 | 215400.0 |
| 2002-06-24 14:00:00 | IWM | ETF | 45.59 | 45.875 | 45.55 | 45.875 | 247200.0 |
| 2002-06-24 14:30:00 | IWM | ETF | 45.875 | 46.1 | 45.875 | 45.995 | 175600.0 |
| 2002-06-24 15:00:00 | IWM | ETF | 46.0 | 46.195 | 45.83 | 45.835 | 436600.0 |
| 2002-06-24 15:30:00 | IWM | ETF | 45.815 | 45.815 | 45.47 | 45.755 | 197600.0 |
| 2002-06-24 16:00:00 | IWM | ETF | 45.755 | 45.775 | 45.655 | 45.655 | 9000.0 |
> showing 50 of 537 rows — these rows as CSV