PREVIEW / etf_1hour / 2006-07-24
file: by_date/etf_1hour/2006/2006-07-24.parquet size: 50 KB rows: 1,574
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-07-24 04:00:00 | SPY | ETF | 124.18 | 124.18 | 124.18 | 124.18 | 100.0 |
| 2006-07-24 05:00:00 | SPY | ETF | 124.31 | 124.5 | 124.31 | 124.5 | 2600.0 |
| 2006-07-24 06:00:00 | SPY | ETF | 124.53 | 124.54 | 124.45 | 124.45 | 50800.0 |
| 2006-07-24 07:00:00 | SPY | ETF | 124.43 | 124.49 | 124.23 | 124.35 | 142600.0 |
| 2006-07-24 08:00:00 | SPY | ETF | 124.33 | 124.61 | 124.24 | 124.58 | 2299100.0 |
| 2006-07-24 09:00:00 | SPY | ETF | 124.56 | 125.04 | 124.44 | 124.84 | 11860300.0 |
| 2006-07-24 10:00:00 | SPY | ETF | 124.84 | 125.74 | 124.71 | 125.62 | 17417300.0 |
| 2006-07-24 11:00:00 | SPY | ETF | 125.63 | 126.09 | 125.52 | 125.9 | 12578200.0 |
| 2006-07-24 12:00:00 | SPY | ETF | 125.91 | 125.94 | 125.57 | 125.64 | 7146300.0 |
| 2006-07-24 13:00:00 | SPY | ETF | 125.63 | 125.8 | 125.54 | 125.65 | 7598700.0 |
| 2006-07-24 14:00:00 | SPY | ETF | 125.65 | 125.93 | 125.5 | 125.87 | 10582000.0 |
| 2006-07-24 15:00:00 | SPY | ETF | 125.86 | 126.32 | 125.83 | 126.13 | 16472900.0 |
| 2006-07-24 16:00:00 | SPY | ETF | 126.16 | 126.25 | 125.3964 | 126.25 | 2667700.0 |
| 2006-07-24 17:00:00 | SPY | ETF | 126.23 | 126.27 | 126.21 | 126.27 | 63500.0 |
| 2006-07-24 18:00:00 | SPY | ETF | 126.22 | 126.24 | 126.21 | 126.24 | 5900.0 |
| 2006-07-24 19:00:00 | SPY | ETF | 126.23 | 126.23 | 126.2 | 126.2 | 2800.0 |
| 2006-07-24 09:00:00 | QQQ | ETF | 35.85 | 36.02 | 35.84 | 35.89 | 18858000.0 |
| 2006-07-24 10:00:00 | QQQ | ETF | 35.88 | 36.25 | 35.8 | 36.21 | 25175300.0 |
| 2006-07-24 11:00:00 | QQQ | ETF | 36.21 | 36.37 | 36.17 | 36.28 | 13602600.0 |
| 2006-07-24 12:00:00 | QQQ | ETF | 36.28 | 36.3 | 36.08 | 36.09 | 11235100.0 |
| 2006-07-24 13:00:00 | QQQ | ETF | 36.09 | 36.2 | 36.03 | 36.14 | 13371800.0 |
| 2006-07-24 14:00:00 | QQQ | ETF | 36.14 | 36.29 | 36.12 | 36.28 | 11525500.0 |
| 2006-07-24 15:00:00 | QQQ | ETF | 36.28 | 36.43 | 36.27 | 36.39 | 25291400.0 |
| 2006-07-24 06:00:00 | IWM | ETF | 67.0 | 67.0 | 67.0 | 67.0 | 400.0 |
| 2006-07-24 08:00:00 | IWM | ETF | 67.2 | 67.21 | 67.1 | 67.21 | 197700.0 |
| 2006-07-24 09:00:00 | IWM | ETF | 67.22 | 67.99 | 67.2 | 67.66 | 14379300.0 |
| 2006-07-24 10:00:00 | IWM | ETF | 67.65 | 68.5 | 67.53 | 68.37 | 19567400.0 |
| 2006-07-24 11:00:00 | IWM | ETF | 68.37 | 68.53 | 68.26 | 68.44 | 6419900.0 |
| 2006-07-24 12:00:00 | IWM | ETF | 68.45 | 68.47 | 67.99 | 68.05 | 4667400.0 |
| 2006-07-24 13:00:00 | IWM | ETF | 68.05 | 68.31 | 67.9 | 68.19 | 6783500.0 |
| 2006-07-24 14:00:00 | IWM | ETF | 68.19 | 68.39 | 68.07 | 68.35 | 5667300.0 |
| 2006-07-24 15:00:00 | IWM | ETF | 68.35 | 68.7 | 68.34 | 68.68 | 10320300.0 |
| 2006-07-24 16:00:00 | IWM | ETF | 68.69 | 68.94 | 68.68 | 68.94 | 3179800.0 |
| 2006-07-24 17:00:00 | IWM | ETF | 68.94 | 69.0 | 68.89 | 68.89 | 165000.0 |
| 2006-07-24 18:00:00 | IWM | ETF | 68.94 | 68.94 | 68.94 | 68.94 | 100.0 |
| 2006-07-24 07:00:00 | DIA | ETF | 108.98 | 108.98 | 108.82 | 108.82 | 1000.0 |
| 2006-07-24 08:00:00 | DIA | ETF | 108.84 | 109.05 | 108.84 | 109.05 | 26400.0 |
| 2006-07-24 09:00:00 | DIA | ETF | 109.05 | 109.47 | 109.0 | 109.35 | 826800.0 |
| 2006-07-24 10:00:00 | DIA | ETF | 109.34 | 110.0 | 109.09 | 109.92 | 1723200.0 |
| 2006-07-24 11:00:00 | DIA | ETF | 109.93 | 110.24 | 109.86 | 110.11 | 1463900.0 |
| 2006-07-24 12:00:00 | DIA | ETF | 110.11 | 110.142 | 109.9 | 109.95 | 590800.0 |
| 2006-07-24 13:00:00 | DIA | ETF | 109.95 | 110.0 | 109.82 | 109.82 | 482400.0 |
| 2006-07-24 14:00:00 | DIA | ETF | 109.83 | 110.08 | 109.74 | 110.07 | 481300.0 |
| 2006-07-24 15:00:00 | DIA | ETF | 110.05 | 110.6 | 110.05 | 110.42 | 2228800.0 |
| 2006-07-24 16:00:00 | DIA | ETF | 110.42 | 110.55 | 110.4125 | 110.55 | 1278000.0 |
| 2006-07-24 19:00:00 | DIA | ETF | 110.6 | 110.6 | 110.6 | 110.6 | 100.0 |
| 2006-07-24 07:00:00 | GLD | ETF | 60.99 | 61.09 | 60.99 | 61.09 | 7600.0 |
| 2006-07-24 08:00:00 | GLD | ETF | 61.12 | 61.29 | 60.45 | 60.54 | 127700.0 |
| 2006-07-24 09:00:00 | GLD | ETF | 60.6 | 60.88 | 60.11 | 60.18 | 1429600.0 |
| 2006-07-24 10:00:00 | GLD | ETF | 60.18 | 60.44 | 59.88 | 59.88 | 1896200.0 |
> showing 50 of 1,574 rows — these rows as CSV