PREVIEW / etf_30min / 2003-06-23
file: by_date/etf_30min/2003/2003-06-23.parquet size: 24 KB rows: 713
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-06-23 08:00:00 | SPY | ETF | 99.45 | 99.49 | 99.45 | 99.47 | 6600.0 |
| 2003-06-23 08:30:00 | SPY | ETF | 99.48 | 99.48 | 99.4 | 99.43 | 5600.0 |
| 2003-06-23 09:00:00 | SPY | ETF | 99.41 | 99.47 | 99.41 | 99.45 | 7300.0 |
| 2003-06-23 09:30:00 | SPY | ETF | 99.48 | 99.64 | 99.03 | 99.21 | 4266900.0 |
| 2003-06-23 10:00:00 | SPY | ETF | 99.21 | 99.24 | 98.53 | 98.56 | 5390500.0 |
| 2003-06-23 10:30:00 | SPY | ETF | 98.57 | 98.68 | 98.36 | 98.56 | 2912600.0 |
| 2003-06-23 11:00:00 | SPY | ETF | 98.54 | 98.6 | 98.26 | 98.41 | 2400400.0 |
| 2003-06-23 11:30:00 | SPY | ETF | 98.42 | 98.5 | 98.19 | 98.25 | 933200.0 |
| 2003-06-23 12:00:00 | SPY | ETF | 98.26 | 98.4 | 98.13 | 98.34 | 1726400.0 |
| 2003-06-23 12:30:00 | SPY | ETF | 98.33 | 98.38 | 98.17 | 98.21 | 885100.0 |
| 2003-06-23 13:00:00 | SPY | ETF | 98.2 | 98.38 | 98.13 | 98.3 | 691500.0 |
| 2003-06-23 13:30:00 | SPY | ETF | 98.29 | 98.4 | 98.12 | 98.33 | 1230700.0 |
| 2003-06-23 14:00:00 | SPY | ETF | 98.32 | 98.42 | 98.15 | 98.22 | 1023700.0 |
| 2003-06-23 14:30:00 | SPY | ETF | 98.24 | 98.32 | 98.0 | 98.022 | 2186400.0 |
| 2003-06-23 15:00:00 | SPY | ETF | 98.03 | 98.19 | 97.92 | 98.15 | 2154200.0 |
| 2003-06-23 15:30:00 | SPY | ETF | 98.14 | 98.46 | 98.06 | 98.36 | 3283400.0 |
| 2003-06-23 16:00:00 | SPY | ETF | 98.37 | 98.52 | 98.36 | 98.4 | 829300.0 |
| 2003-06-23 16:30:00 | SPY | ETF | 98.43 | 98.69 | 98.34 | 98.52 | 107800.0 |
| 2003-06-23 17:00:00 | SPY | ETF | 98.54 | 98.54 | 98.49 | 98.51 | 14200.0 |
| 2003-06-23 17:30:00 | SPY | ETF | 98.51 | 98.54 | 98.49 | 98.5 | 17000.0 |
| 2003-06-23 18:00:00 | SPY | ETF | 98.5 | 98.528 | 98.47 | 98.47 | 50200.0 |
| 2003-06-23 18:30:00 | SPY | ETF | 98.52 | 98.53 | 98.46 | 98.53 | 4000.0 |
| 2003-06-23 19:00:00 | SPY | ETF | 98.47 | 98.47 | 98.31 | 98.31 | 14700.0 |
| 2003-06-23 19:30:00 | SPY | ETF | 98.3 | 98.36 | 98.25 | 98.35 | 5500.0 |
| 2003-06-23 08:00:00 | QQQ | ETF | 30.31 | 30.36 | 30.28 | 30.3 | 25000.0 |
| 2003-06-23 08:30:00 | QQQ | ETF | 30.3 | 30.33 | 30.3 | 30.31 | 20800.0 |
| 2003-06-23 09:00:00 | QQQ | ETF | 30.3 | 30.35 | 30.3 | 30.34 | 16600.0 |
| 2003-06-23 09:30:00 | QQQ | ETF | 30.33 | 30.371 | 30.15 | 30.28 | 10416300.0 |
| 2003-06-23 10:00:00 | QQQ | ETF | 30.28 | 30.28 | 29.91 | 29.93 | 13211200.0 |
| 2003-06-23 10:30:00 | QQQ | ETF | 29.95 | 29.95 | 29.77 | 29.91 | 7722100.0 |
| 2003-06-23 11:00:00 | QQQ | ETF | 29.92 | 29.923 | 29.67 | 29.81 | 7319000.0 |
| 2003-06-23 11:30:00 | QQQ | ETF | 29.8 | 29.85 | 29.67 | 29.697 | 2824600.0 |
| 2003-06-23 12:00:00 | QQQ | ETF | 29.695 | 29.79 | 29.61 | 29.75 | 4450100.0 |
| 2003-06-23 12:30:00 | QQQ | ETF | 29.76 | 29.79 | 29.67 | 29.691 | 3745800.0 |
| 2003-06-23 13:00:00 | QQQ | ETF | 29.68 | 29.78 | 29.66 | 29.75 | 2244800.0 |
| 2003-06-23 13:30:00 | QQQ | ETF | 29.75 | 29.782 | 29.67 | 29.738 | 3299800.0 |
| 2003-06-23 14:00:00 | QQQ | ETF | 29.74 | 29.77 | 29.66 | 29.698 | 2407300.0 |
| 2003-06-23 14:30:00 | QQQ | ETF | 29.7 | 29.71 | 29.58 | 29.59 | 4375700.0 |
| 2003-06-23 15:00:00 | QQQ | ETF | 29.59 | 29.73 | 29.56 | 29.701 | 4578700.0 |
| 2003-06-23 15:30:00 | QQQ | ETF | 29.7 | 29.84 | 29.66 | 29.77 | 6882300.0 |
| 2003-06-23 16:00:00 | QQQ | ETF | 29.77 | 29.94 | 29.75 | 29.89 | 2328700.0 |
| 2003-06-23 16:30:00 | QQQ | ETF | 29.89 | 30.4119 | 29.87 | 29.9 | 2138600.0 |
| 2003-06-23 17:00:00 | QQQ | ETF | 29.89 | 29.919 | 29.88 | 29.91 | 32600.0 |
| 2003-06-23 17:30:00 | QQQ | ETF | 29.91 | 29.92 | 29.89 | 29.92 | 6000.0 |
| 2003-06-23 18:00:00 | QQQ | ETF | 29.902 | 29.92 | 29.87 | 29.91 | 64300.0 |
| 2003-06-23 18:30:00 | QQQ | ETF | 29.88 | 29.9 | 29.87 | 29.89 | 12200.0 |
| 2003-06-23 19:00:00 | QQQ | ETF | 29.88 | 29.88 | 29.8 | 29.8 | 30200.0 |
| 2003-06-23 19:30:00 | QQQ | ETF | 29.81 | 29.82 | 29.78 | 29.81 | 21700.0 |
| 2003-06-23 09:30:00 | IWM | ETF | 44.675 | 44.85 | 44.45 | 44.49 | 432000.0 |
| 2003-06-23 10:00:00 | IWM | ETF | 44.49 | 44.49 | 44.085 | 44.085 | 236800.0 |
> showing 50 of 713 rows — these rows as CSV