PREVIEW / etf_30min / 2001-09-04
file: by_date/etf_30min/2001/2001-09-04.parquet size: 16 KB rows: 404
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-09-04 09:30:00 | SPY | ETF | 113.85 | 114.07 | 113.44 | 114.06 | 1190600.0 |
| 2001-09-04 10:00:00 | SPY | ETF | 114.07 | 115.15 | 113.9 | 114.5 | 4657000.0 |
| 2001-09-04 10:30:00 | SPY | ETF | 114.46 | 114.95 | 114.46 | 114.91 | 1489900.0 |
| 2001-09-04 11:00:00 | SPY | ETF | 114.96 | 115.31 | 114.9 | 115.28 | 2022100.0 |
| 2001-09-04 11:30:00 | SPY | ETF | 115.3 | 115.5 | 115.28 | 115.37 | 1013300.0 |
| 2001-09-04 12:00:00 | SPY | ETF | 115.41 | 115.84 | 115.41 | 115.84 | 1206600.0 |
| 2001-09-04 12:30:00 | SPY | ETF | 115.88 | 116.05 | 115.76 | 115.85 | 1105700.0 |
| 2001-09-04 13:00:00 | SPY | ETF | 115.84 | 116.03 | 115.66 | 115.85 | 772000.0 |
| 2001-09-04 13:30:00 | SPY | ETF | 115.86 | 116.16 | 115.77 | 116.05 | 681500.0 |
| 2001-09-04 14:00:00 | SPY | ETF | 116.12 | 116.17 | 115.56 | 115.65 | 1493500.0 |
| 2001-09-04 14:30:00 | SPY | ETF | 115.65 | 115.85 | 115.48 | 115.8 | 742100.0 |
| 2001-09-04 15:00:00 | SPY | ETF | 115.77 | 115.77 | 114.71 | 114.79 | 1617000.0 |
| 2001-09-04 15:30:00 | SPY | ETF | 114.76 | 114.8 | 113.6 | 113.65 | 3604600.0 |
| 2001-09-04 16:00:00 | SPY | ETF | 113.65 | 113.78 | 113.36 | 113.65 | 1945900.0 |
| 2001-09-04 16:30:00 | SPY | ETF | 113.42 | 113.7 | 113.41 | 113.42 | 26600.0 |
| 2001-09-04 17:00:00 | SPY | ETF | 113.55 | 113.55 | 113.55 | 113.55 | 500.0 |
| 2001-09-04 17:30:00 | SPY | ETF | 113.43 | 113.43 | 113.25 | 113.25 | 4700.0 |
| 2001-09-04 18:00:00 | SPY | ETF | 113.45 | 113.45 | 113.45 | 113.45 | 1000.0 |
| 2001-09-04 09:30:00 | QQQ | ETF | 36.51 | 36.55 | 36.11 | 36.5 | 6886100.0 |
| 2001-09-04 10:00:00 | QQQ | ETF | 36.54 | 37.5 | 36.34 | 36.56 | 10204200.0 |
| 2001-09-04 10:30:00 | QQQ | ETF | 36.56 | 36.84 | 36.42 | 36.8 | 4137300.0 |
| 2001-09-04 11:00:00 | QQQ | ETF | 36.81 | 36.95 | 36.7 | 36.86 | 3878600.0 |
| 2001-09-04 11:30:00 | QQQ | ETF | 36.84 | 37.03 | 36.79 | 36.9 | 3955400.0 |
| 2001-09-04 12:00:00 | QQQ | ETF | 36.89 | 37.26 | 36.89 | 37.23 | 2734100.0 |
| 2001-09-04 12:30:00 | QQQ | ETF | 37.23 | 37.48 | 37.22 | 37.36 | 4617600.0 |
| 2001-09-04 13:00:00 | QQQ | ETF | 37.4 | 37.44 | 37.14 | 37.2 | 3472400.0 |
| 2001-09-04 13:30:00 | QQQ | ETF | 37.2 | 37.34 | 37.12 | 37.3 | 1683600.0 |
| 2001-09-04 14:00:00 | QQQ | ETF | 37.32 | 37.33 | 36.85 | 36.92 | 3425700.0 |
| 2001-09-04 14:30:00 | QQQ | ETF | 36.97 | 37.0 | 36.71 | 36.9 | 2608000.0 |
| 2001-09-04 15:00:00 | QQQ | ETF | 36.93 | 36.96 | 36.1 | 36.17 | 6059600.0 |
| 2001-09-04 15:30:00 | QQQ | ETF | 36.17 | 36.51 | 35.42 | 35.48 | 9496000.0 |
| 2001-09-04 16:00:00 | QQQ | ETF | 35.43 | 35.54 | 35.35 | 35.4 | 6242300.0 |
| 2001-09-04 16:30:00 | QQQ | ETF | 35.4 | 35.51 | 35.36 | 35.47 | 116000.0 |
| 2001-09-04 17:00:00 | QQQ | ETF | 35.46 | 35.48 | 35.41 | 35.43 | 623200.0 |
| 2001-09-04 17:30:00 | QQQ | ETF | 35.45 | 35.45 | 35.2 | 35.25 | 32000.0 |
| 2001-09-04 18:00:00 | QQQ | ETF | 35.23 | 37.33 | 35.2 | 35.37 | 13000.0 |
| 2001-09-04 09:30:00 | IWM | ETF | 46.85 | 46.85 | 46.505 | 46.745 | 30800.0 |
| 2001-09-04 10:00:00 | IWM | ETF | 46.9 | 47.095 | 46.9 | 46.9 | 41800.0 |
| 2001-09-04 10:30:00 | IWM | ETF | 47.045 | 47.045 | 46.9 | 47.045 | 15400.0 |
| 2001-09-04 11:00:00 | IWM | ETF | 47.045 | 47.075 | 46.95 | 46.95 | 31800.0 |
| 2001-09-04 11:30:00 | IWM | ETF | 47.04 | 47.095 | 47.02 | 47.055 | 6000.0 |
| 2001-09-04 12:00:00 | IWM | ETF | 47.12 | 47.125 | 47.095 | 47.125 | 55800.0 |
| 2001-09-04 12:30:00 | IWM | ETF | 47.245 | 47.245 | 47.125 | 47.125 | 233200.0 |
| 2001-09-04 13:00:00 | IWM | ETF | 47.125 | 47.125 | 47.12 | 47.12 | 10600.0 |
| 2001-09-04 13:30:00 | IWM | ETF | 47.195 | 47.195 | 47.105 | 47.105 | 7600.0 |
| 2001-09-04 14:00:00 | IWM | ETF | 47.15 | 47.18 | 47.075 | 47.1 | 6600.0 |
| 2001-09-04 14:30:00 | IWM | ETF | 47.095 | 47.155 | 46.96 | 47.155 | 4000.0 |
| 2001-09-04 15:00:00 | IWM | ETF | 47.17 | 47.17 | 47.05 | 47.05 | 5000.0 |
| 2001-09-04 15:30:00 | IWM | ETF | 46.755 | 46.895 | 46.5 | 46.505 | 220600.0 |
| 2001-09-04 16:00:00 | IWM | ETF | 46.5 | 46.6 | 46.5 | 46.6 | 14200.0 |
> showing 50 of 404 rows — these rows as CSV