PREVIEW / etf_1hour / 2006-11-27
file: by_date/etf_1hour/2006/2006-11-27.parquet size: 60 KB rows: 1,862
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-11-27 04:00:00 | SPY | ETF | 140.6 | 140.6 | 140.6 | 140.6 | 200.0 |
| 2006-11-27 07:00:00 | SPY | ETF | 140.35 | 140.36 | 140.16 | 140.2 | 286100.0 |
| 2006-11-27 08:00:00 | SPY | ETF | 140.21 | 140.52 | 140.17 | 140.2 | 910200.0 |
| 2006-11-27 09:00:00 | SPY | ETF | 140.22 | 140.35 | 139.78 | 139.78 | 9821500.0 |
| 2006-11-27 10:00:00 | SPY | ETF | 139.79 | 139.81 | 139.3 | 139.53 | 13424100.0 |
| 2006-11-27 11:00:00 | SPY | ETF | 139.53 | 139.98 | 138.84 | 138.97 | 11891100.0 |
| 2006-11-27 12:00:00 | SPY | ETF | 138.96 | 139.12 | 138.73 | 138.75 | 8910000.0 |
| 2006-11-27 13:00:00 | SPY | ETF | 138.75 | 138.94 | 138.62 | 138.84 | 8749200.0 |
| 2006-11-27 14:00:00 | SPY | ETF | 138.85 | 138.87 | 138.46 | 138.51 | 13253100.0 |
| 2006-11-27 15:00:00 | SPY | ETF | 138.51 | 138.7 | 138.44 | 138.49 | 10910800.0 |
| 2006-11-27 16:00:00 | SPY | ETF | 138.49 | 138.5 | 138.38 | 138.43 | 2955000.0 |
| 2006-11-27 17:00:00 | SPY | ETF | 138.41 | 138.43 | 137.1918 | 138.42 | 839300.0 |
| 2006-11-27 18:00:00 | SPY | ETF | 138.42 | 138.47 | 138.4 | 138.47 | 3000.0 |
| 2006-11-27 19:00:00 | SPY | ETF | 138.45 | 138.47 | 138.44 | 138.44 | 3300.0 |
| 2006-11-27 09:00:00 | QQQ | ETF | 44.52 | 44.61 | 44.36 | 44.36 | 15864000.0 |
| 2006-11-27 10:00:00 | QQQ | ETF | 44.37 | 44.38 | 44.07 | 44.17 | 31584600.0 |
| 2006-11-27 11:00:00 | QQQ | ETF | 44.17 | 44.18 | 43.82 | 43.87 | 26550100.0 |
| 2006-11-27 12:00:00 | QQQ | ETF | 43.87 | 43.93 | 43.7 | 43.7 | 16792400.0 |
| 2006-11-27 13:00:00 | QQQ | ETF | 43.7 | 43.84 | 43.65 | 43.77 | 12735500.0 |
| 2006-11-27 14:00:00 | QQQ | ETF | 43.77 | 43.97 | 42.77 | 43.73 | 18682100.0 |
| 2006-11-27 15:00:00 | QQQ | ETF | 43.73 | 43.77 | 43.65 | 43.66 | 18788300.0 |
| 2006-11-27 07:00:00 | IWM | ETF | 78.4 | 78.4 | 78.4 | 78.4 | 100.0 |
| 2006-11-27 08:00:00 | IWM | ETF | 78.43 | 78.5 | 78.4 | 78.4 | 17700.0 |
| 2006-11-27 09:00:00 | IWM | ETF | 78.45 | 78.54 | 77.94 | 77.96 | 7327400.0 |
| 2006-11-27 10:00:00 | IWM | ETF | 77.96 | 77.97 | 77.36 | 77.61 | 15015800.0 |
| 2006-11-27 11:00:00 | IWM | ETF | 77.61 | 77.63 | 77.11 | 77.2 | 10562600.0 |
| 2006-11-27 12:00:00 | IWM | ETF | 77.2 | 77.32 | 76.98 | 77.0 | 7042100.0 |
| 2006-11-27 13:00:00 | IWM | ETF | 77.0 | 77.12 | 76.9 | 77.05 | 5860500.0 |
| 2006-11-27 14:00:00 | IWM | ETF | 77.05 | 77.08 | 76.76 | 76.78 | 7072500.0 |
| 2006-11-27 15:00:00 | IWM | ETF | 76.78 | 76.91 | 76.72 | 76.79 | 10611100.0 |
| 2006-11-27 16:00:00 | IWM | ETF | 76.79 | 77.33 | 76.73 | 76.75 | 975900.0 |
| 2006-11-27 17:00:00 | IWM | ETF | 76.76 | 76.76 | 76.76 | 76.76 | 200.0 |
| 2006-11-27 08:00:00 | DIA | ETF | 122.65 | 122.69 | 122.61 | 122.62 | 24400.0 |
| 2006-11-27 09:00:00 | DIA | ETF | 122.64 | 122.72 | 121.97 | 121.98 | 918200.0 |
| 2006-11-27 10:00:00 | DIA | ETF | 121.98 | 121.99 | 121.62 | 121.81 | 1772800.0 |
| 2006-11-27 11:00:00 | DIA | ETF | 121.81 | 121.81 | 121.38 | 121.47 | 1080000.0 |
| 2006-11-27 12:00:00 | DIA | ETF | 121.47 | 121.55 | 121.21 | 121.29 | 917800.0 |
| 2006-11-27 13:00:00 | DIA | ETF | 121.29 | 121.39 | 121.19 | 121.34 | 809800.0 |
| 2006-11-27 14:00:00 | DIA | ETF | 121.34 | 121.36 | 121.08 | 121.12 | 2085000.0 |
| 2006-11-27 15:00:00 | DIA | ETF | 121.13 | 121.3 | 121.07 | 121.17 | 1147700.0 |
| 2006-11-27 16:00:00 | DIA | ETF | 121.16 | 121.16 | 121.07 | 121.1 | 25600.0 |
| 2006-11-27 17:00:00 | DIA | ETF | 121.1 | 121.1 | 121.1 | 121.1 | 1100.0 |
| 2006-11-27 18:00:00 | DIA | ETF | 121.12 | 121.2 | 121.12 | 121.2 | 500.0 |
| 2006-11-27 07:00:00 | GLD | ETF | 63.45 | 63.45 | 63.31 | 63.31 | 33600.0 |
| 2006-11-27 08:00:00 | GLD | ETF | 63.37 | 63.46 | 63.3 | 63.31 | 168400.0 |
| 2006-11-27 09:00:00 | GLD | ETF | 63.29 | 63.5 | 63.29 | 63.45 | 1338600.0 |
| 2006-11-27 10:00:00 | GLD | ETF | 63.44 | 63.54 | 63.38 | 63.54 | 891200.0 |
| 2006-11-27 11:00:00 | GLD | ETF | 63.54 | 63.6 | 63.4 | 63.48 | 635000.0 |
| 2006-11-27 12:00:00 | GLD | ETF | 63.47 | 63.66 | 63.44 | 63.64 | 384200.0 |
| 2006-11-27 13:00:00 | GLD | ETF | 63.65 | 63.72 | 63.58 | 63.72 | 867900.0 |
> showing 50 of 1,862 rows — these rows as CSV