PREVIEW / etf_30min / 2010-02-10
file: by_date/etf_30min/2010/2010-02-10.parquet size: 241 KB rows: 8,052
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-10 04:00:00 | SPY | ETF | 106.93 | 106.93 | 106.83 | 106.83 | 2200.0 |
| 2010-02-10 04:30:00 | SPY | ETF | 106.95 | 107.11 | 106.95 | 107.11 | 4900.0 |
| 2010-02-10 05:00:00 | SPY | ETF | 107.12 | 107.56 | 107.12 | 107.33 | 24071.0 |
| 2010-02-10 05:30:00 | SPY | ETF | 107.31 | 107.69 | 107.28 | 107.61 | 56000.0 |
| 2010-02-10 06:00:00 | SPY | ETF | 107.48 | 107.56 | 107.4 | 107.4 | 2600.0 |
| 2010-02-10 06:30:00 | SPY | ETF | 107.42 | 107.6 | 107.41 | 107.54 | 87800.0 |
| 2010-02-10 07:00:00 | SPY | ETF | 107.49 | 107.49 | 107.3 | 107.37 | 99258.0 |
| 2010-02-10 07:30:00 | SPY | ETF | 107.4 | 107.75 | 107.1 | 107.15 | 1529299.0 |
| 2010-02-10 08:00:00 | SPY | ETF | 107.53 | 107.53 | 106.96 | 107.21 | 4087046.0 |
| 2010-02-10 08:30:00 | SPY | ETF | 107.23 | 107.26 | 106.97 | 107.15 | 2263574.0 |
| 2010-02-10 09:00:00 | SPY | ETF | 107.15 | 107.28 | 107.01 | 107.05 | 1382568.0 |
| 2010-02-10 09:30:00 | SPY | ETF | 107.05 | 107.45 | 106.87 | 107.1 | 21598377.0 |
| 2010-02-10 10:00:00 | SPY | ETF | 107.09 | 107.15 | 106.14 | 106.31 | 36673650.0 |
| 2010-02-10 10:30:00 | SPY | ETF | 106.3 | 106.72 | 106.11 | 106.6283 | 21628758.0 |
| 2010-02-10 11:00:00 | SPY | ETF | 106.63 | 106.9 | 106.39 | 106.85 | 17313009.0 |
| 2010-02-10 11:30:00 | SPY | ETF | 106.85 | 106.98 | 106.62 | 106.71 | 14851690.0 |
| 2010-02-10 12:00:00 | SPY | ETF | 106.7 | 107.25 | 106.6 | 107.2 | 14792291.0 |
| 2010-02-10 12:30:00 | SPY | ETF | 107.21 | 107.39 | 107.08 | 107.17 | 9721737.0 |
| 2010-02-10 13:00:00 | SPY | ETF | 107.17 | 107.6 | 107.15 | 107.56 | 13698120.0 |
| 2010-02-10 13:30:00 | SPY | ETF | 107.56 | 107.58 | 107.24 | 107.33 | 9453042.0 |
| 2010-02-10 14:00:00 | SPY | ETF | 107.33 | 107.48 | 107.17 | 107.31 | 10142969.0 |
| 2010-02-10 14:30:00 | SPY | ETF | 107.32 | 107.32 | 106.98 | 107.1 | 12869035.0 |
| 2010-02-10 15:00:00 | SPY | ETF | 107.0995 | 107.32 | 107.08 | 107.25 | 9184799.0 |
| 2010-02-10 15:30:00 | SPY | ETF | 107.25 | 107.26 | 106.82 | 107.0 | 24049957.0 |
| 2010-02-10 16:00:00 | SPY | ETF | 107.02 | 107.25 | 106.29 | 106.87 | 7320531.0 |
| 2010-02-10 16:30:00 | SPY | ETF | 106.86 | 106.9 | 106.78 | 106.84 | 2755724.0 |
| 2010-02-10 17:00:00 | SPY | ETF | 106.87 | 106.89 | 106.78 | 106.86 | 394757.0 |
| 2010-02-10 17:30:00 | SPY | ETF | 106.81 | 106.92 | 106.8 | 106.9 | 54631.0 |
| 2010-02-10 18:00:00 | SPY | ETF | 106.9 | 106.93 | 106.86 | 106.89 | 21975.0 |
| 2010-02-10 18:30:00 | SPY | ETF | 106.91 | 106.93 | 106.88 | 106.9 | 11385.0 |
| 2010-02-10 19:00:00 | SPY | ETF | 106.93 | 107.05 | 106.93 | 107.01 | 49100.0 |
| 2010-02-10 19:30:00 | SPY | ETF | 107.04 | 107.24 | 107.04 | 107.2 | 91588.0 |
| 2010-02-10 04:30:00 | QQQ | ETF | 43.12 | 43.12 | 43.12 | 43.12 | 1000.0 |
| 2010-02-10 05:00:00 | QQQ | ETF | 43.32 | 43.33 | 43.32 | 43.33 | 989.0 |
| 2010-02-10 06:00:00 | QQQ | ETF | 43.34 | 43.34 | 43.25 | 43.25 | 3500.0 |
| 2010-02-10 06:30:00 | QQQ | ETF | 43.27 | 43.27 | 43.27 | 43.27 | 100.0 |
| 2010-02-10 07:00:00 | QQQ | ETF | 43.26 | 43.27 | 43.25 | 43.25 | 18140.0 |
| 2010-02-10 07:30:00 | QQQ | ETF | 43.25 | 43.37 | 43.13 | 43.13 | 249819.0 |
| 2010-02-10 08:00:00 | QQQ | ETF | 43.17 | 43.35 | 43.09 | 43.22 | 1389446.0 |
| 2010-02-10 08:30:00 | QQQ | ETF | 43.22 | 43.22 | 43.12 | 43.19 | 416579.0 |
| 2010-02-10 09:00:00 | QQQ | ETF | 43.18 | 43.24 | 43.11 | 43.11 | 761925.0 |
| 2010-02-10 09:30:00 | QQQ | ETF | 43.1 | 43.31 | 43.04 | 43.16 | 10211961.0 |
| 2010-02-10 10:00:00 | QQQ | ETF | 43.16 | 43.18 | 42.77 | 42.85 | 11353921.0 |
| 2010-02-10 10:30:00 | QQQ | ETF | 42.8461 | 42.95 | 42.75 | 42.91 | 9810976.0 |
| 2010-02-10 11:00:00 | QQQ | ETF | 42.91 | 42.99 | 42.82 | 42.97 | 6026735.0 |
| 2010-02-10 11:30:00 | QQQ | ETF | 42.97 | 43.02 | 42.87 | 42.91 | 4102346.0 |
| 2010-02-10 12:00:00 | QQQ | ETF | 42.91 | 43.12 | 42.86 | 43.1 | 7354604.0 |
| 2010-02-10 12:30:00 | QQQ | ETF | 43.11 | 43.16 | 43.08 | 43.11 | 4292643.0 |
| 2010-02-10 13:00:00 | QQQ | ETF | 43.11 | 43.26 | 42.95 | 43.25 | 5013066.0 |
| 2010-02-10 13:30:00 | QQQ | ETF | 43.24 | 43.25 | 43.13 | 43.16 | 4083951.0 |
> showing 50 of 8,052 rows — these rows as CSV