PREVIEW / etf_30min / 2001-06-20
file: by_date/etf_30min/2001/2001-06-20.parquet size: 15 KB rows: 387
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-06-20 09:30:00 | SPY | ETF | 121.19 | 122.17 | 121.1 | 122.11 | 1410800.0 |
| 2001-06-20 10:00:00 | SPY | ETF | 122.1 | 122.73 | 122.07 | 122.27 | 675500.0 |
| 2001-06-20 10:30:00 | SPY | ETF | 122.27 | 122.65 | 122.07 | 122.47 | 839300.0 |
| 2001-06-20 11:00:00 | SPY | ETF | 122.42 | 122.85 | 122.25 | 122.42 | 1137000.0 |
| 2001-06-20 11:30:00 | SPY | ETF | 122.46 | 122.47 | 121.84 | 121.91 | 282700.0 |
| 2001-06-20 12:00:00 | SPY | ETF | 121.88 | 122.04 | 121.67 | 121.9 | 182400.0 |
| 2001-06-20 12:30:00 | SPY | ETF | 121.88 | 122.17 | 121.88 | 121.95 | 342200.0 |
| 2001-06-20 13:00:00 | SPY | ETF | 121.92 | 122.03 | 121.72 | 121.76 | 247100.0 |
| 2001-06-20 13:30:00 | SPY | ETF | 121.75 | 121.85 | 121.41 | 121.63 | 310700.0 |
| 2001-06-20 14:00:00 | SPY | ETF | 121.58 | 122.23 | 121.55 | 122.23 | 394500.0 |
| 2001-06-20 14:30:00 | SPY | ETF | 122.16 | 122.38 | 121.97 | 122.12 | 324800.0 |
| 2001-06-20 15:00:00 | SPY | ETF | 122.06 | 122.86 | 122.06 | 122.65 | 905400.0 |
| 2001-06-20 15:30:00 | SPY | ETF | 122.6 | 122.8 | 122.32 | 122.6 | 810500.0 |
| 2001-06-20 16:00:00 | SPY | ETF | 122.6 | 122.74 | 122.23 | 122.45 | 759800.0 |
| 2001-06-20 16:30:00 | SPY | ETF | 122.45 | 122.65 | 122.45 | 122.47 | 1400.0 |
| 2001-06-20 17:30:00 | SPY | ETF | 122.16 | 122.16 | 122.16 | 122.16 | 1000.0 |
| 2001-06-20 09:30:00 | QQQ | ETF | 41.3 | 42.26 | 41.28 | 42.18 | 13347900.0 |
| 2001-06-20 10:00:00 | QQQ | ETF | 42.22 | 42.62 | 42.1 | 42.2 | 7144200.0 |
| 2001-06-20 10:30:00 | QQQ | ETF | 42.19 | 42.6 | 42.04 | 42.45 | 6129200.0 |
| 2001-06-20 11:00:00 | QQQ | ETF | 42.45 | 42.82 | 42.4 | 42.63 | 6239400.0 |
| 2001-06-20 11:30:00 | QQQ | ETF | 42.64 | 42.69 | 42.15 | 42.2 | 4676300.0 |
| 2001-06-20 12:00:00 | QQQ | ETF | 42.19 | 42.3 | 42.01 | 42.11 | 2831800.0 |
| 2001-06-20 12:30:00 | QQQ | ETF | 42.12 | 42.39 | 42.06 | 42.07 | 1538800.0 |
| 2001-06-20 13:00:00 | QQQ | ETF | 42.07 | 42.13 | 41.71 | 41.76 | 3496400.0 |
| 2001-06-20 13:30:00 | QQQ | ETF | 41.75 | 41.78 | 41.41 | 41.56 | 5422900.0 |
| 2001-06-20 14:00:00 | QQQ | ETF | 41.56 | 42.25 | 41.52 | 42.25 | 6900700.0 |
| 2001-06-20 14:30:00 | QQQ | ETF | 42.23 | 42.37 | 41.88 | 41.91 | 7013600.0 |
| 2001-06-20 15:00:00 | QQQ | ETF | 41.93 | 42.75 | 41.9 | 42.6 | 6212000.0 |
| 2001-06-20 15:30:00 | QQQ | ETF | 42.6 | 42.97 | 42.52 | 42.92 | 7992500.0 |
| 2001-06-20 16:00:00 | QQQ | ETF | 42.9 | 42.95 | 42.7 | 42.72 | 1591700.0 |
| 2001-06-20 16:30:00 | QQQ | ETF | 42.75 | 42.89 | 42.7 | 42.85 | 49500.0 |
| 2001-06-20 17:00:00 | QQQ | ETF | 42.87 | 42.9 | 42.78 | 42.85 | 38200.0 |
| 2001-06-20 17:30:00 | QQQ | ETF | 42.87 | 42.9 | 42.8 | 42.85 | 31200.0 |
| 2001-06-20 18:00:00 | QQQ | ETF | 42.89 | 42.92 | 42.82 | 42.9 | 15600.0 |
| 2001-06-20 09:30:00 | IWM | ETF | 48.5 | 48.875 | 48.5 | 48.795 | 78000.0 |
| 2001-06-20 10:00:00 | IWM | ETF | 48.8 | 49.125 | 48.8 | 49.0 | 65600.0 |
| 2001-06-20 10:30:00 | IWM | ETF | 49.0 | 49.05 | 48.875 | 49.025 | 49200.0 |
| 2001-06-20 11:00:00 | IWM | ETF | 49.035 | 49.19 | 49.035 | 49.115 | 132800.0 |
| 2001-06-20 11:30:00 | IWM | ETF | 49.135 | 49.135 | 48.945 | 49.015 | 32800.0 |
| 2001-06-20 12:00:00 | IWM | ETF | 49.015 | 49.015 | 48.915 | 48.915 | 19200.0 |
| 2001-06-20 12:30:00 | IWM | ETF | 48.925 | 48.955 | 48.875 | 48.945 | 37400.0 |
| 2001-06-20 13:00:00 | IWM | ETF | 48.95 | 48.955 | 48.825 | 48.83 | 41600.0 |
| 2001-06-20 13:30:00 | IWM | ETF | 48.875 | 48.875 | 48.735 | 48.745 | 26600.0 |
| 2001-06-20 14:00:00 | IWM | ETF | 48.74 | 48.9 | 48.74 | 48.89 | 49000.0 |
| 2001-06-20 14:30:00 | IWM | ETF | 49.0 | 49.075 | 48.975 | 49.075 | 46000.0 |
| 2001-06-20 15:00:00 | IWM | ETF | 49.07 | 49.29 | 49.045 | 49.24 | 94400.0 |
| 2001-06-20 15:30:00 | IWM | ETF | 49.28 | 49.55 | 49.24 | 49.55 | 147400.0 |
| 2001-06-20 16:00:00 | IWM | ETF | 49.495 | 49.5 | 49.4 | 49.425 | 37600.0 |
| 2001-06-20 09:30:00 | DIA | ETF | 105.95 | 106.6 | 105.85 | 106.55 | 305200.0 |
| 2001-06-20 10:00:00 | DIA | ETF | 106.55 | 107.14 | 106.55 | 106.95 | 245900.0 |
> showing 50 of 387 rows — these rows as CSV