PREVIEW / etf_30min / 2010-11-22
file: by_date/etf_30min/2010/2010-11-22.parquet size: 270 KB rows: 8,855
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-11-22 04:00:00 | SPY | ETF | 120.55 | 120.93 | 120.55 | 120.8 | 4900.0 |
| 2010-11-22 04:30:00 | SPY | ETF | 120.81 | 120.81 | 120.81 | 120.81 | 400.0 |
| 2010-11-22 05:00:00 | SPY | ETF | 120.78 | 120.78 | 120.77 | 120.77 | 1700.0 |
| 2010-11-22 05:30:00 | SPY | ETF | 120.68 | 120.68 | 120.68 | 120.68 | 200.0 |
| 2010-11-22 06:00:00 | SPY | ETF | 120.63 | 120.78 | 120.58 | 120.58 | 4925.0 |
| 2010-11-22 06:30:00 | SPY | ETF | 120.58 | 120.58 | 120.36 | 120.36 | 19967.0 |
| 2010-11-22 07:00:00 | SPY | ETF | 120.37 | 120.37 | 120.08 | 120.14 | 142772.0 |
| 2010-11-22 07:30:00 | SPY | ETF | 120.16 | 120.26 | 120.1 | 120.23 | 261158.0 |
| 2010-11-22 08:00:00 | SPY | ETF | 121.05 | 121.1 | 119.82 | 119.86 | 2038528.0 |
| 2010-11-22 08:30:00 | SPY | ETF | 119.86 | 120.03 | 119.75 | 119.92 | 1797084.0 |
| 2010-11-22 09:00:00 | SPY | ETF | 119.92 | 119.93 | 119.65 | 119.69 | 1592367.0 |
| 2010-11-22 09:30:00 | SPY | ETF | 119.69 | 120.24 | 119.54 | 120.1701 | 18549426.0 |
| 2010-11-22 10:00:00 | SPY | ETF | 120.17 | 120.23 | 119.7 | 119.7099 | 12805935.0 |
| 2010-11-22 10:30:00 | SPY | ETF | 119.7 | 119.73 | 119.42 | 119.52 | 16136808.0 |
| 2010-11-22 11:00:00 | SPY | ETF | 119.52 | 120.2 | 119.32 | 119.61 | 12888420.0 |
| 2010-11-22 11:30:00 | SPY | ETF | 119.61 | 119.68 | 119.52 | 119.61 | 4386491.0 |
| 2010-11-22 12:00:00 | SPY | ETF | 119.61 | 119.62 | 119.04 | 119.07 | 13964967.0 |
| 2010-11-22 12:30:00 | SPY | ETF | 119.05 | 119.08 | 118.77 | 119.04 | 16057158.0 |
| 2010-11-22 13:00:00 | SPY | ETF | 119.04 | 119.15 | 118.95 | 119.11 | 7582746.0 |
| 2010-11-22 13:30:00 | SPY | ETF | 119.11 | 119.43 | 119.1 | 119.38 | 9665736.0 |
| 2010-11-22 14:00:00 | SPY | ETF | 119.39 | 119.68 | 119.33 | 119.49 | 10036175.0 |
| 2010-11-22 14:30:00 | SPY | ETF | 119.499 | 119.92 | 119.46 | 119.88 | 10799131.0 |
| 2010-11-22 15:00:00 | SPY | ETF | 119.88 | 119.98 | 119.66 | 119.76 | 9024516.0 |
| 2010-11-22 15:30:00 | SPY | ETF | 119.76 | 120.205 | 119.66 | 120.15 | 19800831.0 |
| 2010-11-22 16:00:00 | SPY | ETF | 120.16 | 120.33 | 118.965 | 120.23 | 9124466.0 |
| 2010-11-22 16:30:00 | SPY | ETF | 120.2 | 120.21 | 120.08 | 120.17 | 489862.0 |
| 2010-11-22 17:00:00 | SPY | ETF | 120.16 | 120.2 | 120.12 | 120.2 | 100902.0 |
| 2010-11-22 17:30:00 | SPY | ETF | 120.2 | 120.22 | 120.18 | 120.19 | 8123.0 |
| 2010-11-22 18:00:00 | SPY | ETF | 120.22 | 120.27 | 120.15 | 120.15 | 88501.0 |
| 2010-11-22 18:30:00 | SPY | ETF | 120.15 | 120.17 | 120.04 | 120.04 | 62520.0 |
| 2010-11-22 19:00:00 | SPY | ETF | 120.04 | 120.06 | 120.03 | 120.05 | 11308.0 |
| 2010-11-22 19:30:00 | SPY | ETF | 120.06 | 120.08 | 119.98 | 119.99 | 80088.0 |
| 2010-11-22 04:00:00 | QQQ | ETF | 52.75 | 52.75 | 52.75 | 52.75 | 100.0 |
| 2010-11-22 04:30:00 | QQQ | ETF | 52.79 | 52.79 | 52.78 | 52.78 | 430.0 |
| 2010-11-22 06:00:00 | QQQ | ETF | 52.7 | 52.7 | 52.7 | 52.7 | 1000.0 |
| 2010-11-22 06:30:00 | QQQ | ETF | 52.64 | 52.64 | 52.62 | 52.62 | 25100.0 |
| 2010-11-22 07:00:00 | QQQ | ETF | 52.58 | 52.58 | 52.47 | 52.5 | 34364.0 |
| 2010-11-22 07:30:00 | QQQ | ETF | 52.5 | 52.55 | 52.48 | 52.55 | 6100.0 |
| 2010-11-22 08:00:00 | QQQ | ETF | 52.53 | 52.53 | 52.3 | 52.32 | 2015551.0 |
| 2010-11-22 08:30:00 | QQQ | ETF | 52.32 | 52.4 | 52.27 | 52.35 | 323943.0 |
| 2010-11-22 09:00:00 | QQQ | ETF | 52.34 | 52.34 | 52.23 | 52.26 | 633411.0 |
| 2010-11-22 09:30:00 | QQQ | ETF | 52.26 | 52.84 | 52.21 | 52.82 | 10285789.0 |
| 2010-11-22 10:00:00 | QQQ | ETF | 52.83 | 52.88 | 52.6 | 52.6 | 5497918.0 |
| 2010-11-22 10:30:00 | QQQ | ETF | 52.605 | 52.61 | 52.41 | 52.495 | 4351750.0 |
| 2010-11-22 11:00:00 | QQQ | ETF | 52.495 | 52.57 | 52.38 | 52.56 | 3713718.0 |
| 2010-11-22 11:30:00 | QQQ | ETF | 52.57 | 52.62 | 52.51 | 52.61 | 1080635.0 |
| 2010-11-22 12:00:00 | QQQ | ETF | 52.6 | 52.605 | 52.32 | 52.33 | 4853578.0 |
| 2010-11-22 12:30:00 | QQQ | ETF | 52.33 | 52.33 | 52.17 | 52.26 | 5349713.0 |
| 2010-11-22 13:00:00 | QQQ | ETF | 52.26 | 52.33 | 52.2 | 52.29 | 2000838.0 |
| 2010-11-22 13:30:00 | QQQ | ETF | 52.29 | 52.48 | 52.29 | 52.45 | 3623356.0 |
> showing 50 of 8,855 rows — these rows as CSV