PREVIEW / etf_30min / 2002-03-01
file: by_date/etf_30min/2002/2002-03-01.parquet size: 18 KB rows: 471
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-03-01 09:30:00 | SPY | ETF | 111.72 | 111.9 | 111.51 | 111.68 | 2903500.0 |
| 2002-03-01 10:00:00 | SPY | ETF | 111.72 | 112.43 | 111.66 | 112.27 | 3653600.0 |
| 2002-03-01 10:30:00 | SPY | ETF | 112.22 | 112.62 | 112.1 | 112.43 | 1901000.0 |
| 2002-03-01 11:00:00 | SPY | ETF | 112.42 | 113.18 | 112.36 | 112.97 | 3071900.0 |
| 2002-03-01 11:30:00 | SPY | ETF | 112.97 | 113.01 | 112.73 | 112.8 | 1406800.0 |
| 2002-03-01 12:00:00 | SPY | ETF | 112.81 | 112.9 | 112.61 | 112.69 | 1107400.0 |
| 2002-03-01 12:30:00 | SPY | ETF | 112.75 | 112.96 | 112.68 | 112.82 | 1657200.0 |
| 2002-03-01 13:00:00 | SPY | ETF | 112.76 | 113.07 | 112.69 | 113.0 | 862900.0 |
| 2002-03-01 13:30:00 | SPY | ETF | 113.03 | 113.19 | 112.87 | 112.95 | 1283500.0 |
| 2002-03-01 14:00:00 | SPY | ETF | 112.96 | 113.08 | 112.77 | 112.93 | 776400.0 |
| 2002-03-01 14:30:00 | SPY | ETF | 112.9 | 113.18 | 112.81 | 113.01 | 746700.0 |
| 2002-03-01 15:00:00 | SPY | ETF | 113.03 | 113.15 | 112.86 | 112.98 | 1017900.0 |
| 2002-03-01 15:30:00 | SPY | ETF | 112.98 | 113.73 | 112.89 | 113.66 | 3621900.0 |
| 2002-03-01 16:00:00 | SPY | ETF | 113.66 | 113.87 | 113.52 | 113.85 | 1648200.0 |
| 2002-03-01 16:30:00 | SPY | ETF | 113.84 | 113.86 | 113.84 | 113.86 | 800.0 |
| 2002-03-01 17:00:00 | SPY | ETF | 113.74 | 113.74 | 113.57 | 113.57 | 6100.0 |
| 2002-03-01 17:30:00 | SPY | ETF | 113.57 | 113.7 | 113.3 | 113.5 | 7800.0 |
| 2002-03-01 18:00:00 | SPY | ETF | 113.43 | 113.44 | 113.35 | 113.35 | 11000.0 |
| 2002-03-01 09:30:00 | QQQ | ETF | 34.15 | 34.37 | 34.09 | 34.19 | 7595400.0 |
| 2002-03-01 10:00:00 | QQQ | ETF | 34.19 | 34.68 | 34.16 | 34.57 | 10916200.0 |
| 2002-03-01 10:30:00 | QQQ | ETF | 34.51 | 34.87 | 34.45 | 34.73 | 6596500.0 |
| 2002-03-01 11:00:00 | QQQ | ETF | 34.74 | 35.16 | 34.7 | 35.08 | 10564400.0 |
| 2002-03-01 11:30:00 | QQQ | ETF | 35.06 | 35.14 | 34.92 | 34.98 | 4722800.0 |
| 2002-03-01 12:00:00 | QQQ | ETF | 34.98 | 35.09 | 34.89 | 35.0 | 3003700.0 |
| 2002-03-01 12:30:00 | QQQ | ETF | 35.0 | 35.16 | 34.97 | 35.05 | 3442700.0 |
| 2002-03-01 13:00:00 | QQQ | ETF | 35.05 | 35.26 | 35.01 | 35.25 | 4121400.0 |
| 2002-03-01 13:30:00 | QQQ | ETF | 35.25 | 35.38 | 35.19 | 35.28 | 6432100.0 |
| 2002-03-01 14:00:00 | QQQ | ETF | 35.27 | 35.35 | 35.11 | 35.15 | 3862600.0 |
| 2002-03-01 14:30:00 | QQQ | ETF | 35.17 | 35.48 | 35.11 | 35.27 | 5542700.0 |
| 2002-03-01 15:00:00 | QQQ | ETF | 35.31 | 35.43 | 35.21 | 35.3 | 4787700.0 |
| 2002-03-01 15:30:00 | QQQ | ETF | 35.32 | 35.73 | 35.27 | 35.7 | 10850600.0 |
| 2002-03-01 16:00:00 | QQQ | ETF | 35.7 | 35.86 | 35.65 | 35.8 | 1950300.0 |
| 2002-03-01 16:30:00 | QQQ | ETF | 35.8 | 35.84 | 35.76 | 35.8 | 34400.0 |
| 2002-03-01 17:00:00 | QQQ | ETF | 35.81 | 35.84 | 35.4 | 35.4 | 301400.0 |
| 2002-03-01 17:30:00 | QQQ | ETF | 35.5 | 35.52 | 35.31 | 35.4 | 265100.0 |
| 2002-03-01 18:00:00 | QQQ | ETF | 35.4 | 35.43 | 35.26 | 35.3 | 110700.0 |
| 2002-03-01 09:30:00 | IWM | ETF | 46.825 | 46.845 | 46.65 | 46.72 | 60000.0 |
| 2002-03-01 10:00:00 | IWM | ETF | 46.665 | 46.9 | 46.665 | 46.85 | 120800.0 |
| 2002-03-01 10:30:00 | IWM | ETF | 46.88 | 47.0 | 46.765 | 47.0 | 137000.0 |
| 2002-03-01 11:00:00 | IWM | ETF | 46.98 | 47.22 | 46.92 | 47.2 | 110400.0 |
| 2002-03-01 11:30:00 | IWM | ETF | 47.12 | 47.205 | 47.07 | 47.07 | 32800.0 |
| 2002-03-01 12:00:00 | IWM | ETF | 47.1 | 47.13 | 47.04 | 47.04 | 29400.0 |
| 2002-03-01 12:30:00 | IWM | ETF | 47.05 | 47.2 | 47.05 | 47.19 | 38800.0 |
| 2002-03-01 13:00:00 | IWM | ETF | 47.19 | 47.21 | 47.13 | 47.21 | 47600.0 |
| 2002-03-01 13:30:00 | IWM | ETF | 47.22 | 47.35 | 47.2 | 47.26 | 27000.0 |
| 2002-03-01 14:00:00 | IWM | ETF | 47.32 | 47.34 | 47.22 | 47.28 | 13800.0 |
| 2002-03-01 14:30:00 | IWM | ETF | 47.21 | 47.3 | 47.21 | 47.215 | 10200.0 |
| 2002-03-01 15:00:00 | IWM | ETF | 47.28 | 47.29 | 47.215 | 47.23 | 86200.0 |
| 2002-03-01 15:30:00 | IWM | ETF | 47.26 | 47.52 | 47.24 | 47.52 | 145800.0 |
| 2002-03-01 16:00:00 | IWM | ETF | 47.55 | 47.75 | 47.51 | 47.75 | 43000.0 |
> showing 50 of 471 rows — these rows as CSV