PREVIEW / etf_30min / 2010-10-29
file: by_date/etf_30min/2010/2010-10-29.parquet size: 254 KB rows: 8,583
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-10-29 05:00:00 | SPY | ETF | 117.81 | 117.81 | 117.72 | 117.72 | 1548.0 |
| 2010-10-29 05:30:00 | SPY | ETF | 117.83 | 117.83 | 117.73 | 117.76 | 5050.0 |
| 2010-10-29 06:00:00 | SPY | ETF | 117.83 | 117.88 | 117.83 | 117.88 | 1600.0 |
| 2010-10-29 06:30:00 | SPY | ETF | 117.89 | 117.96 | 117.89 | 117.95 | 2000.0 |
| 2010-10-29 07:00:00 | SPY | ETF | 117.96 | 117.96 | 117.8 | 117.8 | 208226.0 |
| 2010-10-29 07:30:00 | SPY | ETF | 117.8 | 117.97 | 117.75 | 117.93 | 84000.0 |
| 2010-10-29 08:00:00 | SPY | ETF | 117.96 | 118.05 | 117.9 | 117.96 | 393500.0 |
| 2010-10-29 08:30:00 | SPY | ETF | 117.93 | 118.39 | 117.75 | 118.28 | 1555326.0 |
| 2010-10-29 09:00:00 | SPY | ETF | 118.3 | 118.39 | 118.13 | 118.28 | 1196197.0 |
| 2010-10-29 09:30:00 | SPY | ETF | 118.28 | 118.56 | 118.12 | 118.19 | 18726312.0 |
| 2010-10-29 10:00:00 | SPY | ETF | 118.19 | 118.72 | 118.11 | 118.56 | 14954770.0 |
| 2010-10-29 10:30:00 | SPY | ETF | 118.57 | 118.57 | 118.27 | 118.49 | 8656429.0 |
| 2010-10-29 11:00:00 | SPY | ETF | 118.49 | 118.6 | 118.38 | 118.4 | 7491073.0 |
| 2010-10-29 11:30:00 | SPY | ETF | 118.39 | 118.42 | 118.07 | 118.29 | 15738007.0 |
| 2010-10-29 12:00:00 | SPY | ETF | 118.3 | 118.5 | 118.29 | 118.465 | 9092291.0 |
| 2010-10-29 12:30:00 | SPY | ETF | 118.47 | 118.57 | 118.42 | 118.5138 | 5815934.0 |
| 2010-10-29 13:00:00 | SPY | ETF | 118.51 | 118.54 | 118.37 | 118.51 | 3653041.0 |
| 2010-10-29 13:30:00 | SPY | ETF | 118.53 | 118.66 | 118.44 | 118.64 | 7165834.0 |
| 2010-10-29 14:00:00 | SPY | ETF | 118.63 | 118.7 | 118.52 | 118.52 | 4958608.0 |
| 2010-10-29 14:30:00 | SPY | ETF | 118.53 | 118.56 | 118.35 | 118.386 | 5763952.0 |
| 2010-10-29 15:00:00 | SPY | ETF | 118.38 | 118.55 | 118.33 | 118.51 | 9572546.0 |
| 2010-10-29 15:30:00 | SPY | ETF | 118.51 | 118.7 | 118.46 | 118.47 | 17459427.0 |
| 2010-10-29 16:00:00 | SPY | ETF | 118.49 | 118.635 | 118.215 | 118.35 | 10386933.0 |
| 2010-10-29 16:30:00 | SPY | ETF | 118.36 | 118.47 | 118.32 | 118.44 | 420638.0 |
| 2010-10-29 17:00:00 | SPY | ETF | 118.41 | 118.44 | 118.34 | 118.4 | 143497.0 |
| 2010-10-29 17:30:00 | SPY | ETF | 118.37 | 118.4 | 118.33 | 118.39 | 73859.0 |
| 2010-10-29 18:00:00 | SPY | ETF | 118.33 | 118.53 | 118.29 | 118.3 | 65176.0 |
| 2010-10-29 18:30:00 | SPY | ETF | 118.3 | 118.34 | 118.29 | 118.31 | 19392.0 |
| 2010-10-29 19:00:00 | SPY | ETF | 118.31 | 118.33 | 118.3 | 118.31 | 35417.0 |
| 2010-10-29 19:30:00 | SPY | ETF | 118.33 | 118.35 | 118.27 | 118.34 | 10268.0 |
| 2010-10-29 05:00:00 | QQQ | ETF | 52.08 | 52.08 | 52.05 | 52.05 | 550.0 |
| 2010-10-29 05:30:00 | QQQ | ETF | 52.07 | 52.07 | 52.07 | 52.07 | 1100.0 |
| 2010-10-29 06:00:00 | QQQ | ETF | 52.07 | 52.11 | 52.07 | 52.11 | 2100.0 |
| 2010-10-29 06:30:00 | QQQ | ETF | 52.11 | 52.11 | 52.11 | 52.11 | 5700.0 |
| 2010-10-29 07:00:00 | QQQ | ETF | 52.12 | 52.13 | 52.1 | 52.1 | 74813.0 |
| 2010-10-29 07:30:00 | QQQ | ETF | 52.1 | 52.14 | 52.08 | 52.13 | 34283.0 |
| 2010-10-29 08:00:00 | QQQ | ETF | 52.14 | 52.18 | 52.11 | 52.14 | 254894.0 |
| 2010-10-29 08:30:00 | QQQ | ETF | 52.1 | 52.3 | 52.07 | 52.26 | 272389.0 |
| 2010-10-29 09:00:00 | QQQ | ETF | 52.26 | 52.3 | 52.21 | 52.29 | 258595.0 |
| 2010-10-29 09:30:00 | QQQ | ETF | 52.29 | 52.46 | 52.22 | 52.31 | 9586024.0 |
| 2010-10-29 10:00:00 | QQQ | ETF | 52.31 | 52.49 | 52.28 | 52.41 | 4632330.0 |
| 2010-10-29 10:30:00 | QQQ | ETF | 52.42 | 52.4265 | 52.19 | 52.3 | 3554049.0 |
| 2010-10-29 11:00:00 | QQQ | ETF | 52.3 | 52.36 | 52.27 | 52.29 | 1764712.0 |
| 2010-10-29 11:30:00 | QQQ | ETF | 52.28 | 52.3 | 52.1698 | 52.26 | 4755716.0 |
| 2010-10-29 12:00:00 | QQQ | ETF | 52.25 | 52.38 | 52.25 | 52.36 | 1414831.0 |
| 2010-10-29 12:30:00 | QQQ | ETF | 52.36 | 52.43 | 52.34 | 52.36 | 1732820.0 |
| 2010-10-29 13:00:00 | QQQ | ETF | 52.3601 | 52.37 | 52.26 | 52.35 | 2063013.0 |
| 2010-10-29 13:30:00 | QQQ | ETF | 52.35 | 52.41 | 52.285 | 52.3991 | 1246999.0 |
| 2010-10-29 14:00:00 | QQQ | ETF | 52.39 | 52.4 | 52.32 | 52.32 | 2280085.0 |
| 2010-10-29 14:30:00 | QQQ | ETF | 52.325 | 52.34 | 52.23 | 52.24 | 1473379.0 |
> showing 50 of 8,583 rows — these rows as CSV