PREVIEW / etf_30min / 2003-11-18
file: by_date/etf_30min/2003/2003-11-18.parquet size: 28 KB rows: 851
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-11-18 08:00:00 | SPY | ETF | 105.09 | 105.12 | 105.05 | 105.1 | 10000.0 |
| 2003-11-18 08:30:00 | SPY | ETF | 105.12 | 105.22 | 105.07 | 105.2 | 189400.0 |
| 2003-11-18 09:00:00 | SPY | ETF | 105.21 | 105.25 | 105.17 | 105.24 | 92400.0 |
| 2003-11-18 09:30:00 | SPY | ETF | 105.24 | 105.45 | 105.19 | 105.329 | 3676700.0 |
| 2003-11-18 10:00:00 | SPY | ETF | 105.35 | 105.39 | 105.03 | 105.18 | 2349900.0 |
| 2003-11-18 10:30:00 | SPY | ETF | 105.2 | 105.2 | 104.78 | 105.01 | 2589100.0 |
| 2003-11-18 11:00:00 | SPY | ETF | 105.01 | 105.2 | 104.82 | 105.15 | 1161100.0 |
| 2003-11-18 11:30:00 | SPY | ETF | 105.14 | 105.23 | 104.79 | 104.81 | 1288900.0 |
| 2003-11-18 12:00:00 | SPY | ETF | 104.81 | 104.87 | 104.68 | 104.8 | 2298000.0 |
| 2003-11-18 12:30:00 | SPY | ETF | 104.8 | 104.94 | 104.7 | 104.89 | 817600.0 |
| 2003-11-18 13:00:00 | SPY | ETF | 104.9 | 105.03 | 104.81 | 104.87 | 1372100.0 |
| 2003-11-18 13:30:00 | SPY | ETF | 104.84 | 104.92 | 104.37 | 104.43 | 1943400.0 |
| 2003-11-18 14:00:00 | SPY | ETF | 104.41 | 104.52 | 104.27 | 104.44 | 3405000.0 |
| 2003-11-18 14:30:00 | SPY | ETF | 104.43 | 104.45 | 104.03 | 104.23 | 3054900.0 |
| 2003-11-18 15:00:00 | SPY | ETF | 104.22 | 104.38 | 104.02 | 104.37 | 3171300.0 |
| 2003-11-18 15:30:00 | SPY | ETF | 104.38 | 104.39 | 103.9 | 103.91 | 3749300.0 |
| 2003-11-18 16:00:00 | SPY | ETF | 103.93 | 103.96 | 103.7 | 103.85 | 2663200.0 |
| 2003-11-18 16:30:00 | SPY | ETF | 103.88 | 104.912 | 103.81 | 103.86 | 2178700.0 |
| 2003-11-18 17:00:00 | SPY | ETF | 103.86 | 103.86 | 103.79 | 103.82 | 10000.0 |
| 2003-11-18 17:30:00 | SPY | ETF | 103.82 | 103.86 | 103.82 | 103.84 | 6100.0 |
| 2003-11-18 18:00:00 | SPY | ETF | 103.81 | 103.82 | 103.81 | 103.81 | 2800.0 |
| 2003-11-18 18:30:00 | SPY | ETF | 103.8 | 103.8 | 103.77 | 103.77 | 400.0 |
| 2003-11-18 19:00:00 | SPY | ETF | 103.77 | 103.77 | 103.71 | 103.71 | 200.0 |
| 2003-11-18 19:30:00 | SPY | ETF | 103.74 | 103.74 | 103.7 | 103.7 | 1000.0 |
| 2003-11-18 08:00:00 | QQQ | ETF | 34.81 | 34.83 | 34.79 | 34.82 | 170800.0 |
| 2003-11-18 08:30:00 | QQQ | ETF | 34.82 | 34.85 | 34.79 | 34.84 | 81200.0 |
| 2003-11-18 09:00:00 | QQQ | ETF | 34.83 | 34.89 | 34.83 | 34.86 | 227300.0 |
| 2003-11-18 09:30:00 | QQQ | ETF | 34.87 | 34.97 | 34.8 | 34.87 | 11695400.0 |
| 2003-11-18 10:00:00 | QQQ | ETF | 34.87 | 34.89 | 34.69 | 34.778 | 7797500.0 |
| 2003-11-18 10:30:00 | QQQ | ETF | 34.78 | 34.8 | 34.54 | 34.68 | 7949600.0 |
| 2003-11-18 11:00:00 | QQQ | ETF | 34.684 | 34.8 | 34.57 | 34.735 | 4167500.0 |
| 2003-11-18 11:30:00 | QQQ | ETF | 34.732 | 34.78 | 34.48 | 34.5 | 5873800.0 |
| 2003-11-18 12:00:00 | QQQ | ETF | 34.49 | 34.52 | 34.407 | 34.49 | 7252500.0 |
| 2003-11-18 12:30:00 | QQQ | ETF | 34.491 | 34.543 | 34.43 | 34.506 | 1656900.0 |
| 2003-11-18 13:00:00 | QQQ | ETF | 34.51 | 34.62 | 34.479 | 34.519 | 2717300.0 |
| 2003-11-18 13:30:00 | QQQ | ETF | 34.52 | 34.54 | 34.27 | 34.33 | 4441200.0 |
| 2003-11-18 14:00:00 | QQQ | ETF | 34.32 | 34.42 | 34.21 | 34.31 | 9043000.0 |
| 2003-11-18 14:30:00 | QQQ | ETF | 34.323 | 34.34 | 34.12 | 34.208 | 6010100.0 |
| 2003-11-18 15:00:00 | QQQ | ETF | 34.21 | 34.27 | 34.08 | 34.23 | 9832900.0 |
| 2003-11-18 15:30:00 | QQQ | ETF | 34.23 | 34.26 | 33.95 | 33.98 | 11438000.0 |
| 2003-11-18 16:00:00 | QQQ | ETF | 33.98 | 34.005 | 33.81 | 33.84 | 5754700.0 |
| 2003-11-18 16:30:00 | QQQ | ETF | 33.85 | 33.89 | 33.85 | 33.88 | 215400.0 |
| 2003-11-18 17:00:00 | QQQ | ETF | 33.87 | 33.89 | 33.86 | 33.89 | 52000.0 |
| 2003-11-18 17:30:00 | QQQ | ETF | 33.87 | 33.9 | 33.86 | 33.87 | 34100.0 |
| 2003-11-18 18:00:00 | QQQ | ETF | 33.87 | 33.88 | 33.85 | 33.88 | 71500.0 |
| 2003-11-18 18:30:00 | QQQ | ETF | 33.87 | 33.88 | 33.83 | 33.83 | 21900.0 |
| 2003-11-18 19:00:00 | QQQ | ETF | 33.83 | 33.85 | 33.8 | 33.8 | 12800.0 |
| 2003-11-18 19:30:00 | QQQ | ETF | 33.8 | 33.81 | 33.79 | 33.79 | 12500.0 |
| 2003-11-18 09:00:00 | IWM | ETF | 52.68 | 52.68 | 52.68 | 52.68 | 600.0 |
| 2003-11-18 09:30:00 | IWM | ETF | 52.775 | 53.095 | 52.73 | 53.025 | 1156800.0 |
> showing 50 of 851 rows — these rows as CSV