PREVIEW / etf_30min / 2004-08-30
file: by_date/etf_30min/2004/2004-08-30.parquet size: 33 KB rows: 1,103
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-30 08:00:00 | SPY | ETF | 111.15 | 111.2 | 111.13 | 111.15 | 33200.0 |
| 2004-08-30 08:30:00 | SPY | ETF | 111.15 | 111.16 | 111.11 | 111.14 | 19700.0 |
| 2004-08-30 09:00:00 | SPY | ETF | 111.14 | 111.21 | 111.14 | 111.21 | 14600.0 |
| 2004-08-30 09:30:00 | SPY | ETF | 111.23 | 111.34 | 111.1 | 111.23 | 2396800.0 |
| 2004-08-30 10:00:00 | SPY | ETF | 111.23 | 111.26 | 111.09 | 111.09 | 2110800.0 |
| 2004-08-30 10:30:00 | SPY | ETF | 111.1 | 111.12 | 110.89 | 110.97 | 3104200.0 |
| 2004-08-30 11:00:00 | SPY | ETF | 110.97 | 111.02 | 110.91 | 110.97 | 1480100.0 |
| 2004-08-30 11:30:00 | SPY | ETF | 110.97 | 111.14 | 110.95 | 111.04 | 2987600.0 |
| 2004-08-30 12:00:00 | SPY | ETF | 111.05 | 111.06 | 110.97 | 110.97 | 1266900.0 |
| 2004-08-30 12:30:00 | SPY | ETF | 110.98 | 111.03 | 110.93 | 111.0 | 689900.0 |
| 2004-08-30 13:00:00 | SPY | ETF | 111.0 | 111.05 | 110.93 | 110.94 | 777800.0 |
| 2004-08-30 13:30:00 | SPY | ETF | 110.95 | 111.05 | 110.91 | 110.99 | 780300.0 |
| 2004-08-30 14:00:00 | SPY | ETF | 111.0 | 111.02 | 110.93 | 111.01 | 616800.0 |
| 2004-08-30 14:30:00 | SPY | ETF | 111.01 | 111.04 | 110.78 | 110.79 | 1734900.0 |
| 2004-08-30 15:00:00 | SPY | ETF | 110.79 | 110.813 | 110.67 | 110.77 | 2188600.0 |
| 2004-08-30 15:30:00 | SPY | ETF | 110.77 | 110.79 | 110.51 | 110.58 | 3556100.0 |
| 2004-08-30 16:00:00 | SPY | ETF | 110.58 | 110.58 | 110.45 | 110.53 | 1393300.0 |
| 2004-08-30 16:30:00 | SPY | ETF | 110.55 | 110.61 | 110.54 | 110.56 | 35700.0 |
| 2004-08-30 17:00:00 | SPY | ETF | 110.55 | 110.57 | 110.55 | 110.57 | 3700.0 |
| 2004-08-30 17:30:00 | SPY | ETF | 110.56 | 110.56 | 110.56 | 110.56 | 200.0 |
| 2004-08-30 18:00:00 | SPY | ETF | 110.56 | 110.56 | 110.56 | 110.56 | 1200.0 |
| 2004-08-30 08:00:00 | QQQ | ETF | 34.37 | 34.37 | 34.35 | 34.36 | 58700.0 |
| 2004-08-30 08:30:00 | QQQ | ETF | 34.36 | 34.36 | 34.33 | 34.35 | 33900.0 |
| 2004-08-30 09:00:00 | QQQ | ETF | 34.34 | 34.4 | 34.34 | 34.4 | 75600.0 |
| 2004-08-30 09:30:00 | QQQ | ETF | 34.41 | 34.43 | 34.32 | 34.38 | 6056400.0 |
| 2004-08-30 10:00:00 | QQQ | ETF | 34.38 | 34.39 | 34.25 | 34.25 | 5776700.0 |
| 2004-08-30 10:30:00 | QQQ | ETF | 34.27 | 34.27 | 34.016 | 34.077 | 11854900.0 |
| 2004-08-30 11:00:00 | QQQ | ETF | 34.072 | 34.15 | 34.06 | 34.12 | 3373900.0 |
| 2004-08-30 11:30:00 | QQQ | ETF | 34.12 | 34.23 | 34.11 | 34.182 | 4265800.0 |
| 2004-08-30 12:00:00 | QQQ | ETF | 34.18 | 34.181 | 34.115 | 34.15 | 2392700.0 |
| 2004-08-30 12:30:00 | QQQ | ETF | 34.14 | 34.19 | 34.14 | 34.1894 | 2456800.0 |
| 2004-08-30 13:00:00 | QQQ | ETF | 34.181 | 34.2 | 34.14 | 34.14 | 1258500.0 |
| 2004-08-30 13:30:00 | QQQ | ETF | 34.15 | 34.22 | 34.13 | 34.18 | 3153500.0 |
| 2004-08-30 14:00:00 | QQQ | ETF | 34.182 | 34.22 | 34.17 | 34.21 | 861800.0 |
| 2004-08-30 14:30:00 | QQQ | ETF | 34.21 | 34.22 | 34.1 | 34.1 | 2855700.0 |
| 2004-08-30 15:00:00 | QQQ | ETF | 34.105 | 34.16 | 34.05 | 34.12 | 5494200.0 |
| 2004-08-30 15:30:00 | QQQ | ETF | 34.12 | 34.13 | 34.03 | 34.035 | 6870800.0 |
| 2004-08-30 16:00:00 | QQQ | ETF | 34.04 | 34.06 | 33.95 | 33.99 | 4465400.0 |
| 2004-08-30 16:30:00 | QQQ | ETF | 33.99 | 34.02 | 33.98 | 34.0 | 55400.0 |
| 2004-08-30 17:00:00 | QQQ | ETF | 34.0 | 34.02 | 33.99 | 34.01 | 115800.0 |
| 2004-08-30 17:30:00 | QQQ | ETF | 34.01 | 34.04 | 34.005 | 34.04 | 31500.0 |
| 2004-08-30 18:00:00 | QQQ | ETF | 34.014 | 34.03 | 34.01 | 34.02 | 16700.0 |
| 2004-08-30 18:30:00 | QQQ | ETF | 34.02 | 34.02 | 34.02 | 34.02 | 2000.0 |
| 2004-08-30 19:00:00 | QQQ | ETF | 34.02 | 34.02 | 34.01 | 34.02 | 4800.0 |
| 2004-08-30 19:30:00 | QQQ | ETF | 34.02 | 34.03 | 34.01 | 34.03 | 26800.0 |
| 2004-08-30 08:00:00 | IWM | ETF | 54.725 | 54.725 | 54.725 | 54.725 | 1600.0 |
| 2004-08-30 09:00:00 | IWM | ETF | 54.77 | 54.77 | 54.77 | 54.77 | 1000.0 |
| 2004-08-30 09:30:00 | IWM | ETF | 54.7 | 54.84 | 54.595 | 54.735 | 578600.0 |
| 2004-08-30 10:00:00 | IWM | ETF | 54.735 | 54.77 | 54.64 | 54.655 | 449400.0 |
| 2004-08-30 10:30:00 | IWM | ETF | 54.655 | 54.655 | 54.24 | 54.32 | 1336400.0 |
> showing 50 of 1,103 rows — these rows as CSV