PREVIEW / etf_30min / 2003-05-23
file: by_date/etf_30min/2003/2003-05-23.parquet size: 21 KB rows: 636
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-23 08:00:00 | SPY | ETF | 93.44 | 93.51 | 93.42 | 93.48 | 16800.0 |
| 2003-05-23 08:30:00 | SPY | ETF | 93.48 | 93.51 | 93.43 | 93.5 | 6300.0 |
| 2003-05-23 09:00:00 | SPY | ETF | 93.51 | 93.6 | 93.5 | 93.53 | 25700.0 |
| 2003-05-23 09:30:00 | SPY | ETF | 93.53 | 93.66 | 93.14 | 93.22 | 3012900.0 |
| 2003-05-23 10:00:00 | SPY | ETF | 93.22 | 93.6 | 93.15 | 93.46 | 2444800.0 |
| 2003-05-23 10:30:00 | SPY | ETF | 93.45 | 93.77 | 93.43 | 93.65 | 1933700.0 |
| 2003-05-23 11:00:00 | SPY | ETF | 93.66 | 93.89 | 93.65 | 93.86 | 2365500.0 |
| 2003-05-23 11:30:00 | SPY | ETF | 93.85 | 93.89 | 93.66 | 93.78 | 988200.0 |
| 2003-05-23 12:00:00 | SPY | ETF | 93.77 | 93.98 | 93.71 | 93.93 | 1643200.0 |
| 2003-05-23 12:30:00 | SPY | ETF | 93.93 | 93.97 | 93.74 | 93.8 | 644100.0 |
| 2003-05-23 13:00:00 | SPY | ETF | 93.8 | 93.88 | 93.75 | 93.84 | 513000.0 |
| 2003-05-23 13:30:00 | SPY | ETF | 93.84 | 93.94 | 93.8 | 93.91 | 606800.0 |
| 2003-05-23 14:00:00 | SPY | ETF | 93.9 | 93.98 | 93.82 | 93.96 | 1105500.0 |
| 2003-05-23 14:30:00 | SPY | ETF | 93.95 | 93.96 | 93.72 | 93.87 | 1362800.0 |
| 2003-05-23 15:00:00 | SPY | ETF | 93.84 | 93.97 | 93.79 | 93.83 | 749100.0 |
| 2003-05-23 15:30:00 | SPY | ETF | 93.83 | 93.92 | 93.66 | 93.75 | 2677900.0 |
| 2003-05-23 16:00:00 | SPY | ETF | 93.72 | 93.8 | 93.66 | 93.79 | 852300.0 |
| 2003-05-23 16:30:00 | SPY | ETF | 93.72 | 93.77 | 93.72 | 93.76 | 2500.0 |
| 2003-05-23 17:00:00 | SPY | ETF | 93.76 | 93.77 | 93.75 | 93.75 | 2900.0 |
| 2003-05-23 18:00:00 | SPY | ETF | 93.76 | 93.76 | 93.76 | 93.76 | 600.0 |
| 2003-05-23 19:00:00 | SPY | ETF | 93.75 | 93.76 | 93.74 | 93.74 | 300.0 |
| 2003-05-23 08:00:00 | QQQ | ETF | 28.01 | 28.07 | 28.01 | 28.07 | 26100.0 |
| 2003-05-23 08:30:00 | QQQ | ETF | 28.07 | 28.1 | 28.06 | 28.09 | 27100.0 |
| 2003-05-23 09:00:00 | QQQ | ETF | 28.09 | 28.12 | 28.07 | 28.07 | 45300.0 |
| 2003-05-23 09:30:00 | QQQ | ETF | 28.04 | 28.18 | 27.95 | 28.0 | 6299200.0 |
| 2003-05-23 10:00:00 | QQQ | ETF | 27.99 | 28.12 | 27.98 | 28.04 | 4803600.0 |
| 2003-05-23 10:30:00 | QQQ | ETF | 28.04 | 28.17 | 28.03 | 28.13 | 2826600.0 |
| 2003-05-23 11:00:00 | QQQ | ETF | 28.14 | 28.22 | 28.12 | 28.19 | 2891100.0 |
| 2003-05-23 11:30:00 | QQQ | ETF | 28.21 | 28.21 | 28.13 | 28.17 | 1559300.0 |
| 2003-05-23 12:00:00 | QQQ | ETF | 28.16 | 28.24 | 28.13 | 28.22 | 1884400.0 |
| 2003-05-23 12:30:00 | QQQ | ETF | 28.21 | 28.25 | 28.14 | 28.15 | 1691400.0 |
| 2003-05-23 13:00:00 | QQQ | ETF | 28.15 | 28.18 | 28.12 | 28.15 | 1125800.0 |
| 2003-05-23 13:30:00 | QQQ | ETF | 28.15 | 28.19 | 28.13 | 28.17 | 983600.0 |
| 2003-05-23 14:00:00 | QQQ | ETF | 28.17 | 28.2 | 28.14 | 28.17 | 855200.0 |
| 2003-05-23 14:30:00 | QQQ | ETF | 28.17 | 28.18 | 28.06 | 28.11 | 1657100.0 |
| 2003-05-23 15:00:00 | QQQ | ETF | 28.13 | 28.15 | 28.07 | 28.1 | 797700.0 |
| 2003-05-23 15:30:00 | QQQ | ETF | 28.09 | 28.17 | 28.06 | 28.08 | 3291100.0 |
| 2003-05-23 16:00:00 | QQQ | ETF | 28.08 | 28.13 | 28.06 | 28.12 | 1375900.0 |
| 2003-05-23 16:30:00 | QQQ | ETF | 28.12 | 28.14 | 28.08 | 28.14 | 33300.0 |
| 2003-05-23 17:00:00 | QQQ | ETF | 28.11 | 28.13 | 28.07 | 28.08 | 22400.0 |
| 2003-05-23 17:30:00 | QQQ | ETF | 28.11 | 28.13 | 28.09 | 28.09 | 4100.0 |
| 2003-05-23 18:00:00 | QQQ | ETF | 28.09 | 28.14 | 28.08 | 28.11 | 11200.0 |
| 2003-05-23 19:30:00 | QQQ | ETF | 28.11 | 28.11 | 28.09 | 28.09 | 1800.0 |
| 2003-05-23 09:30:00 | IWM | ETF | 41.385 | 41.39 | 41.195 | 41.31 | 259600.0 |
| 2003-05-23 10:00:00 | IWM | ETF | 41.315 | 41.475 | 41.285 | 41.42 | 154400.0 |
| 2003-05-23 10:30:00 | IWM | ETF | 41.44 | 41.62 | 41.44 | 41.525 | 108200.0 |
| 2003-05-23 11:00:00 | IWM | ETF | 41.565 | 41.67 | 41.565 | 41.67 | 88200.0 |
| 2003-05-23 11:30:00 | IWM | ETF | 41.67 | 41.68 | 41.625 | 41.655 | 37000.0 |
| 2003-05-23 12:00:00 | IWM | ETF | 41.67 | 41.68 | 41.635 | 41.665 | 38400.0 |
| 2003-05-23 12:30:00 | IWM | ETF | 41.68 | 41.685 | 41.65 | 41.65 | 12800.0 |
> showing 50 of 636 rows — these rows as CSV