PREVIEW / etf_30min / 2004-09-07
file: by_date/etf_30min/2004/2004-09-07.parquet size: 36 KB rows: 1,196
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-07 08:00:00 | SPY | ETF | 112.6 | 112.63 | 112.53 | 112.63 | 33300.0 |
| 2004-09-07 08:30:00 | SPY | ETF | 112.64 | 112.65 | 112.6 | 112.62 | 21500.0 |
| 2004-09-07 09:00:00 | SPY | ETF | 112.62 | 112.65 | 112.52 | 112.55 | 18900.0 |
| 2004-09-07 09:30:00 | SPY | ETF | 112.54 | 112.89 | 112.54 | 112.68 | 4739800.0 |
| 2004-09-07 10:00:00 | SPY | ETF | 112.7 | 112.82 | 112.57 | 112.7 | 3371300.0 |
| 2004-09-07 10:30:00 | SPY | ETF | 112.7 | 112.72 | 112.45 | 112.52 | 3189000.0 |
| 2004-09-07 11:00:00 | SPY | ETF | 112.54 | 112.71 | 112.49 | 112.63 | 1508100.0 |
| 2004-09-07 11:30:00 | SPY | ETF | 112.63 | 112.78 | 112.63 | 112.67 | 1030600.0 |
| 2004-09-07 12:00:00 | SPY | ETF | 112.69 | 112.85 | 112.68 | 112.74 | 1508500.0 |
| 2004-09-07 12:30:00 | SPY | ETF | 112.74 | 113.03 | 112.67 | 113.0 | 2212500.0 |
| 2004-09-07 13:00:00 | SPY | ETF | 113.0 | 113.09 | 112.95 | 113.04 | 1257600.0 |
| 2004-09-07 13:30:00 | SPY | ETF | 113.032 | 113.13 | 112.76 | 112.8 | 2554800.0 |
| 2004-09-07 14:00:00 | SPY | ETF | 112.8 | 112.85 | 112.63 | 112.68 | 2052500.0 |
| 2004-09-07 14:30:00 | SPY | ETF | 112.68 | 112.72 | 112.32 | 112.51 | 4419300.0 |
| 2004-09-07 15:00:00 | SPY | ETF | 112.51 | 112.63 | 112.42 | 112.44 | 2115900.0 |
| 2004-09-07 15:30:00 | SPY | ETF | 112.44 | 112.85 | 112.41 | 112.81 | 3253300.0 |
| 2004-09-07 16:00:00 | SPY | ETF | 112.82 | 112.99 | 112.8 | 112.86 | 2220000.0 |
| 2004-09-07 16:30:00 | SPY | ETF | 112.89 | 112.89 | 112.8 | 112.83 | 56900.0 |
| 2004-09-07 17:00:00 | SPY | ETF | 112.85 | 112.86 | 112.81 | 112.81 | 3800.0 |
| 2004-09-07 17:30:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 700.0 |
| 2004-09-07 18:00:00 | SPY | ETF | 112.85 | 112.86 | 112.8 | 112.81 | 4100.0 |
| 2004-09-07 08:00:00 | QQQ | ETF | 34.35 | 34.37 | 34.34 | 34.36 | 86800.0 |
| 2004-09-07 08:30:00 | QQQ | ETF | 34.36 | 34.41 | 34.36 | 34.39 | 165300.0 |
| 2004-09-07 09:00:00 | QQQ | ETF | 34.39 | 34.41 | 34.38 | 34.39 | 111500.0 |
| 2004-09-07 09:30:00 | QQQ | ETF | 34.4 | 34.55 | 34.36 | 34.43 | 14253700.0 |
| 2004-09-07 10:00:00 | QQQ | ETF | 34.43 | 34.5 | 34.37 | 34.47 | 10297400.0 |
| 2004-09-07 10:30:00 | QQQ | ETF | 34.44 | 34.45 | 34.294 | 34.34 | 7828600.0 |
| 2004-09-07 11:00:00 | QQQ | ETF | 34.35 | 34.47 | 34.33 | 34.44 | 4835800.0 |
| 2004-09-07 11:30:00 | QQQ | ETF | 34.43 | 34.54 | 34.43 | 34.466 | 3678200.0 |
| 2004-09-07 12:00:00 | QQQ | ETF | 34.47 | 34.553 | 34.46 | 34.495 | 5058000.0 |
| 2004-09-07 12:30:00 | QQQ | ETF | 34.5 | 34.58 | 34.46 | 34.58 | 6598600.0 |
| 2004-09-07 13:00:00 | QQQ | ETF | 34.56 | 34.59 | 34.51 | 34.55 | 3049800.0 |
| 2004-09-07 13:30:00 | QQQ | ETF | 34.54 | 34.61 | 34.448 | 34.45 | 4673600.0 |
| 2004-09-07 14:00:00 | QQQ | ETF | 34.45 | 34.48 | 34.37 | 34.38 | 5460000.0 |
| 2004-09-07 14:30:00 | QQQ | ETF | 34.38 | 34.41 | 34.12 | 34.194 | 10378500.0 |
| 2004-09-07 15:00:00 | QQQ | ETF | 34.19 | 34.27 | 34.16 | 34.19 | 6333300.0 |
| 2004-09-07 15:30:00 | QQQ | ETF | 34.19 | 34.38 | 34.171 | 34.37 | 7790000.0 |
| 2004-09-07 16:00:00 | QQQ | ETF | 34.36 | 34.43 | 34.34 | 34.38 | 1658900.0 |
| 2004-09-07 16:30:00 | QQQ | ETF | 34.38 | 34.42 | 34.35 | 34.35 | 484300.0 |
| 2004-09-07 17:00:00 | QQQ | ETF | 34.352 | 34.39 | 34.34 | 34.389 | 89700.0 |
| 2004-09-07 17:30:00 | QQQ | ETF | 34.43 | 34.43 | 34.38 | 34.4 | 1009100.0 |
| 2004-09-07 18:00:00 | QQQ | ETF | 34.38 | 34.393 | 34.38 | 34.39 | 4700.0 |
| 2004-09-07 19:30:00 | QQQ | ETF | 34.36 | 34.36 | 34.36 | 34.36 | 1000.0 |
| 2004-09-07 08:30:00 | IWM | ETF | 55.94 | 55.94 | 55.905 | 55.905 | 8000.0 |
| 2004-09-07 09:00:00 | IWM | ETF | 55.89 | 55.89 | 55.87 | 55.87 | 2800.0 |
| 2004-09-07 09:30:00 | IWM | ETF | 55.905 | 56.155 | 55.86 | 56.035 | 3120600.0 |
| 2004-09-07 10:00:00 | IWM | ETF | 56.035 | 56.11 | 55.905 | 55.905 | 1028200.0 |
| 2004-09-07 10:30:00 | IWM | ETF | 55.91 | 55.91 | 55.705 | 55.83 | 787400.0 |
| 2004-09-07 11:00:00 | IWM | ETF | 55.83 | 56.115 | 55.82 | 56.095 | 1081200.0 |
| 2004-09-07 11:30:00 | IWM | ETF | 56.095 | 56.19 | 56.09 | 56.13 | 637400.0 |
> showing 50 of 1,196 rows — these rows as CSV