PREVIEW / etf_30min / 2003-04-04
file: by_date/etf_30min/2003/2003-04-04.parquet size: 21 KB rows: 647
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-04 08:00:00 | SPY | ETF | 88.3 | 88.52 | 88.19 | 88.19 | 60300.0 |
| 2003-04-04 08:30:00 | SPY | ETF | 88.19 | 88.77 | 88.09 | 88.51 | 103100.0 |
| 2003-04-04 09:00:00 | SPY | ETF | 88.58 | 88.74 | 88.38 | 88.39 | 117400.0 |
| 2003-04-04 09:30:00 | SPY | ETF | 88.43 | 88.59 | 88.01 | 88.18 | 6241300.0 |
| 2003-04-04 10:00:00 | SPY | ETF | 88.19 | 88.35 | 87.68 | 87.86 | 5021000.0 |
| 2003-04-04 10:30:00 | SPY | ETF | 87.87 | 88.13 | 87.62 | 87.75 | 3231400.0 |
| 2003-04-04 11:00:00 | SPY | ETF | 87.75 | 88.17 | 87.7 | 88.06 | 2720500.0 |
| 2003-04-04 11:30:00 | SPY | ETF | 88.09 | 88.33 | 87.97 | 88.23 | 2659200.0 |
| 2003-04-04 12:00:00 | SPY | ETF | 88.22 | 88.25 | 87.94 | 88.09 | 788600.0 |
| 2003-04-04 12:30:00 | SPY | ETF | 88.07 | 88.11 | 87.75 | 87.99 | 1512400.0 |
| 2003-04-04 13:00:00 | SPY | ETF | 88.0 | 88.14 | 87.91 | 87.99 | 821000.0 |
| 2003-04-04 13:30:00 | SPY | ETF | 88.0 | 88.04 | 87.72 | 87.73 | 1020800.0 |
| 2003-04-04 14:00:00 | SPY | ETF | 87.75 | 88.03 | 87.67 | 88.0 | 1363800.0 |
| 2003-04-04 14:30:00 | SPY | ETF | 88.0 | 88.13 | 87.89 | 87.98 | 1412000.0 |
| 2003-04-04 15:00:00 | SPY | ETF | 87.98 | 88.09 | 87.68 | 87.87 | 1714400.0 |
| 2003-04-04 15:30:00 | SPY | ETF | 87.89 | 88.29 | 87.78 | 88.12 | 2971400.0 |
| 2003-04-04 16:00:00 | SPY | ETF | 88.11 | 88.29 | 88.1 | 88.19 | 1981400.0 |
| 2003-04-04 16:30:00 | SPY | ETF | 88.19 | 88.28 | 88.15 | 88.26 | 25300.0 |
| 2003-04-04 17:00:00 | SPY | ETF | 88.26 | 88.26 | 88.21 | 88.25 | 8700.0 |
| 2003-04-04 17:30:00 | SPY | ETF | 88.26 | 88.3 | 88.26 | 88.26 | 8200.0 |
| 2003-04-04 18:00:00 | SPY | ETF | 88.3 | 88.4 | 88.28 | 88.4 | 2400.0 |
| 2003-04-04 18:30:00 | SPY | ETF | 88.27 | 88.27 | 88.27 | 88.27 | 300.0 |
| 2003-04-04 19:30:00 | SPY | ETF | 88.35 | 88.39 | 88.35 | 88.39 | 700.0 |
| 2003-04-04 08:00:00 | QQQ | ETF | 26.5 | 26.59 | 26.48 | 26.5 | 78400.0 |
| 2003-04-04 08:30:00 | QQQ | ETF | 26.5 | 26.71 | 26.43 | 26.63 | 220600.0 |
| 2003-04-04 09:00:00 | QQQ | ETF | 26.63 | 26.7 | 26.55 | 26.57 | 73200.0 |
| 2003-04-04 09:30:00 | QQQ | ETF | 26.57 | 26.6 | 26.28 | 26.32 | 10915400.0 |
| 2003-04-04 10:00:00 | QQQ | ETF | 26.32 | 26.4 | 26.08 | 26.1 | 10009700.0 |
| 2003-04-04 10:30:00 | QQQ | ETF | 26.14 | 26.25 | 26.05 | 26.12 | 4785300.0 |
| 2003-04-04 11:00:00 | QQQ | ETF | 26.11 | 26.24 | 26.07 | 26.19 | 3625300.0 |
| 2003-04-04 11:30:00 | QQQ | ETF | 26.19 | 26.29 | 26.16 | 26.22 | 2796400.0 |
| 2003-04-04 12:00:00 | QQQ | ETF | 26.23 | 26.24 | 26.12 | 26.15 | 2311300.0 |
| 2003-04-04 12:30:00 | QQQ | ETF | 26.15 | 26.17 | 25.98 | 26.08 | 3951100.0 |
| 2003-04-04 13:00:00 | QQQ | ETF | 26.08 | 26.13 | 26.05 | 26.08 | 1993600.0 |
| 2003-04-04 13:30:00 | QQQ | ETF | 26.07 | 26.09 | 25.97 | 26.0 | 3235900.0 |
| 2003-04-04 14:00:00 | QQQ | ETF | 26.0 | 26.12 | 25.98 | 26.08 | 2566900.0 |
| 2003-04-04 14:30:00 | QQQ | ETF | 26.09 | 26.16 | 26.04 | 26.1 | 2544300.0 |
| 2003-04-04 15:00:00 | QQQ | ETF | 26.1 | 26.13 | 26.0 | 26.03 | 3115800.0 |
| 2003-04-04 15:30:00 | QQQ | ETF | 26.02 | 26.21 | 26.0 | 26.11 | 5313700.0 |
| 2003-04-04 16:00:00 | QQQ | ETF | 26.12 | 26.16 | 25.97 | 26.06 | 2349100.0 |
| 2003-04-04 16:30:00 | QQQ | ETF | 26.05 | 26.07 | 26.03 | 26.06 | 239800.0 |
| 2003-04-04 17:00:00 | QQQ | ETF | 26.06 | 26.11 | 26.05 | 26.08 | 35400.0 |
| 2003-04-04 17:30:00 | QQQ | ETF | 26.11 | 26.11 | 26.05 | 26.06 | 66600.0 |
| 2003-04-04 18:00:00 | QQQ | ETF | 26.08 | 26.1 | 26.06 | 26.1 | 10600.0 |
| 2003-04-04 18:30:00 | QQQ | ETF | 26.1 | 26.1 | 26.08 | 26.08 | 13000.0 |
| 2003-04-04 19:00:00 | QQQ | ETF | 26.08 | 26.08 | 26.06 | 26.06 | 8300.0 |
| 2003-04-04 19:30:00 | QQQ | ETF | 26.06 | 26.09 | 26.06 | 26.09 | 8200.0 |
| 2003-04-04 09:30:00 | IWM | ETF | 37.54 | 37.655 | 37.5 | 37.52 | 202000.0 |
| 2003-04-04 10:00:00 | IWM | ETF | 37.49 | 37.5 | 37.285 | 37.29 | 186400.0 |
| 2003-04-04 10:30:00 | IWM | ETF | 37.355 | 37.425 | 37.25 | 37.26 | 181000.0 |
> showing 50 of 647 rows — these rows as CSV