PREVIEW / etf_30min / 2003-06-09
file: by_date/etf_30min/2003/2003-06-09.parquet size: 24 KB rows: 734
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-06-09 08:00:00 | SPY | ETF | 99.39 | 99.39 | 98.95 | 98.99 | 64400.0 |
| 2003-06-09 08:30:00 | SPY | ETF | 98.95 | 98.99 | 98.74 | 98.78 | 38200.0 |
| 2003-06-09 09:00:00 | SPY | ETF | 98.72 | 98.78 | 98.7 | 98.78 | 67400.0 |
| 2003-06-09 09:30:00 | SPY | ETF | 98.76 | 99.08 | 98.59 | 99.02 | 6114600.0 |
| 2003-06-09 10:00:00 | SPY | ETF | 98.95 | 99.1 | 98.24 | 98.28 | 4952600.0 |
| 2003-06-09 10:30:00 | SPY | ETF | 98.27 | 98.35 | 98.07 | 98.31 | 3629900.0 |
| 2003-06-09 11:00:00 | SPY | ETF | 98.31 | 98.52 | 98.25 | 98.46 | 1953600.0 |
| 2003-06-09 11:30:00 | SPY | ETF | 98.46 | 98.57 | 98.26 | 98.34 | 979700.0 |
| 2003-06-09 12:00:00 | SPY | ETF | 98.36 | 98.69 | 98.3 | 98.45 | 1257900.0 |
| 2003-06-09 12:30:00 | SPY | ETF | 98.41 | 98.45 | 98.26 | 98.33 | 1099900.0 |
| 2003-06-09 13:00:00 | SPY | ETF | 98.33 | 98.36 | 98.11 | 98.32 | 1076000.0 |
| 2003-06-09 13:30:00 | SPY | ETF | 98.33 | 98.4 | 98.15 | 98.28 | 1049600.0 |
| 2003-06-09 14:00:00 | SPY | ETF | 98.28 | 98.42 | 98.04 | 98.11 | 1880500.0 |
| 2003-06-09 14:30:00 | SPY | ETF | 98.1 | 98.29 | 97.88 | 97.93 | 1819900.0 |
| 2003-06-09 15:00:00 | SPY | ETF | 97.94 | 98.02 | 97.77 | 97.85 | 2686800.0 |
| 2003-06-09 15:30:00 | SPY | ETF | 97.83 | 98.16 | 97.83 | 98.11 | 4052000.0 |
| 2003-06-09 16:00:00 | SPY | ETF | 98.11 | 98.29 | 98.09 | 98.26 | 1190400.0 |
| 2003-06-09 16:30:00 | SPY | ETF | 98.26 | 98.28 | 98.25 | 98.26 | 108600.0 |
| 2003-06-09 17:00:00 | SPY | ETF | 98.26 | 98.27 | 98.2 | 98.27 | 739100.0 |
| 2003-06-09 17:30:00 | SPY | ETF | 98.27 | 98.27 | 98.27 | 98.27 | 1000.0 |
| 2003-06-09 18:00:00 | SPY | ETF | 98.27 | 98.33 | 98.27 | 98.33 | 3000.0 |
| 2003-06-09 18:30:00 | SPY | ETF | 98.33 | 98.33 | 98.28 | 98.28 | 800.0 |
| 2003-06-09 19:00:00 | SPY | ETF | 98.28 | 98.28 | 98.28 | 98.28 | 700.0 |
| 2003-06-09 19:30:00 | SPY | ETF | 98.24 | 98.24 | 98.23 | 98.24 | 10000.0 |
| 2003-06-09 08:00:00 | QQQ | ETF | 30.18 | 30.18 | 30.03 | 30.06 | 108500.0 |
| 2003-06-09 08:30:00 | QQQ | ETF | 30.02 | 30.03 | 29.94 | 29.98 | 75200.0 |
| 2003-06-09 09:00:00 | QQQ | ETF | 29.99 | 30.01 | 29.93 | 30.01 | 103400.0 |
| 2003-06-09 09:30:00 | QQQ | ETF | 30.0 | 30.18 | 29.85 | 30.11 | 14559500.0 |
| 2003-06-09 10:00:00 | QQQ | ETF | 30.12 | 30.22 | 29.75 | 29.75 | 10975200.0 |
| 2003-06-09 10:30:00 | QQQ | ETF | 29.75 | 29.8 | 29.56 | 29.73 | 12616400.0 |
| 2003-06-09 11:00:00 | QQQ | ETF | 29.72 | 29.85 | 29.66 | 29.82 | 3449100.0 |
| 2003-06-09 11:30:00 | QQQ | ETF | 29.8 | 29.88 | 29.72 | 29.77 | 2353200.0 |
| 2003-06-09 12:00:00 | QQQ | ETF | 29.77 | 29.89 | 29.7 | 29.74 | 3022300.0 |
| 2003-06-09 12:30:00 | QQQ | ETF | 29.77 | 29.79 | 29.67 | 29.72 | 2198000.0 |
| 2003-06-09 13:00:00 | QQQ | ETF | 29.71 | 29.78 | 29.61 | 29.73 | 2425800.0 |
| 2003-06-09 13:30:00 | QQQ | ETF | 29.7 | 29.79 | 29.64 | 29.74 | 2812600.0 |
| 2003-06-09 14:00:00 | QQQ | ETF | 29.74 | 29.83 | 29.59 | 29.65 | 6164600.0 |
| 2003-06-09 14:30:00 | QQQ | ETF | 29.63 | 29.75 | 29.57 | 29.61 | 3494600.0 |
| 2003-06-09 15:00:00 | QQQ | ETF | 29.62 | 29.67 | 29.53 | 29.57 | 4189100.0 |
| 2003-06-09 15:30:00 | QQQ | ETF | 29.58 | 29.75 | 29.56 | 29.7 | 6522300.0 |
| 2003-06-09 16:00:00 | QQQ | ETF | 29.72 | 29.76 | 29.7 | 29.75 | 4063800.0 |
| 2003-06-09 16:30:00 | QQQ | ETF | 29.75 | 29.76 | 29.73 | 29.74 | 20300.0 |
| 2003-06-09 17:00:00 | QQQ | ETF | 29.76 | 29.78 | 29.74 | 29.77 | 563800.0 |
| 2003-06-09 17:30:00 | QQQ | ETF | 29.78 | 29.79 | 29.75 | 29.75 | 32400.0 |
| 2003-06-09 18:00:00 | QQQ | ETF | 29.77 | 29.78 | 29.76 | 29.78 | 5800.0 |
| 2003-06-09 18:30:00 | QQQ | ETF | 29.78 | 29.79 | 29.77 | 29.79 | 4700.0 |
| 2003-06-09 19:00:00 | QQQ | ETF | 29.79 | 29.79 | 29.79 | 29.79 | 800.0 |
| 2003-06-09 19:30:00 | QQQ | ETF | 29.79 | 29.8 | 29.78 | 29.79 | 7700.0 |
| 2003-06-09 09:30:00 | IWM | ETF | 45.1 | 45.2 | 44.905 | 45.055 | 473800.0 |
| 2003-06-09 10:00:00 | IWM | ETF | 44.985 | 45.075 | 44.675 | 44.7 | 487600.0 |
> showing 50 of 734 rows — these rows as CSV