PREVIEW / etf_30min / 2006-02-21
file: by_date/etf_30min/2006/2006-02-21.parquet size: 59 KB rows: 2,172
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-21 04:30:00 | SPY | ETF | 129.0 | 129.0 | 129.0 | 129.0 | 100.0 |
| 2006-02-21 05:30:00 | SPY | ETF | 129.23 | 129.23 | 129.23 | 129.23 | 100.0 |
| 2006-02-21 06:30:00 | SPY | ETF | 129.2 | 129.25 | 129.2 | 129.25 | 50100.0 |
| 2006-02-21 07:00:00 | SPY | ETF | 129.25 | 129.3 | 129.2 | 129.3 | 75700.0 |
| 2006-02-21 07:30:00 | SPY | ETF | 129.31 | 129.31 | 129.2 | 129.21 | 82600.0 |
| 2006-02-21 08:00:00 | SPY | ETF | 129.27 | 129.3 | 129.15 | 129.18 | 348500.0 |
| 2006-02-21 08:30:00 | SPY | ETF | 129.18 | 129.23 | 129.15 | 129.16 | 330900.0 |
| 2006-02-21 09:00:00 | SPY | ETF | 129.16 | 129.26 | 129.1 | 129.12 | 115200.0 |
| 2006-02-21 09:30:00 | SPY | ETF | 129.12 | 129.4 | 129.06 | 129.09 | 5263100.0 |
| 2006-02-21 10:00:00 | SPY | ETF | 129.07 | 129.2 | 128.48 | 128.58 | 7761900.0 |
| 2006-02-21 10:30:00 | SPY | ETF | 128.57 | 128.81 | 128.54 | 128.7 | 3474800.0 |
| 2006-02-21 11:00:00 | SPY | ETF | 128.7 | 128.87 | 128.67 | 128.78 | 1177800.0 |
| 2006-02-21 11:30:00 | SPY | ETF | 128.78 | 128.85 | 128.38 | 128.43 | 3010900.0 |
| 2006-02-21 12:00:00 | SPY | ETF | 128.43 | 128.52 | 128.34 | 128.45 | 2648300.0 |
| 2006-02-21 12:30:00 | SPY | ETF | 128.45 | 128.65 | 128.4 | 128.4 | 1891800.0 |
| 2006-02-21 13:00:00 | SPY | ETF | 128.41 | 128.62 | 128.31 | 128.5 | 1621700.0 |
| 2006-02-21 13:30:00 | SPY | ETF | 128.51 | 128.62 | 128.42 | 128.46 | 2267700.0 |
| 2006-02-21 14:00:00 | SPY | ETF | 128.46 | 128.71 | 128.29 | 128.42 | 4311100.0 |
| 2006-02-21 14:30:00 | SPY | ETF | 128.41 | 128.59 | 128.33 | 128.41 | 2918800.0 |
| 2006-02-21 15:00:00 | SPY | ETF | 128.4 | 128.69 | 128.39 | 128.56 | 1711000.0 |
| 2006-02-21 15:30:00 | SPY | ETF | 128.57 | 128.72 | 128.47 | 128.53 | 3149800.0 |
| 2006-02-21 16:00:00 | SPY | ETF | 128.53 | 128.59 | 128.46 | 128.48 | 1059000.0 |
| 2006-02-21 16:30:00 | SPY | ETF | 128.51 | 128.53 | 128.48 | 128.48 | 517500.0 |
| 2006-02-21 17:00:00 | SPY | ETF | 128.47 | 128.49 | 128.43 | 128.49 | 5700.0 |
| 2006-02-21 17:30:00 | SPY | ETF | 128.49 | 128.55 | 128.49 | 128.55 | 5100.0 |
| 2006-02-21 18:00:00 | SPY | ETF | 128.5 | 128.5 | 128.47 | 128.47 | 5500.0 |
| 2006-02-21 19:30:00 | SPY | ETF | 128.56 | 128.56 | 128.56 | 128.56 | 200.0 |
| 2006-02-21 09:30:00 | QQQ | ETF | 41.21 | 41.27 | 41.05 | 41.06 | 10524800.0 |
| 2006-02-21 10:00:00 | QQQ | ETF | 41.07 | 41.08 | 40.73 | 40.77 | 12253100.0 |
| 2006-02-21 10:30:00 | QQQ | ETF | 40.77 | 40.89 | 40.75 | 40.85 | 11182900.0 |
| 2006-02-21 11:00:00 | QQQ | ETF | 40.86 | 40.95 | 40.84 | 40.87 | 4240000.0 |
| 2006-02-21 11:30:00 | QQQ | ETF | 40.88 | 40.91 | 40.73 | 40.75 | 3668500.0 |
| 2006-02-21 12:00:00 | QQQ | ETF | 40.74 | 40.76 | 40.66 | 40.73 | 5112500.0 |
| 2006-02-21 12:30:00 | QQQ | ETF | 40.73 | 40.89 | 40.69 | 40.72 | 4363000.0 |
| 2006-02-21 13:00:00 | QQQ | ETF | 40.71 | 40.76 | 40.61 | 40.67 | 4915500.0 |
| 2006-02-21 13:30:00 | QQQ | ETF | 40.67 | 40.76 | 40.67 | 40.67 | 2930700.0 |
| 2006-02-21 14:00:00 | QQQ | ETF | 40.68 | 40.79 | 40.64 | 40.69 | 4742600.0 |
| 2006-02-21 14:30:00 | QQQ | ETF | 40.69 | 40.77 | 40.67 | 40.74 | 4255000.0 |
| 2006-02-21 15:00:00 | QQQ | ETF | 40.75 | 40.83 | 40.74 | 40.81 | 3014800.0 |
| 2006-02-21 15:30:00 | QQQ | ETF | 40.81 | 40.86 | 40.73 | 40.73 | 6546200.0 |
| 2006-02-21 08:30:00 | IWM | ETF | 72.74 | 72.74 | 72.74 | 72.74 | 200.0 |
| 2006-02-21 09:00:00 | IWM | ETF | 72.75 | 72.77 | 72.73 | 72.75 | 67900.0 |
| 2006-02-21 09:30:00 | IWM | ETF | 72.75 | 72.93 | 72.65 | 72.65 | 1706100.0 |
| 2006-02-21 10:00:00 | IWM | ETF | 72.66 | 72.73 | 72.24 | 72.33 | 3919700.0 |
| 2006-02-21 10:30:00 | IWM | ETF | 72.33 | 72.64 | 72.29 | 72.35 | 1935800.0 |
| 2006-02-21 11:00:00 | IWM | ETF | 72.35 | 72.46 | 72.35 | 72.38 | 1226600.0 |
| 2006-02-21 11:30:00 | IWM | ETF | 72.38 | 72.44 | 72.05 | 72.07 | 1951400.0 |
| 2006-02-21 12:00:00 | IWM | ETF | 72.07 | 72.1 | 72.0 | 72.02 | 1101200.0 |
| 2006-02-21 12:30:00 | IWM | ETF | 72.03 | 72.11 | 71.85 | 71.95 | 1308200.0 |
| 2006-02-21 13:00:00 | IWM | ETF | 71.95 | 72.06 | 71.92 | 72.06 | 762800.0 |
> showing 50 of 2,172 rows — these rows as CSV