PREVIEW / etf_30min / 2002-12-10
file: by_date/etf_30min/2002/2002-12-10.parquet size: 21 KB rows: 627
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-10 08:00:00 | SPY | ETF | 90.2 | 90.29 | 90.15 | 90.21 | 27800.0 |
| 2002-12-10 08:30:00 | SPY | ETF | 90.21 | 90.27 | 90.2 | 90.24 | 59400.0 |
| 2002-12-10 09:00:00 | SPY | ETF | 90.27 | 90.27 | 90.12 | 90.15 | 10100.0 |
| 2002-12-10 09:30:00 | SPY | ETF | 90.02 | 90.33 | 89.82 | 90.09 | 4432600.0 |
| 2002-12-10 10:00:00 | SPY | ETF | 90.09 | 90.38 | 89.87 | 89.94 | 3549000.0 |
| 2002-12-10 10:30:00 | SPY | ETF | 89.92 | 90.22 | 89.76 | 90.02 | 3085800.0 |
| 2002-12-10 11:00:00 | SPY | ETF | 90.04 | 90.5 | 89.99 | 90.44 | 2246300.0 |
| 2002-12-10 11:30:00 | SPY | ETF | 90.41 | 90.71 | 90.41 | 90.51 | 1954100.0 |
| 2002-12-10 12:00:00 | SPY | ETF | 90.51 | 90.55 | 90.35 | 90.39 | 969200.0 |
| 2002-12-10 12:30:00 | SPY | ETF | 90.41 | 90.49 | 90.21 | 90.44 | 1352700.0 |
| 2002-12-10 13:00:00 | SPY | ETF | 90.44 | 90.6 | 90.32 | 90.46 | 564600.0 |
| 2002-12-10 13:30:00 | SPY | ETF | 90.5 | 90.71 | 90.46 | 90.71 | 1201800.0 |
| 2002-12-10 14:00:00 | SPY | ETF | 90.75 | 90.84 | 90.41 | 90.6 | 2799100.0 |
| 2002-12-10 14:30:00 | SPY | ETF | 90.57 | 90.66 | 90.4 | 90.48 | 1877600.0 |
| 2002-12-10 15:00:00 | SPY | ETF | 90.46 | 90.82 | 90.27 | 90.75 | 1843900.0 |
| 2002-12-10 15:30:00 | SPY | ETF | 90.75 | 91.1 | 90.74 | 90.92 | 3150500.0 |
| 2002-12-10 16:00:00 | SPY | ETF | 90.96 | 91.09 | 90.7 | 90.82 | 1384000.0 |
| 2002-12-10 16:30:00 | SPY | ETF | 90.82 | 90.82 | 90.75 | 90.79 | 185600.0 |
| 2002-12-10 17:00:00 | SPY | ETF | 90.79 | 90.79 | 90.76 | 90.77 | 14300.0 |
| 2002-12-10 17:30:00 | SPY | ETF | 90.78 | 90.82 | 90.77 | 90.79 | 103100.0 |
| 2002-12-10 18:00:00 | SPY | ETF | 90.79 | 90.79 | 90.73 | 90.75 | 5900.0 |
| 2002-12-10 18:30:00 | SPY | ETF | 90.7 | 90.78 | 90.7 | 90.71 | 3000.0 |
| 2002-12-10 19:00:00 | SPY | ETF | 90.71 | 90.71 | 90.7 | 90.7 | 2000.0 |
| 2002-12-10 19:30:00 | SPY | ETF | 90.78 | 90.79 | 90.78 | 90.79 | 600.0 |
| 2002-12-10 08:00:00 | QQQ | ETF | 25.4 | 25.45 | 25.38 | 25.39 | 70100.0 |
| 2002-12-10 08:30:00 | QQQ | ETF | 25.4 | 25.45 | 25.4 | 25.43 | 15600.0 |
| 2002-12-10 09:00:00 | QQQ | ETF | 25.41 | 25.43 | 25.36 | 25.38 | 52100.0 |
| 2002-12-10 09:30:00 | QQQ | ETF | 25.42 | 25.57 | 25.35 | 25.46 | 11960900.0 |
| 2002-12-10 10:00:00 | QQQ | ETF | 25.46 | 25.66 | 25.43 | 25.49 | 6675500.0 |
| 2002-12-10 10:30:00 | QQQ | ETF | 25.5 | 25.68 | 25.46 | 25.61 | 5720300.0 |
| 2002-12-10 11:00:00 | QQQ | ETF | 25.6 | 25.85 | 25.58 | 25.82 | 7498000.0 |
| 2002-12-10 11:30:00 | QQQ | ETF | 25.82 | 25.95 | 25.8 | 25.85 | 5937100.0 |
| 2002-12-10 12:00:00 | QQQ | ETF | 25.85 | 25.88 | 25.75 | 25.8 | 2528200.0 |
| 2002-12-10 12:30:00 | QQQ | ETF | 25.78 | 25.85 | 25.7 | 25.83 | 2069000.0 |
| 2002-12-10 13:00:00 | QQQ | ETF | 25.83 | 25.84 | 25.76 | 25.81 | 1243000.0 |
| 2002-12-10 13:30:00 | QQQ | ETF | 25.8 | 25.92 | 25.8 | 25.9 | 2029200.0 |
| 2002-12-10 14:00:00 | QQQ | ETF | 25.9 | 25.95 | 25.74 | 25.85 | 4571500.0 |
| 2002-12-10 14:30:00 | QQQ | ETF | 25.81 | 25.88 | 25.7 | 25.78 | 4667200.0 |
| 2002-12-10 15:00:00 | QQQ | ETF | 25.78 | 25.84 | 25.63 | 25.8 | 3658900.0 |
| 2002-12-10 15:30:00 | QQQ | ETF | 25.78 | 25.87 | 25.66 | 25.67 | 5177900.0 |
| 2002-12-10 16:00:00 | QQQ | ETF | 25.67 | 25.76 | 25.56 | 25.61 | 1558700.0 |
| 2002-12-10 16:30:00 | QQQ | ETF | 25.61 | 25.63 | 25.59 | 25.61 | 119300.0 |
| 2002-12-10 17:00:00 | QQQ | ETF | 25.61 | 25.64 | 25.61 | 25.63 | 308700.0 |
| 2002-12-10 17:30:00 | QQQ | ETF | 25.64 | 25.67 | 25.62 | 25.63 | 50800.0 |
| 2002-12-10 18:00:00 | QQQ | ETF | 25.62 | 25.67 | 25.62 | 25.65 | 14600.0 |
| 2002-12-10 18:30:00 | QQQ | ETF | 25.65 | 25.66 | 25.59 | 25.64 | 28300.0 |
| 2002-12-10 19:00:00 | QQQ | ETF | 25.63 | 25.63 | 25.6 | 25.6 | 8600.0 |
| 2002-12-10 19:30:00 | QQQ | ETF | 25.58 | 25.63 | 25.58 | 25.62 | 3200.0 |
| 2002-12-10 09:30:00 | IWM | ETF | 38.74 | 38.975 | 38.735 | 38.845 | 205600.0 |
| 2002-12-10 10:00:00 | IWM | ETF | 38.82 | 38.98 | 38.82 | 38.88 | 164800.0 |
> showing 50 of 627 rows — these rows as CSV