PREVIEW / etf_30min / 2002-05-09
file: by_date/etf_30min/2002/2002-05-09.parquet size: 18 KB rows: 504
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-05-09 09:30:00 | SPY | ETF | 108.65 | 109.02 | 108.41 | 108.98 | 2602500.0 |
| 2002-05-09 10:00:00 | SPY | ETF | 108.93 | 109.0 | 108.2 | 108.28 | 1463100.0 |
| 2002-05-09 10:30:00 | SPY | ETF | 108.3 | 108.35 | 108.02 | 108.26 | 1352200.0 |
| 2002-05-09 11:00:00 | SPY | ETF | 108.29 | 108.48 | 108.07 | 108.32 | 488900.0 |
| 2002-05-09 11:30:00 | SPY | ETF | 108.32 | 108.46 | 108.23 | 108.44 | 279900.0 |
| 2002-05-09 12:00:00 | SPY | ETF | 108.43 | 108.44 | 107.62 | 108.04 | 4258600.0 |
| 2002-05-09 12:30:00 | SPY | ETF | 108.04 | 108.55 | 107.97 | 108.5 | 885100.0 |
| 2002-05-09 13:00:00 | SPY | ETF | 108.48 | 108.51 | 108.23 | 108.43 | 531500.0 |
| 2002-05-09 13:30:00 | SPY | ETF | 108.42 | 108.73 | 108.34 | 108.44 | 778400.0 |
| 2002-05-09 14:00:00 | SPY | ETF | 108.46 | 108.51 | 108.14 | 108.29 | 492200.0 |
| 2002-05-09 14:30:00 | SPY | ETF | 108.3 | 108.46 | 108.01 | 108.04 | 258700.0 |
| 2002-05-09 15:00:00 | SPY | ETF | 108.03 | 108.13 | 107.81 | 107.99 | 816300.0 |
| 2002-05-09 15:30:00 | SPY | ETF | 108.0 | 108.19 | 107.58 | 107.65 | 1506600.0 |
| 2002-05-09 16:00:00 | SPY | ETF | 107.68 | 108.58 | 107.58 | 107.69 | 2285400.0 |
| 2002-05-09 16:30:00 | SPY | ETF | 107.73 | 107.76 | 107.73 | 107.73 | 31800.0 |
| 2002-05-09 17:00:00 | SPY | ETF | 107.73 | 107.75 | 107.65 | 107.69 | 1100.0 |
| 2002-05-09 17:30:00 | SPY | ETF | 107.75 | 107.85 | 107.75 | 107.85 | 1400.0 |
| 2002-05-09 18:00:00 | SPY | ETF | 107.75 | 107.85 | 107.75 | 107.85 | 300.0 |
| 2002-05-09 09:30:00 | QQQ | ETF | 31.57 | 31.89 | 31.51 | 31.84 | 16219100.0 |
| 2002-05-09 10:00:00 | QQQ | ETF | 31.84 | 31.88 | 31.26 | 31.34 | 11902700.0 |
| 2002-05-09 10:30:00 | QQQ | ETF | 31.34 | 31.37 | 31.09 | 31.24 | 9018700.0 |
| 2002-05-09 11:00:00 | QQQ | ETF | 31.24 | 31.32 | 31.05 | 31.14 | 5885200.0 |
| 2002-05-09 11:30:00 | QQQ | ETF | 31.14 | 31.23 | 31.06 | 31.16 | 4113200.0 |
| 2002-05-09 12:00:00 | QQQ | ETF | 31.15 | 31.18 | 30.8 | 30.97 | 11918100.0 |
| 2002-05-09 12:30:00 | QQQ | ETF | 31.0 | 31.35 | 30.97 | 31.28 | 5369200.0 |
| 2002-05-09 13:00:00 | QQQ | ETF | 31.28 | 31.36 | 31.15 | 31.25 | 4015300.0 |
| 2002-05-09 13:30:00 | QQQ | ETF | 31.25 | 31.5 | 31.25 | 31.28 | 5083700.0 |
| 2002-05-09 14:00:00 | QQQ | ETF | 31.3 | 31.36 | 31.15 | 31.2 | 5216200.0 |
| 2002-05-09 14:30:00 | QQQ | ETF | 31.2 | 31.32 | 31.05 | 31.08 | 5528000.0 |
| 2002-05-09 15:00:00 | QQQ | ETF | 31.08 | 31.14 | 30.93 | 31.1 | 5312300.0 |
| 2002-05-09 15:30:00 | QQQ | ETF | 31.09 | 31.26 | 30.87 | 30.89 | 8727300.0 |
| 2002-05-09 16:00:00 | QQQ | ETF | 30.9 | 30.99 | 30.77 | 30.9 | 4071800.0 |
| 2002-05-09 16:30:00 | QQQ | ETF | 30.87 | 30.95 | 30.87 | 30.94 | 31000.0 |
| 2002-05-09 17:00:00 | QQQ | ETF | 30.95 | 30.96 | 30.91 | 30.93 | 15200.0 |
| 2002-05-09 17:30:00 | QQQ | ETF | 30.91 | 30.97 | 30.9 | 30.95 | 26900.0 |
| 2002-05-09 18:00:00 | QQQ | ETF | 30.95 | 30.97 | 30.95 | 30.96 | 11200.0 |
| 2002-05-09 09:30:00 | IWM | ETF | 50.8 | 50.8 | 50.44 | 50.64 | 66200.0 |
| 2002-05-09 10:00:00 | IWM | ETF | 50.675 | 50.735 | 50.485 | 50.5 | 176600.0 |
| 2002-05-09 10:30:00 | IWM | ETF | 50.475 | 50.555 | 50.39 | 50.54 | 75400.0 |
| 2002-05-09 11:00:00 | IWM | ETF | 50.545 | 50.65 | 50.5 | 50.605 | 55200.0 |
| 2002-05-09 11:30:00 | IWM | ETF | 50.65 | 50.65 | 50.51 | 50.57 | 22800.0 |
| 2002-05-09 12:00:00 | IWM | ETF | 50.555 | 50.555 | 50.39 | 50.4 | 69000.0 |
| 2002-05-09 12:30:00 | IWM | ETF | 50.475 | 50.5 | 50.415 | 50.48 | 10200.0 |
| 2002-05-09 13:00:00 | IWM | ETF | 50.545 | 50.59 | 50.5 | 50.585 | 99400.0 |
| 2002-05-09 13:30:00 | IWM | ETF | 50.53 | 50.65 | 50.53 | 50.62 | 117000.0 |
| 2002-05-09 14:00:00 | IWM | ETF | 50.565 | 50.625 | 50.52 | 50.625 | 130800.0 |
| 2002-05-09 14:30:00 | IWM | ETF | 50.54 | 50.735 | 50.52 | 50.54 | 147800.0 |
| 2002-05-09 15:00:00 | IWM | ETF | 50.55 | 50.55 | 50.25 | 50.325 | 191400.0 |
| 2002-05-09 15:30:00 | IWM | ETF | 50.31 | 50.41 | 49.875 | 50.025 | 195800.0 |
| 2002-05-09 16:00:00 | IWM | ETF | 49.85 | 50.0 | 49.85 | 49.875 | 354800.0 |
> showing 50 of 504 rows — these rows as CSV