PREVIEW / etf_30min / 2002-01-15
file: by_date/etf_30min/2002/2002-01-15.parquet size: 17 KB rows: 457
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-01-15 09:30:00 | SPY | ETF | 114.55 | 114.84 | 114.3 | 114.79 | 1952300.0 |
| 2002-01-15 10:00:00 | SPY | ETF | 114.82 | 115.22 | 114.82 | 115.03 | 1692500.0 |
| 2002-01-15 10:30:00 | SPY | ETF | 115.01 | 115.1 | 114.87 | 114.96 | 847900.0 |
| 2002-01-15 11:00:00 | SPY | ETF | 114.96 | 115.39 | 114.9 | 114.95 | 403400.0 |
| 2002-01-15 11:30:00 | SPY | ETF | 114.93 | 115.0 | 114.82 | 114.9 | 1865400.0 |
| 2002-01-15 12:00:00 | SPY | ETF | 114.94 | 114.95 | 114.78 | 114.78 | 483500.0 |
| 2002-01-15 12:30:00 | SPY | ETF | 114.8 | 114.81 | 114.65 | 114.81 | 610600.0 |
| 2002-01-15 13:00:00 | SPY | ETF | 114.8 | 114.87 | 114.58 | 114.59 | 213100.0 |
| 2002-01-15 13:30:00 | SPY | ETF | 114.58 | 114.6 | 114.06 | 114.11 | 987300.0 |
| 2002-01-15 14:00:00 | SPY | ETF | 114.08 | 114.27 | 113.9 | 114.27 | 1427700.0 |
| 2002-01-15 14:30:00 | SPY | ETF | 114.28 | 114.43 | 114.04 | 114.21 | 1047900.0 |
| 2002-01-15 15:00:00 | SPY | ETF | 114.17 | 114.62 | 114.17 | 114.58 | 677400.0 |
| 2002-01-15 15:30:00 | SPY | ETF | 114.58 | 115.04 | 114.47 | 114.88 | 2839700.0 |
| 2002-01-15 16:00:00 | SPY | ETF | 114.89 | 115.2 | 114.1 | 114.1 | 4366200.0 |
| 2002-01-15 16:30:00 | SPY | ETF | 114.6 | 114.99 | 114.05 | 114.63 | 282800.0 |
| 2002-01-15 17:00:00 | SPY | ETF | 114.64 | 114.7 | 114.35 | 114.63 | 65100.0 |
| 2002-01-15 17:30:00 | SPY | ETF | 114.68 | 114.7 | 114.41 | 114.6 | 35600.0 |
| 2002-01-15 18:00:00 | SPY | ETF | 114.68 | 114.68 | 114.68 | 114.68 | 1000.0 |
| 2002-01-15 09:30:00 | QQQ | ETF | 40.03 | 40.19 | 39.76 | 40.14 | 8499100.0 |
| 2002-01-15 10:00:00 | QQQ | ETF | 40.16 | 40.32 | 40.06 | 40.08 | 5514500.0 |
| 2002-01-15 10:30:00 | QQQ | ETF | 40.08 | 40.3 | 40.05 | 40.2 | 3694400.0 |
| 2002-01-15 11:00:00 | QQQ | ETF | 40.21 | 40.75 | 40.2 | 40.36 | 6680800.0 |
| 2002-01-15 11:30:00 | QQQ | ETF | 40.36 | 40.4 | 40.1 | 40.2 | 4006200.0 |
| 2002-01-15 12:00:00 | QQQ | ETF | 40.19 | 40.24 | 40.06 | 40.11 | 1824800.0 |
| 2002-01-15 12:30:00 | QQQ | ETF | 40.11 | 40.14 | 39.94 | 40.11 | 3359600.0 |
| 2002-01-15 13:00:00 | QQQ | ETF | 40.11 | 40.16 | 39.93 | 39.96 | 989100.0 |
| 2002-01-15 13:30:00 | QQQ | ETF | 39.95 | 39.98 | 39.62 | 39.64 | 4000700.0 |
| 2002-01-15 14:00:00 | QQQ | ETF | 39.66 | 39.82 | 39.56 | 39.8 | 6132800.0 |
| 2002-01-15 14:30:00 | QQQ | ETF | 39.79 | 39.92 | 39.64 | 39.78 | 3346900.0 |
| 2002-01-15 15:00:00 | QQQ | ETF | 39.77 | 40.03 | 39.71 | 39.98 | 4247100.0 |
| 2002-01-15 15:30:00 | QQQ | ETF | 40.0 | 40.19 | 39.89 | 40.13 | 8584000.0 |
| 2002-01-15 16:00:00 | QQQ | ETF | 40.14 | 40.55 | 39.5 | 39.75 | 3128700.0 |
| 2002-01-15 16:30:00 | QQQ | ETF | 39.74 | 39.87 | 39.53 | 39.67 | 1281900.0 |
| 2002-01-15 17:00:00 | QQQ | ETF | 39.66 | 39.75 | 39.63 | 39.73 | 227800.0 |
| 2002-01-15 17:30:00 | QQQ | ETF | 39.71 | 39.77 | 39.66 | 39.69 | 66600.0 |
| 2002-01-15 18:00:00 | QQQ | ETF | 39.68 | 39.75 | 39.6 | 39.6 | 34500.0 |
| 2002-01-15 09:30:00 | IWM | ETF | 48.095 | 48.125 | 47.935 | 48.11 | 39800.0 |
| 2002-01-15 10:00:00 | IWM | ETF | 48.125 | 48.24 | 48.125 | 48.135 | 99000.0 |
| 2002-01-15 10:30:00 | IWM | ETF | 48.19 | 48.19 | 48.075 | 48.135 | 398200.0 |
| 2002-01-15 11:00:00 | IWM | ETF | 48.045 | 48.165 | 48.045 | 48.14 | 31400.0 |
| 2002-01-15 11:30:00 | IWM | ETF | 48.055 | 48.13 | 48.0 | 48.0 | 152000.0 |
| 2002-01-15 12:00:00 | IWM | ETF | 48.065 | 48.065 | 47.96 | 48.0 | 13800.0 |
| 2002-01-15 12:30:00 | IWM | ETF | 48.0 | 48.0 | 47.92 | 47.92 | 26800.0 |
| 2002-01-15 13:00:00 | IWM | ETF | 47.93 | 47.995 | 47.925 | 47.975 | 19400.0 |
| 2002-01-15 13:30:00 | IWM | ETF | 47.925 | 47.975 | 47.75 | 47.75 | 106600.0 |
| 2002-01-15 14:00:00 | IWM | ETF | 47.75 | 47.83 | 47.73 | 47.735 | 28400.0 |
| 2002-01-15 14:30:00 | IWM | ETF | 47.76 | 47.87 | 47.735 | 47.765 | 25000.0 |
| 2002-01-15 15:00:00 | IWM | ETF | 47.765 | 47.94 | 47.765 | 47.94 | 61000.0 |
| 2002-01-15 15:30:00 | IWM | ETF | 47.925 | 48.24 | 47.925 | 48.24 | 137800.0 |
| 2002-01-15 16:00:00 | IWM | ETF | 48.24 | 48.3 | 48.225 | 48.275 | 30400.0 |
> showing 50 of 457 rows — these rows as CSV