PREVIEW / etf_1hour / 2006-05-16
file: by_date/etf_1hour/2006/2006-05-16.parquet size: 43 KB rows: 1,333
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-05-16 06:00:00 | SPY | ETF | 129.43 | 129.45 | 129.4 | 129.45 | 65300.0 |
| 2006-05-16 07:00:00 | SPY | ETF | 129.49 | 129.61 | 129.4 | 129.61 | 125600.0 |
| 2006-05-16 08:00:00 | SPY | ETF | 129.62 | 129.86 | 129.4 | 129.86 | 1843700.0 |
| 2006-05-16 09:00:00 | SPY | ETF | 129.86 | 130.0 | 129.53 | 129.77 | 9950400.0 |
| 2006-05-16 10:00:00 | SPY | ETF | 129.77 | 129.81 | 129.49 | 129.55 | 8893800.0 |
| 2006-05-16 11:00:00 | SPY | ETF | 129.56 | 129.69 | 129.01 | 129.31 | 11278200.0 |
| 2006-05-16 12:00:00 | SPY | ETF | 129.32 | 129.68 | 129.21 | 129.66 | 6811200.0 |
| 2006-05-16 13:00:00 | SPY | ETF | 129.66 | 129.95 | 129.57 | 129.73 | 7910700.0 |
| 2006-05-16 14:00:00 | SPY | ETF | 129.71 | 129.79 | 129.48 | 129.54 | 3662400.0 |
| 2006-05-16 15:00:00 | SPY | ETF | 129.55 | 129.66 | 129.35 | 129.3606 | 8676700.0 |
| 2006-05-16 16:00:00 | SPY | ETF | 129.35 | 129.41 | 129.11 | 129.28 | 778900.0 |
| 2006-05-16 17:00:00 | SPY | ETF | 129.28 | 129.41 | 129.27 | 129.33 | 47000.0 |
| 2006-05-16 18:00:00 | SPY | ETF | 129.28 | 129.3 | 129.27 | 129.29 | 2400.0 |
| 2006-05-16 19:00:00 | SPY | ETF | 129.39 | 129.39 | 129.37 | 129.37 | 200.0 |
| 2006-05-16 09:00:00 | QQQ | ETF | 40.16 | 40.26 | 40.14 | 40.19 | 11771000.0 |
| 2006-05-16 10:00:00 | QQQ | ETF | 40.19 | 40.2 | 40.03 | 40.09 | 14538100.0 |
| 2006-05-16 11:00:00 | QQQ | ETF | 40.09 | 40.11 | 39.77 | 39.89 | 16092300.0 |
| 2006-05-16 12:00:00 | QQQ | ETF | 39.89 | 39.95 | 39.8 | 39.92 | 11628700.0 |
| 2006-05-16 13:00:00 | QQQ | ETF | 39.91 | 40.16 | 39.91 | 40.09 | 39408100.0 |
| 2006-05-16 14:00:00 | QQQ | ETF | 40.08 | 40.09 | 39.96 | 39.96 | 7707300.0 |
| 2006-05-16 15:00:00 | QQQ | ETF | 39.96 | 40.03 | 39.85 | 39.88 | 14494100.0 |
| 2006-05-16 08:00:00 | IWM | ETF | 73.12 | 75.51 | 73.12 | 73.51 | 553800.0 |
| 2006-05-16 09:00:00 | IWM | ETF | 73.48 | 73.87 | 73.35 | 73.68 | 7437200.0 |
| 2006-05-16 10:00:00 | IWM | ETF | 73.68 | 73.7 | 73.31 | 73.42 | 7358700.0 |
| 2006-05-16 11:00:00 | IWM | ETF | 73.42 | 73.5 | 72.94 | 73.13 | 5543500.0 |
| 2006-05-16 12:00:00 | IWM | ETF | 73.13 | 73.48 | 73.0 | 73.36 | 3241500.0 |
| 2006-05-16 13:00:00 | IWM | ETF | 73.36 | 73.69 | 73.33 | 73.56 | 4275600.0 |
| 2006-05-16 14:00:00 | IWM | ETF | 73.57 | 73.57 | 73.4 | 73.42 | 1586700.0 |
| 2006-05-16 15:00:00 | IWM | ETF | 73.42 | 73.52 | 73.24 | 73.28 | 5065300.0 |
| 2006-05-16 16:00:00 | IWM | ETF | 73.28 | 73.34 | 72.78 | 73.29 | 173900.0 |
| 2006-05-16 17:00:00 | IWM | ETF | 73.3 | 73.3 | 73.3 | 73.3 | 5000.0 |
| 2006-05-16 18:00:00 | IWM | ETF | 73.27 | 73.27 | 73.27 | 73.27 | 100.0 |
| 2006-05-16 07:00:00 | DIA | ETF | 114.28 | 114.29 | 114.28 | 114.29 | 600.0 |
| 2006-05-16 08:00:00 | DIA | ETF | 114.28 | 114.43 | 114.23 | 114.43 | 18500.0 |
| 2006-05-16 09:00:00 | DIA | ETF | 114.42 | 114.65 | 114.32 | 114.53 | 2620400.0 |
| 2006-05-16 10:00:00 | DIA | ETF | 114.55 | 114.6 | 114.37 | 114.47 | 893500.0 |
| 2006-05-16 11:00:00 | DIA | ETF | 114.45 | 114.56 | 114.0 | 114.23 | 731600.0 |
| 2006-05-16 12:00:00 | DIA | ETF | 114.23 | 114.5 | 114.07 | 114.5 | 639800.0 |
| 2006-05-16 13:00:00 | DIA | ETF | 114.5 | 114.72 | 114.46 | 114.5 | 799400.0 |
| 2006-05-16 14:00:00 | DIA | ETF | 114.49 | 114.5 | 114.31 | 114.33 | 341200.0 |
| 2006-05-16 15:00:00 | DIA | ETF | 114.34 | 114.47 | 114.21 | 114.29 | 811000.0 |
| 2006-05-16 16:00:00 | DIA | ETF | 114.3 | 114.3 | 114.17 | 114.26 | 51500.0 |
| 2006-05-16 07:00:00 | GLD | ETF | 68.46 | 68.46 | 67.85 | 67.85 | 6500.0 |
| 2006-05-16 08:00:00 | GLD | ETF | 67.83 | 68.57 | 67.78 | 68.34 | 232400.0 |
| 2006-05-16 09:00:00 | GLD | ETF | 68.37 | 68.56 | 68.21 | 68.47 | 1658100.0 |
| 2006-05-16 10:00:00 | GLD | ETF | 68.47 | 68.85 | 68.31 | 68.3201 | 2785300.0 |
| 2006-05-16 11:00:00 | GLD | ETF | 68.3292 | 68.5 | 67.87 | 68.16 | 3355300.0 |
| 2006-05-16 12:00:00 | GLD | ETF | 68.19 | 68.78 | 68.18 | 68.64 | 1703900.0 |
| 2006-05-16 13:00:00 | GLD | ETF | 68.67 | 68.84 | 68.63 | 68.836 | 877700.0 |
| 2006-05-16 14:00:00 | GLD | ETF | 68.83 | 68.86 | 68.7 | 68.7199 | 750400.0 |
> showing 50 of 1,333 rows — these rows as CSV