PREVIEW / etf_30min / 2004-11-22
file: by_date/etf_30min/2004/2004-11-22.parquet size: 40 KB rows: 1,333
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-11-22 08:00:00 | SPY | ETF | 117.12 | 117.15 | 117.12 | 117.13 | 8700.0 |
| 2004-11-22 08:30:00 | SPY | ETF | 117.11 | 117.13 | 117.06 | 117.13 | 16000.0 |
| 2004-11-22 09:00:00 | SPY | ETF | 117.14 | 117.24 | 117.11 | 117.17 | 54900.0 |
| 2004-11-22 09:30:00 | SPY | ETF | 117.17 | 117.25 | 117.09 | 117.09 | 3667800.0 |
| 2004-11-22 10:00:00 | SPY | ETF | 117.12 | 117.38 | 117.05 | 117.31 | 4250700.0 |
| 2004-11-22 10:30:00 | SPY | ETF | 117.32 | 117.34 | 117.03 | 117.16 | 2402600.0 |
| 2004-11-22 11:00:00 | SPY | ETF | 117.14 | 117.29 | 117.05 | 117.24 | 1996300.0 |
| 2004-11-22 11:30:00 | SPY | ETF | 117.24 | 117.32 | 117.11 | 117.15 | 1234600.0 |
| 2004-11-22 12:00:00 | SPY | ETF | 117.15 | 117.18 | 117.11 | 117.17 | 534400.0 |
| 2004-11-22 12:30:00 | SPY | ETF | 117.17 | 117.43 | 117.15 | 117.35 | 1378300.0 |
| 2004-11-22 13:00:00 | SPY | ETF | 117.35 | 117.67 | 117.34 | 117.67 | 2690900.0 |
| 2004-11-22 13:30:00 | SPY | ETF | 117.67 | 117.83 | 117.64 | 117.83 | 2959300.0 |
| 2004-11-22 14:00:00 | SPY | ETF | 117.83 | 118.12 | 117.81 | 118.03 | 3568100.0 |
| 2004-11-22 14:30:00 | SPY | ETF | 118.03 | 118.04 | 117.8 | 117.82 | 2045600.0 |
| 2004-11-22 15:00:00 | SPY | ETF | 117.81 | 118.05 | 117.75 | 118.01 | 2419200.0 |
| 2004-11-22 15:30:00 | SPY | ETF | 118.01 | 118.04 | 117.78 | 117.95 | 3898300.0 |
| 2004-11-22 16:00:00 | SPY | ETF | 117.97 | 118.04 | 117.94 | 117.99 | 1925600.0 |
| 2004-11-22 16:30:00 | SPY | ETF | 117.97 | 117.99 | 117.95 | 117.95 | 176000.0 |
| 2004-11-22 17:00:00 | SPY | ETF | 117.96 | 117.99 | 117.1 | 117.98 | 6300.0 |
| 2004-11-22 17:30:00 | SPY | ETF | 117.96 | 117.96 | 117.96 | 117.96 | 200.0 |
| 2004-11-22 18:00:00 | SPY | ETF | 118.0 | 118.0 | 117.97 | 117.98 | 400.0 |
| 2004-11-22 19:00:00 | SPY | ETF | 117.98 | 118.03 | 117.98 | 118.03 | 7100.0 |
| 2004-11-22 19:30:00 | SPY | ETF | 118.01 | 118.01 | 118.0 | 118.0 | 800.0 |
| 2004-11-22 08:00:00 | QQQ | ETF | 38.51 | 38.57 | 38.5 | 38.5 | 42200.0 |
| 2004-11-22 08:30:00 | QQQ | ETF | 38.5 | 38.55 | 38.5 | 38.55 | 41300.0 |
| 2004-11-22 09:00:00 | QQQ | ETF | 38.55 | 38.61 | 38.54 | 38.6 | 235200.0 |
| 2004-11-22 09:30:00 | QQQ | ETF | 38.61 | 38.64 | 38.54 | 38.571 | 9767500.0 |
| 2004-11-22 10:00:00 | QQQ | ETF | 38.57 | 38.65 | 38.51 | 38.61 | 8293700.0 |
| 2004-11-22 10:30:00 | QQQ | ETF | 38.61 | 38.63 | 38.48 | 38.55 | 5997500.0 |
| 2004-11-22 11:00:00 | QQQ | ETF | 38.55 | 38.6 | 38.5 | 38.57 | 4294800.0 |
| 2004-11-22 11:30:00 | QQQ | ETF | 38.59 | 38.61 | 38.52 | 38.535 | 2816100.0 |
| 2004-11-22 12:00:00 | QQQ | ETF | 38.55 | 38.55 | 38.515 | 38.542 | 1963100.0 |
| 2004-11-22 12:30:00 | QQQ | ETF | 38.543 | 38.71 | 38.53 | 38.69 | 3989800.0 |
| 2004-11-22 13:00:00 | QQQ | ETF | 38.69 | 38.86 | 38.68 | 38.85 | 7959800.0 |
| 2004-11-22 13:30:00 | QQQ | ETF | 38.856 | 38.95 | 38.85 | 38.9 | 5774900.0 |
| 2004-11-22 14:00:00 | QQQ | ETF | 38.9 | 39.04 | 38.9 | 38.99 | 7633400.0 |
| 2004-11-22 14:30:00 | QQQ | ETF | 38.99 | 39.0 | 38.89 | 38.907 | 4654300.0 |
| 2004-11-22 15:00:00 | QQQ | ETF | 38.909 | 39.01 | 38.87 | 38.98 | 4892300.0 |
| 2004-11-22 15:30:00 | QQQ | ETF | 38.98 | 39.03 | 38.891 | 39.02 | 6952100.0 |
| 2004-11-22 16:00:00 | QQQ | ETF | 39.02 | 39.07 | 38.88 | 39.05 | 2570100.0 |
| 2004-11-22 16:30:00 | QQQ | ETF | 39.05 | 39.051 | 39.035 | 39.05 | 111900.0 |
| 2004-11-22 17:00:00 | QQQ | ETF | 39.05 | 39.064 | 39.05 | 39.05 | 62300.0 |
| 2004-11-22 17:30:00 | QQQ | ETF | 39.05 | 39.07 | 39.03 | 39.042 | 24000.0 |
| 2004-11-22 18:00:00 | QQQ | ETF | 39.051 | 39.06 | 39.05 | 39.06 | 14600.0 |
| 2004-11-22 18:30:00 | QQQ | ETF | 39.06 | 39.06 | 39.06 | 39.06 | 800.0 |
| 2004-11-22 19:00:00 | QQQ | ETF | 39.05 | 39.06 | 39.05 | 39.06 | 8400.0 |
| 2004-11-22 19:30:00 | QQQ | ETF | 39.05 | 39.05 | 39.04 | 39.05 | 5800.0 |
| 2004-11-22 08:30:00 | IWM | ETF | 61.005 | 61.025 | 60.975 | 60.975 | 3200.0 |
| 2004-11-22 09:00:00 | IWM | ETF | 61.065 | 61.065 | 61.065 | 61.065 | 9800.0 |
| 2004-11-22 09:30:00 | IWM | ETF | 61.075 | 61.255 | 61.075 | 61.155 | 2376800.0 |
> showing 50 of 1,333 rows — these rows as CSV