PREVIEW / etf_30min / 2001-11-05
file: by_date/etf_30min/2001/2001-11-05.parquet size: 15 KB rows: 403
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-05 09:30:00 | SPY | ETF | 110.12 | 110.8 | 109.95 | 110.63 | 3961500.0 |
| 2001-11-05 10:00:00 | SPY | ETF | 110.61 | 111.04 | 110.36 | 111.04 | 1961900.0 |
| 2001-11-05 10:30:00 | SPY | ETF | 111.07 | 111.09 | 110.7 | 110.78 | 1010200.0 |
| 2001-11-05 11:00:00 | SPY | ETF | 110.78 | 110.94 | 110.61 | 110.72 | 666600.0 |
| 2001-11-05 11:30:00 | SPY | ETF | 110.72 | 110.72 | 110.25 | 110.25 | 1327700.0 |
| 2001-11-05 12:00:00 | SPY | ETF | 110.27 | 110.48 | 110.17 | 110.38 | 1092600.0 |
| 2001-11-05 12:30:00 | SPY | ETF | 110.35 | 110.41 | 110.15 | 110.31 | 334400.0 |
| 2001-11-05 13:00:00 | SPY | ETF | 110.28 | 110.6 | 110.22 | 110.37 | 379700.0 |
| 2001-11-05 13:30:00 | SPY | ETF | 110.35 | 110.82 | 110.28 | 110.79 | 960400.0 |
| 2001-11-05 14:00:00 | SPY | ETF | 110.72 | 110.94 | 110.62 | 110.7 | 427800.0 |
| 2001-11-05 14:30:00 | SPY | ETF | 110.68 | 110.91 | 110.55 | 110.89 | 591300.0 |
| 2001-11-05 15:00:00 | SPY | ETF | 110.87 | 111.05 | 110.75 | 110.8 | 916300.0 |
| 2001-11-05 15:30:00 | SPY | ETF | 110.82 | 110.91 | 110.32 | 110.58 | 1457600.0 |
| 2001-11-05 16:00:00 | SPY | ETF | 110.61 | 110.85 | 110.5 | 110.82 | 777400.0 |
| 2001-11-05 16:30:00 | SPY | ETF | 110.85 | 111.08 | 107.76 | 111.0 | 35100.0 |
| 2001-11-05 17:00:00 | SPY | ETF | 111.1 | 111.15 | 110.96 | 111.15 | 6300.0 |
| 2001-11-05 17:30:00 | SPY | ETF | 111.24 | 111.24 | 110.7 | 110.8 | 19400.0 |
| 2001-11-05 18:00:00 | SPY | ETF | 110.62 | 110.9 | 110.5 | 110.9 | 112700.0 |
| 2001-11-05 09:30:00 | QQQ | ETF | 36.26 | 36.67 | 36.16 | 36.46 | 10335100.0 |
| 2001-11-05 10:00:00 | QQQ | ETF | 36.47 | 36.8 | 36.3 | 36.76 | 7902600.0 |
| 2001-11-05 10:30:00 | QQQ | ETF | 36.75 | 36.8 | 36.52 | 36.62 | 3483200.0 |
| 2001-11-05 11:00:00 | QQQ | ETF | 36.63 | 36.84 | 36.58 | 36.71 | 3415900.0 |
| 2001-11-05 11:30:00 | QQQ | ETF | 36.7 | 36.76 | 36.52 | 36.54 | 2581000.0 |
| 2001-11-05 12:00:00 | QQQ | ETF | 36.54 | 36.69 | 36.51 | 36.64 | 1965400.0 |
| 2001-11-05 12:30:00 | QQQ | ETF | 36.62 | 36.72 | 36.57 | 36.7 | 917800.0 |
| 2001-11-05 13:00:00 | QQQ | ETF | 36.69 | 36.82 | 36.67 | 36.68 | 1667100.0 |
| 2001-11-05 13:30:00 | QQQ | ETF | 36.69 | 37.01 | 36.66 | 36.96 | 4977300.0 |
| 2001-11-05 14:00:00 | QQQ | ETF | 36.96 | 37.1 | 36.86 | 36.9 | 3400300.0 |
| 2001-11-05 14:30:00 | QQQ | ETF | 36.86 | 37.1 | 36.82 | 37.1 | 3759500.0 |
| 2001-11-05 15:00:00 | QQQ | ETF | 37.04 | 37.16 | 36.94 | 36.97 | 6251100.0 |
| 2001-11-05 15:30:00 | QQQ | ETF | 36.97 | 37.04 | 36.7 | 36.84 | 8053100.0 |
| 2001-11-05 16:00:00 | QQQ | ETF | 36.82 | 37.33 | 36.74 | 37.3 | 2199500.0 |
| 2001-11-05 16:30:00 | QQQ | ETF | 37.3 | 37.41 | 37.07 | 37.2 | 1136200.0 |
| 2001-11-05 17:00:00 | QQQ | ETF | 37.2 | 37.39 | 37.18 | 37.28 | 374400.0 |
| 2001-11-05 17:30:00 | QQQ | ETF | 37.25 | 37.36 | 36.9 | 37.28 | 349700.0 |
| 2001-11-05 18:00:00 | QQQ | ETF | 37.3 | 37.31 | 37.24 | 37.26 | 194900.0 |
| 2001-11-05 10:00:00 | IWM | ETF | 43.6 | 43.625 | 43.5 | 43.625 | 39400.0 |
| 2001-11-05 10:30:00 | IWM | ETF | 43.65 | 43.65 | 43.465 | 43.5 | 8200.0 |
| 2001-11-05 11:00:00 | IWM | ETF | 43.5 | 43.65 | 43.5 | 43.595 | 34000.0 |
| 2001-11-05 11:30:00 | IWM | ETF | 43.595 | 43.6 | 43.475 | 43.535 | 44200.0 |
| 2001-11-05 12:00:00 | IWM | ETF | 43.5 | 43.525 | 43.46 | 43.475 | 9400.0 |
| 2001-11-05 12:30:00 | IWM | ETF | 43.44 | 43.445 | 43.42 | 43.42 | 3600.0 |
| 2001-11-05 13:00:00 | IWM | ETF | 43.42 | 43.44 | 43.42 | 43.44 | 2200.0 |
| 2001-11-05 13:30:00 | IWM | ETF | 43.44 | 43.5 | 43.4 | 43.5 | 9000.0 |
| 2001-11-05 14:00:00 | IWM | ETF | 43.55 | 43.55 | 43.485 | 43.545 | 39800.0 |
| 2001-11-05 14:30:00 | IWM | ETF | 43.54 | 43.54 | 43.44 | 43.495 | 16600.0 |
| 2001-11-05 15:00:00 | IWM | ETF | 43.495 | 43.58 | 43.495 | 43.535 | 10800.0 |
| 2001-11-05 15:30:00 | IWM | ETF | 43.52 | 43.53 | 43.31 | 43.485 | 35400.0 |
| 2001-11-05 16:00:00 | IWM | ETF | 43.625 | 43.625 | 43.54 | 43.54 | 43600.0 |
| 2001-11-05 17:00:00 | IWM | ETF | 43.625 | 43.625 | 43.625 | 43.625 | 2000.0 |
> showing 50 of 403 rows — these rows as CSV