PREVIEW / etf_30min / 2002-08-16
file: by_date/etf_30min/2002/2002-08-16.parquet size: 20 KB rows: 559
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-08-16 09:30:00 | SPY | ETF | 92.82 | 92.96 | 92.0 | 92.75 | 6556400.0 |
| 2002-08-16 10:00:00 | SPY | ETF | 92.77 | 93.26 | 92.57 | 93.12 | 3071000.0 |
| 2002-08-16 10:30:00 | SPY | ETF | 93.08 | 93.48 | 93.04 | 93.3 | 3137500.0 |
| 2002-08-16 11:00:00 | SPY | ETF | 93.3 | 94.08 | 93.19 | 93.8 | 4632900.0 |
| 2002-08-16 11:30:00 | SPY | ETF | 93.88 | 93.99 | 93.57 | 93.65 | 1819000.0 |
| 2002-08-16 12:00:00 | SPY | ETF | 93.58 | 93.8 | 93.55 | 93.56 | 901600.0 |
| 2002-08-16 12:30:00 | SPY | ETF | 93.57 | 93.58 | 93.09 | 93.31 | 1861300.0 |
| 2002-08-16 13:00:00 | SPY | ETF | 93.34 | 93.66 | 93.19 | 93.57 | 974000.0 |
| 2002-08-16 13:30:00 | SPY | ETF | 93.56 | 93.8 | 93.4 | 93.5 | 1385800.0 |
| 2002-08-16 14:00:00 | SPY | ETF | 93.5 | 93.65 | 93.25 | 93.61 | 896700.0 |
| 2002-08-16 14:30:00 | SPY | ETF | 93.59 | 93.83 | 93.49 | 93.74 | 877800.0 |
| 2002-08-16 15:00:00 | SPY | ETF | 93.74 | 94.07 | 93.57 | 93.66 | 1869900.0 |
| 2002-08-16 15:30:00 | SPY | ETF | 93.66 | 93.75 | 93.0 | 93.24 | 4628700.0 |
| 2002-08-16 16:00:00 | SPY | ETF | 93.22 | 93.39 | 93.15 | 93.22 | 1440200.0 |
| 2002-08-16 09:30:00 | QQQ | ETF | 24.13 | 24.3 | 23.73 | 24.21 | 21367200.0 |
| 2002-08-16 10:00:00 | QQQ | ETF | 24.18 | 24.34 | 24.05 | 24.33 | 8701100.0 |
| 2002-08-16 10:30:00 | QQQ | ETF | 24.34 | 24.59 | 24.27 | 24.56 | 11032400.0 |
| 2002-08-16 11:00:00 | QQQ | ETF | 24.58 | 24.96 | 24.53 | 24.84 | 9139600.0 |
| 2002-08-16 11:30:00 | QQQ | ETF | 24.83 | 24.9 | 24.67 | 24.67 | 7575500.0 |
| 2002-08-16 12:00:00 | QQQ | ETF | 24.72 | 24.8 | 24.65 | 24.66 | 3623800.0 |
| 2002-08-16 12:30:00 | QQQ | ETF | 24.71 | 24.71 | 24.51 | 24.62 | 3529100.0 |
| 2002-08-16 13:00:00 | QQQ | ETF | 24.63 | 24.8 | 24.56 | 24.76 | 2254800.0 |
| 2002-08-16 13:30:00 | QQQ | ETF | 24.79 | 24.85 | 24.66 | 24.76 | 3093700.0 |
| 2002-08-16 14:00:00 | QQQ | ETF | 24.76 | 24.82 | 24.66 | 24.76 | 2543200.0 |
| 2002-08-16 14:30:00 | QQQ | ETF | 24.76 | 24.92 | 24.72 | 24.86 | 3336700.0 |
| 2002-08-16 15:00:00 | QQQ | ETF | 24.87 | 25.0 | 24.78 | 24.8 | 7068200.0 |
| 2002-08-16 15:30:00 | QQQ | ETF | 24.82 | 24.86 | 24.66 | 24.73 | 6912600.0 |
| 2002-08-16 16:00:00 | QQQ | ETF | 24.71 | 24.79 | 24.7 | 24.7 | 724500.0 |
| 2002-08-16 09:30:00 | IWM | ETF | 38.825 | 38.935 | 38.64 | 38.885 | 508000.0 |
| 2002-08-16 10:00:00 | IWM | ETF | 38.9 | 39.05 | 38.885 | 39.05 | 64800.0 |
| 2002-08-16 10:30:00 | IWM | ETF | 39.05 | 39.13 | 38.95 | 39.13 | 80400.0 |
| 2002-08-16 11:00:00 | IWM | ETF | 39.075 | 39.6 | 39.075 | 39.6 | 159000.0 |
| 2002-08-16 11:30:00 | IWM | ETF | 39.6 | 39.6 | 39.35 | 39.43 | 670800.0 |
| 2002-08-16 12:00:00 | IWM | ETF | 39.5 | 39.5 | 39.315 | 39.39 | 85200.0 |
| 2002-08-16 12:30:00 | IWM | ETF | 39.38 | 39.425 | 39.205 | 39.25 | 162200.0 |
| 2002-08-16 13:00:00 | IWM | ETF | 39.3 | 39.36 | 39.245 | 39.36 | 44800.0 |
| 2002-08-16 13:30:00 | IWM | ETF | 39.325 | 39.455 | 39.3 | 39.335 | 55400.0 |
| 2002-08-16 14:00:00 | IWM | ETF | 39.4 | 39.495 | 39.315 | 39.315 | 77600.0 |
| 2002-08-16 14:30:00 | IWM | ETF | 39.39 | 39.555 | 39.355 | 39.53 | 80600.0 |
| 2002-08-16 15:00:00 | IWM | ETF | 39.54 | 39.665 | 39.515 | 39.615 | 65200.0 |
| 2002-08-16 15:30:00 | IWM | ETF | 39.605 | 39.605 | 39.275 | 39.45 | 129200.0 |
| 2002-08-16 16:00:00 | IWM | ETF | 39.45 | 39.625 | 39.45 | 39.475 | 55400.0 |
| 2002-08-16 09:30:00 | DIA | ETF | 87.62 | 87.92 | 87.12 | 87.59 | 1428900.0 |
| 2002-08-16 10:00:00 | DIA | ETF | 87.58 | 87.89 | 87.3 | 87.77 | 811600.0 |
| 2002-08-16 10:30:00 | DIA | ETF | 87.77 | 88.1 | 87.65 | 87.96 | 825000.0 |
| 2002-08-16 11:00:00 | DIA | ETF | 87.88 | 88.56 | 87.71 | 88.29 | 1026500.0 |
| 2002-08-16 11:30:00 | DIA | ETF | 88.3 | 88.43 | 88.0 | 88.01 | 446800.0 |
| 2002-08-16 12:00:00 | DIA | ETF | 88.09 | 88.4 | 88.01 | 88.01 | 163200.0 |
| 2002-08-16 12:30:00 | DIA | ETF | 88.01 | 88.01 | 87.52 | 87.63 | 606200.0 |
| 2002-08-16 13:00:00 | DIA | ETF | 87.62 | 87.98 | 87.53 | 87.96 | 280400.0 |
> showing 50 of 559 rows — these rows as CSV