PREVIEW / etf_30min / 2002-04-22
file: by_date/etf_30min/2002/2002-04-22.parquet size: 18 KB rows: 519
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-22 09:30:00 | SPY | ETF | 112.38 | 112.43 | 111.98 | 111.99 | 1905800.0 |
| 2002-04-22 10:00:00 | SPY | ETF | 112.0 | 112.08 | 111.57 | 111.72 | 1477200.0 |
| 2002-04-22 10:30:00 | SPY | ETF | 111.71 | 111.83 | 111.5 | 111.8 | 931300.0 |
| 2002-04-22 11:00:00 | SPY | ETF | 111.81 | 111.83 | 111.52 | 111.65 | 406900.0 |
| 2002-04-22 11:30:00 | SPY | ETF | 111.64 | 111.78 | 111.35 | 111.37 | 747900.0 |
| 2002-04-22 12:00:00 | SPY | ETF | 111.38 | 111.5 | 111.21 | 111.49 | 1081400.0 |
| 2002-04-22 12:30:00 | SPY | ETF | 111.5 | 111.52 | 111.21 | 111.26 | 886000.0 |
| 2002-04-22 13:00:00 | SPY | ETF | 111.25 | 111.52 | 111.21 | 111.48 | 512200.0 |
| 2002-04-22 13:30:00 | SPY | ETF | 111.48 | 111.51 | 111.1 | 111.11 | 639100.0 |
| 2002-04-22 14:00:00 | SPY | ETF | 111.12 | 111.22 | 110.92 | 111.2 | 839100.0 |
| 2002-04-22 14:30:00 | SPY | ETF | 111.2 | 111.26 | 110.88 | 111.0 | 1208500.0 |
| 2002-04-22 15:00:00 | SPY | ETF | 111.01 | 111.09 | 110.84 | 110.97 | 528400.0 |
| 2002-04-22 15:30:00 | SPY | ETF | 111.02 | 111.21 | 110.99 | 111.14 | 1114600.0 |
| 2002-04-22 16:00:00 | SPY | ETF | 111.14 | 111.22 | 111.0 | 111.12 | 690200.0 |
| 2002-04-22 16:30:00 | SPY | ETF | 111.0 | 111.0 | 111.0 | 111.0 | 200.0 |
| 2002-04-22 17:00:00 | SPY | ETF | 111.11 | 111.15 | 111.11 | 111.15 | 2600.0 |
| 2002-04-22 17:30:00 | SPY | ETF | 111.16 | 111.16 | 111.1 | 111.1 | 400.0 |
| 2002-04-22 18:00:00 | SPY | ETF | 111.06 | 111.16 | 111.06 | 111.1 | 1000.0 |
| 2002-04-22 09:30:00 | QQQ | ETF | 34.01 | 34.02 | 33.75 | 33.75 | 9741600.0 |
| 2002-04-22 10:00:00 | QQQ | ETF | 33.76 | 33.78 | 33.57 | 33.67 | 7437100.0 |
| 2002-04-22 10:30:00 | QQQ | ETF | 33.66 | 33.82 | 33.56 | 33.8 | 5623900.0 |
| 2002-04-22 11:00:00 | QQQ | ETF | 33.8 | 33.81 | 33.6 | 33.67 | 2264400.0 |
| 2002-04-22 11:30:00 | QQQ | ETF | 33.68 | 33.74 | 33.49 | 33.49 | 3561200.0 |
| 2002-04-22 12:00:00 | QQQ | ETF | 33.49 | 33.51 | 33.36 | 33.49 | 7719000.0 |
| 2002-04-22 12:30:00 | QQQ | ETF | 33.5 | 33.52 | 33.38 | 33.41 | 1856600.0 |
| 2002-04-22 13:00:00 | QQQ | ETF | 33.41 | 33.59 | 33.37 | 33.56 | 1874100.0 |
| 2002-04-22 13:30:00 | QQQ | ETF | 33.54 | 33.57 | 33.37 | 33.39 | 2190300.0 |
| 2002-04-22 14:00:00 | QQQ | ETF | 33.4 | 33.44 | 33.3 | 33.41 | 2358900.0 |
| 2002-04-22 14:30:00 | QQQ | ETF | 33.41 | 33.43 | 33.25 | 33.3 | 3206400.0 |
| 2002-04-22 15:00:00 | QQQ | ETF | 33.3 | 33.4 | 33.26 | 33.36 | 2967100.0 |
| 2002-04-22 15:30:00 | QQQ | ETF | 33.37 | 33.58 | 33.35 | 33.56 | 6814500.0 |
| 2002-04-22 16:00:00 | QQQ | ETF | 33.57 | 33.6 | 33.51 | 33.57 | 1240500.0 |
| 2002-04-22 16:30:00 | QQQ | ETF | 33.57 | 33.7 | 33.52 | 33.58 | 114500.0 |
| 2002-04-22 17:00:00 | QQQ | ETF | 33.56 | 33.58 | 33.54 | 33.58 | 54000.0 |
| 2002-04-22 17:30:00 | QQQ | ETF | 33.56 | 33.56 | 33.5 | 33.5 | 31600.0 |
| 2002-04-22 18:00:00 | QQQ | ETF | 33.53 | 33.57 | 33.5 | 33.55 | 26100.0 |
| 2002-04-22 09:30:00 | IWM | ETF | 51.4 | 51.445 | 51.04 | 51.04 | 392000.0 |
| 2002-04-22 10:00:00 | IWM | ETF | 51.055 | 51.11 | 50.755 | 50.9 | 323200.0 |
| 2002-04-22 10:30:00 | IWM | ETF | 50.9 | 50.96 | 50.84 | 50.96 | 52200.0 |
| 2002-04-22 11:00:00 | IWM | ETF | 50.97 | 50.97 | 50.875 | 50.92 | 164200.0 |
| 2002-04-22 11:30:00 | IWM | ETF | 50.93 | 50.93 | 50.845 | 50.89 | 78600.0 |
| 2002-04-22 12:00:00 | IWM | ETF | 50.89 | 50.92 | 50.765 | 50.795 | 33000.0 |
| 2002-04-22 12:30:00 | IWM | ETF | 50.87 | 50.95 | 50.805 | 50.9 | 72400.0 |
| 2002-04-22 13:00:00 | IWM | ETF | 50.88 | 50.905 | 50.835 | 50.885 | 8600.0 |
| 2002-04-22 13:30:00 | IWM | ETF | 50.975 | 50.995 | 50.855 | 50.94 | 18600.0 |
| 2002-04-22 14:00:00 | IWM | ETF | 50.9 | 50.91 | 50.805 | 50.89 | 14600.0 |
| 2002-04-22 14:30:00 | IWM | ETF | 50.825 | 50.89 | 50.8 | 50.805 | 41800.0 |
| 2002-04-22 15:00:00 | IWM | ETF | 50.795 | 50.865 | 50.785 | 50.825 | 31400.0 |
| 2002-04-22 15:30:00 | IWM | ETF | 50.845 | 50.89 | 50.775 | 50.825 | 145400.0 |
| 2002-04-22 16:00:00 | IWM | ETF | 50.825 | 50.825 | 50.755 | 50.77 | 104200.0 |
> showing 50 of 519 rows — these rows as CSV