PREVIEW / etf_1hour / 2008-01-28
file: by_date/etf_1hour/2008/2008-01-28.parquet size: 100 KB rows: 3,357
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-28 04:00:00 | SPY | ETF | 132.49 | 132.49 | 132.49 | 132.49 | 200.0 |
| 2008-01-28 05:00:00 | SPY | ETF | 132.04 | 132.04 | 132.0 | 132.0 | 700.0 |
| 2008-01-28 06:00:00 | SPY | ETF | 132.1 | 132.27 | 132.05 | 132.24 | 51400.0 |
| 2008-01-28 07:00:00 | SPY | ETF | 132.34 | 132.64 | 132.18 | 132.44 | 552700.0 |
| 2008-01-28 08:00:00 | SPY | ETF | 132.42 | 133.04 | 132.05 | 132.77 | 3586200.0 |
| 2008-01-28 09:00:00 | SPY | ETF | 132.78 | 133.33 | 132.29 | 132.88 | 23407792.0 |
| 2008-01-28 10:00:00 | SPY | ETF | 132.88 | 134.08 | 132.06 | 133.82 | 44380967.0 |
| 2008-01-28 11:00:00 | SPY | ETF | 133.81 | 134.45 | 133.48 | 133.89 | 20602390.0 |
| 2008-01-28 12:00:00 | SPY | ETF | 133.8999 | 134.22 | 133.46 | 134.03 | 14456392.0 |
| 2008-01-28 13:00:00 | SPY | ETF | 134.04 | 134.68 | 133.98 | 134.22 | 24753958.0 |
| 2008-01-28 14:00:00 | SPY | ETF | 134.22 | 134.89 | 134.21 | 134.28 | 24870132.0 |
| 2008-01-28 15:00:00 | SPY | ETF | 134.28 | 135.33 | 133.73 | 135.32 | 43097982.0 |
| 2008-01-28 16:00:00 | SPY | ETF | 135.26 | 135.51 | 132.85 | 134.99 | 10168700.0 |
| 2008-01-28 17:00:00 | SPY | ETF | 135.06 | 135.5 | 135.02 | 135.36 | 1078800.0 |
| 2008-01-28 18:00:00 | SPY | ETF | 135.35 | 135.42 | 135.22 | 135.35 | 255000.0 |
| 2008-01-28 19:00:00 | SPY | ETF | 135.35 | 135.4 | 135.28 | 135.33 | 58000.0 |
| 2008-01-28 04:00:00 | QQQ | ETF | 43.76 | 43.76 | 43.76 | 43.76 | 200.0 |
| 2008-01-28 06:00:00 | QQQ | ETF | 43.54 | 43.56 | 43.47 | 43.56 | 9500.0 |
| 2008-01-28 07:00:00 | QQQ | ETF | 43.58 | 43.8 | 43.57 | 43.77 | 392046.0 |
| 2008-01-28 08:00:00 | QQQ | ETF | 43.78 | 43.97 | 43.47 | 43.93 | 2247434.0 |
| 2008-01-28 09:00:00 | QQQ | ETF | 43.94 | 44.07 | 43.57 | 43.95 | 30245763.0 |
| 2008-01-28 10:00:00 | QQQ | ETF | 43.95 | 44.29 | 43.61 | 44.2 | 32277747.0 |
| 2008-01-28 11:00:00 | QQQ | ETF | 44.2 | 44.38 | 44.06 | 44.18 | 14169830.0 |
| 2008-01-28 12:00:00 | QQQ | ETF | 44.19 | 44.24 | 44.04 | 44.14 | 9624480.0 |
| 2008-01-28 13:00:00 | QQQ | ETF | 44.15 | 44.39 | 44.14 | 44.25 | 12491301.0 |
| 2008-01-28 14:00:00 | QQQ | ETF | 44.25 | 44.44 | 44.14 | 44.15 | 19227172.0 |
| 2008-01-28 15:00:00 | QQQ | ETF | 44.15 | 44.37 | 43.83 | 44.37 | 37366871.0 |
| 2008-01-28 16:00:00 | QQQ | ETF | 44.38 | 44.44 | 43.88 | 44.17 | 4685355.0 |
| 2008-01-28 17:00:00 | QQQ | ETF | 44.18 | 44.33 | 44.17 | 44.23 | 694500.0 |
| 2008-01-28 18:00:00 | QQQ | ETF | 44.23 | 44.26 | 44.18 | 44.22 | 240902.0 |
| 2008-01-28 19:00:00 | QQQ | ETF | 44.21 | 44.24 | 44.18 | 44.22 | 38079.0 |
| 2008-01-28 04:00:00 | IWM | ETF | 68.0 | 68.0 | 68.0 | 68.0 | 200.0 |
| 2008-01-28 07:00:00 | IWM | ETF | 67.95 | 68.12 | 67.92 | 68.12 | 137000.0 |
| 2008-01-28 08:00:00 | IWM | ETF | 67.98 | 68.37 | 67.98 | 68.21 | 549800.0 |
| 2008-01-28 09:00:00 | IWM | ETF | 68.23 | 68.55 | 67.72 | 68.18 | 9515768.0 |
| 2008-01-28 10:00:00 | IWM | ETF | 68.19 | 69.11 | 67.71 | 68.96 | 12787190.0 |
| 2008-01-28 11:00:00 | IWM | ETF | 68.94 | 69.41 | 68.85 | 69.1 | 6864521.0 |
| 2008-01-28 12:00:00 | IWM | ETF | 69.1 | 69.28 | 68.91 | 69.1 | 4547214.0 |
| 2008-01-28 13:00:00 | IWM | ETF | 69.11 | 69.65 | 69.09 | 69.36 | 8990842.0 |
| 2008-01-28 14:00:00 | IWM | ETF | 69.36 | 69.97 | 69.35 | 69.45 | 14734606.0 |
| 2008-01-28 15:00:00 | IWM | ETF | 69.45 | 69.95 | 69.04 | 69.93 | 13959199.0 |
| 2008-01-28 16:00:00 | IWM | ETF | 69.93 | 70.4 | 68.49 | 69.78 | 12232318.0 |
| 2008-01-28 17:00:00 | IWM | ETF | 69.83 | 70.01 | 69.8 | 69.8 | 57600.0 |
| 2008-01-28 18:00:00 | IWM | ETF | 69.9 | 69.96 | 69.88 | 69.88 | 19100.0 |
| 2008-01-28 19:00:00 | IWM | ETF | 69.94 | 69.98 | 69.94 | 69.98 | 12700.0 |
| 2008-01-28 04:00:00 | DIA | ETF | 122.18 | 122.18 | 122.18 | 122.18 | 100.0 |
| 2008-01-28 07:00:00 | DIA | ETF | 121.57 | 121.8 | 121.57 | 121.6 | 6100.0 |
| 2008-01-28 08:00:00 | DIA | ETF | 121.62 | 122.08 | 121.17 | 121.76 | 46000.0 |
| 2008-01-28 09:00:00 | DIA | ETF | 121.8 | 122.08 | 121.27 | 121.68 | 2934981.0 |
| 2008-01-28 10:00:00 | DIA | ETF | 121.65 | 122.65 | 121.0 | 122.45 | 4627410.0 |
> showing 50 of 3,357 rows — these rows as CSV