PREVIEW / etf_30min / 2003-06-04
file: by_date/etf_30min/2003/2003-06-04.parquet size: 24 KB rows: 742
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-04 08:00:00 | SPY | ETF | 97.79 | 97.79 | 97.77 | 97.77 | 4000.0 |
| 2003-06-04 08:30:00 | SPY | ETF | 97.8 | 97.8 | 97.7 | 97.7 | 11300.0 |
| 2003-06-04 09:00:00 | SPY | ETF | 97.68 | 97.71 | 97.6 | 97.68 | 32700.0 |
| 2003-06-04 09:30:00 | SPY | ETF | 97.66 | 97.9 | 97.56 | 97.87 | 4185300.0 |
| 2003-06-04 10:00:00 | SPY | ETF | 97.82 | 98.7 | 97.82 | 98.64 | 8150700.0 |
| 2003-06-04 10:30:00 | SPY | ETF | 98.64 | 98.94 | 98.62 | 98.82 | 3653600.0 |
| 2003-06-04 11:00:00 | SPY | ETF | 98.83 | 98.91 | 98.5 | 98.6 | 2358100.0 |
| 2003-06-04 11:30:00 | SPY | ETF | 98.58 | 98.73 | 98.46 | 98.49 | 1341100.0 |
| 2003-06-04 12:00:00 | SPY | ETF | 98.5 | 98.87 | 98.43 | 98.8 | 1721700.0 |
| 2003-06-04 12:30:00 | SPY | ETF | 98.8 | 98.86 | 98.58 | 98.59 | 1786000.0 |
| 2003-06-04 13:00:00 | SPY | ETF | 98.6 | 98.74 | 98.52 | 98.6 | 969700.0 |
| 2003-06-04 13:30:00 | SPY | ETF | 98.6 | 98.9 | 98.53 | 98.77 | 1230200.0 |
| 2003-06-04 14:00:00 | SPY | ETF | 98.78 | 98.92 | 98.64 | 98.67 | 2262600.0 |
| 2003-06-04 14:30:00 | SPY | ETF | 98.64 | 98.97 | 98.57 | 98.76 | 1573100.0 |
| 2003-06-04 15:00:00 | SPY | ETF | 98.75 | 99.2 | 98.71 | 99.18 | 3463200.0 |
| 2003-06-04 15:30:00 | SPY | ETF | 99.19 | 99.35 | 99.0 | 99.13 | 5680100.0 |
| 2003-06-04 16:00:00 | SPY | ETF | 99.14 | 99.26 | 99.08 | 99.18 | 4705200.0 |
| 2003-06-04 16:30:00 | SPY | ETF | 99.18 | 99.2 | 99.05 | 99.09 | 140300.0 |
| 2003-06-04 17:00:00 | SPY | ETF | 99.1 | 99.15 | 99.07 | 99.08 | 116600.0 |
| 2003-06-04 17:30:00 | SPY | ETF | 99.13 | 99.15 | 99.05 | 99.08 | 94700.0 |
| 2003-06-04 18:00:00 | SPY | ETF | 99.09 | 99.09 | 99.05 | 99.05 | 41700.0 |
| 2003-06-04 18:30:00 | SPY | ETF | 99.07 | 99.12 | 99.07 | 99.12 | 5400.0 |
| 2003-06-04 19:00:00 | SPY | ETF | 99.07 | 99.07 | 99.03 | 99.03 | 2700.0 |
| 2003-06-04 19:30:00 | SPY | ETF | 99.06 | 99.09 | 99.05 | 99.09 | 1400.0 |
| 2003-06-04 08:00:00 | QQQ | ETF | 29.89 | 29.89 | 29.83 | 29.87 | 27100.0 |
| 2003-06-04 08:30:00 | QQQ | ETF | 29.88 | 29.88 | 29.8 | 29.8 | 123200.0 |
| 2003-06-04 09:00:00 | QQQ | ETF | 29.8 | 29.84 | 29.79 | 29.8 | 68000.0 |
| 2003-06-04 09:30:00 | QQQ | ETF | 29.81 | 29.94 | 29.72 | 29.89 | 6108500.0 |
| 2003-06-04 10:00:00 | QQQ | ETF | 29.91 | 30.25 | 29.89 | 30.23 | 12140000.0 |
| 2003-06-04 10:30:00 | QQQ | ETF | 30.21 | 30.36 | 30.18 | 30.27 | 10522100.0 |
| 2003-06-04 11:00:00 | QQQ | ETF | 30.28 | 30.34 | 30.11 | 30.13 | 7462700.0 |
| 2003-06-04 11:30:00 | QQQ | ETF | 30.15 | 30.17 | 30.06 | 30.09 | 3491200.0 |
| 2003-06-04 12:00:00 | QQQ | ETF | 30.09 | 30.19 | 30.04 | 30.18 | 3687700.0 |
| 2003-06-04 12:30:00 | QQQ | ETF | 30.16 | 30.21 | 30.07 | 30.09 | 2579400.0 |
| 2003-06-04 13:00:00 | QQQ | ETF | 30.09 | 30.18 | 30.08 | 30.11 | 1233300.0 |
| 2003-06-04 13:30:00 | QQQ | ETF | 30.11 | 30.27 | 30.08 | 30.19 | 2725700.0 |
| 2003-06-04 14:00:00 | QQQ | ETF | 30.19 | 30.26 | 30.13 | 30.14 | 2963400.0 |
| 2003-06-04 14:30:00 | QQQ | ETF | 30.14 | 30.27 | 30.1 | 30.2 | 3257500.0 |
| 2003-06-04 15:00:00 | QQQ | ETF | 30.21 | 30.49 | 30.18 | 30.49 | 9120900.0 |
| 2003-06-04 15:30:00 | QQQ | ETF | 30.45 | 30.58 | 30.32 | 30.42 | 11589700.0 |
| 2003-06-04 16:00:00 | QQQ | ETF | 30.41 | 30.45 | 30.36 | 30.39 | 3270700.0 |
| 2003-06-04 16:30:00 | QQQ | ETF | 30.4 | 30.42 | 30.32 | 30.36 | 484500.0 |
| 2003-06-04 17:00:00 | QQQ | ETF | 30.36 | 30.39 | 30.35 | 30.37 | 144700.0 |
| 2003-06-04 17:30:00 | QQQ | ETF | 30.37 | 30.37 | 30.34 | 30.34 | 45000.0 |
| 2003-06-04 18:00:00 | QQQ | ETF | 30.35 | 30.36 | 30.33 | 30.35 | 43600.0 |
| 2003-06-04 18:30:00 | QQQ | ETF | 30.36 | 30.37 | 30.34 | 30.36 | 16300.0 |
| 2003-06-04 19:00:00 | QQQ | ETF | 30.37 | 30.38 | 30.37 | 30.38 | 2400.0 |
| 2003-06-04 19:30:00 | QQQ | ETF | 30.37 | 30.37 | 30.35 | 30.35 | 19300.0 |
| 2003-06-04 09:30:00 | IWM | ETF | 44.375 | 44.56 | 44.355 | 44.56 | 343000.0 |
| 2003-06-04 10:00:00 | IWM | ETF | 44.56 | 44.88 | 44.56 | 44.88 | 350200.0 |
> showing 50 of 742 rows — these rows as CSV