PREVIEW / etf_30min / 2004-08-17
file: by_date/etf_30min/2004/2004-08-17.parquet size: 34 KB rows: 1,155
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-08-17 08:00:00 | SPY | ETF | 108.68 | 108.77 | 108.59 | 108.59 | 68700.0 |
| 2004-08-17 08:30:00 | SPY | ETF | 108.67 | 108.99 | 108.67 | 108.87 | 447700.0 |
| 2004-08-17 09:00:00 | SPY | ETF | 108.87 | 108.92 | 108.73 | 108.74 | 82100.0 |
| 2004-08-17 09:30:00 | SPY | ETF | 108.75 | 109.28 | 108.67 | 109.11 | 6612300.0 |
| 2004-08-17 10:00:00 | SPY | ETF | 109.1 | 109.18 | 108.82 | 108.87 | 4582600.0 |
| 2004-08-17 10:30:00 | SPY | ETF | 108.87 | 109.01 | 108.78 | 108.82 | 3873300.0 |
| 2004-08-17 11:00:00 | SPY | ETF | 108.82 | 108.9 | 108.62 | 108.68 | 3275000.0 |
| 2004-08-17 11:30:00 | SPY | ETF | 108.69 | 108.84 | 108.61 | 108.75 | 2013900.0 |
| 2004-08-17 12:00:00 | SPY | ETF | 108.75 | 108.85 | 108.72 | 108.79 | 1293100.0 |
| 2004-08-17 12:30:00 | SPY | ETF | 108.782 | 108.95 | 108.71 | 108.9 | 1331900.0 |
| 2004-08-17 13:00:00 | SPY | ETF | 108.91 | 108.95 | 108.76 | 108.85 | 817100.0 |
| 2004-08-17 13:30:00 | SPY | ETF | 108.86 | 108.93 | 108.71 | 108.85 | 1161100.0 |
| 2004-08-17 14:00:00 | SPY | ETF | 108.85 | 108.86 | 108.58 | 108.75 | 2857800.0 |
| 2004-08-17 14:30:00 | SPY | ETF | 108.76 | 108.95 | 108.74 | 108.8 | 2255900.0 |
| 2004-08-17 15:00:00 | SPY | ETF | 108.82 | 108.84 | 108.53 | 108.59 | 3505100.0 |
| 2004-08-17 15:30:00 | SPY | ETF | 108.59 | 108.8 | 108.57 | 108.71 | 3170800.0 |
| 2004-08-17 16:00:00 | SPY | ETF | 108.72 | 108.96 | 108.65 | 108.9 | 1589200.0 |
| 2004-08-17 16:30:00 | SPY | ETF | 108.89 | 108.89 | 108.81 | 108.86 | 65800.0 |
| 2004-08-17 17:00:00 | SPY | ETF | 108.99 | 108.99 | 108.8 | 108.82 | 68900.0 |
| 2004-08-17 17:30:00 | SPY | ETF | 108.77 | 108.83 | 108.77 | 108.83 | 500.0 |
| 2004-08-17 18:00:00 | SPY | ETF | 108.77 | 108.81 | 108.76 | 108.81 | 62100.0 |
| 2004-08-17 19:00:00 | SPY | ETF | 108.8 | 108.8 | 108.75 | 108.76 | 9900.0 |
| 2004-08-17 19:30:00 | SPY | ETF | 108.75 | 108.77 | 108.71 | 108.77 | 7200.0 |
| 2004-08-17 08:00:00 | QQQ | ETF | 33.05 | 33.08 | 33.02 | 33.02 | 97100.0 |
| 2004-08-17 08:30:00 | QQQ | ETF | 33.05 | 33.19 | 33.05 | 33.14 | 602500.0 |
| 2004-08-17 09:00:00 | QQQ | ETF | 33.14 | 33.18 | 33.12 | 33.13 | 243100.0 |
| 2004-08-17 09:30:00 | QQQ | ETF | 33.12 | 33.44 | 33.1 | 33.344 | 18942500.0 |
| 2004-08-17 10:00:00 | QQQ | ETF | 33.34 | 33.38 | 33.18 | 33.232 | 8509500.0 |
| 2004-08-17 10:30:00 | QQQ | ETF | 33.231 | 33.341 | 33.2 | 33.27 | 5110100.0 |
| 2004-08-17 11:00:00 | QQQ | ETF | 33.27 | 33.28 | 33.1 | 33.16 | 6213300.0 |
| 2004-08-17 11:30:00 | QQQ | ETF | 33.151 | 33.23 | 33.11 | 33.2 | 4355400.0 |
| 2004-08-17 12:00:00 | QQQ | ETF | 33.198 | 33.28 | 33.189 | 33.26 | 3328100.0 |
| 2004-08-17 12:30:00 | QQQ | ETF | 33.25 | 33.35 | 33.22 | 33.337 | 3523600.0 |
| 2004-08-17 13:00:00 | QQQ | ETF | 33.339 | 33.35 | 33.27 | 33.3 | 2945100.0 |
| 2004-08-17 13:30:00 | QQQ | ETF | 33.3 | 33.33 | 33.25 | 33.31 | 3957500.0 |
| 2004-08-17 14:00:00 | QQQ | ETF | 33.314 | 33.33 | 33.164 | 33.258 | 5795500.0 |
| 2004-08-17 14:30:00 | QQQ | ETF | 33.26 | 33.33 | 33.243 | 33.27 | 3548700.0 |
| 2004-08-17 15:00:00 | QQQ | ETF | 33.27 | 33.29 | 33.16 | 33.175 | 4185800.0 |
| 2004-08-17 15:30:00 | QQQ | ETF | 33.176 | 33.23 | 33.15 | 33.17 | 8899500.0 |
| 2004-08-17 16:00:00 | QQQ | ETF | 33.171 | 33.27 | 33.15 | 33.24 | 1920500.0 |
| 2004-08-17 16:30:00 | QQQ | ETF | 33.22 | 33.27 | 33.2 | 33.242 | 487500.0 |
| 2004-08-17 17:00:00 | QQQ | ETF | 33.25 | 33.26 | 33.22 | 33.25 | 136600.0 |
| 2004-08-17 17:30:00 | QQQ | ETF | 33.25 | 33.29 | 33.25 | 33.28 | 37600.0 |
| 2004-08-17 18:00:00 | QQQ | ETF | 33.28 | 33.28 | 33.26 | 33.27 | 11600.0 |
| 2004-08-17 18:30:00 | QQQ | ETF | 33.27 | 33.28 | 33.27 | 33.27 | 2000.0 |
| 2004-08-17 19:00:00 | QQQ | ETF | 33.27 | 33.27 | 33.23 | 33.23 | 22200.0 |
| 2004-08-17 19:30:00 | QQQ | ETF | 33.23 | 33.24 | 33.22 | 33.22 | 6200.0 |
| 2004-08-17 08:30:00 | IWM | ETF | 53.035 | 53.045 | 52.94 | 52.94 | 18200.0 |
| 2004-08-17 09:00:00 | IWM | ETF | 52.94 | 52.995 | 52.94 | 52.975 | 37200.0 |
| 2004-08-17 09:30:00 | IWM | ETF | 52.96 | 53.225 | 52.79 | 53.1 | 1911400.0 |
> showing 50 of 1,155 rows — these rows as CSV