PREVIEW / etf_30min / 2003-08-08
file: by_date/etf_30min/2003/2003-08-08.parquet size: 22 KB rows: 666
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-08-08 08:00:00 | SPY | ETF | 98.13 | 98.19 | 98.11 | 98.19 | 8100.0 |
| 2003-08-08 08:30:00 | SPY | ETF | 98.2 | 98.41 | 98.2 | 98.35 | 33400.0 |
| 2003-08-08 09:00:00 | SPY | ETF | 98.35 | 98.39 | 98.3 | 98.34 | 36900.0 |
| 2003-08-08 09:30:00 | SPY | ETF | 98.32 | 98.547 | 98.15 | 98.39 | 4637200.0 |
| 2003-08-08 10:00:00 | SPY | ETF | 98.41 | 98.48 | 98.0 | 98.19 | 3045300.0 |
| 2003-08-08 10:30:00 | SPY | ETF | 98.18 | 98.45 | 98.09 | 98.16 | 2158100.0 |
| 2003-08-08 11:00:00 | SPY | ETF | 98.09 | 98.14 | 97.76 | 98.01 | 2508400.0 |
| 2003-08-08 11:30:00 | SPY | ETF | 98.0 | 98.34 | 97.97 | 98.22 | 1176700.0 |
| 2003-08-08 12:00:00 | SPY | ETF | 98.23 | 98.3 | 98.01 | 98.04 | 1173800.0 |
| 2003-08-08 12:30:00 | SPY | ETF | 98.03 | 98.17 | 97.97 | 98.09 | 1690500.0 |
| 2003-08-08 13:00:00 | SPY | ETF | 98.099 | 98.25 | 98.06 | 98.19 | 572100.0 |
| 2003-08-08 13:30:00 | SPY | ETF | 98.2 | 98.36 | 98.01 | 98.09 | 1143800.0 |
| 2003-08-08 14:00:00 | SPY | ETF | 98.09 | 98.16 | 97.89 | 98.13 | 1396200.0 |
| 2003-08-08 14:30:00 | SPY | ETF | 98.14 | 98.28 | 97.98 | 98.04 | 910000.0 |
| 2003-08-08 15:00:00 | SPY | ETF | 98.03 | 98.17 | 97.9 | 98.0 | 1154400.0 |
| 2003-08-08 15:30:00 | SPY | ETF | 98.01 | 98.28 | 98.0 | 98.22 | 2155300.0 |
| 2003-08-08 16:00:00 | SPY | ETF | 98.27 | 98.37 | 98.2057 | 98.24 | 1281500.0 |
| 2003-08-08 16:30:00 | SPY | ETF | 98.29 | 98.3 | 98.17 | 98.28 | 51400.0 |
| 2003-08-08 17:00:00 | SPY | ETF | 98.3 | 98.3 | 98.2 | 98.27 | 34800.0 |
| 2003-08-08 17:30:00 | SPY | ETF | 98.28 | 98.29 | 98.28 | 98.29 | 900.0 |
| 2003-08-08 18:00:00 | SPY | ETF | 98.29 | 98.3 | 98.29 | 98.3 | 800.0 |
| 2003-08-08 18:30:00 | SPY | ETF | 98.29 | 98.29 | 98.29 | 98.29 | 100.0 |
| 2003-08-08 08:00:00 | QQQ | ETF | 30.42 | 30.42 | 30.38 | 30.41 | 36300.0 |
| 2003-08-08 08:30:00 | QQQ | ETF | 30.42 | 30.52 | 30.42 | 30.47 | 53300.0 |
| 2003-08-08 09:00:00 | QQQ | ETF | 30.47 | 30.5 | 30.44 | 30.44 | 93400.0 |
| 2003-08-08 09:30:00 | QQQ | ETF | 30.43 | 30.55 | 30.35 | 30.47 | 7603100.0 |
| 2003-08-08 10:00:00 | QQQ | ETF | 30.46 | 30.52 | 30.26 | 30.33 | 5455000.0 |
| 2003-08-08 10:30:00 | QQQ | ETF | 30.33 | 30.38 | 30.17 | 30.2 | 3352900.0 |
| 2003-08-08 11:00:00 | QQQ | ETF | 30.2 | 30.21 | 29.95 | 30.05 | 9202600.0 |
| 2003-08-08 11:30:00 | QQQ | ETF | 30.05 | 30.19 | 30.03 | 30.128 | 5094500.0 |
| 2003-08-08 12:00:00 | QQQ | ETF | 30.13 | 30.16 | 29.97 | 30.0 | 3655100.0 |
| 2003-08-08 12:30:00 | QQQ | ETF | 30.0 | 30.09 | 29.97 | 30.021 | 4364200.0 |
| 2003-08-08 13:00:00 | QQQ | ETF | 30.03 | 30.14 | 30.01 | 30.12 | 2265300.0 |
| 2003-08-08 13:30:00 | QQQ | ETF | 30.12 | 30.23 | 30.05 | 30.099 | 3644200.0 |
| 2003-08-08 14:00:00 | QQQ | ETF | 30.09 | 30.11 | 29.96 | 30.08 | 2886600.0 |
| 2003-08-08 14:30:00 | QQQ | ETF | 30.075 | 30.11 | 29.96 | 29.996 | 2828800.0 |
| 2003-08-08 15:00:00 | QQQ | ETF | 29.995 | 30.07 | 29.93 | 29.97 | 3032200.0 |
| 2003-08-08 15:30:00 | QQQ | ETF | 29.96 | 30.1 | 29.95 | 30.04 | 6282700.0 |
| 2003-08-08 16:00:00 | QQQ | ETF | 30.07 | 30.081 | 29.98 | 30.06 | 1959100.0 |
| 2003-08-08 16:30:00 | QQQ | ETF | 30.05 | 30.08 | 30.0 | 30.069 | 61600.0 |
| 2003-08-08 17:00:00 | QQQ | ETF | 30.04 | 30.06 | 30.02 | 30.06 | 10100.0 |
| 2003-08-08 17:30:00 | QQQ | ETF | 30.06 | 30.08 | 30.06 | 30.07 | 11800.0 |
| 2003-08-08 18:00:00 | QQQ | ETF | 30.08 | 30.08 | 30.06 | 30.07 | 11600.0 |
| 2003-08-08 18:30:00 | QQQ | ETF | 30.08 | 30.08 | 30.08 | 30.08 | 2000.0 |
| 2003-08-08 19:00:00 | QQQ | ETF | 30.08 | 30.09 | 30.07 | 30.09 | 1500.0 |
| 2003-08-08 19:30:00 | QQQ | ETF | 30.09 | 30.09 | 30.07 | 30.07 | 3500.0 |
| 2003-08-08 09:30:00 | IWM | ETF | 45.43 | 45.475 | 45.2 | 45.375 | 284600.0 |
| 2003-08-08 10:00:00 | IWM | ETF | 45.395 | 45.425 | 45.185 | 45.305 | 294600.0 |
| 2003-08-08 10:30:00 | IWM | ETF | 45.325 | 45.355 | 45.23 | 45.23 | 1158600.0 |
| 2003-08-08 11:00:00 | IWM | ETF | 45.205 | 45.21 | 45.07 | 45.14 | 441000.0 |
> showing 50 of 666 rows — these rows as CSV