PREVIEW / etf_30min / 2001-05-25
file: by_date/etf_30min/2001/2001-05-25.parquet size: 14 KB rows: 355
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-25 09:30:00 | SPY | ETF | 129.65 | 129.7 | 129.29 | 129.5 | 938600.0 |
| 2001-05-25 10:00:00 | SPY | ETF | 129.53 | 129.53 | 128.4 | 128.61 | 1096900.0 |
| 2001-05-25 10:30:00 | SPY | ETF | 128.55 | 128.77 | 128.25 | 128.4 | 701100.0 |
| 2001-05-25 11:00:00 | SPY | ETF | 128.41 | 128.7 | 128.33 | 128.63 | 220200.0 |
| 2001-05-25 11:30:00 | SPY | ETF | 128.56 | 128.84 | 128.55 | 128.62 | 505400.0 |
| 2001-05-25 12:00:00 | SPY | ETF | 128.7 | 128.74 | 128.47 | 128.69 | 213500.0 |
| 2001-05-25 12:30:00 | SPY | ETF | 128.73 | 128.74 | 128.5 | 128.6 | 110500.0 |
| 2001-05-25 13:00:00 | SPY | ETF | 128.6 | 128.63 | 128.23 | 128.37 | 309000.0 |
| 2001-05-25 13:30:00 | SPY | ETF | 128.42 | 128.68 | 128.3 | 128.66 | 356100.0 |
| 2001-05-25 14:00:00 | SPY | ETF | 128.6 | 128.74 | 128.53 | 128.58 | 231800.0 |
| 2001-05-25 14:30:00 | SPY | ETF | 128.55 | 128.7 | 128.4 | 128.4 | 194700.0 |
| 2001-05-25 15:00:00 | SPY | ETF | 128.35 | 128.47 | 128.07 | 128.1 | 744200.0 |
| 2001-05-25 15:30:00 | SPY | ETF | 128.09 | 128.59 | 128.01 | 128.23 | 877700.0 |
| 2001-05-25 16:00:00 | SPY | ETF | 128.25 | 128.27 | 127.9 | 128.1 | 373200.0 |
| 2001-05-25 09:30:00 | QQQ | ETF | 49.96 | 50.02 | 49.51 | 49.67 | 6742700.0 |
| 2001-05-25 10:00:00 | QQQ | ETF | 49.67 | 49.75 | 48.65 | 48.85 | 7661500.0 |
| 2001-05-25 10:30:00 | QQQ | ETF | 48.8 | 49.03 | 48.7 | 48.79 | 3469100.0 |
| 2001-05-25 11:00:00 | QQQ | ETF | 48.79 | 49.0 | 48.7 | 48.94 | 2100200.0 |
| 2001-05-25 11:30:00 | QQQ | ETF | 48.94 | 49.15 | 48.84 | 49.01 | 2293700.0 |
| 2001-05-25 12:00:00 | QQQ | ETF | 49.0 | 49.17 | 48.81 | 49.03 | 1100200.0 |
| 2001-05-25 12:30:00 | QQQ | ETF | 49.07 | 49.17 | 48.95 | 49.06 | 734500.0 |
| 2001-05-25 13:00:00 | QQQ | ETF | 49.06 | 49.1 | 48.81 | 48.91 | 1267300.0 |
| 2001-05-25 13:30:00 | QQQ | ETF | 48.95 | 49.2 | 48.87 | 49.14 | 1181000.0 |
| 2001-05-25 14:00:00 | QQQ | ETF | 49.12 | 49.29 | 49.05 | 49.16 | 2041700.0 |
| 2001-05-25 14:30:00 | QQQ | ETF | 49.15 | 49.24 | 48.96 | 49.0 | 1120200.0 |
| 2001-05-25 15:00:00 | QQQ | ETF | 48.97 | 49.05 | 48.76 | 48.8 | 1573000.0 |
| 2001-05-25 15:30:00 | QQQ | ETF | 48.79 | 49.08 | 48.73 | 48.9 | 3157400.0 |
| 2001-05-25 16:00:00 | QQQ | ETF | 48.97 | 49.85 | 48.85 | 49.0 | 509000.0 |
| 2001-05-25 16:30:00 | QQQ | ETF | 48.99 | 49.05 | 48.8 | 49.02 | 15000.0 |
| 2001-05-25 17:00:00 | QQQ | ETF | 49.0 | 49.01 | 48.97 | 49.0 | 9700.0 |
| 2001-05-25 17:30:00 | QQQ | ETF | 48.98 | 49.02 | 48.97 | 49.0 | 6100.0 |
| 2001-05-25 18:00:00 | QQQ | ETF | 48.98 | 49.05 | 48.94 | 48.94 | 4600.0 |
| 2001-05-25 09:30:00 | IWM | ETF | 51.05 | 51.1 | 50.925 | 51.075 | 20000.0 |
| 2001-05-25 10:00:00 | IWM | ETF | 51.1 | 51.1 | 50.75 | 50.775 | 55000.0 |
| 2001-05-25 10:30:00 | IWM | ETF | 50.82 | 50.87 | 50.755 | 50.805 | 11400.0 |
| 2001-05-25 11:00:00 | IWM | ETF | 50.8 | 50.925 | 50.725 | 50.915 | 37800.0 |
| 2001-05-25 11:30:00 | IWM | ETF | 50.91 | 50.96 | 50.91 | 50.96 | 4800.0 |
| 2001-05-25 12:00:00 | IWM | ETF | 50.95 | 50.95 | 50.925 | 50.935 | 9600.0 |
| 2001-05-25 12:30:00 | IWM | ETF | 50.96 | 50.96 | 50.95 | 50.95 | 6800.0 |
| 2001-05-25 13:00:00 | IWM | ETF | 50.865 | 50.865 | 50.78 | 50.78 | 26800.0 |
| 2001-05-25 13:30:00 | IWM | ETF | 50.825 | 50.87 | 50.765 | 50.765 | 91400.0 |
| 2001-05-25 14:00:00 | IWM | ETF | 50.87 | 51.0 | 50.87 | 51.0 | 5600.0 |
| 2001-05-25 14:30:00 | IWM | ETF | 51.025 | 51.025 | 50.97 | 50.97 | 3000.0 |
| 2001-05-25 15:00:00 | IWM | ETF | 50.96 | 50.96 | 50.95 | 50.96 | 2600.0 |
| 2001-05-25 15:30:00 | IWM | ETF | 50.96 | 50.96 | 50.655 | 50.655 | 45400.0 |
| 2001-05-25 16:00:00 | IWM | ETF | 50.8 | 50.8 | 50.65 | 50.65 | 8000.0 |
| 2001-05-25 09:30:00 | DIA | ETF | 111.35 | 111.35 | 110.92 | 111.05 | 236100.0 |
| 2001-05-25 10:00:00 | DIA | ETF | 111.05 | 111.05 | 110.36 | 110.6 | 209300.0 |
| 2001-05-25 10:30:00 | DIA | ETF | 110.47 | 110.65 | 110.25 | 110.32 | 174800.0 |
| 2001-05-25 11:00:00 | DIA | ETF | 110.32 | 110.63 | 110.31 | 110.45 | 160400.0 |
> showing 50 of 355 rows — these rows as CSV