PREVIEW / etf_30min / 2003-09-18
file: by_date/etf_30min/2003/2003-09-18.parquet size: 24 KB rows: 742
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-09-18 08:00:00 | SPY | ETF | 103.28 | 103.44 | 103.28 | 103.4 | 11000.0 |
| 2003-09-18 08:30:00 | SPY | ETF | 103.44 | 103.57 | 103.44 | 103.49 | 45100.0 |
| 2003-09-18 09:00:00 | SPY | ETF | 103.47 | 103.54 | 103.45 | 103.48 | 29700.0 |
| 2003-09-18 09:30:00 | SPY | ETF | 103.4 | 103.602 | 103.2 | 103.58 | 2848400.0 |
| 2003-09-18 10:00:00 | SPY | ETF | 103.58 | 103.98 | 103.5 | 103.94 | 4018700.0 |
| 2003-09-18 10:30:00 | SPY | ETF | 103.941 | 104.05 | 103.86 | 103.99 | 3217200.0 |
| 2003-09-18 11:00:00 | SPY | ETF | 103.99 | 104.22 | 103.92 | 104.13 | 1837600.0 |
| 2003-09-18 11:30:00 | SPY | ETF | 104.14 | 104.36 | 104.13 | 104.19 | 2638200.0 |
| 2003-09-18 12:00:00 | SPY | ETF | 104.17 | 104.33 | 104.02 | 104.241 | 2094400.0 |
| 2003-09-18 12:30:00 | SPY | ETF | 104.22 | 104.33 | 104.16 | 104.21 | 984700.0 |
| 2003-09-18 13:00:00 | SPY | ETF | 104.23 | 104.34 | 104.12 | 104.31 | 741300.0 |
| 2003-09-18 13:30:00 | SPY | ETF | 104.3 | 104.59 | 104.3 | 104.5 | 1723500.0 |
| 2003-09-18 14:00:00 | SPY | ETF | 104.5 | 104.6 | 104.35 | 104.41 | 1935800.0 |
| 2003-09-18 14:30:00 | SPY | ETF | 104.41 | 104.56 | 104.38 | 104.49 | 879900.0 |
| 2003-09-18 15:00:00 | SPY | ETF | 104.49 | 104.68 | 104.44 | 104.57 | 836700.0 |
| 2003-09-18 15:30:00 | SPY | ETF | 104.64 | 104.7 | 104.53 | 104.59 | 2174400.0 |
| 2003-09-18 16:00:00 | SPY | ETF | 104.56 | 104.62 | 104.55 | 104.62 | 919500.0 |
| 2003-09-18 16:30:00 | SPY | ETF | 104.62 | 104.63 | 104.56 | 104.57 | 62600.0 |
| 2003-09-18 17:00:00 | SPY | ETF | 104.6 | 104.6 | 104.56 | 104.56 | 51300.0 |
| 2003-09-18 17:30:00 | SPY | ETF | 104.58 | 104.58 | 104.58 | 104.58 | 200.0 |
| 2003-09-18 18:00:00 | SPY | ETF | 104.58 | 104.61 | 104.58 | 104.59 | 700.0 |
| 2003-09-18 18:30:00 | SPY | ETF | 104.58 | 104.58 | 104.58 | 104.58 | 200.0 |
| 2003-09-18 19:00:00 | SPY | ETF | 104.57 | 104.57 | 104.57 | 104.57 | 100.0 |
| 2003-09-18 08:00:00 | QQQ | ETF | 34.11 | 34.18 | 34.11 | 34.17 | 34000.0 |
| 2003-09-18 08:30:00 | QQQ | ETF | 34.15 | 34.21 | 34.12 | 34.13 | 118800.0 |
| 2003-09-18 09:00:00 | QQQ | ETF | 34.12 | 34.16 | 34.12 | 34.16 | 68000.0 |
| 2003-09-18 09:30:00 | QQQ | ETF | 34.17 | 34.25 | 34.0 | 34.23 | 11513500.0 |
| 2003-09-18 10:00:00 | QQQ | ETF | 34.23 | 34.47 | 34.21 | 34.43 | 12828100.0 |
| 2003-09-18 10:30:00 | QQQ | ETF | 34.43 | 34.47 | 34.34 | 34.42 | 5102500.0 |
| 2003-09-18 11:00:00 | QQQ | ETF | 34.43 | 34.5 | 34.36 | 34.47 | 4727300.0 |
| 2003-09-18 11:30:00 | QQQ | ETF | 34.47 | 34.69 | 34.47 | 34.59 | 9898600.0 |
| 2003-09-18 12:00:00 | QQQ | ETF | 34.61 | 34.652 | 34.49 | 34.62 | 4245500.0 |
| 2003-09-18 12:30:00 | QQQ | ETF | 34.63 | 34.69 | 34.59 | 34.601 | 2893200.0 |
| 2003-09-18 13:00:00 | QQQ | ETF | 34.61 | 34.66 | 34.555 | 34.65 | 1664900.0 |
| 2003-09-18 13:30:00 | QQQ | ETF | 34.655 | 34.781 | 34.65 | 34.72 | 7851900.0 |
| 2003-09-18 14:00:00 | QQQ | ETF | 34.715 | 34.77 | 34.6 | 34.64 | 4225900.0 |
| 2003-09-18 14:30:00 | QQQ | ETF | 34.65 | 34.75 | 34.63 | 34.7 | 2335500.0 |
| 2003-09-18 15:00:00 | QQQ | ETF | 34.7 | 34.82 | 34.7 | 34.77 | 4916300.0 |
| 2003-09-18 15:30:00 | QQQ | ETF | 34.77 | 34.86 | 34.76 | 34.779 | 6888400.0 |
| 2003-09-18 16:00:00 | QQQ | ETF | 34.78 | 34.81 | 34.76 | 34.78 | 2263700.0 |
| 2003-09-18 16:30:00 | QQQ | ETF | 34.79 | 34.795 | 34.77 | 34.79 | 353000.0 |
| 2003-09-18 17:00:00 | QQQ | ETF | 34.79 | 34.81 | 34.78 | 34.795 | 47400.0 |
| 2003-09-18 17:30:00 | QQQ | ETF | 34.78 | 34.79 | 34.75 | 34.78 | 20000.0 |
| 2003-09-18 18:00:00 | QQQ | ETF | 34.78 | 34.81 | 34.77 | 34.81 | 17400.0 |
| 2003-09-18 18:30:00 | QQQ | ETF | 34.81 | 34.81 | 34.77 | 34.77 | 15800.0 |
| 2003-09-18 19:00:00 | QQQ | ETF | 34.8 | 34.8 | 34.78 | 34.8 | 1600.0 |
| 2003-09-18 19:30:00 | QQQ | ETF | 34.78 | 34.81 | 34.77 | 34.81 | 15600.0 |
| 2003-09-18 09:00:00 | IWM | ETF | 51.33 | 51.35 | 51.33 | 51.35 | 8200.0 |
| 2003-09-18 09:30:00 | IWM | ETF | 51.375 | 51.375 | 51.06 | 51.24 | 684200.0 |
| 2003-09-18 10:00:00 | IWM | ETF | 51.245 | 51.6 | 51.24 | 51.56 | 432000.0 |
> showing 50 of 742 rows — these rows as CSV