PREVIEW / etf_30min / 2004-11-15
file: by_date/etf_30min/2004/2004-11-15.parquet size: 39 KB rows: 1,370
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-11-15 08:00:00 | SPY | ETF | 118.55 | 118.55 | 118.4 | 118.44 | 64300.0 |
| 2004-11-15 08:30:00 | SPY | ETF | 118.42 | 118.52 | 118.41 | 118.49 | 53300.0 |
| 2004-11-15 09:00:00 | SPY | ETF | 118.47 | 118.58 | 118.44 | 118.49 | 58000.0 |
| 2004-11-15 09:30:00 | SPY | ETF | 118.5 | 118.58 | 118.28 | 118.46 | 5357800.0 |
| 2004-11-15 10:00:00 | SPY | ETF | 118.46 | 118.64 | 118.44 | 118.53 | 4703900.0 |
| 2004-11-15 10:30:00 | SPY | ETF | 118.52 | 118.69 | 118.37 | 118.43 | 3415800.0 |
| 2004-11-15 11:00:00 | SPY | ETF | 118.43 | 118.44 | 118.23 | 118.27 | 3434600.0 |
| 2004-11-15 11:30:00 | SPY | ETF | 118.27 | 118.48 | 118.23 | 118.48 | 1557300.0 |
| 2004-11-15 12:00:00 | SPY | ETF | 118.46 | 118.51 | 118.33 | 118.45 | 1504800.0 |
| 2004-11-15 12:30:00 | SPY | ETF | 118.45 | 118.73 | 118.42 | 118.72 | 1976900.0 |
| 2004-11-15 13:00:00 | SPY | ETF | 118.72 | 118.73 | 118.5 | 118.54 | 1240600.0 |
| 2004-11-15 13:30:00 | SPY | ETF | 118.51 | 118.64 | 118.33 | 118.37 | 1311700.0 |
| 2004-11-15 14:00:00 | SPY | ETF | 118.36 | 118.53 | 118.3 | 118.5 | 2567500.0 |
| 2004-11-15 14:30:00 | SPY | ETF | 118.5 | 118.61 | 118.39 | 118.42 | 1711700.0 |
| 2004-11-15 15:00:00 | SPY | ETF | 118.41 | 118.68 | 118.39 | 118.53 | 1776400.0 |
| 2004-11-15 15:30:00 | SPY | ETF | 118.51 | 118.67 | 118.4 | 118.67 | 2371400.0 |
| 2004-11-15 16:00:00 | SPY | ETF | 118.67 | 118.77 | 118.61 | 118.68 | 1564800.0 |
| 2004-11-15 16:30:00 | SPY | ETF | 118.7 | 118.73 | 118.68 | 118.73 | 114400.0 |
| 2004-11-15 17:00:00 | SPY | ETF | 118.73 | 118.75 | 118.6 | 118.72 | 79100.0 |
| 2004-11-15 17:30:00 | SPY | ETF | 118.72 | 118.72 | 118.7 | 118.71 | 1400.0 |
| 2004-11-15 08:00:00 | QQQ | ETF | 38.62 | 38.62 | 38.55 | 38.55 | 67300.0 |
| 2004-11-15 08:30:00 | QQQ | ETF | 38.56 | 38.63 | 38.55 | 38.6 | 155200.0 |
| 2004-11-15 09:00:00 | QQQ | ETF | 38.6 | 38.69 | 38.6 | 38.65 | 165900.0 |
| 2004-11-15 09:30:00 | QQQ | ETF | 38.64 | 38.68 | 38.53 | 38.62 | 12859400.0 |
| 2004-11-15 10:00:00 | QQQ | ETF | 38.629 | 38.71 | 38.61 | 38.661 | 6559700.0 |
| 2004-11-15 10:30:00 | QQQ | ETF | 38.66 | 38.78 | 38.66 | 38.73 | 7626900.0 |
| 2004-11-15 11:00:00 | QQQ | ETF | 38.73 | 38.73 | 38.57 | 38.61 | 7442000.0 |
| 2004-11-15 11:30:00 | QQQ | ETF | 38.61 | 38.73 | 38.59 | 38.73 | 3453200.0 |
| 2004-11-15 12:00:00 | QQQ | ETF | 38.72 | 38.74 | 38.66 | 38.72 | 3415200.0 |
| 2004-11-15 12:30:00 | QQQ | ETF | 38.73 | 38.859 | 38.717 | 38.85 | 6912300.0 |
| 2004-11-15 13:00:00 | QQQ | ETF | 38.85 | 38.86 | 38.76 | 38.78 | 4878800.0 |
| 2004-11-15 13:30:00 | QQQ | ETF | 38.78 | 38.84 | 38.719 | 38.72 | 4061400.0 |
| 2004-11-15 14:00:00 | QQQ | ETF | 38.72 | 38.77 | 38.68 | 38.756 | 4639300.0 |
| 2004-11-15 14:30:00 | QQQ | ETF | 38.755 | 38.79 | 38.66 | 38.67 | 4272500.0 |
| 2004-11-15 15:00:00 | QQQ | ETF | 38.67 | 38.78 | 38.67 | 38.75 | 5119300.0 |
| 2004-11-15 15:30:00 | QQQ | ETF | 38.75 | 38.81 | 38.69 | 38.8 | 8246800.0 |
| 2004-11-15 16:00:00 | QQQ | ETF | 38.794 | 38.84 | 38.79 | 38.83 | 2044600.0 |
| 2004-11-15 16:30:00 | QQQ | ETF | 38.83 | 38.85 | 38.82 | 38.839 | 393600.0 |
| 2004-11-15 17:00:00 | QQQ | ETF | 38.84 | 38.84 | 38.82 | 38.83 | 21000.0 |
| 2004-11-15 17:30:00 | QQQ | ETF | 38.83 | 38.85 | 38.83 | 38.85 | 13600.0 |
| 2004-11-15 18:00:00 | QQQ | ETF | 38.84 | 38.84 | 38.81 | 38.81 | 14200.0 |
| 2004-11-15 18:30:00 | QQQ | ETF | 38.84 | 38.85 | 38.84 | 38.85 | 400.0 |
| 2004-11-15 19:00:00 | QQQ | ETF | 38.84 | 38.85 | 38.84 | 38.85 | 300.0 |
| 2004-11-15 19:30:00 | QQQ | ETF | 38.85 | 38.86 | 38.84 | 38.86 | 40300.0 |
| 2004-11-15 09:30:00 | IWM | ETF | 61.95 | 62.025 | 61.75 | 61.95 | 1537200.0 |
| 2004-11-15 10:00:00 | IWM | ETF | 61.975 | 62.08 | 61.925 | 61.935 | 577200.0 |
| 2004-11-15 10:30:00 | IWM | ETF | 61.94 | 62.04 | 61.88 | 61.885 | 1226200.0 |
| 2004-11-15 11:00:00 | IWM | ETF | 61.885 | 61.885 | 61.715 | 61.72 | 642800.0 |
| 2004-11-15 11:30:00 | IWM | ETF | 61.71 | 61.89 | 61.675 | 61.88 | 247400.0 |
| 2004-11-15 12:00:00 | IWM | ETF | 61.875 | 61.97 | 61.86 | 61.905 | 602600.0 |
> showing 50 of 1,370 rows — these rows as CSV