PREVIEW / etf_30min / 2003-10-01
file: by_date/etf_30min/2003/2003-10-01.parquet size: 25 KB rows: 745
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-10-01 08:00:00 | SPY | ETF | 100.32 | 100.33 | 100.26 | 100.28 | 13900.0 |
| 2003-10-01 08:30:00 | SPY | ETF | 100.27 | 100.31 | 100.2 | 100.25 | 21900.0 |
| 2003-10-01 09:00:00 | SPY | ETF | 100.25 | 100.27 | 100.23 | 100.24 | 7000.0 |
| 2003-10-01 09:30:00 | SPY | ETF | 100.24 | 100.78 | 100.2 | 100.65 | 5070200.0 |
| 2003-10-01 10:00:00 | SPY | ETF | 100.61 | 100.93 | 100.44 | 100.7 | 6383100.0 |
| 2003-10-01 10:30:00 | SPY | ETF | 100.69 | 100.81 | 100.41 | 100.427 | 3602300.0 |
| 2003-10-01 11:00:00 | SPY | ETF | 100.42 | 100.89 | 100.41 | 100.85 | 1874300.0 |
| 2003-10-01 11:30:00 | SPY | ETF | 100.83 | 101.08 | 100.78 | 100.97 | 3086900.0 |
| 2003-10-01 12:00:00 | SPY | ETF | 100.94 | 101.3 | 100.88 | 101.29 | 1848600.0 |
| 2003-10-01 12:30:00 | SPY | ETF | 101.3 | 101.33 | 101.11 | 101.19 | 1935000.0 |
| 2003-10-01 13:00:00 | SPY | ETF | 101.19 | 101.33 | 101.15 | 101.31 | 1655400.0 |
| 2003-10-01 13:30:00 | SPY | ETF | 101.26 | 101.6 | 101.19 | 101.56 | 4456800.0 |
| 2003-10-01 14:00:00 | SPY | ETF | 101.51 | 101.62 | 101.28 | 101.39 | 6478900.0 |
| 2003-10-01 14:30:00 | SPY | ETF | 101.37 | 101.63 | 101.32 | 101.46 | 2496400.0 |
| 2003-10-01 15:00:00 | SPY | ETF | 101.45 | 101.95 | 101.43 | 101.92 | 4602400.0 |
| 2003-10-01 15:30:00 | SPY | ETF | 101.92 | 102.12 | 101.82 | 102.0 | 7445200.0 |
| 2003-10-01 16:00:00 | SPY | ETF | 102.0 | 102.57 | 101.95 | 102.11 | 2825700.0 |
| 2003-10-01 16:30:00 | SPY | ETF | 102.1 | 102.1 | 102.028 | 102.06 | 70500.0 |
| 2003-10-01 17:00:00 | SPY | ETF | 102.01 | 102.08 | 101.98 | 101.98 | 45600.0 |
| 2003-10-01 17:30:00 | SPY | ETF | 102.04 | 102.05 | 102.01 | 102.03 | 53400.0 |
| 2003-10-01 18:00:00 | SPY | ETF | 102.03 | 102.05 | 102.03 | 102.05 | 1100.0 |
| 2003-10-01 18:30:00 | SPY | ETF | 102.07 | 102.07 | 102.07 | 102.07 | 200.0 |
| 2003-10-01 19:00:00 | SPY | ETF | 102.04 | 102.06 | 102.02 | 102.02 | 2600.0 |
| 2003-10-01 08:00:00 | QQQ | ETF | 32.63 | 32.65 | 32.6 | 32.63 | 57800.0 |
| 2003-10-01 08:30:00 | QQQ | ETF | 32.63 | 32.65 | 32.63 | 32.63 | 58800.0 |
| 2003-10-01 09:00:00 | QQQ | ETF | 32.65 | 32.65 | 32.6 | 32.6 | 78300.0 |
| 2003-10-01 09:30:00 | QQQ | ETF | 32.61 | 32.87 | 32.6 | 32.8 | 11798600.0 |
| 2003-10-01 10:00:00 | QQQ | ETF | 32.788 | 32.97 | 32.71 | 32.77 | 9846500.0 |
| 2003-10-01 10:30:00 | QQQ | ETF | 32.774 | 32.83 | 32.45 | 32.47 | 10720500.0 |
| 2003-10-01 11:00:00 | QQQ | ETF | 32.465 | 32.76 | 32.42 | 32.716 | 5737300.0 |
| 2003-10-01 11:30:00 | QQQ | ETF | 32.72 | 32.82 | 32.66 | 32.719 | 5145700.0 |
| 2003-10-01 12:00:00 | QQQ | ETF | 32.71 | 32.88 | 32.68 | 32.88 | 3956200.0 |
| 2003-10-01 12:30:00 | QQQ | ETF | 32.87 | 32.91 | 32.77 | 32.83 | 3489600.0 |
| 2003-10-01 13:00:00 | QQQ | ETF | 32.82 | 32.94 | 32.82 | 32.87 | 3514600.0 |
| 2003-10-01 13:30:00 | QQQ | ETF | 32.87 | 33.066 | 32.86 | 33.04 | 8816100.0 |
| 2003-10-01 14:00:00 | QQQ | ETF | 33.04 | 33.07 | 32.92 | 32.947 | 6254300.0 |
| 2003-10-01 14:30:00 | QQQ | ETF | 32.96 | 33.02 | 32.88 | 32.901 | 5502700.0 |
| 2003-10-01 15:00:00 | QQQ | ETF | 32.9 | 33.17 | 32.896 | 33.14 | 5948800.0 |
| 2003-10-01 15:30:00 | QQQ | ETF | 33.14 | 33.23 | 33.06 | 33.13 | 10215800.0 |
| 2003-10-01 16:00:00 | QQQ | ETF | 33.13 | 33.19 | 33.09 | 33.121 | 3623400.0 |
| 2003-10-01 16:30:00 | QQQ | ETF | 33.121 | 33.159 | 33.119 | 33.12 | 36300.0 |
| 2003-10-01 17:00:00 | QQQ | ETF | 33.14 | 33.159 | 33.12 | 33.15 | 73700.0 |
| 2003-10-01 17:30:00 | QQQ | ETF | 33.145 | 33.19 | 33.12 | 33.13 | 128400.0 |
| 2003-10-01 18:00:00 | QQQ | ETF | 33.14 | 33.16 | 33.14 | 33.14 | 48300.0 |
| 2003-10-01 18:30:00 | QQQ | ETF | 33.15 | 33.16 | 33.14 | 33.15 | 5700.0 |
| 2003-10-01 19:00:00 | QQQ | ETF | 33.15 | 33.15 | 33.15 | 33.15 | 1300.0 |
| 2003-10-01 19:30:00 | QQQ | ETF | 33.15 | 33.15 | 33.14 | 33.14 | 3700.0 |
| 2003-10-01 08:30:00 | IWM | ETF | 48.75 | 48.75 | 48.75 | 48.75 | 6000.0 |
| 2003-10-01 09:00:00 | IWM | ETF | 48.775 | 48.775 | 48.775 | 48.775 | 400.0 |
| 2003-10-01 09:30:00 | IWM | ETF | 48.685 | 49.17 | 48.65 | 49.125 | 880000.0 |
> showing 50 of 745 rows — these rows as CSV