PREVIEW / etf_30min / 2002-02-14
file: by_date/etf_30min/2002/2002-02-14.parquet size: 17 KB rows: 467
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-14 09:30:00 | SPY | ETF | 112.51 | 112.58 | 111.9 | 112.02 | 2461300.0 |
| 2002-02-14 10:00:00 | SPY | ETF | 112.03 | 112.79 | 112.0 | 112.75 | 4005400.0 |
| 2002-02-14 10:30:00 | SPY | ETF | 112.74 | 112.94 | 112.52 | 112.72 | 2042800.0 |
| 2002-02-14 11:00:00 | SPY | ETF | 112.73 | 112.82 | 112.63 | 112.65 | 416300.0 |
| 2002-02-14 11:30:00 | SPY | ETF | 112.65 | 112.77 | 112.5 | 112.71 | 461200.0 |
| 2002-02-14 12:00:00 | SPY | ETF | 112.71 | 112.97 | 112.65 | 112.76 | 739700.0 |
| 2002-02-14 12:30:00 | SPY | ETF | 112.75 | 112.8 | 112.62 | 112.71 | 245000.0 |
| 2002-02-14 13:00:00 | SPY | ETF | 112.68 | 112.79 | 112.62 | 112.79 | 264200.0 |
| 2002-02-14 13:30:00 | SPY | ETF | 112.77 | 112.84 | 112.32 | 112.41 | 821700.0 |
| 2002-02-14 14:00:00 | SPY | ETF | 112.4 | 112.4 | 111.93 | 112.06 | 3233400.0 |
| 2002-02-14 14:30:00 | SPY | ETF | 111.96 | 112.24 | 111.94 | 111.98 | 769400.0 |
| 2002-02-14 15:00:00 | SPY | ETF | 111.94 | 112.03 | 111.59 | 111.74 | 2290400.0 |
| 2002-02-14 15:30:00 | SPY | ETF | 111.74 | 112.18 | 111.73 | 111.98 | 1439600.0 |
| 2002-02-14 16:00:00 | SPY | ETF | 111.98 | 112.1 | 111.97 | 112.06 | 804900.0 |
| 2002-02-14 16:30:00 | SPY | ETF | 112.06 | 112.06 | 111.55 | 112.0 | 83500.0 |
| 2002-02-14 17:00:00 | SPY | ETF | 111.99 | 111.99 | 111.99 | 111.99 | 600.0 |
| 2002-02-14 17:30:00 | SPY | ETF | 111.98 | 112.01 | 111.98 | 111.98 | 2000.0 |
| 2002-02-14 18:00:00 | SPY | ETF | 111.96 | 111.96 | 111.94 | 111.94 | 200.0 |
| 2002-02-14 09:30:00 | QQQ | ETF | 37.15 | 37.3 | 36.94 | 37.0 | 9096400.0 |
| 2002-02-14 10:00:00 | QQQ | ETF | 37.0 | 37.42 | 36.98 | 37.41 | 13002700.0 |
| 2002-02-14 10:30:00 | QQQ | ETF | 37.41 | 37.57 | 37.3 | 37.44 | 7397200.0 |
| 2002-02-14 11:00:00 | QQQ | ETF | 37.45 | 37.49 | 37.33 | 37.34 | 2434200.0 |
| 2002-02-14 11:30:00 | QQQ | ETF | 37.35 | 37.46 | 37.29 | 37.41 | 4549900.0 |
| 2002-02-14 12:00:00 | QQQ | ETF | 37.42 | 37.55 | 37.38 | 37.44 | 3256700.0 |
| 2002-02-14 12:30:00 | QQQ | ETF | 37.44 | 37.47 | 37.34 | 37.4 | 1453300.0 |
| 2002-02-14 13:00:00 | QQQ | ETF | 37.4 | 37.45 | 37.32 | 37.44 | 1228800.0 |
| 2002-02-14 13:30:00 | QQQ | ETF | 37.45 | 37.53 | 37.16 | 37.18 | 4020700.0 |
| 2002-02-14 14:00:00 | QQQ | ETF | 37.16 | 37.19 | 36.7 | 36.78 | 8472000.0 |
| 2002-02-14 14:30:00 | QQQ | ETF | 36.77 | 37.07 | 36.75 | 36.8 | 5397400.0 |
| 2002-02-14 15:00:00 | QQQ | ETF | 36.8 | 36.88 | 36.6 | 36.69 | 6051400.0 |
| 2002-02-14 15:30:00 | QQQ | ETF | 36.69 | 36.92 | 36.66 | 36.72 | 5865300.0 |
| 2002-02-14 16:00:00 | QQQ | ETF | 36.72 | 36.94 | 36.66 | 36.8 | 2225500.0 |
| 2002-02-14 16:30:00 | QQQ | ETF | 36.81 | 36.89 | 36.35 | 36.76 | 1956900.0 |
| 2002-02-14 17:00:00 | QQQ | ETF | 36.74 | 36.83 | 36.71 | 36.75 | 169900.0 |
| 2002-02-14 17:30:00 | QQQ | ETF | 36.75 | 36.76 | 36.66 | 36.67 | 41800.0 |
| 2002-02-14 18:00:00 | QQQ | ETF | 36.69 | 36.75 | 36.65 | 36.74 | 14000.0 |
| 2002-02-14 09:30:00 | IWM | ETF | 47.47 | 47.545 | 47.17 | 47.17 | 78600.0 |
| 2002-02-14 10:00:00 | IWM | ETF | 47.275 | 47.54 | 47.25 | 47.45 | 492800.0 |
| 2002-02-14 10:30:00 | IWM | ETF | 47.565 | 47.59 | 47.385 | 47.5 | 66400.0 |
| 2002-02-14 11:00:00 | IWM | ETF | 47.52 | 47.525 | 47.41 | 47.495 | 40000.0 |
| 2002-02-14 11:30:00 | IWM | ETF | 47.495 | 47.495 | 47.35 | 47.495 | 23400.0 |
| 2002-02-14 12:00:00 | IWM | ETF | 47.445 | 47.485 | 47.39 | 47.39 | 12200.0 |
| 2002-02-14 12:30:00 | IWM | ETF | 47.475 | 47.475 | 47.395 | 47.405 | 11600.0 |
| 2002-02-14 13:00:00 | IWM | ETF | 47.415 | 47.42 | 47.355 | 47.395 | 209000.0 |
| 2002-02-14 13:30:00 | IWM | ETF | 47.405 | 47.41 | 47.355 | 47.375 | 214200.0 |
| 2002-02-14 14:00:00 | IWM | ETF | 47.25 | 47.31 | 47.06 | 47.06 | 263000.0 |
| 2002-02-14 14:30:00 | IWM | ETF | 47.1 | 47.185 | 47.055 | 47.08 | 87600.0 |
| 2002-02-14 15:00:00 | IWM | ETF | 47.07 | 47.115 | 46.785 | 46.79 | 111800.0 |
| 2002-02-14 15:30:00 | IWM | ETF | 46.835 | 46.975 | 46.825 | 46.925 | 120800.0 |
| 2002-02-14 16:00:00 | IWM | ETF | 46.905 | 46.905 | 46.75 | 46.835 | 226600.0 |
> showing 50 of 467 rows — these rows as CSV