PREVIEW / etf_30min / 2002-05-15
file: by_date/etf_30min/2002/2002-05-15.parquet size: 19 KB rows: 545
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-15 09:30:00 | SPY | ETF | 109.5 | 109.73 | 109.29 | 109.67 | 2263300.0 |
| 2002-05-15 10:00:00 | SPY | ETF | 109.67 | 109.83 | 109.44 | 109.79 | 1411500.0 |
| 2002-05-15 10:30:00 | SPY | ETF | 109.82 | 109.9 | 109.64 | 109.79 | 701800.0 |
| 2002-05-15 11:00:00 | SPY | ETF | 109.77 | 110.35 | 109.77 | 110.11 | 2310100.0 |
| 2002-05-15 11:30:00 | SPY | ETF | 110.11 | 110.23 | 109.99 | 110.01 | 616500.0 |
| 2002-05-15 12:00:00 | SPY | ETF | 110.0 | 110.02 | 109.57 | 109.82 | 2326800.0 |
| 2002-05-15 12:30:00 | SPY | ETF | 109.8 | 110.03 | 109.66 | 109.97 | 293000.0 |
| 2002-05-15 13:00:00 | SPY | ETF | 109.96 | 110.32 | 109.92 | 110.24 | 889500.0 |
| 2002-05-15 13:30:00 | SPY | ETF | 110.26 | 110.84 | 110.19 | 110.68 | 1858400.0 |
| 2002-05-15 14:00:00 | SPY | ETF | 110.7 | 110.91 | 110.49 | 110.57 | 1512300.0 |
| 2002-05-15 14:30:00 | SPY | ETF | 110.55 | 110.58 | 109.55 | 109.89 | 5602600.0 |
| 2002-05-15 15:00:00 | SPY | ETF | 109.87 | 109.9 | 109.41 | 109.58 | 3111800.0 |
| 2002-05-15 15:30:00 | SPY | ETF | 109.6 | 109.95 | 109.4 | 109.55 | 2989100.0 |
| 2002-05-15 16:00:00 | SPY | ETF | 109.54 | 109.83 | 109.48 | 109.79 | 1602500.0 |
| 2002-05-15 16:30:00 | SPY | ETF | 109.79 | 109.92 | 109.52 | 109.92 | 177400.0 |
| 2002-05-15 17:00:00 | SPY | ETF | 109.91 | 109.91 | 109.82 | 109.82 | 700.0 |
| 2002-05-15 17:30:00 | SPY | ETF | 109.8 | 109.9 | 109.8 | 109.9 | 2400.0 |
| 2002-05-15 18:00:00 | SPY | ETF | 109.95 | 109.95 | 109.8 | 109.8 | 1500.0 |
| 2002-05-15 09:30:00 | QQQ | ETF | 32.08 | 32.18 | 31.85 | 32.16 | 12627700.0 |
| 2002-05-15 10:00:00 | QQQ | ETF | 32.16 | 32.52 | 32.07 | 32.49 | 14132200.0 |
| 2002-05-15 10:30:00 | QQQ | ETF | 32.48 | 32.59 | 32.3 | 32.44 | 8135800.0 |
| 2002-05-15 11:00:00 | QQQ | ETF | 32.44 | 32.88 | 32.43 | 32.72 | 12630700.0 |
| 2002-05-15 11:30:00 | QQQ | ETF | 32.74 | 32.91 | 32.66 | 32.83 | 6545500.0 |
| 2002-05-15 12:00:00 | QQQ | ETF | 32.83 | 32.85 | 32.55 | 32.75 | 9094500.0 |
| 2002-05-15 12:30:00 | QQQ | ETF | 32.75 | 33.08 | 32.7 | 32.96 | 7098500.0 |
| 2002-05-15 13:00:00 | QQQ | ETF | 32.99 | 33.26 | 32.98 | 33.15 | 5426000.0 |
| 2002-05-15 13:30:00 | QQQ | ETF | 33.16 | 33.5 | 33.15 | 33.43 | 9645700.0 |
| 2002-05-15 14:00:00 | QQQ | ETF | 33.43 | 33.63 | 33.37 | 33.4 | 9761600.0 |
| 2002-05-15 14:30:00 | QQQ | ETF | 33.43 | 33.44 | 32.61 | 32.81 | 21135200.0 |
| 2002-05-15 15:00:00 | QQQ | ETF | 32.84 | 32.91 | 32.55 | 32.62 | 12987600.0 |
| 2002-05-15 15:30:00 | QQQ | ETF | 32.62 | 32.89 | 32.57 | 32.63 | 10372000.0 |
| 2002-05-15 16:00:00 | QQQ | ETF | 32.63 | 33.0 | 32.58 | 32.85 | 2420400.0 |
| 2002-05-15 16:30:00 | QQQ | ETF | 32.81 | 32.87 | 32.72 | 32.75 | 335900.0 |
| 2002-05-15 17:00:00 | QQQ | ETF | 32.75 | 32.94 | 32.73 | 32.74 | 53945200.0 |
| 2002-05-15 17:30:00 | QQQ | ETF | 32.76 | 32.82 | 32.76 | 32.78 | 10700.0 |
| 2002-05-15 18:00:00 | QQQ | ETF | 32.78 | 32.81 | 32.74 | 32.78 | 112200.0 |
| 2002-05-15 09:30:00 | IWM | ETF | 50.875 | 50.9 | 50.58 | 50.9 | 239000.0 |
| 2002-05-15 10:00:00 | IWM | ETF | 50.875 | 51.14 | 50.86 | 51.14 | 405000.0 |
| 2002-05-15 10:30:00 | IWM | ETF | 51.14 | 51.295 | 51.07 | 51.135 | 142600.0 |
| 2002-05-15 11:00:00 | IWM | ETF | 51.14 | 51.315 | 51.14 | 51.25 | 96400.0 |
| 2002-05-15 11:30:00 | IWM | ETF | 51.25 | 51.25 | 51.07 | 51.105 | 139400.0 |
| 2002-05-15 12:00:00 | IWM | ETF | 51.115 | 51.115 | 50.965 | 50.965 | 53400.0 |
| 2002-05-15 12:30:00 | IWM | ETF | 51.015 | 51.145 | 50.965 | 51.1 | 26800.0 |
| 2002-05-15 13:00:00 | IWM | ETF | 51.11 | 51.265 | 51.1 | 51.265 | 32600.0 |
| 2002-05-15 13:30:00 | IWM | ETF | 51.265 | 51.39 | 51.195 | 51.39 | 40800.0 |
| 2002-05-15 14:00:00 | IWM | ETF | 51.37 | 51.41 | 51.29 | 51.315 | 39800.0 |
| 2002-05-15 14:30:00 | IWM | ETF | 51.3 | 51.315 | 50.975 | 51.06 | 269800.0 |
| 2002-05-15 15:00:00 | IWM | ETF | 51.06 | 51.06 | 50.9 | 50.99 | 65400.0 |
| 2002-05-15 15:30:00 | IWM | ETF | 50.98 | 51.14 | 50.93 | 50.94 | 212600.0 |
| 2002-05-15 16:00:00 | IWM | ETF | 50.97 | 51.15 | 50.95 | 51.15 | 18400.0 |
> showing 50 of 545 rows — these rows as CSV