PREVIEW / etf_30min / 2004-02-23
file: by_date/etf_30min/2004/2004-02-23.parquet size: 36 KB rows: 1,199
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-02-23 08:00:00 | SPY | ETF | 115.18 | 115.23 | 115.18 | 115.23 | 2500.0 |
| 2004-02-23 08:30:00 | SPY | ETF | 115.19 | 115.23 | 115.19 | 115.22 | 12100.0 |
| 2004-02-23 09:00:00 | SPY | ETF | 115.23 | 115.29 | 115.2 | 115.2 | 19300.0 |
| 2004-02-23 09:30:00 | SPY | ETF | 115.22 | 115.26 | 114.82 | 114.98 | 5045400.0 |
| 2004-02-23 10:00:00 | SPY | ETF | 114.99 | 115.1 | 114.57 | 114.73 | 4473500.0 |
| 2004-02-23 10:30:00 | SPY | ETF | 114.73 | 114.92 | 114.57 | 114.9 | 1998300.0 |
| 2004-02-23 11:00:00 | SPY | ETF | 114.9 | 114.92 | 114.51 | 114.51 | 1265100.0 |
| 2004-02-23 11:30:00 | SPY | ETF | 114.56 | 114.62 | 114.35 | 114.43 | 3103000.0 |
| 2004-02-23 12:00:00 | SPY | ETF | 114.43 | 114.53 | 114.21 | 114.48 | 3430600.0 |
| 2004-02-23 12:30:00 | SPY | ETF | 114.51 | 114.6 | 114.4 | 114.48 | 1661200.0 |
| 2004-02-23 13:00:00 | SPY | ETF | 114.47 | 114.71 | 114.47 | 114.49 | 1735700.0 |
| 2004-02-23 13:30:00 | SPY | ETF | 114.49 | 114.59 | 114.29 | 114.5 | 1152700.0 |
| 2004-02-23 14:00:00 | SPY | ETF | 114.47 | 114.51 | 114.17 | 114.33 | 1660900.0 |
| 2004-02-23 14:30:00 | SPY | ETF | 114.38 | 114.49 | 114.27 | 114.3 | 1839400.0 |
| 2004-02-23 15:00:00 | SPY | ETF | 114.3 | 114.6 | 114.29 | 114.4 | 2133800.0 |
| 2004-02-23 15:30:00 | SPY | ETF | 114.42 | 114.68 | 114.33 | 114.55 | 3598300.0 |
| 2004-02-23 16:00:00 | SPY | ETF | 114.52 | 114.61 | 114.46 | 114.53 | 829600.0 |
| 2004-02-23 16:30:00 | SPY | ETF | 114.57 | 114.61 | 114.56 | 114.57 | 67700.0 |
| 2004-02-23 17:00:00 | SPY | ETF | 114.57 | 114.59 | 114.56 | 114.58 | 41100.0 |
| 2004-02-23 17:30:00 | SPY | ETF | 114.55 | 114.55 | 114.55 | 114.55 | 500.0 |
| 2004-02-23 18:00:00 | SPY | ETF | 114.54 | 114.6 | 114.52 | 114.56 | 4100.0 |
| 2004-02-23 18:30:00 | SPY | ETF | 114.52 | 114.52 | 114.51 | 114.51 | 4000.0 |
| 2004-02-23 19:30:00 | SPY | ETF | 114.51 | 114.54 | 114.51 | 114.54 | 400.0 |
| 2004-02-23 08:00:00 | QQQ | ETF | 37.05 | 37.1 | 37.05 | 37.08 | 81200.0 |
| 2004-02-23 08:30:00 | QQQ | ETF | 37.07 | 37.08 | 37.03 | 37.06 | 205300.0 |
| 2004-02-23 09:00:00 | QQQ | ETF | 37.04 | 37.07 | 37.0 | 37.01 | 245300.0 |
| 2004-02-23 09:30:00 | QQQ | ETF | 37.0 | 37.03 | 36.68 | 36.79 | 16634700.0 |
| 2004-02-23 10:00:00 | QQQ | ETF | 36.789 | 36.83 | 36.53 | 36.61 | 11433000.0 |
| 2004-02-23 10:30:00 | QQQ | ETF | 36.6 | 36.7 | 36.51 | 36.68 | 8158800.0 |
| 2004-02-23 11:00:00 | QQQ | ETF | 36.675 | 36.7 | 36.45 | 36.51 | 5403100.0 |
| 2004-02-23 11:30:00 | QQQ | ETF | 36.45 | 36.5 | 36.36 | 36.376 | 10154000.0 |
| 2004-02-23 12:00:00 | QQQ | ETF | 36.38 | 36.45 | 36.29 | 36.43 | 8568200.0 |
| 2004-02-23 12:30:00 | QQQ | ETF | 36.44 | 36.47 | 36.37 | 36.38 | 3701100.0 |
| 2004-02-23 13:00:00 | QQQ | ETF | 36.38 | 36.55 | 36.37 | 36.43 | 6350800.0 |
| 2004-02-23 13:30:00 | QQQ | ETF | 36.42 | 36.45 | 36.32 | 36.39 | 5678200.0 |
| 2004-02-23 14:00:00 | QQQ | ETF | 36.39 | 36.4 | 36.11 | 36.23 | 10759900.0 |
| 2004-02-23 14:30:00 | QQQ | ETF | 36.26 | 36.324 | 36.15 | 36.19 | 8159000.0 |
| 2004-02-23 15:00:00 | QQQ | ETF | 36.19 | 36.36 | 36.16 | 36.29 | 11531800.0 |
| 2004-02-23 15:30:00 | QQQ | ETF | 36.29 | 36.42 | 36.23 | 36.399 | 11348000.0 |
| 2004-02-23 16:00:00 | QQQ | ETF | 36.38 | 36.46 | 36.36 | 36.43 | 2238800.0 |
| 2004-02-23 16:30:00 | QQQ | ETF | 36.43 | 36.48 | 36.4 | 36.41 | 495400.0 |
| 2004-02-23 17:00:00 | QQQ | ETF | 36.42 | 36.44 | 36.391 | 36.4 | 98800.0 |
| 2004-02-23 17:30:00 | QQQ | ETF | 36.4 | 36.422 | 36.33 | 36.35 | 152300.0 |
| 2004-02-23 18:00:00 | QQQ | ETF | 36.384 | 36.384 | 36.35 | 36.37 | 80500.0 |
| 2004-02-23 18:30:00 | QQQ | ETF | 36.38 | 36.38 | 36.36 | 36.37 | 20100.0 |
| 2004-02-23 19:00:00 | QQQ | ETF | 36.37 | 36.4 | 36.37 | 36.4 | 8700.0 |
| 2004-02-23 19:30:00 | QQQ | ETF | 36.4 | 36.42 | 36.4 | 36.42 | 1700.0 |
| 2004-02-23 08:30:00 | IWM | ETF | 58.015 | 58.015 | 58.015 | 58.015 | 800.0 |
| 2004-02-23 09:30:00 | IWM | ETF | 57.956 | 57.98 | 57.591 | 57.7 | 905200.0 |
| 2004-02-23 10:00:00 | IWM | ETF | 57.715 | 57.76 | 57.325 | 57.44 | 1189200.0 |
> showing 50 of 1,199 rows — these rows as CSV