PREVIEW / etf_30min / 2001-09-07
file: by_date/etf_30min/2001/2001-09-07.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-09-07 09:30:00 | SPY | ETF | 110.02 | 110.53 | 109.65 | 110.21 | 4240600.0 |
| 2001-09-07 10:00:00 | SPY | ETF | 110.2 | 111.25 | 110.19 | 110.66 | 3315700.0 |
| 2001-09-07 10:30:00 | SPY | ETF | 110.68 | 110.7 | 109.95 | 110.33 | 2877800.0 |
| 2001-09-07 11:00:00 | SPY | ETF | 110.3 | 110.4 | 109.8 | 109.98 | 2257200.0 |
| 2001-09-07 11:30:00 | SPY | ETF | 109.96 | 110.22 | 109.48 | 109.9 | 2543800.0 |
| 2001-09-07 12:00:00 | SPY | ETF | 109.87 | 109.94 | 109.56 | 109.92 | 717200.0 |
| 2001-09-07 12:30:00 | SPY | ETF | 109.88 | 109.92 | 109.04 | 109.21 | 1399000.0 |
| 2001-09-07 13:00:00 | SPY | ETF | 109.24 | 109.42 | 108.87 | 108.99 | 893500.0 |
| 2001-09-07 13:30:00 | SPY | ETF | 108.95 | 109.34 | 108.69 | 109.22 | 2229600.0 |
| 2001-09-07 14:00:00 | SPY | ETF | 109.22 | 109.38 | 108.85 | 109.19 | 1282200.0 |
| 2001-09-07 14:30:00 | SPY | ETF | 109.18 | 110.05 | 109.12 | 110.0 | 2594400.0 |
| 2001-09-07 15:00:00 | SPY | ETF | 110.0 | 110.05 | 109.21 | 109.4 | 2170300.0 |
| 2001-09-07 15:30:00 | SPY | ETF | 109.34 | 109.35 | 109.02 | 109.13 | 1838000.0 |
| 2001-09-07 16:00:00 | SPY | ETF | 109.09 | 109.12 | 108.63 | 108.71 | 1497000.0 |
| 2001-09-07 16:30:00 | SPY | ETF | 108.75 | 108.75 | 108.6 | 108.6 | 2200.0 |
| 2001-09-07 17:00:00 | SPY | ETF | 108.71 | 108.76 | 108.71 | 108.76 | 200.0 |
| 2001-09-07 17:30:00 | SPY | ETF | 108.9 | 108.9 | 108.9 | 108.9 | 300.0 |
| 2001-09-07 09:30:00 | QQQ | ETF | 33.62 | 34.3 | 33.35 | 34.15 | 18165900.0 |
| 2001-09-07 10:00:00 | QQQ | ETF | 34.16 | 34.66 | 34.12 | 34.3 | 9890300.0 |
| 2001-09-07 10:30:00 | QQQ | ETF | 34.3 | 34.33 | 33.87 | 34.0 | 6376000.0 |
| 2001-09-07 11:00:00 | QQQ | ETF | 33.98 | 34.03 | 33.66 | 33.9 | 4856300.0 |
| 2001-09-07 11:30:00 | QQQ | ETF | 33.87 | 34.14 | 33.62 | 33.94 | 4052900.0 |
| 2001-09-07 12:00:00 | QQQ | ETF | 33.94 | 34.05 | 33.76 | 33.96 | 3380100.0 |
| 2001-09-07 12:30:00 | QQQ | ETF | 34.02 | 34.02 | 33.49 | 33.55 | 4659000.0 |
| 2001-09-07 13:00:00 | QQQ | ETF | 33.57 | 33.79 | 33.44 | 33.45 | 4718700.0 |
| 2001-09-07 13:30:00 | QQQ | ETF | 33.44 | 33.87 | 33.35 | 33.75 | 6800000.0 |
| 2001-09-07 14:00:00 | QQQ | ETF | 33.77 | 33.93 | 33.61 | 33.8 | 4231400.0 |
| 2001-09-07 14:30:00 | QQQ | ETF | 33.78 | 34.4 | 33.73 | 34.38 | 9157200.0 |
| 2001-09-07 15:00:00 | QQQ | ETF | 34.38 | 34.4 | 33.84 | 33.87 | 6798900.0 |
| 2001-09-07 15:30:00 | QQQ | ETF | 33.88 | 33.94 | 33.66 | 33.78 | 5642500.0 |
| 2001-09-07 16:00:00 | QQQ | ETF | 33.77 | 33.79 | 33.55 | 33.65 | 1761300.0 |
| 2001-09-07 16:30:00 | QQQ | ETF | 33.6 | 33.7 | 33.5 | 33.6 | 64100.0 |
| 2001-09-07 17:00:00 | QQQ | ETF | 33.6 | 33.65 | 33.5 | 33.6 | 45800.0 |
| 2001-09-07 17:30:00 | QQQ | ETF | 33.61 | 33.63 | 33.6 | 33.6 | 4800.0 |
| 2001-09-07 18:00:00 | QQQ | ETF | 33.62 | 33.63 | 33.56 | 33.6 | 8500.0 |
| 2001-09-07 09:30:00 | IWM | ETF | 44.65 | 44.85 | 44.555 | 44.65 | 89400.0 |
| 2001-09-07 10:00:00 | IWM | ETF | 44.95 | 45.05 | 44.85 | 44.865 | 12000.0 |
| 2001-09-07 10:30:00 | IWM | ETF | 44.995 | 44.995 | 44.7 | 44.7 | 146200.0 |
| 2001-09-07 11:00:00 | IWM | ETF | 44.675 | 44.775 | 44.56 | 44.775 | 12600.0 |
| 2001-09-07 11:30:00 | IWM | ETF | 44.775 | 44.775 | 44.675 | 44.675 | 1001400.0 |
| 2001-09-07 12:00:00 | IWM | ETF | 44.675 | 44.695 | 44.625 | 44.675 | 9600.0 |
| 2001-09-07 12:30:00 | IWM | ETF | 44.725 | 44.745 | 44.45 | 44.45 | 109000.0 |
| 2001-09-07 13:00:00 | IWM | ETF | 44.4 | 44.515 | 44.155 | 44.155 | 3162200.0 |
| 2001-09-07 13:30:00 | IWM | ETF | 44.15 | 44.35 | 44.085 | 44.225 | 21800.0 |
| 2001-09-07 14:00:00 | IWM | ETF | 44.18 | 44.34 | 44.1 | 44.1 | 20400.0 |
| 2001-09-07 14:30:00 | IWM | ETF | 44.265 | 44.5 | 44.125 | 44.375 | 149600.0 |
| 2001-09-07 15:00:00 | IWM | ETF | 44.38 | 44.495 | 44.26 | 44.35 | 124400.0 |
| 2001-09-07 15:30:00 | IWM | ETF | 44.36 | 44.405 | 44.275 | 44.285 | 64200.0 |
| 2001-09-07 16:00:00 | IWM | ETF | 44.28 | 44.375 | 44.265 | 44.265 | 1800.0 |
| 2001-09-07 09:30:00 | DIA | ETF | 97.61 | 97.76 | 97.05 | 97.4 | 1175700.0 |
> showing 50 of 407 rows — these rows as CSV