PREVIEW / etf_30min / 2002-05-23
file: by_date/etf_30min/2002/2002-05-23.parquet size: 18 KB rows: 493
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-23 09:30:00 | SPY | ETF | 109.26 | 109.45 | 108.78 | 109.1 | 1766400.0 |
| 2002-05-23 10:00:00 | SPY | ETF | 109.1 | 109.32 | 108.8 | 109.31 | 1307800.0 |
| 2002-05-23 10:30:00 | SPY | ETF | 109.31 | 109.34 | 109.0 | 109.16 | 661800.0 |
| 2002-05-23 11:00:00 | SPY | ETF | 109.15 | 109.19 | 108.75 | 108.93 | 702600.0 |
| 2002-05-23 11:30:00 | SPY | ETF | 108.88 | 109.04 | 108.51 | 108.61 | 636500.0 |
| 2002-05-23 12:00:00 | SPY | ETF | 108.6 | 108.85 | 108.48 | 108.85 | 617900.0 |
| 2002-05-23 12:30:00 | SPY | ETF | 108.86 | 109.0 | 108.79 | 108.85 | 498200.0 |
| 2002-05-23 13:00:00 | SPY | ETF | 108.84 | 109.08 | 108.68 | 108.96 | 563700.0 |
| 2002-05-23 13:30:00 | SPY | ETF | 108.99 | 109.0 | 108.76 | 108.84 | 355500.0 |
| 2002-05-23 14:00:00 | SPY | ETF | 108.84 | 109.25 | 108.75 | 109.19 | 591700.0 |
| 2002-05-23 14:30:00 | SPY | ETF | 109.2 | 109.7 | 109.18 | 109.65 | 1387100.0 |
| 2002-05-23 15:00:00 | SPY | ETF | 109.63 | 109.96 | 109.6 | 109.74 | 1484200.0 |
| 2002-05-23 15:30:00 | SPY | ETF | 109.73 | 110.24 | 109.72 | 110.16 | 1904200.0 |
| 2002-05-23 16:00:00 | SPY | ETF | 110.18 | 110.36 | 109.97 | 110.25 | 1204000.0 |
| 2002-05-23 16:30:00 | SPY | ETF | 110.16 | 110.25 | 110.1 | 110.18 | 21800.0 |
| 2002-05-23 17:00:00 | SPY | ETF | 110.11 | 110.19 | 110.09 | 110.12 | 16500.0 |
| 2002-05-23 17:30:00 | SPY | ETF | 110.2 | 110.2 | 110.2 | 110.2 | 400.0 |
| 2002-05-23 18:00:00 | SPY | ETF | 110.13 | 110.19 | 110.13 | 110.19 | 1400.0 |
| 2002-05-23 09:30:00 | QQQ | ETF | 31.63 | 31.74 | 31.15 | 31.43 | 17601400.0 |
| 2002-05-23 10:00:00 | QQQ | ETF | 31.43 | 31.45 | 31.08 | 31.34 | 7187400.0 |
| 2002-05-23 10:30:00 | QQQ | ETF | 31.33 | 31.35 | 31.08 | 31.15 | 3222600.0 |
| 2002-05-23 11:00:00 | QQQ | ETF | 31.16 | 31.17 | 30.8 | 30.91 | 9537100.0 |
| 2002-05-23 11:30:00 | QQQ | ETF | 30.91 | 31.01 | 30.84 | 30.88 | 4264100.0 |
| 2002-05-23 12:00:00 | QQQ | ETF | 30.91 | 31.1 | 30.87 | 31.1 | 2922900.0 |
| 2002-05-23 12:30:00 | QQQ | ETF | 31.09 | 31.15 | 31.02 | 31.03 | 2703900.0 |
| 2002-05-23 13:00:00 | QQQ | ETF | 31.03 | 31.2 | 30.96 | 31.14 | 3224200.0 |
| 2002-05-23 13:30:00 | QQQ | ETF | 31.14 | 31.2 | 31.01 | 31.14 | 2636700.0 |
| 2002-05-23 14:00:00 | QQQ | ETF | 31.14 | 31.45 | 31.05 | 31.39 | 4839400.0 |
| 2002-05-23 14:30:00 | QQQ | ETF | 31.39 | 31.78 | 31.37 | 31.68 | 10899800.0 |
| 2002-05-23 15:00:00 | QQQ | ETF | 31.7 | 31.86 | 31.6 | 31.7 | 8363000.0 |
| 2002-05-23 15:30:00 | QQQ | ETF | 31.71 | 32.1 | 31.66 | 32.06 | 12036800.0 |
| 2002-05-23 16:00:00 | QQQ | ETF | 32.05 | 32.1 | 32.0 | 32.08 | 2053900.0 |
| 2002-05-23 16:30:00 | QQQ | ETF | 32.09 | 32.1 | 31.85 | 31.93 | 751500.0 |
| 2002-05-23 17:00:00 | QQQ | ETF | 31.94 | 31.96 | 31.89 | 31.9 | 41700.0 |
| 2002-05-23 17:30:00 | QQQ | ETF | 31.93 | 31.97 | 31.91 | 31.97 | 59200.0 |
| 2002-05-23 18:00:00 | QQQ | ETF | 31.97 | 31.98 | 31.91 | 31.96 | 23600.0 |
| 2002-05-23 09:30:00 | IWM | ETF | 49.35 | 49.35 | 49.0 | 49.0 | 282600.0 |
| 2002-05-23 10:00:00 | IWM | ETF | 49.05 | 49.095 | 48.75 | 48.925 | 181800.0 |
| 2002-05-23 10:30:00 | IWM | ETF | 48.955 | 48.975 | 48.92 | 48.965 | 118200.0 |
| 2002-05-23 11:00:00 | IWM | ETF | 48.99 | 49.025 | 48.875 | 48.9 | 338000.0 |
| 2002-05-23 11:30:00 | IWM | ETF | 48.9 | 48.97 | 48.85 | 48.85 | 70000.0 |
| 2002-05-23 12:00:00 | IWM | ETF | 48.85 | 48.94 | 48.815 | 48.88 | 90400.0 |
| 2002-05-23 12:30:00 | IWM | ETF | 48.925 | 49.02 | 48.895 | 49.0 | 157400.0 |
| 2002-05-23 13:00:00 | IWM | ETF | 49.01 | 49.14 | 48.935 | 49.14 | 252600.0 |
| 2002-05-23 13:30:00 | IWM | ETF | 49.145 | 49.145 | 49.06 | 49.135 | 26400.0 |
| 2002-05-23 14:00:00 | IWM | ETF | 49.13 | 49.31 | 49.055 | 49.3 | 124000.0 |
| 2002-05-23 14:30:00 | IWM | ETF | 49.315 | 49.7 | 49.3 | 49.58 | 213400.0 |
| 2002-05-23 15:00:00 | IWM | ETF | 49.64 | 49.82 | 49.58 | 49.75 | 401600.0 |
| 2002-05-23 15:30:00 | IWM | ETF | 49.755 | 49.995 | 49.75 | 49.995 | 74800.0 |
| 2002-05-23 16:00:00 | IWM | ETF | 49.99 | 49.99 | 49.9 | 49.975 | 2600.0 |
> showing 50 of 493 rows — these rows as CSV