PREVIEW / etf_30min / 2003-03-18
file: by_date/etf_30min/2003/2003-03-18.parquet size: 23 KB rows: 671
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-03-18 08:00:00 | SPY | ETF | 87.8 | 87.84 | 87.61 | 87.64 | 68500.0 |
| 2003-03-18 08:30:00 | SPY | ETF | 87.62 | 87.62 | 87.31 | 87.35 | 161300.0 |
| 2003-03-18 09:00:00 | SPY | ETF | 87.36 | 87.36 | 87.09 | 87.19 | 55400.0 |
| 2003-03-18 09:30:00 | SPY | ETF | 87.15 | 87.25 | 86.28 | 86.33 | 9116500.0 |
| 2003-03-18 10:00:00 | SPY | ETF | 86.3 | 87.24 | 86.29 | 87.13 | 5648600.0 |
| 2003-03-18 10:30:00 | SPY | ETF | 87.12 | 87.18 | 86.56 | 86.71 | 4137400.0 |
| 2003-03-18 11:00:00 | SPY | ETF | 86.73 | 86.93 | 86.54 | 86.76 | 1943800.0 |
| 2003-03-18 11:30:00 | SPY | ETF | 86.76 | 87.05 | 86.6 | 86.64 | 1591500.0 |
| 2003-03-18 12:00:00 | SPY | ETF | 86.63 | 86.79 | 86.52 | 86.62 | 2647900.0 |
| 2003-03-18 12:30:00 | SPY | ETF | 86.64 | 86.9 | 86.54 | 86.83 | 1279800.0 |
| 2003-03-18 13:00:00 | SPY | ETF | 86.85 | 87.05 | 86.81 | 86.87 | 2636400.0 |
| 2003-03-18 13:30:00 | SPY | ETF | 86.87 | 87.32 | 86.85 | 87.1 | 4587100.0 |
| 2003-03-18 14:00:00 | SPY | ETF | 87.1 | 87.16 | 86.52 | 86.6 | 4015300.0 |
| 2003-03-18 14:30:00 | SPY | ETF | 86.63 | 86.92 | 86.42 | 86.71 | 2915500.0 |
| 2003-03-18 15:00:00 | SPY | ETF | 86.74 | 87.03 | 86.52 | 86.74 | 1905200.0 |
| 2003-03-18 15:30:00 | SPY | ETF | 86.75 | 87.19 | 86.58 | 87.19 | 3594300.0 |
| 2003-03-18 16:00:00 | SPY | ETF | 87.19 | 87.35 | 86.87 | 87.3 | 1641800.0 |
| 2003-03-18 16:30:00 | SPY | ETF | 87.3 | 87.37 | 86.73 | 87.37 | 66700.0 |
| 2003-03-18 17:00:00 | SPY | ETF | 87.34 | 87.36 | 87.14 | 87.14 | 268800.0 |
| 2003-03-18 17:30:00 | SPY | ETF | 87.15 | 87.2 | 87.0 | 87.0 | 271200.0 |
| 2003-03-18 18:00:00 | SPY | ETF | 87.0 | 87.13 | 87.0 | 87.09 | 9500.0 |
| 2003-03-18 18:30:00 | SPY | ETF | 87.06 | 87.15 | 87.05 | 87.06 | 13100.0 |
| 2003-03-18 19:00:00 | SPY | ETF | 87.04 | 87.04 | 87.03 | 87.03 | 800.0 |
| 2003-03-18 19:30:00 | SPY | ETF | 87.01 | 87.03 | 87.0 | 87.0 | 7800.0 |
| 2003-03-18 08:00:00 | QQQ | ETF | 26.98 | 27.01 | 26.9 | 26.9 | 161100.0 |
| 2003-03-18 08:30:00 | QQQ | ETF | 26.88 | 26.91 | 26.76 | 26.81 | 166100.0 |
| 2003-03-18 09:00:00 | QQQ | ETF | 26.8 | 26.83 | 26.75 | 26.78 | 117700.0 |
| 2003-03-18 09:30:00 | QQQ | ETF | 26.8 | 26.88 | 26.42 | 26.46 | 23148800.0 |
| 2003-03-18 10:00:00 | QQQ | ETF | 26.46 | 26.9 | 26.43 | 26.86 | 11321900.0 |
| 2003-03-18 10:30:00 | QQQ | ETF | 26.87 | 26.9 | 26.57 | 26.62 | 7495100.0 |
| 2003-03-18 11:00:00 | QQQ | ETF | 26.63 | 26.68 | 26.5 | 26.61 | 5243200.0 |
| 2003-03-18 11:30:00 | QQQ | ETF | 26.6 | 26.73 | 26.59 | 26.63 | 4545500.0 |
| 2003-03-18 12:00:00 | QQQ | ETF | 26.61 | 26.69 | 26.59 | 26.62 | 1706300.0 |
| 2003-03-18 12:30:00 | QQQ | ETF | 26.62 | 26.74 | 26.58 | 26.67 | 3627000.0 |
| 2003-03-18 13:00:00 | QQQ | ETF | 26.66 | 26.75 | 26.66 | 26.71 | 2474800.0 |
| 2003-03-18 13:30:00 | QQQ | ETF | 26.71 | 26.85 | 26.69 | 26.77 | 5651500.0 |
| 2003-03-18 14:00:00 | QQQ | ETF | 26.77 | 26.81 | 26.57 | 26.61 | 6125100.0 |
| 2003-03-18 14:30:00 | QQQ | ETF | 26.62 | 26.78 | 26.55 | 26.69 | 7497600.0 |
| 2003-03-18 15:00:00 | QQQ | ETF | 26.68 | 26.79 | 26.6 | 26.69 | 2679400.0 |
| 2003-03-18 15:30:00 | QQQ | ETF | 26.7 | 26.89 | 26.65 | 26.85 | 5951900.0 |
| 2003-03-18 16:00:00 | QQQ | ETF | 26.86 | 26.97 | 26.81 | 26.95 | 3129000.0 |
| 2003-03-18 16:30:00 | QQQ | ETF | 26.95 | 26.95 | 26.87 | 26.91 | 475300.0 |
| 2003-03-18 17:00:00 | QQQ | ETF | 26.91 | 26.92 | 26.82 | 26.82 | 430600.0 |
| 2003-03-18 17:30:00 | QQQ | ETF | 26.82 | 26.83 | 26.75 | 26.77 | 891300.0 |
| 2003-03-18 18:00:00 | QQQ | ETF | 26.77 | 26.8 | 26.74 | 26.8 | 343000.0 |
| 2003-03-18 18:30:00 | QQQ | ETF | 26.79 | 26.81 | 26.78 | 26.81 | 24600.0 |
| 2003-03-18 19:00:00 | QQQ | ETF | 26.81 | 26.84 | 26.75 | 26.8 | 12700.0 |
| 2003-03-18 19:30:00 | QQQ | ETF | 26.76 | 26.8 | 26.76 | 26.79 | 4700.0 |
| 2003-03-18 09:30:00 | IWM | ETF | 36.45 | 36.495 | 36.12 | 36.12 | 295400.0 |
| 2003-03-18 10:00:00 | IWM | ETF | 36.125 | 36.485 | 36.115 | 36.41 | 194200.0 |
> showing 50 of 671 rows — these rows as CSV