PREVIEW / etf_30min / 2006-08-29
file: by_date/etf_30min/2006/2006-08-29.parquet size: 78 KB rows: 2,718
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-29 07:00:00 | SPY | ETF | 130.66 | 130.68 | 130.6 | 130.61 | 8100.0 |
| 2006-08-29 07:30:00 | SPY | ETF | 130.59 | 130.63 | 130.55 | 130.62 | 67900.0 |
| 2006-08-29 08:00:00 | SPY | ETF | 130.6 | 130.66 | 130.4 | 130.55 | 115500.0 |
| 2006-08-29 08:30:00 | SPY | ETF | 130.51 | 130.61 | 130.51 | 130.57 | 345800.0 |
| 2006-08-29 09:00:00 | SPY | ETF | 130.54 | 130.59 | 130.45 | 130.49 | 263100.0 |
| 2006-08-29 09:30:00 | SPY | ETF | 130.49 | 130.54 | 130.31 | 130.49 | 6132600.0 |
| 2006-08-29 10:00:00 | SPY | ETF | 130.5 | 130.51 | 130.02 | 130.06 | 7408900.0 |
| 2006-08-29 10:30:00 | SPY | ETF | 130.06 | 130.17 | 129.98 | 130.11 | 4233400.0 |
| 2006-08-29 11:00:00 | SPY | ETF | 130.11 | 130.17 | 130.0 | 130.08 | 2047400.0 |
| 2006-08-29 11:30:00 | SPY | ETF | 130.08 | 130.1 | 129.85 | 129.91 | 3389400.0 |
| 2006-08-29 12:00:00 | SPY | ETF | 129.92 | 129.99 | 129.88 | 129.97 | 858900.0 |
| 2006-08-29 12:30:00 | SPY | ETF | 129.96 | 130.09 | 129.94 | 129.97 | 2178500.0 |
| 2006-08-29 13:00:00 | SPY | ETF | 129.97 | 130.07 | 129.89 | 130.01 | 1088900.0 |
| 2006-08-29 13:30:00 | SPY | ETF | 130.01 | 130.09 | 129.95 | 130.02 | 1295100.0 |
| 2006-08-29 14:00:00 | SPY | ETF | 130.01 | 130.45 | 129.81 | 130.25 | 12962600.0 |
| 2006-08-29 14:30:00 | SPY | ETF | 130.25 | 130.54 | 130.25 | 130.38 | 5712800.0 |
| 2006-08-29 15:00:00 | SPY | ETF | 130.38 | 130.69 | 130.27 | 130.66 | 4429700.0 |
| 2006-08-29 15:30:00 | SPY | ETF | 130.65 | 130.83 | 130.65 | 130.76 | 5221200.0 |
| 2006-08-29 16:00:00 | SPY | ETF | 130.75 | 130.77 | 130.58 | 130.67 | 1320500.0 |
| 2006-08-29 16:30:00 | SPY | ETF | 130.63 | 130.63 | 130.57 | 130.59 | 187600.0 |
| 2006-08-29 17:00:00 | SPY | ETF | 130.59 | 130.59 | 130.56 | 130.56 | 10400.0 |
| 2006-08-29 17:30:00 | SPY | ETF | 130.57 | 130.57 | 130.57 | 130.57 | 200.0 |
| 2006-08-29 18:00:00 | SPY | ETF | 130.57 | 130.64 | 130.56 | 130.64 | 21700.0 |
| 2006-08-29 19:00:00 | SPY | ETF | 130.63 | 130.63 | 130.63 | 130.63 | 800.0 |
| 2006-08-29 09:30:00 | QQQ | ETF | 38.58 | 38.63 | 38.47 | 38.62 | 8799600.0 |
| 2006-08-29 10:00:00 | QQQ | ETF | 38.62 | 38.62 | 38.28 | 38.28 | 12738900.0 |
| 2006-08-29 10:30:00 | QQQ | ETF | 38.28 | 38.34 | 38.23 | 38.34 | 8705200.0 |
| 2006-08-29 11:00:00 | QQQ | ETF | 38.33 | 38.36 | 38.26 | 38.29 | 3885300.0 |
| 2006-08-29 11:30:00 | QQQ | ETF | 38.29 | 38.29 | 38.18 | 38.21 | 5746900.0 |
| 2006-08-29 12:00:00 | QQQ | ETF | 38.21 | 38.27 | 38.19 | 38.25 | 2297000.0 |
| 2006-08-29 12:30:00 | QQQ | ETF | 38.26 | 38.3 | 38.24 | 38.26 | 2038500.0 |
| 2006-08-29 13:00:00 | QQQ | ETF | 38.26 | 38.31 | 38.25 | 38.27 | 1495100.0 |
| 2006-08-29 13:30:00 | QQQ | ETF | 38.27 | 38.31 | 38.24 | 38.29 | 2658000.0 |
| 2006-08-29 14:00:00 | QQQ | ETF | 38.29 | 38.48 | 38.18 | 38.36 | 20635400.0 |
| 2006-08-29 14:30:00 | QQQ | ETF | 38.37 | 38.52 | 38.36 | 38.47 | 6830000.0 |
| 2006-08-29 15:00:00 | QQQ | ETF | 38.46 | 38.62 | 38.41 | 38.59 | 8732600.0 |
| 2006-08-29 15:30:00 | QQQ | ETF | 38.6 | 38.76 | 38.59 | 38.72 | 15416600.0 |
| 2006-08-29 08:00:00 | IWM | ETF | 70.58 | 70.58 | 70.51 | 70.52 | 28700.0 |
| 2006-08-29 08:30:00 | IWM | ETF | 70.55 | 70.61 | 70.53 | 70.55 | 448400.0 |
| 2006-08-29 09:00:00 | IWM | ETF | 70.55 | 70.61 | 70.47 | 70.51 | 227200.0 |
| 2006-08-29 09:30:00 | IWM | ETF | 70.51 | 70.6 | 70.36 | 70.6 | 3572300.0 |
| 2006-08-29 10:00:00 | IWM | ETF | 70.59 | 70.59 | 70.1 | 70.15 | 4449800.0 |
| 2006-08-29 10:30:00 | IWM | ETF | 70.15 | 70.18 | 70.0 | 70.13 | 3566700.0 |
| 2006-08-29 11:00:00 | IWM | ETF | 70.13 | 70.2 | 70.06 | 70.11 | 971100.0 |
| 2006-08-29 11:30:00 | IWM | ETF | 70.11 | 70.11 | 69.88 | 69.93 | 2156400.0 |
| 2006-08-29 12:00:00 | IWM | ETF | 69.94 | 70.07 | 69.92 | 70.06 | 732400.0 |
| 2006-08-29 12:30:00 | IWM | ETF | 70.06 | 70.11 | 70.01 | 70.03 | 403600.0 |
| 2006-08-29 13:00:00 | IWM | ETF | 70.03 | 70.2 | 70.02 | 70.16 | 702100.0 |
| 2006-08-29 13:30:00 | IWM | ETF | 70.16 | 70.25 | 70.1 | 70.16 | 1009200.0 |
| 2006-08-29 14:00:00 | IWM | ETF | 70.17 | 70.83 | 69.98 | 70.58 | 7436800.0 |
> showing 50 of 2,718 rows — these rows as CSV