PREVIEW / etf_30min / 2001-04-18
file: by_date/etf_30min/2001/2001-04-18.parquet size: 16 KB rows: 407
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-04-18 09:30:00 | SPY | ETF | 121.06 | 121.29 | 120.69 | 121.21 | 2121700.0 |
| 2001-04-18 10:00:00 | SPY | ETF | 121.24 | 121.65 | 120.95 | 121.34 | 1605400.0 |
| 2001-04-18 10:30:00 | SPY | ETF | 121.3 | 126.0 | 121.09 | 126.0 | 1805400.0 |
| 2001-04-18 11:00:00 | SPY | ETF | 124.56 | 125.6 | 123.61 | 123.97 | 2635100.0 |
| 2001-04-18 11:30:00 | SPY | ETF | 123.79 | 124.7 | 123.75 | 124.69 | 2139000.0 |
| 2001-04-18 12:00:00 | SPY | ETF | 124.69 | 124.85 | 124.3 | 124.75 | 740400.0 |
| 2001-04-18 12:30:00 | SPY | ETF | 124.79 | 124.86 | 124.33 | 124.44 | 484800.0 |
| 2001-04-18 13:00:00 | SPY | ETF | 124.45 | 124.55 | 124.05 | 124.55 | 545900.0 |
| 2001-04-18 13:30:00 | SPY | ETF | 124.54 | 124.75 | 124.44 | 124.65 | 1194800.0 |
| 2001-04-18 14:00:00 | SPY | ETF | 124.69 | 124.94 | 124.35 | 124.86 | 1499200.0 |
| 2001-04-18 14:30:00 | SPY | ETF | 124.81 | 125.26 | 124.8 | 124.87 | 1264100.0 |
| 2001-04-18 15:00:00 | SPY | ETF | 124.83 | 124.98 | 124.11 | 124.25 | 1370500.0 |
| 2001-04-18 15:30:00 | SPY | ETF | 124.15 | 124.3 | 123.86 | 124.14 | 1602800.0 |
| 2001-04-18 16:00:00 | SPY | ETF | 124.06 | 124.43 | 123.91 | 124.37 | 7484400.0 |
| 2001-04-18 16:30:00 | SPY | ETF | 123.65 | 124.95 | 123.5 | 124.9 | 5226900.0 |
| 2001-04-18 17:00:00 | SPY | ETF | 124.91 | 125.15 | 124.91 | 125.1 | 9700.0 |
| 2001-04-18 17:30:00 | SPY | ETF | 125.15 | 125.43 | 125.15 | 125.4 | 116400.0 |
| 2001-04-18 18:00:00 | SPY | ETF | 125.3 | 125.38 | 125.0 | 125.37 | 7500.0 |
| 2001-04-18 09:30:00 | QQQ | ETF | 43.72 | 43.94 | 43.35 | 43.75 | 15331800.0 |
| 2001-04-18 10:00:00 | QQQ | ETF | 43.75 | 44.34 | 43.69 | 44.15 | 10052700.0 |
| 2001-04-18 10:30:00 | QQQ | ETF | 44.1 | 51.0 | 43.88 | 46.5 | 14414300.0 |
| 2001-04-18 11:00:00 | QQQ | ETF | 46.5 | 48.0 | 45.5 | 45.57 | 20204100.0 |
| 2001-04-18 11:30:00 | QQQ | ETF | 45.55 | 46.22 | 45.4 | 46.15 | 10294200.0 |
| 2001-04-18 12:00:00 | QQQ | ETF | 46.18 | 46.6 | 46.0 | 46.46 | 5336000.0 |
| 2001-04-18 12:30:00 | QQQ | ETF | 46.47 | 46.65 | 46.31 | 46.33 | 4241800.0 |
| 2001-04-18 13:00:00 | QQQ | ETF | 46.33 | 46.55 | 46.2 | 46.5 | 4209500.0 |
| 2001-04-18 13:30:00 | QQQ | ETF | 46.5 | 46.9 | 46.42 | 46.9 | 3434800.0 |
| 2001-04-18 14:00:00 | QQQ | ETF | 46.9 | 47.0 | 46.53 | 46.85 | 5096600.0 |
| 2001-04-18 14:30:00 | QQQ | ETF | 46.84 | 47.25 | 46.74 | 46.85 | 7430000.0 |
| 2001-04-18 15:00:00 | QQQ | ETF | 46.84 | 46.94 | 46.04 | 46.11 | 6644100.0 |
| 2001-04-18 15:30:00 | QQQ | ETF | 46.15 | 46.15 | 45.5 | 45.59 | 10168200.0 |
| 2001-04-18 16:00:00 | QQQ | ETF | 45.62 | 47.16 | 45.4 | 47.0 | 3469600.0 |
| 2001-04-18 16:30:00 | QQQ | ETF | 45.65 | 47.0 | 45.55 | 46.77 | 3945000.0 |
| 2001-04-18 17:00:00 | QQQ | ETF | 46.79 | 47.0 | 43.5 | 46.9 | 887800.0 |
| 2001-04-18 17:30:00 | QQQ | ETF | 46.9 | 47.0 | 46.75 | 46.85 | 996700.0 |
| 2001-04-18 18:00:00 | QQQ | ETF | 46.85 | 46.96 | 46.75 | 46.85 | 187700.0 |
| 2001-04-18 09:30:00 | IWM | ETF | 46.075 | 46.15 | 46.0 | 46.125 | 287800.0 |
| 2001-04-18 10:00:00 | IWM | ETF | 46.125 | 46.475 | 46.125 | 46.475 | 41400.0 |
| 2001-04-18 10:30:00 | IWM | ETF | 46.345 | 47.25 | 46.2 | 47.0 | 23200.0 |
| 2001-04-18 11:00:00 | IWM | ETF | 48.0 | 48.0 | 46.5 | 47.38 | 71200.0 |
| 2001-04-18 11:30:00 | IWM | ETF | 47.12 | 47.35 | 47.05 | 47.25 | 48000.0 |
| 2001-04-18 12:00:00 | IWM | ETF | 47.47 | 47.495 | 47.15 | 47.425 | 3800.0 |
| 2001-04-18 12:30:00 | IWM | ETF | 47.425 | 47.425 | 47.2 | 47.275 | 6800.0 |
| 2001-04-18 13:00:00 | IWM | ETF | 47.2 | 47.455 | 47.2 | 47.43 | 8400.0 |
| 2001-04-18 13:30:00 | IWM | ETF | 47.325 | 47.325 | 47.32 | 47.32 | 31000.0 |
| 2001-04-18 14:00:00 | IWM | ETF | 47.325 | 47.325 | 47.325 | 47.325 | 20000.0 |
| 2001-04-18 14:30:00 | IWM | ETF | 47.325 | 47.325 | 47.245 | 47.3 | 5400.0 |
| 2001-04-18 15:00:00 | IWM | ETF | 47.23 | 47.245 | 46.75 | 46.75 | 62800.0 |
| 2001-04-18 15:30:00 | IWM | ETF | 46.75 | 46.75 | 46.45 | 46.5 | 64800.0 |
| 2001-04-18 16:00:00 | IWM | ETF | 46.7 | 46.7 | 46.675 | 46.675 | 3400.0 |
> showing 50 of 407 rows — these rows as CSV