PREVIEW / etf_30min / 2004-12-22
file: by_date/etf_30min/2004/2004-12-22.parquet size: 39 KB rows: 1,374
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-22 08:00:00 | SPY | ETF | 120.52 | 120.6 | 120.52 | 120.6 | 60700.0 |
| 2004-12-22 08:30:00 | SPY | ETF | 120.6 | 120.6 | 120.46 | 120.46 | 64800.0 |
| 2004-12-22 09:00:00 | SPY | ETF | 120.47 | 120.49 | 120.37 | 120.37 | 12900.0 |
| 2004-12-22 09:30:00 | SPY | ETF | 120.38 | 120.59 | 120.32 | 120.42 | 3490700.0 |
| 2004-12-22 10:00:00 | SPY | ETF | 120.43 | 120.59 | 120.37 | 120.55 | 1604600.0 |
| 2004-12-22 10:30:00 | SPY | ETF | 120.52 | 121.08 | 120.52 | 120.93 | 4892300.0 |
| 2004-12-22 11:00:00 | SPY | ETF | 120.92 | 120.98 | 120.78 | 120.85 | 2727600.0 |
| 2004-12-22 11:30:00 | SPY | ETF | 120.85 | 120.93 | 120.7 | 120.83 | 2201400.0 |
| 2004-12-22 12:00:00 | SPY | ETF | 120.83 | 120.9 | 120.78 | 120.81 | 1398900.0 |
| 2004-12-22 12:30:00 | SPY | ETF | 120.8 | 120.92 | 120.72 | 120.9 | 1285800.0 |
| 2004-12-22 13:00:00 | SPY | ETF | 120.89 | 120.9 | 120.74 | 120.79 | 738200.0 |
| 2004-12-22 13:30:00 | SPY | ETF | 120.79 | 120.88 | 120.55 | 120.61 | 1630600.0 |
| 2004-12-22 14:00:00 | SPY | ETF | 120.61 | 120.78 | 120.51 | 120.7 | 1158500.0 |
| 2004-12-22 14:30:00 | SPY | ETF | 120.7 | 120.72 | 120.56 | 120.69 | 1550400.0 |
| 2004-12-22 15:00:00 | SPY | ETF | 120.68 | 120.85 | 120.66 | 120.75 | 1571200.0 |
| 2004-12-22 15:30:00 | SPY | ETF | 120.81 | 120.93 | 120.74 | 120.91 | 2513000.0 |
| 2004-12-22 16:00:00 | SPY | ETF | 120.91 | 120.96 | 120.66 | 120.68 | 3756100.0 |
| 2004-12-22 16:30:00 | SPY | ETF | 120.71 | 120.74 | 120.68 | 120.71 | 95200.0 |
| 2004-12-22 17:00:00 | SPY | ETF | 120.71 | 120.74 | 120.71 | 120.74 | 11300.0 |
| 2004-12-22 17:30:00 | SPY | ETF | 120.72 | 120.72 | 120.72 | 120.72 | 300.0 |
| 2004-12-22 18:00:00 | SPY | ETF | 120.75 | 120.77 | 120.75 | 120.77 | 1900.0 |
| 2004-12-22 19:30:00 | SPY | ETF | 120.72 | 120.72 | 120.69 | 120.69 | 900.0 |
| 2004-12-22 08:00:00 | QQQ | ETF | 39.65 | 39.7 | 39.64 | 39.67 | 43004.0 |
| 2004-12-22 08:30:00 | QQQ | ETF | 39.67 | 39.671 | 39.56 | 39.57 | 224734.0 |
| 2004-12-22 09:00:00 | QQQ | ETF | 39.57 | 39.6 | 39.53 | 39.531 | 316715.0 |
| 2004-12-22 09:30:00 | QQQ | ETF | 39.535 | 39.673 | 39.517 | 39.569 | 11338047.0 |
| 2004-12-22 10:00:00 | QQQ | ETF | 39.57 | 39.6 | 39.488 | 39.55 | 7865645.0 |
| 2004-12-22 10:30:00 | QQQ | ETF | 39.56 | 39.93 | 39.55 | 39.831 | 13053080.0 |
| 2004-12-22 11:00:00 | QQQ | ETF | 39.84 | 39.88 | 39.68 | 39.7 | 7852122.0 |
| 2004-12-22 11:30:00 | QQQ | ETF | 39.7 | 39.75 | 39.68 | 39.724 | 3329125.0 |
| 2004-12-22 12:00:00 | QQQ | ETF | 39.724 | 39.76 | 39.7 | 39.7 | 1602598.0 |
| 2004-12-22 12:30:00 | QQQ | ETF | 39.71 | 39.74 | 39.64 | 39.729 | 2080167.0 |
| 2004-12-22 13:00:00 | QQQ | ETF | 39.72 | 39.73 | 39.679 | 39.712 | 1188223.0 |
| 2004-12-22 13:30:00 | QQQ | ETF | 39.71 | 39.72 | 39.596 | 39.619 | 3067147.0 |
| 2004-12-22 14:00:00 | QQQ | ETF | 39.61 | 39.7 | 39.61 | 39.65 | 4307035.0 |
| 2004-12-22 14:30:00 | QQQ | ETF | 39.65 | 39.68 | 39.61 | 39.66 | 3349206.0 |
| 2004-12-22 15:00:00 | QQQ | ETF | 39.667 | 39.75 | 39.66 | 39.72 | 4218402.0 |
| 2004-12-22 15:30:00 | QQQ | ETF | 39.71 | 39.77 | 39.68 | 39.75 | 6624558.0 |
| 2004-12-22 16:00:00 | QQQ | ETF | 39.73 | 39.75 | 39.6 | 39.65 | 2525808.0 |
| 2004-12-22 16:30:00 | QQQ | ETF | 39.65 | 39.66 | 39.63 | 39.64 | 119586.0 |
| 2004-12-22 17:00:00 | QQQ | ETF | 39.64 | 39.664 | 39.63 | 39.664 | 262125.0 |
| 2004-12-22 17:30:00 | QQQ | ETF | 39.65 | 39.68 | 39.65 | 39.65 | 6898.0 |
| 2004-12-22 18:00:00 | QQQ | ETF | 39.65 | 39.653 | 39.63 | 39.65 | 8609.0 |
| 2004-12-22 08:30:00 | IWM | ETF | 64.54 | 64.54 | 64.54 | 64.54 | 2000.0 |
| 2004-12-22 09:30:00 | IWM | ETF | 64.51 | 64.72 | 64.44 | 64.655 | 1102400.0 |
| 2004-12-22 10:00:00 | IWM | ETF | 64.655 | 64.745 | 64.595 | 64.67 | 714000.0 |
| 2004-12-22 10:30:00 | IWM | ETF | 64.685 | 64.925 | 64.685 | 64.875 | 1034800.0 |
| 2004-12-22 11:00:00 | IWM | ETF | 64.875 | 64.91 | 64.7 | 64.735 | 553800.0 |
| 2004-12-22 11:30:00 | IWM | ETF | 64.73 | 64.76 | 64.645 | 64.705 | 256800.0 |
| 2004-12-22 12:00:00 | IWM | ETF | 64.71 | 64.78 | 64.71 | 64.72 | 303600.0 |
> showing 50 of 1,374 rows — these rows as CSV