PREVIEW / etf_30min / 2003-08-19
file: by_date/etf_30min/2003/2003-08-19.parquet size: 24 KB rows: 726
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-19 08:00:00 | SPY | ETF | 100.61 | 100.64 | 100.6 | 100.64 | 17000.0 |
| 2003-08-19 08:30:00 | SPY | ETF | 100.67 | 100.79 | 100.67 | 100.75 | 71600.0 |
| 2003-08-19 09:00:00 | SPY | ETF | 100.73 | 100.77 | 100.68 | 100.69 | 42900.0 |
| 2003-08-19 09:30:00 | SPY | ETF | 100.687 | 100.81 | 100.41 | 100.49 | 5127000.0 |
| 2003-08-19 10:00:00 | SPY | ETF | 100.45 | 100.53 | 100.2 | 100.33 | 4805300.0 |
| 2003-08-19 10:30:00 | SPY | ETF | 100.35 | 100.94 | 100.32 | 100.83 | 4056200.0 |
| 2003-08-19 11:00:00 | SPY | ETF | 100.83 | 100.83 | 100.58 | 100.68 | 1525200.0 |
| 2003-08-19 11:30:00 | SPY | ETF | 100.631 | 100.808 | 100.58 | 100.77 | 1206800.0 |
| 2003-08-19 12:00:00 | SPY | ETF | 100.74 | 100.87 | 100.47 | 100.48 | 1355700.0 |
| 2003-08-19 12:30:00 | SPY | ETF | 100.51 | 100.56 | 100.31 | 100.45 | 1474600.0 |
| 2003-08-19 13:00:00 | SPY | ETF | 100.44 | 100.54 | 100.36 | 100.38 | 692700.0 |
| 2003-08-19 13:30:00 | SPY | ETF | 100.38 | 100.51 | 100.29 | 100.47 | 1580100.0 |
| 2003-08-19 14:00:00 | SPY | ETF | 100.47 | 100.53 | 100.29 | 100.36 | 874000.0 |
| 2003-08-19 14:30:00 | SPY | ETF | 100.35 | 100.42 | 100.0 | 100.2 | 3145300.0 |
| 2003-08-19 15:00:00 | SPY | ETF | 100.22 | 100.47 | 100.15 | 100.43 | 2537300.0 |
| 2003-08-19 15:30:00 | SPY | ETF | 100.43 | 100.85 | 100.33 | 100.82 | 2372000.0 |
| 2003-08-19 16:00:00 | SPY | ETF | 100.83 | 100.9 | 100.7 | 100.74 | 1142600.0 |
| 2003-08-19 16:30:00 | SPY | ETF | 100.73 | 100.76 | 100.68 | 100.7 | 255200.0 |
| 2003-08-19 17:00:00 | SPY | ETF | 100.72 | 100.72 | 100.66 | 100.68 | 311100.0 |
| 2003-08-19 17:30:00 | SPY | ETF | 100.68 | 100.68 | 100.66 | 100.66 | 6700.0 |
| 2003-08-19 18:00:00 | SPY | ETF | 100.69 | 100.71 | 100.69 | 100.71 | 8900.0 |
| 2003-08-19 18:30:00 | SPY | ETF | 100.7 | 100.7 | 100.7 | 100.7 | 500.0 |
| 2003-08-19 19:00:00 | SPY | ETF | 100.67 | 100.7 | 100.67 | 100.7 | 2700.0 |
| 2003-08-19 19:30:00 | SPY | ETF | 100.67 | 100.7 | 100.67 | 100.7 | 700.0 |
| 2003-08-19 08:00:00 | QQQ | ETF | 32.07 | 32.11 | 32.06 | 32.08 | 54600.0 |
| 2003-08-19 08:30:00 | QQQ | ETF | 32.1 | 32.15 | 32.1 | 32.13 | 127700.0 |
| 2003-08-19 09:00:00 | QQQ | ETF | 32.12 | 32.15 | 32.09 | 32.1 | 166900.0 |
| 2003-08-19 09:30:00 | QQQ | ETF | 32.11 | 32.171 | 31.97 | 32.01 | 10247000.0 |
| 2003-08-19 10:00:00 | QQQ | ETF | 32.01 | 32.05 | 31.846 | 31.966 | 7362400.0 |
| 2003-08-19 10:30:00 | QQQ | ETF | 31.964 | 32.27 | 31.95 | 32.25 | 7284800.0 |
| 2003-08-19 11:00:00 | QQQ | ETF | 32.253 | 32.27 | 32.1 | 32.162 | 4032500.0 |
| 2003-08-19 11:30:00 | QQQ | ETF | 32.162 | 32.25 | 32.11 | 32.23 | 2833700.0 |
| 2003-08-19 12:00:00 | QQQ | ETF | 32.221 | 32.312 | 32.15 | 32.18 | 3295300.0 |
| 2003-08-19 12:30:00 | QQQ | ETF | 32.175 | 32.22 | 32.09 | 32.154 | 3356200.0 |
| 2003-08-19 13:00:00 | QQQ | ETF | 32.152 | 32.2 | 32.11 | 32.13 | 1755000.0 |
| 2003-08-19 13:30:00 | QQQ | ETF | 32.13 | 32.23 | 32.11 | 32.171 | 1677700.0 |
| 2003-08-19 14:00:00 | QQQ | ETF | 32.19 | 32.22 | 32.11 | 32.16 | 1573500.0 |
| 2003-08-19 14:30:00 | QQQ | ETF | 32.16 | 32.18 | 32.004 | 32.09 | 3514600.0 |
| 2003-08-19 15:00:00 | QQQ | ETF | 32.09 | 32.27 | 32.07 | 32.22 | 2989100.0 |
| 2003-08-19 15:30:00 | QQQ | ETF | 32.22 | 32.37 | 32.15 | 32.36 | 6147300.0 |
| 2003-08-19 16:00:00 | QQQ | ETF | 32.36 | 32.4 | 32.2 | 32.241 | 3167000.0 |
| 2003-08-19 16:30:00 | QQQ | ETF | 32.23 | 32.31 | 32.18 | 32.19 | 422700.0 |
| 2003-08-19 17:00:00 | QQQ | ETF | 32.2 | 32.3 | 32.16 | 32.18 | 163700.0 |
| 2003-08-19 17:30:00 | QQQ | ETF | 32.18 | 32.21 | 32.18 | 32.199 | 76600.0 |
| 2003-08-19 18:00:00 | QQQ | ETF | 32.2 | 32.21 | 32.17 | 32.18 | 71600.0 |
| 2003-08-19 18:30:00 | QQQ | ETF | 32.19 | 32.21 | 32.18 | 32.2 | 24600.0 |
| 2003-08-19 19:00:00 | QQQ | ETF | 32.18 | 32.22 | 32.18 | 32.2 | 2500.0 |
| 2003-08-19 19:30:00 | QQQ | ETF | 32.18 | 32.22 | 32.18 | 32.19 | 10400.0 |
| 2003-08-19 09:00:00 | IWM | ETF | 48.2 | 48.2 | 48.2 | 48.2 | 1000.0 |
| 2003-08-19 09:30:00 | IWM | ETF | 48.275 | 48.425 | 48.145 | 48.155 | 883000.0 |
> showing 50 of 726 rows — these rows as CSV