PREVIEW / etf_30min / 2008-08-28
file: by_date/etf_30min/2008/2008-08-28.parquet size: 163 KB rows: 5,740
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-08-28 04:00:00 | SPY | ETF | 128.0 | 128.0 | 128.0 | 128.0 | 300.0 |
| 2008-08-28 06:30:00 | SPY | ETF | 128.51 | 128.51 | 128.5 | 128.5 | 6000.0 |
| 2008-08-28 07:00:00 | SPY | ETF | 128.51 | 128.59 | 128.43 | 128.59 | 38369.0 |
| 2008-08-28 07:30:00 | SPY | ETF | 128.59 | 128.64 | 128.5 | 128.5 | 280483.0 |
| 2008-08-28 08:00:00 | SPY | ETF | 128.5 | 129.1 | 128.43 | 128.89 | 747104.0 |
| 2008-08-28 08:30:00 | SPY | ETF | 128.91 | 129.5 | 128.91 | 129.42 | 4629981.0 |
| 2008-08-28 09:00:00 | SPY | ETF | 129.42 | 129.44 | 129.2 | 129.2 | 1982936.0 |
| 2008-08-28 09:30:00 | SPY | ETF | 129.19 | 129.5 | 129.11 | 129.34 | 20423631.0 |
| 2008-08-28 10:00:00 | SPY | ETF | 129.34 | 129.5 | 129.15 | 129.32 | 12176169.0 |
| 2008-08-28 10:30:00 | SPY | ETF | 129.32 | 129.68 | 129.21 | 129.56 | 14703480.0 |
| 2008-08-28 11:00:00 | SPY | ETF | 129.56 | 129.59 | 129.35 | 129.44 | 7538499.0 |
| 2008-08-28 11:30:00 | SPY | ETF | 129.44 | 129.99 | 129.21 | 129.91 | 17057219.0 |
| 2008-08-28 12:00:00 | SPY | ETF | 129.91 | 130.0 | 129.79 | 129.96 | 8993106.0 |
| 2008-08-28 12:30:00 | SPY | ETF | 129.97 | 130.0 | 129.66 | 129.84 | 7353390.0 |
| 2008-08-28 13:00:00 | SPY | ETF | 129.84 | 129.92 | 129.69 | 129.9 | 5822274.0 |
| 2008-08-28 13:30:00 | SPY | ETF | 129.9 | 130.12 | 129.86 | 129.95 | 7156932.0 |
| 2008-08-28 14:00:00 | SPY | ETF | 129.95 | 130.07 | 129.68 | 130.01 | 8350445.0 |
| 2008-08-28 14:30:00 | SPY | ETF | 130.0 | 130.22 | 130.0 | 130.07 | 7988841.0 |
| 2008-08-28 15:00:00 | SPY | ETF | 130.06 | 130.18 | 129.91 | 130.09 | 8534962.0 |
| 2008-08-28 15:30:00 | SPY | ETF | 130.1 | 130.34 | 129.95 | 130.3 | 18717947.0 |
| 2008-08-28 16:00:00 | SPY | ETF | 130.28 | 130.41 | 130.07 | 130.08 | 8659234.0 |
| 2008-08-28 16:30:00 | SPY | ETF | 130.06 | 130.13 | 130.02 | 130.1 | 490418.0 |
| 2008-08-28 17:00:00 | SPY | ETF | 130.12 | 130.19 | 130.06 | 130.09 | 1193189.0 |
| 2008-08-28 17:30:00 | SPY | ETF | 130.1 | 130.17 | 130.1 | 130.1 | 12100.0 |
| 2008-08-28 18:00:00 | SPY | ETF | 130.11 | 130.11 | 130.07 | 130.1 | 47201.0 |
| 2008-08-28 18:30:00 | SPY | ETF | 130.11 | 130.12 | 130.07 | 130.07 | 750.0 |
| 2008-08-28 19:00:00 | SPY | ETF | 130.06 | 130.238 | 130.06 | 130.06 | 104991.0 |
| 2008-08-28 19:30:00 | SPY | ETF | 130.06 | 130.06 | 129.98 | 129.98 | 18992.0 |
| 2008-08-28 04:00:00 | QQQ | ETF | 46.53 | 46.53 | 46.52 | 46.52 | 500.0 |
| 2008-08-28 06:00:00 | QQQ | ETF | 46.71 | 46.71 | 46.71 | 46.71 | 100.0 |
| 2008-08-28 06:30:00 | QQQ | ETF | 46.64 | 46.64 | 46.63 | 46.63 | 1200.0 |
| 2008-08-28 07:00:00 | QQQ | ETF | 46.65 | 46.67 | 46.61 | 46.66 | 27661.0 |
| 2008-08-28 07:30:00 | QQQ | ETF | 46.67 | 46.71 | 46.66 | 46.66 | 50662.0 |
| 2008-08-28 08:00:00 | QQQ | ETF | 46.67 | 46.97 | 46.65 | 46.86 | 529277.0 |
| 2008-08-28 08:30:00 | QQQ | ETF | 46.87 | 47.06 | 46.86 | 47.06 | 2615443.0 |
| 2008-08-28 09:00:00 | QQQ | ETF | 47.06 | 47.07 | 46.93 | 46.93 | 656326.0 |
| 2008-08-28 09:30:00 | QQQ | ETF | 46.92 | 47.0701 | 46.83 | 47.04 | 14880915.0 |
| 2008-08-28 10:00:00 | QQQ | ETF | 47.04 | 47.09 | 46.95 | 47.0289 | 6413313.0 |
| 2008-08-28 10:30:00 | QQQ | ETF | 47.02 | 47.22 | 46.96 | 47.15 | 9852276.0 |
| 2008-08-28 11:00:00 | QQQ | ETF | 47.15 | 47.17 | 47.07 | 47.12 | 5350201.0 |
| 2008-08-28 11:30:00 | QQQ | ETF | 47.12 | 47.28 | 47.02 | 47.2295 | 8784839.0 |
| 2008-08-28 12:00:00 | QQQ | ETF | 47.225 | 47.23 | 47.1 | 47.18 | 4773884.0 |
| 2008-08-28 12:30:00 | QQQ | ETF | 47.18 | 47.2 | 47.04 | 47.13 | 4210394.0 |
| 2008-08-28 13:00:00 | QQQ | ETF | 47.14 | 47.17 | 47.08 | 47.16 | 2732934.0 |
| 2008-08-28 13:30:00 | QQQ | ETF | 47.16 | 47.24 | 47.11 | 47.16 | 4225609.0 |
| 2008-08-28 14:00:00 | QQQ | ETF | 47.16 | 47.16 | 46.98 | 47.09 | 7042583.0 |
| 2008-08-28 14:30:00 | QQQ | ETF | 47.1 | 47.225 | 47.095 | 47.17 | 4421538.0 |
| 2008-08-28 15:00:00 | QQQ | ETF | 47.16 | 47.2 | 47.03 | 47.115 | 5396404.0 |
| 2008-08-28 15:30:00 | QQQ | ETF | 47.13 | 47.21 | 47.04 | 47.1 | 12072394.0 |
| 2008-08-28 16:00:00 | QQQ | ETF | 47.09 | 47.152 | 46.77 | 46.81 | 10701328.0 |
> showing 50 of 5,740 rows — these rows as CSV