PREVIEW / etf_30min / 2008-02-12
file: by_date/etf_30min/2008/2008-02-12.parquet size: 154 KB rows: 5,567
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-02-12 05:00:00 | SPY | ETF | 133.52 | 133.52 | 133.52 | 133.52 | 300.0 |
| 2008-02-12 06:00:00 | SPY | ETF | 133.91 | 134.45 | 133.91 | 134.4 | 10800.0 |
| 2008-02-12 06:30:00 | SPY | ETF | 134.39 | 134.39 | 134.22 | 134.29 | 23000.0 |
| 2008-02-12 07:00:00 | SPY | ETF | 134.34 | 134.59 | 134.23 | 134.26 | 810600.0 |
| 2008-02-12 07:30:00 | SPY | ETF | 134.26 | 134.39 | 134.0 | 134.04 | 686200.0 |
| 2008-02-12 08:00:00 | SPY | ETF | 134.05 | 135.17 | 133.45 | 134.96 | 12481200.0 |
| 2008-02-12 08:30:00 | SPY | ETF | 134.96 | 135.02 | 134.5 | 134.83 | 3404700.0 |
| 2008-02-12 09:00:00 | SPY | ETF | 134.82 | 134.95 | 134.75 | 134.93 | 2326651.0 |
| 2008-02-12 09:30:00 | SPY | ETF | 134.91 | 135.19 | 134.56 | 135.13 | 22617702.0 |
| 2008-02-12 10:00:00 | SPY | ETF | 135.15 | 135.96 | 135.12 | 135.69 | 26069738.0 |
| 2008-02-12 10:30:00 | SPY | ETF | 135.71 | 136.3 | 135.62 | 136.1885 | 17695894.0 |
| 2008-02-12 11:00:00 | SPY | ETF | 136.19 | 136.31 | 135.91 | 136.03 | 13246303.0 |
| 2008-02-12 11:30:00 | SPY | ETF | 136.05 | 136.12 | 135.73 | 135.8 | 9845835.0 |
| 2008-02-12 12:00:00 | SPY | ETF | 135.8 | 135.94 | 135.3 | 135.41 | 13351860.0 |
| 2008-02-12 12:30:00 | SPY | ETF | 135.39 | 135.48 | 135.0 | 135.48 | 13084363.0 |
| 2008-02-12 13:00:00 | SPY | ETF | 135.48 | 135.92 | 135.45 | 135.83 | 13449541.0 |
| 2008-02-12 13:30:00 | SPY | ETF | 135.83 | 135.94 | 135.58 | 135.91 | 7013036.0 |
| 2008-02-12 14:00:00 | SPY | ETF | 135.91 | 135.92 | 135.4 | 135.51 | 7624540.0 |
| 2008-02-12 14:30:00 | SPY | ETF | 135.51 | 135.8 | 135.08 | 135.77 | 16821573.0 |
| 2008-02-12 15:00:00 | SPY | ETF | 135.76 | 135.78 | 134.44 | 134.73 | 24507005.0 |
| 2008-02-12 15:30:00 | SPY | ETF | 134.7399 | 135.05 | 133.98 | 134.94 | 40036247.0 |
| 2008-02-12 16:00:00 | SPY | ETF | 135.0 | 135.19 | 134.73 | 135.02 | 5278500.0 |
| 2008-02-12 16:30:00 | SPY | ETF | 135.02 | 135.06 | 134.9 | 135.05 | 2265100.0 |
| 2008-02-12 17:00:00 | SPY | ETF | 135.05 | 135.08 | 134.96 | 135.03 | 90400.0 |
| 2008-02-12 17:30:00 | SPY | ETF | 135.05 | 135.1 | 134.95 | 134.97 | 34100.0 |
| 2008-02-12 18:00:00 | SPY | ETF | 134.97 | 134.98 | 134.87 | 134.88 | 133100.0 |
| 2008-02-12 18:30:00 | SPY | ETF | 134.89 | 134.89 | 134.81 | 134.87 | 26700.0 |
| 2008-02-12 19:00:00 | SPY | ETF | 134.84 | 134.86 | 134.62 | 134.66 | 45100.0 |
| 2008-02-12 19:30:00 | SPY | ETF | 134.68 | 134.74 | 134.6 | 134.66 | 46500.0 |
| 2008-02-12 06:30:00 | QQQ | ETF | 44.23 | 44.23 | 44.23 | 44.23 | 10000.0 |
| 2008-02-12 07:00:00 | QQQ | ETF | 44.25 | 44.29 | 44.24 | 44.25 | 66713.0 |
| 2008-02-12 07:30:00 | QQQ | ETF | 44.25 | 44.25 | 44.19 | 44.21 | 51078.0 |
| 2008-02-12 08:00:00 | QQQ | ETF | 43.95 | 44.56 | 43.95 | 44.52 | 2099194.0 |
| 2008-02-12 08:30:00 | QQQ | ETF | 44.51 | 44.53 | 44.38 | 44.42 | 1156190.0 |
| 2008-02-12 09:00:00 | QQQ | ETF | 44.42 | 44.43 | 44.33 | 44.33 | 1073187.0 |
| 2008-02-12 09:30:00 | QQQ | ETF | 44.32 | 44.41 | 44.25 | 44.3 | 16036195.0 |
| 2008-02-12 10:00:00 | QQQ | ETF | 44.3 | 44.48 | 44.29 | 44.38 | 12650792.0 |
| 2008-02-12 10:30:00 | QQQ | ETF | 44.38 | 44.58 | 44.35 | 44.56 | 9285756.0 |
| 2008-02-12 11:00:00 | QQQ | ETF | 44.56 | 44.57 | 44.43 | 44.49 | 7529147.0 |
| 2008-02-12 11:30:00 | QQQ | ETF | 44.49 | 44.52 | 44.42 | 44.425 | 5285051.0 |
| 2008-02-12 12:00:00 | QQQ | ETF | 44.42 | 44.47 | 44.26 | 44.32 | 7672736.0 |
| 2008-02-12 12:30:00 | QQQ | ETF | 44.31 | 44.32 | 44.13 | 44.27 | 8463509.0 |
| 2008-02-12 13:00:00 | QQQ | ETF | 44.27 | 44.36 | 44.23 | 44.33 | 4620330.0 |
| 2008-02-12 13:30:00 | QQQ | ETF | 44.33 | 44.34 | 44.21 | 44.32 | 4896924.0 |
| 2008-02-12 14:00:00 | QQQ | ETF | 44.32 | 44.32 | 44.16 | 44.21 | 3949011.0 |
| 2008-02-12 14:30:00 | QQQ | ETF | 44.2 | 44.24 | 44.06 | 44.24 | 9145521.0 |
| 2008-02-12 15:00:00 | QQQ | ETF | 44.23 | 44.23 | 43.72 | 43.77 | 20738310.0 |
| 2008-02-12 15:30:00 | QQQ | ETF | 43.77 | 43.83 | 43.51 | 43.81 | 24755973.0 |
| 2008-02-12 16:00:00 | QQQ | ETF | 43.82 | 44.1586 | 43.6318 | 43.9 | 3987778.0 |
| 2008-02-12 16:30:00 | QQQ | ETF | 43.9 | 44.0976 | 43.9 | 43.94 | 3734615.0 |
> showing 50 of 5,567 rows — these rows as CSV