PREVIEW / etf_30min / 2003-09-10
file: by_date/etf_30min/2003/2003-09-10.parquet size: 25 KB rows: 732
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-09-10 08:00:00 | SPY | ETF | 102.86 | 102.9 | 102.72 | 102.77 | 19500.0 |
| 2003-09-10 08:30:00 | SPY | ETF | 102.7 | 102.74 | 102.68 | 102.68 | 27400.0 |
| 2003-09-10 09:00:00 | SPY | ETF | 102.68 | 102.68 | 102.55 | 102.55 | 35100.0 |
| 2003-09-10 09:30:00 | SPY | ETF | 102.54 | 102.77 | 102.45 | 102.75 | 5214800.0 |
| 2003-09-10 10:00:00 | SPY | ETF | 102.75 | 102.75 | 102.247 | 102.35 | 4621100.0 |
| 2003-09-10 10:30:00 | SPY | ETF | 102.32 | 102.55 | 102.31 | 102.38 | 1964400.0 |
| 2003-09-10 11:00:00 | SPY | ETF | 102.38 | 102.47 | 102.3 | 102.35 | 1237100.0 |
| 2003-09-10 11:30:00 | SPY | ETF | 102.35 | 102.37 | 102.15 | 102.27 | 2594800.0 |
| 2003-09-10 12:00:00 | SPY | ETF | 102.3 | 102.44 | 102.26 | 102.36 | 1351500.0 |
| 2003-09-10 12:30:00 | SPY | ETF | 102.35 | 102.57 | 102.3 | 102.53 | 1005700.0 |
| 2003-09-10 13:00:00 | SPY | ETF | 102.5 | 102.6 | 102.29 | 102.35 | 1221100.0 |
| 2003-09-10 13:30:00 | SPY | ETF | 102.35 | 102.41 | 102.24 | 102.26 | 837600.0 |
| 2003-09-10 14:00:00 | SPY | ETF | 102.28 | 102.39 | 101.86 | 101.9 | 5206500.0 |
| 2003-09-10 14:30:00 | SPY | ETF | 101.89 | 101.98 | 101.7 | 101.87 | 5330200.0 |
| 2003-09-10 15:00:00 | SPY | ETF | 101.85 | 101.9 | 101.55 | 101.57 | 2799100.0 |
| 2003-09-10 15:30:00 | SPY | ETF | 101.57 | 101.83 | 101.55 | 101.68 | 3607800.0 |
| 2003-09-10 16:00:00 | SPY | ETF | 101.7 | 102.0 | 101.67 | 101.94 | 1616000.0 |
| 2003-09-10 16:30:00 | SPY | ETF | 102.91 | 102.91 | 101.9 | 101.93 | 1419100.0 |
| 2003-09-10 17:00:00 | SPY | ETF | 101.9 | 101.9 | 101.84 | 101.84 | 224100.0 |
| 2003-09-10 17:30:00 | SPY | ETF | 101.88 | 101.88 | 101.83 | 101.83 | 1100.0 |
| 2003-09-10 18:00:00 | SPY | ETF | 101.876 | 101.91 | 101.84 | 101.91 | 16000.0 |
| 2003-09-10 18:30:00 | SPY | ETF | 101.89 | 101.89 | 101.84 | 101.84 | 500.0 |
| 2003-09-10 19:00:00 | SPY | ETF | 101.89 | 101.9 | 101.86 | 101.89 | 5800.0 |
| 2003-09-10 19:30:00 | SPY | ETF | 101.87 | 101.87 | 101.84 | 101.84 | 1000.0 |
| 2003-09-10 08:00:00 | QQQ | ETF | 33.86 | 33.9 | 33.78 | 33.8 | 124000.0 |
| 2003-09-10 08:30:00 | QQQ | ETF | 33.79 | 33.82 | 33.75 | 33.75 | 133000.0 |
| 2003-09-10 09:00:00 | QQQ | ETF | 33.75 | 33.78 | 33.74 | 33.74 | 153300.0 |
| 2003-09-10 09:30:00 | QQQ | ETF | 33.75 | 33.89 | 33.66 | 33.864 | 14753600.0 |
| 2003-09-10 10:00:00 | QQQ | ETF | 33.863 | 33.87 | 33.61 | 33.675 | 11457200.0 |
| 2003-09-10 10:30:00 | QQQ | ETF | 33.669 | 33.741 | 33.65 | 33.68 | 7341200.0 |
| 2003-09-10 11:00:00 | QQQ | ETF | 33.65 | 33.72 | 33.61 | 33.63 | 4707000.0 |
| 2003-09-10 11:30:00 | QQQ | ETF | 33.63 | 33.64 | 33.441 | 33.53 | 8729100.0 |
| 2003-09-10 12:00:00 | QQQ | ETF | 33.53 | 33.63 | 33.51 | 33.561 | 4075000.0 |
| 2003-09-10 12:30:00 | QQQ | ETF | 33.56 | 33.69 | 33.55 | 33.63 | 3177100.0 |
| 2003-09-10 13:00:00 | QQQ | ETF | 33.634 | 33.67 | 33.52 | 33.54 | 3160900.0 |
| 2003-09-10 13:30:00 | QQQ | ETF | 33.54 | 33.58 | 33.46 | 33.514 | 4539000.0 |
| 2003-09-10 14:00:00 | QQQ | ETF | 33.52 | 33.548 | 33.33 | 33.34 | 8839500.0 |
| 2003-09-10 14:30:00 | QQQ | ETF | 33.34 | 33.4 | 33.25 | 33.32 | 8235200.0 |
| 2003-09-10 15:00:00 | QQQ | ETF | 33.32 | 33.35 | 33.18 | 33.205 | 7688400.0 |
| 2003-09-10 15:30:00 | QQQ | ETF | 33.21 | 33.3 | 33.11 | 33.13 | 10350300.0 |
| 2003-09-10 16:00:00 | QQQ | ETF | 33.13 | 33.28 | 33.11 | 33.24 | 2616400.0 |
| 2003-09-10 16:30:00 | QQQ | ETF | 33.24 | 33.27 | 33.12 | 33.22 | 177600.0 |
| 2003-09-10 17:00:00 | QQQ | ETF | 33.22 | 33.22 | 33.129 | 33.16 | 224200.0 |
| 2003-09-10 17:30:00 | QQQ | ETF | 33.18 | 33.22 | 33.174 | 33.22 | 24100.0 |
| 2003-09-10 18:00:00 | QQQ | ETF | 33.2 | 33.23 | 33.19 | 33.21 | 47500.0 |
| 2003-09-10 18:30:00 | QQQ | ETF | 33.21 | 33.21 | 33.19 | 33.19 | 14300.0 |
| 2003-09-10 19:00:00 | QQQ | ETF | 33.2 | 33.21 | 33.19 | 33.21 | 3200.0 |
| 2003-09-10 19:30:00 | QQQ | ETF | 33.2 | 33.2 | 33.19 | 33.19 | 7100.0 |
| 2003-09-10 09:30:00 | IWM | ETF | 50.955 | 50.955 | 50.46 | 50.78 | 736600.0 |
| 2003-09-10 10:00:00 | IWM | ETF | 50.775 | 50.785 | 50.475 | 50.5 | 632000.0 |
> showing 50 of 732 rows — these rows as CSV