PREVIEW / etf_30min / 2003-10-06
file: by_date/etf_30min/2003/2003-10-06.parquet size: 24 KB rows: 757
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-06 08:00:00 | SPY | ETF | 103.54 | 103.55 | 103.49 | 103.49 | 20800.0 |
| 2003-10-06 08:30:00 | SPY | ETF | 103.45 | 103.52 | 103.45 | 103.5 | 9500.0 |
| 2003-10-06 09:00:00 | SPY | ETF | 103.5 | 103.52 | 103.47 | 103.51 | 7900.0 |
| 2003-10-06 09:30:00 | SPY | ETF | 103.482 | 103.54 | 103.22 | 103.44 | 2265900.0 |
| 2003-10-06 10:00:00 | SPY | ETF | 103.44 | 103.66 | 103.3 | 103.42 | 1823000.0 |
| 2003-10-06 10:30:00 | SPY | ETF | 103.43 | 103.44 | 103.2 | 103.35 | 1007700.0 |
| 2003-10-06 11:00:00 | SPY | ETF | 103.35 | 103.532 | 103.32 | 103.43 | 793700.0 |
| 2003-10-06 11:30:00 | SPY | ETF | 103.44 | 103.6 | 103.4 | 103.54 | 663900.0 |
| 2003-10-06 12:00:00 | SPY | ETF | 103.54 | 103.88 | 103.5 | 103.83 | 1308100.0 |
| 2003-10-06 12:30:00 | SPY | ETF | 103.83 | 103.85 | 103.71 | 103.74 | 605100.0 |
| 2003-10-06 13:00:00 | SPY | ETF | 103.74 | 103.85 | 103.7 | 103.78 | 579700.0 |
| 2003-10-06 13:30:00 | SPY | ETF | 103.78 | 103.85 | 103.66 | 103.8 | 676300.0 |
| 2003-10-06 14:00:00 | SPY | ETF | 103.81 | 103.94 | 103.79 | 103.87 | 657500.0 |
| 2003-10-06 14:30:00 | SPY | ETF | 103.89 | 103.99 | 103.7 | 103.71 | 1095500.0 |
| 2003-10-06 15:00:00 | SPY | ETF | 103.72 | 103.84 | 103.58 | 103.78 | 929700.0 |
| 2003-10-06 15:30:00 | SPY | ETF | 103.76 | 103.83 | 103.68 | 103.722 | 1216500.0 |
| 2003-10-06 16:00:00 | SPY | ETF | 103.714 | 103.88 | 103.7 | 103.83 | 501500.0 |
| 2003-10-06 16:30:00 | SPY | ETF | 103.84 | 103.93 | 103.84 | 103.93 | 19000.0 |
| 2003-10-06 17:00:00 | SPY | ETF | 103.95 | 103.98 | 103.92 | 103.95 | 7200.0 |
| 2003-10-06 17:30:00 | SPY | ETF | 103.92 | 103.99 | 103.92 | 103.99 | 2200.0 |
| 2003-10-06 18:00:00 | SPY | ETF | 103.96 | 103.96 | 103.92 | 103.92 | 10600.0 |
| 2003-10-06 18:30:00 | SPY | ETF | 103.92 | 103.92 | 103.92 | 103.92 | 1000.0 |
| 2003-10-06 19:00:00 | SPY | ETF | 103.92 | 103.95 | 103.92 | 103.95 | 1300.0 |
| 2003-10-06 19:30:00 | SPY | ETF | 103.92 | 103.92 | 103.92 | 103.92 | 2700.0 |
| 2003-10-06 08:00:00 | QQQ | ETF | 34.38 | 34.39 | 34.33 | 34.35 | 101400.0 |
| 2003-10-06 08:30:00 | QQQ | ETF | 34.35 | 34.37 | 34.32 | 34.33 | 72100.0 |
| 2003-10-06 09:00:00 | QQQ | ETF | 34.33 | 34.35 | 34.29 | 34.29 | 99900.0 |
| 2003-10-06 09:30:00 | QQQ | ETF | 34.28 | 34.33 | 34.06 | 34.22 | 10800900.0 |
| 2003-10-06 10:00:00 | QQQ | ETF | 34.216 | 34.35 | 34.19 | 34.27 | 5869800.0 |
| 2003-10-06 10:30:00 | QQQ | ETF | 34.267 | 34.28 | 34.08 | 34.17 | 3003000.0 |
| 2003-10-06 11:00:00 | QQQ | ETF | 34.175 | 34.253 | 34.14 | 34.2 | 1591600.0 |
| 2003-10-06 11:30:00 | QQQ | ETF | 34.2 | 34.28 | 34.15 | 34.27 | 1828400.0 |
| 2003-10-06 12:00:00 | QQQ | ETF | 34.27 | 34.401 | 34.25 | 34.38 | 3227100.0 |
| 2003-10-06 12:30:00 | QQQ | ETF | 34.37 | 34.39 | 34.28 | 34.29 | 1319700.0 |
| 2003-10-06 13:00:00 | QQQ | ETF | 34.31 | 34.39 | 34.27 | 34.34 | 1369400.0 |
| 2003-10-06 13:30:00 | QQQ | ETF | 34.35 | 34.36 | 34.23 | 34.3 | 2365100.0 |
| 2003-10-06 14:00:00 | QQQ | ETF | 34.31 | 34.38 | 34.294 | 34.33 | 1092900.0 |
| 2003-10-06 14:30:00 | QQQ | ETF | 34.33 | 34.408 | 34.25 | 34.26 | 2949600.0 |
| 2003-10-06 15:00:00 | QQQ | ETF | 34.25 | 34.35 | 34.24 | 34.34 | 2341100.0 |
| 2003-10-06 15:30:00 | QQQ | ETF | 34.35 | 34.37 | 34.28 | 34.34 | 3302800.0 |
| 2003-10-06 16:00:00 | QQQ | ETF | 34.341 | 34.46 | 34.32 | 34.4 | 1259800.0 |
| 2003-10-06 16:30:00 | QQQ | ETF | 34.4 | 34.47 | 34.4 | 34.44 | 122800.0 |
| 2003-10-06 17:00:00 | QQQ | ETF | 34.45 | 34.45 | 34.27 | 34.45 | 68000.0 |
| 2003-10-06 17:30:00 | QQQ | ETF | 34.46 | 34.5 | 34.46 | 34.46 | 48300.0 |
| 2003-10-06 18:00:00 | QQQ | ETF | 34.46 | 34.47 | 34.45 | 34.45 | 27500.0 |
| 2003-10-06 18:30:00 | QQQ | ETF | 34.46 | 34.47 | 34.45 | 34.47 | 16300.0 |
| 2003-10-06 19:00:00 | QQQ | ETF | 34.45 | 34.47 | 34.45 | 34.47 | 10300.0 |
| 2003-10-06 19:30:00 | QQQ | ETF | 34.47 | 34.48 | 34.45 | 34.47 | 8400.0 |
| 2003-10-06 09:30:00 | IWM | ETF | 51.1 | 51.28 | 50.9 | 51.155 | 325200.0 |
| 2003-10-06 10:00:00 | IWM | ETF | 51.16 | 51.36 | 51.145 | 51.235 | 429800.0 |
> showing 50 of 757 rows — these rows as CSV