PREVIEW / etf_30min / 2001-09-28
file: by_date/etf_30min/2001/2001-09-28.parquet size: 16 KB rows: 426
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-28 09:30:00 | SPY | ETF | 102.98 | 103.18 | 102.5 | 103.15 | 2285100.0 |
| 2001-09-28 10:00:00 | SPY | ETF | 103.12 | 104.11 | 102.93 | 103.57 | 4659700.0 |
| 2001-09-28 10:30:00 | SPY | ETF | 103.5 | 103.7 | 103.1 | 103.4 | 1375200.0 |
| 2001-09-28 11:00:00 | SPY | ETF | 103.45 | 103.98 | 103.36 | 103.83 | 1004100.0 |
| 2001-09-28 11:30:00 | SPY | ETF | 103.79 | 104.06 | 103.56 | 103.72 | 696200.0 |
| 2001-09-28 12:00:00 | SPY | ETF | 103.71 | 104.03 | 103.56 | 103.88 | 999000.0 |
| 2001-09-28 12:30:00 | SPY | ETF | 103.83 | 103.98 | 103.54 | 103.63 | 789900.0 |
| 2001-09-28 13:00:00 | SPY | ETF | 103.63 | 104.14 | 103.46 | 104.1 | 915300.0 |
| 2001-09-28 13:30:00 | SPY | ETF | 104.05 | 104.18 | 103.78 | 104.1 | 1265400.0 |
| 2001-09-28 14:00:00 | SPY | ETF | 104.13 | 104.14 | 103.56 | 103.9 | 1395000.0 |
| 2001-09-28 14:30:00 | SPY | ETF | 103.9 | 103.98 | 103.58 | 103.85 | 1026000.0 |
| 2001-09-28 15:00:00 | SPY | ETF | 103.86 | 104.25 | 103.82 | 104.14 | 1159600.0 |
| 2001-09-28 15:30:00 | SPY | ETF | 104.14 | 104.31 | 103.91 | 104.25 | 2087100.0 |
| 2001-09-28 16:00:00 | SPY | ETF | 104.31 | 104.45 | 103.8 | 104.3 | 771800.0 |
| 2001-09-28 16:30:00 | SPY | ETF | 104.3 | 104.4 | 104.11 | 104.11 | 5500.0 |
| 2001-09-28 17:00:00 | SPY | ETF | 104.11 | 104.36 | 104.11 | 104.11 | 4100.0 |
| 2001-09-28 17:30:00 | SPY | ETF | 104.12 | 104.12 | 104.11 | 104.11 | 500.0 |
| 2001-09-28 09:30:00 | QQQ | ETF | 28.84 | 28.97 | 28.53 | 28.77 | 12422900.0 |
| 2001-09-28 10:00:00 | QQQ | ETF | 28.78 | 29.32 | 28.73 | 29.01 | 13557800.0 |
| 2001-09-28 10:30:00 | QQQ | ETF | 29.01 | 29.07 | 28.61 | 28.83 | 9884600.0 |
| 2001-09-28 11:00:00 | QQQ | ETF | 28.83 | 29.21 | 28.8 | 29.1 | 3877800.0 |
| 2001-09-28 11:30:00 | QQQ | ETF | 29.1 | 29.35 | 29.05 | 29.15 | 5582000.0 |
| 2001-09-28 12:00:00 | QQQ | ETF | 29.14 | 29.3 | 29.07 | 29.16 | 3600700.0 |
| 2001-09-28 12:30:00 | QQQ | ETF | 29.18 | 29.21 | 28.92 | 28.98 | 2672700.0 |
| 2001-09-28 13:00:00 | QQQ | ETF | 28.96 | 29.25 | 28.9 | 29.17 | 2421300.0 |
| 2001-09-28 13:30:00 | QQQ | ETF | 29.17 | 29.24 | 29.0 | 29.15 | 3498900.0 |
| 2001-09-28 14:00:00 | QQQ | ETF | 29.17 | 29.2 | 28.93 | 29.1 | 2508300.0 |
| 2001-09-28 14:30:00 | QQQ | ETF | 29.1 | 29.12 | 28.83 | 29.0 | 3429400.0 |
| 2001-09-28 15:00:00 | QQQ | ETF | 28.99 | 29.3 | 28.93 | 29.2 | 5650300.0 |
| 2001-09-28 15:30:00 | QQQ | ETF | 29.2 | 29.22 | 28.87 | 29.06 | 10252500.0 |
| 2001-09-28 16:00:00 | QQQ | ETF | 29.05 | 29.1 | 28.94 | 29.04 | 2368400.0 |
| 2001-09-28 16:30:00 | QQQ | ETF | 29.07 | 29.1 | 29.0 | 29.07 | 99400.0 |
| 2001-09-28 17:00:00 | QQQ | ETF | 29.09 | 29.09 | 28.98 | 29.01 | 39800.0 |
| 2001-09-28 17:30:00 | QQQ | ETF | 29.0 | 29.05 | 28.95 | 29.05 | 39400.0 |
| 2001-09-28 18:00:00 | QQQ | ETF | 29.07 | 29.09 | 29.01 | 29.02 | 5500.0 |
| 2001-09-28 18:30:00 | QQQ | ETF | 29.02 | 29.02 | 29.02 | 29.02 | 100.0 |
| 2001-09-28 09:30:00 | IWM | ETF | 39.8 | 39.8 | 39.64 | 39.8 | 1048400.0 |
| 2001-09-28 10:00:00 | IWM | ETF | 40.175 | 40.3 | 40.05 | 40.175 | 187800.0 |
| 2001-09-28 10:30:00 | IWM | ETF | 40.2 | 40.225 | 39.97 | 40.025 | 170000.0 |
| 2001-09-28 11:00:00 | IWM | ETF | 40.1 | 40.18 | 40.05 | 40.05 | 82600.0 |
| 2001-09-28 11:30:00 | IWM | ETF | 40.1 | 40.15 | 40.1 | 40.15 | 70400.0 |
| 2001-09-28 12:00:00 | IWM | ETF | 40.07 | 40.15 | 40.07 | 40.15 | 43800.0 |
| 2001-09-28 12:30:00 | IWM | ETF | 40.2 | 40.225 | 40.125 | 40.125 | 10000.0 |
| 2001-09-28 13:00:00 | IWM | ETF | 40.075 | 40.175 | 40.075 | 40.175 | 2200.0 |
| 2001-09-28 13:30:00 | IWM | ETF | 40.175 | 40.225 | 40.16 | 40.22 | 8800.0 |
| 2001-09-28 14:00:00 | IWM | ETF | 40.225 | 40.245 | 40.125 | 40.24 | 53000.0 |
| 2001-09-28 14:30:00 | IWM | ETF | 40.235 | 40.235 | 40.15 | 40.19 | 36400.0 |
| 2001-09-28 15:00:00 | IWM | ETF | 40.175 | 40.39 | 40.175 | 40.355 | 59000.0 |
| 2001-09-28 15:30:00 | IWM | ETF | 40.3 | 40.375 | 40.22 | 40.225 | 75200.0 |
| 2001-09-28 16:00:00 | IWM | ETF | 40.125 | 40.275 | 40.05 | 40.1 | 408400.0 |
> showing 50 of 426 rows — these rows as CSV