PREVIEW / etf_30min / 2003-08-06
file: by_date/etf_30min/2003/2003-08-06.parquet size: 23 KB rows: 676
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-06 08:00:00 | SPY | ETF | 96.75 | 96.78 | 96.67 | 96.78 | 15700.0 |
| 2003-08-06 08:30:00 | SPY | ETF | 96.78 | 96.78 | 96.7 | 96.74 | 9700.0 |
| 2003-08-06 09:00:00 | SPY | ETF | 96.76 | 96.82 | 96.74 | 96.74 | 71200.0 |
| 2003-08-06 09:30:00 | SPY | ETF | 96.69 | 97.07 | 96.5 | 97.04 | 5587300.0 |
| 2003-08-06 10:00:00 | SPY | ETF | 97.04 | 97.09 | 96.423 | 96.6 | 4982100.0 |
| 2003-08-06 10:30:00 | SPY | ETF | 96.6 | 97.13 | 96.49 | 96.85 | 3363200.0 |
| 2003-08-06 11:00:00 | SPY | ETF | 96.84 | 97.05 | 96.62 | 96.87 | 1651000.0 |
| 2003-08-06 11:30:00 | SPY | ETF | 96.83 | 97.16 | 96.78 | 97.14 | 1401300.0 |
| 2003-08-06 12:00:00 | SPY | ETF | 97.15 | 97.46 | 97.11 | 97.41 | 3916600.0 |
| 2003-08-06 12:30:00 | SPY | ETF | 97.43 | 97.49 | 97.18 | 97.28 | 967900.0 |
| 2003-08-06 13:00:00 | SPY | ETF | 97.3 | 97.76 | 97.27 | 97.72 | 2493000.0 |
| 2003-08-06 13:30:00 | SPY | ETF | 97.72 | 97.74 | 97.44 | 97.6 | 2572100.0 |
| 2003-08-06 14:00:00 | SPY | ETF | 97.61 | 98.06 | 97.439 | 97.95 | 2970100.0 |
| 2003-08-06 14:30:00 | SPY | ETF | 97.95 | 98.02 | 97.68 | 97.72 | 3070000.0 |
| 2003-08-06 15:00:00 | SPY | ETF | 97.71 | 97.73 | 97.28 | 97.45 | 4788100.0 |
| 2003-08-06 15:30:00 | SPY | ETF | 97.435 | 97.52 | 97.07 | 97.13 | 2610700.0 |
| 2003-08-06 16:00:00 | SPY | ETF | 97.1 | 97.21 | 96.98 | 97.02 | 1717100.0 |
| 2003-08-06 16:30:00 | SPY | ETF | 97.0 | 97.05 | 97.0 | 97.05 | 22700.0 |
| 2003-08-06 17:00:00 | SPY | ETF | 97.17 | 97.17 | 96.91 | 96.91 | 28900.0 |
| 2003-08-06 17:30:00 | SPY | ETF | 96.92 | 97.17 | 96.87 | 96.9 | 622100.0 |
| 2003-08-06 18:00:00 | SPY | ETF | 97.0 | 97.04 | 97.0 | 97.04 | 600.0 |
| 2003-08-06 18:30:00 | SPY | ETF | 97.0 | 97.0 | 96.97 | 96.98 | 2200.0 |
| 2003-08-06 19:00:00 | SPY | ETF | 96.98 | 97.0 | 96.95 | 97.0 | 1500.0 |
| 2003-08-06 08:00:00 | QQQ | ETF | 30.33 | 30.37 | 30.31 | 30.37 | 28200.0 |
| 2003-08-06 08:30:00 | QQQ | ETF | 30.36 | 30.38 | 30.32 | 30.36 | 107800.0 |
| 2003-08-06 09:00:00 | QQQ | ETF | 30.36 | 30.41 | 30.35 | 30.35 | 169000.0 |
| 2003-08-06 09:30:00 | QQQ | ETF | 30.36 | 30.46 | 30.24 | 30.4 | 11391300.0 |
| 2003-08-06 10:00:00 | QQQ | ETF | 30.43 | 30.48 | 30.1 | 30.16 | 10778000.0 |
| 2003-08-06 10:30:00 | QQQ | ETF | 30.167 | 30.42 | 30.13 | 30.28 | 8454700.0 |
| 2003-08-06 11:00:00 | QQQ | ETF | 30.27 | 30.36 | 30.19 | 30.26 | 5326500.0 |
| 2003-08-06 11:30:00 | QQQ | ETF | 30.26 | 30.38 | 30.22 | 30.35 | 3695600.0 |
| 2003-08-06 12:00:00 | QQQ | ETF | 30.35 | 30.562 | 30.349 | 30.56 | 12291800.0 |
| 2003-08-06 12:30:00 | QQQ | ETF | 30.56 | 30.57 | 30.43 | 30.45 | 2528100.0 |
| 2003-08-06 13:00:00 | QQQ | ETF | 30.48 | 30.75 | 30.47 | 30.72 | 5874600.0 |
| 2003-08-06 13:30:00 | QQQ | ETF | 30.73 | 30.74 | 30.55 | 30.62 | 3519000.0 |
| 2003-08-06 14:00:00 | QQQ | ETF | 30.62 | 30.77 | 30.54 | 30.73 | 4775300.0 |
| 2003-08-06 14:30:00 | QQQ | ETF | 30.73 | 30.75 | 30.53 | 30.56 | 3746900.0 |
| 2003-08-06 15:00:00 | QQQ | ETF | 30.57 | 30.58 | 30.4 | 30.48 | 6329800.0 |
| 2003-08-06 15:30:00 | QQQ | ETF | 30.47 | 30.53 | 30.21 | 30.22 | 5965300.0 |
| 2003-08-06 16:00:00 | QQQ | ETF | 30.21 | 30.395 | 30.162 | 30.2 | 3505100.0 |
| 2003-08-06 16:30:00 | QQQ | ETF | 30.2 | 30.26 | 30.2 | 30.205 | 98200.0 |
| 2003-08-06 17:00:00 | QQQ | ETF | 30.215 | 30.215 | 30.18 | 30.19 | 39400.0 |
| 2003-08-06 17:30:00 | QQQ | ETF | 30.17 | 30.205 | 30.16 | 30.2 | 103400.0 |
| 2003-08-06 18:00:00 | QQQ | ETF | 30.19 | 30.21 | 30.19 | 30.2 | 22600.0 |
| 2003-08-06 18:30:00 | QQQ | ETF | 30.21 | 30.21 | 30.17 | 30.17 | 14700.0 |
| 2003-08-06 19:00:00 | QQQ | ETF | 30.18 | 30.18 | 30.17 | 30.18 | 4700.0 |
| 2003-08-06 19:30:00 | QQQ | ETF | 30.19 | 30.2 | 30.16 | 30.16 | 5300.0 |
| 2003-08-06 09:30:00 | IWM | ETF | 45.485 | 45.575 | 45.35 | 45.465 | 1092800.0 |
| 2003-08-06 10:00:00 | IWM | ETF | 45.48 | 45.49 | 45.15 | 45.15 | 247600.0 |
| 2003-08-06 10:30:00 | IWM | ETF | 45.15 | 45.295 | 45.13 | 45.17 | 262600.0 |
> showing 50 of 676 rows — these rows as CSV