PREVIEW / etf_30min / 2003-01-23
file: by_date/etf_30min/2003/2003-01-23.parquet size: 22 KB rows: 649
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-23 08:00:00 | SPY | ETF | 88.7 | 88.78 | 88.66 | 88.78 | 19200.0 |
| 2003-01-23 08:30:00 | SPY | ETF | 88.75 | 88.83 | 88.74 | 88.75 | 60400.0 |
| 2003-01-23 09:00:00 | SPY | ETF | 88.75 | 88.9 | 88.75 | 88.82 | 33000.0 |
| 2003-01-23 09:30:00 | SPY | ETF | 88.75 | 88.97 | 88.49 | 88.62 | 4917600.0 |
| 2003-01-23 10:00:00 | SPY | ETF | 88.6 | 88.79 | 88.05 | 88.11 | 4188700.0 |
| 2003-01-23 10:30:00 | SPY | ETF | 88.11 | 88.51 | 87.95 | 88.5 | 3961900.0 |
| 2003-01-23 11:00:00 | SPY | ETF | 88.5 | 88.5 | 88.17 | 88.24 | 1604900.0 |
| 2003-01-23 11:30:00 | SPY | ETF | 88.22 | 88.37 | 88.0 | 88.35 | 2414600.0 |
| 2003-01-23 12:00:00 | SPY | ETF | 88.37 | 88.51 | 88.12 | 88.24 | 2715300.0 |
| 2003-01-23 12:30:00 | SPY | ETF | 88.25 | 88.64 | 88.08 | 88.48 | 2999100.0 |
| 2003-01-23 13:00:00 | SPY | ETF | 88.48 | 88.81 | 88.38 | 88.62 | 3009300.0 |
| 2003-01-23 13:30:00 | SPY | ETF | 88.6 | 88.92 | 88.55 | 88.8 | 1956100.0 |
| 2003-01-23 14:00:00 | SPY | ETF | 88.8 | 88.92 | 88.56 | 88.6 | 2104300.0 |
| 2003-01-23 14:30:00 | SPY | ETF | 88.6 | 89.02 | 88.55 | 88.83 | 2384700.0 |
| 2003-01-23 15:00:00 | SPY | ETF | 88.86 | 89.22 | 88.83 | 89.17 | 2715200.0 |
| 2003-01-23 15:30:00 | SPY | ETF | 89.21 | 89.38 | 89.0 | 89.08 | 5198200.0 |
| 2003-01-23 16:00:00 | SPY | ETF | 89.04 | 89.09 | 88.67 | 88.85 | 13141300.0 |
| 2003-01-23 16:30:00 | SPY | ETF | 88.85 | 89.05 | 88.7 | 88.8 | 248100.0 |
| 2003-01-23 17:00:00 | SPY | ETF | 88.8 | 88.85 | 88.76 | 88.8 | 30800.0 |
| 2003-01-23 17:30:00 | SPY | ETF | 88.77 | 88.9 | 88.77 | 88.88 | 144100.0 |
| 2003-01-23 18:00:00 | SPY | ETF | 88.89 | 88.9 | 88.83 | 88.83 | 1500.0 |
| 2003-01-23 18:30:00 | SPY | ETF | 88.8 | 88.9 | 88.8 | 88.9 | 300.0 |
| 2003-01-23 19:30:00 | SPY | ETF | 88.9 | 88.9 | 88.9 | 88.9 | 900.0 |
| 2003-01-23 08:00:00 | QQQ | ETF | 25.37 | 25.44 | 25.35 | 25.44 | 83400.0 |
| 2003-01-23 08:30:00 | QQQ | ETF | 25.42 | 25.44 | 25.39 | 25.41 | 57900.0 |
| 2003-01-23 09:00:00 | QQQ | ETF | 25.4 | 25.44 | 25.4 | 25.4 | 98800.0 |
| 2003-01-23 09:30:00 | QQQ | ETF | 25.4 | 25.63 | 25.36 | 25.47 | 11534400.0 |
| 2003-01-23 10:00:00 | QQQ | ETF | 25.49 | 25.55 | 25.14 | 25.17 | 11970400.0 |
| 2003-01-23 10:30:00 | QQQ | ETF | 25.16 | 25.36 | 25.11 | 25.35 | 5084800.0 |
| 2003-01-23 11:00:00 | QQQ | ETF | 25.35 | 25.37 | 25.2 | 25.23 | 3277600.0 |
| 2003-01-23 11:30:00 | QQQ | ETF | 25.24 | 25.34 | 25.13 | 25.3 | 2596600.0 |
| 2003-01-23 12:00:00 | QQQ | ETF | 25.3 | 25.39 | 25.27 | 25.29 | 2252600.0 |
| 2003-01-23 12:30:00 | QQQ | ETF | 25.3 | 25.48 | 25.26 | 25.41 | 2759100.0 |
| 2003-01-23 13:00:00 | QQQ | ETF | 25.41 | 25.48 | 25.35 | 25.4 | 2424900.0 |
| 2003-01-23 13:30:00 | QQQ | ETF | 25.41 | 25.59 | 25.37 | 25.52 | 3947500.0 |
| 2003-01-23 14:00:00 | QQQ | ETF | 25.52 | 25.57 | 25.4 | 25.41 | 4217200.0 |
| 2003-01-23 14:30:00 | QQQ | ETF | 25.41 | 25.59 | 25.39 | 25.54 | 3513600.0 |
| 2003-01-23 15:00:00 | QQQ | ETF | 25.54 | 25.76 | 25.52 | 25.76 | 7078400.0 |
| 2003-01-23 15:30:00 | QQQ | ETF | 25.75 | 25.84 | 25.65 | 25.66 | 8466500.0 |
| 2003-01-23 16:00:00 | QQQ | ETF | 25.65 | 25.69 | 25.45 | 25.5 | 3225200.0 |
| 2003-01-23 16:30:00 | QQQ | ETF | 25.47 | 25.67 | 25.45 | 25.49 | 1079000.0 |
| 2003-01-23 17:00:00 | QQQ | ETF | 25.49 | 25.6 | 25.46 | 25.52 | 621000.0 |
| 2003-01-23 17:30:00 | QQQ | ETF | 25.51 | 25.54 | 25.49 | 25.52 | 115100.0 |
| 2003-01-23 18:00:00 | QQQ | ETF | 25.55 | 25.55 | 25.51 | 25.52 | 18600.0 |
| 2003-01-23 18:30:00 | QQQ | ETF | 25.52 | 25.57 | 25.5 | 25.57 | 10500.0 |
| 2003-01-23 19:00:00 | QQQ | ETF | 25.55 | 25.57 | 25.55 | 25.56 | 3300.0 |
| 2003-01-23 19:30:00 | QQQ | ETF | 25.55 | 25.57 | 25.52 | 25.53 | 8600.0 |
| 2003-01-23 08:30:00 | IWM | ETF | 38.03 | 38.03 | 38.03 | 38.03 | 200.0 |
| 2003-01-23 09:30:00 | IWM | ETF | 37.975 | 38.17 | 37.975 | 38.0 | 169600.0 |
| 2003-01-23 10:00:00 | IWM | ETF | 38.075 | 38.1 | 37.79 | 37.865 | 168000.0 |
> showing 50 of 649 rows — these rows as CSV