PREVIEW / etf_30min / 2001-03-07
file: by_date/etf_30min/2001/2001-03-07.parquet size: 14 KB rows: 345
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-03-07 09:30:00 | SPY | ETF | 126.9 | 126.9 | 126.2 | 126.3 | 1266300.0 |
| 2001-03-07 10:00:00 | SPY | ETF | 126.3 | 126.84 | 125.85 | 126.65 | 939100.0 |
| 2001-03-07 10:30:00 | SPY | ETF | 126.68 | 126.89 | 126.0 | 126.15 | 418400.0 |
| 2001-03-07 11:00:00 | SPY | ETF | 126.16 | 126.42 | 125.93 | 126.11 | 248900.0 |
| 2001-03-07 11:30:00 | SPY | ETF | 126.17 | 126.34 | 125.81 | 125.86 | 260100.0 |
| 2001-03-07 12:00:00 | SPY | ETF | 125.88 | 126.37 | 125.78 | 126.37 | 157500.0 |
| 2001-03-07 12:30:00 | SPY | ETF | 126.35 | 126.7 | 126.23 | 126.42 | 209100.0 |
| 2001-03-07 13:00:00 | SPY | ETF | 126.38 | 126.74 | 126.25 | 126.6 | 336700.0 |
| 2001-03-07 13:30:00 | SPY | ETF | 126.64 | 126.69 | 126.3 | 126.55 | 294800.0 |
| 2001-03-07 14:00:00 | SPY | ETF | 126.58 | 126.59 | 126.02 | 126.05 | 269200.0 |
| 2001-03-07 14:30:00 | SPY | ETF | 126.02 | 126.48 | 125.76 | 126.41 | 307200.0 |
| 2001-03-07 15:00:00 | SPY | ETF | 126.4 | 126.54 | 126.01 | 126.06 | 310500.0 |
| 2001-03-07 15:30:00 | SPY | ETF | 126.2 | 126.74 | 126.1 | 126.64 | 765700.0 |
| 2001-03-07 16:00:00 | SPY | ETF | 126.51 | 127.04 | 126.51 | 126.95 | 487100.0 |
| 2001-03-07 09:30:00 | QQQ | ETF | 50.4 | 50.43 | 49.45 | 49.55 | 9184900.0 |
| 2001-03-07 10:00:00 | QQQ | ETF | 49.53 | 49.99 | 49.0 | 49.9 | 5802700.0 |
| 2001-03-07 10:30:00 | QQQ | ETF | 49.99 | 50.12 | 49.32 | 49.48 | 3404600.0 |
| 2001-03-07 11:00:00 | QQQ | ETF | 49.45 | 49.7 | 49.24 | 49.31 | 3243400.0 |
| 2001-03-07 11:30:00 | QQQ | ETF | 49.3 | 49.57 | 49.04 | 49.05 | 2662400.0 |
| 2001-03-07 12:00:00 | QQQ | ETF | 49.04 | 49.55 | 48.97 | 49.5 | 4636400.0 |
| 2001-03-07 12:30:00 | QQQ | ETF | 49.52 | 50.0 | 49.41 | 49.83 | 4352500.0 |
| 2001-03-07 13:00:00 | QQQ | ETF | 49.8 | 50.3 | 49.75 | 50.2 | 4073000.0 |
| 2001-03-07 13:30:00 | QQQ | ETF | 50.18 | 50.28 | 49.94 | 50.18 | 2435400.0 |
| 2001-03-07 14:00:00 | QQQ | ETF | 50.18 | 50.24 | 49.61 | 49.68 | 3348100.0 |
| 2001-03-07 14:30:00 | QQQ | ETF | 49.66 | 49.9 | 49.45 | 49.85 | 2016200.0 |
| 2001-03-07 15:00:00 | QQQ | ETF | 49.9 | 50.14 | 49.57 | 49.69 | 2962000.0 |
| 2001-03-07 15:30:00 | QQQ | ETF | 49.71 | 50.03 | 49.54 | 49.72 | 3715500.0 |
| 2001-03-07 16:00:00 | QQQ | ETF | 49.7 | 49.76 | 49.4 | 49.5 | 1358000.0 |
| 2001-03-07 16:30:00 | QQQ | ETF | 49.5 | 49.75 | 49.4 | 49.42 | 183400.0 |
| 2001-03-07 17:00:00 | QQQ | ETF | 49.5 | 49.75 | 49.4 | 49.5 | 34200.0 |
| 2001-03-07 17:30:00 | QQQ | ETF | 49.51 | 49.8 | 49.51 | 49.6 | 10600.0 |
| 2001-03-07 18:00:00 | QQQ | ETF | 49.6 | 49.8 | 49.45 | 49.5 | 28400.0 |
| 2001-03-07 09:30:00 | IWM | ETF | 48.4 | 48.575 | 48.2 | 48.45 | 41800.0 |
| 2001-03-07 10:00:00 | IWM | ETF | 48.275 | 48.495 | 48.125 | 48.495 | 62200.0 |
| 2001-03-07 10:30:00 | IWM | ETF | 48.575 | 48.6 | 48.33 | 48.33 | 70000.0 |
| 2001-03-07 11:00:00 | IWM | ETF | 48.445 | 48.445 | 48.15 | 48.15 | 2400.0 |
| 2001-03-07 11:30:00 | IWM | ETF | 48.325 | 48.325 | 48.125 | 48.125 | 1400.0 |
| 2001-03-07 12:00:00 | IWM | ETF | 48.125 | 48.125 | 48.125 | 48.125 | 1000.0 |
| 2001-03-07 12:30:00 | IWM | ETF | 48.325 | 48.475 | 48.15 | 48.475 | 11200.0 |
| 2001-03-07 13:00:00 | IWM | ETF | 48.275 | 48.5 | 48.275 | 48.5 | 96200.0 |
| 2001-03-07 13:30:00 | IWM | ETF | 48.4 | 48.425 | 48.375 | 48.425 | 800.0 |
| 2001-03-07 14:00:00 | IWM | ETF | 48.375 | 48.5 | 48.28 | 48.45 | 12400.0 |
| 2001-03-07 14:30:00 | IWM | ETF | 48.305 | 48.55 | 48.3 | 48.525 | 3000.0 |
| 2001-03-07 15:00:00 | IWM | ETF | 48.35 | 48.55 | 48.3 | 48.47 | 3400.0 |
| 2001-03-07 15:30:00 | IWM | ETF | 48.36 | 48.575 | 48.25 | 48.375 | 66600.0 |
| 2001-03-07 16:00:00 | IWM | ETF | 48.3 | 48.3 | 48.3 | 48.3 | 600.0 |
| 2001-03-07 09:30:00 | DIA | ETF | 106.8 | 106.95 | 106.4 | 106.89 | 165200.0 |
| 2001-03-07 10:00:00 | DIA | ETF | 106.75 | 107.11 | 106.5 | 106.94 | 297800.0 |
| 2001-03-07 10:30:00 | DIA | ETF | 106.94 | 107.17 | 106.51 | 106.72 | 131100.0 |
| 2001-03-07 11:00:00 | DIA | ETF | 106.69 | 106.88 | 106.3 | 106.63 | 115400.0 |
> showing 50 of 345 rows — these rows as CSV