PREVIEW / etf_30min / 2001-07-13
file: by_date/etf_30min/2001/2001-07-13.parquet size: 14 KB rows: 351
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-13 09:30:00 | SPY | ETF | 120.84 | 121.17 | 120.7 | 120.77 | 1440800.0 |
| 2001-07-13 10:00:00 | SPY | ETF | 120.71 | 121.35 | 120.62 | 121.32 | 719300.0 |
| 2001-07-13 10:30:00 | SPY | ETF | 121.31 | 121.68 | 121.25 | 121.42 | 1055500.0 |
| 2001-07-13 11:00:00 | SPY | ETF | 121.42 | 121.42 | 121.11 | 121.29 | 232900.0 |
| 2001-07-13 11:30:00 | SPY | ETF | 121.23 | 121.78 | 121.22 | 121.59 | 526400.0 |
| 2001-07-13 12:00:00 | SPY | ETF | 121.65 | 121.88 | 121.51 | 121.88 | 774800.0 |
| 2001-07-13 12:30:00 | SPY | ETF | 121.81 | 122.1 | 121.81 | 121.91 | 244200.0 |
| 2001-07-13 13:00:00 | SPY | ETF | 121.94 | 122.17 | 121.83 | 121.92 | 322300.0 |
| 2001-07-13 13:30:00 | SPY | ETF | 121.95 | 122.02 | 121.81 | 121.93 | 226000.0 |
| 2001-07-13 14:00:00 | SPY | ETF | 121.92 | 122.1 | 121.76 | 122.1 | 222200.0 |
| 2001-07-13 14:30:00 | SPY | ETF | 122.1 | 122.18 | 121.99 | 122.01 | 341400.0 |
| 2001-07-13 15:00:00 | SPY | ETF | 122.03 | 122.32 | 121.66 | 121.66 | 412000.0 |
| 2001-07-13 15:30:00 | SPY | ETF | 121.65 | 121.97 | 121.48 | 121.9 | 2682000.0 |
| 2001-07-13 16:00:00 | SPY | ETF | 121.91 | 122.24 | 121.8 | 122.24 | 527400.0 |
| 2001-07-13 16:30:00 | SPY | ETF | 122.2 | 122.24 | 122.12 | 122.12 | 800.0 |
| 2001-07-13 18:00:00 | SPY | ETF | 122.05 | 122.05 | 122.0 | 122.0 | 200.0 |
| 2001-07-13 09:30:00 | QQQ | ETF | 43.38 | 43.54 | 43.02 | 43.02 | 8042100.0 |
| 2001-07-13 10:00:00 | QQQ | ETF | 43.15 | 43.35 | 42.9 | 43.3 | 5894100.0 |
| 2001-07-13 10:30:00 | QQQ | ETF | 43.3 | 43.59 | 43.22 | 43.48 | 5612400.0 |
| 2001-07-13 11:00:00 | QQQ | ETF | 43.48 | 43.5 | 43.2 | 43.45 | 2665700.0 |
| 2001-07-13 11:30:00 | QQQ | ETF | 43.4 | 43.95 | 43.39 | 43.86 | 6169800.0 |
| 2001-07-13 12:00:00 | QQQ | ETF | 43.86 | 43.94 | 43.71 | 43.89 | 1714000.0 |
| 2001-07-13 12:30:00 | QQQ | ETF | 43.9 | 44.1 | 43.86 | 44.05 | 4146300.0 |
| 2001-07-13 13:00:00 | QQQ | ETF | 44.05 | 44.43 | 44.0 | 44.21 | 4223600.0 |
| 2001-07-13 13:30:00 | QQQ | ETF | 44.22 | 44.29 | 43.91 | 43.95 | 3606900.0 |
| 2001-07-13 14:00:00 | QQQ | ETF | 43.96 | 44.05 | 43.8 | 44.05 | 3159300.0 |
| 2001-07-13 14:30:00 | QQQ | ETF | 44.05 | 44.11 | 43.84 | 43.88 | 2378900.0 |
| 2001-07-13 15:00:00 | QQQ | ETF | 43.88 | 44.05 | 43.4 | 43.4 | 3430000.0 |
| 2001-07-13 15:30:00 | QQQ | ETF | 43.4 | 43.68 | 43.2 | 43.65 | 5782300.0 |
| 2001-07-13 16:00:00 | QQQ | ETF | 43.64 | 43.7 | 43.56 | 43.67 | 1160400.0 |
| 2001-07-13 16:30:00 | QQQ | ETF | 43.7 | 43.76 | 43.15 | 43.6 | 107700.0 |
| 2001-07-13 17:00:00 | QQQ | ETF | 43.6 | 43.65 | 43.6 | 43.65 | 3500.0 |
| 2001-07-13 17:30:00 | QQQ | ETF | 43.65 | 43.65 | 43.6 | 43.65 | 4200.0 |
| 2001-07-13 18:00:00 | QQQ | ETF | 43.6 | 43.65 | 43.5 | 43.57 | 5000.0 |
| 2001-07-13 09:30:00 | IWM | ETF | 48.55 | 48.575 | 48.35 | 48.5 | 15400.0 |
| 2001-07-13 10:00:00 | IWM | ETF | 48.495 | 48.5 | 48.435 | 48.5 | 9600.0 |
| 2001-07-13 10:30:00 | IWM | ETF | 48.75 | 48.85 | 48.625 | 48.85 | 1400.0 |
| 2001-07-13 11:00:00 | IWM | ETF | 48.815 | 48.815 | 48.675 | 48.78 | 8600.0 |
| 2001-07-13 11:30:00 | IWM | ETF | 48.785 | 48.925 | 48.76 | 48.925 | 2400.0 |
| 2001-07-13 12:30:00 | IWM | ETF | 48.875 | 48.925 | 48.875 | 48.91 | 34200.0 |
| 2001-07-13 13:00:00 | IWM | ETF | 48.91 | 48.975 | 48.91 | 48.975 | 23600.0 |
| 2001-07-13 13:30:00 | IWM | ETF | 48.97 | 48.97 | 48.865 | 48.865 | 5600.0 |
| 2001-07-13 14:00:00 | IWM | ETF | 48.97 | 48.97 | 48.845 | 48.85 | 27000.0 |
| 2001-07-13 14:30:00 | IWM | ETF | 48.97 | 48.97 | 48.865 | 48.865 | 4400.0 |
| 2001-07-13 15:00:00 | IWM | ETF | 48.925 | 49.075 | 48.85 | 48.85 | 41400.0 |
| 2001-07-13 15:30:00 | IWM | ETF | 48.75 | 48.975 | 48.725 | 48.9 | 20800.0 |
| 2001-07-13 09:30:00 | DIA | ETF | 104.75 | 105.04 | 104.55 | 104.55 | 370500.0 |
| 2001-07-13 10:00:00 | DIA | ETF | 104.5 | 104.94 | 104.4 | 104.91 | 154400.0 |
| 2001-07-13 10:30:00 | DIA | ETF | 104.9 | 105.2 | 104.85 | 105.02 | 82200.0 |
| 2001-07-13 11:00:00 | DIA | ETF | 104.92 | 105.01 | 104.71 | 104.98 | 59000.0 |
> showing 50 of 351 rows — these rows as CSV