PREVIEW / etf_30min / 2003-07-25
file: by_date/etf_30min/2003/2003-07-25.parquet size: 24 KB rows: 693
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-25 08:00:00 | SPY | ETF | 98.73 | 98.85 | 98.69 | 98.78 | 31900.0 |
| 2003-07-25 08:30:00 | SPY | ETF | 98.8 | 98.98 | 98.67 | 98.67 | 71400.0 |
| 2003-07-25 09:00:00 | SPY | ETF | 98.66 | 98.74 | 98.6 | 98.6 | 13000.0 |
| 2003-07-25 09:30:00 | SPY | ETF | 98.66 | 99.07 | 98.47 | 99.05 | 4693300.0 |
| 2003-07-25 10:00:00 | SPY | ETF | 99.05 | 99.17 | 98.598 | 98.62 | 3485700.0 |
| 2003-07-25 10:30:00 | SPY | ETF | 98.63 | 98.74 | 98.04 | 98.3 | 4270400.0 |
| 2003-07-25 11:00:00 | SPY | ETF | 98.32 | 98.75 | 98.2 | 98.57 | 3367200.0 |
| 2003-07-25 11:30:00 | SPY | ETF | 98.57 | 98.95 | 98.5 | 98.87 | 1788100.0 |
| 2003-07-25 12:00:00 | SPY | ETF | 98.91 | 99.06 | 98.82 | 98.85 | 1677500.0 |
| 2003-07-25 12:30:00 | SPY | ETF | 98.86 | 99.03 | 98.83 | 99.02 | 1019100.0 |
| 2003-07-25 13:00:00 | SPY | ETF | 98.996 | 99.45 | 98.94 | 99.33 | 1727500.0 |
| 2003-07-25 13:30:00 | SPY | ETF | 99.31 | 99.519 | 99.25 | 99.3 | 3251100.0 |
| 2003-07-25 14:00:00 | SPY | ETF | 99.29 | 99.46 | 99.24 | 99.34 | 1445500.0 |
| 2003-07-25 14:30:00 | SPY | ETF | 99.3 | 100.01 | 99.3 | 99.9 | 3507800.0 |
| 2003-07-25 15:00:00 | SPY | ETF | 99.94 | 100.15 | 99.86 | 100.06 | 2044000.0 |
| 2003-07-25 15:30:00 | SPY | ETF | 100.05 | 100.29 | 99.92 | 100.23 | 3323300.0 |
| 2003-07-25 16:00:00 | SPY | ETF | 100.23 | 100.33 | 100.1 | 100.33 | 3615900.0 |
| 2003-07-25 16:30:00 | SPY | ETF | 100.3 | 100.34 | 100.27 | 100.33 | 47700.0 |
| 2003-07-25 17:00:00 | SPY | ETF | 100.33 | 100.39 | 100.2 | 100.36 | 9000.0 |
| 2003-07-25 17:30:00 | SPY | ETF | 100.37 | 100.5 | 100.33 | 100.5 | 8300.0 |
| 2003-07-25 18:00:00 | SPY | ETF | 100.54 | 100.59 | 100.4 | 100.4 | 74600.0 |
| 2003-07-25 18:30:00 | SPY | ETF | 100.41 | 100.41 | 100.4 | 100.4 | 500.0 |
| 2003-07-25 19:00:00 | SPY | ETF | 100.38 | 100.38 | 100.37 | 100.37 | 1700.0 |
| 2003-07-25 19:30:00 | SPY | ETF | 100.4 | 100.4 | 100.38 | 100.38 | 1000.0 |
| 2003-07-25 08:00:00 | QQQ | ETF | 31.21 | 31.24 | 31.15 | 31.22 | 147000.0 |
| 2003-07-25 08:30:00 | QQQ | ETF | 31.2 | 31.3 | 31.11 | 31.13 | 381500.0 |
| 2003-07-25 09:00:00 | QQQ | ETF | 31.12 | 31.17 | 31.11 | 31.12 | 102800.0 |
| 2003-07-25 09:30:00 | QQQ | ETF | 31.13 | 31.33 | 31.07 | 31.27 | 7391700.0 |
| 2003-07-25 10:00:00 | QQQ | ETF | 31.26 | 31.277 | 30.97 | 31.003 | 8113900.0 |
| 2003-07-25 10:30:00 | QQQ | ETF | 31.011 | 31.03 | 30.769 | 30.87 | 7849200.0 |
| 2003-07-25 11:00:00 | QQQ | ETF | 30.885 | 31.08 | 30.839 | 30.95 | 5332300.0 |
| 2003-07-25 11:30:00 | QQQ | ETF | 30.97 | 31.15 | 30.91 | 31.13 | 3512400.0 |
| 2003-07-25 12:00:00 | QQQ | ETF | 31.14 | 31.2 | 31.04 | 31.05 | 2653300.0 |
| 2003-07-25 12:30:00 | QQQ | ETF | 31.05 | 31.17 | 31.05 | 31.131 | 1531900.0 |
| 2003-07-25 13:00:00 | QQQ | ETF | 31.13 | 31.27 | 31.11 | 31.232 | 3106700.0 |
| 2003-07-25 13:30:00 | QQQ | ETF | 31.24 | 31.51 | 31.23 | 31.367 | 7437900.0 |
| 2003-07-25 14:00:00 | QQQ | ETF | 31.38 | 31.452 | 31.34 | 31.389 | 1390000.0 |
| 2003-07-25 14:30:00 | QQQ | ETF | 31.39 | 31.66 | 31.38 | 31.61 | 4667500.0 |
| 2003-07-25 15:00:00 | QQQ | ETF | 31.61 | 31.72 | 31.55 | 31.68 | 5042000.0 |
| 2003-07-25 15:30:00 | QQQ | ETF | 31.705 | 31.781 | 31.6 | 31.77 | 9103200.0 |
| 2003-07-25 16:00:00 | QQQ | ETF | 31.77 | 31.85 | 31.75 | 31.83 | 3512000.0 |
| 2003-07-25 16:30:00 | QQQ | ETF | 31.83 | 31.87 | 31.81 | 31.85 | 88000.0 |
| 2003-07-25 17:00:00 | QQQ | ETF | 31.86 | 31.87 | 31.85 | 31.87 | 55600.0 |
| 2003-07-25 17:30:00 | QQQ | ETF | 31.88 | 31.92 | 31.85 | 31.9 | 119900.0 |
| 2003-07-25 18:00:00 | QQQ | ETF | 31.91 | 31.93 | 31.9 | 31.92 | 219200.0 |
| 2003-07-25 18:30:00 | QQQ | ETF | 31.89 | 31.92 | 31.8 | 31.92 | 9900.0 |
| 2003-07-25 19:00:00 | QQQ | ETF | 31.87 | 31.87 | 31.85 | 31.85 | 1900.0 |
| 2003-07-25 19:30:00 | QQQ | ETF | 31.85 | 31.89 | 31.83 | 31.83 | 16900.0 |
| 2003-07-25 09:30:00 | IWM | ETF | 46.475 | 46.745 | 46.45 | 46.71 | 315400.0 |
| 2003-07-25 10:00:00 | IWM | ETF | 46.68 | 46.735 | 46.41 | 46.41 | 182800.0 |
> showing 50 of 693 rows — these rows as CSV