PREVIEW / etf_1hour / 2006-05-15
file: by_date/etf_1hour/2006/2006-05-15.parquet size: 45 KB rows: 1,364
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-15 05:00:00 | SPY | ETF | 129.19 | 129.19 | 129.19 | 129.19 | 5000.0 |
| 2006-05-15 06:00:00 | SPY | ETF | 129.0 | 129.29 | 128.96 | 129.05 | 15500.0 |
| 2006-05-15 07:00:00 | SPY | ETF | 129.11 | 129.11 | 128.9 | 129.06 | 133300.0 |
| 2006-05-15 08:00:00 | SPY | ETF | 129.04 | 129.35 | 128.8 | 128.94 | 987000.0 |
| 2006-05-15 09:00:00 | SPY | ETF | 128.93 | 129.38 | 128.75 | 129.1 | 13160300.0 |
| 2006-05-15 10:00:00 | SPY | ETF | 129.09 | 129.71 | 128.87 | 129.38 | 21984400.0 |
| 2006-05-15 11:00:00 | SPY | ETF | 129.38 | 129.66 | 129.25 | 129.47 | 6829800.0 |
| 2006-05-15 12:00:00 | SPY | ETF | 129.47 | 129.55 | 129.27 | 129.45 | 2765700.0 |
| 2006-05-15 13:00:00 | SPY | ETF | 129.47 | 129.53 | 128.61 | 128.76 | 11576900.0 |
| 2006-05-15 14:00:00 | SPY | ETF | 128.76 | 129.24 | 128.64 | 128.89 | 11326600.0 |
| 2006-05-15 15:00:00 | SPY | ETF | 128.89 | 129.74 | 128.82 | 129.62 | 13094200.0 |
| 2006-05-15 16:00:00 | SPY | ETF | 129.61 | 129.66 | 129.47 | 129.53 | 822800.0 |
| 2006-05-15 17:00:00 | SPY | ETF | 129.53 | 129.57 | 129.49 | 129.5 | 88200.0 |
| 2006-05-15 18:00:00 | SPY | ETF | 129.49 | 129.55 | 129.49 | 129.55 | 12100.0 |
| 2006-05-15 19:00:00 | SPY | ETF | 129.56 | 129.6 | 129.55 | 129.55 | 7700.0 |
| 2006-05-15 09:00:00 | QQQ | ETF | 40.03 | 40.34 | 40.02 | 40.16 | 20229000.0 |
| 2006-05-15 10:00:00 | QQQ | ETF | 40.16 | 40.28 | 39.95 | 40.07 | 25865500.0 |
| 2006-05-15 11:00:00 | QQQ | ETF | 40.06 | 40.22 | 40.05 | 40.17 | 10814700.0 |
| 2006-05-15 12:00:00 | QQQ | ETF | 40.18 | 40.21 | 40.11 | 40.14 | 5109100.0 |
| 2006-05-15 13:00:00 | QQQ | ETF | 40.14 | 40.16 | 39.79 | 39.85 | 14734900.0 |
| 2006-05-15 14:00:00 | QQQ | ETF | 39.86 | 40.05 | 39.82 | 39.91 | 18359700.0 |
| 2006-05-15 15:00:00 | QQQ | ETF | 39.91 | 40.23 | 39.89 | 40.18 | 21573100.0 |
| 2006-05-15 08:00:00 | IWM | ETF | 73.23 | 73.25 | 72.75 | 72.79 | 1159000.0 |
| 2006-05-15 09:00:00 | IWM | ETF | 72.89 | 73.67 | 72.35 | 73.12 | 9603900.0 |
| 2006-05-15 10:00:00 | IWM | ETF | 73.13 | 73.71 | 72.8 | 73.33 | 15890300.0 |
| 2006-05-15 11:00:00 | IWM | ETF | 73.32 | 73.61 | 73.22 | 73.44 | 4663300.0 |
| 2006-05-15 12:00:00 | IWM | ETF | 73.44 | 73.51 | 73.29 | 73.38 | 2676200.0 |
| 2006-05-15 13:00:00 | IWM | ETF | 73.38 | 73.45 | 72.42 | 72.58 | 7249200.0 |
| 2006-05-15 14:00:00 | IWM | ETF | 72.58 | 73.13 | 72.51 | 72.77 | 9194500.0 |
| 2006-05-15 15:00:00 | IWM | ETF | 72.77 | 73.55 | 72.72 | 73.34 | 8861300.0 |
| 2006-05-15 16:00:00 | IWM | ETF | 73.34 | 73.39 | 73.14 | 73.18 | 96100.0 |
| 2006-05-15 17:00:00 | IWM | ETF | 73.27 | 73.28 | 73.18 | 73.2 | 12300.0 |
| 2006-05-15 18:00:00 | IWM | ETF | 73.27 | 73.27 | 73.27 | 73.27 | 5000.0 |
| 2006-05-15 07:00:00 | DIA | ETF | 113.7 | 113.79 | 113.63 | 113.79 | 10000.0 |
| 2006-05-15 08:00:00 | DIA | ETF | 113.74 | 113.79 | 113.63 | 113.74 | 61900.0 |
| 2006-05-15 09:00:00 | DIA | ETF | 113.73 | 114.12 | 113.51 | 113.8 | 1075000.0 |
| 2006-05-15 10:00:00 | DIA | ETF | 113.79 | 114.2 | 113.63 | 114.01 | 1560100.0 |
| 2006-05-15 11:00:00 | DIA | ETF | 114.01 | 114.23 | 113.9 | 114.07 | 569200.0 |
| 2006-05-15 12:00:00 | DIA | ETF | 114.07 | 114.11 | 113.9 | 114.07 | 283000.0 |
| 2006-05-15 13:00:00 | DIA | ETF | 114.06 | 114.14 | 113.42 | 113.5 | 1020100.0 |
| 2006-05-15 14:00:00 | DIA | ETF | 113.51 | 113.91 | 113.44 | 113.69 | 1043000.0 |
| 2006-05-15 15:00:00 | DIA | ETF | 113.69 | 114.43 | 113.63 | 114.37 | 1613800.0 |
| 2006-05-15 16:00:00 | DIA | ETF | 114.34 | 114.36 | 114.27 | 114.3 | 64900.0 |
| 2006-05-15 19:00:00 | DIA | ETF | 114.32 | 114.32 | 114.32 | 114.32 | 600.0 |
| 2006-05-15 04:00:00 | GLD | ETF | 70.25 | 70.25 | 69.81 | 69.81 | 2600.0 |
| 2006-05-15 07:00:00 | GLD | ETF | 68.9 | 69.64 | 68.55 | 68.6 | 563900.0 |
| 2006-05-15 08:00:00 | GLD | ETF | 68.63 | 69.53 | 68.52 | 69.09 | 1051800.0 |
| 2006-05-15 09:00:00 | GLD | ETF | 69.09 | 69.27 | 68.18 | 68.22 | 4159900.0 |
| 2006-05-15 10:00:00 | GLD | ETF | 68.21 | 69.3 | 68.06 | 68.89 | 3685300.0 |
| 2006-05-15 11:00:00 | GLD | ETF | 68.89 | 68.98 | 68.1 | 68.17 | 1851500.0 |
> showing 50 of 1,364 rows — these rows as CSV