PREVIEW / etf_30min / 2004-10-19
file: by_date/etf_30min/2004/2004-10-19.parquet size: 38 KB rows: 1,249
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-10-19 08:00:00 | SPY | ETF | 112.2 | 112.2 | 112.15 | 112.18 | 72100.0 |
| 2004-10-19 08:30:00 | SPY | ETF | 112.17 | 112.17 | 112.06 | 112.07 | 63900.0 |
| 2004-10-19 09:00:00 | SPY | ETF | 112.08 | 112.1 | 112.03 | 112.03 | 47700.0 |
| 2004-10-19 09:30:00 | SPY | ETF | 112.02 | 112.12 | 111.89 | 111.92 | 5025300.0 |
| 2004-10-19 10:00:00 | SPY | ETF | 111.92 | 112.23 | 111.87 | 111.88 | 5507200.0 |
| 2004-10-19 10:30:00 | SPY | ETF | 111.89 | 111.97 | 111.68 | 111.73 | 5171100.0 |
| 2004-10-19 11:00:00 | SPY | ETF | 111.72 | 111.79 | 111.3 | 111.4 | 5195900.0 |
| 2004-10-19 11:30:00 | SPY | ETF | 111.41 | 111.53 | 111.31 | 111.44 | 3223700.0 |
| 2004-10-19 12:00:00 | SPY | ETF | 111.45 | 111.69 | 111.43 | 111.65 | 1758500.0 |
| 2004-10-19 12:30:00 | SPY | ETF | 111.65 | 111.7 | 111.48 | 111.54 | 1881900.0 |
| 2004-10-19 13:00:00 | SPY | ETF | 111.54 | 111.57 | 111.29 | 111.52 | 3063200.0 |
| 2004-10-19 13:30:00 | SPY | ETF | 111.5 | 111.59 | 111.15 | 111.16 | 2877000.0 |
| 2004-10-19 14:00:00 | SPY | ETF | 111.16 | 111.22 | 110.93 | 111.02 | 4489900.0 |
| 2004-10-19 14:30:00 | SPY | ETF | 111.03 | 111.09 | 110.78 | 110.86 | 2281200.0 |
| 2004-10-19 15:00:00 | SPY | ETF | 110.87 | 110.95 | 110.76 | 110.83 | 2059500.0 |
| 2004-10-19 15:30:00 | SPY | ETF | 110.84 | 110.99 | 110.66 | 110.72 | 4463000.0 |
| 2004-10-19 16:00:00 | SPY | ETF | 110.73 | 110.77 | 110.59 | 110.73 | 1931700.0 |
| 2004-10-19 16:30:00 | SPY | ETF | 110.73 | 110.73 | 110.64 | 110.64 | 373200.0 |
| 2004-10-19 17:00:00 | SPY | ETF | 110.64 | 110.66 | 110.49 | 110.5 | 113700.0 |
| 2004-10-19 17:30:00 | SPY | ETF | 110.49 | 110.6 | 110.41 | 110.5 | 35200.0 |
| 2004-10-19 18:00:00 | SPY | ETF | 110.5 | 110.54 | 110.32 | 110.37 | 58600.0 |
| 2004-10-19 18:30:00 | SPY | ETF | 110.4 | 110.4 | 110.31 | 110.39 | 2500.0 |
| 2004-10-19 19:00:00 | SPY | ETF | 110.34 | 110.42 | 110.34 | 110.42 | 2100.0 |
| 2004-10-19 19:30:00 | SPY | ETF | 110.4 | 110.42 | 110.4 | 110.42 | 2100.0 |
| 2004-10-19 08:00:00 | QQQ | ETF | 36.5 | 36.52 | 36.47 | 36.5 | 705000.0 |
| 2004-10-19 08:30:00 | QQQ | ETF | 36.5 | 36.52 | 36.4 | 36.42 | 366300.0 |
| 2004-10-19 09:00:00 | QQQ | ETF | 36.42 | 36.45 | 36.37 | 36.38 | 549300.0 |
| 2004-10-19 09:30:00 | QQQ | ETF | 36.38 | 36.45 | 36.31 | 36.36 | 16340300.0 |
| 2004-10-19 10:00:00 | QQQ | ETF | 36.36 | 36.57 | 36.336 | 36.43 | 15777600.0 |
| 2004-10-19 10:30:00 | QQQ | ETF | 36.44 | 36.53 | 36.38 | 36.41 | 8234200.0 |
| 2004-10-19 11:00:00 | QQQ | ETF | 36.41 | 36.47 | 36.19 | 36.28 | 12506600.0 |
| 2004-10-19 11:30:00 | QQQ | ETF | 36.28 | 36.37 | 36.25 | 36.314 | 5813900.0 |
| 2004-10-19 12:00:00 | QQQ | ETF | 36.31 | 36.4 | 36.3 | 36.35 | 5261100.0 |
| 2004-10-19 12:30:00 | QQQ | ETF | 36.35 | 36.4 | 36.26 | 36.3 | 4181300.0 |
| 2004-10-19 13:00:00 | QQQ | ETF | 36.3 | 36.34 | 36.17 | 36.31 | 5904800.0 |
| 2004-10-19 13:30:00 | QQQ | ETF | 36.31 | 36.4 | 36.16 | 36.17 | 6746200.0 |
| 2004-10-19 14:00:00 | QQQ | ETF | 36.17 | 36.19 | 36.046 | 36.09 | 11364200.0 |
| 2004-10-19 14:30:00 | QQQ | ETF | 36.083 | 36.09 | 35.93 | 36.0 | 8778000.0 |
| 2004-10-19 15:00:00 | QQQ | ETF | 36.0 | 36.05 | 35.94 | 35.977 | 9189700.0 |
| 2004-10-19 15:30:00 | QQQ | ETF | 35.976 | 36.09 | 35.89 | 35.91 | 9914300.0 |
| 2004-10-19 16:00:00 | QQQ | ETF | 35.91 | 35.951 | 35.79 | 35.89 | 4722000.0 |
| 2004-10-19 16:30:00 | QQQ | ETF | 35.89 | 35.895 | 35.83 | 35.83 | 741000.0 |
| 2004-10-19 17:00:00 | QQQ | ETF | 35.83 | 35.86 | 35.78 | 35.79 | 431000.0 |
| 2004-10-19 17:30:00 | QQQ | ETF | 35.78 | 35.83 | 35.77 | 35.77 | 39000.0 |
| 2004-10-19 18:00:00 | QQQ | ETF | 35.79 | 35.82 | 35.758 | 35.76 | 82600.0 |
| 2004-10-19 19:00:00 | QQQ | ETF | 35.78 | 35.79 | 35.78 | 35.79 | 6100.0 |
| 2004-10-19 19:30:00 | QQQ | ETF | 35.79 | 35.79 | 35.79 | 35.79 | 2000.0 |
| 2004-10-19 08:30:00 | IWM | ETF | 57.325 | 57.375 | 57.325 | 57.375 | 3800.0 |
| 2004-10-19 09:00:00 | IWM | ETF | 57.385 | 57.385 | 57.34 | 57.34 | 26800.0 |
| 2004-10-19 09:30:00 | IWM | ETF | 57.265 | 57.5 | 57.235 | 57.34 | 2080600.0 |
> showing 50 of 1,249 rows — these rows as CSV