PREVIEW / etf_30min / 2003-10-22
file: by_date/etf_30min/2003/2003-10-22.parquet size: 26 KB rows: 810
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-22 08:00:00 | SPY | ETF | 104.27 | 104.28 | 104.19 | 104.23 | 133100.0 |
| 2003-10-22 08:30:00 | SPY | ETF | 104.26 | 104.26 | 104.19 | 104.2 | 38600.0 |
| 2003-10-22 09:00:00 | SPY | ETF | 104.2 | 104.23 | 104.03 | 104.04 | 172900.0 |
| 2003-10-22 09:30:00 | SPY | ETF | 104.03 | 104.091 | 103.75 | 103.828 | 4506000.0 |
| 2003-10-22 10:00:00 | SPY | ETF | 103.83 | 104.19 | 103.77 | 104.113 | 3532400.0 |
| 2003-10-22 10:30:00 | SPY | ETF | 104.11 | 104.12 | 103.56 | 103.66 | 2958900.0 |
| 2003-10-22 11:00:00 | SPY | ETF | 103.69 | 103.77 | 103.55 | 103.73 | 1764500.0 |
| 2003-10-22 11:30:00 | SPY | ETF | 103.72 | 103.78 | 103.59 | 103.7 | 1028800.0 |
| 2003-10-22 12:00:00 | SPY | ETF | 103.71 | 103.75 | 103.58 | 103.7 | 755600.0 |
| 2003-10-22 12:30:00 | SPY | ETF | 103.72 | 103.72 | 103.51 | 103.61 | 1638500.0 |
| 2003-10-22 13:00:00 | SPY | ETF | 103.584 | 103.62 | 103.4 | 103.498 | 1450900.0 |
| 2003-10-22 13:30:00 | SPY | ETF | 103.51 | 103.51 | 103.19 | 103.359 | 2566500.0 |
| 2003-10-22 14:00:00 | SPY | ETF | 103.349 | 103.44 | 103.19 | 103.27 | 1598600.0 |
| 2003-10-22 14:30:00 | SPY | ETF | 103.27 | 103.59 | 103.21 | 103.51 | 2760500.0 |
| 2003-10-22 15:00:00 | SPY | ETF | 103.55 | 103.65 | 103.299 | 103.32 | 1798700.0 |
| 2003-10-22 15:30:00 | SPY | ETF | 103.33 | 103.55 | 103.26 | 103.4 | 3105700.0 |
| 2003-10-22 16:00:00 | SPY | ETF | 103.42 | 103.65 | 103.41 | 103.47 | 1412400.0 |
| 2003-10-22 16:30:00 | SPY | ETF | 103.47 | 103.49 | 103.42 | 103.45 | 131100.0 |
| 2003-10-22 17:00:00 | SPY | ETF | 103.523 | 103.53 | 103.09 | 103.2 | 371400.0 |
| 2003-10-22 17:30:00 | SPY | ETF | 103.19 | 103.2 | 103.08 | 103.18 | 120000.0 |
| 2003-10-22 18:00:00 | SPY | ETF | 103.17 | 103.19 | 103.1 | 103.18 | 23900.0 |
| 2003-10-22 18:30:00 | SPY | ETF | 103.18 | 103.22 | 103.18 | 103.22 | 4600.0 |
| 2003-10-22 19:00:00 | SPY | ETF | 103.25 | 103.25 | 103.23 | 103.23 | 4700.0 |
| 2003-10-22 19:30:00 | SPY | ETF | 103.21 | 103.21 | 103.16 | 103.2 | 1500.0 |
| 2003-10-22 08:00:00 | QQQ | ETF | 35.0 | 35.0 | 34.91 | 34.92 | 110100.0 |
| 2003-10-22 08:30:00 | QQQ | ETF | 34.93 | 34.96 | 34.93 | 34.93 | 62200.0 |
| 2003-10-22 09:00:00 | QQQ | ETF | 34.93 | 34.94 | 34.86 | 34.9 | 207500.0 |
| 2003-10-22 09:30:00 | QQQ | ETF | 34.89 | 34.929 | 34.68 | 34.79 | 14173000.0 |
| 2003-10-22 10:00:00 | QQQ | ETF | 34.78 | 34.93 | 34.73 | 34.86 | 5952200.0 |
| 2003-10-22 10:30:00 | QQQ | ETF | 34.86 | 34.87 | 34.56 | 34.66 | 8559800.0 |
| 2003-10-22 11:00:00 | QQQ | ETF | 34.679 | 34.73 | 34.63 | 34.66 | 7699100.0 |
| 2003-10-22 11:30:00 | QQQ | ETF | 34.67 | 34.73 | 34.62 | 34.709 | 3667400.0 |
| 2003-10-22 12:00:00 | QQQ | ETF | 34.71 | 34.72 | 34.61 | 34.67 | 1574900.0 |
| 2003-10-22 12:30:00 | QQQ | ETF | 34.68 | 34.7 | 34.58 | 34.61 | 2033000.0 |
| 2003-10-22 13:00:00 | QQQ | ETF | 34.61 | 34.62 | 34.464 | 34.56 | 5859200.0 |
| 2003-10-22 13:30:00 | QQQ | ETF | 34.54 | 34.57 | 34.44 | 34.52 | 4936500.0 |
| 2003-10-22 14:00:00 | QQQ | ETF | 34.53 | 34.59 | 34.48 | 34.55 | 3575700.0 |
| 2003-10-22 14:30:00 | QQQ | ETF | 34.56 | 34.67 | 34.51 | 34.61 | 5873800.0 |
| 2003-10-22 15:00:00 | QQQ | ETF | 34.61 | 34.67 | 34.49 | 34.52 | 5106400.0 |
| 2003-10-22 15:30:00 | QQQ | ETF | 34.529 | 34.64 | 34.46 | 34.56 | 7210600.0 |
| 2003-10-22 16:00:00 | QQQ | ETF | 34.562 | 34.61 | 34.4 | 34.52 | 2825200.0 |
| 2003-10-22 16:30:00 | QQQ | ETF | 34.52 | 34.52 | 34.48 | 34.52 | 330300.0 |
| 2003-10-22 17:00:00 | QQQ | ETF | 34.499 | 34.52 | 34.15 | 34.24 | 1371400.0 |
| 2003-10-22 17:30:00 | QQQ | ETF | 34.24 | 34.29 | 34.2 | 34.24 | 338800.0 |
| 2003-10-22 18:00:00 | QQQ | ETF | 34.242 | 34.27 | 34.21 | 34.26 | 311300.0 |
| 2003-10-22 18:30:00 | QQQ | ETF | 34.25 | 34.25 | 34.23 | 34.25 | 42500.0 |
| 2003-10-22 19:00:00 | QQQ | ETF | 34.24 | 34.26 | 34.23 | 34.25 | 16100.0 |
| 2003-10-22 19:30:00 | QQQ | ETF | 34.26 | 34.27 | 34.25 | 34.26 | 21800.0 |
| 2003-10-22 09:30:00 | IWM | ETF | 51.833 | 51.945 | 51.405 | 51.4725 | 1034200.0 |
| 2003-10-22 10:00:00 | IWM | ETF | 51.51 | 51.75 | 51.47 | 51.69 | 277800.0 |
> showing 50 of 810 rows — these rows as CSV