PREVIEW / etf_30min / 2004-09-15
file: by_date/etf_30min/2004/2004-09-15.parquet size: 34 KB rows: 1,140
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-09-15 08:00:00 | SPY | ETF | 113.33 | 113.35 | 113.27 | 113.3 | 59500.0 |
| 2004-09-15 08:30:00 | SPY | ETF | 113.33 | 113.4 | 113.33 | 113.4 | 18800.0 |
| 2004-09-15 09:00:00 | SPY | ETF | 113.37 | 113.41 | 113.31 | 113.33 | 27100.0 |
| 2004-09-15 09:30:00 | SPY | ETF | 113.3 | 113.36 | 113.05 | 113.09 | 4300100.0 |
| 2004-09-15 10:00:00 | SPY | ETF | 113.09 | 113.13 | 112.75 | 112.9 | 4812100.0 |
| 2004-09-15 10:30:00 | SPY | ETF | 112.9 | 112.91 | 112.7 | 112.82 | 4802200.0 |
| 2004-09-15 11:00:00 | SPY | ETF | 112.83 | 112.97 | 112.74 | 112.94 | 3836900.0 |
| 2004-09-15 11:30:00 | SPY | ETF | 112.94 | 112.95 | 112.82 | 112.88 | 828200.0 |
| 2004-09-15 12:00:00 | SPY | ETF | 112.88 | 112.93 | 112.77 | 112.77 | 728700.0 |
| 2004-09-15 12:30:00 | SPY | ETF | 112.77 | 112.84 | 112.68 | 112.78 | 1605800.0 |
| 2004-09-15 13:00:00 | SPY | ETF | 112.78 | 112.88 | 112.77 | 112.87 | 1528100.0 |
| 2004-09-15 13:30:00 | SPY | ETF | 112.88 | 113.09 | 112.85 | 113.07 | 1799100.0 |
| 2004-09-15 14:00:00 | SPY | ETF | 113.08 | 113.12 | 112.96 | 112.99 | 3304700.0 |
| 2004-09-15 14:30:00 | SPY | ETF | 112.99 | 113.16 | 112.93 | 112.97 | 1890900.0 |
| 2004-09-15 15:00:00 | SPY | ETF | 112.97 | 113.06 | 112.85 | 112.93 | 2088300.0 |
| 2004-09-15 15:30:00 | SPY | ETF | 112.94 | 112.96 | 112.71 | 112.74 | 2979500.0 |
| 2004-09-15 16:00:00 | SPY | ETF | 112.71 | 112.9149 | 112.7 | 112.78 | 1971900.0 |
| 2004-09-15 16:30:00 | SPY | ETF | 112.78 | 113.0 | 112.76 | 112.9 | 124100.0 |
| 2004-09-15 17:00:00 | SPY | ETF | 112.88 | 112.88 | 112.85 | 112.85 | 115500.0 |
| 2004-09-15 17:30:00 | SPY | ETF | 112.83 | 112.85 | 112.78 | 112.85 | 100100.0 |
| 2004-09-15 18:00:00 | SPY | ETF | 112.85 | 112.86 | 112.85 | 112.85 | 2400.0 |
| 2004-09-15 18:30:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 300.0 |
| 2004-09-15 19:00:00 | SPY | ETF | 112.84 | 112.84 | 112.8 | 112.8 | 2100.0 |
| 2004-09-15 08:00:00 | QQQ | ETF | 35.38 | 35.42 | 35.38 | 35.41 | 79500.0 |
| 2004-09-15 08:30:00 | QQQ | ETF | 35.42 | 35.46 | 35.42 | 35.45 | 133000.0 |
| 2004-09-15 09:00:00 | QQQ | ETF | 35.44 | 35.45 | 35.39 | 35.43 | 126900.0 |
| 2004-09-15 09:30:00 | QQQ | ETF | 35.42 | 35.45 | 35.28 | 35.305 | 17221600.0 |
| 2004-09-15 10:00:00 | QQQ | ETF | 35.3 | 35.37 | 35.25 | 35.29 | 8222400.0 |
| 2004-09-15 10:30:00 | QQQ | ETF | 35.29 | 35.3 | 35.21 | 35.268 | 7352500.0 |
| 2004-09-15 11:00:00 | QQQ | ETF | 35.27 | 35.34 | 35.22 | 35.28 | 5736000.0 |
| 2004-09-15 11:30:00 | QQQ | ETF | 35.28 | 35.3 | 35.21 | 35.23 | 2549900.0 |
| 2004-09-15 12:00:00 | QQQ | ETF | 35.23 | 35.27 | 35.15 | 35.1706 | 3737300.0 |
| 2004-09-15 12:30:00 | QQQ | ETF | 35.173 | 35.19 | 35.12 | 35.16 | 7021300.0 |
| 2004-09-15 13:00:00 | QQQ | ETF | 35.16 | 35.24 | 35.15 | 35.21 | 4104300.0 |
| 2004-09-15 13:30:00 | QQQ | ETF | 35.21 | 35.31 | 35.2 | 35.3 | 3614800.0 |
| 2004-09-15 14:00:00 | QQQ | ETF | 35.3 | 35.33 | 35.24 | 35.28 | 4238500.0 |
| 2004-09-15 14:30:00 | QQQ | ETF | 35.27 | 35.36 | 35.26 | 35.28 | 5115300.0 |
| 2004-09-15 15:00:00 | QQQ | ETF | 35.28 | 35.31 | 35.22 | 35.285 | 4685400.0 |
| 2004-09-15 15:30:00 | QQQ | ETF | 35.288 | 35.3 | 35.18 | 35.206 | 9188600.0 |
| 2004-09-15 16:00:00 | QQQ | ETF | 35.19 | 35.27 | 35.19 | 35.25 | 1580900.0 |
| 2004-09-15 16:30:00 | QQQ | ETF | 35.25 | 35.32 | 35.24 | 35.29 | 426400.0 |
| 2004-09-15 17:00:00 | QQQ | ETF | 35.29 | 35.3 | 35.2 | 35.29 | 291200.0 |
| 2004-09-15 17:30:00 | QQQ | ETF | 35.29 | 35.29 | 35.25 | 35.27 | 63800.0 |
| 2004-09-15 18:00:00 | QQQ | ETF | 35.28 | 35.3 | 35.26 | 35.26 | 36400.0 |
| 2004-09-15 18:30:00 | QQQ | ETF | 35.27 | 35.27 | 35.27 | 35.27 | 3400.0 |
| 2004-09-15 19:00:00 | QQQ | ETF | 35.26 | 35.26 | 35.25 | 35.25 | 15000.0 |
| 2004-09-15 19:30:00 | QQQ | ETF | 35.25 | 35.26 | 35.25 | 35.26 | 7000.0 |
| 2004-09-15 08:00:00 | IWM | ETF | 56.79 | 56.89 | 56.77 | 56.89 | 12200.0 |
| 2004-09-15 08:30:00 | IWM | ETF | 56.85 | 56.85 | 56.85 | 56.85 | 800.0 |
| 2004-09-15 09:00:00 | IWM | ETF | 56.82 | 56.82 | 56.81 | 56.81 | 3600.0 |
> showing 50 of 1,140 rows — these rows as CSV