PREVIEW / etf_30min / 2003-07-11
file: by_date/etf_30min/2003/2003-07-11.parquet size: 23 KB rows: 702
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-11 08:00:00 | SPY | ETF | 99.2 | 99.41 | 99.15 | 99.34 | 44500.0 |
| 2003-07-11 08:30:00 | SPY | ETF | 99.35 | 99.45 | 99.17 | 99.45 | 72000.0 |
| 2003-07-11 09:00:00 | SPY | ETF | 99.47 | 99.56 | 99.38 | 99.41 | 176400.0 |
| 2003-07-11 09:30:00 | SPY | ETF | 99.39 | 99.99 | 99.39 | 99.84 | 5360500.0 |
| 2003-07-11 10:00:00 | SPY | ETF | 99.86 | 100.19 | 99.56 | 100.14 | 4115900.0 |
| 2003-07-11 10:30:00 | SPY | ETF | 100.15 | 100.3 | 100.0 | 100.02 | 4041900.0 |
| 2003-07-11 11:00:00 | SPY | ETF | 100.04 | 100.2 | 99.81 | 100.09 | 2033900.0 |
| 2003-07-11 11:30:00 | SPY | ETF | 100.1 | 100.35 | 100.05 | 100.33 | 1276400.0 |
| 2003-07-11 12:00:00 | SPY | ETF | 100.32 | 100.45 | 100.15 | 100.32 | 1342700.0 |
| 2003-07-11 12:30:00 | SPY | ETF | 100.32 | 100.34 | 100.15 | 100.16 | 1323900.0 |
| 2003-07-11 13:00:00 | SPY | ETF | 100.17 | 100.27 | 100.04 | 100.19 | 1228200.0 |
| 2003-07-11 13:30:00 | SPY | ETF | 100.19 | 100.27 | 100.06 | 100.2 | 770200.0 |
| 2003-07-11 14:00:00 | SPY | ETF | 100.19 | 100.28 | 99.9 | 99.97 | 1683900.0 |
| 2003-07-11 14:30:00 | SPY | ETF | 99.96 | 99.97 | 99.61 | 99.71 | 2302000.0 |
| 2003-07-11 15:00:00 | SPY | ETF | 99.71 | 100.11 | 99.6 | 99.99 | 1884200.0 |
| 2003-07-11 15:30:00 | SPY | ETF | 99.99 | 100.27 | 99.85 | 100.14 | 2039500.0 |
| 2003-07-11 16:00:00 | SPY | ETF | 100.13 | 100.29 | 99.2025 | 100.22 | 4980100.0 |
| 2003-07-11 16:30:00 | SPY | ETF | 100.22 | 100.26 | 100.19 | 100.2 | 80200.0 |
| 2003-07-11 17:00:00 | SPY | ETF | 100.25 | 100.25 | 100.15 | 100.15 | 10200.0 |
| 2003-07-11 17:30:00 | SPY | ETF | 100.18 | 100.2 | 100.15 | 100.15 | 99500.0 |
| 2003-07-11 18:00:00 | SPY | ETF | 100.22 | 100.23 | 100.22 | 100.23 | 600.0 |
| 2003-07-11 19:00:00 | SPY | ETF | 100.24 | 100.24 | 100.17 | 100.17 | 1800.0 |
| 2003-07-11 19:30:00 | SPY | ETF | 100.17 | 100.17 | 100.15 | 100.15 | 900.0 |
| 2003-07-11 08:00:00 | QQQ | ETF | 31.52 | 31.58 | 31.51 | 31.55 | 91300.0 |
| 2003-07-11 08:30:00 | QQQ | ETF | 31.55 | 31.64 | 31.49 | 31.63 | 70800.0 |
| 2003-07-11 09:00:00 | QQQ | ETF | 31.63 | 31.7 | 31.63 | 31.65 | 138700.0 |
| 2003-07-11 09:30:00 | QQQ | ETF | 31.652 | 31.85 | 31.65 | 31.82 | 10779200.0 |
| 2003-07-11 10:00:00 | QQQ | ETF | 31.819 | 31.96 | 31.71 | 31.94 | 6051600.0 |
| 2003-07-11 10:30:00 | QQQ | ETF | 31.94 | 31.99 | 31.83 | 31.855 | 6772600.0 |
| 2003-07-11 11:00:00 | QQQ | ETF | 31.85 | 31.9 | 31.765 | 31.863 | 2848400.0 |
| 2003-07-11 11:30:00 | QQQ | ETF | 31.856 | 31.98 | 31.76 | 31.95 | 5012000.0 |
| 2003-07-11 12:00:00 | QQQ | ETF | 31.96 | 31.98 | 31.86 | 31.9 | 5732300.0 |
| 2003-07-11 12:30:00 | QQQ | ETF | 31.92 | 31.97 | 31.84 | 31.87 | 2998700.0 |
| 2003-07-11 13:00:00 | QQQ | ETF | 31.87 | 31.94 | 31.82 | 31.91 | 2659200.0 |
| 2003-07-11 13:30:00 | QQQ | ETF | 31.9 | 31.94 | 31.85 | 31.89 | 1920700.0 |
| 2003-07-11 14:00:00 | QQQ | ETF | 31.9 | 31.92 | 31.72 | 31.76 | 4055400.0 |
| 2003-07-11 14:30:00 | QQQ | ETF | 31.759 | 31.78 | 31.61 | 31.67 | 5005300.0 |
| 2003-07-11 15:00:00 | QQQ | ETF | 31.671 | 31.83 | 31.62 | 31.76 | 2831900.0 |
| 2003-07-11 15:30:00 | QQQ | ETF | 31.77 | 31.93 | 31.66 | 31.839 | 4148100.0 |
| 2003-07-11 16:00:00 | QQQ | ETF | 31.84 | 31.87 | 31.8 | 31.85 | 1404900.0 |
| 2003-07-11 16:30:00 | QQQ | ETF | 31.86 | 31.92 | 31.86 | 31.91 | 65300.0 |
| 2003-07-11 17:00:00 | QQQ | ETF | 31.92 | 31.93 | 31.91 | 31.92 | 49500.0 |
| 2003-07-11 17:30:00 | QQQ | ETF | 31.92 | 31.96 | 31.92 | 31.94 | 39000.0 |
| 2003-07-11 18:00:00 | QQQ | ETF | 31.94 | 31.94 | 31.92 | 31.92 | 11600.0 |
| 2003-07-11 18:30:00 | QQQ | ETF | 31.93 | 31.94 | 31.91 | 31.94 | 10400.0 |
| 2003-07-11 19:00:00 | QQQ | ETF | 31.92 | 31.94 | 31.92 | 31.94 | 2900.0 |
| 2003-07-11 19:30:00 | QQQ | ETF | 31.94 | 31.98 | 31.92 | 31.97 | 25900.0 |
| 2003-07-11 09:30:00 | IWM | ETF | 46.86 | 47.175 | 46.8 | 47.1 | 364200.0 |
| 2003-07-11 10:00:00 | IWM | ETF | 47.13 | 47.21 | 47.01 | 47.21 | 329400.0 |
| 2003-07-11 10:30:00 | IWM | ETF | 47.22 | 47.35 | 47.2 | 47.25 | 206400.0 |
> showing 50 of 702 rows — these rows as CSV