PREVIEW / etf_30min / 2002-05-20
file: by_date/etf_30min/2002/2002-05-20.parquet size: 18 KB rows: 511
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-20 09:30:00 | SPY | ETF | 110.64 | 110.69 | 110.13 | 110.29 | 1886500.0 |
| 2002-05-20 10:00:00 | SPY | ETF | 110.29 | 110.33 | 109.76 | 109.88 | 2520500.0 |
| 2002-05-20 10:30:00 | SPY | ETF | 109.86 | 109.89 | 109.62 | 109.7 | 1368100.0 |
| 2002-05-20 11:00:00 | SPY | ETF | 109.71 | 109.91 | 109.55 | 109.9 | 800700.0 |
| 2002-05-20 11:30:00 | SPY | ETF | 109.87 | 109.91 | 109.54 | 109.89 | 989000.0 |
| 2002-05-20 12:00:00 | SPY | ETF | 109.89 | 109.98 | 109.78 | 109.86 | 307600.0 |
| 2002-05-20 12:30:00 | SPY | ETF | 109.86 | 109.92 | 109.73 | 109.8 | 421900.0 |
| 2002-05-20 13:00:00 | SPY | ETF | 109.79 | 109.98 | 109.79 | 109.95 | 235800.0 |
| 2002-05-20 13:30:00 | SPY | ETF | 109.94 | 110.18 | 109.94 | 110.05 | 851600.0 |
| 2002-05-20 14:00:00 | SPY | ETF | 110.04 | 110.05 | 109.78 | 109.91 | 457700.0 |
| 2002-05-20 14:30:00 | SPY | ETF | 109.88 | 110.09 | 109.73 | 109.79 | 602800.0 |
| 2002-05-20 15:00:00 | SPY | ETF | 109.76 | 109.79 | 109.49 | 109.72 | 1098100.0 |
| 2002-05-20 15:30:00 | SPY | ETF | 109.7 | 109.86 | 109.61 | 109.64 | 999100.0 |
| 2002-05-20 16:00:00 | SPY | ETF | 109.64 | 109.9 | 109.52 | 109.7 | 887700.0 |
| 2002-05-20 16:30:00 | SPY | ETF | 109.75 | 109.77 | 109.7 | 109.77 | 9600.0 |
| 2002-05-20 17:00:00 | SPY | ETF | 109.75 | 109.75 | 109.7 | 109.75 | 2500.0 |
| 2002-05-20 18:00:00 | SPY | ETF | 109.71 | 109.71 | 109.68 | 109.68 | 400.0 |
| 2002-05-20 09:30:00 | QQQ | ETF | 32.6 | 32.7 | 32.45 | 32.53 | 9104000.0 |
| 2002-05-20 10:00:00 | QQQ | ETF | 32.51 | 32.54 | 32.06 | 32.19 | 9520900.0 |
| 2002-05-20 10:30:00 | QQQ | ETF | 32.17 | 32.25 | 31.97 | 32.02 | 7025800.0 |
| 2002-05-20 11:00:00 | QQQ | ETF | 32.02 | 32.15 | 31.96 | 32.11 | 3158800.0 |
| 2002-05-20 11:30:00 | QQQ | ETF | 32.12 | 32.15 | 31.94 | 32.15 | 4064900.0 |
| 2002-05-20 12:00:00 | QQQ | ETF | 32.13 | 32.18 | 32.02 | 32.05 | 1982400.0 |
| 2002-05-20 12:30:00 | QQQ | ETF | 32.06 | 32.08 | 31.95 | 32.03 | 2691000.0 |
| 2002-05-20 13:00:00 | QQQ | ETF | 32.01 | 32.16 | 32.01 | 32.15 | 2993000.0 |
| 2002-05-20 13:30:00 | QQQ | ETF | 32.15 | 32.29 | 32.13 | 32.17 | 5532200.0 |
| 2002-05-20 14:00:00 | QQQ | ETF | 32.16 | 32.19 | 32.02 | 32.13 | 3112500.0 |
| 2002-05-20 14:30:00 | QQQ | ETF | 32.14 | 32.25 | 32.05 | 32.08 | 3714900.0 |
| 2002-05-20 15:00:00 | QQQ | ETF | 32.08 | 32.15 | 31.94 | 32.1 | 5158500.0 |
| 2002-05-20 15:30:00 | QQQ | ETF | 32.08 | 32.25 | 32.05 | 32.17 | 9288600.0 |
| 2002-05-20 16:00:00 | QQQ | ETF | 32.17 | 32.28 | 32.05 | 32.21 | 1552100.0 |
| 2002-05-20 16:30:00 | QQQ | ETF | 32.21 | 32.25 | 32.2 | 32.25 | 146500.0 |
| 2002-05-20 17:00:00 | QQQ | ETF | 32.24 | 32.25 | 32.23 | 32.23 | 31500.0 |
| 2002-05-20 17:30:00 | QQQ | ETF | 32.23 | 32.25 | 32.2 | 32.21 | 44600.0 |
| 2002-05-20 18:00:00 | QQQ | ETF | 32.21 | 32.21 | 32.15 | 32.18 | 15800.0 |
| 2002-05-20 09:30:00 | IWM | ETF | 50.625 | 50.625 | 50.475 | 50.54 | 33000.0 |
| 2002-05-20 10:00:00 | IWM | ETF | 50.565 | 50.565 | 50.3 | 50.345 | 47200.0 |
| 2002-05-20 10:30:00 | IWM | ETF | 50.315 | 50.35 | 50.25 | 50.255 | 91800.0 |
| 2002-05-20 11:00:00 | IWM | ETF | 50.31 | 50.33 | 50.225 | 50.33 | 80400.0 |
| 2002-05-20 11:30:00 | IWM | ETF | 50.315 | 50.315 | 50.17 | 50.245 | 34000.0 |
| 2002-05-20 12:00:00 | IWM | ETF | 50.21 | 50.245 | 50.195 | 50.195 | 19800.0 |
| 2002-05-20 12:30:00 | IWM | ETF | 50.19 | 50.245 | 50.17 | 50.245 | 125600.0 |
| 2002-05-20 13:00:00 | IWM | ETF | 50.225 | 50.245 | 50.15 | 50.19 | 221600.0 |
| 2002-05-20 13:30:00 | IWM | ETF | 50.225 | 50.3 | 50.195 | 50.295 | 41600.0 |
| 2002-05-20 14:00:00 | IWM | ETF | 50.24 | 50.29 | 50.16 | 50.205 | 84400.0 |
| 2002-05-20 14:30:00 | IWM | ETF | 50.21 | 50.25 | 50.175 | 50.19 | 20200.0 |
| 2002-05-20 15:00:00 | IWM | ETF | 50.2 | 50.2 | 50.1 | 50.13 | 201200.0 |
| 2002-05-20 15:30:00 | IWM | ETF | 50.135 | 50.19 | 50.005 | 50.05 | 82600.0 |
| 2002-05-20 16:00:00 | IWM | ETF | 50.05 | 50.205 | 50.03 | 50.12 | 741200.0 |
| 2002-05-20 17:30:00 | IWM | ETF | 50.05 | 50.05 | 50.05 | 50.05 | 200.0 |
> showing 50 of 511 rows — these rows as CSV