PREVIEW / etf_30min / 2003-04-16
file: by_date/etf_30min/2003/2003-04-16.parquet size: 22 KB rows: 644
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-16 08:00:00 | SPY | ETF | 90.22 | 90.27 | 90.16 | 90.17 | 15300.0 |
| 2003-04-16 08:30:00 | SPY | ETF | 90.17 | 90.32 | 90.1 | 90.15 | 77700.0 |
| 2003-04-16 09:00:00 | SPY | ETF | 90.07 | 90.08 | 89.9 | 89.93 | 93100.0 |
| 2003-04-16 09:30:00 | SPY | ETF | 89.91 | 90.06 | 89.36 | 89.62 | 8083700.0 |
| 2003-04-16 10:00:00 | SPY | ETF | 89.62 | 89.96 | 89.33 | 89.7 | 7167300.0 |
| 2003-04-16 10:30:00 | SPY | ETF | 89.68 | 89.79 | 88.97 | 89.06 | 5881700.0 |
| 2003-04-16 11:00:00 | SPY | ETF | 89.06 | 89.21 | 88.88 | 89.12 | 2865400.0 |
| 2003-04-16 11:30:00 | SPY | ETF | 89.11 | 89.14 | 88.7 | 88.76 | 1860000.0 |
| 2003-04-16 12:00:00 | SPY | ETF | 88.77 | 89.0 | 88.66 | 88.94 | 2161300.0 |
| 2003-04-16 12:30:00 | SPY | ETF | 88.95 | 89.12 | 88.91 | 89.01 | 2295000.0 |
| 2003-04-16 13:00:00 | SPY | ETF | 89.01 | 89.01 | 88.85 | 88.96 | 926000.0 |
| 2003-04-16 13:30:00 | SPY | ETF | 88.93 | 88.96 | 88.79 | 88.9 | 863000.0 |
| 2003-04-16 14:00:00 | SPY | ETF | 88.89 | 88.92 | 88.48 | 88.58 | 2975300.0 |
| 2003-04-16 14:30:00 | SPY | ETF | 88.59 | 88.62 | 88.2 | 88.45 | 4325700.0 |
| 2003-04-16 15:00:00 | SPY | ETF | 88.45 | 88.54 | 88.1 | 88.15 | 2764000.0 |
| 2003-04-16 15:30:00 | SPY | ETF | 88.17 | 88.29 | 88.03 | 88.23 | 3820500.0 |
| 2003-04-16 16:00:00 | SPY | ETF | 88.23 | 88.39 | 88.16 | 88.2 | 2096900.0 |
| 2003-04-16 16:30:00 | SPY | ETF | 88.22 | 88.35 | 88.18 | 88.3 | 20200.0 |
| 2003-04-16 17:00:00 | SPY | ETF | 88.31 | 88.31 | 88.25 | 88.3 | 25100.0 |
| 2003-04-16 17:30:00 | SPY | ETF | 88.31 | 88.33 | 88.25 | 88.32 | 6900.0 |
| 2003-04-16 18:00:00 | SPY | ETF | 88.3 | 88.3 | 88.26 | 88.3 | 2500.0 |
| 2003-04-16 18:30:00 | SPY | ETF | 88.3 | 88.32 | 88.25 | 88.27 | 4000.0 |
| 2003-04-16 19:00:00 | SPY | ETF | 88.24 | 88.25 | 88.22 | 88.22 | 3600.0 |
| 2003-04-16 19:30:00 | SPY | ETF | 88.25 | 88.25 | 88.2 | 88.25 | 3500.0 |
| 2003-04-16 08:00:00 | QQQ | ETF | 26.8 | 26.8 | 26.71 | 26.73 | 108500.0 |
| 2003-04-16 08:30:00 | QQQ | ETF | 26.7 | 26.74 | 26.67 | 26.67 | 149300.0 |
| 2003-04-16 09:00:00 | QQQ | ETF | 26.68 | 26.7 | 26.62 | 26.64 | 132900.0 |
| 2003-04-16 09:30:00 | QQQ | ETF | 26.65 | 26.73 | 26.4 | 26.6 | 14998800.0 |
| 2003-04-16 10:00:00 | QQQ | ETF | 26.61 | 26.83 | 26.51 | 26.67 | 9134400.0 |
| 2003-04-16 10:30:00 | QQQ | ETF | 26.66 | 26.73 | 26.39 | 26.44 | 8769200.0 |
| 2003-04-16 11:00:00 | QQQ | ETF | 26.43 | 26.49 | 26.33 | 26.47 | 3922800.0 |
| 2003-04-16 11:30:00 | QQQ | ETF | 26.46 | 26.5 | 26.32 | 26.35 | 3805800.0 |
| 2003-04-16 12:00:00 | QQQ | ETF | 26.35 | 26.43 | 26.29 | 26.38 | 2724000.0 |
| 2003-04-16 12:30:00 | QQQ | ETF | 26.38 | 26.47 | 26.38 | 26.44 | 1750300.0 |
| 2003-04-16 13:00:00 | QQQ | ETF | 26.45 | 26.45 | 26.38 | 26.41 | 1294600.0 |
| 2003-04-16 13:30:00 | QQQ | ETF | 26.41 | 26.42 | 26.31 | 26.35 | 1903300.0 |
| 2003-04-16 14:00:00 | QQQ | ETF | 26.35 | 26.39 | 26.23 | 26.27 | 3535500.0 |
| 2003-04-16 14:30:00 | QQQ | ETF | 26.28 | 26.29 | 26.16 | 26.27 | 3975500.0 |
| 2003-04-16 15:00:00 | QQQ | ETF | 26.28 | 26.33 | 26.12 | 26.14 | 2471400.0 |
| 2003-04-16 15:30:00 | QQQ | ETF | 26.16 | 26.27 | 26.12 | 26.21 | 4524400.0 |
| 2003-04-16 16:00:00 | QQQ | ETF | 26.24 | 26.44 | 26.17 | 26.18 | 1510400.0 |
| 2003-04-16 16:30:00 | QQQ | ETF | 26.19 | 26.29 | 26.15 | 26.26 | 93800.0 |
| 2003-04-16 17:00:00 | QQQ | ETF | 26.26 | 26.31 | 26.25 | 26.28 | 439200.0 |
| 2003-04-16 17:30:00 | QQQ | ETF | 26.27 | 26.28 | 26.26 | 26.27 | 10000.0 |
| 2003-04-16 18:00:00 | QQQ | ETF | 26.26 | 26.29 | 26.26 | 26.29 | 18600.0 |
| 2003-04-16 18:30:00 | QQQ | ETF | 26.29 | 26.29 | 26.26 | 26.28 | 5100.0 |
| 2003-04-16 19:00:00 | QQQ | ETF | 26.28 | 26.28 | 26.26 | 26.26 | 5300.0 |
| 2003-04-16 19:30:00 | QQQ | ETF | 26.27 | 26.28 | 26.24 | 26.24 | 6000.0 |
| 2003-04-16 09:30:00 | IWM | ETF | 38.06 | 38.12 | 37.78 | 37.815 | 333000.0 |
| 2003-04-16 10:00:00 | IWM | ETF | 37.85 | 38.02 | 37.79 | 37.935 | 418000.0 |
> showing 50 of 644 rows — these rows as CSV