PREVIEW / etf_30min / 2005-08-31
file: by_date/etf_30min/2005/2005-08-31.parquet size: 49 KB rows: 1,667
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-31 04:00:00 | SPY | ETF | 121.05 | 121.07 | 121.05 | 121.06 | 18300.0 |
| 2005-08-31 07:00:00 | SPY | ETF | 121.12 | 121.48 | 121.11 | 121.48 | 166500.0 |
| 2005-08-31 07:30:00 | SPY | ETF | 121.45 | 121.54 | 121.3 | 121.41 | 565800.0 |
| 2005-08-31 08:00:00 | SPY | ETF | 121.4 | 121.54 | 121.09 | 121.25 | 1089700.0 |
| 2005-08-31 08:30:00 | SPY | ETF | 121.24 | 121.41 | 121.01 | 121.15 | 1700200.0 |
| 2005-08-31 09:00:00 | SPY | ETF | 121.13 | 121.33 | 121.06 | 121.18 | 990900.0 |
| 2005-08-31 09:30:00 | SPY | ETF | 121.19 | 121.46 | 121.01 | 121.04 | 6350200.0 |
| 2005-08-31 10:00:00 | SPY | ETF | 121.04 | 121.13 | 120.74 | 120.99 | 12205900.0 |
| 2005-08-31 10:30:00 | SPY | ETF | 120.98 | 121.38 | 120.89 | 121.19 | 8515200.0 |
| 2005-08-31 11:00:00 | SPY | ETF | 121.19 | 121.64 | 121.11 | 121.47 | 7392400.0 |
| 2005-08-31 11:30:00 | SPY | ETF | 121.49 | 121.6 | 121.36 | 121.44 | 2502700.0 |
| 2005-08-31 12:00:00 | SPY | ETF | 121.44 | 121.5 | 121.03 | 121.08 | 6393100.0 |
| 2005-08-31 12:30:00 | SPY | ETF | 121.08 | 121.33 | 121.07 | 121.16 | 3294100.0 |
| 2005-08-31 13:00:00 | SPY | ETF | 121.16 | 121.56 | 121.1 | 121.44 | 3551600.0 |
| 2005-08-31 13:30:00 | SPY | ETF | 121.44 | 121.68 | 121.26 | 121.54 | 6401300.0 |
| 2005-08-31 14:00:00 | SPY | ETF | 121.55 | 121.62 | 121.26 | 121.49 | 3401900.0 |
| 2005-08-31 14:30:00 | SPY | ETF | 121.49 | 121.84 | 121.46 | 121.82 | 4749300.0 |
| 2005-08-31 15:00:00 | SPY | ETF | 121.8 | 122.1 | 121.71 | 122.08 | 8541300.0 |
| 2005-08-31 15:30:00 | SPY | ETF | 122.07 | 122.48 | 121.17 | 122.39 | 12632900.0 |
| 2005-08-31 16:00:00 | SPY | ETF | 122.37 | 122.67 | 122.35 | 122.5 | 2918500.0 |
| 2005-08-31 16:30:00 | SPY | ETF | 122.49 | 122.53 | 122.35 | 122.5 | 431300.0 |
| 2005-08-31 17:00:00 | SPY | ETF | 122.48 | 122.54 | 122.46 | 122.47 | 278900.0 |
| 2005-08-31 17:30:00 | SPY | ETF | 122.46 | 122.5 | 122.46 | 122.49 | 4800.0 |
| 2005-08-31 18:00:00 | SPY | ETF | 122.52 | 122.53 | 122.49 | 122.52 | 34000.0 |
| 2005-08-31 18:30:00 | SPY | ETF | 122.51 | 122.51 | 122.51 | 122.51 | 16200.0 |
| 2005-08-31 19:00:00 | SPY | ETF | 122.49 | 122.49 | 122.47 | 122.47 | 23800.0 |
| 2005-08-31 19:30:00 | SPY | ETF | 122.46 | 122.49 | 122.45 | 122.49 | 1000.0 |
| 2005-08-31 09:30:00 | QQQ | ETF | 38.64 | 38.74 | 38.55 | 38.57 | 7891900.0 |
| 2005-08-31 10:00:00 | QQQ | ETF | 38.57 | 38.65 | 38.48 | 38.53 | 11408100.0 |
| 2005-08-31 10:30:00 | QQQ | ETF | 38.53 | 38.69 | 38.49 | 38.53 | 8198200.0 |
| 2005-08-31 11:00:00 | QQQ | ETF | 38.53 | 38.74 | 38.49 | 38.65 | 9143300.0 |
| 2005-08-31 11:30:00 | QQQ | ETF | 38.66 | 38.7 | 38.59 | 38.6 | 3745700.0 |
| 2005-08-31 12:00:00 | QQQ | ETF | 38.6 | 38.63 | 38.52 | 38.54 | 2966000.0 |
| 2005-08-31 12:30:00 | QQQ | ETF | 38.54 | 38.59 | 38.51 | 38.53 | 2445700.0 |
| 2005-08-31 13:00:00 | QQQ | ETF | 38.53 | 38.69 | 38.5 | 38.64 | 4826800.0 |
| 2005-08-31 13:30:00 | QQQ | ETF | 38.64 | 38.76 | 38.61 | 38.71 | 6211900.0 |
| 2005-08-31 14:00:00 | QQQ | ETF | 38.71 | 38.71 | 38.61 | 38.66 | 2859800.0 |
| 2005-08-31 14:30:00 | QQQ | ETF | 38.67 | 38.79 | 38.66 | 38.78 | 5073500.0 |
| 2005-08-31 15:00:00 | QQQ | ETF | 38.77 | 38.91 | 38.75 | 38.9 | 8253600.0 |
| 2005-08-31 15:30:00 | QQQ | ETF | 38.9 | 39.01 | 38.89 | 38.99 | 11986100.0 |
| 2005-08-31 07:00:00 | IWM | ETF | 65.11 | 65.11 | 65.11 | 65.11 | 2000.0 |
| 2005-08-31 07:30:00 | IWM | ETF | 65.21 | 65.23 | 65.2 | 65.21 | 25000.0 |
| 2005-08-31 08:00:00 | IWM | ETF | 65.29 | 65.31 | 65.21 | 65.22 | 19000.0 |
| 2005-08-31 08:30:00 | IWM | ETF | 65.2 | 65.2 | 65.05 | 65.05 | 200200.0 |
| 2005-08-31 09:00:00 | IWM | ETF | 65.06 | 65.1 | 65.06 | 65.1 | 58400.0 |
| 2005-08-31 09:30:00 | IWM | ETF | 65.15 | 65.41 | 65.04 | 65.1 | 2221500.0 |
| 2005-08-31 10:00:00 | IWM | ETF | 65.1 | 65.21 | 64.92 | 65.17 | 1894100.0 |
| 2005-08-31 10:30:00 | IWM | ETF | 65.18 | 65.53 | 65.13 | 65.42 | 1427800.0 |
| 2005-08-31 11:00:00 | IWM | ETF | 65.42 | 65.73 | 65.36 | 65.63 | 2058600.0 |
| 2005-08-31 11:30:00 | IWM | ETF | 65.61 | 65.75 | 65.57 | 65.66 | 1400700.0 |
> showing 50 of 1,667 rows — these rows as CSV