PREVIEW / etf_30min / 2004-02-27
file: by_date/etf_30min/2004/2004-02-27.parquet size: 36 KB rows: 1,201
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-02-27 08:00:00 | SPY | ETF | 115.2 | 115.27 | 115.2 | 115.21 | 39900.0 |
| 2004-02-27 08:30:00 | SPY | ETF | 115.27 | 115.36 | 115.24 | 115.32 | 49800.0 |
| 2004-02-27 09:00:00 | SPY | ETF | 115.31 | 115.31 | 115.19 | 115.21 | 58600.0 |
| 2004-02-27 09:30:00 | SPY | ETF | 115.19 | 115.4 | 115.11 | 115.33 | 3342800.0 |
| 2004-02-27 10:00:00 | SPY | ETF | 115.34 | 115.74 | 115.33 | 115.45 | 3710200.0 |
| 2004-02-27 10:30:00 | SPY | ETF | 115.45 | 115.65 | 115.43 | 115.48 | 2027500.0 |
| 2004-02-27 11:00:00 | SPY | ETF | 115.48 | 115.61 | 115.36 | 115.41 | 801800.0 |
| 2004-02-27 11:30:00 | SPY | ETF | 115.41 | 115.47 | 114.63 | 114.86 | 6411100.0 |
| 2004-02-27 12:00:00 | SPY | ETF | 114.86 | 115.01 | 114.83 | 114.91 | 3240300.0 |
| 2004-02-27 12:30:00 | SPY | ETF | 114.93 | 115.07 | 114.92 | 115.03 | 1178300.0 |
| 2004-02-27 13:00:00 | SPY | ETF | 115.03 | 115.22 | 114.99 | 115.12 | 1670300.0 |
| 2004-02-27 13:30:00 | SPY | ETF | 115.12 | 115.18 | 115.0 | 115.01 | 1289400.0 |
| 2004-02-27 14:00:00 | SPY | ETF | 115.01 | 115.44 | 115.01 | 115.31 | 2144000.0 |
| 2004-02-27 14:30:00 | SPY | ETF | 115.31 | 115.55 | 115.19 | 115.5 | 1366600.0 |
| 2004-02-27 15:00:00 | SPY | ETF | 115.52 | 115.55 | 115.38 | 115.45 | 1732300.0 |
| 2004-02-27 15:30:00 | SPY | ETF | 115.44 | 115.46 | 115.02 | 115.08 | 4527500.0 |
| 2004-02-27 16:00:00 | SPY | ETF | 115.1 | 115.1 | 114.95 | 115.0 | 2388900.0 |
| 2004-02-27 16:30:00 | SPY | ETF | 115.07 | 115.21 | 115.07 | 115.08 | 71200.0 |
| 2004-02-27 17:00:00 | SPY | ETF | 115.07 | 115.12 | 115.04 | 115.04 | 2400.0 |
| 2004-02-27 18:00:00 | SPY | ETF | 115.05 | 115.05 | 115.04 | 115.04 | 500.0 |
| 2004-02-27 19:00:00 | SPY | ETF | 115.15 | 115.15 | 115.15 | 115.15 | 400.0 |
| 2004-02-27 08:00:00 | QQQ | ETF | 36.83 | 36.83 | 36.75 | 36.77 | 54300.0 |
| 2004-02-27 08:30:00 | QQQ | ETF | 36.79 | 36.85 | 36.77 | 36.82 | 81100.0 |
| 2004-02-27 09:00:00 | QQQ | ETF | 36.81 | 36.84 | 36.77 | 36.77 | 221300.0 |
| 2004-02-27 09:30:00 | QQQ | ETF | 36.76 | 36.806 | 36.68 | 36.74 | 7971000.0 |
| 2004-02-27 10:00:00 | QQQ | ETF | 36.73 | 36.94 | 36.73 | 36.79 | 12379400.0 |
| 2004-02-27 10:30:00 | QQQ | ETF | 36.78 | 36.852 | 36.74 | 36.76 | 6314600.0 |
| 2004-02-27 11:00:00 | QQQ | ETF | 36.75 | 36.81 | 36.68 | 36.7 | 3939600.0 |
| 2004-02-27 11:30:00 | QQQ | ETF | 36.694 | 36.73 | 36.27 | 36.41 | 15768100.0 |
| 2004-02-27 12:00:00 | QQQ | ETF | 36.41 | 36.46 | 36.353 | 36.43 | 5333600.0 |
| 2004-02-27 12:30:00 | QQQ | ETF | 36.43 | 36.5 | 36.41 | 36.43 | 4361000.0 |
| 2004-02-27 13:00:00 | QQQ | ETF | 36.42 | 36.49 | 36.41 | 36.47 | 2936000.0 |
| 2004-02-27 13:30:00 | QQQ | ETF | 36.472 | 36.49 | 36.36 | 36.41 | 3960900.0 |
| 2004-02-27 14:00:00 | QQQ | ETF | 36.41 | 36.59 | 36.4 | 36.54 | 5861300.0 |
| 2004-02-27 14:30:00 | QQQ | ETF | 36.55 | 36.7 | 36.48 | 36.68 | 6682900.0 |
| 2004-02-27 15:00:00 | QQQ | ETF | 36.68 | 36.7 | 36.57 | 36.64 | 5843300.0 |
| 2004-02-27 15:30:00 | QQQ | ETF | 36.64 | 36.65 | 36.47 | 36.54 | 9232100.0 |
| 2004-02-27 16:00:00 | QQQ | ETF | 36.54 | 36.6134 | 36.49 | 36.56 | 3113500.0 |
| 2004-02-27 16:30:00 | QQQ | ETF | 36.56 | 36.67 | 36.48 | 36.5 | 593000.0 |
| 2004-02-27 17:00:00 | QQQ | ETF | 36.5 | 36.549 | 36.47 | 36.53 | 83200.0 |
| 2004-02-27 17:30:00 | QQQ | ETF | 36.5 | 36.547 | 36.5 | 36.54 | 6200.0 |
| 2004-02-27 18:00:00 | QQQ | ETF | 36.54 | 36.54 | 36.51 | 36.52 | 10300.0 |
| 2004-02-27 18:30:00 | QQQ | ETF | 36.53 | 36.53 | 36.53 | 36.53 | 1200.0 |
| 2004-02-27 19:30:00 | QQQ | ETF | 36.52 | 36.53 | 36.5 | 36.5 | 4300.0 |
| 2004-02-27 08:30:00 | IWM | ETF | 58.31 | 58.31 | 58.31 | 58.31 | 1000.0 |
| 2004-02-27 09:00:00 | IWM | ETF | 58.275 | 58.275 | 58.23 | 58.23 | 18200.0 |
| 2004-02-27 09:30:00 | IWM | ETF | 58.185 | 58.235 | 58.085 | 58.22 | 1141600.0 |
| 2004-02-27 10:00:00 | IWM | ETF | 58.225 | 58.5 | 58.205 | 58.35 | 1050600.0 |
| 2004-02-27 10:30:00 | IWM | ETF | 58.37 | 58.525 | 58.365 | 58.45 | 432000.0 |
| 2004-02-27 11:00:00 | IWM | ETF | 58.435 | 58.5 | 58.365 | 58.39 | 339800.0 |
> showing 50 of 1,201 rows — these rows as CSV