PREVIEW / etf_30min / 2002-05-03
file: by_date/etf_30min/2002/2002-05-03.parquet size: 18 KB rows: 499
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-03 09:30:00 | SPY | ETF | 108.6 | 108.7 | 107.68 | 107.77 | 3344700.0 |
| 2002-05-03 10:00:00 | SPY | ETF | 107.76 | 107.94 | 107.28 | 107.73 | 2396800.0 |
| 2002-05-03 10:30:00 | SPY | ETF | 107.75 | 107.91 | 107.54 | 107.76 | 1254800.0 |
| 2002-05-03 11:00:00 | SPY | ETF | 107.73 | 107.92 | 107.52 | 107.8 | 1176500.0 |
| 2002-05-03 11:30:00 | SPY | ETF | 107.8 | 107.82 | 107.48 | 107.61 | 685400.0 |
| 2002-05-03 12:00:00 | SPY | ETF | 107.67 | 107.67 | 107.34 | 107.34 | 547600.0 |
| 2002-05-03 12:30:00 | SPY | ETF | 107.35 | 107.56 | 107.2 | 107.43 | 700600.0 |
| 2002-05-03 13:00:00 | SPY | ETF | 107.4 | 107.66 | 107.35 | 107.49 | 525400.0 |
| 2002-05-03 13:30:00 | SPY | ETF | 107.51 | 107.6 | 107.24 | 107.41 | 614200.0 |
| 2002-05-03 14:00:00 | SPY | ETF | 107.41 | 107.84 | 107.29 | 107.83 | 721900.0 |
| 2002-05-03 14:30:00 | SPY | ETF | 107.83 | 108.23 | 107.79 | 107.94 | 2201700.0 |
| 2002-05-03 15:00:00 | SPY | ETF | 107.92 | 107.95 | 107.68 | 107.87 | 868700.0 |
| 2002-05-03 15:30:00 | SPY | ETF | 107.86 | 108.09 | 107.57 | 107.67 | 1683900.0 |
| 2002-05-03 16:00:00 | SPY | ETF | 107.65 | 108.6 | 107.47 | 107.5 | 1310600.0 |
| 2002-05-03 16:30:00 | SPY | ETF | 107.53 | 107.79 | 107.53 | 107.75 | 31600.0 |
| 2002-05-03 17:00:00 | SPY | ETF | 107.75 | 107.75 | 107.45 | 107.45 | 4000.0 |
| 2002-05-03 17:30:00 | SPY | ETF | 107.78 | 107.78 | 107.78 | 107.78 | 500.0 |
| 2002-05-03 09:30:00 | QQQ | ETF | 30.47 | 30.51 | 29.88 | 29.93 | 16699900.0 |
| 2002-05-03 10:00:00 | QQQ | ETF | 29.91 | 30.08 | 29.7 | 29.89 | 13733800.0 |
| 2002-05-03 10:30:00 | QQQ | ETF | 29.89 | 30.1 | 29.82 | 29.91 | 4731900.0 |
| 2002-05-03 11:00:00 | QQQ | ETF | 29.91 | 30.01 | 29.83 | 29.92 | 3560500.0 |
| 2002-05-03 11:30:00 | QQQ | ETF | 29.92 | 29.95 | 29.63 | 29.71 | 4321300.0 |
| 2002-05-03 12:00:00 | QQQ | ETF | 29.71 | 29.75 | 29.51 | 29.55 | 6266800.0 |
| 2002-05-03 12:30:00 | QQQ | ETF | 29.51 | 29.7 | 29.48 | 29.62 | 4097000.0 |
| 2002-05-03 13:00:00 | QQQ | ETF | 29.62 | 29.8 | 29.58 | 29.69 | 4407700.0 |
| 2002-05-03 13:30:00 | QQQ | ETF | 29.69 | 29.77 | 29.52 | 29.68 | 2265600.0 |
| 2002-05-03 14:00:00 | QQQ | ETF | 29.66 | 29.96 | 29.59 | 29.92 | 6403600.0 |
| 2002-05-03 14:30:00 | QQQ | ETF | 29.91 | 30.19 | 29.87 | 29.95 | 7406900.0 |
| 2002-05-03 15:00:00 | QQQ | ETF | 29.95 | 29.96 | 29.71 | 29.83 | 6175400.0 |
| 2002-05-03 15:30:00 | QQQ | ETF | 29.83 | 30.0 | 29.63 | 29.65 | 5853800.0 |
| 2002-05-03 16:00:00 | QQQ | ETF | 29.69 | 29.96 | 29.5 | 29.71 | 4646100.0 |
| 2002-05-03 16:30:00 | QQQ | ETF | 29.71 | 29.72 | 29.68 | 29.69 | 35800.0 |
| 2002-05-03 17:00:00 | QQQ | ETF | 29.69 | 29.73 | 29.69 | 29.7 | 505900.0 |
| 2002-05-03 17:30:00 | QQQ | ETF | 29.7 | 29.81 | 29.7 | 29.78 | 21700.0 |
| 2002-05-03 18:00:00 | QQQ | ETF | 29.8 | 29.85 | 29.78 | 29.84 | 18600.0 |
| 2002-05-03 09:30:00 | IWM | ETF | 51.25 | 51.25 | 50.83 | 50.845 | 63400.0 |
| 2002-05-03 10:00:00 | IWM | ETF | 50.78 | 50.925 | 50.65 | 50.815 | 497000.0 |
| 2002-05-03 10:30:00 | IWM | ETF | 50.93 | 50.93 | 50.71 | 50.89 | 46600.0 |
| 2002-05-03 11:00:00 | IWM | ETF | 50.84 | 51.03 | 50.835 | 50.96 | 45600.0 |
| 2002-05-03 11:30:00 | IWM | ETF | 50.92 | 50.94 | 50.825 | 50.88 | 18800.0 |
| 2002-05-03 12:00:00 | IWM | ETF | 50.91 | 50.91 | 50.81 | 50.89 | 3400.0 |
| 2002-05-03 12:30:00 | IWM | ETF | 50.825 | 50.83 | 50.7 | 50.83 | 96200.0 |
| 2002-05-03 13:00:00 | IWM | ETF | 50.87 | 50.96 | 50.735 | 50.95 | 64200.0 |
| 2002-05-03 13:30:00 | IWM | ETF | 50.96 | 50.96 | 50.85 | 50.93 | 4400.0 |
| 2002-05-03 14:00:00 | IWM | ETF | 50.93 | 51.05 | 50.875 | 51.0 | 89200.0 |
| 2002-05-03 14:30:00 | IWM | ETF | 51.07 | 51.175 | 51.05 | 51.125 | 228200.0 |
| 2002-05-03 15:00:00 | IWM | ETF | 51.085 | 51.125 | 50.89 | 50.91 | 125000.0 |
| 2002-05-03 15:30:00 | IWM | ETF | 51.14 | 51.16 | 50.835 | 50.85 | 211800.0 |
| 2002-05-03 16:00:00 | IWM | ETF | 50.95 | 50.95 | 50.95 | 50.95 | 1000.0 |
| 2002-05-03 09:30:00 | DIA | ETF | 100.73 | 100.89 | 100.06 | 100.1 | 476400.0 |
> showing 50 of 499 rows — these rows as CSV