PREVIEW / etf_30min / 2002-05-06
file: by_date/etf_30min/2002/2002-05-06.parquet size: 19 KB rows: 513
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-06 09:30:00 | SPY | ETF | 107.64 | 107.99 | 107.28 | 107.7 | 4090500.0 |
| 2002-05-06 10:00:00 | SPY | ETF | 107.7 | 107.89 | 107.36 | 107.71 | 1346800.0 |
| 2002-05-06 10:30:00 | SPY | ETF | 107.73 | 107.93 | 107.57 | 107.66 | 1329400.0 |
| 2002-05-06 11:00:00 | SPY | ETF | 107.64 | 107.87 | 107.5 | 107.5 | 592300.0 |
| 2002-05-06 11:30:00 | SPY | ETF | 107.51 | 107.75 | 107.37 | 107.51 | 651500.0 |
| 2002-05-06 12:00:00 | SPY | ETF | 107.51 | 107.63 | 107.36 | 107.49 | 303400.0 |
| 2002-05-06 12:30:00 | SPY | ETF | 107.51 | 107.56 | 107.3 | 107.42 | 413600.0 |
| 2002-05-06 13:00:00 | SPY | ETF | 107.46 | 107.66 | 107.15 | 107.23 | 909500.0 |
| 2002-05-06 13:30:00 | SPY | ETF | 107.23 | 107.29 | 106.94 | 107.07 | 1439000.0 |
| 2002-05-06 14:00:00 | SPY | ETF | 107.06 | 107.19 | 106.88 | 106.94 | 1367000.0 |
| 2002-05-06 14:30:00 | SPY | ETF | 106.89 | 106.97 | 106.72 | 106.8 | 694100.0 |
| 2002-05-06 15:00:00 | SPY | ETF | 106.79 | 106.9 | 106.15 | 106.23 | 2823500.0 |
| 2002-05-06 15:30:00 | SPY | ETF | 106.27 | 106.39 | 105.51 | 105.62 | 3274600.0 |
| 2002-05-06 16:00:00 | SPY | ETF | 105.62 | 105.63 | 105.31 | 105.41 | 3057600.0 |
| 2002-05-06 16:30:00 | SPY | ETF | 105.35 | 105.59 | 105.35 | 105.59 | 5100.0 |
| 2002-05-06 17:00:00 | SPY | ETF | 105.53 | 105.53 | 105.5 | 105.5 | 700.0 |
| 2002-05-06 17:30:00 | SPY | ETF | 105.5 | 105.5 | 105.49 | 105.5 | 5600.0 |
| 2002-05-06 18:00:00 | SPY | ETF | 105.53 | 105.53 | 104.71 | 104.71 | 275200.0 |
| 2002-05-06 09:30:00 | QQQ | ETF | 29.63 | 29.98 | 29.37 | 29.76 | 17519600.0 |
| 2002-05-06 10:00:00 | QQQ | ETF | 29.76 | 29.88 | 29.49 | 29.76 | 15618400.0 |
| 2002-05-06 10:30:00 | QQQ | ETF | 29.77 | 29.9 | 29.63 | 29.7 | 5337700.0 |
| 2002-05-06 11:00:00 | QQQ | ETF | 29.7 | 29.85 | 29.68 | 29.69 | 3154500.0 |
| 2002-05-06 11:30:00 | QQQ | ETF | 29.69 | 29.89 | 29.65 | 29.81 | 3317200.0 |
| 2002-05-06 12:00:00 | QQQ | ETF | 29.8 | 29.9 | 29.74 | 29.83 | 2588300.0 |
| 2002-05-06 12:30:00 | QQQ | ETF | 29.84 | 29.87 | 29.71 | 29.84 | 2126400.0 |
| 2002-05-06 13:00:00 | QQQ | ETF | 29.85 | 29.98 | 29.73 | 29.76 | 4249500.0 |
| 2002-05-06 13:30:00 | QQQ | ETF | 29.76 | 29.8 | 29.55 | 29.65 | 4308000.0 |
| 2002-05-06 14:00:00 | QQQ | ETF | 29.64 | 29.69 | 29.51 | 29.55 | 5104600.0 |
| 2002-05-06 14:30:00 | QQQ | ETF | 29.54 | 29.58 | 29.4 | 29.48 | 4717500.0 |
| 2002-05-06 15:00:00 | QQQ | ETF | 29.48 | 29.54 | 29.01 | 29.08 | 10413900.0 |
| 2002-05-06 15:30:00 | QQQ | ETF | 29.08 | 29.17 | 28.85 | 28.9 | 13677700.0 |
| 2002-05-06 16:00:00 | QQQ | ETF | 28.91 | 28.98 | 28.88 | 28.96 | 2587900.0 |
| 2002-05-06 16:30:00 | QQQ | ETF | 28.93 | 28.97 | 28.9 | 28.92 | 88800.0 |
| 2002-05-06 17:00:00 | QQQ | ETF | 28.93 | 28.94 | 28.88 | 28.88 | 98700.0 |
| 2002-05-06 17:30:00 | QQQ | ETF | 28.9 | 28.91 | 28.87 | 28.88 | 36800.0 |
| 2002-05-06 18:00:00 | QQQ | ETF | 28.87 | 28.92 | 28.86 | 28.9 | 22200.0 |
| 2002-05-06 09:30:00 | IWM | ETF | 50.995 | 51.16 | 50.9 | 51.055 | 134400.0 |
| 2002-05-06 10:00:00 | IWM | ETF | 51.055 | 51.065 | 50.925 | 50.975 | 45800.0 |
| 2002-05-06 10:30:00 | IWM | ETF | 50.99 | 51.0 | 50.915 | 50.915 | 48600.0 |
| 2002-05-06 11:00:00 | IWM | ETF | 50.95 | 50.995 | 50.9 | 50.955 | 96200.0 |
| 2002-05-06 11:30:00 | IWM | ETF | 50.885 | 50.955 | 50.84 | 50.9 | 34200.0 |
| 2002-05-06 12:00:00 | IWM | ETF | 50.915 | 50.915 | 50.82 | 50.85 | 60200.0 |
| 2002-05-06 12:30:00 | IWM | ETF | 50.875 | 50.875 | 50.81 | 50.855 | 46800.0 |
| 2002-05-06 13:00:00 | IWM | ETF | 50.815 | 50.875 | 50.79 | 50.79 | 20000.0 |
| 2002-05-06 13:30:00 | IWM | ETF | 50.78 | 50.845 | 50.67 | 50.735 | 134400.0 |
| 2002-05-06 14:00:00 | IWM | ETF | 50.73 | 50.735 | 50.64 | 50.645 | 232000.0 |
| 2002-05-06 14:30:00 | IWM | ETF | 50.62 | 50.67 | 50.5 | 50.54 | 166800.0 |
| 2002-05-06 15:00:00 | IWM | ETF | 50.475 | 50.48 | 50.165 | 50.205 | 271200.0 |
| 2002-05-06 15:30:00 | IWM | ETF | 50.195 | 50.195 | 50.0 | 50.0 | 449600.0 |
| 2002-05-06 16:00:00 | IWM | ETF | 49.99 | 50.07 | 49.975 | 50.07 | 976800.0 |
> showing 50 of 513 rows — these rows as CSV