PREVIEW / etf_30min / 2004-08-12
file: by_date/etf_30min/2004/2004-08-12.parquet size: 36 KB rows: 1,161
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-08-12 08:00:00 | SPY | ETF | 107.69 | 107.74 | 107.65 | 107.66 | 118800.0 |
| 2004-08-12 08:30:00 | SPY | ETF | 107.65 | 107.9 | 107.57 | 107.83 | 221100.0 |
| 2004-08-12 09:00:00 | SPY | ETF | 107.83 | 107.88 | 107.68 | 107.68 | 58800.0 |
| 2004-08-12 09:30:00 | SPY | ETF | 107.68 | 107.95 | 107.62 | 107.84 | 3906900.0 |
| 2004-08-12 10:00:00 | SPY | ETF | 107.84 | 107.85 | 107.2 | 107.35 | 5673200.0 |
| 2004-08-12 10:30:00 | SPY | ETF | 107.35 | 107.53 | 107.23 | 107.36 | 2582600.0 |
| 2004-08-12 11:00:00 | SPY | ETF | 107.38 | 107.72 | 107.31 | 107.62 | 3345900.0 |
| 2004-08-12 11:30:00 | SPY | ETF | 107.65 | 107.67 | 107.37 | 107.4 | 2936200.0 |
| 2004-08-12 12:00:00 | SPY | ETF | 107.4 | 107.53 | 107.27 | 107.31 | 1761600.0 |
| 2004-08-12 12:30:00 | SPY | ETF | 107.31 | 107.48 | 107.26 | 107.42 | 1359600.0 |
| 2004-08-12 13:00:00 | SPY | ETF | 107.42 | 107.42 | 106.77 | 107.01 | 5503400.0 |
| 2004-08-12 13:30:00 | SPY | ETF | 107.0 | 107.14 | 106.92 | 107.1 | 2380600.0 |
| 2004-08-12 14:00:00 | SPY | ETF | 107.09 | 107.19 | 106.89 | 107.08 | 2993000.0 |
| 2004-08-12 14:30:00 | SPY | ETF | 107.09 | 107.36 | 106.92 | 107.24 | 3719500.0 |
| 2004-08-12 15:00:00 | SPY | ETF | 107.24 | 107.26 | 107.0 | 107.08 | 2386200.0 |
| 2004-08-12 15:30:00 | SPY | ETF | 107.06 | 107.13 | 106.82 | 106.85 | 5382800.0 |
| 2004-08-12 16:00:00 | SPY | ETF | 106.85 | 107.02 | 106.7 | 107.0 | 1665100.0 |
| 2004-08-12 16:30:00 | SPY | ETF | 107.01 | 108.1205 | 106.85 | 107.0 | 2593100.0 |
| 2004-08-12 17:00:00 | SPY | ETF | 107.03 | 107.03 | 106.96 | 107.02 | 783900.0 |
| 2004-08-12 17:30:00 | SPY | ETF | 107.0 | 107.03 | 107.0 | 107.03 | 200.0 |
| 2004-08-12 18:00:00 | SPY | ETF | 107.04 | 107.19 | 107.04 | 107.19 | 18400.0 |
| 2004-08-12 18:30:00 | SPY | ETF | 107.11 | 107.12 | 107.11 | 107.12 | 1500.0 |
| 2004-08-12 19:00:00 | SPY | ETF | 107.13 | 107.13 | 107.08 | 107.08 | 3300.0 |
| 2004-08-12 19:30:00 | SPY | ETF | 107.08 | 107.09 | 107.07 | 107.07 | 1700.0 |
| 2004-08-12 08:00:00 | QQQ | ETF | 32.77 | 32.77 | 32.72 | 32.76 | 232400.0 |
| 2004-08-12 08:30:00 | QQQ | ETF | 32.74 | 32.83 | 32.71 | 32.79 | 420800.0 |
| 2004-08-12 09:00:00 | QQQ | ETF | 32.79 | 32.8 | 32.68 | 32.68 | 446500.0 |
| 2004-08-12 09:30:00 | QQQ | ETF | 32.69 | 32.857 | 32.66 | 32.784 | 12876300.0 |
| 2004-08-12 10:00:00 | QQQ | ETF | 32.78 | 32.8 | 32.57 | 32.615 | 10696900.0 |
| 2004-08-12 10:30:00 | QQQ | ETF | 32.62 | 32.68 | 32.539 | 32.6 | 7204400.0 |
| 2004-08-12 11:00:00 | QQQ | ETF | 32.61 | 32.79 | 32.57 | 32.748 | 6878300.0 |
| 2004-08-12 11:30:00 | QQQ | ETF | 32.75 | 32.77 | 32.62 | 32.62 | 4963000.0 |
| 2004-08-12 12:00:00 | QQQ | ETF | 32.62 | 32.69 | 32.56 | 32.58 | 4783100.0 |
| 2004-08-12 12:30:00 | QQQ | ETF | 32.58 | 32.67 | 32.544 | 32.63 | 3986100.0 |
| 2004-08-12 13:00:00 | QQQ | ETF | 32.62 | 32.63 | 32.37 | 32.47 | 9767600.0 |
| 2004-08-12 13:30:00 | QQQ | ETF | 32.477 | 32.52 | 32.4 | 32.51 | 4233900.0 |
| 2004-08-12 14:00:00 | QQQ | ETF | 32.504 | 32.53 | 32.39 | 32.52 | 7297200.0 |
| 2004-08-12 14:30:00 | QQQ | ETF | 32.526 | 32.678 | 32.47 | 32.6 | 12228200.0 |
| 2004-08-12 15:00:00 | QQQ | ETF | 32.61 | 32.611 | 32.49 | 32.559 | 5594300.0 |
| 2004-08-12 15:30:00 | QQQ | ETF | 32.553 | 32.61 | 32.45 | 32.456 | 10655700.0 |
| 2004-08-12 16:00:00 | QQQ | ETF | 32.46 | 32.58 | 32.4 | 32.53 | 4857400.0 |
| 2004-08-12 16:30:00 | QQQ | ETF | 32.54 | 32.6 | 32.43 | 32.578 | 663000.0 |
| 2004-08-12 17:00:00 | QQQ | ETF | 32.57 | 32.59 | 32.55 | 32.57 | 202300.0 |
| 2004-08-12 17:30:00 | QQQ | ETF | 32.57 | 32.62 | 32.55 | 32.62 | 138400.0 |
| 2004-08-12 18:00:00 | QQQ | ETF | 32.6 | 32.655 | 32.6 | 32.63 | 184900.0 |
| 2004-08-12 18:30:00 | QQQ | ETF | 32.64 | 32.64 | 32.62 | 32.62 | 51200.0 |
| 2004-08-12 19:00:00 | QQQ | ETF | 32.62 | 32.66 | 32.6 | 32.65 | 120200.0 |
| 2004-08-12 19:30:00 | QQQ | ETF | 32.64 | 32.64 | 32.62 | 32.62 | 1900.0 |
| 2004-08-12 08:30:00 | IWM | ETF | 52.095 | 52.305 | 52.095 | 52.265 | 6800.0 |
| 2004-08-12 09:00:00 | IWM | ETF | 52.275 | 52.275 | 52.125 | 52.125 | 3200.0 |
> showing 50 of 1,161 rows — these rows as CSV