PREVIEW / etf_30min / 2006-09-08
file: by_date/etf_30min/2006/2006-09-08.parquet size: 75 KB rows: 2,693
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-08 04:00:00 | SPY | ETF | 130.29 | 130.29 | 130.29 | 130.29 | 100.0 |
| 2006-09-08 07:00:00 | SPY | ETF | 130.07 | 130.15 | 130.07 | 130.15 | 83800.0 |
| 2006-09-08 07:30:00 | SPY | ETF | 130.15 | 130.24 | 130.14 | 130.24 | 37200.0 |
| 2006-09-08 08:00:00 | SPY | ETF | 130.22 | 130.22 | 130.09 | 130.18 | 2485200.0 |
| 2006-09-08 08:30:00 | SPY | ETF | 130.19 | 130.22 | 130.18 | 130.2 | 674400.0 |
| 2006-09-08 09:00:00 | SPY | ETF | 130.2 | 130.2 | 130.1 | 130.1 | 262400.0 |
| 2006-09-08 09:30:00 | SPY | ETF | 130.08 | 130.16 | 129.98 | 130.06 | 4946800.0 |
| 2006-09-08 10:00:00 | SPY | ETF | 130.06 | 130.08 | 129.84 | 130.03 | 3217500.0 |
| 2006-09-08 10:30:00 | SPY | ETF | 130.03 | 130.12 | 129.83 | 130.11 | 2802600.0 |
| 2006-09-08 11:00:00 | SPY | ETF | 130.11 | 130.17 | 130.03 | 130.1 | 3613400.0 |
| 2006-09-08 11:30:00 | SPY | ETF | 130.1 | 130.15 | 130.01 | 130.04 | 1490200.0 |
| 2006-09-08 12:00:00 | SPY | ETF | 130.02 | 130.09 | 129.91 | 129.95 | 1968500.0 |
| 2006-09-08 12:30:00 | SPY | ETF | 129.96 | 130.12 | 129.94 | 130.1 | 817100.0 |
| 2006-09-08 13:00:00 | SPY | ETF | 130.11 | 130.25 | 130.02 | 130.22 | 1905400.0 |
| 2006-09-08 13:30:00 | SPY | ETF | 130.21 | 130.43 | 130.1 | 130.41 | 3399600.0 |
| 2006-09-08 14:00:00 | SPY | ETF | 130.41 | 130.46 | 130.26 | 130.27 | 4291300.0 |
| 2006-09-08 14:30:00 | SPY | ETF | 130.26 | 130.36 | 130.22 | 130.34 | 1769000.0 |
| 2006-09-08 15:00:00 | SPY | ETF | 130.33 | 130.42 | 130.15 | 130.39 | 2794700.0 |
| 2006-09-08 15:30:00 | SPY | ETF | 130.39 | 130.41 | 130.23 | 130.3 | 4998400.0 |
| 2006-09-08 16:00:00 | SPY | ETF | 130.31 | 130.33 | 130.1 | 130.18 | 2344400.0 |
| 2006-09-08 16:30:00 | SPY | ETF | 130.2 | 130.2 | 130.13 | 130.2 | 7800.0 |
| 2006-09-08 17:00:00 | SPY | ETF | 130.19 | 130.22 | 130.15 | 130.22 | 1400.0 |
| 2006-09-08 17:30:00 | SPY | ETF | 130.22 | 130.22 | 130.22 | 130.22 | 300.0 |
| 2006-09-08 18:00:00 | SPY | ETF | 130.23 | 130.25 | 130.2 | 130.2 | 11400.0 |
| 2006-09-08 09:30:00 | QQQ | ETF | 38.54 | 38.63 | 38.46 | 38.59 | 9832800.0 |
| 2006-09-08 10:00:00 | QQQ | ETF | 38.58 | 38.62 | 38.47 | 38.59 | 7624400.0 |
| 2006-09-08 10:30:00 | QQQ | ETF | 38.58 | 38.65 | 38.49 | 38.65 | 6650600.0 |
| 2006-09-08 11:00:00 | QQQ | ETF | 38.65 | 38.69 | 38.59 | 38.63 | 5705200.0 |
| 2006-09-08 11:30:00 | QQQ | ETF | 38.63 | 38.63 | 38.56 | 38.59 | 4478600.0 |
| 2006-09-08 12:00:00 | QQQ | ETF | 38.59 | 38.62 | 38.52 | 38.54 | 3886300.0 |
| 2006-09-08 12:30:00 | QQQ | ETF | 38.54 | 38.64 | 38.54 | 38.64 | 2084500.0 |
| 2006-09-08 13:00:00 | QQQ | ETF | 38.64 | 38.72 | 38.59 | 38.7 | 5731200.0 |
| 2006-09-08 13:30:00 | QQQ | ETF | 38.7 | 38.79 | 38.66 | 38.79 | 4837000.0 |
| 2006-09-08 14:00:00 | QQQ | ETF | 38.79 | 38.82 | 38.64 | 38.71 | 7128100.0 |
| 2006-09-08 14:30:00 | QQQ | ETF | 38.71 | 38.77 | 38.69 | 38.74 | 2504500.0 |
| 2006-09-08 15:00:00 | QQQ | ETF | 38.74 | 38.82 | 38.65 | 38.8 | 8116200.0 |
| 2006-09-08 15:30:00 | QQQ | ETF | 38.8 | 38.8 | 38.68 | 38.72 | 12650700.0 |
| 2006-09-08 07:30:00 | IWM | ETF | 70.48 | 70.55 | 70.48 | 70.55 | 31000.0 |
| 2006-09-08 08:00:00 | IWM | ETF | 70.5 | 70.55 | 70.47 | 70.54 | 63100.0 |
| 2006-09-08 08:30:00 | IWM | ETF | 70.6 | 70.6 | 70.53 | 70.53 | 32800.0 |
| 2006-09-08 09:00:00 | IWM | ETF | 70.5 | 70.54 | 70.44 | 70.53 | 124500.0 |
| 2006-09-08 09:30:00 | IWM | ETF | 70.53 | 70.63 | 70.21 | 70.35 | 3316500.0 |
| 2006-09-08 10:00:00 | IWM | ETF | 70.35 | 70.41 | 70.17 | 70.41 | 2534700.0 |
| 2006-09-08 10:30:00 | IWM | ETF | 70.41 | 70.49 | 70.21 | 70.48 | 2007700.0 |
| 2006-09-08 11:00:00 | IWM | ETF | 70.48 | 70.5 | 70.35 | 70.43 | 816800.0 |
| 2006-09-08 11:30:00 | IWM | ETF | 70.43 | 70.47 | 70.3 | 70.35 | 815600.0 |
| 2006-09-08 12:00:00 | IWM | ETF | 70.35 | 70.38 | 70.26 | 70.31 | 2117200.0 |
| 2006-09-08 12:30:00 | IWM | ETF | 70.3 | 70.49 | 70.27 | 70.47 | 1210800.0 |
| 2006-09-08 13:00:00 | IWM | ETF | 70.47 | 70.55 | 70.38 | 70.49 | 1025900.0 |
| 2006-09-08 13:30:00 | IWM | ETF | 70.49 | 70.64 | 70.41 | 70.63 | 1301300.0 |
> showing 50 of 2,693 rows — these rows as CSV