PREVIEW / etf_30min / 2001-08-13
file: by_date/etf_30min/2001/2001-08-13.parquet size: 15 KB rows: 361
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-08-13 09:30:00 | SPY | ETF | 119.6 | 119.73 | 119.11 | 119.38 | 1124600.0 |
| 2001-08-13 10:00:00 | SPY | ETF | 119.42 | 119.72 | 119.25 | 119.33 | 633600.0 |
| 2001-08-13 10:30:00 | SPY | ETF | 119.31 | 119.39 | 118.95 | 119.11 | 617700.0 |
| 2001-08-13 11:00:00 | SPY | ETF | 119.13 | 119.43 | 119.06 | 119.13 | 270600.0 |
| 2001-08-13 11:30:00 | SPY | ETF | 119.15 | 119.33 | 119.0 | 119.21 | 534200.0 |
| 2001-08-13 12:00:00 | SPY | ETF | 119.23 | 119.35 | 119.08 | 119.15 | 96900.0 |
| 2001-08-13 12:30:00 | SPY | ETF | 119.13 | 119.18 | 118.81 | 118.91 | 245400.0 |
| 2001-08-13 13:00:00 | SPY | ETF | 118.91 | 119.4 | 118.91 | 119.34 | 252600.0 |
| 2001-08-13 13:30:00 | SPY | ETF | 119.35 | 119.54 | 119.24 | 119.48 | 298000.0 |
| 2001-08-13 14:00:00 | SPY | ETF | 119.55 | 119.6 | 119.43 | 119.46 | 430300.0 |
| 2001-08-13 14:30:00 | SPY | ETF | 119.46 | 119.63 | 119.26 | 119.61 | 348400.0 |
| 2001-08-13 15:00:00 | SPY | ETF | 119.61 | 119.85 | 119.5 | 119.53 | 1037900.0 |
| 2001-08-13 15:30:00 | SPY | ETF | 119.5 | 119.58 | 119.4 | 119.49 | 774300.0 |
| 2001-08-13 16:00:00 | SPY | ETF | 119.48 | 119.52 | 118.38 | 119.34 | 389500.0 |
| 2001-08-13 16:30:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 2800.0 |
| 2001-08-13 17:30:00 | SPY | ETF | 119.25 | 119.33 | 119.25 | 119.33 | 3800.0 |
| 2001-08-13 09:30:00 | QQQ | ETF | 40.59 | 40.71 | 40.3 | 40.5 | 5855600.0 |
| 2001-08-13 10:00:00 | QQQ | ETF | 40.5 | 40.79 | 40.45 | 40.53 | 4706000.0 |
| 2001-08-13 10:30:00 | QQQ | ETF | 40.5 | 40.65 | 40.2 | 40.34 | 4983200.0 |
| 2001-08-13 11:00:00 | QQQ | ETF | 40.35 | 40.55 | 40.3 | 40.4 | 3207400.0 |
| 2001-08-13 11:30:00 | QQQ | ETF | 40.34 | 40.49 | 40.25 | 40.38 | 1558100.0 |
| 2001-08-13 12:00:00 | QQQ | ETF | 40.41 | 40.53 | 40.31 | 40.4 | 1595800.0 |
| 2001-08-13 12:30:00 | QQQ | ETF | 40.38 | 40.5 | 40.32 | 40.35 | 852500.0 |
| 2001-08-13 13:00:00 | QQQ | ETF | 40.35 | 40.64 | 40.32 | 40.61 | 2132400.0 |
| 2001-08-13 13:30:00 | QQQ | ETF | 40.59 | 40.85 | 40.52 | 40.81 | 2896200.0 |
| 2001-08-13 14:00:00 | QQQ | ETF | 40.81 | 41.0 | 40.78 | 40.9 | 3932100.0 |
| 2001-08-13 14:30:00 | QQQ | ETF | 40.89 | 41.13 | 40.75 | 41.09 | 3265800.0 |
| 2001-08-13 15:00:00 | QQQ | ETF | 41.08 | 41.34 | 41.07 | 41.1 | 5181600.0 |
| 2001-08-13 15:30:00 | QQQ | ETF | 41.09 | 41.24 | 41.02 | 41.23 | 5276500.0 |
| 2001-08-13 16:00:00 | QQQ | ETF | 41.23 | 41.25 | 40.93 | 41.09 | 715600.0 |
| 2001-08-13 16:30:00 | QQQ | ETF | 41.15 | 41.15 | 41.08 | 41.08 | 23800.0 |
| 2001-08-13 17:00:00 | QQQ | ETF | 41.06 | 41.19 | 41.06 | 41.15 | 21300.0 |
| 2001-08-13 17:30:00 | QQQ | ETF | 41.15 | 41.18 | 41.11 | 41.11 | 4100.0 |
| 2001-08-13 18:00:00 | QQQ | ETF | 41.16 | 41.18 | 41.1 | 41.15 | 4800.0 |
| 2001-08-13 09:30:00 | IWM | ETF | 47.575 | 47.575 | 47.375 | 47.375 | 19400.0 |
| 2001-08-13 10:00:00 | IWM | ETF | 47.35 | 47.545 | 47.35 | 47.4 | 9400.0 |
| 2001-08-13 10:30:00 | IWM | ETF | 47.49 | 47.49 | 47.305 | 47.445 | 4600.0 |
| 2001-08-13 11:00:00 | IWM | ETF | 47.415 | 47.415 | 47.375 | 47.375 | 6400.0 |
| 2001-08-13 11:30:00 | IWM | ETF | 47.355 | 47.395 | 47.355 | 47.395 | 45600.0 |
| 2001-08-13 12:00:00 | IWM | ETF | 47.395 | 47.395 | 47.375 | 47.375 | 1000.0 |
| 2001-08-13 12:30:00 | IWM | ETF | 47.375 | 47.375 | 47.375 | 47.375 | 1200.0 |
| 2001-08-13 13:00:00 | IWM | ETF | 47.39 | 47.525 | 47.39 | 47.525 | 454400.0 |
| 2001-08-13 13:30:00 | IWM | ETF | 47.545 | 47.64 | 47.51 | 47.64 | 2200.0 |
| 2001-08-13 14:00:00 | IWM | ETF | 47.56 | 47.7 | 47.56 | 47.7 | 200200.0 |
| 2001-08-13 14:30:00 | IWM | ETF | 47.66 | 47.725 | 47.53 | 47.725 | 303600.0 |
| 2001-08-13 15:00:00 | IWM | ETF | 47.73 | 47.81 | 47.7 | 47.81 | 327400.0 |
| 2001-08-13 15:30:00 | IWM | ETF | 47.7 | 47.775 | 47.7 | 47.7 | 227800.0 |
| 2001-08-13 16:00:00 | IWM | ETF | 47.65 | 47.7 | 47.65 | 47.7 | 5000.0 |
| 2001-08-13 09:30:00 | DIA | ETF | 104.2 | 104.42 | 103.96 | 104.2 | 380000.0 |
| 2001-08-13 10:00:00 | DIA | ETF | 104.22 | 104.48 | 104.03 | 104.07 | 309000.0 |
> showing 50 of 361 rows — these rows as CSV