PREVIEW / etf_30min / 2002-04-29
file: by_date/etf_30min/2002/2002-04-29.parquet size: 18 KB rows: 500
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-04-29 09:30:00 | SPY | ETF | 107.93 | 108.19 | 107.66 | 108.17 | 2456100.0 |
| 2002-04-29 10:00:00 | SPY | ETF | 108.16 | 108.26 | 107.53 | 107.7 | 1577700.0 |
| 2002-04-29 10:30:00 | SPY | ETF | 107.72 | 108.13 | 107.69 | 108.09 | 881200.0 |
| 2002-04-29 11:00:00 | SPY | ETF | 108.08 | 108.13 | 107.82 | 107.86 | 841100.0 |
| 2002-04-29 11:30:00 | SPY | ETF | 107.89 | 107.89 | 107.55 | 107.75 | 741600.0 |
| 2002-04-29 12:00:00 | SPY | ETF | 107.75 | 107.94 | 107.69 | 107.81 | 572400.0 |
| 2002-04-29 12:30:00 | SPY | ETF | 107.8 | 107.93 | 107.62 | 107.68 | 301600.0 |
| 2002-04-29 13:00:00 | SPY | ETF | 107.65 | 107.69 | 107.1 | 107.36 | 1287400.0 |
| 2002-04-29 13:30:00 | SPY | ETF | 107.34 | 107.69 | 107.34 | 107.6 | 1143100.0 |
| 2002-04-29 14:00:00 | SPY | ETF | 107.6 | 107.65 | 107.22 | 107.25 | 649200.0 |
| 2002-04-29 14:30:00 | SPY | ETF | 107.25 | 107.5 | 106.86 | 106.94 | 1117200.0 |
| 2002-04-29 15:00:00 | SPY | ETF | 106.92 | 107.24 | 106.92 | 107.07 | 1382900.0 |
| 2002-04-29 15:30:00 | SPY | ETF | 107.12 | 107.12 | 106.63 | 106.82 | 2899700.0 |
| 2002-04-29 16:00:00 | SPY | ETF | 106.91 | 106.98 | 106.7 | 106.85 | 1063100.0 |
| 2002-04-29 16:30:00 | SPY | ETF | 106.83 | 106.85 | 106.8 | 106.8 | 11400.0 |
| 2002-04-29 17:00:00 | SPY | ETF | 106.9 | 106.9 | 106.9 | 106.9 | 200.0 |
| 2002-04-29 17:30:00 | SPY | ETF | 106.9 | 106.99 | 106.9 | 106.99 | 1000.0 |
| 2002-04-29 18:00:00 | SPY | ETF | 106.97 | 107.09 | 106.9 | 106.93 | 600.0 |
| 2002-04-29 09:30:00 | QQQ | ETF | 31.24 | 31.52 | 31.1 | 31.46 | 9198700.0 |
| 2002-04-29 10:00:00 | QQQ | ETF | 31.46 | 31.55 | 31.06 | 31.12 | 9849600.0 |
| 2002-04-29 10:30:00 | QQQ | ETF | 31.12 | 31.4 | 31.11 | 31.39 | 5359900.0 |
| 2002-04-29 11:00:00 | QQQ | ETF | 31.38 | 31.47 | 31.25 | 31.35 | 5491900.0 |
| 2002-04-29 11:30:00 | QQQ | ETF | 31.37 | 31.4 | 31.15 | 31.33 | 5458000.0 |
| 2002-04-29 12:00:00 | QQQ | ETF | 31.35 | 31.42 | 31.28 | 31.33 | 3386300.0 |
| 2002-04-29 12:30:00 | QQQ | ETF | 31.33 | 31.4 | 31.21 | 31.25 | 1304700.0 |
| 2002-04-29 13:00:00 | QQQ | ETF | 31.25 | 31.29 | 30.95 | 31.15 | 5801200.0 |
| 2002-04-29 13:30:00 | QQQ | ETF | 31.17 | 31.27 | 31.08 | 31.19 | 3498000.0 |
| 2002-04-29 14:00:00 | QQQ | ETF | 31.18 | 31.23 | 30.82 | 30.86 | 3708100.0 |
| 2002-04-29 14:30:00 | QQQ | ETF | 30.86 | 31.0 | 30.56 | 30.63 | 7854400.0 |
| 2002-04-29 15:00:00 | QQQ | ETF | 30.63 | 31.0 | 30.62 | 30.92 | 9303600.0 |
| 2002-04-29 15:30:00 | QQQ | ETF | 30.92 | 31.04 | 30.71 | 31.02 | 10596100.0 |
| 2002-04-29 16:00:00 | QQQ | ETF | 31.03 | 31.1 | 31.0 | 31.06 | 1763700.0 |
| 2002-04-29 16:30:00 | QQQ | ETF | 31.05 | 31.13 | 31.02 | 31.13 | 1076700.0 |
| 2002-04-29 17:00:00 | QQQ | ETF | 31.14 | 31.14 | 31.1 | 31.1 | 20700.0 |
| 2002-04-29 17:30:00 | QQQ | ETF | 31.1 | 31.13 | 31.08 | 31.09 | 9400.0 |
| 2002-04-29 18:00:00 | QQQ | ETF | 31.09 | 31.16 | 31.09 | 31.13 | 19100.0 |
| 2002-04-29 09:30:00 | IWM | ETF | 50.0 | 50.09 | 49.875 | 49.98 | 511600.0 |
| 2002-04-29 10:00:00 | IWM | ETF | 49.935 | 50.04 | 49.75 | 49.815 | 102600.0 |
| 2002-04-29 10:30:00 | IWM | ETF | 49.815 | 49.905 | 49.755 | 49.85 | 81200.0 |
| 2002-04-29 11:00:00 | IWM | ETF | 49.835 | 49.925 | 49.815 | 49.825 | 115200.0 |
| 2002-04-29 11:30:00 | IWM | ETF | 49.825 | 49.875 | 49.725 | 49.82 | 178800.0 |
| 2002-04-29 12:00:00 | IWM | ETF | 49.805 | 49.905 | 49.79 | 49.875 | 95200.0 |
| 2002-04-29 12:30:00 | IWM | ETF | 49.85 | 49.915 | 49.81 | 49.85 | 45000.0 |
| 2002-04-29 13:00:00 | IWM | ETF | 49.785 | 49.85 | 49.58 | 49.7 | 501600.0 |
| 2002-04-29 13:30:00 | IWM | ETF | 49.595 | 49.83 | 49.595 | 49.83 | 130400.0 |
| 2002-04-29 14:00:00 | IWM | ETF | 49.765 | 49.83 | 49.75 | 49.75 | 36200.0 |
| 2002-04-29 14:30:00 | IWM | ETF | 49.72 | 49.81 | 49.55 | 49.575 | 596000.0 |
| 2002-04-29 15:00:00 | IWM | ETF | 49.55 | 49.78 | 49.55 | 49.745 | 144800.0 |
| 2002-04-29 15:30:00 | IWM | ETF | 49.745 | 49.88 | 49.6 | 49.86 | 580600.0 |
| 2002-04-29 16:00:00 | IWM | ETF | 49.9 | 49.93 | 49.825 | 49.835 | 428400.0 |
> showing 50 of 500 rows — these rows as CSV