PREVIEW / etf_30min / 2001-09-17
file: by_date/etf_30min/2001/2001-09-17.parquet size: 17 KB rows: 441
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-09-17 09:30:00 | SPY | ETF | 101.0 | 104.5 | 101.0 | 103.75 | 3848500.0 |
| 2001-09-17 10:00:00 | SPY | ETF | 103.79 | 104.9 | 102.4 | 104.4 | 3291100.0 |
| 2001-09-17 10:30:00 | SPY | ETF | 104.5 | 106.0 | 104.3 | 105.7 | 3528100.0 |
| 2001-09-17 11:00:00 | SPY | ETF | 105.49 | 105.8 | 104.95 | 105.4 | 3345300.0 |
| 2001-09-17 11:30:00 | SPY | ETF | 105.5 | 106.4 | 105.3 | 105.93 | 2964000.0 |
| 2001-09-17 12:00:00 | SPY | ETF | 105.83 | 106.1 | 105.2 | 105.55 | 2470300.0 |
| 2001-09-17 12:30:00 | SPY | ETF | 105.51 | 105.6 | 105.1 | 105.33 | 1434000.0 |
| 2001-09-17 13:00:00 | SPY | ETF | 105.38 | 105.42 | 104.85 | 104.9 | 1367000.0 |
| 2001-09-17 13:30:00 | SPY | ETF | 104.9 | 105.02 | 104.32 | 104.84 | 1605700.0 |
| 2001-09-17 14:00:00 | SPY | ETF | 104.85 | 105.18 | 104.61 | 104.75 | 770500.0 |
| 2001-09-17 14:30:00 | SPY | ETF | 104.74 | 104.87 | 104.1 | 104.29 | 1430200.0 |
| 2001-09-17 15:00:00 | SPY | ETF | 104.31 | 104.8 | 104.2 | 104.5 | 1495200.0 |
| 2001-09-17 15:30:00 | SPY | ETF | 104.54 | 104.79 | 104.15 | 104.3 | 2811600.0 |
| 2001-09-17 16:00:00 | SPY | ETF | 104.4 | 104.65 | 103.41 | 104.41 | 719300.0 |
| 2001-09-17 16:30:00 | SPY | ETF | 104.3 | 104.6 | 103.25 | 104.3 | 353700.0 |
| 2001-09-17 17:00:00 | SPY | ETF | 104.35 | 104.35 | 104.33 | 104.33 | 300.0 |
| 2001-09-17 17:30:00 | SPY | ETF | 104.51 | 104.51 | 104.33 | 104.33 | 39600.0 |
| 2001-09-17 09:30:00 | QQQ | ETF | 31.25 | 32.8 | 31.25 | 31.89 | 18433800.0 |
| 2001-09-17 10:00:00 | QQQ | ETF | 31.9 | 32.4 | 31.53 | 32.35 | 10745300.0 |
| 2001-09-17 10:30:00 | QQQ | ETF | 32.3 | 32.69 | 32.2 | 32.5 | 11121200.0 |
| 2001-09-17 11:00:00 | QQQ | ETF | 32.5 | 32.55 | 32.1 | 32.23 | 7990400.0 |
| 2001-09-17 11:30:00 | QQQ | ETF | 32.18 | 32.62 | 32.18 | 32.39 | 4892700.0 |
| 2001-09-17 12:00:00 | QQQ | ETF | 32.42 | 32.5 | 32.06 | 32.18 | 4605600.0 |
| 2001-09-17 12:30:00 | QQQ | ETF | 32.15 | 32.2 | 31.77 | 31.87 | 4469900.0 |
| 2001-09-17 13:00:00 | QQQ | ETF | 31.9 | 31.99 | 31.74 | 31.77 | 2738000.0 |
| 2001-09-17 13:30:00 | QQQ | ETF | 31.75 | 31.83 | 31.58 | 31.73 | 3252400.0 |
| 2001-09-17 14:00:00 | QQQ | ETF | 31.73 | 31.86 | 31.56 | 31.6 | 2839000.0 |
| 2001-09-17 14:30:00 | QQQ | ETF | 31.6 | 31.68 | 31.25 | 31.28 | 5283800.0 |
| 2001-09-17 15:00:00 | QQQ | ETF | 31.26 | 31.6 | 31.26 | 31.37 | 4655000.0 |
| 2001-09-17 15:30:00 | QQQ | ETF | 31.35 | 31.5 | 31.2 | 31.22 | 6009700.0 |
| 2001-09-17 16:00:00 | QQQ | ETF | 31.24 | 31.45 | 31.08 | 31.18 | 3626500.0 |
| 2001-09-17 16:30:00 | QQQ | ETF | 31.15 | 31.48 | 31.15 | 31.25 | 123900.0 |
| 2001-09-17 17:00:00 | QQQ | ETF | 31.25 | 32.48 | 31.15 | 31.41 | 44300.0 |
| 2001-09-17 17:30:00 | QQQ | ETF | 31.39 | 31.4 | 31.27 | 31.4 | 8300.0 |
| 2001-09-17 18:00:00 | QQQ | ETF | 31.39 | 31.4 | 31.35 | 31.35 | 2000.0 |
| 2001-09-17 09:30:00 | IWM | ETF | 41.0 | 41.225 | 41.0 | 41.225 | 48400.0 |
| 2001-09-17 10:00:00 | IWM | ETF | 41.3 | 42.1 | 41.075 | 42.1 | 164400.0 |
| 2001-09-17 10:30:00 | IWM | ETF | 42.075 | 42.345 | 41.995 | 42.295 | 264400.0 |
| 2001-09-17 11:00:00 | IWM | ETF | 42.295 | 42.295 | 41.85 | 42.07 | 159400.0 |
| 2001-09-17 11:30:00 | IWM | ETF | 42.075 | 42.495 | 42.075 | 42.425 | 146600.0 |
| 2001-09-17 12:00:00 | IWM | ETF | 42.445 | 42.495 | 42.355 | 42.495 | 64000.0 |
| 2001-09-17 12:30:00 | IWM | ETF | 42.495 | 42.495 | 42.3 | 42.325 | 11800.0 |
| 2001-09-17 13:00:00 | IWM | ETF | 42.35 | 42.38 | 42.105 | 42.3 | 49800.0 |
| 2001-09-17 13:30:00 | IWM | ETF | 42.25 | 42.25 | 42.01 | 42.14 | 36800.0 |
| 2001-09-17 14:00:00 | IWM | ETF | 42.105 | 42.225 | 42.0 | 42.05 | 43200.0 |
| 2001-09-17 14:30:00 | IWM | ETF | 41.935 | 41.975 | 41.725 | 41.905 | 24000.0 |
| 2001-09-17 15:00:00 | IWM | ETF | 41.905 | 41.905 | 41.7 | 41.775 | 63200.0 |
| 2001-09-17 15:30:00 | IWM | ETF | 41.84 | 41.84 | 41.525 | 41.65 | 57400.0 |
| 2001-09-17 16:00:00 | IWM | ETF | 41.575 | 41.75 | 41.505 | 41.75 | 190000.0 |
| 2001-09-17 16:30:00 | IWM | ETF | 41.0 | 41.0 | 41.0 | 41.0 | 400.0 |
> showing 50 of 441 rows — these rows as CSV