PREVIEW / etf_30min / 2002-02-20
file: by_date/etf_30min/2002/2002-02-20.parquet size: 18 KB rows: 469
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-02-20 09:30:00 | SPY | ETF | 109.05 | 109.25 | 108.8 | 109.25 | 2849800.0 |
| 2002-02-20 10:00:00 | SPY | ETF | 109.27 | 109.37 | 108.82 | 108.94 | 2398900.0 |
| 2002-02-20 10:30:00 | SPY | ETF | 108.96 | 109.08 | 108.67 | 108.96 | 1543200.0 |
| 2002-02-20 11:00:00 | SPY | ETF | 108.95 | 109.0 | 108.46 | 108.7 | 1095100.0 |
| 2002-02-20 11:30:00 | SPY | ETF | 108.7 | 108.82 | 108.6 | 108.64 | 507700.0 |
| 2002-02-20 12:00:00 | SPY | ETF | 108.62 | 108.65 | 108.01 | 108.08 | 2057700.0 |
| 2002-02-20 12:30:00 | SPY | ETF | 108.1 | 108.2 | 107.82 | 108.17 | 1441900.0 |
| 2002-02-20 13:00:00 | SPY | ETF | 108.16 | 108.7 | 108.11 | 108.63 | 1729800.0 |
| 2002-02-20 13:30:00 | SPY | ETF | 108.64 | 108.81 | 108.44 | 108.68 | 1711000.0 |
| 2002-02-20 14:00:00 | SPY | ETF | 108.67 | 109.31 | 108.66 | 109.2 | 2820400.0 |
| 2002-02-20 14:30:00 | SPY | ETF | 109.2 | 110.2 | 109.11 | 110.16 | 3964900.0 |
| 2002-02-20 15:00:00 | SPY | ETF | 110.18 | 110.24 | 109.65 | 109.8 | 2699500.0 |
| 2002-02-20 15:30:00 | SPY | ETF | 109.8 | 110.38 | 109.78 | 110.32 | 2674700.0 |
| 2002-02-20 16:00:00 | SPY | ETF | 110.35 | 110.6 | 110.28 | 110.6 | 1389000.0 |
| 2002-02-20 16:30:00 | SPY | ETF | 110.58 | 110.6 | 110.26 | 110.52 | 115300.0 |
| 2002-02-20 17:00:00 | SPY | ETF | 110.55 | 110.55 | 110.49 | 110.49 | 2300.0 |
| 2002-02-20 18:00:00 | SPY | ETF | 110.53 | 110.55 | 110.46 | 110.54 | 4700.0 |
| 2002-02-20 09:30:00 | QQQ | ETF | 34.9 | 35.05 | 34.57 | 35.05 | 14638200.0 |
| 2002-02-20 10:00:00 | QQQ | ETF | 35.03 | 35.06 | 34.61 | 34.7 | 9428000.0 |
| 2002-02-20 10:30:00 | QQQ | ETF | 34.7 | 34.76 | 34.4 | 34.6 | 8078300.0 |
| 2002-02-20 11:00:00 | QQQ | ETF | 34.64 | 34.64 | 34.3 | 34.45 | 4797300.0 |
| 2002-02-20 11:30:00 | QQQ | ETF | 34.45 | 34.55 | 34.38 | 34.4 | 3596200.0 |
| 2002-02-20 12:00:00 | QQQ | ETF | 34.4 | 34.43 | 34.0 | 34.03 | 9661900.0 |
| 2002-02-20 12:30:00 | QQQ | ETF | 34.0 | 34.18 | 33.93 | 34.18 | 5765200.0 |
| 2002-02-20 13:00:00 | QQQ | ETF | 34.16 | 34.29 | 34.03 | 34.26 | 5352100.0 |
| 2002-02-20 13:30:00 | QQQ | ETF | 34.28 | 34.45 | 34.17 | 34.35 | 4979100.0 |
| 2002-02-20 14:00:00 | QQQ | ETF | 34.36 | 34.89 | 34.34 | 34.73 | 9731500.0 |
| 2002-02-20 14:30:00 | QQQ | ETF | 34.72 | 35.09 | 34.64 | 34.97 | 8577400.0 |
| 2002-02-20 15:00:00 | QQQ | ETF | 34.97 | 35.0 | 34.64 | 34.73 | 6208800.0 |
| 2002-02-20 15:30:00 | QQQ | ETF | 34.74 | 35.17 | 34.7 | 35.09 | 9111000.0 |
| 2002-02-20 16:00:00 | QQQ | ETF | 35.09 | 35.18 | 35.07 | 35.16 | 2128900.0 |
| 2002-02-20 16:30:00 | QQQ | ETF | 35.18 | 35.23 | 35.15 | 35.19 | 103700.0 |
| 2002-02-20 17:00:00 | QQQ | ETF | 35.18 | 35.18 | 35.15 | 35.16 | 26600.0 |
| 2002-02-20 17:30:00 | QQQ | ETF | 35.16 | 35.19 | 35.13 | 35.18 | 44400.0 |
| 2002-02-20 18:00:00 | QQQ | ETF | 35.2 | 35.2 | 35.16 | 35.2 | 19700.0 |
| 2002-02-20 09:30:00 | IWM | ETF | 45.7 | 46.0 | 45.7 | 46.0 | 312600.0 |
| 2002-02-20 10:00:00 | IWM | ETF | 46.045 | 46.07 | 45.82 | 45.82 | 45000.0 |
| 2002-02-20 10:30:00 | IWM | ETF | 45.825 | 45.845 | 45.7 | 45.805 | 27600.0 |
| 2002-02-20 11:00:00 | IWM | ETF | 45.845 | 45.845 | 45.58 | 45.58 | 8400.0 |
| 2002-02-20 11:30:00 | IWM | ETF | 45.66 | 45.7 | 45.625 | 45.635 | 18000.0 |
| 2002-02-20 12:00:00 | IWM | ETF | 45.695 | 45.695 | 45.5 | 45.515 | 25000.0 |
| 2002-02-20 12:30:00 | IWM | ETF | 45.505 | 45.54 | 45.44 | 45.49 | 23000.0 |
| 2002-02-20 13:00:00 | IWM | ETF | 45.52 | 45.675 | 45.5 | 45.675 | 48200.0 |
| 2002-02-20 13:30:00 | IWM | ETF | 45.69 | 45.76 | 45.69 | 45.735 | 32600.0 |
| 2002-02-20 14:00:00 | IWM | ETF | 45.78 | 46.0 | 45.75 | 45.95 | 95800.0 |
| 2002-02-20 14:30:00 | IWM | ETF | 45.95 | 46.265 | 45.95 | 46.265 | 160800.0 |
| 2002-02-20 15:00:00 | IWM | ETF | 46.245 | 46.245 | 46.075 | 46.16 | 35400.0 |
| 2002-02-20 15:30:00 | IWM | ETF | 46.065 | 46.445 | 46.065 | 46.445 | 112000.0 |
| 2002-02-20 16:00:00 | IWM | ETF | 46.485 | 46.55 | 46.485 | 46.55 | 423000.0 |
| 2002-02-20 09:30:00 | DIA | ETF | 97.97 | 98.26 | 97.76 | 98.26 | 523400.0 |
> showing 50 of 469 rows — these rows as CSV