PREVIEW / etf_30min / 2001-07-12
file: by_date/etf_30min/2001/2001-07-12.parquet size: 15 KB rows: 369
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-12 09:30:00 | SPY | ETF | 119.5 | 120.13 | 119.31 | 120.1 | 2029600.0 |
| 2001-07-12 10:00:00 | SPY | ETF | 120.08 | 120.39 | 119.95 | 120.26 | 806500.0 |
| 2001-07-12 10:30:00 | SPY | ETF | 120.25 | 120.62 | 120.14 | 120.37 | 568600.0 |
| 2001-07-12 11:00:00 | SPY | ETF | 120.38 | 120.45 | 120.05 | 120.14 | 541800.0 |
| 2001-07-12 11:30:00 | SPY | ETF | 120.21 | 120.3 | 120.1 | 120.27 | 288300.0 |
| 2001-07-12 12:00:00 | SPY | ETF | 120.28 | 120.36 | 120.01 | 120.22 | 408600.0 |
| 2001-07-12 12:30:00 | SPY | ETF | 120.23 | 120.58 | 120.2 | 120.41 | 702900.0 |
| 2001-07-12 13:00:00 | SPY | ETF | 120.34 | 120.6 | 120.21 | 120.31 | 903800.0 |
| 2001-07-12 13:30:00 | SPY | ETF | 120.35 | 120.67 | 120.26 | 120.35 | 247900.0 |
| 2001-07-12 14:00:00 | SPY | ETF | 120.31 | 120.46 | 120.21 | 120.39 | 182500.0 |
| 2001-07-12 14:30:00 | SPY | ETF | 120.27 | 120.72 | 120.27 | 120.62 | 1257300.0 |
| 2001-07-12 15:00:00 | SPY | ETF | 120.68 | 121.29 | 120.57 | 121.25 | 1262100.0 |
| 2001-07-12 15:30:00 | SPY | ETF | 121.23 | 121.47 | 121.16 | 121.24 | 1598400.0 |
| 2001-07-12 16:00:00 | SPY | ETF | 121.16 | 121.32 | 121.07 | 121.32 | 818700.0 |
| 2001-07-12 16:30:00 | SPY | ETF | 121.15 | 121.15 | 121.15 | 121.15 | 300.0 |
| 2001-07-12 17:00:00 | SPY | ETF | 121.15 | 121.22 | 120.7 | 120.7 | 2100.0 |
| 2001-07-12 17:30:00 | SPY | ETF | 121.3 | 121.3 | 121.05 | 121.2 | 5600.0 |
| 2001-07-12 18:00:00 | SPY | ETF | 121.35 | 121.35 | 121.35 | 121.35 | 1000.0 |
| 2001-07-12 09:30:00 | QQQ | ETF | 42.63 | 42.94 | 42.3 | 42.79 | 12883700.0 |
| 2001-07-12 10:00:00 | QQQ | ETF | 42.79 | 43.0 | 42.64 | 42.7 | 6163500.0 |
| 2001-07-12 10:30:00 | QQQ | ETF | 42.7 | 42.92 | 42.59 | 42.65 | 4456000.0 |
| 2001-07-12 11:00:00 | QQQ | ETF | 42.65 | 42.76 | 42.42 | 42.66 | 4675800.0 |
| 2001-07-12 11:30:00 | QQQ | ETF | 42.64 | 42.75 | 42.54 | 42.67 | 1988000.0 |
| 2001-07-12 12:00:00 | QQQ | ETF | 42.69 | 42.9 | 42.55 | 42.81 | 3467800.0 |
| 2001-07-12 12:30:00 | QQQ | ETF | 42.83 | 43.14 | 42.81 | 42.98 | 4711400.0 |
| 2001-07-12 13:00:00 | QQQ | ETF | 42.98 | 43.12 | 42.87 | 42.95 | 2243900.0 |
| 2001-07-12 13:30:00 | QQQ | ETF | 42.91 | 43.2 | 42.81 | 43.01 | 2747000.0 |
| 2001-07-12 14:00:00 | QQQ | ETF | 43.02 | 43.1 | 42.85 | 43.05 | 2170500.0 |
| 2001-07-12 14:30:00 | QQQ | ETF | 43.05 | 43.43 | 42.97 | 43.38 | 5341200.0 |
| 2001-07-12 15:00:00 | QQQ | ETF | 43.35 | 43.75 | 43.27 | 43.71 | 6671100.0 |
| 2001-07-12 15:30:00 | QQQ | ETF | 43.71 | 43.83 | 43.56 | 43.62 | 7323100.0 |
| 2001-07-12 16:00:00 | QQQ | ETF | 43.59 | 43.75 | 43.4 | 43.52 | 2283300.0 |
| 2001-07-12 16:30:00 | QQQ | ETF | 43.5 | 43.57 | 43.4 | 43.5 | 285700.0 |
| 2001-07-12 17:00:00 | QQQ | ETF | 43.49 | 43.9 | 43.4 | 43.85 | 521700.0 |
| 2001-07-12 17:30:00 | QQQ | ETF | 43.9 | 44.0 | 43.84 | 43.95 | 391100.0 |
| 2001-07-12 18:00:00 | QQQ | ETF | 43.94 | 43.98 | 43.9 | 43.94 | 53000.0 |
| 2001-07-12 09:30:00 | IWM | ETF | 47.9 | 48.09 | 47.875 | 48.09 | 63400.0 |
| 2001-07-12 10:00:00 | IWM | ETF | 48.175 | 48.45 | 48.11 | 48.215 | 192600.0 |
| 2001-07-12 10:30:00 | IWM | ETF | 48.32 | 48.38 | 48.21 | 48.28 | 33400.0 |
| 2001-07-12 11:00:00 | IWM | ETF | 48.21 | 48.21 | 48.125 | 48.125 | 6000.0 |
| 2001-07-12 11:30:00 | IWM | ETF | 48.23 | 48.24 | 48.2 | 48.22 | 6000.0 |
| 2001-07-12 12:00:00 | IWM | ETF | 48.2 | 48.24 | 48.2 | 48.24 | 3800.0 |
| 2001-07-12 12:30:00 | IWM | ETF | 48.175 | 48.35 | 48.175 | 48.285 | 4200.0 |
| 2001-07-12 13:00:00 | IWM | ETF | 48.28 | 48.28 | 48.28 | 48.28 | 1000.0 |
| 2001-07-12 13:30:00 | IWM | ETF | 48.33 | 48.39 | 48.33 | 48.35 | 6600.0 |
| 2001-07-12 14:00:00 | IWM | ETF | 48.275 | 48.36 | 48.175 | 48.2 | 341000.0 |
| 2001-07-12 14:30:00 | IWM | ETF | 48.195 | 48.45 | 48.195 | 48.45 | 490600.0 |
| 2001-07-12 15:00:00 | IWM | ETF | 48.5 | 48.58 | 48.39 | 48.58 | 41600.0 |
| 2001-07-12 15:30:00 | IWM | ETF | 48.75 | 48.75 | 48.595 | 48.72 | 26800.0 |
| 2001-07-12 16:00:00 | IWM | ETF | 48.735 | 48.735 | 48.665 | 48.665 | 2800.0 |
> showing 50 of 369 rows — these rows as CSV