PREVIEW / etf_30min / 2003-10-09
file: by_date/etf_30min/2003/2003-10-09.parquet size: 26 KB rows: 790
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-10-09 08:00:00 | SPY | ETF | 104.09 | 104.21 | 104.09 | 104.2 | 54800.0 |
| 2003-10-09 08:30:00 | SPY | ETF | 104.25 | 104.75 | 104.05 | 104.72 | 364600.0 |
| 2003-10-09 09:00:00 | SPY | ETF | 104.72 | 104.85 | 104.7 | 104.85 | 40100.0 |
| 2003-10-09 09:30:00 | SPY | ETF | 104.88 | 104.97 | 104.54 | 104.75 | 4433700.0 |
| 2003-10-09 10:00:00 | SPY | ETF | 104.74 | 104.78 | 104.47 | 104.64 | 2399900.0 |
| 2003-10-09 10:30:00 | SPY | ETF | 104.68 | 104.83 | 104.5 | 104.797 | 2690900.0 |
| 2003-10-09 11:00:00 | SPY | ETF | 104.83 | 105.04 | 104.75 | 104.93 | 3442000.0 |
| 2003-10-09 11:30:00 | SPY | ETF | 104.97 | 105.22 | 104.93 | 105.07 | 1830200.0 |
| 2003-10-09 12:00:00 | SPY | ETF | 105.06 | 105.14 | 104.94 | 105.04 | 893700.0 |
| 2003-10-09 12:30:00 | SPY | ETF | 105.04 | 105.17 | 104.97 | 105.0 | 580200.0 |
| 2003-10-09 13:00:00 | SPY | ETF | 104.98 | 105.02 | 104.81 | 104.96 | 1304500.0 |
| 2003-10-09 13:30:00 | SPY | ETF | 104.96 | 105.04 | 104.75 | 104.87 | 980700.0 |
| 2003-10-09 14:00:00 | SPY | ETF | 104.9 | 104.93 | 104.33 | 104.34 | 2609200.0 |
| 2003-10-09 14:30:00 | SPY | ETF | 104.34 | 104.42 | 103.91 | 104.062 | 4645800.0 |
| 2003-10-09 15:00:00 | SPY | ETF | 104.02 | 104.26 | 103.83 | 104.16 | 3517200.0 |
| 2003-10-09 15:30:00 | SPY | ETF | 104.14 | 104.26 | 104.01 | 104.169 | 2067600.0 |
| 2003-10-09 16:00:00 | SPY | ETF | 104.16 | 104.34 | 104.13 | 104.28 | 1068500.0 |
| 2003-10-09 16:30:00 | SPY | ETF | 104.24 | 104.28 | 104.22 | 104.28 | 21400.0 |
| 2003-10-09 17:00:00 | SPY | ETF | 104.28 | 104.3 | 104.23 | 104.3 | 14300.0 |
| 2003-10-09 17:30:00 | SPY | ETF | 104.28 | 104.37 | 104.28 | 104.3 | 4300.0 |
| 2003-10-09 18:00:00 | SPY | ETF | 104.32 | 104.35 | 104.29 | 104.31 | 13000.0 |
| 2003-10-09 18:30:00 | SPY | ETF | 104.31 | 104.31 | 104.27 | 104.29 | 3500.0 |
| 2003-10-09 19:00:00 | SPY | ETF | 104.32 | 104.32 | 104.29 | 104.31 | 2500.0 |
| 2003-10-09 19:30:00 | SPY | ETF | 104.31 | 104.31 | 104.31 | 104.31 | 1000.0 |
| 2003-10-09 08:00:00 | QQQ | ETF | 34.51 | 34.57 | 34.51 | 34.57 | 52400.0 |
| 2003-10-09 08:30:00 | QQQ | ETF | 34.57 | 34.88 | 34.57 | 34.87 | 573000.0 |
| 2003-10-09 09:00:00 | QQQ | ETF | 34.86 | 34.94 | 34.85 | 34.9 | 277300.0 |
| 2003-10-09 09:30:00 | QQQ | ETF | 34.92 | 35.0 | 34.8 | 34.92 | 13712300.0 |
| 2003-10-09 10:00:00 | QQQ | ETF | 34.92 | 34.99 | 34.81 | 34.919 | 7582700.0 |
| 2003-10-09 10:30:00 | QQQ | ETF | 34.924 | 35.1 | 34.86 | 35.1 | 7268900.0 |
| 2003-10-09 11:00:00 | QQQ | ETF | 35.095 | 35.23 | 35.08 | 35.14 | 9869300.0 |
| 2003-10-09 11:30:00 | QQQ | ETF | 35.13 | 35.27 | 35.13 | 35.2 | 5436200.0 |
| 2003-10-09 12:00:00 | QQQ | ETF | 35.2 | 35.27 | 35.15 | 35.2 | 3178300.0 |
| 2003-10-09 12:30:00 | QQQ | ETF | 35.2 | 35.25 | 35.168 | 35.18 | 2939700.0 |
| 2003-10-09 13:00:00 | QQQ | ETF | 35.17 | 35.21 | 35.09 | 35.17 | 3379100.0 |
| 2003-10-09 13:30:00 | QQQ | ETF | 35.17 | 35.23 | 35.06 | 35.097 | 6120800.0 |
| 2003-10-09 14:00:00 | QQQ | ETF | 35.1 | 35.14 | 34.888 | 34.889 | 6168500.0 |
| 2003-10-09 14:30:00 | QQQ | ETF | 34.91 | 34.96 | 34.55 | 34.63 | 11598700.0 |
| 2003-10-09 15:00:00 | QQQ | ETF | 34.627 | 34.76 | 34.43 | 34.66 | 13718000.0 |
| 2003-10-09 15:30:00 | QQQ | ETF | 34.64 | 34.73 | 34.58 | 34.64 | 9533100.0 |
| 2003-10-09 16:00:00 | QQQ | ETF | 34.64 | 34.73 | 34.63 | 34.67 | 2170900.0 |
| 2003-10-09 16:30:00 | QQQ | ETF | 34.679 | 34.693 | 34.64 | 34.66 | 115400.0 |
| 2003-10-09 17:00:00 | QQQ | ETF | 34.66 | 34.71 | 34.64 | 34.69 | 84800.0 |
| 2003-10-09 17:30:00 | QQQ | ETF | 34.69 | 34.74 | 34.67 | 34.67 | 11800.0 |
| 2003-10-09 18:00:00 | QQQ | ETF | 34.68 | 34.702 | 34.65 | 34.69 | 27100.0 |
| 2003-10-09 18:30:00 | QQQ | ETF | 34.68 | 34.7 | 34.66 | 34.66 | 10400.0 |
| 2003-10-09 19:00:00 | QQQ | ETF | 34.7 | 34.71 | 34.69 | 34.69 | 12800.0 |
| 2003-10-09 19:30:00 | QQQ | ETF | 34.7 | 34.72 | 34.7 | 34.7 | 8000.0 |
| 2003-10-09 08:30:00 | IWM | ETF | 51.725 | 51.94 | 51.725 | 51.94 | 400.0 |
| 2003-10-09 09:00:00 | IWM | ETF | 51.95 | 51.95 | 51.95 | 51.95 | 2000.0 |
> showing 50 of 790 rows — these rows as CSV