PREVIEW / etf_30min / 2002-04-25
file: by_date/etf_30min/2002/2002-04-25.parquet size: 18 KB rows: 487
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-04-25 09:30:00 | SPY | ETF | 109.21 | 109.31 | 108.76 | 108.95 | 2935500.0 |
| 2002-04-25 10:00:00 | SPY | ETF | 108.95 | 109.61 | 108.72 | 109.53 | 2688400.0 |
| 2002-04-25 10:30:00 | SPY | ETF | 109.51 | 109.74 | 109.31 | 109.53 | 1613000.0 |
| 2002-04-25 11:00:00 | SPY | ETF | 109.55 | 109.65 | 109.3 | 109.55 | 1336600.0 |
| 2002-04-25 11:30:00 | SPY | ETF | 109.58 | 109.66 | 109.0 | 109.42 | 5133000.0 |
| 2002-04-25 12:00:00 | SPY | ETF | 109.44 | 109.5 | 109.16 | 109.23 | 1378400.0 |
| 2002-04-25 12:30:00 | SPY | ETF | 109.23 | 109.25 | 109.05 | 109.17 | 1037000.0 |
| 2002-04-25 13:00:00 | SPY | ETF | 109.17 | 109.57 | 109.17 | 109.48 | 780900.0 |
| 2002-04-25 13:30:00 | SPY | ETF | 109.5 | 109.68 | 109.45 | 109.45 | 925200.0 |
| 2002-04-25 14:00:00 | SPY | ETF | 109.49 | 109.62 | 109.24 | 109.36 | 584700.0 |
| 2002-04-25 14:30:00 | SPY | ETF | 109.36 | 109.55 | 109.15 | 109.3 | 1087100.0 |
| 2002-04-25 15:00:00 | SPY | ETF | 109.3 | 109.4 | 108.85 | 109.27 | 1275000.0 |
| 2002-04-25 15:30:00 | SPY | ETF | 109.25 | 109.64 | 109.17 | 109.44 | 2232700.0 |
| 2002-04-25 16:00:00 | SPY | ETF | 109.43 | 109.66 | 109.38 | 109.51 | 1776800.0 |
| 2002-04-25 16:30:00 | SPY | ETF | 109.45 | 109.51 | 109.44 | 109.5 | 8100.0 |
| 2002-04-25 17:30:00 | SPY | ETF | 109.67 | 109.67 | 109.59 | 109.62 | 3000.0 |
| 2002-04-25 18:00:00 | SPY | ETF | 109.62 | 109.78 | 109.62 | 109.78 | 2400.0 |
| 2002-04-25 09:30:00 | QQQ | ETF | 32.3 | 32.48 | 32.06 | 32.2 | 16290000.0 |
| 2002-04-25 10:00:00 | QQQ | ETF | 32.18 | 32.62 | 32.03 | 32.56 | 13537900.0 |
| 2002-04-25 10:30:00 | QQQ | ETF | 32.53 | 32.73 | 32.35 | 32.43 | 9304800.0 |
| 2002-04-25 11:00:00 | QQQ | ETF | 32.42 | 32.45 | 32.24 | 32.42 | 4915500.0 |
| 2002-04-25 11:30:00 | QQQ | ETF | 32.42 | 32.47 | 32.0 | 32.37 | 8488400.0 |
| 2002-04-25 12:00:00 | QQQ | ETF | 32.37 | 32.45 | 32.2 | 32.23 | 2743900.0 |
| 2002-04-25 12:30:00 | QQQ | ETF | 32.24 | 32.32 | 32.15 | 32.28 | 1954100.0 |
| 2002-04-25 13:00:00 | QQQ | ETF | 32.28 | 32.58 | 32.25 | 32.53 | 6136800.0 |
| 2002-04-25 13:30:00 | QQQ | ETF | 32.51 | 32.67 | 32.47 | 32.5 | 2902500.0 |
| 2002-04-25 14:00:00 | QQQ | ETF | 32.5 | 32.62 | 32.28 | 32.32 | 4116000.0 |
| 2002-04-25 14:30:00 | QQQ | ETF | 32.33 | 32.44 | 32.15 | 32.28 | 4622900.0 |
| 2002-04-25 15:00:00 | QQQ | ETF | 32.27 | 32.35 | 32.04 | 32.31 | 8324800.0 |
| 2002-04-25 15:30:00 | QQQ | ETF | 32.3 | 32.65 | 32.25 | 32.44 | 10919000.0 |
| 2002-04-25 16:00:00 | QQQ | ETF | 32.44 | 32.5 | 32.4 | 32.42 | 3241300.0 |
| 2002-04-25 16:30:00 | QQQ | ETF | 32.43 | 32.65 | 32.17 | 32.44 | 780600.0 |
| 2002-04-25 17:00:00 | QQQ | ETF | 32.44 | 32.47 | 32.42 | 32.44 | 114800.0 |
| 2002-04-25 17:30:00 | QQQ | ETF | 32.44 | 32.51 | 32.43 | 32.51 | 17000.0 |
| 2002-04-25 18:00:00 | QQQ | ETF | 32.46 | 32.54 | 32.44 | 32.54 | 28300.0 |
| 2002-04-25 09:30:00 | IWM | ETF | 50.3 | 50.44 | 50.105 | 50.115 | 168800.0 |
| 2002-04-25 10:00:00 | IWM | ETF | 50.12 | 50.52 | 50.105 | 50.5 | 208000.0 |
| 2002-04-25 10:30:00 | IWM | ETF | 50.515 | 50.645 | 50.495 | 50.6 | 164600.0 |
| 2002-04-25 11:00:00 | IWM | ETF | 50.54 | 50.55 | 50.44 | 50.525 | 111000.0 |
| 2002-04-25 11:30:00 | IWM | ETF | 50.525 | 50.535 | 50.38 | 50.445 | 56000.0 |
| 2002-04-25 12:00:00 | IWM | ETF | 50.38 | 50.5 | 50.38 | 50.435 | 18000.0 |
| 2002-04-25 12:30:00 | IWM | ETF | 50.385 | 50.465 | 50.35 | 50.455 | 20800.0 |
| 2002-04-25 13:00:00 | IWM | ETF | 50.455 | 50.575 | 50.455 | 50.575 | 27400.0 |
| 2002-04-25 13:30:00 | IWM | ETF | 50.58 | 50.69 | 50.58 | 50.65 | 248600.0 |
| 2002-04-25 14:00:00 | IWM | ETF | 50.65 | 50.685 | 50.575 | 50.6 | 25600.0 |
| 2002-04-25 14:30:00 | IWM | ETF | 50.555 | 50.575 | 50.48 | 50.54 | 143400.0 |
| 2002-04-25 15:00:00 | IWM | ETF | 50.5 | 50.525 | 50.425 | 50.51 | 33800.0 |
| 2002-04-25 15:30:00 | IWM | ETF | 50.525 | 50.72 | 50.49 | 50.72 | 90800.0 |
| 2002-04-25 16:00:00 | IWM | ETF | 50.725 | 50.77 | 50.655 | 50.655 | 15600.0 |
| 2002-04-25 09:30:00 | DIA | ETF | 100.0 | 100.1 | 99.3 | 99.5 | 876500.0 |
> showing 50 of 487 rows — these rows as CSV