PREVIEW / etf_30min / 2001-07-30
file: by_date/etf_30min/2001/2001-07-30.parquet size: 14 KB rows: 360
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-07-30 09:30:00 | SPY | ETF | 121.19 | 121.35 | 120.82 | 120.87 | 613100.0 |
| 2001-07-30 10:00:00 | SPY | ETF | 120.81 | 120.84 | 120.5 | 120.71 | 501000.0 |
| 2001-07-30 10:30:00 | SPY | ETF | 120.7 | 120.95 | 120.3 | 120.35 | 451900.0 |
| 2001-07-30 11:00:00 | SPY | ETF | 120.42 | 120.79 | 120.42 | 120.67 | 306000.0 |
| 2001-07-30 11:30:00 | SPY | ETF | 120.68 | 120.98 | 120.65 | 120.81 | 992700.0 |
| 2001-07-30 12:00:00 | SPY | ETF | 120.92 | 121.1 | 120.73 | 120.79 | 679800.0 |
| 2001-07-30 12:30:00 | SPY | ETF | 120.77 | 120.98 | 120.71 | 120.91 | 416500.0 |
| 2001-07-30 13:00:00 | SPY | ETF | 120.85 | 121.07 | 120.67 | 120.91 | 339900.0 |
| 2001-07-30 13:30:00 | SPY | ETF | 120.91 | 121.04 | 120.8 | 120.87 | 241400.0 |
| 2001-07-30 14:00:00 | SPY | ETF | 120.85 | 120.85 | 120.47 | 120.6 | 381700.0 |
| 2001-07-30 14:30:00 | SPY | ETF | 120.56 | 120.66 | 120.35 | 120.49 | 1195400.0 |
| 2001-07-30 15:00:00 | SPY | ETF | 120.5 | 120.81 | 120.5 | 120.71 | 245100.0 |
| 2001-07-30 15:30:00 | SPY | ETF | 120.79 | 120.86 | 120.51 | 120.82 | 584600.0 |
| 2001-07-30 16:00:00 | SPY | ETF | 120.82 | 120.94 | 120.73 | 120.8 | 348200.0 |
| 2001-07-30 16:30:00 | SPY | ETF | 120.85 | 120.89 | 120.8 | 120.89 | 2500.0 |
| 2001-07-30 17:00:00 | SPY | ETF | 120.89 | 121.0 | 120.55 | 120.55 | 6200.0 |
| 2001-07-30 17:30:00 | SPY | ETF | 121.0 | 121.02 | 121.0 | 121.0 | 1100.0 |
| 2001-07-30 09:30:00 | QQQ | ETF | 42.13 | 42.27 | 41.81 | 41.81 | 4894300.0 |
| 2001-07-30 10:00:00 | QQQ | ETF | 41.85 | 41.9 | 41.55 | 41.71 | 4447200.0 |
| 2001-07-30 10:30:00 | QQQ | ETF | 41.7 | 41.93 | 41.52 | 41.59 | 2542300.0 |
| 2001-07-30 11:00:00 | QQQ | ETF | 41.62 | 41.92 | 41.55 | 41.83 | 2119000.0 |
| 2001-07-30 11:30:00 | QQQ | ETF | 41.78 | 42.18 | 41.78 | 42.09 | 3335100.0 |
| 2001-07-30 12:00:00 | QQQ | ETF | 42.13 | 42.3 | 41.92 | 42.0 | 2442900.0 |
| 2001-07-30 12:30:00 | QQQ | ETF | 42.02 | 42.12 | 41.89 | 42.09 | 1052100.0 |
| 2001-07-30 13:00:00 | QQQ | ETF | 42.09 | 42.21 | 41.91 | 42.13 | 1589400.0 |
| 2001-07-30 13:30:00 | QQQ | ETF | 42.1 | 42.2 | 41.91 | 41.95 | 1659900.0 |
| 2001-07-30 14:00:00 | QQQ | ETF | 41.93 | 41.94 | 41.58 | 41.7 | 2837100.0 |
| 2001-07-30 14:30:00 | QQQ | ETF | 41.7 | 41.7 | 41.4 | 41.4 | 3642100.0 |
| 2001-07-30 15:00:00 | QQQ | ETF | 41.43 | 41.75 | 41.4 | 41.68 | 2205800.0 |
| 2001-07-30 15:30:00 | QQQ | ETF | 41.62 | 41.7 | 41.45 | 41.65 | 4003000.0 |
| 2001-07-30 16:00:00 | QQQ | ETF | 41.64 | 41.7 | 41.56 | 41.68 | 1144400.0 |
| 2001-07-30 16:30:00 | QQQ | ETF | 41.7 | 41.75 | 41.65 | 41.75 | 153500.0 |
| 2001-07-30 17:00:00 | QQQ | ETF | 41.72 | 41.74 | 41.65 | 41.74 | 10400.0 |
| 2001-07-30 17:30:00 | QQQ | ETF | 41.74 | 41.75 | 41.68 | 41.7 | 5900.0 |
| 2001-07-30 18:00:00 | QQQ | ETF | 41.67 | 41.7 | 41.65 | 41.65 | 4900.0 |
| 2001-07-30 09:30:00 | IWM | ETF | 48.45 | 48.5 | 48.395 | 48.4 | 28200.0 |
| 2001-07-30 10:00:00 | IWM | ETF | 48.325 | 48.325 | 48.05 | 48.12 | 34600.0 |
| 2001-07-30 10:30:00 | IWM | ETF | 48.15 | 48.22 | 47.88 | 48.0 | 5200.0 |
| 2001-07-30 11:00:00 | IWM | ETF | 47.975 | 48.025 | 47.85 | 48.025 | 21800.0 |
| 2001-07-30 11:30:00 | IWM | ETF | 48.07 | 48.075 | 47.93 | 48.075 | 25400.0 |
| 2001-07-30 12:00:00 | IWM | ETF | 48.075 | 48.075 | 48.07 | 48.07 | 7000.0 |
| 2001-07-30 12:30:00 | IWM | ETF | 48.005 | 48.075 | 48.005 | 48.075 | 4800.0 |
| 2001-07-30 13:00:00 | IWM | ETF | 48.01 | 48.075 | 48.01 | 48.075 | 39600.0 |
| 2001-07-30 13:30:00 | IWM | ETF | 48.075 | 48.15 | 47.975 | 48.0 | 13000.0 |
| 2001-07-30 14:00:00 | IWM | ETF | 48.125 | 48.125 | 47.975 | 47.975 | 49600.0 |
| 2001-07-30 14:30:00 | IWM | ETF | 48.01 | 48.01 | 47.975 | 48.0 | 29000.0 |
| 2001-07-30 15:00:00 | IWM | ETF | 48.115 | 48.27 | 48.0 | 48.27 | 67000.0 |
| 2001-07-30 15:30:00 | IWM | ETF | 48.135 | 48.2 | 48.135 | 48.175 | 30400.0 |
| 2001-07-30 16:00:00 | IWM | ETF | 48.175 | 48.175 | 48.175 | 48.175 | 18600.0 |
| 2001-07-30 09:30:00 | DIA | ETF | 104.65 | 104.65 | 104.17 | 104.17 | 218800.0 |
> showing 50 of 360 rows — these rows as CSV