PREVIEW / etf_30min / 2006-08-21
file: by_date/etf_30min/2006/2006-08-21.parquet size: 74 KB rows: 2,793
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-08-21 04:00:00 | SPY | ETF | 130.07 | 130.07 | 130.07 | 130.07 | 3000.0 |
| 2006-08-21 06:30:00 | SPY | ETF | 130.25 | 130.25 | 130.23 | 130.24 | 2700.0 |
| 2006-08-21 07:00:00 | SPY | ETF | 130.22 | 130.23 | 130.15 | 130.22 | 60400.0 |
| 2006-08-21 07:30:00 | SPY | ETF | 130.19 | 130.24 | 130.1 | 130.21 | 79200.0 |
| 2006-08-21 08:00:00 | SPY | ETF | 130.2 | 130.3 | 130.1 | 130.21 | 570100.0 |
| 2006-08-21 08:30:00 | SPY | ETF | 130.23 | 130.28 | 130.18 | 130.23 | 996700.0 |
| 2006-08-21 09:00:00 | SPY | ETF | 130.23 | 130.24 | 130.15 | 130.18 | 677700.0 |
| 2006-08-21 09:30:00 | SPY | ETF | 130.18 | 130.2 | 130.04 | 130.05 | 5012500.0 |
| 2006-08-21 10:00:00 | SPY | ETF | 130.06 | 130.25 | 129.99 | 130.05 | 5096500.0 |
| 2006-08-21 10:30:00 | SPY | ETF | 130.04 | 130.2 | 130.02 | 130.12 | 1941600.0 |
| 2006-08-21 11:00:00 | SPY | ETF | 130.13 | 130.13 | 129.95 | 130.07 | 2261200.0 |
| 2006-08-21 11:30:00 | SPY | ETF | 130.07 | 130.17 | 129.81 | 129.84 | 5129600.0 |
| 2006-08-21 12:00:00 | SPY | ETF | 129.84 | 129.94 | 129.8 | 129.92 | 1803500.0 |
| 2006-08-21 12:30:00 | SPY | ETF | 129.92 | 130.11 | 129.91 | 130.04 | 1628600.0 |
| 2006-08-21 13:00:00 | SPY | ETF | 130.04 | 130.16 | 129.98 | 130.0 | 3374700.0 |
| 2006-08-21 13:30:00 | SPY | ETF | 129.99 | 130.08 | 129.97 | 130.08 | 1646800.0 |
| 2006-08-21 14:00:00 | SPY | ETF | 130.07 | 130.16 | 129.92 | 129.98 | 1660500.0 |
| 2006-08-21 14:30:00 | SPY | ETF | 129.98 | 130.04 | 129.9 | 130.02 | 1394400.0 |
| 2006-08-21 15:00:00 | SPY | ETF | 130.02 | 130.16 | 129.93 | 130.1 | 2172200.0 |
| 2006-08-21 15:30:00 | SPY | ETF | 130.09 | 130.25 | 130.05 | 130.11 | 3720100.0 |
| 2006-08-21 16:00:00 | SPY | ETF | 130.14 | 130.28 | 130.12 | 130.15 | 613100.0 |
| 2006-08-21 16:30:00 | SPY | ETF | 130.15 | 130.15 | 130.09 | 130.09 | 22600.0 |
| 2006-08-21 17:00:00 | SPY | ETF | 130.18 | 130.19 | 130.12 | 130.14 | 3200.0 |
| 2006-08-21 17:30:00 | SPY | ETF | 130.1 | 130.1 | 130.1 | 130.1 | 2000.0 |
| 2006-08-21 18:00:00 | SPY | ETF | 130.16 | 130.16 | 130.16 | 130.16 | 100.0 |
| 2006-08-21 19:30:00 | SPY | ETF | 130.14 | 130.17 | 130.14 | 130.17 | 500.0 |
| 2006-08-21 09:30:00 | QQQ | ETF | 38.47 | 38.5 | 38.35 | 38.36 | 11883800.0 |
| 2006-08-21 10:00:00 | QQQ | ETF | 38.36 | 38.48 | 38.34 | 38.37 | 5384000.0 |
| 2006-08-21 10:30:00 | QQQ | ETF | 38.37 | 38.45 | 38.36 | 38.41 | 2595900.0 |
| 2006-08-21 11:00:00 | QQQ | ETF | 38.41 | 38.41 | 38.3 | 38.38 | 6136400.0 |
| 2006-08-21 11:30:00 | QQQ | ETF | 38.38 | 38.42 | 38.28 | 38.29 | 4409000.0 |
| 2006-08-21 12:00:00 | QQQ | ETF | 38.29 | 38.33 | 38.26 | 38.31 | 2605100.0 |
| 2006-08-21 12:30:00 | QQQ | ETF | 38.3 | 38.42 | 38.3 | 38.39 | 2990900.0 |
| 2006-08-21 13:00:00 | QQQ | ETF | 38.39 | 38.47 | 38.37 | 38.38 | 3781500.0 |
| 2006-08-21 13:30:00 | QQQ | ETF | 38.38 | 38.4 | 38.37 | 38.39 | 1649600.0 |
| 2006-08-21 14:00:00 | QQQ | ETF | 38.39 | 38.46 | 38.37 | 38.4 | 3524400.0 |
| 2006-08-21 14:30:00 | QQQ | ETF | 38.39 | 38.44 | 38.35 | 38.38 | 3418400.0 |
| 2006-08-21 15:00:00 | QQQ | ETF | 38.39 | 38.51 | 38.36 | 38.47 | 3809100.0 |
| 2006-08-21 15:30:00 | QQQ | ETF | 38.48 | 38.56 | 38.4 | 38.43 | 7899600.0 |
| 2006-08-21 08:00:00 | IWM | ETF | 70.45 | 70.52 | 70.33 | 70.33 | 33700.0 |
| 2006-08-21 08:30:00 | IWM | ETF | 70.47 | 70.5 | 70.43 | 70.48 | 99300.0 |
| 2006-08-21 09:00:00 | IWM | ETF | 70.47 | 70.51 | 70.45 | 70.48 | 273200.0 |
| 2006-08-21 09:30:00 | IWM | ETF | 70.48 | 70.49 | 70.18 | 70.18 | 4614300.0 |
| 2006-08-21 10:00:00 | IWM | ETF | 70.19 | 70.39 | 70.12 | 70.21 | 2620800.0 |
| 2006-08-21 10:30:00 | IWM | ETF | 70.21 | 70.38 | 70.2 | 70.25 | 1105000.0 |
| 2006-08-21 11:00:00 | IWM | ETF | 70.24 | 70.24 | 69.98 | 70.04 | 2519100.0 |
| 2006-08-21 11:30:00 | IWM | ETF | 70.04 | 70.14 | 69.87 | 69.89 | 2828400.0 |
| 2006-08-21 12:00:00 | IWM | ETF | 69.89 | 70.0 | 69.85 | 69.97 | 1049700.0 |
| 2006-08-21 12:30:00 | IWM | ETF | 69.98 | 70.16 | 69.97 | 70.09 | 1136300.0 |
| 2006-08-21 13:00:00 | IWM | ETF | 70.09 | 70.21 | 70.06 | 70.07 | 1238400.0 |
> showing 50 of 2,793 rows — these rows as CSV