PREVIEW / etf_30min / 2001-03-21
file: by_date/etf_30min/2001/2001-03-21.parquet size: 15 KB rows: 366
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-21 09:30:00 | SPY | ETF | 114.18 | 114.44 | 113.31 | 113.52 | 2587200.0 |
| 2001-03-21 10:00:00 | SPY | ETF | 113.45 | 114.95 | 113.06 | 114.5 | 2443400.0 |
| 2001-03-21 10:30:00 | SPY | ETF | 114.65 | 115.26 | 114.21 | 114.8 | 663700.0 |
| 2001-03-21 11:00:00 | SPY | ETF | 114.67 | 114.9 | 113.74 | 113.94 | 706300.0 |
| 2001-03-21 11:30:00 | SPY | ETF | 114.08 | 114.4 | 113.58 | 113.69 | 1281600.0 |
| 2001-03-21 12:00:00 | SPY | ETF | 113.68 | 113.76 | 113.11 | 113.23 | 617500.0 |
| 2001-03-21 12:30:00 | SPY | ETF | 113.34 | 114.12 | 113.11 | 113.84 | 1081600.0 |
| 2001-03-21 13:00:00 | SPY | ETF | 113.85 | 114.02 | 113.0 | 113.01 | 1062200.0 |
| 2001-03-21 13:30:00 | SPY | ETF | 113.04 | 113.87 | 112.98 | 113.53 | 526200.0 |
| 2001-03-21 14:00:00 | SPY | ETF | 113.44 | 114.25 | 113.34 | 114.1 | 508500.0 |
| 2001-03-21 14:30:00 | SPY | ETF | 114.23 | 114.48 | 113.54 | 113.55 | 1040800.0 |
| 2001-03-21 15:00:00 | SPY | ETF | 113.6 | 114.08 | 112.82 | 112.98 | 1650700.0 |
| 2001-03-21 15:30:00 | SPY | ETF | 112.99 | 113.1 | 111.9 | 112.34 | 2053500.0 |
| 2001-03-21 16:00:00 | SPY | ETF | 112.31 | 112.4 | 112.21 | 112.26 | 310800.0 |
| 2001-03-21 16:30:00 | SPY | ETF | 114.25 | 114.25 | 112.26 | 112.4 | 240700.0 |
| 2001-03-21 17:00:00 | SPY | ETF | 112.41 | 112.5 | 112.35 | 112.5 | 430500.0 |
| 2001-03-21 17:30:00 | SPY | ETF | 112.13 | 112.13 | 112.13 | 112.13 | 100.0 |
| 2001-03-21 09:30:00 | QQQ | ETF | 40.52 | 40.84 | 39.95 | 40.25 | 11926100.0 |
| 2001-03-21 10:00:00 | QQQ | ETF | 40.25 | 41.65 | 40.0 | 41.41 | 10877900.0 |
| 2001-03-21 10:30:00 | QQQ | ETF | 41.41 | 41.95 | 41.07 | 41.25 | 5521800.0 |
| 2001-03-21 11:00:00 | QQQ | ETF | 41.18 | 41.43 | 40.66 | 40.94 | 6252700.0 |
| 2001-03-21 11:30:00 | QQQ | ETF | 40.9 | 41.09 | 40.3 | 40.4 | 4236700.0 |
| 2001-03-21 12:00:00 | QQQ | ETF | 40.4 | 40.5 | 40.0 | 40.19 | 5434300.0 |
| 2001-03-21 12:30:00 | QQQ | ETF | 40.08 | 40.72 | 39.99 | 40.51 | 3497600.0 |
| 2001-03-21 13:00:00 | QQQ | ETF | 40.55 | 40.64 | 39.75 | 39.85 | 4431400.0 |
| 2001-03-21 13:30:00 | QQQ | ETF | 39.82 | 40.56 | 39.71 | 40.3 | 4523500.0 |
| 2001-03-21 14:00:00 | QQQ | ETF | 40.3 | 41.2 | 40.01 | 41.05 | 7751100.0 |
| 2001-03-21 14:30:00 | QQQ | ETF | 41.06 | 41.34 | 40.52 | 40.57 | 7994000.0 |
| 2001-03-21 15:00:00 | QQQ | ETF | 40.6 | 40.9 | 40.11 | 40.2 | 9750200.0 |
| 2001-03-21 15:30:00 | QQQ | ETF | 40.25 | 40.35 | 39.79 | 40.1 | 8306800.0 |
| 2001-03-21 16:00:00 | QQQ | ETF | 40.01 | 40.4 | 39.94 | 40.3 | 2746100.0 |
| 2001-03-21 16:30:00 | QQQ | ETF | 40.33 | 40.47 | 40.0 | 40.3 | 56400.0 |
| 2001-03-21 17:00:00 | QQQ | ETF | 40.26 | 40.38 | 40.12 | 40.32 | 27400.0 |
| 2001-03-21 17:30:00 | QQQ | ETF | 40.3 | 40.48 | 40.25 | 40.36 | 19300.0 |
| 2001-03-21 18:00:00 | QQQ | ETF | 40.36 | 40.59 | 40.36 | 40.5 | 180600.0 |
| 2001-03-21 09:30:00 | IWM | ETF | 44.125 | 44.15 | 43.95 | 43.95 | 17200.0 |
| 2001-03-21 10:00:00 | IWM | ETF | 43.95 | 44.2 | 43.7 | 44.0 | 121800.0 |
| 2001-03-21 10:30:00 | IWM | ETF | 44.075 | 44.3 | 44.05 | 44.13 | 63800.0 |
| 2001-03-21 11:00:00 | IWM | ETF | 44.0 | 44.0 | 43.8 | 43.8 | 13000.0 |
| 2001-03-21 11:30:00 | IWM | ETF | 44.0 | 44.0 | 43.775 | 43.8 | 21800.0 |
| 2001-03-21 12:00:00 | IWM | ETF | 43.775 | 43.775 | 43.5 | 43.625 | 57200.0 |
| 2001-03-21 12:30:00 | IWM | ETF | 43.65 | 43.9 | 43.5 | 43.725 | 84800.0 |
| 2001-03-21 13:00:00 | IWM | ETF | 43.725 | 43.75 | 43.475 | 43.475 | 14200.0 |
| 2001-03-21 13:30:00 | IWM | ETF | 43.675 | 43.675 | 43.675 | 43.675 | 1000.0 |
| 2001-03-21 14:00:00 | IWM | ETF | 43.7 | 43.825 | 43.625 | 43.625 | 1600.0 |
| 2001-03-21 14:30:00 | IWM | ETF | 43.9 | 43.95 | 43.745 | 43.95 | 8000.0 |
| 2001-03-21 15:00:00 | IWM | ETF | 43.5 | 43.75 | 43.495 | 43.495 | 5400.0 |
| 2001-03-21 15:30:00 | IWM | ETF | 43.475 | 43.475 | 43.075 | 43.37 | 74000.0 |
| 2001-03-21 16:00:00 | IWM | ETF | 43.375 | 43.45 | 43.375 | 43.425 | 4200.0 |
| 2001-03-21 09:30:00 | DIA | ETF | 96.96 | 96.96 | 95.88 | 95.94 | 1339700.0 |
> showing 50 of 366 rows — these rows as CSV