PREVIEW / etf_30min / 2005-06-20
file: by_date/etf_30min/2005/2005-06-20.parquet size: 43 KB rows: 1,512
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-20 06:30:00 | SPY | ETF | 121.15 | 121.16 | 121.15 | 121.16 | 4000.0 |
| 2005-06-20 07:00:00 | SPY | ETF | 121.13 | 121.15 | 121.12 | 121.15 | 4700.0 |
| 2005-06-20 07:30:00 | SPY | ETF | 121.13 | 121.16 | 121.13 | 121.16 | 3100.0 |
| 2005-06-20 08:00:00 | SPY | ETF | 121.16 | 121.16 | 121.05 | 121.09 | 402300.0 |
| 2005-06-20 08:30:00 | SPY | ETF | 121.11 | 121.13 | 121.09 | 121.1 | 25300.0 |
| 2005-06-20 09:00:00 | SPY | ETF | 121.12 | 121.15 | 121.04 | 121.08 | 92600.0 |
| 2005-06-20 09:30:00 | SPY | ETF | 121.08 | 121.2 | 121.04 | 121.14 | 4282100.0 |
| 2005-06-20 10:00:00 | SPY | ETF | 121.15 | 121.15 | 120.94 | 121.02 | 3993700.0 |
| 2005-06-20 10:30:00 | SPY | ETF | 121.02 | 121.34 | 120.98 | 121.22 | 4210800.0 |
| 2005-06-20 11:00:00 | SPY | ETF | 121.22 | 121.3 | 121.08 | 121.15 | 2064800.0 |
| 2005-06-20 11:30:00 | SPY | ETF | 121.15 | 121.3 | 121.07 | 121.28 | 1292000.0 |
| 2005-06-20 12:00:00 | SPY | ETF | 121.28 | 121.35 | 121.22 | 121.27 | 1531800.0 |
| 2005-06-20 12:30:00 | SPY | ETF | 121.27 | 121.34 | 121.22 | 121.25 | 881100.0 |
| 2005-06-20 13:00:00 | SPY | ETF | 121.24 | 121.31 | 121.15 | 121.18 | 1381500.0 |
| 2005-06-20 13:30:00 | SPY | ETF | 121.19 | 121.33 | 121.12 | 121.27 | 1235000.0 |
| 2005-06-20 14:00:00 | SPY | ETF | 121.27 | 121.4 | 121.17 | 121.4 | 2189100.0 |
| 2005-06-20 14:30:00 | SPY | ETF | 121.4 | 121.62 | 121.3 | 121.57 | 3743600.0 |
| 2005-06-20 15:00:00 | SPY | ETF | 121.57 | 121.84 | 121.49 | 121.74 | 6184800.0 |
| 2005-06-20 15:30:00 | SPY | ETF | 121.74 | 121.76 | 121.49 | 121.5 | 5652100.0 |
| 2005-06-20 16:00:00 | SPY | ETF | 121.49 | 121.539 | 121.39 | 121.45 | 862300.0 |
| 2005-06-20 16:30:00 | SPY | ETF | 121.42 | 121.46 | 121.39 | 121.42 | 1163200.0 |
| 2005-06-20 17:00:00 | SPY | ETF | 121.41 | 121.42 | 121.4 | 121.42 | 7700.0 |
| 2005-06-20 17:30:00 | SPY | ETF | 121.45 | 121.45 | 121.45 | 121.45 | 2600.0 |
| 2005-06-20 18:00:00 | SPY | ETF | 121.45 | 121.47 | 121.45 | 121.47 | 34600.0 |
| 2005-06-20 18:30:00 | SPY | ETF | 121.48 | 121.48 | 121.45 | 121.45 | 4200.0 |
| 2005-06-20 19:00:00 | SPY | ETF | 121.45 | 121.46 | 121.44 | 121.46 | 900.0 |
| 2005-06-20 19:30:00 | SPY | ETF | 121.46 | 121.47 | 121.43 | 121.43 | 3300.0 |
| 2005-06-20 09:30:00 | QQQ | ETF | 37.72 | 37.76 | 37.68 | 37.74 | 7963600.0 |
| 2005-06-20 10:00:00 | QQQ | ETF | 37.73 | 37.74 | 37.58 | 37.69 | 8153500.0 |
| 2005-06-20 10:30:00 | QQQ | ETF | 37.68 | 37.83 | 37.67 | 37.75 | 6821300.0 |
| 2005-06-20 11:00:00 | QQQ | ETF | 37.74 | 37.8 | 37.71 | 37.74 | 4012200.0 |
| 2005-06-20 11:30:00 | QQQ | ETF | 37.74 | 37.83 | 37.71 | 37.82 | 2906600.0 |
| 2005-06-20 12:00:00 | QQQ | ETF | 37.83 | 37.89 | 37.82 | 37.84 | 4993400.0 |
| 2005-06-20 12:30:00 | QQQ | ETF | 37.84 | 37.88 | 37.81 | 37.82 | 2500600.0 |
| 2005-06-20 13:00:00 | QQQ | ETF | 37.82 | 37.82 | 37.75 | 37.78 | 2200900.0 |
| 2005-06-20 13:30:00 | QQQ | ETF | 37.77 | 37.84 | 37.74 | 37.82 | 1603000.0 |
| 2005-06-20 14:00:00 | QQQ | ETF | 37.81 | 37.86 | 37.78 | 37.86 | 2040200.0 |
| 2005-06-20 14:30:00 | QQQ | ETF | 37.86 | 37.97 | 37.82 | 37.95 | 6071700.0 |
| 2005-06-20 15:00:00 | QQQ | ETF | 37.95 | 38.08 | 37.92 | 38.0 | 7573600.0 |
| 2005-06-20 15:30:00 | QQQ | ETF | 38.0 | 38.02 | 37.86 | 37.87 | 5792300.0 |
| 2005-06-20 07:30:00 | IWM | ETF | 63.74 | 63.74 | 63.71 | 63.71 | 7000.0 |
| 2005-06-20 08:00:00 | IWM | ETF | 63.7 | 63.72 | 63.63 | 63.72 | 14100.0 |
| 2005-06-20 08:30:00 | IWM | ETF | 63.72 | 63.73 | 63.63 | 63.63 | 9900.0 |
| 2005-06-20 09:00:00 | IWM | ETF | 63.65 | 63.75 | 63.65 | 63.75 | 29500.0 |
| 2005-06-20 09:30:00 | IWM | ETF | 63.72 | 63.95 | 63.72 | 63.94 | 2693600.0 |
| 2005-06-20 10:00:00 | IWM | ETF | 63.93 | 63.93 | 63.62 | 63.74 | 3543800.0 |
| 2005-06-20 10:30:00 | IWM | ETF | 63.73 | 63.88 | 63.58 | 63.64 | 1983700.0 |
| 2005-06-20 11:00:00 | IWM | ETF | 63.64 | 63.75 | 63.56 | 63.61 | 1862700.0 |
| 2005-06-20 11:30:00 | IWM | ETF | 63.61 | 63.85 | 63.59 | 63.84 | 1099500.0 |
| 2005-06-20 12:00:00 | IWM | ETF | 63.83 | 63.86 | 63.72 | 63.8 | 1021500.0 |
> showing 50 of 1,512 rows — these rows as CSV