PREVIEW / etf_30min / 2002-06-26
file: by_date/etf_30min/2002/2002-06-26.parquet size: 19 KB rows: 523
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-26 09:30:00 | SPY | ETF | 95.2 | 96.5 | 95.19 | 96.5 | 3833100.0 |
| 2002-06-26 10:00:00 | SPY | ETF | 96.5 | 96.79 | 95.69 | 96.16 | 2601700.0 |
| 2002-06-26 10:30:00 | SPY | ETF | 96.18 | 96.75 | 95.86 | 96.04 | 1521300.0 |
| 2002-06-26 11:00:00 | SPY | ETF | 96.02 | 96.65 | 95.95 | 96.23 | 969100.0 |
| 2002-06-26 11:30:00 | SPY | ETF | 96.27 | 97.57 | 96.23 | 97.48 | 3748200.0 |
| 2002-06-26 12:00:00 | SPY | ETF | 97.46 | 97.54 | 96.68 | 96.73 | 1798100.0 |
| 2002-06-26 12:30:00 | SPY | ETF | 96.71 | 97.06 | 96.67 | 96.75 | 904100.0 |
| 2002-06-26 13:00:00 | SPY | ETF | 96.71 | 96.73 | 96.3 | 96.66 | 1381500.0 |
| 2002-06-26 13:30:00 | SPY | ETF | 96.67 | 96.78 | 96.01 | 96.12 | 693300.0 |
| 2002-06-26 14:00:00 | SPY | ETF | 96.18 | 96.6 | 95.7 | 95.95 | 1943300.0 |
| 2002-06-26 14:30:00 | SPY | ETF | 95.93 | 97.0 | 95.6 | 96.39 | 2154900.0 |
| 2002-06-26 15:00:00 | SPY | ETF | 96.4 | 98.15 | 96.2 | 97.75 | 2426100.0 |
| 2002-06-26 15:30:00 | SPY | ETF | 97.76 | 97.92 | 97.06 | 97.62 | 3494200.0 |
| 2002-06-26 16:00:00 | SPY | ETF | 97.65 | 97.79 | 97.41 | 97.65 | 2036200.0 |
| 2002-06-26 16:30:00 | SPY | ETF | 97.65 | 97.81 | 97.38 | 97.75 | 17400.0 |
| 2002-06-26 17:00:00 | SPY | ETF | 97.9 | 97.9 | 97.63 | 97.75 | 403100.0 |
| 2002-06-26 17:30:00 | SPY | ETF | 97.74 | 97.74 | 97.65 | 97.7 | 4200.0 |
| 2002-06-26 18:00:00 | SPY | ETF | 97.8 | 97.9 | 97.8 | 97.9 | 9900.0 |
| 2002-06-26 09:30:00 | QQQ | ETF | 24.43 | 24.93 | 24.39 | 24.92 | 20532700.0 |
| 2002-06-26 10:00:00 | QQQ | ETF | 24.91 | 25.03 | 24.57 | 24.85 | 10262600.0 |
| 2002-06-26 10:30:00 | QQQ | ETF | 24.85 | 25.13 | 24.67 | 24.82 | 9404200.0 |
| 2002-06-26 11:00:00 | QQQ | ETF | 24.79 | 25.0 | 24.74 | 24.92 | 5248700.0 |
| 2002-06-26 11:30:00 | QQQ | ETF | 24.92 | 25.42 | 24.92 | 25.39 | 9900700.0 |
| 2002-06-26 12:00:00 | QQQ | ETF | 25.38 | 25.42 | 25.08 | 25.13 | 7756300.0 |
| 2002-06-26 12:30:00 | QQQ | ETF | 25.12 | 25.25 | 24.92 | 24.95 | 4608000.0 |
| 2002-06-26 13:00:00 | QQQ | ETF | 24.95 | 25.02 | 24.8 | 25.0 | 3628200.0 |
| 2002-06-26 13:30:00 | QQQ | ETF | 25.0 | 25.07 | 24.72 | 24.78 | 4450800.0 |
| 2002-06-26 14:00:00 | QQQ | ETF | 24.79 | 25.03 | 24.65 | 24.76 | 7067400.0 |
| 2002-06-26 14:30:00 | QQQ | ETF | 24.75 | 25.3 | 24.66 | 25.14 | 12034200.0 |
| 2002-06-26 15:00:00 | QQQ | ETF | 25.11 | 25.78 | 25.04 | 25.63 | 11841700.0 |
| 2002-06-26 15:30:00 | QQQ | ETF | 25.63 | 25.75 | 25.31 | 25.57 | 12292600.0 |
| 2002-06-26 16:00:00 | QQQ | ETF | 25.57 | 25.74 | 24.99 | 25.5 | 3698000.0 |
| 2002-06-26 16:30:00 | QQQ | ETF | 25.5 | 25.65 | 25.34 | 25.56 | 207100.0 |
| 2002-06-26 17:00:00 | QQQ | ETF | 25.58 | 25.59 | 24.8 | 25.49 | 590300.0 |
| 2002-06-26 17:30:00 | QQQ | ETF | 25.53 | 25.59 | 25.52 | 25.53 | 22000.0 |
| 2002-06-26 18:00:00 | QQQ | ETF | 25.55 | 25.66 | 25.53 | 25.65 | 48500.0 |
| 2002-06-26 09:30:00 | IWM | ETF | 44.0 | 44.315 | 43.95 | 44.315 | 415600.0 |
| 2002-06-26 10:00:00 | IWM | ETF | 44.28 | 44.5 | 44.115 | 44.345 | 85400.0 |
| 2002-06-26 10:30:00 | IWM | ETF | 44.285 | 44.545 | 44.285 | 44.33 | 78200.0 |
| 2002-06-26 11:00:00 | IWM | ETF | 44.305 | 44.47 | 44.3 | 44.38 | 68000.0 |
| 2002-06-26 11:30:00 | IWM | ETF | 44.335 | 44.77 | 44.335 | 44.77 | 233000.0 |
| 2002-06-26 12:00:00 | IWM | ETF | 44.875 | 44.92 | 44.635 | 44.635 | 136800.0 |
| 2002-06-26 12:30:00 | IWM | ETF | 44.695 | 44.75 | 44.63 | 44.73 | 44400.0 |
| 2002-06-26 13:00:00 | IWM | ETF | 44.635 | 44.65 | 44.57 | 44.65 | 20400.0 |
| 2002-06-26 13:30:00 | IWM | ETF | 44.7 | 44.77 | 44.65 | 44.705 | 4113200.0 |
| 2002-06-26 14:00:00 | IWM | ETF | 44.705 | 44.735 | 44.6 | 44.7 | 132200.0 |
| 2002-06-26 14:30:00 | IWM | ETF | 44.63 | 45.115 | 44.6 | 44.94 | 393400.0 |
| 2002-06-26 15:00:00 | IWM | ETF | 44.935 | 45.155 | 44.86 | 45.15 | 181000.0 |
| 2002-06-26 15:30:00 | IWM | ETF | 45.095 | 45.15 | 44.825 | 45.15 | 612800.0 |
| 2002-06-26 16:00:00 | IWM | ETF | 45.145 | 45.15 | 44.985 | 45.0 | 42000.0 |
> showing 50 of 523 rows — these rows as CSV