PREVIEW / etf_30min / 2003-09-23
file: by_date/etf_30min/2003/2003-09-23.parquet size: 24 KB rows: 740
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-23 08:00:00 | SPY | ETF | 102.78 | 102.94 | 102.77 | 102.85 | 35500.0 |
| 2003-09-23 08:30:00 | SPY | ETF | 102.8 | 102.83 | 102.66 | 102.66 | 55800.0 |
| 2003-09-23 09:00:00 | SPY | ETF | 102.65 | 102.7 | 102.57 | 102.65 | 42600.0 |
| 2003-09-23 09:30:00 | SPY | ETF | 102.59 | 102.91 | 102.43 | 102.84 | 4341300.0 |
| 2003-09-23 10:00:00 | SPY | ETF | 102.82 | 102.98 | 102.65 | 102.94 | 2168700.0 |
| 2003-09-23 10:30:00 | SPY | ETF | 102.95 | 103.0 | 102.58 | 102.6 | 2131100.0 |
| 2003-09-23 11:00:00 | SPY | ETF | 102.59 | 102.64 | 102.41 | 102.53 | 3546900.0 |
| 2003-09-23 11:30:00 | SPY | ETF | 102.54 | 102.62 | 102.36 | 102.6 | 1836400.0 |
| 2003-09-23 12:00:00 | SPY | ETF | 102.6 | 102.77 | 102.58 | 102.73 | 1209900.0 |
| 2003-09-23 12:30:00 | SPY | ETF | 102.71 | 102.79 | 102.64 | 102.67 | 540700.0 |
| 2003-09-23 13:00:00 | SPY | ETF | 102.67 | 102.88 | 102.58 | 102.83 | 589700.0 |
| 2003-09-23 13:30:00 | SPY | ETF | 102.82 | 102.94 | 102.75 | 102.78 | 2374600.0 |
| 2003-09-23 14:00:00 | SPY | ETF | 102.77 | 102.94 | 102.68 | 102.751 | 1140700.0 |
| 2003-09-23 14:30:00 | SPY | ETF | 102.77 | 103.02 | 102.73 | 102.98 | 1398700.0 |
| 2003-09-23 15:00:00 | SPY | ETF | 102.99 | 103.24 | 102.99 | 103.21 | 2169300.0 |
| 2003-09-23 15:30:00 | SPY | ETF | 103.21 | 103.29 | 103.041 | 103.09 | 1878200.0 |
| 2003-09-23 16:00:00 | SPY | ETF | 103.1 | 103.1 | 102.94 | 102.98 | 1763400.0 |
| 2003-09-23 16:30:00 | SPY | ETF | 102.98 | 103.04 | 102.94 | 103.01 | 53000.0 |
| 2003-09-23 17:00:00 | SPY | ETF | 103.02 | 103.03 | 102.94 | 102.95 | 4400.0 |
| 2003-09-23 17:30:00 | SPY | ETF | 102.95 | 102.98 | 102.94 | 102.98 | 23200.0 |
| 2003-09-23 18:00:00 | SPY | ETF | 102.95 | 103.0 | 102.95 | 102.99 | 500.0 |
| 2003-09-23 19:30:00 | SPY | ETF | 102.97 | 103.0 | 102.97 | 103.0 | 900.0 |
| 2003-09-23 08:00:00 | QQQ | ETF | 33.99 | 34.08 | 33.99 | 34.05 | 124700.0 |
| 2003-09-23 08:30:00 | QQQ | ETF | 34.05 | 34.08 | 33.97 | 34.0 | 91500.0 |
| 2003-09-23 09:00:00 | QQQ | ETF | 34.0 | 34.01 | 33.97 | 33.98 | 108200.0 |
| 2003-09-23 09:30:00 | QQQ | ETF | 33.97 | 34.23 | 33.91 | 34.16 | 9249800.0 |
| 2003-09-23 10:00:00 | QQQ | ETF | 34.15 | 34.3 | 34.12 | 34.282 | 7529400.0 |
| 2003-09-23 10:30:00 | QQQ | ETF | 34.27 | 34.33 | 34.166 | 34.17 | 4621200.0 |
| 2003-09-23 11:00:00 | QQQ | ETF | 34.17 | 34.21 | 34.088 | 34.158 | 5906000.0 |
| 2003-09-23 11:30:00 | QQQ | ETF | 34.16 | 34.18 | 33.97 | 34.09 | 4799900.0 |
| 2003-09-23 12:00:00 | QQQ | ETF | 34.086 | 34.209 | 34.07 | 34.16 | 2781600.0 |
| 2003-09-23 12:30:00 | QQQ | ETF | 34.157 | 34.21 | 34.12 | 34.19 | 2235100.0 |
| 2003-09-23 13:00:00 | QQQ | ETF | 34.18 | 34.26 | 34.12 | 34.25 | 2508800.0 |
| 2003-09-23 13:30:00 | QQQ | ETF | 34.254 | 34.33 | 34.206 | 34.22 | 3666500.0 |
| 2003-09-23 14:00:00 | QQQ | ETF | 34.22 | 34.32 | 34.19 | 34.243 | 3196600.0 |
| 2003-09-23 14:30:00 | QQQ | ETF | 34.243 | 34.4 | 34.22 | 34.38 | 4364200.0 |
| 2003-09-23 15:00:00 | QQQ | ETF | 34.37 | 34.49 | 34.35 | 34.476 | 6077000.0 |
| 2003-09-23 15:30:00 | QQQ | ETF | 34.476 | 34.56 | 34.42 | 34.469 | 7704100.0 |
| 2003-09-23 16:00:00 | QQQ | ETF | 34.46 | 34.52 | 34.44 | 34.51 | 2215700.0 |
| 2003-09-23 16:30:00 | QQQ | ETF | 34.52 | 34.57 | 34.49 | 34.569 | 467500.0 |
| 2003-09-23 17:00:00 | QQQ | ETF | 34.56 | 34.569 | 34.49 | 34.49 | 73300.0 |
| 2003-09-23 17:30:00 | QQQ | ETF | 34.5 | 34.51 | 34.49 | 34.5 | 17300.0 |
| 2003-09-23 18:00:00 | QQQ | ETF | 34.5 | 34.52 | 34.49 | 34.52 | 6000.0 |
| 2003-09-23 18:30:00 | QQQ | ETF | 34.51 | 34.51 | 34.5 | 34.5 | 1400.0 |
| 2003-09-23 19:00:00 | QQQ | ETF | 34.5 | 34.51 | 34.49 | 34.51 | 8300.0 |
| 2003-09-23 19:30:00 | QQQ | ETF | 34.5 | 34.55 | 34.49 | 34.53 | 9800.0 |
| 2003-09-23 09:30:00 | IWM | ETF | 51.15 | 51.475 | 51.15 | 51.45 | 857000.0 |
| 2003-09-23 10:00:00 | IWM | ETF | 51.47 | 51.625 | 51.455 | 51.625 | 423400.0 |
| 2003-09-23 10:30:00 | IWM | ETF | 51.635 | 51.695 | 51.49 | 51.495 | 355200.0 |
| 2003-09-23 11:00:00 | IWM | ETF | 51.495 | 51.525 | 51.435 | 51.465 | 267200.0 |
> showing 50 of 740 rows — these rows as CSV