PREVIEW / etf_30min / 2002-01-17
file: by_date/etf_30min/2002/2002-01-17.parquet size: 17 KB rows: 450
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-17 09:30:00 | SPY | ETF | 113.76 | 113.9 | 113.52 | 113.61 | 2107000.0 |
| 2002-01-17 10:00:00 | SPY | ETF | 113.58 | 113.74 | 113.4 | 113.51 | 1412100.0 |
| 2002-01-17 10:30:00 | SPY | ETF | 113.5 | 113.71 | 113.43 | 113.68 | 1119200.0 |
| 2002-01-17 11:00:00 | SPY | ETF | 113.65 | 113.8 | 113.45 | 113.51 | 780100.0 |
| 2002-01-17 11:30:00 | SPY | ETF | 113.52 | 113.85 | 113.44 | 113.66 | 676300.0 |
| 2002-01-17 12:00:00 | SPY | ETF | 113.68 | 114.01 | 113.67 | 113.9 | 1404300.0 |
| 2002-01-17 12:30:00 | SPY | ETF | 113.91 | 114.19 | 113.9 | 114.02 | 1682500.0 |
| 2002-01-17 13:00:00 | SPY | ETF | 113.97 | 114.07 | 113.81 | 113.86 | 1352200.0 |
| 2002-01-17 13:30:00 | SPY | ETF | 113.9 | 113.99 | 113.75 | 113.89 | 650900.0 |
| 2002-01-17 14:00:00 | SPY | ETF | 113.84 | 113.95 | 113.58 | 113.59 | 724300.0 |
| 2002-01-17 14:30:00 | SPY | ETF | 113.6 | 113.94 | 113.57 | 113.93 | 1103500.0 |
| 2002-01-17 15:00:00 | SPY | ETF | 113.91 | 114.1 | 113.8 | 114.08 | 946900.0 |
| 2002-01-17 15:30:00 | SPY | ETF | 114.04 | 114.24 | 113.94 | 114.13 | 1537200.0 |
| 2002-01-17 16:00:00 | SPY | ETF | 114.15 | 114.2 | 113.2 | 113.4 | 949400.0 |
| 2002-01-17 16:30:00 | SPY | ETF | 113.5 | 113.9 | 113.26 | 113.42 | 96200.0 |
| 2002-01-17 17:00:00 | SPY | ETF | 113.25 | 113.3 | 113.15 | 113.22 | 427600.0 |
| 2002-01-17 17:30:00 | SPY | ETF | 113.26 | 113.4 | 113.15 | 113.28 | 73300.0 |
| 2002-01-17 18:00:00 | SPY | ETF | 113.25 | 113.4 | 112.65 | 113.02 | 409900.0 |
| 2002-01-17 09:30:00 | QQQ | ETF | 39.48 | 39.6 | 39.25 | 39.31 | 11472700.0 |
| 2002-01-17 10:00:00 | QQQ | ETF | 39.3 | 39.4 | 39.01 | 39.23 | 8224000.0 |
| 2002-01-17 10:30:00 | QQQ | ETF | 39.21 | 39.32 | 39.16 | 39.28 | 3913100.0 |
| 2002-01-17 11:00:00 | QQQ | ETF | 39.27 | 39.37 | 39.1 | 39.1 | 2891000.0 |
| 2002-01-17 11:30:00 | QQQ | ETF | 39.11 | 39.27 | 39.05 | 39.19 | 3448100.0 |
| 2002-01-17 12:00:00 | QQQ | ETF | 39.19 | 39.41 | 39.16 | 39.38 | 4018100.0 |
| 2002-01-17 12:30:00 | QQQ | ETF | 39.4 | 39.65 | 39.37 | 39.47 | 8049300.0 |
| 2002-01-17 13:00:00 | QQQ | ETF | 39.47 | 39.53 | 39.34 | 39.39 | 2853700.0 |
| 2002-01-17 13:30:00 | QQQ | ETF | 39.39 | 39.49 | 39.35 | 39.46 | 1551300.0 |
| 2002-01-17 14:00:00 | QQQ | ETF | 39.45 | 39.54 | 39.26 | 39.26 | 4317200.0 |
| 2002-01-17 14:30:00 | QQQ | ETF | 39.29 | 39.62 | 39.26 | 39.59 | 3585100.0 |
| 2002-01-17 15:00:00 | QQQ | ETF | 39.59 | 39.86 | 39.55 | 39.82 | 6159300.0 |
| 2002-01-17 15:30:00 | QQQ | ETF | 39.82 | 39.97 | 39.71 | 39.85 | 7200300.0 |
| 2002-01-17 16:00:00 | QQQ | ETF | 39.87 | 39.9 | 39.3 | 39.39 | 3588600.0 |
| 2002-01-17 16:30:00 | QQQ | ETF | 39.4 | 39.55 | 39.03 | 39.18 | 1449900.0 |
| 2002-01-17 17:00:00 | QQQ | ETF | 39.18 | 39.21 | 39.05 | 39.15 | 542500.0 |
| 2002-01-17 17:30:00 | QQQ | ETF | 39.15 | 39.18 | 39.11 | 39.13 | 78400.0 |
| 2002-01-17 18:00:00 | QQQ | ETF | 39.15 | 39.4 | 38.81 | 38.82 | 1243600.0 |
| 2002-01-17 09:30:00 | IWM | ETF | 47.75 | 47.845 | 47.49 | 47.49 | 176000.0 |
| 2002-01-17 10:00:00 | IWM | ETF | 47.55 | 47.55 | 47.315 | 47.385 | 27400.0 |
| 2002-01-17 10:30:00 | IWM | ETF | 47.35 | 47.36 | 47.285 | 47.345 | 30600.0 |
| 2002-01-17 11:00:00 | IWM | ETF | 47.35 | 47.395 | 47.32 | 47.345 | 45000.0 |
| 2002-01-17 11:30:00 | IWM | ETF | 47.26 | 47.355 | 47.26 | 47.28 | 27200.0 |
| 2002-01-17 12:00:00 | IWM | ETF | 47.315 | 47.45 | 47.315 | 47.45 | 58800.0 |
| 2002-01-17 12:30:00 | IWM | ETF | 47.4 | 47.545 | 47.4 | 47.525 | 22600.0 |
| 2002-01-17 13:00:00 | IWM | ETF | 47.525 | 47.525 | 47.5 | 47.5 | 8400.0 |
| 2002-01-17 13:30:00 | IWM | ETF | 47.48 | 47.51 | 47.445 | 47.445 | 14000.0 |
| 2002-01-17 14:00:00 | IWM | ETF | 47.45 | 47.49 | 47.385 | 47.385 | 14600.0 |
| 2002-01-17 14:30:00 | IWM | ETF | 47.395 | 47.475 | 47.395 | 47.47 | 12000.0 |
| 2002-01-17 15:00:00 | IWM | ETF | 47.485 | 47.565 | 47.485 | 47.56 | 16800.0 |
| 2002-01-17 15:30:00 | IWM | ETF | 47.575 | 47.945 | 47.5 | 47.925 | 196000.0 |
| 2002-01-17 16:00:00 | IWM | ETF | 47.99 | 48.0 | 47.55 | 47.55 | 156600.0 |
> showing 50 of 450 rows — these rows as CSV