PREVIEW / etf_30min / 2003-04-09
file: by_date/etf_30min/2003/2003-04-09.parquet size: 22 KB rows: 648
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-09 08:00:00 | SPY | ETF | 87.87 | 87.87 | 87.75 | 87.78 | 10600.0 |
| 2003-04-09 08:30:00 | SPY | ETF | 87.8 | 88.15 | 87.78 | 88.05 | 38200.0 |
| 2003-04-09 09:00:00 | SPY | ETF | 88.08 | 88.78 | 88.08 | 88.35 | 154000.0 |
| 2003-04-09 09:30:00 | SPY | ETF | 88.36 | 88.47 | 87.83 | 88.25 | 6338500.0 |
| 2003-04-09 10:00:00 | SPY | ETF | 88.21 | 89.06 | 88.1 | 88.73 | 8005200.0 |
| 2003-04-09 10:30:00 | SPY | ETF | 88.72 | 89.1 | 88.5 | 88.56 | 4311200.0 |
| 2003-04-09 11:00:00 | SPY | ETF | 88.55 | 88.72 | 87.94 | 88.04 | 3282900.0 |
| 2003-04-09 11:30:00 | SPY | ETF | 88.07 | 88.22 | 87.99 | 88.0 | 1962200.0 |
| 2003-04-09 12:00:00 | SPY | ETF | 87.99 | 88.09 | 87.55 | 87.72 | 3220500.0 |
| 2003-04-09 12:30:00 | SPY | ETF | 87.71 | 87.78 | 87.12 | 87.28 | 4329200.0 |
| 2003-04-09 13:00:00 | SPY | ETF | 87.28 | 87.51 | 87.21 | 87.49 | 2240900.0 |
| 2003-04-09 13:30:00 | SPY | ETF | 87.48 | 87.48 | 87.11 | 87.11 | 2743400.0 |
| 2003-04-09 14:00:00 | SPY | ETF | 87.1 | 87.54 | 87.01 | 87.49 | 2882300.0 |
| 2003-04-09 14:30:00 | SPY | ETF | 87.49 | 87.64 | 87.22 | 87.3 | 1998800.0 |
| 2003-04-09 15:00:00 | SPY | ETF | 87.3 | 87.8 | 87.29 | 87.57 | 2953400.0 |
| 2003-04-09 15:30:00 | SPY | ETF | 87.56 | 87.69 | 86.77 | 86.86 | 4548100.0 |
| 2003-04-09 16:00:00 | SPY | ETF | 86.87 | 88.89 | 86.81 | 86.95 | 1709000.0 |
| 2003-04-09 16:30:00 | SPY | ETF | 86.95 | 87.11 | 86.91 | 87.0 | 88100.0 |
| 2003-04-09 17:00:00 | SPY | ETF | 87.0 | 87.07 | 86.99 | 86.99 | 36200.0 |
| 2003-04-09 17:30:00 | SPY | ETF | 86.99 | 87.09 | 86.99 | 87.09 | 13500.0 |
| 2003-04-09 18:00:00 | SPY | ETF | 87.09 | 87.1 | 87.06 | 87.08 | 12300.0 |
| 2003-04-09 18:30:00 | SPY | ETF | 87.1 | 87.1 | 87.02 | 87.03 | 3400.0 |
| 2003-04-09 19:00:00 | SPY | ETF | 87.03 | 87.15 | 87.03 | 87.15 | 8000.0 |
| 2003-04-09 19:30:00 | SPY | ETF | 87.07 | 87.08 | 87.03 | 87.03 | 7000.0 |
| 2003-04-09 08:00:00 | QQQ | ETF | 25.98 | 25.98 | 25.9 | 25.91 | 16800.0 |
| 2003-04-09 08:30:00 | QQQ | ETF | 25.9 | 26.04 | 25.9 | 26.01 | 36700.0 |
| 2003-04-09 09:00:00 | QQQ | ETF | 26.01 | 26.32 | 26.0 | 26.1 | 175200.0 |
| 2003-04-09 09:30:00 | QQQ | ETF | 26.1 | 26.15 | 25.86 | 26.03 | 9037300.0 |
| 2003-04-09 10:00:00 | QQQ | ETF | 26.0 | 26.27 | 25.94 | 26.17 | 8920700.0 |
| 2003-04-09 10:30:00 | QQQ | ETF | 26.16 | 26.28 | 26.07 | 26.08 | 7133300.0 |
| 2003-04-09 11:00:00 | QQQ | ETF | 26.07 | 26.15 | 25.86 | 25.91 | 6135100.0 |
| 2003-04-09 11:30:00 | QQQ | ETF | 25.91 | 25.97 | 25.87 | 25.88 | 3535300.0 |
| 2003-04-09 12:00:00 | QQQ | ETF | 25.9 | 25.9 | 25.65 | 25.72 | 5235100.0 |
| 2003-04-09 12:30:00 | QQQ | ETF | 25.73 | 25.78 | 25.57 | 25.64 | 4132500.0 |
| 2003-04-09 13:00:00 | QQQ | ETF | 25.66 | 25.71 | 25.6 | 25.68 | 3042700.0 |
| 2003-04-09 13:30:00 | QQQ | ETF | 25.68 | 25.7 | 25.56 | 25.58 | 2431900.0 |
| 2003-04-09 14:00:00 | QQQ | ETF | 25.56 | 25.72 | 25.53 | 25.68 | 4551600.0 |
| 2003-04-09 14:30:00 | QQQ | ETF | 25.68 | 25.74 | 25.57 | 25.64 | 3043200.0 |
| 2003-04-09 15:00:00 | QQQ | ETF | 25.61 | 25.77 | 25.58 | 25.67 | 3486900.0 |
| 2003-04-09 15:30:00 | QQQ | ETF | 25.66 | 25.73 | 25.43 | 25.46 | 6894600.0 |
| 2003-04-09 16:00:00 | QQQ | ETF | 25.46 | 25.5 | 25.41 | 25.48 | 1997000.0 |
| 2003-04-09 16:30:00 | QQQ | ETF | 25.49 | 25.57 | 25.45 | 25.47 | 344100.0 |
| 2003-04-09 17:00:00 | QQQ | ETF | 25.45 | 25.51 | 25.45 | 25.47 | 136100.0 |
| 2003-04-09 17:30:00 | QQQ | ETF | 25.49 | 25.5 | 25.48 | 25.5 | 43700.0 |
| 2003-04-09 18:00:00 | QQQ | ETF | 25.48 | 25.53 | 25.48 | 25.53 | 30300.0 |
| 2003-04-09 18:30:00 | QQQ | ETF | 25.54 | 25.54 | 25.52 | 25.54 | 24600.0 |
| 2003-04-09 19:00:00 | QQQ | ETF | 25.53 | 25.56 | 25.53 | 25.56 | 12700.0 |
| 2003-04-09 19:30:00 | QQQ | ETF | 25.56 | 25.56 | 25.51 | 25.54 | 12900.0 |
| 2003-04-09 09:00:00 | IWM | ETF | 37.315 | 37.33 | 37.315 | 37.33 | 3000.0 |
| 2003-04-09 09:30:00 | IWM | ETF | 37.365 | 37.46 | 37.25 | 37.45 | 456400.0 |
> showing 50 of 648 rows — these rows as CSV