PREVIEW / etf_1hour / 2006-10-24
file: by_date/etf_1hour/2006/2006-10-24.parquet size: 54 KB rows: 1,737
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-10-24 06:00:00 | SPY | ETF | 137.32 | 137.35 | 137.3 | 137.35 | 20000.0 |
| 2006-10-24 07:00:00 | SPY | ETF | 137.25 | 137.35 | 137.25 | 137.35 | 86300.0 |
| 2006-10-24 08:00:00 | SPY | ETF | 137.18 | 137.35 | 137.18 | 137.35 | 405500.0 |
| 2006-10-24 09:00:00 | SPY | ETF | 137.35 | 137.68 | 137.22 | 137.55 | 8168300.0 |
| 2006-10-24 10:00:00 | SPY | ETF | 137.53 | 137.55 | 137.3 | 137.52 | 8791000.0 |
| 2006-10-24 11:00:00 | SPY | ETF | 137.52 | 137.67 | 137.44 | 137.6 | 4765400.0 |
| 2006-10-24 12:00:00 | SPY | ETF | 137.59 | 137.65 | 137.26 | 137.3 | 5399800.0 |
| 2006-10-24 13:00:00 | SPY | ETF | 137.3 | 137.63 | 137.29 | 137.38 | 7613400.0 |
| 2006-10-24 14:00:00 | SPY | ETF | 137.38 | 137.64 | 137.34 | 137.54 | 5685000.0 |
| 2006-10-24 15:00:00 | SPY | ETF | 137.54 | 137.83 | 137.53 | 137.79 | 7598100.0 |
| 2006-10-24 16:00:00 | SPY | ETF | 137.79 | 137.94 | 137.5 | 137.74 | 2387800.0 |
| 2006-10-24 17:00:00 | SPY | ETF | 137.74 | 137.79 | 137.73 | 137.79 | 63900.0 |
| 2006-10-24 18:00:00 | SPY | ETF | 137.77 | 137.81 | 137.76 | 137.79 | 121300.0 |
| 2006-10-24 19:00:00 | SPY | ETF | 137.78 | 137.78 | 137.77 | 137.77 | 1100.0 |
| 2006-10-24 09:00:00 | QQQ | ETF | 42.29 | 42.45 | 42.25 | 42.32 | 10767900.0 |
| 2006-10-24 10:00:00 | QQQ | ETF | 42.32 | 42.36 | 42.1 | 42.18 | 19322900.0 |
| 2006-10-24 11:00:00 | QQQ | ETF | 42.19 | 42.26 | 42.14 | 42.19 | 9331700.0 |
| 2006-10-24 12:00:00 | QQQ | ETF | 42.19 | 42.21 | 41.92 | 41.95 | 9715600.0 |
| 2006-10-24 13:00:00 | QQQ | ETF | 41.95 | 42.13 | 41.94 | 42.05 | 9282100.0 |
| 2006-10-24 14:00:00 | QQQ | ETF | 42.06 | 42.18 | 42.03 | 42.11 | 7867800.0 |
| 2006-10-24 15:00:00 | QQQ | ETF | 42.12 | 42.22 | 42.08 | 42.12 | 10438500.0 |
| 2006-10-24 07:00:00 | IWM | ETF | 75.48 | 75.48 | 75.48 | 75.48 | 200.0 |
| 2006-10-24 08:00:00 | IWM | ETF | 75.65 | 75.65 | 75.57 | 75.64 | 7400.0 |
| 2006-10-24 09:00:00 | IWM | ETF | 75.65 | 75.95 | 75.43 | 75.76 | 3007200.0 |
| 2006-10-24 10:00:00 | IWM | ETF | 75.74 | 75.82 | 75.47 | 75.65 | 5991100.0 |
| 2006-10-24 11:00:00 | IWM | ETF | 75.65 | 75.8 | 75.59 | 75.76 | 3917300.0 |
| 2006-10-24 12:00:00 | IWM | ETF | 75.77 | 75.78 | 75.34 | 75.38 | 3015300.0 |
| 2006-10-24 13:00:00 | IWM | ETF | 75.38 | 75.56 | 75.35 | 75.5 | 4793900.0 |
| 2006-10-24 14:00:00 | IWM | ETF | 75.5 | 75.7176 | 75.47 | 75.66 | 5063300.0 |
| 2006-10-24 15:00:00 | IWM | ETF | 75.66 | 75.88 | 75.62 | 75.71 | 3861400.0 |
| 2006-10-24 16:00:00 | IWM | ETF | 75.74 | 75.9 | 75.6 | 75.79 | 441100.0 |
| 2006-10-24 17:00:00 | IWM | ETF | 75.76 | 75.76 | 75.76 | 75.76 | 1000.0 |
| 2006-10-24 18:00:00 | IWM | ETF | 75.81 | 75.84 | 75.81 | 75.84 | 2000.0 |
| 2006-10-24 07:00:00 | DIA | ETF | 120.87 | 120.87 | 120.87 | 120.87 | 100.0 |
| 2006-10-24 08:00:00 | DIA | ETF | 120.86 | 120.9 | 120.79 | 120.79 | 143200.0 |
| 2006-10-24 09:00:00 | DIA | ETF | 120.83 | 121.24 | 120.75 | 121.09 | 1495000.0 |
| 2006-10-24 10:00:00 | DIA | ETF | 121.09 | 121.1 | 120.81 | 121.02 | 1124800.0 |
| 2006-10-24 11:00:00 | DIA | ETF | 121.01 | 121.13 | 120.94 | 121.1 | 601000.0 |
| 2006-10-24 12:00:00 | DIA | ETF | 121.1 | 121.14 | 120.82 | 120.85 | 622100.0 |
| 2006-10-24 13:00:00 | DIA | ETF | 120.85 | 121.07 | 120.85 | 120.92 | 1021500.0 |
| 2006-10-24 14:00:00 | DIA | ETF | 120.94 | 121.09 | 120.91 | 120.99 | 483200.0 |
| 2006-10-24 15:00:00 | DIA | ETF | 121.01 | 121.22 | 120.99 | 121.16 | 1456300.0 |
| 2006-10-24 16:00:00 | DIA | ETF | 121.2 | 121.22 | 121.14 | 121.15 | 30700.0 |
| 2006-10-24 17:00:00 | DIA | ETF | 121.15 | 121.16 | 121.15 | 121.15 | 1900.0 |
| 2006-10-24 18:00:00 | DIA | ETF | 121.15 | 121.15 | 121.15 | 121.15 | 1000.0 |
| 2006-10-24 19:00:00 | DIA | ETF | 121.15 | 121.15 | 121.15 | 121.15 | 400.0 |
| 2006-10-24 07:00:00 | GLD | ETF | 57.7 | 57.74 | 57.7 | 57.7 | 2500.0 |
| 2006-10-24 08:00:00 | GLD | ETF | 57.68 | 57.7 | 56.94 | 57.18 | 93000.0 |
| 2006-10-24 09:00:00 | GLD | ETF | 57.19 | 57.26 | 56.97 | 57.04 | 527400.0 |
| 2006-10-24 10:00:00 | GLD | ETF | 57.0301 | 57.63 | 56.87 | 57.59 | 880600.0 |
> showing 50 of 1,737 rows — these rows as CSV