PREVIEW / etf_30min / 2001-05-02
file: by_date/etf_30min/2001/2001-05-02.parquet size: 15 KB rows: 377
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-05-02 09:30:00 | SPY | ETF | 127.41 | 127.69 | 126.55 | 126.8 | 1362000.0 |
| 2001-05-02 10:00:00 | SPY | ETF | 126.83 | 127.04 | 126.0 | 126.26 | 1176600.0 |
| 2001-05-02 10:30:00 | SPY | ETF | 126.34 | 126.59 | 126.11 | 126.5 | 483900.0 |
| 2001-05-02 11:00:00 | SPY | ETF | 126.46 | 126.52 | 126.06 | 126.17 | 408600.0 |
| 2001-05-02 11:30:00 | SPY | ETF | 126.15 | 126.72 | 126.03 | 126.56 | 608000.0 |
| 2001-05-02 12:00:00 | SPY | ETF | 126.68 | 126.91 | 126.44 | 126.86 | 234400.0 |
| 2001-05-02 12:30:00 | SPY | ETF | 126.86 | 126.86 | 126.38 | 126.4 | 154200.0 |
| 2001-05-02 13:00:00 | SPY | ETF | 126.46 | 126.6 | 126.24 | 126.55 | 201300.0 |
| 2001-05-02 13:30:00 | SPY | ETF | 126.6 | 127.35 | 126.52 | 127.18 | 679000.0 |
| 2001-05-02 14:00:00 | SPY | ETF | 127.21 | 127.57 | 126.95 | 127.2 | 935900.0 |
| 2001-05-02 14:30:00 | SPY | ETF | 127.2 | 127.63 | 127.11 | 127.19 | 778900.0 |
| 2001-05-02 15:00:00 | SPY | ETF | 127.18 | 127.58 | 126.78 | 126.95 | 681200.0 |
| 2001-05-02 15:30:00 | SPY | ETF | 126.86 | 127.11 | 126.6 | 126.89 | 711500.0 |
| 2001-05-02 16:00:00 | SPY | ETF | 126.91 | 127.18 | 126.72 | 126.82 | 310700.0 |
| 2001-05-02 16:30:00 | SPY | ETF | 126.96 | 127.01 | 126.96 | 126.98 | 2300.0 |
| 2001-05-02 17:00:00 | SPY | ETF | 127.0 | 127.03 | 127.0 | 127.0 | 101500.0 |
| 2001-05-02 17:30:00 | SPY | ETF | 126.84 | 126.84 | 126.84 | 126.84 | 100.0 |
| 2001-05-02 09:30:00 | QQQ | ETF | 48.8 | 49.4 | 48.55 | 48.85 | 14013100.0 |
| 2001-05-02 10:00:00 | QQQ | ETF | 48.78 | 48.99 | 47.9 | 48.3 | 8877500.0 |
| 2001-05-02 10:30:00 | QQQ | ETF | 48.29 | 48.5 | 48.08 | 48.5 | 4978300.0 |
| 2001-05-02 11:00:00 | QQQ | ETF | 48.42 | 48.5 | 47.76 | 47.92 | 4329300.0 |
| 2001-05-02 11:30:00 | QQQ | ETF | 47.9 | 48.42 | 47.7 | 48.33 | 4029200.0 |
| 2001-05-02 12:00:00 | QQQ | ETF | 48.34 | 48.83 | 48.06 | 48.7 | 3781100.0 |
| 2001-05-02 12:30:00 | QQQ | ETF | 48.7 | 48.82 | 48.36 | 48.43 | 2627600.0 |
| 2001-05-02 13:00:00 | QQQ | ETF | 48.39 | 48.6 | 48.2 | 48.5 | 1858000.0 |
| 2001-05-02 13:30:00 | QQQ | ETF | 48.44 | 49.12 | 48.36 | 49.03 | 4535600.0 |
| 2001-05-02 14:00:00 | QQQ | ETF | 49.05 | 49.25 | 48.77 | 49.13 | 4329600.0 |
| 2001-05-02 14:30:00 | QQQ | ETF | 49.14 | 49.4 | 48.9 | 48.97 | 5573600.0 |
| 2001-05-02 15:00:00 | QQQ | ETF | 48.92 | 49.3 | 48.56 | 48.67 | 4950900.0 |
| 2001-05-02 15:30:00 | QQQ | ETF | 48.7 | 48.95 | 48.43 | 48.9 | 7133000.0 |
| 2001-05-02 16:00:00 | QQQ | ETF | 48.9 | 49.0 | 48.8 | 48.99 | 1336500.0 |
| 2001-05-02 16:30:00 | QQQ | ETF | 48.91 | 49.06 | 48.9 | 48.99 | 52900.0 |
| 2001-05-02 17:00:00 | QQQ | ETF | 49.0 | 49.03 | 48.85 | 48.91 | 14800.0 |
| 2001-05-02 17:30:00 | QQQ | ETF | 48.9 | 48.9 | 48.8 | 48.86 | 7300.0 |
| 2001-05-02 18:00:00 | QQQ | ETF | 48.86 | 48.87 | 48.7 | 48.77 | 15300.0 |
| 2001-05-02 09:30:00 | IWM | ETF | 49.2 | 49.225 | 49.0 | 49.0 | 35200.0 |
| 2001-05-02 10:00:00 | IWM | ETF | 49.025 | 49.05 | 48.6 | 48.605 | 32800.0 |
| 2001-05-02 10:30:00 | IWM | ETF | 48.675 | 48.85 | 48.675 | 48.675 | 70600.0 |
| 2001-05-02 11:00:00 | IWM | ETF | 48.625 | 48.725 | 48.625 | 48.725 | 2000.0 |
| 2001-05-02 11:30:00 | IWM | ETF | 48.73 | 48.75 | 48.5 | 48.75 | 174200.0 |
| 2001-05-02 12:00:00 | IWM | ETF | 48.675 | 48.925 | 48.625 | 48.925 | 9400.0 |
| 2001-05-02 12:30:00 | IWM | ETF | 48.9 | 48.9 | 48.645 | 48.875 | 18600.0 |
| 2001-05-02 13:00:00 | IWM | ETF | 48.805 | 48.9 | 48.775 | 48.9 | 22000.0 |
| 2001-05-02 13:30:00 | IWM | ETF | 48.9 | 49.025 | 48.9 | 49.025 | 22600.0 |
| 2001-05-02 14:00:00 | IWM | ETF | 49.12 | 49.15 | 49.025 | 49.145 | 4400.0 |
| 2001-05-02 14:30:00 | IWM | ETF | 49.145 | 49.3 | 49.125 | 49.25 | 10600.0 |
| 2001-05-02 15:00:00 | IWM | ETF | 49.25 | 49.295 | 48.975 | 49.0 | 53400.0 |
| 2001-05-02 15:30:00 | IWM | ETF | 49.025 | 49.12 | 48.9 | 48.975 | 102000.0 |
| 2001-05-02 16:00:00 | IWM | ETF | 48.975 | 48.975 | 48.975 | 48.975 | 600.0 |
| 2001-05-02 09:30:00 | DIA | ETF | 109.05 | 109.49 | 108.45 | 108.51 | 726400.0 |
> showing 50 of 377 rows — these rows as CSV