PREVIEW / etf_30min / 2004-05-03
file: by_date/etf_30min/2004/2004-05-03.parquet size: 36 KB rows: 1,196
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 |
|---|---|---|---|---|---|---|---|
| 2004-05-03 08:00:00 | SPY | ETF | 111.4 | 111.43 | 111.33 | 111.36 | 7900.0 |
| 2004-05-03 08:30:00 | SPY | ETF | 111.33 | 111.43 | 111.33 | 111.4 | 22300.0 |
| 2004-05-03 09:00:00 | SPY | ETF | 111.4 | 111.45 | 111.38 | 111.39 | 41300.0 |
| 2004-05-03 09:30:00 | SPY | ETF | 111.37 | 111.82 | 111.35 | 111.79 | 3677200.0 |
| 2004-05-03 10:00:00 | SPY | ETF | 111.79 | 111.95 | 111.42 | 111.92 | 3521800.0 |
| 2004-05-03 10:30:00 | SPY | ETF | 111.89 | 112.17 | 111.72 | 112.04 | 2892500.0 |
| 2004-05-03 11:00:00 | SPY | ETF | 112.04 | 112.29 | 112.02 | 112.1 | 2048300.0 |
| 2004-05-03 11:30:00 | SPY | ETF | 112.0901 | 112.14 | 111.94 | 112.01 | 1815900.0 |
| 2004-05-03 12:00:00 | SPY | ETF | 111.98 | 112.11 | 111.85 | 112.0 | 1182000.0 |
| 2004-05-03 12:30:00 | SPY | ETF | 112.0 | 112.11 | 111.94 | 112.05 | 1664900.0 |
| 2004-05-03 13:00:00 | SPY | ETF | 112.06 | 112.08 | 111.78 | 111.79 | 1105700.0 |
| 2004-05-03 13:30:00 | SPY | ETF | 111.77 | 111.91 | 111.68 | 111.79 | 1737500.0 |
| 2004-05-03 14:00:00 | SPY | ETF | 111.79 | 112.12 | 111.75 | 111.95 | 1487000.0 |
| 2004-05-03 14:30:00 | SPY | ETF | 111.98 | 112.07 | 111.56 | 111.63 | 2829300.0 |
| 2004-05-03 15:00:00 | SPY | ETF | 111.65 | 111.9 | 111.6 | 111.79 | 1927700.0 |
| 2004-05-03 15:30:00 | SPY | ETF | 111.75 | 112.22 | 111.73 | 112.14 | 2630700.0 |
| 2004-05-03 16:00:00 | SPY | ETF | 112.16 | 112.22 | 112.1 | 112.14 | 997300.0 |
| 2004-05-03 16:30:00 | SPY | ETF | 112.14 | 112.18 | 112.13 | 112.14 | 119600.0 |
| 2004-05-03 17:00:00 | SPY | ETF | 112.18 | 112.19 | 112.14 | 112.16 | 30500.0 |
| 2004-05-03 17:30:00 | SPY | ETF | 112.16 | 112.16 | 112.16 | 112.16 | 200.0 |
| 2004-05-03 18:00:00 | SPY | ETF | 112.14 | 112.15 | 112.12 | 112.12 | 3100.0 |
| 2004-05-03 18:30:00 | SPY | ETF | 112.15 | 112.17 | 112.14 | 112.14 | 3200.0 |
| 2004-05-03 08:00:00 | QQQ | ETF | 34.95 | 35.85 | 34.92 | 34.95 | 158000.0 |
| 2004-05-03 08:30:00 | QQQ | ETF | 34.96 | 34.98 | 34.95 | 34.98 | 80500.0 |
| 2004-05-03 09:00:00 | QQQ | ETF | 34.98 | 35.03 | 34.98 | 35.01 | 419100.0 |
| 2004-05-03 09:30:00 | QQQ | ETF | 35.0 | 35.21 | 34.972 | 35.17 | 16816700.0 |
| 2004-05-03 10:00:00 | QQQ | ETF | 35.178 | 35.34 | 35.02 | 35.31 | 14343000.0 |
| 2004-05-03 10:30:00 | QQQ | ETF | 35.31 | 35.42 | 35.28 | 35.36 | 9816000.0 |
| 2004-05-03 11:00:00 | QQQ | ETF | 35.37 | 35.52 | 35.36 | 35.43 | 9648700.0 |
| 2004-05-03 11:30:00 | QQQ | ETF | 35.439 | 35.45 | 35.33 | 35.381 | 5453400.0 |
| 2004-05-03 12:00:00 | QQQ | ETF | 35.389 | 35.44 | 35.29 | 35.34 | 5677400.0 |
| 2004-05-03 12:30:00 | QQQ | ETF | 35.352 | 35.38 | 35.29 | 35.35 | 2400800.0 |
| 2004-05-03 13:00:00 | QQQ | ETF | 35.359 | 35.362 | 35.15 | 35.1677 | 5877100.0 |
| 2004-05-03 13:30:00 | QQQ | ETF | 35.16 | 35.19 | 35.04 | 35.138 | 8879600.0 |
| 2004-05-03 14:00:00 | QQQ | ETF | 35.14 | 35.27 | 35.12 | 35.15 | 4964100.0 |
| 2004-05-03 14:30:00 | QQQ | ETF | 35.151 | 35.22 | 34.89 | 34.96 | 9792000.0 |
| 2004-05-03 15:00:00 | QQQ | ETF | 34.958 | 35.08 | 34.93 | 35.01 | 6503600.0 |
| 2004-05-03 15:30:00 | QQQ | ETF | 35.02 | 35.28 | 34.99 | 35.18 | 11464400.0 |
| 2004-05-03 16:00:00 | QQQ | ETF | 35.171 | 35.19 | 35.09 | 35.15 | 2154100.0 |
| 2004-05-03 16:30:00 | QQQ | ETF | 35.13 | 35.15 | 35.12 | 35.14 | 138000.0 |
| 2004-05-03 17:00:00 | QQQ | ETF | 35.13 | 35.15 | 35.12 | 35.13 | 67600.0 |
| 2004-05-03 17:30:00 | QQQ | ETF | 35.13 | 35.16 | 35.12 | 35.15 | 41600.0 |
| 2004-05-03 18:00:00 | QQQ | ETF | 35.15 | 35.16 | 35.13 | 35.147 | 8000.0 |
| 2004-05-03 18:30:00 | QQQ | ETF | 35.14 | 35.15 | 35.13 | 35.13 | 7400.0 |
| 2004-05-03 19:00:00 | QQQ | ETF | 35.15 | 35.15 | 35.13 | 35.14 | 7200.0 |
| 2004-05-03 19:30:00 | QQQ | ETF | 35.15 | 35.17 | 35.14 | 35.17 | 2100.0 |
| 2004-05-03 08:00:00 | IWM | ETF | 55.875 | 55.875 | 55.875 | 55.875 | 1000.0 |
| 2004-05-03 08:30:00 | IWM | ETF | 55.87 | 55.875 | 55.825 | 55.825 | 11400.0 |
| 2004-05-03 09:30:00 | IWM | ETF | 55.8 | 56.005 | 55.745 | 55.94 | 2384000.0 |
| 2004-05-03 10:00:00 | IWM | ETF | 55.955 | 56.38 | 55.745 | 56.38 | 1602000.0 |
> showing 50 of 1,196 rows — these rows as CSV