PREVIEW / etf_30min / 2002-01-29
file: by_date/etf_30min/2002/2002-01-29.parquet size: 18 KB rows: 472
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-01-29 09:30:00 | SPY | ETF | 113.85 | 114.13 | 113.72 | 113.83 | 1849300.0 |
| 2002-01-29 10:00:00 | SPY | ETF | 113.79 | 113.93 | 113.15 | 113.18 | 2394400.0 |
| 2002-01-29 10:30:00 | SPY | ETF | 113.3 | 113.3 | 112.91 | 112.91 | 1151100.0 |
| 2002-01-29 11:00:00 | SPY | ETF | 112.92 | 112.95 | 112.18 | 112.4 | 2887000.0 |
| 2002-01-29 11:30:00 | SPY | ETF | 112.4 | 112.43 | 112.13 | 112.18 | 2404000.0 |
| 2002-01-29 12:00:00 | SPY | ETF | 112.2 | 112.2 | 111.36 | 111.46 | 1538900.0 |
| 2002-01-29 12:30:00 | SPY | ETF | 111.45 | 111.8 | 111.38 | 111.7 | 2086300.0 |
| 2002-01-29 13:00:00 | SPY | ETF | 111.7 | 111.73 | 111.29 | 111.71 | 1173100.0 |
| 2002-01-29 13:30:00 | SPY | ETF | 111.68 | 111.78 | 111.42 | 111.56 | 794600.0 |
| 2002-01-29 14:00:00 | SPY | ETF | 111.51 | 111.57 | 110.79 | 111.0 | 2731300.0 |
| 2002-01-29 14:30:00 | SPY | ETF | 111.0 | 111.05 | 110.49 | 110.77 | 1835600.0 |
| 2002-01-29 15:00:00 | SPY | ETF | 110.84 | 110.84 | 110.05 | 110.37 | 2585900.0 |
| 2002-01-29 15:30:00 | SPY | ETF | 110.34 | 110.56 | 110.16 | 110.28 | 2804300.0 |
| 2002-01-29 16:00:00 | SPY | ETF | 110.37 | 110.41 | 110.15 | 110.32 | 1292200.0 |
| 2002-01-29 16:30:00 | SPY | ETF | 110.32 | 110.46 | 110.3 | 110.37 | 45500.0 |
| 2002-01-29 17:00:00 | SPY | ETF | 110.38 | 110.46 | 110.29 | 110.29 | 16500.0 |
| 2002-01-29 17:30:00 | SPY | ETF | 110.31 | 110.34 | 110.31 | 110.34 | 14500.0 |
| 2002-01-29 18:00:00 | SPY | ETF | 110.38 | 110.38 | 110.23 | 110.23 | 4800.0 |
| 2002-01-29 09:30:00 | QQQ | ETF | 39.13 | 39.4 | 39.04 | 39.26 | 8560900.0 |
| 2002-01-29 10:00:00 | QQQ | ETF | 39.27 | 39.37 | 38.85 | 38.89 | 5891500.0 |
| 2002-01-29 10:30:00 | QQQ | ETF | 38.89 | 39.07 | 38.71 | 38.72 | 5735400.0 |
| 2002-01-29 11:00:00 | QQQ | ETF | 38.73 | 38.81 | 38.43 | 38.61 | 6268800.0 |
| 2002-01-29 11:30:00 | QQQ | ETF | 38.6 | 38.65 | 38.43 | 38.5 | 3122900.0 |
| 2002-01-29 12:00:00 | QQQ | ETF | 38.46 | 38.48 | 37.9 | 38.02 | 8170000.0 |
| 2002-01-29 12:30:00 | QQQ | ETF | 38.06 | 38.23 | 37.9 | 38.2 | 4444500.0 |
| 2002-01-29 13:00:00 | QQQ | ETF | 38.22 | 38.25 | 37.98 | 38.25 | 4381400.0 |
| 2002-01-29 13:30:00 | QQQ | ETF | 38.25 | 38.43 | 38.14 | 38.21 | 4752800.0 |
| 2002-01-29 14:00:00 | QQQ | ETF | 38.19 | 38.25 | 37.83 | 37.99 | 6046100.0 |
| 2002-01-29 14:30:00 | QQQ | ETF | 37.98 | 37.99 | 37.64 | 37.82 | 7604700.0 |
| 2002-01-29 15:00:00 | QQQ | ETF | 37.81 | 37.87 | 37.51 | 37.71 | 7613800.0 |
| 2002-01-29 15:30:00 | QQQ | ETF | 37.71 | 37.95 | 37.61 | 37.87 | 7170000.0 |
| 2002-01-29 16:00:00 | QQQ | ETF | 37.86 | 38.02 | 37.85 | 37.91 | 2691300.0 |
| 2002-01-29 16:30:00 | QQQ | ETF | 37.9 | 37.96 | 37.85 | 37.88 | 98300.0 |
| 2002-01-29 17:00:00 | QQQ | ETF | 37.88 | 38.0 | 37.88 | 37.93 | 63300.0 |
| 2002-01-29 17:30:00 | QQQ | ETF | 37.94 | 37.94 | 37.88 | 37.9 | 13200.0 |
| 2002-01-29 18:00:00 | QQQ | ETF | 37.9 | 37.96 | 37.89 | 37.89 | 18000.0 |
| 2002-01-29 09:30:00 | IWM | ETF | 47.925 | 48.015 | 47.9 | 48.015 | 24200.0 |
| 2002-01-29 10:00:00 | IWM | ETF | 47.875 | 47.93 | 47.65 | 47.65 | 46600.0 |
| 2002-01-29 10:30:00 | IWM | ETF | 47.71 | 47.71 | 47.4 | 47.425 | 43800.0 |
| 2002-01-29 11:00:00 | IWM | ETF | 47.39 | 47.39 | 47.19 | 47.24 | 44400.0 |
| 2002-01-29 11:30:00 | IWM | ETF | 47.24 | 47.255 | 47.155 | 47.18 | 9000.0 |
| 2002-01-29 12:00:00 | IWM | ETF | 47.25 | 47.25 | 46.97 | 46.97 | 46600.0 |
| 2002-01-29 12:30:00 | IWM | ETF | 46.96 | 47.145 | 46.96 | 47.095 | 413400.0 |
| 2002-01-29 13:00:00 | IWM | ETF | 47.095 | 47.175 | 47.01 | 47.03 | 79600.0 |
| 2002-01-29 13:30:00 | IWM | ETF | 47.06 | 47.19 | 47.06 | 47.11 | 211800.0 |
| 2002-01-29 14:00:00 | IWM | ETF | 47.1 | 47.19 | 47.005 | 47.08 | 72600.0 |
| 2002-01-29 14:30:00 | IWM | ETF | 47.005 | 47.03 | 46.925 | 47.03 | 94200.0 |
| 2002-01-29 15:00:00 | IWM | ETF | 47.02 | 47.02 | 46.825 | 46.995 | 106400.0 |
| 2002-01-29 15:30:00 | IWM | ETF | 47.0 | 47.135 | 46.93 | 46.93 | 260800.0 |
| 2002-01-29 16:00:00 | IWM | ETF | 47.1 | 47.125 | 47.1 | 47.105 | 62400.0 |
> showing 50 of 472 rows — these rows as CSV