PREVIEW / etf_30min / 2004-11-04
file: by_date/etf_30min/2004/2004-11-04.parquet size: 42 KB rows: 1,334
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-04 08:00:00 | SPY | ETF | 114.84 | 114.88 | 114.8 | 114.85 | 17400.0 |
| 2004-11-04 08:30:00 | SPY | ETF | 114.89 | 114.98 | 114.86 | 114.87 | 110000.0 |
| 2004-11-04 09:00:00 | SPY | ETF | 114.86 | 114.86 | 114.73 | 114.79 | 57300.0 |
| 2004-11-04 09:30:00 | SPY | ETF | 114.78 | 115.05 | 114.76 | 115.04 | 4429900.0 |
| 2004-11-04 10:00:00 | SPY | ETF | 115.01 | 115.11 | 114.68 | 114.82 | 4222400.0 |
| 2004-11-04 10:30:00 | SPY | ETF | 114.82 | 114.98 | 114.72 | 114.93 | 2561600.0 |
| 2004-11-04 11:00:00 | SPY | ETF | 114.95 | 115.34 | 114.87 | 115.3 | 6069600.0 |
| 2004-11-04 11:30:00 | SPY | ETF | 115.3 | 115.54 | 115.3 | 115.34 | 4519400.0 |
| 2004-11-04 12:00:00 | SPY | ETF | 115.34 | 115.79 | 115.3 | 115.7 | 2816000.0 |
| 2004-11-04 12:30:00 | SPY | ETF | 115.7 | 116.0 | 115.7 | 115.86 | 4180800.0 |
| 2004-11-04 13:00:00 | SPY | ETF | 115.87 | 116.18 | 115.81 | 116.15 | 2834000.0 |
| 2004-11-04 13:30:00 | SPY | ETF | 116.15 | 116.35 | 116.1 | 116.31 | 4616000.0 |
| 2004-11-04 14:00:00 | SPY | ETF | 116.31 | 116.38 | 116.08 | 116.18 | 3289000.0 |
| 2004-11-04 14:30:00 | SPY | ETF | 116.18 | 116.34 | 116.13 | 116.26 | 1998800.0 |
| 2004-11-04 15:00:00 | SPY | ETF | 116.27 | 116.58 | 116.22 | 116.36 | 4090100.0 |
| 2004-11-04 15:30:00 | SPY | ETF | 116.37 | 116.67 | 116.26 | 116.57 | 5030100.0 |
| 2004-11-04 16:00:00 | SPY | ETF | 116.58 | 116.66 | 116.49 | 116.52 | 2385800.0 |
| 2004-11-04 16:30:00 | SPY | ETF | 116.53 | 116.57 | 116.43 | 116.49 | 299200.0 |
| 2004-11-04 17:00:00 | SPY | ETF | 116.49 | 116.53 | 116.48 | 116.5 | 107600.0 |
| 2004-11-04 17:30:00 | SPY | ETF | 116.45 | 116.52 | 116.45 | 116.46 | 51700.0 |
| 2004-11-04 18:00:00 | SPY | ETF | 116.53 | 116.53 | 116.5 | 116.5 | 2600.0 |
| 2004-11-04 18:30:00 | SPY | ETF | 116.5 | 116.5 | 116.5 | 116.5 | 100.0 |
| 2004-11-04 19:30:00 | SPY | ETF | 116.45 | 116.49 | 116.43 | 116.43 | 10400.0 |
| 2004-11-04 08:00:00 | QQQ | ETF | 37.3 | 37.32 | 37.26 | 37.27 | 39600.0 |
| 2004-11-04 08:30:00 | QQQ | ETF | 37.27 | 37.31 | 37.26 | 37.3 | 143800.0 |
| 2004-11-04 09:00:00 | QQQ | ETF | 37.3 | 37.3 | 37.21 | 37.25 | 318500.0 |
| 2004-11-04 09:30:00 | QQQ | ETF | 37.26 | 37.34 | 37.19 | 37.281 | 12347900.0 |
| 2004-11-04 10:00:00 | QQQ | ETF | 37.281 | 37.32 | 37.11 | 37.189 | 11161600.0 |
| 2004-11-04 10:30:00 | QQQ | ETF | 37.188 | 37.27 | 37.13 | 37.22 | 7145600.0 |
| 2004-11-04 11:00:00 | QQQ | ETF | 37.27 | 37.451 | 37.23 | 37.42 | 8240000.0 |
| 2004-11-04 11:30:00 | QQQ | ETF | 37.41 | 37.55 | 37.35 | 37.37 | 8252500.0 |
| 2004-11-04 12:00:00 | QQQ | ETF | 37.366 | 37.56 | 37.35 | 37.538 | 5873200.0 |
| 2004-11-04 12:30:00 | QQQ | ETF | 37.53 | 37.66 | 37.52 | 37.57 | 9165000.0 |
| 2004-11-04 13:00:00 | QQQ | ETF | 37.57 | 37.68 | 37.51 | 37.66 | 6225600.0 |
| 2004-11-04 13:30:00 | QQQ | ETF | 37.66 | 37.75 | 37.64 | 37.69 | 7117600.0 |
| 2004-11-04 14:00:00 | QQQ | ETF | 37.71 | 37.76 | 37.626 | 37.7 | 8088400.0 |
| 2004-11-04 14:30:00 | QQQ | ETF | 37.699 | 37.74 | 37.63 | 37.67 | 5214900.0 |
| 2004-11-04 15:00:00 | QQQ | ETF | 37.67 | 37.78 | 37.64 | 37.64 | 8017500.0 |
| 2004-11-04 15:30:00 | QQQ | ETF | 37.65 | 37.73 | 37.6 | 37.64 | 10182900.0 |
| 2004-11-04 16:00:00 | QQQ | ETF | 37.637 | 37.67 | 37.6 | 37.62 | 2559200.0 |
| 2004-11-04 16:30:00 | QQQ | ETF | 37.62 | 37.64 | 37.6 | 37.63 | 290200.0 |
| 2004-11-04 17:00:00 | QQQ | ETF | 37.62 | 37.682 | 37.62 | 37.66 | 270100.0 |
| 2004-11-04 17:30:00 | QQQ | ETF | 37.67 | 37.68 | 37.63 | 37.64 | 52900.0 |
| 2004-11-04 18:00:00 | QQQ | ETF | 37.65 | 37.65 | 37.62 | 37.63 | 36400.0 |
| 2004-11-04 18:30:00 | QQQ | ETF | 37.62 | 37.62 | 37.62 | 37.62 | 2100.0 |
| 2004-11-04 19:00:00 | QQQ | ETF | 37.62 | 37.63 | 37.62 | 37.63 | 15500.0 |
| 2004-11-04 19:30:00 | QQQ | ETF | 37.62 | 37.63 | 37.62 | 37.63 | 37000.0 |
| 2004-11-04 08:00:00 | IWM | ETF | 59.32 | 59.32 | 59.32 | 59.32 | 2000.0 |
| 2004-11-04 08:30:00 | IWM | ETF | 59.255 | 59.28 | 59.235 | 59.28 | 11600.0 |
| 2004-11-04 09:00:00 | IWM | ETF | 59.215 | 59.215 | 59.215 | 59.215 | 1400.0 |
> showing 50 of 1,334 rows — these rows as CSV