PREVIEW / etf_1hour / 2006-08-24
file: by_date/etf_1hour/2006/2006-08-24.parquet size: 49 KB rows: 1,579
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-24 07:00:00 | SPY | ETF | 129.85 | 129.94 | 129.81 | 129.84 | 118400.0 |
| 2006-08-24 08:00:00 | SPY | ETF | 129.86 | 130.03 | 129.76 | 130.01 | 1645300.0 |
| 2006-08-24 09:00:00 | SPY | ETF | 130.0 | 130.1 | 129.57 | 129.94 | 8298500.0 |
| 2006-08-24 10:00:00 | SPY | ETF | 129.94 | 130.0 | 129.6 | 129.77 | 10821900.0 |
| 2006-08-24 11:00:00 | SPY | ETF | 129.76 | 129.89 | 129.58 | 129.63 | 5230800.0 |
| 2006-08-24 12:00:00 | SPY | ETF | 129.62 | 129.62 | 129.4 | 129.57 | 6971200.0 |
| 2006-08-24 13:00:00 | SPY | ETF | 129.56 | 129.74 | 129.46 | 129.64 | 4198800.0 |
| 2006-08-24 14:00:00 | SPY | ETF | 129.63 | 129.95 | 129.62 | 129.93 | 7022300.0 |
| 2006-08-24 15:00:00 | SPY | ETF | 129.92 | 129.93 | 129.64 | 129.86 | 10013900.0 |
| 2006-08-24 16:00:00 | SPY | ETF | 129.87 | 129.886 | 129.62 | 129.6699 | 2843700.0 |
| 2006-08-24 17:00:00 | SPY | ETF | 129.71 | 129.71 | 129.67 | 129.71 | 1700.0 |
| 2006-08-24 18:00:00 | SPY | ETF | 129.74 | 129.74 | 129.71 | 129.72 | 2600.0 |
| 2006-08-24 19:00:00 | SPY | ETF | 129.67 | 129.67 | 129.66 | 129.66 | 400.0 |
| 2006-08-24 09:00:00 | QQQ | ETF | 38.26 | 38.35 | 38.21 | 38.25 | 9239700.0 |
| 2006-08-24 10:00:00 | QQQ | ETF | 38.25 | 38.3 | 38.05 | 38.15 | 19630900.0 |
| 2006-08-24 11:00:00 | QQQ | ETF | 38.15 | 38.19 | 38.02 | 38.03 | 7980200.0 |
| 2006-08-24 12:00:00 | QQQ | ETF | 38.04 | 38.05 | 37.92 | 38.02 | 11241700.0 |
| 2006-08-24 13:00:00 | QQQ | ETF | 38.02 | 38.13 | 37.95 | 38.11 | 7557500.0 |
| 2006-08-24 14:00:00 | QQQ | ETF | 38.11 | 38.27 | 38.09 | 38.25 | 8495500.0 |
| 2006-08-24 15:00:00 | QQQ | ETF | 38.25 | 38.27 | 38.12 | 38.26 | 11580800.0 |
| 2006-08-24 08:00:00 | IWM | ETF | 69.6 | 69.66 | 69.5 | 69.66 | 161500.0 |
| 2006-08-24 09:00:00 | IWM | ETF | 69.63 | 69.87 | 69.61 | 69.81 | 4152300.0 |
| 2006-08-24 10:00:00 | IWM | ETF | 69.8 | 69.8 | 69.14 | 69.32 | 7104100.0 |
| 2006-08-24 11:00:00 | IWM | ETF | 69.31 | 69.44 | 69.07 | 69.14 | 4981800.0 |
| 2006-08-24 12:00:00 | IWM | ETF | 69.13 | 69.14 | 68.91 | 69.07 | 4676300.0 |
| 2006-08-24 13:00:00 | IWM | ETF | 69.07 | 69.43 | 68.98 | 69.38 | 2668000.0 |
| 2006-08-24 14:00:00 | IWM | ETF | 69.38 | 69.66 | 69.36 | 69.59 | 4422000.0 |
| 2006-08-24 15:00:00 | IWM | ETF | 69.58 | 69.61 | 69.3 | 69.54 | 3608700.0 |
| 2006-08-24 16:00:00 | IWM | ETF | 69.55 | 69.59 | 69.43 | 69.44 | 81000.0 |
| 2006-08-24 17:00:00 | IWM | ETF | 69.44 | 69.48 | 69.44 | 69.48 | 44500.0 |
| 2006-08-24 18:00:00 | IWM | ETF | 69.41 | 69.41 | 69.41 | 69.41 | 1200.0 |
| 2006-08-24 08:00:00 | DIA | ETF | 113.16 | 113.28 | 113.1 | 113.26 | 58000.0 |
| 2006-08-24 09:00:00 | DIA | ETF | 113.28 | 113.34 | 113.01 | 113.11 | 472200.0 |
| 2006-08-24 10:00:00 | DIA | ETF | 113.11 | 113.18 | 112.82 | 112.89 | 861400.0 |
| 2006-08-24 11:00:00 | DIA | ETF | 112.89 | 112.99 | 112.77 | 112.81 | 373900.0 |
| 2006-08-24 12:00:00 | DIA | ETF | 112.81 | 112.81 | 112.67 | 112.78 | 489600.0 |
| 2006-08-24 13:00:00 | DIA | ETF | 112.78 | 112.91 | 112.69 | 112.81 | 423200.0 |
| 2006-08-24 14:00:00 | DIA | ETF | 112.8 | 113.06 | 112.79 | 113.03 | 371600.0 |
| 2006-08-24 15:00:00 | DIA | ETF | 113.06 | 113.06 | 112.79 | 112.97 | 456000.0 |
| 2006-08-24 16:00:00 | DIA | ETF | 112.97 | 112.98 | 112.76 | 112.85 | 519900.0 |
| 2006-08-24 07:00:00 | GLD | ETF | 62.09 | 62.15 | 62.09 | 62.15 | 1700.0 |
| 2006-08-24 08:00:00 | GLD | ETF | 62.15 | 62.22 | 61.95 | 62.12 | 40400.0 |
| 2006-08-24 09:00:00 | GLD | ETF | 62.06 | 62.11 | 61.84 | 61.98 | 363500.0 |
| 2006-08-24 10:00:00 | GLD | ETF | 61.99 | 62.04 | 61.62 | 61.91 | 616600.0 |
| 2006-08-24 11:00:00 | GLD | ETF | 61.91 | 61.98 | 61.73 | 61.8 | 251900.0 |
| 2006-08-24 12:00:00 | GLD | ETF | 61.79 | 61.88 | 61.45 | 61.62 | 290200.0 |
| 2006-08-24 13:00:00 | GLD | ETF | 61.6 | 61.68 | 61.48 | 61.639 | 170400.0 |
| 2006-08-24 14:00:00 | GLD | ETF | 61.64 | 61.758 | 61.55 | 61.75 | 241200.0 |
| 2006-08-24 15:00:00 | GLD | ETF | 61.74 | 61.76 | 61.66 | 61.69 | 202800.0 |
| 2006-08-24 16:00:00 | GLD | ETF | 61.745 | 61.745 | 61.68 | 61.7 | 6300.0 |
> showing 50 of 1,579 rows — these rows as CSV