PREVIEW / etf_30min / 2003-04-01
file: by_date/etf_30min/2003/2003-04-01.parquet size: 22 KB rows: 660
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-04-01 08:00:00 | SPY | ETF | 85.44 | 85.59 | 85.15 | 85.15 | 33500.0 |
| 2003-04-01 08:30:00 | SPY | ETF | 85.2 | 85.41 | 85.2 | 85.37 | 48500.0 |
| 2003-04-01 09:00:00 | SPY | ETF | 85.37 | 85.42 | 85.28 | 85.28 | 20500.0 |
| 2003-04-01 09:30:00 | SPY | ETF | 85.25 | 85.45 | 84.98 | 85.11 | 4149800.0 |
| 2003-04-01 10:00:00 | SPY | ETF | 85.11 | 85.84 | 84.91 | 85.61 | 7576400.0 |
| 2003-04-01 10:30:00 | SPY | ETF | 85.64 | 85.74 | 85.06 | 85.06 | 3475400.0 |
| 2003-04-01 11:00:00 | SPY | ETF | 85.07 | 85.45 | 85.01 | 85.21 | 1603600.0 |
| 2003-04-01 11:30:00 | SPY | ETF | 85.2 | 85.46 | 85.13 | 85.44 | 1214100.0 |
| 2003-04-01 12:00:00 | SPY | ETF | 85.44 | 86.09 | 85.4 | 85.86 | 5641700.0 |
| 2003-04-01 12:30:00 | SPY | ETF | 85.86 | 86.17 | 85.73 | 86.16 | 2204900.0 |
| 2003-04-01 13:00:00 | SPY | ETF | 86.16 | 86.25 | 85.77 | 85.82 | 2279500.0 |
| 2003-04-01 13:30:00 | SPY | ETF | 85.86 | 86.25 | 85.83 | 86.23 | 1959200.0 |
| 2003-04-01 14:00:00 | SPY | ETF | 86.19 | 86.39 | 86.06 | 86.2 | 3089700.0 |
| 2003-04-01 14:30:00 | SPY | ETF | 86.23 | 86.35 | 85.88 | 85.93 | 2400500.0 |
| 2003-04-01 15:00:00 | SPY | ETF | 85.95 | 86.09 | 85.8 | 85.89 | 4489100.0 |
| 2003-04-01 15:30:00 | SPY | ETF | 85.88 | 86.23 | 85.6 | 86.1 | 5699900.0 |
| 2003-04-01 16:00:00 | SPY | ETF | 86.1 | 86.18 | 85.56 | 85.91 | 2095000.0 |
| 2003-04-01 16:30:00 | SPY | ETF | 85.95 | 86.03 | 85.88 | 85.98 | 261800.0 |
| 2003-04-01 17:00:00 | SPY | ETF | 85.96 | 86.04 | 85.9 | 86.04 | 20700.0 |
| 2003-04-01 17:30:00 | SPY | ETF | 86.02 | 86.02 | 85.93 | 86.0 | 10300.0 |
| 2003-04-01 18:00:00 | SPY | ETF | 85.93 | 86.25 | 85.88 | 86.18 | 190800.0 |
| 2003-04-01 18:30:00 | SPY | ETF | 86.17 | 86.35 | 86.11 | 86.35 | 50900.0 |
| 2003-04-01 19:00:00 | SPY | ETF | 86.35 | 87.61 | 86.28 | 86.35 | 62900.0 |
| 2003-04-01 19:30:00 | SPY | ETF | 86.26 | 86.3 | 86.18 | 86.23 | 28500.0 |
| 2003-04-01 08:00:00 | QQQ | ETF | 25.44 | 25.45 | 25.33 | 25.33 | 45200.0 |
| 2003-04-01 08:30:00 | QQQ | ETF | 25.36 | 25.44 | 25.33 | 25.41 | 50400.0 |
| 2003-04-01 09:00:00 | QQQ | ETF | 25.43 | 25.45 | 25.41 | 25.43 | 48400.0 |
| 2003-04-01 09:30:00 | QQQ | ETF | 25.44 | 25.51 | 25.31 | 25.35 | 7018100.0 |
| 2003-04-01 10:00:00 | QQQ | ETF | 25.37 | 25.64 | 25.25 | 25.53 | 12883500.0 |
| 2003-04-01 10:30:00 | QQQ | ETF | 25.52 | 25.57 | 25.33 | 25.33 | 4788800.0 |
| 2003-04-01 11:00:00 | QQQ | ETF | 25.33 | 25.45 | 25.32 | 25.37 | 2873800.0 |
| 2003-04-01 11:30:00 | QQQ | ETF | 25.37 | 25.43 | 25.33 | 25.4 | 1739400.0 |
| 2003-04-01 12:00:00 | QQQ | ETF | 25.4 | 25.59 | 25.39 | 25.5 | 5926600.0 |
| 2003-04-01 12:30:00 | QQQ | ETF | 25.5 | 25.59 | 25.46 | 25.58 | 3439300.0 |
| 2003-04-01 13:00:00 | QQQ | ETF | 25.58 | 25.61 | 25.43 | 25.45 | 2592700.0 |
| 2003-04-01 13:30:00 | QQQ | ETF | 25.46 | 25.62 | 25.44 | 25.59 | 2526300.0 |
| 2003-04-01 14:00:00 | QQQ | ETF | 25.59 | 25.67 | 25.55 | 25.6 | 3592200.0 |
| 2003-04-01 14:30:00 | QQQ | ETF | 25.6 | 25.64 | 25.48 | 25.49 | 4341100.0 |
| 2003-04-01 15:00:00 | QQQ | ETF | 25.49 | 25.55 | 25.41 | 25.45 | 4602100.0 |
| 2003-04-01 15:30:00 | QQQ | ETF | 25.45 | 25.53 | 25.36 | 25.43 | 5571700.0 |
| 2003-04-01 16:00:00 | QQQ | ETF | 25.44 | 25.48 | 25.36 | 25.42 | 4933800.0 |
| 2003-04-01 16:30:00 | QQQ | ETF | 25.41 | 25.44 | 25.41 | 25.44 | 281700.0 |
| 2003-04-01 17:00:00 | QQQ | ETF | 25.44 | 25.45 | 25.43 | 25.43 | 48700.0 |
| 2003-04-01 17:30:00 | QQQ | ETF | 25.43 | 25.43 | 25.43 | 25.43 | 11200.0 |
| 2003-04-01 18:00:00 | QQQ | ETF | 25.43 | 25.59 | 25.43 | 25.5 | 223300.0 |
| 2003-04-01 18:30:00 | QQQ | ETF | 25.56 | 25.59 | 25.5 | 25.57 | 109900.0 |
| 2003-04-01 19:00:00 | QQQ | ETF | 25.57 | 25.69 | 25.53 | 25.55 | 99200.0 |
| 2003-04-01 19:30:00 | QQQ | ETF | 25.55 | 25.57 | 25.52 | 25.56 | 23300.0 |
| 2003-04-01 09:30:00 | IWM | ETF | 36.35 | 36.4 | 36.195 | 36.195 | 170000.0 |
| 2003-04-01 10:00:00 | IWM | ETF | 36.165 | 36.425 | 36.11 | 36.37 | 170200.0 |
> showing 50 of 660 rows — these rows as CSV