PREVIEW / etf_30min / 2003-10-27
file: by_date/etf_30min/2003/2003-10-27.parquet size: 24 KB rows: 765
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-27 08:00:00 | SPY | ETF | 103.88 | 103.92 | 103.82 | 103.9 | 36900.0 |
| 2003-10-27 08:30:00 | SPY | ETF | 103.91 | 103.93 | 103.85 | 103.88 | 95400.0 |
| 2003-10-27 09:00:00 | SPY | ETF | 103.91 | 103.92 | 103.75 | 103.75 | 81100.0 |
| 2003-10-27 09:30:00 | SPY | ETF | 103.74 | 104.06 | 103.71 | 104.02 | 4924200.0 |
| 2003-10-27 10:00:00 | SPY | ETF | 104.02 | 104.18 | 103.81 | 103.86 | 3489400.0 |
| 2003-10-27 10:30:00 | SPY | ETF | 103.86 | 103.97 | 103.72 | 103.81 | 3086500.0 |
| 2003-10-27 11:00:00 | SPY | ETF | 103.78 | 103.85 | 103.57 | 103.77 | 1666900.0 |
| 2003-10-27 11:30:00 | SPY | ETF | 103.78 | 103.84 | 103.48 | 103.6 | 1231000.0 |
| 2003-10-27 12:00:00 | SPY | ETF | 103.6 | 103.81 | 103.58 | 103.76 | 1269900.0 |
| 2003-10-27 12:30:00 | SPY | ETF | 103.77 | 103.78 | 103.61 | 103.65 | 1077600.0 |
| 2003-10-27 13:00:00 | SPY | ETF | 103.63 | 103.81 | 103.56 | 103.66 | 769200.0 |
| 2003-10-27 13:30:00 | SPY | ETF | 103.65 | 103.76 | 103.57 | 103.63 | 796300.0 |
| 2003-10-27 14:00:00 | SPY | ETF | 103.64 | 103.64 | 103.35 | 103.48 | 2462700.0 |
| 2003-10-27 14:30:00 | SPY | ETF | 103.48 | 103.51 | 103.37 | 103.43 | 717700.0 |
| 2003-10-27 15:00:00 | SPY | ETF | 103.43 | 103.76 | 103.41 | 103.47 | 2265300.0 |
| 2003-10-27 15:30:00 | SPY | ETF | 103.46 | 103.54 | 103.27 | 103.44 | 2378100.0 |
| 2003-10-27 16:00:00 | SPY | ETF | 103.42 | 103.76 | 103.41 | 103.54 | 1310000.0 |
| 2003-10-27 16:30:00 | SPY | ETF | 103.57 | 103.6 | 103.56 | 103.6 | 38600.0 |
| 2003-10-27 17:00:00 | SPY | ETF | 103.6 | 103.7 | 103.6 | 103.7 | 22000.0 |
| 2003-10-27 17:30:00 | SPY | ETF | 103.68 | 103.68 | 103.63 | 103.65 | 900.0 |
| 2003-10-27 18:00:00 | SPY | ETF | 103.69 | 103.73 | 103.68 | 103.68 | 26900.0 |
| 2003-10-27 18:30:00 | SPY | ETF | 103.66 | 103.66 | 103.65 | 103.65 | 1400.0 |
| 2003-10-27 19:30:00 | SPY | ETF | 103.64 | 103.65 | 103.64 | 103.65 | 11000.0 |
| 2003-10-27 08:00:00 | QQQ | ETF | 34.34 | 34.34 | 34.27 | 34.32 | 172500.0 |
| 2003-10-27 08:30:00 | QQQ | ETF | 34.31 | 34.33 | 34.29 | 34.32 | 56100.0 |
| 2003-10-27 09:00:00 | QQQ | ETF | 34.32 | 34.33 | 34.27 | 34.27 | 109500.0 |
| 2003-10-27 09:30:00 | QQQ | ETF | 34.28 | 34.4 | 34.27 | 34.39 | 11407400.0 |
| 2003-10-27 10:00:00 | QQQ | ETF | 34.39 | 34.45 | 34.18 | 34.2 | 9278500.0 |
| 2003-10-27 10:30:00 | QQQ | ETF | 34.19 | 34.28 | 34.12 | 34.19 | 4485300.0 |
| 2003-10-27 11:00:00 | QQQ | ETF | 34.21 | 34.23 | 34.07 | 34.16 | 3605500.0 |
| 2003-10-27 11:30:00 | QQQ | ETF | 34.16 | 34.18 | 34.04 | 34.11 | 4162900.0 |
| 2003-10-27 12:00:00 | QQQ | ETF | 34.1 | 34.22 | 34.09 | 34.2 | 2140600.0 |
| 2003-10-27 12:30:00 | QQQ | ETF | 34.163 | 34.19 | 34.12 | 34.14 | 1147800.0 |
| 2003-10-27 13:00:00 | QQQ | ETF | 34.141 | 34.24 | 34.12 | 34.2 | 1938900.0 |
| 2003-10-27 13:30:00 | QQQ | ETF | 34.19 | 34.25 | 34.14 | 34.199 | 2033100.0 |
| 2003-10-27 14:00:00 | QQQ | ETF | 34.19 | 34.2 | 34.05 | 34.15 | 3323600.0 |
| 2003-10-27 14:30:00 | QQQ | ETF | 34.154 | 34.18 | 34.1 | 34.135 | 1695000.0 |
| 2003-10-27 15:00:00 | QQQ | ETF | 34.14 | 34.29 | 34.09 | 34.12 | 3753600.0 |
| 2003-10-27 15:30:00 | QQQ | ETF | 34.115 | 34.19 | 34.05 | 34.18 | 3259300.0 |
| 2003-10-27 16:00:00 | QQQ | ETF | 34.18 | 34.3 | 34.1172 | 34.25 | 1726300.0 |
| 2003-10-27 16:30:00 | QQQ | ETF | 34.22 | 34.24 | 34.2 | 34.225 | 62500.0 |
| 2003-10-27 17:00:00 | QQQ | ETF | 34.211 | 34.29 | 34.211 | 34.284 | 32900.0 |
| 2003-10-27 17:30:00 | QQQ | ETF | 34.26 | 34.28 | 34.26 | 34.28 | 7400.0 |
| 2003-10-27 18:00:00 | QQQ | ETF | 34.29 | 34.3 | 34.28 | 34.28 | 28000.0 |
| 2003-10-27 18:30:00 | QQQ | ETF | 34.29 | 34.3 | 34.27 | 34.27 | 6000.0 |
| 2003-10-27 19:00:00 | QQQ | ETF | 34.28 | 34.28 | 34.27 | 34.27 | 3700.0 |
| 2003-10-27 19:30:00 | QQQ | ETF | 34.28 | 34.3 | 34.27 | 34.27 | 10500.0 |
| 2003-10-27 09:00:00 | IWM | ETF | 50.655 | 50.655 | 50.655 | 50.655 | 400.0 |
| 2003-10-27 09:30:00 | IWM | ETF | 50.8 | 51.355 | 50.775 | 51.355 | 1065000.0 |
| 2003-10-27 10:00:00 | IWM | ETF | 51.345 | 51.555 | 51.235 | 51.34 | 1578400.0 |
> showing 50 of 765 rows — these rows as CSV