PREVIEW / etf_30min / 2003-07-08
file: by_date/etf_30min/2003/2003-07-08.parquet size: 24 KB rows: 724
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-07-08 08:00:00 | SPY | ETF | 100.6 | 100.6 | 100.48 | 100.48 | 21600.0 |
| 2003-07-08 08:30:00 | SPY | ETF | 100.48 | 100.48 | 100.29 | 100.37 | 53400.0 |
| 2003-07-08 09:00:00 | SPY | ETF | 100.36 | 100.52 | 100.35 | 100.47 | 28800.0 |
| 2003-07-08 09:30:00 | SPY | ETF | 100.5 | 100.79 | 100.37 | 100.396 | 3248100.0 |
| 2003-07-08 10:00:00 | SPY | ETF | 100.4 | 100.6 | 100.17 | 100.5 | 3339400.0 |
| 2003-07-08 10:30:00 | SPY | ETF | 100.5 | 100.97 | 100.45 | 100.83 | 2251400.0 |
| 2003-07-08 11:00:00 | SPY | ETF | 100.85 | 101.0 | 100.68 | 100.9 | 1538400.0 |
| 2003-07-08 11:30:00 | SPY | ETF | 100.88 | 100.98 | 100.73 | 100.92 | 998600.0 |
| 2003-07-08 12:00:00 | SPY | ETF | 100.93 | 100.95 | 100.48 | 100.63 | 3267300.0 |
| 2003-07-08 12:30:00 | SPY | ETF | 100.62 | 100.81 | 100.55 | 100.75 | 753400.0 |
| 2003-07-08 13:00:00 | SPY | ETF | 100.73 | 100.85 | 100.55 | 100.61 | 691600.0 |
| 2003-07-08 13:30:00 | SPY | ETF | 100.61 | 100.84 | 100.57 | 100.59 | 693900.0 |
| 2003-07-08 14:00:00 | SPY | ETF | 100.6 | 100.83 | 100.48 | 100.79 | 1155700.0 |
| 2003-07-08 14:30:00 | SPY | ETF | 100.78 | 100.89 | 100.63 | 100.82 | 819500.0 |
| 2003-07-08 15:00:00 | SPY | ETF | 100.82 | 100.97 | 100.68 | 100.96 | 2318600.0 |
| 2003-07-08 15:30:00 | SPY | ETF | 100.95 | 101.29 | 100.93 | 101.03 | 3887600.0 |
| 2003-07-08 16:00:00 | SPY | ETF | 101.03 | 101.2 | 101.0 | 101.08 | 1826400.0 |
| 2003-07-08 16:30:00 | SPY | ETF | 101.01 | 101.11 | 100.95 | 101.099 | 314500.0 |
| 2003-07-08 17:00:00 | SPY | ETF | 101.05 | 101.06 | 101.01 | 101.01 | 46600.0 |
| 2003-07-08 17:30:00 | SPY | ETF | 101.021 | 101.021 | 101.0 | 101.0 | 2201500.0 |
| 2003-07-08 18:00:00 | SPY | ETF | 101.01 | 101.05 | 101.0 | 101.042 | 2500.0 |
| 2003-07-08 18:30:00 | SPY | ETF | 101.04 | 101.05 | 101.04 | 101.05 | 3000.0 |
| 2003-07-08 19:30:00 | SPY | ETF | 101.06 | 101.06 | 101.06 | 101.06 | 100.0 |
| 2003-07-08 08:00:00 | QQQ | ETF | 31.85 | 31.87 | 31.79 | 31.79 | 53200.0 |
| 2003-07-08 08:30:00 | QQQ | ETF | 31.8 | 31.8 | 31.72 | 31.76 | 94600.0 |
| 2003-07-08 09:00:00 | QQQ | ETF | 31.76 | 31.83 | 31.76 | 31.8 | 116700.0 |
| 2003-07-08 09:30:00 | QQQ | ETF | 31.78 | 31.98 | 31.696 | 31.72 | 10157100.0 |
| 2003-07-08 10:00:00 | QQQ | ETF | 31.719 | 31.87 | 31.62 | 31.8 | 10637800.0 |
| 2003-07-08 10:30:00 | QQQ | ETF | 31.79 | 31.96 | 31.76 | 31.9 | 5995400.0 |
| 2003-07-08 11:00:00 | QQQ | ETF | 31.93 | 32.06 | 31.86 | 32.01 | 5737200.0 |
| 2003-07-08 11:30:00 | QQQ | ETF | 32.02 | 32.08 | 31.96 | 32.08 | 3522700.0 |
| 2003-07-08 12:00:00 | QQQ | ETF | 32.07 | 32.08 | 31.83 | 31.94 | 4579600.0 |
| 2003-07-08 12:30:00 | QQQ | ETF | 31.92 | 32.03 | 31.9 | 32.0 | 3366000.0 |
| 2003-07-08 13:00:00 | QQQ | ETF | 32.0 | 32.05 | 31.93 | 31.97 | 2210200.0 |
| 2003-07-08 13:30:00 | QQQ | ETF | 31.97 | 32.06 | 31.96 | 31.993 | 3179700.0 |
| 2003-07-08 14:00:00 | QQQ | ETF | 32.0 | 32.1 | 31.92 | 32.06 | 3526600.0 |
| 2003-07-08 14:30:00 | QQQ | ETF | 32.059 | 32.15 | 31.98 | 32.08 | 3360400.0 |
| 2003-07-08 15:00:00 | QQQ | ETF | 32.11 | 32.217 | 32.04 | 32.2 | 4863100.0 |
| 2003-07-08 15:30:00 | QQQ | ETF | 32.201 | 32.31 | 32.15 | 32.221 | 12616700.0 |
| 2003-07-08 16:00:00 | QQQ | ETF | 32.18 | 32.31 | 31.9908 | 32.21 | 2613800.0 |
| 2003-07-08 16:30:00 | QQQ | ETF | 32.21 | 32.26 | 32.21 | 32.21 | 67500.0 |
| 2003-07-08 17:00:00 | QQQ | ETF | 32.22 | 32.22 | 31.944 | 32.19 | 88300.0 |
| 2003-07-08 17:30:00 | QQQ | ETF | 32.183 | 32.19 | 32.08 | 32.16 | 409000.0 |
| 2003-07-08 18:00:00 | QQQ | ETF | 32.16 | 32.17 | 32.13 | 32.16 | 16100.0 |
| 2003-07-08 18:30:00 | QQQ | ETF | 32.16 | 32.19 | 32.16 | 32.17 | 18500.0 |
| 2003-07-08 19:00:00 | QQQ | ETF | 32.18 | 32.18 | 32.16 | 32.16 | 6900.0 |
| 2003-07-08 19:30:00 | QQQ | ETF | 32.16 | 32.17 | 32.13 | 32.15 | 20200.0 |
| 2003-07-08 09:30:00 | IWM | ETF | 46.4 | 46.565 | 46.344 | 46.42 | 471000.0 |
| 2003-07-08 10:00:00 | IWM | ETF | 46.43 | 46.625 | 46.365 | 46.6 | 304800.0 |
| 2003-07-08 10:30:00 | IWM | ETF | 46.575 | 46.8 | 46.575 | 46.75 | 211600.0 |
> showing 50 of 724 rows — these rows as CSV