PREVIEW / etf_30min / 2002-10-31
file: by_date/etf_30min/2002/2002-10-31.parquet size: 21 KB rows: 622
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-10-31 08:30:00 | SPY | ETF | 89.3 | 89.7 | 88.91 | 89.7 | 8500.0 |
| 2002-10-31 09:00:00 | SPY | ETF | 89.78 | 89.85 | 89.66 | 89.75 | 3800.0 |
| 2002-10-31 09:30:00 | SPY | ETF | 89.66 | 90.1 | 89.2 | 89.22 | 3923000.0 |
| 2002-10-31 10:00:00 | SPY | ETF | 89.22 | 90.3 | 89.06 | 90.0 | 6073500.0 |
| 2002-10-31 10:30:00 | SPY | ETF | 90.03 | 90.09 | 89.1 | 89.22 | 2940400.0 |
| 2002-10-31 11:00:00 | SPY | ETF | 89.2 | 89.65 | 88.92 | 89.45 | 3106700.0 |
| 2002-10-31 11:30:00 | SPY | ETF | 89.46 | 89.73 | 89.32 | 89.7 | 1225600.0 |
| 2002-10-31 12:00:00 | SPY | ETF | 89.73 | 89.84 | 89.39 | 89.55 | 1063000.0 |
| 2002-10-31 12:30:00 | SPY | ETF | 89.53 | 89.6 | 89.01 | 89.22 | 1442600.0 |
| 2002-10-31 13:00:00 | SPY | ETF | 89.21 | 89.42 | 89.04 | 89.28 | 623100.0 |
| 2002-10-31 13:30:00 | SPY | ETF | 89.28 | 89.65 | 88.98 | 89.5 | 1244800.0 |
| 2002-10-31 14:00:00 | SPY | ETF | 89.5 | 89.6 | 89.13 | 89.46 | 912400.0 |
| 2002-10-31 14:30:00 | SPY | ETF | 89.45 | 89.65 | 89.11 | 89.14 | 892500.0 |
| 2002-10-31 15:00:00 | SPY | ETF | 89.13 | 89.15 | 88.19 | 88.51 | 4552700.0 |
| 2002-10-31 15:30:00 | SPY | ETF | 88.54 | 89.24 | 88.49 | 88.86 | 4870900.0 |
| 2002-10-31 16:00:00 | SPY | ETF | 88.83 | 88.93 | 88.51 | 88.52 | 3162700.0 |
| 2002-10-31 16:30:00 | SPY | ETF | 88.52 | 88.68 | 88.48 | 88.48 | 171300.0 |
| 2002-10-31 17:00:00 | SPY | ETF | 88.5 | 88.6 | 88.5 | 88.6 | 4900.0 |
| 2002-10-31 17:30:00 | SPY | ETF | 88.6 | 88.6 | 88.59 | 88.6 | 2500.0 |
| 2002-10-31 18:00:00 | SPY | ETF | 88.55 | 88.58 | 88.55 | 88.58 | 1900.0 |
| 2002-10-31 18:30:00 | SPY | ETF | 88.5 | 88.5 | 88.5 | 88.5 | 200.0 |
| 2002-10-31 08:00:00 | QQQ | ETF | 24.56 | 24.59 | 24.5 | 24.5 | 12800.0 |
| 2002-10-31 08:30:00 | QQQ | ETF | 24.4 | 24.78 | 24.37 | 24.74 | 39800.0 |
| 2002-10-31 09:00:00 | QQQ | ETF | 24.71 | 24.74 | 24.64 | 24.65 | 43100.0 |
| 2002-10-31 09:30:00 | QQQ | ETF | 24.66 | 24.84 | 24.56 | 24.62 | 10053800.0 |
| 2002-10-31 10:00:00 | QQQ | ETF | 24.7 | 25.04 | 24.44 | 24.88 | 13092200.0 |
| 2002-10-31 10:30:00 | QQQ | ETF | 24.89 | 24.95 | 24.42 | 24.5 | 10202700.0 |
| 2002-10-31 11:00:00 | QQQ | ETF | 24.49 | 24.66 | 24.37 | 24.57 | 6328300.0 |
| 2002-10-31 11:30:00 | QQQ | ETF | 24.57 | 24.65 | 24.49 | 24.65 | 2528800.0 |
| 2002-10-31 12:00:00 | QQQ | ETF | 24.64 | 24.69 | 24.54 | 24.61 | 2255200.0 |
| 2002-10-31 12:30:00 | QQQ | ETF | 24.6 | 24.65 | 24.45 | 24.51 | 2602900.0 |
| 2002-10-31 13:00:00 | QQQ | ETF | 24.52 | 24.67 | 24.46 | 24.64 | 1730700.0 |
| 2002-10-31 13:30:00 | QQQ | ETF | 24.64 | 24.77 | 24.54 | 24.75 | 2916900.0 |
| 2002-10-31 14:00:00 | QQQ | ETF | 24.75 | 24.82 | 24.6 | 24.78 | 3586100.0 |
| 2002-10-31 14:30:00 | QQQ | ETF | 24.79 | 24.85 | 24.68 | 24.72 | 3739300.0 |
| 2002-10-31 15:00:00 | QQQ | ETF | 24.73 | 24.77 | 24.42 | 24.56 | 6312900.0 |
| 2002-10-31 15:30:00 | QQQ | ETF | 24.55 | 24.76 | 24.48 | 24.58 | 6923800.0 |
| 2002-10-31 16:00:00 | QQQ | ETF | 24.58 | 24.67 | 24.51 | 24.67 | 2610400.0 |
| 2002-10-31 16:30:00 | QQQ | ETF | 24.55 | 24.55 | 24.48 | 24.5 | 121300.0 |
| 2002-10-31 17:00:00 | QQQ | ETF | 24.5 | 24.52 | 24.45 | 24.5 | 165700.0 |
| 2002-10-31 17:30:00 | QQQ | ETF | 24.48 | 24.53 | 24.45 | 24.53 | 32400.0 |
| 2002-10-31 18:00:00 | QQQ | ETF | 24.53 | 24.54 | 24.46 | 24.47 | 25500.0 |
| 2002-10-31 18:30:00 | QQQ | ETF | 24.51 | 24.51 | 24.51 | 24.51 | 200.0 |
| 2002-10-31 19:00:00 | QQQ | ETF | 24.51 | 24.53 | 24.51 | 24.53 | 4000.0 |
| 2002-10-31 09:30:00 | IWM | ETF | 37.525 | 37.65 | 37.38 | 37.38 | 267800.0 |
| 2002-10-31 10:00:00 | IWM | ETF | 37.41 | 37.685 | 37.325 | 37.585 | 572400.0 |
| 2002-10-31 10:30:00 | IWM | ETF | 37.645 | 37.645 | 37.315 | 37.315 | 229200.0 |
| 2002-10-31 11:00:00 | IWM | ETF | 37.315 | 37.43 | 37.2 | 37.3 | 479000.0 |
| 2002-10-31 11:30:00 | IWM | ETF | 37.43 | 37.45 | 37.3 | 37.395 | 207600.0 |
| 2002-10-31 12:00:00 | IWM | ETF | 37.395 | 37.45 | 37.385 | 37.425 | 17200.0 |
> showing 50 of 622 rows — these rows as CSV