PREVIEW / etf_30min / 2001-07-11
file: by_date/etf_30min/2001/2001-07-11.parquet size: 15 KB rows: 379
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-11 09:30:00 | SPY | ETF | 118.1 | 118.56 | 117.78 | 118.06 | 1761900.0 |
| 2001-07-11 10:00:00 | SPY | ETF | 118.07 | 118.89 | 118.03 | 118.65 | 1106000.0 |
| 2001-07-11 10:30:00 | SPY | ETF | 118.64 | 118.67 | 117.91 | 117.91 | 415600.0 |
| 2001-07-11 11:00:00 | SPY | ETF | 117.92 | 117.99 | 117.09 | 117.2 | 1242200.0 |
| 2001-07-11 11:30:00 | SPY | ETF | 117.25 | 117.59 | 117.2 | 117.55 | 740500.0 |
| 2001-07-11 12:00:00 | SPY | ETF | 117.55 | 118.83 | 117.55 | 117.98 | 799100.0 |
| 2001-07-11 12:30:00 | SPY | ETF | 117.9 | 118.29 | 117.9 | 118.16 | 471900.0 |
| 2001-07-11 13:00:00 | SPY | ETF | 118.19 | 118.79 | 118.02 | 118.58 | 2258900.0 |
| 2001-07-11 13:30:00 | SPY | ETF | 118.51 | 118.62 | 118.22 | 118.46 | 895600.0 |
| 2001-07-11 14:00:00 | SPY | ETF | 118.48 | 118.62 | 117.9 | 118.08 | 267700.0 |
| 2001-07-11 14:30:00 | SPY | ETF | 118.1 | 118.4 | 117.9 | 118.01 | 234500.0 |
| 2001-07-11 15:00:00 | SPY | ETF | 118.03 | 118.38 | 117.73 | 118.12 | 1481400.0 |
| 2001-07-11 15:30:00 | SPY | ETF | 118.15 | 118.45 | 117.9 | 118.27 | 1931300.0 |
| 2001-07-11 16:00:00 | SPY | ETF | 118.21 | 118.39 | 118.09 | 118.31 | 334400.0 |
| 2001-07-11 16:30:00 | SPY | ETF | 118.65 | 118.65 | 118.4 | 118.4 | 53900.0 |
| 2001-07-11 17:00:00 | SPY | ETF | 118.4 | 119.8 | 118.3 | 119.3 | 812400.0 |
| 2001-07-11 17:30:00 | SPY | ETF | 119.5 | 120.0 | 119.5 | 119.7 | 159100.0 |
| 2001-07-11 18:00:00 | SPY | ETF | 119.99 | 120.0 | 119.51 | 119.51 | 44300.0 |
| 2001-07-11 09:30:00 | QQQ | ETF | 40.42 | 40.71 | 40.12 | 40.48 | 9118800.0 |
| 2001-07-11 10:00:00 | QQQ | ETF | 40.5 | 41.1 | 40.41 | 40.79 | 5760700.0 |
| 2001-07-11 10:30:00 | QQQ | ETF | 40.78 | 40.89 | 40.35 | 40.41 | 5295200.0 |
| 2001-07-11 11:00:00 | QQQ | ETF | 40.42 | 40.44 | 39.87 | 40.1 | 7281700.0 |
| 2001-07-11 11:30:00 | QQQ | ETF | 40.1 | 40.37 | 39.94 | 40.26 | 4118700.0 |
| 2001-07-11 12:00:00 | QQQ | ETF | 40.26 | 40.7 | 40.25 | 40.5 | 4901400.0 |
| 2001-07-11 12:30:00 | QQQ | ETF | 40.44 | 40.79 | 40.43 | 40.69 | 2868300.0 |
| 2001-07-11 13:00:00 | QQQ | ETF | 40.7 | 41.09 | 40.55 | 41.0 | 6352900.0 |
| 2001-07-11 13:30:00 | QQQ | ETF | 40.99 | 41.04 | 40.68 | 40.86 | 3309400.0 |
| 2001-07-11 14:00:00 | QQQ | ETF | 40.85 | 41.05 | 40.46 | 40.64 | 4408600.0 |
| 2001-07-11 14:30:00 | QQQ | ETF | 40.59 | 40.9 | 40.51 | 40.57 | 3599100.0 |
| 2001-07-11 15:00:00 | QQQ | ETF | 40.53 | 40.86 | 40.37 | 40.58 | 5140500.0 |
| 2001-07-11 15:30:00 | QQQ | ETF | 40.59 | 40.93 | 40.42 | 40.9 | 5999900.0 |
| 2001-07-11 16:00:00 | QQQ | ETF | 40.86 | 41.22 | 40.67 | 41.15 | 1473700.0 |
| 2001-07-11 16:30:00 | QQQ | ETF | 41.16 | 41.45 | 41.15 | 41.35 | 458700.0 |
| 2001-07-11 17:00:00 | QQQ | ETF | 41.33 | 42.8 | 41.23 | 42.62 | 2646800.0 |
| 2001-07-11 17:30:00 | QQQ | ETF | 42.8 | 43.0 | 42.5 | 42.95 | 2019200.0 |
| 2001-07-11 18:00:00 | QQQ | ETF | 42.96 | 43.09 | 42.8 | 42.99 | 442900.0 |
| 2001-07-11 09:30:00 | IWM | ETF | 47.4 | 47.4 | 47.02 | 47.025 | 224600.0 |
| 2001-07-11 10:00:00 | IWM | ETF | 47.15 | 47.475 | 47.15 | 47.27 | 30200.0 |
| 2001-07-11 10:30:00 | IWM | ETF | 47.24 | 47.32 | 47.225 | 47.225 | 32600.0 |
| 2001-07-11 11:00:00 | IWM | ETF | 47.225 | 47.225 | 46.79 | 46.85 | 86600.0 |
| 2001-07-11 11:30:00 | IWM | ETF | 46.85 | 46.93 | 46.745 | 46.9 | 295000.0 |
| 2001-07-11 12:00:00 | IWM | ETF | 46.945 | 47.025 | 46.945 | 47.02 | 43600.0 |
| 2001-07-11 12:30:00 | IWM | ETF | 47.025 | 47.115 | 47.025 | 47.115 | 9800.0 |
| 2001-07-11 13:00:00 | IWM | ETF | 47.08 | 47.265 | 47.08 | 47.265 | 9800.0 |
| 2001-07-11 13:30:00 | IWM | ETF | 47.275 | 47.3 | 47.23 | 47.23 | 21400.0 |
| 2001-07-11 14:00:00 | IWM | ETF | 47.285 | 47.31 | 47.19 | 47.19 | 16400.0 |
| 2001-07-11 14:30:00 | IWM | ETF | 47.225 | 47.34 | 47.2 | 47.2 | 60800.0 |
| 2001-07-11 15:00:00 | IWM | ETF | 47.2 | 47.315 | 47.16 | 47.315 | 157000.0 |
| 2001-07-11 15:30:00 | IWM | ETF | 47.315 | 47.62 | 47.22 | 47.62 | 82400.0 |
| 2001-07-11 16:00:00 | IWM | ETF | 47.62 | 47.62 | 47.5 | 47.5 | 28200.0 |
> showing 50 of 379 rows — these rows as CSV