PREVIEW / etf_30min / 2003-10-29
file: by_date/etf_30min/2003/2003-10-29.parquet size: 25 KB rows: 793
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-10-29 08:00:00 | SPY | ETF | 104.79 | 104.83 | 104.73 | 104.76 | 48400.0 |
| 2003-10-29 08:30:00 | SPY | ETF | 104.76 | 104.77 | 104.72 | 104.72 | 6600.0 |
| 2003-10-29 09:00:00 | SPY | ETF | 104.72 | 104.83 | 104.7 | 104.77 | 20500.0 |
| 2003-10-29 09:30:00 | SPY | ETF | 104.77 | 104.98 | 104.69 | 104.78 | 3295900.0 |
| 2003-10-29 10:00:00 | SPY | ETF | 104.82 | 105.04 | 104.77 | 104.82 | 2636500.0 |
| 2003-10-29 10:30:00 | SPY | ETF | 104.82 | 104.95 | 104.71 | 104.89 | 1642000.0 |
| 2003-10-29 11:00:00 | SPY | ETF | 104.89 | 104.97 | 104.75 | 104.95 | 1489800.0 |
| 2003-10-29 11:30:00 | SPY | ETF | 104.94 | 104.96 | 104.8 | 104.89 | 557700.0 |
| 2003-10-29 12:00:00 | SPY | ETF | 104.89 | 105.12 | 104.85 | 105.07 | 2766300.0 |
| 2003-10-29 12:30:00 | SPY | ETF | 105.08 | 105.13 | 104.92 | 105.04 | 1020600.0 |
| 2003-10-29 13:00:00 | SPY | ETF | 105.04 | 105.43 | 104.97 | 105.35 | 1207100.0 |
| 2003-10-29 13:30:00 | SPY | ETF | 105.36 | 105.4 | 105.08 | 105.14 | 1548500.0 |
| 2003-10-29 14:00:00 | SPY | ETF | 105.14 | 105.32 | 104.75 | 105.23 | 4608000.0 |
| 2003-10-29 14:30:00 | SPY | ETF | 105.24 | 105.26 | 104.88 | 105.19 | 1326900.0 |
| 2003-10-29 15:00:00 | SPY | ETF | 105.19 | 105.32 | 105.13 | 105.14 | 1182800.0 |
| 2003-10-29 15:30:00 | SPY | ETF | 105.14 | 105.29 | 105.09 | 105.25 | 1796400.0 |
| 2003-10-29 16:00:00 | SPY | ETF | 105.25 | 105.3 | 105.1 | 105.13 | 1315700.0 |
| 2003-10-29 16:30:00 | SPY | ETF | 105.15 | 105.2 | 104.94 | 104.96 | 88900.0 |
| 2003-10-29 17:00:00 | SPY | ETF | 105.01 | 105.08 | 105.007 | 105.06 | 27800.0 |
| 2003-10-29 17:30:00 | SPY | ETF | 105.02 | 105.07 | 105.02 | 105.04 | 3000.0 |
| 2003-10-29 18:00:00 | SPY | ETF | 105.03 | 105.08 | 105.02 | 105.08 | 6700.0 |
| 2003-10-29 18:30:00 | SPY | ETF | 105.07 | 105.07 | 105.07 | 105.07 | 200.0 |
| 2003-10-29 19:30:00 | SPY | ETF | 105.07 | 105.07 | 105.06 | 105.06 | 5100.0 |
| 2003-10-29 08:00:00 | QQQ | ETF | 35.27 | 35.27 | 35.2 | 35.23 | 44800.0 |
| 2003-10-29 08:30:00 | QQQ | ETF | 35.22 | 35.23 | 35.2 | 35.2 | 29000.0 |
| 2003-10-29 09:00:00 | QQQ | ETF | 35.2 | 35.24 | 35.2 | 35.2 | 105900.0 |
| 2003-10-29 09:30:00 | QQQ | ETF | 35.2 | 35.29 | 35.13 | 35.182 | 7745000.0 |
| 2003-10-29 10:00:00 | QQQ | ETF | 35.18 | 35.35 | 35.11 | 35.17 | 7536800.0 |
| 2003-10-29 10:30:00 | QQQ | ETF | 35.169 | 35.251 | 35.07 | 35.21 | 5704700.0 |
| 2003-10-29 11:00:00 | QQQ | ETF | 35.21 | 35.23 | 35.087 | 35.21 | 2910700.0 |
| 2003-10-29 11:30:00 | QQQ | ETF | 35.22 | 35.22 | 35.1 | 35.147 | 1896100.0 |
| 2003-10-29 12:00:00 | QQQ | ETF | 35.14 | 35.26 | 35.11 | 35.23 | 3890200.0 |
| 2003-10-29 12:30:00 | QQQ | ETF | 35.23 | 35.25 | 35.1 | 35.16 | 2245200.0 |
| 2003-10-29 13:00:00 | QQQ | ETF | 35.15 | 35.4 | 35.14 | 35.38 | 3401200.0 |
| 2003-10-29 13:30:00 | QQQ | ETF | 35.379 | 35.39 | 35.189 | 35.31 | 4466400.0 |
| 2003-10-29 14:00:00 | QQQ | ETF | 35.288 | 35.41 | 35.16 | 35.39 | 5958800.0 |
| 2003-10-29 14:30:00 | QQQ | ETF | 35.39 | 35.396 | 35.18 | 35.3 | 3412900.0 |
| 2003-10-29 15:00:00 | QQQ | ETF | 35.32 | 35.38 | 35.25 | 35.29 | 3891200.0 |
| 2003-10-29 15:30:00 | QQQ | ETF | 35.28 | 35.39 | 35.25 | 35.3 | 5230600.0 |
| 2003-10-29 16:00:00 | QQQ | ETF | 35.3 | 35.33 | 35.27 | 35.3 | 1599400.0 |
| 2003-10-29 16:30:00 | QQQ | ETF | 35.3 | 35.31 | 35.25 | 35.25 | 172800.0 |
| 2003-10-29 17:00:00 | QQQ | ETF | 35.27 | 35.29 | 35.24 | 35.24 | 174300.0 |
| 2003-10-29 17:30:00 | QQQ | ETF | 35.24 | 35.3 | 35.24 | 35.3 | 26300.0 |
| 2003-10-29 18:00:00 | QQQ | ETF | 35.27 | 35.28 | 35.26 | 35.28 | 28000.0 |
| 2003-10-29 18:30:00 | QQQ | ETF | 35.27 | 35.28 | 35.26 | 35.27 | 19100.0 |
| 2003-10-29 19:00:00 | QQQ | ETF | 35.27 | 35.27 | 35.27 | 35.27 | 2000.0 |
| 2003-10-29 19:30:00 | QQQ | ETF | 35.27 | 35.3 | 35.27 | 35.3 | 10400.0 |
| 2003-10-29 08:30:00 | IWM | ETF | 52.46 | 52.46 | 52.46 | 52.46 | 2000.0 |
| 2003-10-29 09:30:00 | IWM | ETF | 52.385 | 52.49 | 52.29 | 52.465 | 1291000.0 |
| 2003-10-29 10:00:00 | IWM | ETF | 52.468 | 52.735 | 52.45 | 52.65 | 1923600.0 |
> showing 50 of 793 rows — these rows as CSV