PREVIEW / etf_30min / 2002-10-15
file: by_date/etf_30min/2002/2002-10-15.parquet size: 22 KB rows: 646
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-10-15 08:00:00 | SPY | ETF | 86.33 | 87.0 | 86.33 | 86.75 | 13900.0 |
| 2002-10-15 08:30:00 | SPY | ETF | 86.77 | 86.95 | 86.75 | 86.95 | 7100.0 |
| 2002-10-15 09:00:00 | SPY | ETF | 86.87 | 87.19 | 86.87 | 87.01 | 10700.0 |
| 2002-10-15 09:30:00 | SPY | ETF | 86.99 | 87.62 | 86.85 | 87.34 | 11869400.0 |
| 2002-10-15 10:00:00 | SPY | ETF | 87.32 | 87.67 | 86.95 | 87.2 | 7693600.0 |
| 2002-10-15 10:30:00 | SPY | ETF | 87.19 | 87.63 | 87.04 | 87.25 | 3474400.0 |
| 2002-10-15 11:00:00 | SPY | ETF | 87.25 | 87.7 | 87.08 | 87.42 | 4471800.0 |
| 2002-10-15 11:30:00 | SPY | ETF | 87.42 | 87.7 | 87.33 | 87.49 | 2442300.0 |
| 2002-10-15 12:00:00 | SPY | ETF | 87.5 | 87.74 | 87.42 | 87.57 | 1963000.0 |
| 2002-10-15 12:30:00 | SPY | ETF | 87.54 | 87.9 | 87.44 | 87.84 | 2115000.0 |
| 2002-10-15 13:00:00 | SPY | ETF | 87.85 | 88.1 | 87.79 | 87.86 | 3192300.0 |
| 2002-10-15 13:30:00 | SPY | ETF | 87.86 | 88.0 | 87.59 | 87.68 | 2527200.0 |
| 2002-10-15 14:00:00 | SPY | ETF | 87.71 | 87.92 | 87.52 | 87.72 | 2842500.0 |
| 2002-10-15 14:30:00 | SPY | ETF | 87.73 | 88.19 | 87.55 | 87.64 | 5353300.0 |
| 2002-10-15 15:00:00 | SPY | ETF | 87.63 | 88.31 | 87.51 | 87.66 | 8989100.0 |
| 2002-10-15 15:30:00 | SPY | ETF | 87.73 | 88.5 | 87.59 | 88.42 | 6794700.0 |
| 2002-10-15 16:00:00 | SPY | ETF | 88.4 | 88.75 | 87.5 | 88.64 | 6522700.0 |
| 2002-10-15 16:30:00 | SPY | ETF | 87.65 | 88.0 | 87.35 | 87.55 | 3539000.0 |
| 2002-10-15 17:00:00 | SPY | ETF | 87.57 | 88.66 | 87.24 | 87.5 | 1089700.0 |
| 2002-10-15 17:30:00 | SPY | ETF | 87.52 | 87.59 | 87.45 | 87.47 | 206600.0 |
| 2002-10-15 18:00:00 | SPY | ETF | 87.48 | 87.6 | 87.45 | 87.57 | 66600.0 |
| 2002-10-15 18:30:00 | SPY | ETF | 87.64 | 87.64 | 87.64 | 87.64 | 200.0 |
| 2002-10-15 19:00:00 | SPY | ETF | 87.8 | 87.8 | 87.8 | 87.8 | 100.0 |
| 2002-10-15 08:00:00 | QQQ | ETF | 23.01 | 23.28 | 23.01 | 23.24 | 41400.0 |
| 2002-10-15 08:30:00 | QQQ | ETF | 23.27 | 23.37 | 23.23 | 23.35 | 51800.0 |
| 2002-10-15 09:00:00 | QQQ | ETF | 23.35 | 23.42 | 23.32 | 23.41 | 147100.0 |
| 2002-10-15 09:30:00 | QQQ | ETF | 23.44 | 23.54 | 23.26 | 23.35 | 28327400.0 |
| 2002-10-15 10:00:00 | QQQ | ETF | 23.35 | 23.42 | 23.18 | 23.32 | 12982100.0 |
| 2002-10-15 10:30:00 | QQQ | ETF | 23.32 | 23.45 | 23.27 | 23.32 | 7268600.0 |
| 2002-10-15 11:00:00 | QQQ | ETF | 23.33 | 23.46 | 23.26 | 23.36 | 6070600.0 |
| 2002-10-15 11:30:00 | QQQ | ETF | 23.33 | 23.39 | 23.3 | 23.33 | 4166100.0 |
| 2002-10-15 12:00:00 | QQQ | ETF | 23.31 | 23.43 | 23.3 | 23.38 | 3310100.0 |
| 2002-10-15 12:30:00 | QQQ | ETF | 23.37 | 23.46 | 23.35 | 23.45 | 3535400.0 |
| 2002-10-15 13:00:00 | QQQ | ETF | 23.45 | 23.54 | 23.42 | 23.44 | 5896400.0 |
| 2002-10-15 13:30:00 | QQQ | ETF | 23.44 | 23.45 | 23.32 | 23.38 | 3702200.0 |
| 2002-10-15 14:00:00 | QQQ | ETF | 23.38 | 23.42 | 23.23 | 23.3 | 4841700.0 |
| 2002-10-15 14:30:00 | QQQ | ETF | 23.3 | 23.48 | 23.27 | 23.33 | 4944500.0 |
| 2002-10-15 15:00:00 | QQQ | ETF | 23.28 | 23.47 | 23.24 | 23.36 | 6975800.0 |
| 2002-10-15 15:30:00 | QQQ | ETF | 23.33 | 23.59 | 23.31 | 23.58 | 10489000.0 |
| 2002-10-15 16:00:00 | QQQ | ETF | 23.59 | 23.63 | 22.75 | 22.8 | 7554800.0 |
| 2002-10-15 16:30:00 | QQQ | ETF | 22.82 | 23.56 | 22.61 | 22.86 | 2906300.0 |
| 2002-10-15 17:00:00 | QQQ | ETF | 22.85 | 22.91 | 22.79 | 22.9 | 1484600.0 |
| 2002-10-15 17:30:00 | QQQ | ETF | 22.91 | 23.63 | 22.86 | 22.92 | 2088700.0 |
| 2002-10-15 18:00:00 | QQQ | ETF | 22.9 | 22.95 | 22.8 | 22.84 | 115900.0 |
| 2002-10-15 18:30:00 | QQQ | ETF | 22.81 | 22.89 | 22.81 | 22.89 | 1500.0 |
| 2002-10-15 19:00:00 | QQQ | ETF | 22.89 | 22.92 | 22.89 | 22.92 | 1300.0 |
| 2002-10-15 19:30:00 | QQQ | ETF | 22.9 | 22.91 | 22.9 | 22.91 | 2100.0 |
| 2002-10-15 09:00:00 | IWM | ETF | 35.32 | 35.32 | 35.32 | 35.32 | 1000.0 |
| 2002-10-15 09:30:00 | IWM | ETF | 35.38 | 35.75 | 35.215 | 35.5 | 924000.0 |
| 2002-10-15 10:00:00 | IWM | ETF | 35.585 | 35.725 | 35.585 | 35.645 | 471600.0 |
> showing 50 of 646 rows — these rows as CSV