PREVIEW / etf_30min / 2001-07-16
file: by_date/etf_30min/2001/2001-07-16.parquet size: 15 KB rows: 372
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-16 09:30:00 | SPY | ETF | 121.77 | 122.28 | 121.77 | 121.83 | 1205400.0 |
| 2001-07-16 10:00:00 | SPY | ETF | 121.76 | 121.95 | 121.55 | 121.73 | 434500.0 |
| 2001-07-16 10:30:00 | SPY | ETF | 121.75 | 121.9 | 121.43 | 121.85 | 370100.0 |
| 2001-07-16 11:00:00 | SPY | ETF | 121.79 | 122.06 | 121.72 | 121.95 | 121400.0 |
| 2001-07-16 11:30:00 | SPY | ETF | 122.0 | 122.0 | 121.35 | 121.41 | 231600.0 |
| 2001-07-16 12:00:00 | SPY | ETF | 121.41 | 121.46 | 121.23 | 121.43 | 233600.0 |
| 2001-07-16 12:30:00 | SPY | ETF | 121.43 | 121.43 | 121.03 | 121.06 | 193200.0 |
| 2001-07-16 13:00:00 | SPY | ETF | 121.11 | 121.12 | 120.85 | 120.85 | 255500.0 |
| 2001-07-16 13:30:00 | SPY | ETF | 120.9 | 120.9 | 120.43 | 120.53 | 412900.0 |
| 2001-07-16 14:00:00 | SPY | ETF | 120.6 | 120.75 | 120.32 | 120.5 | 574900.0 |
| 2001-07-16 14:30:00 | SPY | ETF | 120.47 | 120.85 | 120.46 | 120.73 | 464800.0 |
| 2001-07-16 15:00:00 | SPY | ETF | 120.74 | 120.89 | 120.45 | 120.49 | 524000.0 |
| 2001-07-16 15:30:00 | SPY | ETF | 120.46 | 120.64 | 120.29 | 120.6 | 997300.0 |
| 2001-07-16 16:00:00 | SPY | ETF | 120.51 | 121.1 | 120.51 | 121.09 | 616400.0 |
| 2001-07-16 16:30:00 | SPY | ETF | 120.8 | 120.85 | 120.44 | 120.85 | 9100.0 |
| 2001-07-16 17:00:00 | SPY | ETF | 120.64 | 120.64 | 120.31 | 120.6 | 2100.0 |
| 2001-07-16 17:30:00 | SPY | ETF | 120.35 | 120.35 | 120.35 | 120.35 | 100.0 |
| 2001-07-16 09:30:00 | QQQ | ETF | 43.37 | 43.86 | 43.23 | 43.25 | 6039500.0 |
| 2001-07-16 10:00:00 | QQQ | ETF | 43.24 | 43.53 | 43.11 | 43.37 | 5914400.0 |
| 2001-07-16 10:30:00 | QQQ | ETF | 43.37 | 43.5 | 43.2 | 43.4 | 2471300.0 |
| 2001-07-16 11:00:00 | QQQ | ETF | 43.4 | 43.64 | 43.27 | 43.53 | 2258500.0 |
| 2001-07-16 11:30:00 | QQQ | ETF | 43.52 | 43.54 | 42.95 | 42.95 | 3454200.0 |
| 2001-07-16 12:00:00 | QQQ | ETF | 42.95 | 43.03 | 42.57 | 42.73 | 3581100.0 |
| 2001-07-16 12:30:00 | QQQ | ETF | 42.74 | 42.75 | 42.31 | 42.35 | 3120100.0 |
| 2001-07-16 13:00:00 | QQQ | ETF | 42.35 | 42.39 | 42.15 | 42.24 | 2826000.0 |
| 2001-07-16 13:30:00 | QQQ | ETF | 42.23 | 42.34 | 42.01 | 42.26 | 3018100.0 |
| 2001-07-16 14:00:00 | QQQ | ETF | 42.27 | 42.49 | 42.1 | 42.3 | 3190200.0 |
| 2001-07-16 14:30:00 | QQQ | ETF | 42.3 | 42.55 | 42.25 | 42.27 | 3582400.0 |
| 2001-07-16 15:00:00 | QQQ | ETF | 42.26 | 42.44 | 42.04 | 42.1 | 3553800.0 |
| 2001-07-16 15:30:00 | QQQ | ETF | 42.03 | 42.2 | 41.9 | 42.0 | 6268800.0 |
| 2001-07-16 16:00:00 | QQQ | ETF | 42.0 | 42.35 | 41.92 | 42.3 | 2066500.0 |
| 2001-07-16 16:30:00 | QQQ | ETF | 42.3 | 42.59 | 42.12 | 42.18 | 58800.0 |
| 2001-07-16 17:00:00 | QQQ | ETF | 42.17 | 42.17 | 41.93 | 41.97 | 152800.0 |
| 2001-07-16 17:30:00 | QQQ | ETF | 42.0 | 42.16 | 41.92 | 41.93 | 40700.0 |
| 2001-07-16 18:00:00 | QQQ | ETF | 41.97 | 42.0 | 41.75 | 41.9 | 25900.0 |
| 2001-07-16 09:30:00 | IWM | ETF | 48.85 | 48.995 | 48.845 | 48.845 | 26000.0 |
| 2001-07-16 10:00:00 | IWM | ETF | 48.775 | 48.775 | 48.55 | 48.625 | 4200.0 |
| 2001-07-16 10:30:00 | IWM | ETF | 48.63 | 48.75 | 48.625 | 48.75 | 15800.0 |
| 2001-07-16 11:00:00 | IWM | ETF | 48.845 | 48.88 | 48.845 | 48.88 | 10600.0 |
| 2001-07-16 11:30:00 | IWM | ETF | 48.885 | 48.885 | 48.695 | 48.745 | 32200.0 |
| 2001-07-16 12:00:00 | IWM | ETF | 48.695 | 48.7 | 48.595 | 48.65 | 22200.0 |
| 2001-07-16 12:30:00 | IWM | ETF | 48.65 | 48.65 | 48.5 | 48.52 | 18800.0 |
| 2001-07-16 13:00:00 | IWM | ETF | 48.6 | 48.6 | 48.425 | 48.49 | 59600.0 |
| 2001-07-16 13:30:00 | IWM | ETF | 48.395 | 48.45 | 48.395 | 48.415 | 51000.0 |
| 2001-07-16 14:00:00 | IWM | ETF | 48.45 | 48.45 | 48.33 | 48.4 | 100600.0 |
| 2001-07-16 14:30:00 | IWM | ETF | 48.475 | 48.48 | 48.45 | 48.45 | 34600.0 |
| 2001-07-16 15:00:00 | IWM | ETF | 48.455 | 48.48 | 48.345 | 48.355 | 39400.0 |
| 2001-07-16 15:30:00 | IWM | ETF | 48.335 | 48.335 | 48.15 | 48.255 | 42600.0 |
| 2001-07-16 16:00:00 | IWM | ETF | 48.075 | 48.25 | 48.075 | 48.075 | 33600.0 |
| 2001-07-16 09:30:00 | DIA | ETF | 105.46 | 105.75 | 105.45 | 105.52 | 97600.0 |
> showing 50 of 372 rows — these rows as CSV