PREVIEW / etf_30min / 2002-11-12
file: by_date/etf_30min/2002/2002-11-12.parquet size: 22 KB rows: 648
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-11-12 08:00:00 | SPY | ETF | 88.74 | 88.79 | 88.74 | 88.74 | 1500.0 |
| 2002-11-12 08:30:00 | SPY | ETF | 88.84 | 88.84 | 88.8 | 88.8 | 700.0 |
| 2002-11-12 09:00:00 | SPY | ETF | 88.74 | 88.74 | 88.62 | 88.65 | 3400.0 |
| 2002-11-12 09:30:00 | SPY | ETF | 88.66 | 88.93 | 88.43 | 88.55 | 4495300.0 |
| 2002-11-12 10:00:00 | SPY | ETF | 88.5 | 89.0 | 88.37 | 89.0 | 3829800.0 |
| 2002-11-12 10:30:00 | SPY | ETF | 89.0 | 89.36 | 88.93 | 89.18 | 3534300.0 |
| 2002-11-12 11:00:00 | SPY | ETF | 89.18 | 89.27 | 88.99 | 89.15 | 1564500.0 |
| 2002-11-12 11:30:00 | SPY | ETF | 89.12 | 89.41 | 89.05 | 89.29 | 2100600.0 |
| 2002-11-12 12:00:00 | SPY | ETF | 89.29 | 89.36 | 89.15 | 89.28 | 1016300.0 |
| 2002-11-12 12:30:00 | SPY | ETF | 89.26 | 89.59 | 89.24 | 89.5 | 1275400.0 |
| 2002-11-12 13:00:00 | SPY | ETF | 89.54 | 89.73 | 89.41 | 89.41 | 1919100.0 |
| 2002-11-12 13:30:00 | SPY | ETF | 89.42 | 89.5 | 89.19 | 89.41 | 1508500.0 |
| 2002-11-12 14:00:00 | SPY | ETF | 89.4 | 89.81 | 89.38 | 89.77 | 1929500.0 |
| 2002-11-12 14:30:00 | SPY | ETF | 89.74 | 89.91 | 89.37 | 89.41 | 1647200.0 |
| 2002-11-12 15:00:00 | SPY | ETF | 89.44 | 89.45 | 88.4 | 88.57 | 5269200.0 |
| 2002-11-12 15:30:00 | SPY | ETF | 88.58 | 88.82 | 88.4 | 88.75 | 4627300.0 |
| 2002-11-12 16:00:00 | SPY | ETF | 88.68 | 89.02 | 88.68 | 88.8 | 1306600.0 |
| 2002-11-12 16:30:00 | SPY | ETF | 88.88 | 88.99 | 88.85 | 88.9 | 16100.0 |
| 2002-11-12 17:00:00 | SPY | ETF | 88.91 | 88.91 | 88.78 | 88.8 | 47500.0 |
| 2002-11-12 17:30:00 | SPY | ETF | 88.86 | 88.87 | 88.68 | 88.71 | 7200.0 |
| 2002-11-12 18:00:00 | SPY | ETF | 88.68 | 88.69 | 88.54 | 88.58 | 18900.0 |
| 2002-11-12 08:00:00 | QQQ | ETF | 24.41 | 24.49 | 24.4 | 24.46 | 11500.0 |
| 2002-11-12 08:30:00 | QQQ | ETF | 24.46 | 24.48 | 24.45 | 24.45 | 19300.0 |
| 2002-11-12 09:00:00 | QQQ | ETF | 24.43 | 24.45 | 24.38 | 24.42 | 14300.0 |
| 2002-11-12 09:30:00 | QQQ | ETF | 24.4 | 24.63 | 24.4 | 24.47 | 10906700.0 |
| 2002-11-12 10:00:00 | QQQ | ETF | 24.47 | 24.81 | 24.45 | 24.79 | 8853900.0 |
| 2002-11-12 10:30:00 | QQQ | ETF | 24.79 | 25.02 | 24.75 | 24.96 | 9250600.0 |
| 2002-11-12 11:00:00 | QQQ | ETF | 24.96 | 25.03 | 24.87 | 24.89 | 4669800.0 |
| 2002-11-12 11:30:00 | QQQ | ETF | 24.89 | 25.08 | 24.85 | 25.05 | 3426200.0 |
| 2002-11-12 12:00:00 | QQQ | ETF | 25.04 | 25.08 | 24.95 | 25.0 | 3176400.0 |
| 2002-11-12 12:30:00 | QQQ | ETF | 25.0 | 25.16 | 24.99 | 25.13 | 3174800.0 |
| 2002-11-12 13:00:00 | QQQ | ETF | 25.12 | 25.21 | 25.04 | 25.08 | 3772300.0 |
| 2002-11-12 13:30:00 | QQQ | ETF | 25.05 | 25.14 | 25.0 | 25.12 | 2772900.0 |
| 2002-11-12 14:00:00 | QQQ | ETF | 25.12 | 25.34 | 25.09 | 25.3 | 4713700.0 |
| 2002-11-12 14:30:00 | QQQ | ETF | 25.31 | 25.4 | 25.21 | 25.21 | 6183000.0 |
| 2002-11-12 15:00:00 | QQQ | ETF | 25.23 | 25.24 | 24.86 | 24.94 | 9584500.0 |
| 2002-11-12 15:30:00 | QQQ | ETF | 24.92 | 25.03 | 24.81 | 24.94 | 10278500.0 |
| 2002-11-12 16:00:00 | QQQ | ETF | 24.93 | 25.0 | 24.91 | 24.94 | 1462400.0 |
| 2002-11-12 16:30:00 | QQQ | ETF | 24.95 | 24.97 | 24.88 | 24.89 | 1877700.0 |
| 2002-11-12 17:00:00 | QQQ | ETF | 24.89 | 24.9 | 24.85 | 24.88 | 84800.0 |
| 2002-11-12 17:30:00 | QQQ | ETF | 24.87 | 24.9 | 24.82 | 24.83 | 116500.0 |
| 2002-11-12 18:00:00 | QQQ | ETF | 24.83 | 24.84 | 24.8 | 24.84 | 90600.0 |
| 2002-11-12 18:30:00 | QQQ | ETF | 24.84 | 24.84 | 24.82 | 24.82 | 3200.0 |
| 2002-11-12 19:00:00 | QQQ | ETF | 24.82 | 24.84 | 24.81 | 24.84 | 3000.0 |
| 2002-11-12 19:30:00 | QQQ | ETF | 24.83 | 24.84 | 24.83 | 24.84 | 2000.0 |
| 2002-11-12 09:30:00 | IWM | ETF | 37.175 | 37.18 | 37.025 | 37.125 | 334200.0 |
| 2002-11-12 10:00:00 | IWM | ETF | 37.075 | 37.35 | 37.075 | 37.35 | 318600.0 |
| 2002-11-12 10:30:00 | IWM | ETF | 37.35 | 37.5 | 37.345 | 37.42 | 157800.0 |
| 2002-11-12 11:00:00 | IWM | ETF | 37.45 | 37.47 | 37.35 | 37.37 | 77200.0 |
| 2002-11-12 11:30:00 | IWM | ETF | 37.38 | 37.43 | 37.375 | 37.39 | 49600.0 |
> showing 50 of 648 rows — these rows as CSV