PREVIEW / etf_30min / 2002-02-25
file: by_date/etf_30min/2002/2002-02-25.parquet size: 17 KB rows: 461
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-02-25 09:30:00 | SPY | ETF | 109.74 | 110.39 | 109.7 | 110.29 | 2678200.0 |
| 2002-02-25 10:00:00 | SPY | ETF | 110.29 | 110.61 | 110.15 | 110.31 | 1669600.0 |
| 2002-02-25 10:30:00 | SPY | ETF | 110.3 | 110.49 | 110.1 | 110.26 | 707000.0 |
| 2002-02-25 11:00:00 | SPY | ETF | 110.22 | 110.61 | 110.2 | 110.44 | 1203400.0 |
| 2002-02-25 11:30:00 | SPY | ETF | 110.46 | 110.5 | 110.25 | 110.45 | 778400.0 |
| 2002-02-25 12:00:00 | SPY | ETF | 110.46 | 110.74 | 110.4 | 110.4 | 858300.0 |
| 2002-02-25 12:30:00 | SPY | ETF | 110.4 | 110.54 | 110.3 | 110.46 | 530800.0 |
| 2002-02-25 13:00:00 | SPY | ETF | 110.42 | 110.73 | 110.35 | 110.73 | 368400.0 |
| 2002-02-25 13:30:00 | SPY | ETF | 110.72 | 110.88 | 110.57 | 110.7 | 569700.0 |
| 2002-02-25 14:00:00 | SPY | ETF | 110.72 | 110.89 | 110.65 | 110.79 | 585200.0 |
| 2002-02-25 14:30:00 | SPY | ETF | 110.77 | 111.45 | 110.77 | 111.37 | 1475600.0 |
| 2002-02-25 15:00:00 | SPY | ETF | 111.38 | 111.81 | 111.36 | 111.63 | 1232500.0 |
| 2002-02-25 15:30:00 | SPY | ETF | 111.63 | 111.7 | 111.35 | 111.5 | 2271100.0 |
| 2002-02-25 16:00:00 | SPY | ETF | 111.53 | 111.7 | 111.31 | 111.43 | 1076700.0 |
| 2002-02-25 16:30:00 | SPY | ETF | 111.32 | 111.44 | 111.32 | 111.44 | 3800.0 |
| 2002-02-25 17:00:00 | SPY | ETF | 111.43 | 111.44 | 111.42 | 111.44 | 10200.0 |
| 2002-02-25 18:00:00 | SPY | ETF | 111.44 | 111.44 | 111.44 | 111.44 | 400.0 |
| 2002-02-25 09:30:00 | QQQ | ETF | 34.0 | 34.32 | 33.95 | 34.17 | 13318800.0 |
| 2002-02-25 10:00:00 | QQQ | ETF | 34.22 | 34.35 | 34.03 | 34.12 | 7300000.0 |
| 2002-02-25 10:30:00 | QQQ | ETF | 34.12 | 34.3 | 33.96 | 34.15 | 4258900.0 |
| 2002-02-25 11:00:00 | QQQ | ETF | 34.15 | 34.47 | 34.12 | 34.4 | 5989100.0 |
| 2002-02-25 11:30:00 | QQQ | ETF | 34.4 | 34.42 | 34.22 | 34.38 | 3798800.0 |
| 2002-02-25 12:00:00 | QQQ | ETF | 34.4 | 34.56 | 34.32 | 34.32 | 5395500.0 |
| 2002-02-25 12:30:00 | QQQ | ETF | 34.32 | 34.46 | 34.22 | 34.44 | 5268300.0 |
| 2002-02-25 13:00:00 | QQQ | ETF | 34.45 | 34.67 | 34.4 | 34.66 | 3891200.0 |
| 2002-02-25 13:30:00 | QQQ | ETF | 34.64 | 34.76 | 34.58 | 34.7 | 4597700.0 |
| 2002-02-25 14:00:00 | QQQ | ETF | 34.72 | 34.82 | 34.63 | 34.75 | 3632200.0 |
| 2002-02-25 14:30:00 | QQQ | ETF | 34.75 | 35.14 | 34.74 | 35.08 | 10423800.0 |
| 2002-02-25 15:00:00 | QQQ | ETF | 35.08 | 35.24 | 34.98 | 35.11 | 8355000.0 |
| 2002-02-25 15:30:00 | QQQ | ETF | 35.11 | 35.19 | 34.96 | 35.01 | 8549100.0 |
| 2002-02-25 16:00:00 | QQQ | ETF | 35.04 | 35.08 | 34.93 | 35.03 | 1605300.0 |
| 2002-02-25 16:30:00 | QQQ | ETF | 35.03 | 35.08 | 34.98 | 35.0 | 62200.0 |
| 2002-02-25 17:00:00 | QQQ | ETF | 35.0 | 35.02 | 34.98 | 35.01 | 22400.0 |
| 2002-02-25 17:30:00 | QQQ | ETF | 35.05 | 35.05 | 35.0 | 35.04 | 29600.0 |
| 2002-02-25 18:00:00 | QQQ | ETF | 35.05 | 35.1 | 35.04 | 35.07 | 9000.0 |
| 2002-02-25 09:30:00 | IWM | ETF | 46.375 | 46.545 | 46.35 | 46.495 | 29400.0 |
| 2002-02-25 10:00:00 | IWM | ETF | 46.39 | 46.465 | 46.25 | 46.27 | 128800.0 |
| 2002-02-25 10:30:00 | IWM | ETF | 46.27 | 46.325 | 46.175 | 46.22 | 76800.0 |
| 2002-02-25 11:00:00 | IWM | ETF | 46.305 | 46.375 | 46.22 | 46.375 | 18600.0 |
| 2002-02-25 11:30:00 | IWM | ETF | 46.375 | 46.375 | 46.26 | 46.26 | 6200.0 |
| 2002-02-25 12:00:00 | IWM | ETF | 46.34 | 46.375 | 46.28 | 46.28 | 34000.0 |
| 2002-02-25 12:30:00 | IWM | ETF | 46.26 | 46.325 | 46.22 | 46.25 | 15400.0 |
| 2002-02-25 13:00:00 | IWM | ETF | 46.3 | 46.375 | 46.285 | 46.375 | 14400.0 |
| 2002-02-25 13:30:00 | IWM | ETF | 46.375 | 46.4 | 46.375 | 46.39 | 39400.0 |
| 2002-02-25 14:00:00 | IWM | ETF | 46.36 | 46.39 | 46.335 | 46.375 | 5400.0 |
| 2002-02-25 14:30:00 | IWM | ETF | 46.375 | 46.62 | 46.35 | 46.525 | 105600.0 |
| 2002-02-25 15:00:00 | IWM | ETF | 46.55 | 46.605 | 46.49 | 46.49 | 125400.0 |
| 2002-02-25 15:30:00 | IWM | ETF | 46.575 | 46.59 | 46.45 | 46.59 | 109600.0 |
| 2002-02-25 16:00:00 | IWM | ETF | 46.5 | 46.665 | 46.5 | 46.665 | 16800.0 |
| 2002-02-25 09:30:00 | DIA | ETF | 100.06 | 100.75 | 99.98 | 100.62 | 2221300.0 |
> showing 50 of 461 rows — these rows as CSV