PREVIEW / etf_30min / 2003-08-13
file: by_date/etf_30min/2003/2003-08-13.parquet size: 23 KB rows: 682
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-08-13 08:00:00 | SPY | ETF | 99.56 | 99.6 | 99.5 | 99.57 | 14600.0 |
| 2003-08-13 08:30:00 | SPY | ETF | 99.61 | 99.86 | 99.61 | 99.81 | 52100.0 |
| 2003-08-13 09:00:00 | SPY | ETF | 99.84 | 99.88 | 99.75 | 99.79 | 10200.0 |
| 2003-08-13 09:30:00 | SPY | ETF | 99.82 | 99.849 | 99.21 | 99.32 | 5150900.0 |
| 2003-08-13 10:00:00 | SPY | ETF | 99.33 | 99.52 | 99.18 | 99.39 | 2954200.0 |
| 2003-08-13 10:30:00 | SPY | ETF | 99.431 | 99.44 | 98.93 | 98.949 | 3536200.0 |
| 2003-08-13 11:00:00 | SPY | ETF | 98.93 | 99.06 | 98.87 | 99.02 | 2700900.0 |
| 2003-08-13 11:30:00 | SPY | ETF | 99.03 | 99.08 | 98.74 | 98.808 | 2041100.0 |
| 2003-08-13 12:00:00 | SPY | ETF | 98.81 | 98.98 | 98.75 | 98.89 | 1476700.0 |
| 2003-08-13 12:30:00 | SPY | ETF | 98.89 | 99.15 | 98.85 | 99.09 | 1182600.0 |
| 2003-08-13 13:00:00 | SPY | ETF | 99.09 | 99.25 | 99.03 | 99.17 | 2316100.0 |
| 2003-08-13 13:30:00 | SPY | ETF | 99.17 | 99.24 | 99.03 | 99.07 | 1313700.0 |
| 2003-08-13 14:00:00 | SPY | ETF | 99.08 | 99.22 | 98.99 | 99.18 | 969600.0 |
| 2003-08-13 14:30:00 | SPY | ETF | 99.187 | 99.35 | 99.08 | 99.11 | 1669100.0 |
| 2003-08-13 15:00:00 | SPY | ETF | 99.11 | 99.15 | 98.72 | 98.78 | 2075700.0 |
| 2003-08-13 15:30:00 | SPY | ETF | 98.79 | 98.9 | 98.53 | 98.89 | 3549300.0 |
| 2003-08-13 16:00:00 | SPY | ETF | 98.89 | 99.1 | 98.87 | 99.0 | 2113600.0 |
| 2003-08-13 16:30:00 | SPY | ETF | 99.0 | 99.01 | 98.989 | 98.989 | 61600.0 |
| 2003-08-13 17:00:00 | SPY | ETF | 98.99 | 98.99 | 98.97 | 98.98 | 7200.0 |
| 2003-08-13 17:30:00 | SPY | ETF | 98.99 | 98.99 | 98.98 | 98.98 | 3000.0 |
| 2003-08-13 18:00:00 | SPY | ETF | 98.97 | 98.98 | 98.95 | 98.98 | 900.0 |
| 2003-08-13 18:30:00 | SPY | ETF | 98.98 | 99.0 | 98.98 | 99.0 | 1300.0 |
| 2003-08-13 19:00:00 | SPY | ETF | 99.03 | 99.03 | 99.03 | 99.03 | 300.0 |
| 2003-08-13 19:30:00 | SPY | ETF | 99.0 | 99.01 | 99.0 | 99.01 | 1200.0 |
| 2003-08-13 08:00:00 | QQQ | ETF | 30.83 | 30.9 | 30.83 | 30.9 | 24000.0 |
| 2003-08-13 08:30:00 | QQQ | ETF | 30.9 | 31.03 | 30.9 | 31.01 | 196900.0 |
| 2003-08-13 09:00:00 | QQQ | ETF | 31.0 | 31.0 | 30.96 | 30.96 | 123200.0 |
| 2003-08-13 09:30:00 | QQQ | ETF | 30.98 | 31.04 | 30.78 | 30.85 | 7652700.0 |
| 2003-08-13 10:00:00 | QQQ | ETF | 30.851 | 31.03 | 30.79 | 30.967 | 6377000.0 |
| 2003-08-13 10:30:00 | QQQ | ETF | 30.95 | 30.99 | 30.76 | 30.78 | 3970900.0 |
| 2003-08-13 11:00:00 | QQQ | ETF | 30.782 | 30.8 | 30.66 | 30.78 | 4925700.0 |
| 2003-08-13 11:30:00 | QQQ | ETF | 30.79 | 30.82 | 30.65 | 30.69 | 2671200.0 |
| 2003-08-13 12:00:00 | QQQ | ETF | 30.68 | 30.77 | 30.67 | 30.73 | 1914800.0 |
| 2003-08-13 12:30:00 | QQQ | ETF | 30.74 | 30.84 | 30.72 | 30.83 | 2094500.0 |
| 2003-08-13 13:00:00 | QQQ | ETF | 30.82 | 30.9 | 30.78 | 30.9 | 2751200.0 |
| 2003-08-13 13:30:00 | QQQ | ETF | 30.88 | 30.95 | 30.82 | 30.838 | 3006000.0 |
| 2003-08-13 14:00:00 | QQQ | ETF | 30.85 | 30.946 | 30.81 | 30.9 | 2142900.0 |
| 2003-08-13 14:30:00 | QQQ | ETF | 30.9 | 31.066 | 30.9 | 30.97 | 5000500.0 |
| 2003-08-13 15:00:00 | QQQ | ETF | 30.967 | 30.98 | 30.78 | 30.85 | 3811900.0 |
| 2003-08-13 15:30:00 | QQQ | ETF | 30.85 | 30.87 | 30.68 | 30.82 | 5149400.0 |
| 2003-08-13 16:00:00 | QQQ | ETF | 30.82 | 30.92 | 30.81 | 30.9 | 967000.0 |
| 2003-08-13 16:30:00 | QQQ | ETF | 30.9 | 30.9 | 30.87 | 30.87 | 58500.0 |
| 2003-08-13 17:00:00 | QQQ | ETF | 30.87 | 30.884 | 30.84 | 30.84 | 383100.0 |
| 2003-08-13 17:30:00 | QQQ | ETF | 30.84 | 30.85 | 30.82 | 30.83 | 95300.0 |
| 2003-08-13 18:00:00 | QQQ | ETF | 30.83 | 30.85 | 30.82 | 30.85 | 8500.0 |
| 2003-08-13 19:00:00 | QQQ | ETF | 30.86 | 30.86 | 30.85 | 30.86 | 700.0 |
| 2003-08-13 19:30:00 | QQQ | ETF | 30.84 | 30.85 | 30.84 | 30.85 | 2800.0 |
| 2003-08-13 09:30:00 | IWM | ETF | 46.65 | 46.705 | 46.57 | 46.595 | 640200.0 |
| 2003-08-13 10:00:00 | IWM | ETF | 46.6 | 46.74 | 46.575 | 46.68 | 337800.0 |
| 2003-08-13 10:30:00 | IWM | ETF | 46.68 | 46.68 | 46.515 | 46.515 | 1802200.0 |
> showing 50 of 682 rows — these rows as CSV