PREVIEW / etf_30min / 2002-09-13
file: by_date/etf_30min/2002/2002-09-13.parquet size: 19 KB rows: 521
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-09-13 09:30:00 | SPY | ETF | 88.69 | 88.82 | 88.25 | 88.53 | 5915500.0 |
| 2002-09-13 10:00:00 | SPY | ETF | 88.52 | 89.36 | 88.34 | 89.17 | 5826400.0 |
| 2002-09-13 10:30:00 | SPY | ETF | 89.17 | 89.66 | 89.01 | 89.08 | 4140400.0 |
| 2002-09-13 11:00:00 | SPY | ETF | 89.1 | 89.15 | 88.6 | 88.76 | 1845100.0 |
| 2002-09-13 11:30:00 | SPY | ETF | 88.76 | 89.38 | 88.75 | 89.35 | 2317500.0 |
| 2002-09-13 12:00:00 | SPY | ETF | 89.3 | 89.49 | 89.09 | 89.32 | 3214100.0 |
| 2002-09-13 12:30:00 | SPY | ETF | 89.36 | 89.59 | 89.11 | 89.56 | 1318100.0 |
| 2002-09-13 13:00:00 | SPY | ETF | 89.53 | 89.9 | 89.34 | 89.64 | 1636600.0 |
| 2002-09-13 13:30:00 | SPY | ETF | 89.61 | 89.76 | 89.2 | 89.24 | 1573800.0 |
| 2002-09-13 14:00:00 | SPY | ETF | 89.24 | 89.39 | 88.9 | 88.95 | 2505300.0 |
| 2002-09-13 14:30:00 | SPY | ETF | 88.95 | 89.4 | 88.9 | 89.16 | 2508200.0 |
| 2002-09-13 15:00:00 | SPY | ETF | 89.16 | 89.56 | 89.06 | 89.47 | 2961600.0 |
| 2002-09-13 15:30:00 | SPY | ETF | 89.47 | 89.85 | 89.36 | 89.54 | 2863600.0 |
| 2002-09-13 16:00:00 | SPY | ETF | 89.48 | 89.8 | 89.42 | 89.67 | 1287300.0 |
| 2002-09-13 09:30:00 | QQQ | ETF | 22.6 | 22.8 | 22.52 | 22.78 | 14819700.0 |
| 2002-09-13 10:00:00 | QQQ | ETF | 22.77 | 23.08 | 22.65 | 22.92 | 12532100.0 |
| 2002-09-13 10:30:00 | QQQ | ETF | 22.95 | 23.03 | 22.72 | 22.82 | 6906600.0 |
| 2002-09-13 11:00:00 | QQQ | ETF | 22.81 | 22.84 | 22.56 | 22.58 | 5219000.0 |
| 2002-09-13 11:30:00 | QQQ | ETF | 22.61 | 22.88 | 22.58 | 22.86 | 3530200.0 |
| 2002-09-13 12:00:00 | QQQ | ETF | 22.85 | 22.89 | 22.73 | 22.85 | 2766700.0 |
| 2002-09-13 12:30:00 | QQQ | ETF | 22.85 | 22.98 | 22.8 | 22.94 | 3084300.0 |
| 2002-09-13 13:00:00 | QQQ | ETF | 22.94 | 23.07 | 22.85 | 22.88 | 4882200.0 |
| 2002-09-13 13:30:00 | QQQ | ETF | 22.88 | 23.0 | 22.82 | 22.84 | 3714300.0 |
| 2002-09-13 14:00:00 | QQQ | ETF | 22.84 | 22.91 | 22.73 | 22.75 | 3180800.0 |
| 2002-09-13 14:30:00 | QQQ | ETF | 22.75 | 22.92 | 22.71 | 22.87 | 3572000.0 |
| 2002-09-13 15:00:00 | QQQ | ETF | 22.85 | 23.01 | 22.8 | 22.92 | 3264700.0 |
| 2002-09-13 15:30:00 | QQQ | ETF | 22.92 | 23.03 | 22.85 | 22.95 | 5986600.0 |
| 2002-09-13 16:00:00 | QQQ | ETF | 22.95 | 23.03 | 22.94 | 22.99 | 1314400.0 |
| 2002-09-13 09:30:00 | IWM | ETF | 38.3 | 38.3 | 38.125 | 38.2 | 320000.0 |
| 2002-09-13 10:00:00 | IWM | ETF | 38.215 | 38.48 | 38.2 | 38.37 | 171800.0 |
| 2002-09-13 10:30:00 | IWM | ETF | 38.37 | 38.61 | 38.36 | 38.545 | 130800.0 |
| 2002-09-13 11:00:00 | IWM | ETF | 38.475 | 38.555 | 38.375 | 38.375 | 80200.0 |
| 2002-09-13 11:30:00 | IWM | ETF | 38.38 | 38.52 | 38.38 | 38.52 | 47200.0 |
| 2002-09-13 12:00:00 | IWM | ETF | 38.52 | 38.54 | 38.445 | 38.5 | 49600.0 |
| 2002-09-13 12:30:00 | IWM | ETF | 38.54 | 38.59 | 38.52 | 38.59 | 37000.0 |
| 2002-09-13 13:00:00 | IWM | ETF | 38.515 | 38.64 | 38.515 | 38.635 | 61800.0 |
| 2002-09-13 13:30:00 | IWM | ETF | 38.64 | 38.7 | 38.625 | 38.63 | 56600.0 |
| 2002-09-13 14:00:00 | IWM | ETF | 38.65 | 38.7 | 38.57 | 38.57 | 41000.0 |
| 2002-09-13 14:30:00 | IWM | ETF | 38.57 | 38.67 | 38.51 | 38.585 | 98200.0 |
| 2002-09-13 15:00:00 | IWM | ETF | 38.6 | 38.775 | 38.6 | 38.775 | 112400.0 |
| 2002-09-13 15:30:00 | IWM | ETF | 38.72 | 38.86 | 38.72 | 38.775 | 123000.0 |
| 2002-09-13 16:00:00 | IWM | ETF | 38.86 | 38.86 | 38.825 | 38.85 | 74000.0 |
| 2002-09-13 09:30:00 | DIA | ETF | 83.44 | 83.44 | 82.7 | 82.98 | 1801100.0 |
| 2002-09-13 10:00:00 | DIA | ETF | 82.9 | 83.48 | 82.77 | 83.3 | 1480200.0 |
| 2002-09-13 10:30:00 | DIA | ETF | 83.32 | 83.73 | 83.13 | 83.23 | 1004400.0 |
| 2002-09-13 11:00:00 | DIA | ETF | 83.22 | 83.28 | 82.77 | 82.9 | 609300.0 |
| 2002-09-13 11:30:00 | DIA | ETF | 82.92 | 83.45 | 82.9 | 83.4 | 573800.0 |
| 2002-09-13 12:00:00 | DIA | ETF | 83.36 | 83.48 | 83.15 | 83.42 | 241500.0 |
| 2002-09-13 12:30:00 | DIA | ETF | 83.43 | 83.66 | 83.21 | 83.6 | 356800.0 |
| 2002-09-13 13:00:00 | DIA | ETF | 83.6 | 83.87 | 83.36 | 83.59 | 411500.0 |
> showing 50 of 521 rows — these rows as CSV