PREVIEW / etf_30min / 2010-10-12
file: by_date/etf_30min/2010/2010-10-12.parquet size: 255 KB rows: 8,598
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-12 04:00:00 | SPY | ETF | 116.41 | 116.41 | 115.7 | 115.75 | 11255.0 |
| 2010-10-12 04:30:00 | SPY | ETF | 115.73 | 115.81 | 115.7 | 115.7 | 2300.0 |
| 2010-10-12 05:00:00 | SPY | ETF | 115.75 | 115.91 | 115.75 | 115.8 | 52525.0 |
| 2010-10-12 05:30:00 | SPY | ETF | 115.98 | 115.98 | 115.98 | 115.98 | 700.0 |
| 2010-10-12 06:00:00 | SPY | ETF | 115.95 | 115.98 | 115.83 | 115.83 | 900.0 |
| 2010-10-12 06:30:00 | SPY | ETF | 116.04 | 116.04 | 115.96 | 116.02 | 19300.0 |
| 2010-10-12 07:00:00 | SPY | ETF | 116.02 | 116.06 | 115.98 | 116.05 | 261527.0 |
| 2010-10-12 07:30:00 | SPY | ETF | 116.03 | 116.32 | 115.99 | 116.25 | 229045.0 |
| 2010-10-12 08:00:00 | SPY | ETF | 116.25 | 116.31 | 115.8 | 116.07 | 2782075.0 |
| 2010-10-12 08:30:00 | SPY | ETF | 116.08 | 116.39 | 116.08 | 116.38 | 654821.0 |
| 2010-10-12 09:00:00 | SPY | ETF | 116.38 | 116.4 | 116.25 | 116.26 | 2501647.0 |
| 2010-10-12 09:30:00 | SPY | ETF | 116.27 | 116.31 | 115.65 | 115.88 | 23978370.0 |
| 2010-10-12 10:00:00 | SPY | ETF | 115.88 | 116.23 | 115.81 | 116.08 | 15956974.0 |
| 2010-10-12 10:30:00 | SPY | ETF | 116.09 | 116.52 | 116.04 | 116.3999 | 10691922.0 |
| 2010-10-12 11:00:00 | SPY | ETF | 116.4 | 116.55 | 116.37 | 116.51 | 8111869.0 |
| 2010-10-12 11:30:00 | SPY | ETF | 116.5019 | 116.59 | 116.35 | 116.46 | 7957651.0 |
| 2010-10-12 12:00:00 | SPY | ETF | 116.465 | 116.6 | 116.37 | 116.37 | 6704242.0 |
| 2010-10-12 12:30:00 | SPY | ETF | 116.375 | 116.4 | 116.32 | 116.3499 | 2986851.0 |
| 2010-10-12 13:00:00 | SPY | ETF | 116.345 | 116.44 | 116.3 | 116.4231 | 2994719.0 |
| 2010-10-12 13:30:00 | SPY | ETF | 116.42 | 116.46 | 116.38 | 116.44 | 2572163.0 |
| 2010-10-12 14:00:00 | SPY | ETF | 116.44 | 117.02 | 116.29 | 116.77 | 22567549.0 |
| 2010-10-12 14:30:00 | SPY | ETF | 116.77 | 116.87 | 116.49 | 116.85 | 12485346.0 |
| 2010-10-12 15:00:00 | SPY | ETF | 116.85 | 117.35 | 116.64 | 117.34 | 14051100.0 |
| 2010-10-12 15:30:00 | SPY | ETF | 117.33 | 117.35 | 117.0 | 117.04 | 22272587.0 |
| 2010-10-12 16:00:00 | SPY | ETF | 117.04 | 117.25 | 115.915 | 117.04 | 10639601.0 |
| 2010-10-12 16:30:00 | SPY | ETF | 117.03 | 117.15 | 116.95 | 117.07 | 1155684.0 |
| 2010-10-12 17:00:00 | SPY | ETF | 117.07 | 117.12 | 117.0 | 117.1 | 7251585.0 |
| 2010-10-12 17:30:00 | SPY | ETF | 117.09 | 117.16 | 117.09 | 117.16 | 59282.0 |
| 2010-10-12 18:00:00 | SPY | ETF | 117.13 | 117.13 | 116.98 | 117.01 | 137778.0 |
| 2010-10-12 18:30:00 | SPY | ETF | 117.0 | 117.08 | 117.0 | 117.05 | 64411.0 |
| 2010-10-12 19:00:00 | SPY | ETF | 117.06 | 117.11 | 117.05 | 117.1 | 70159.0 |
| 2010-10-12 19:30:00 | SPY | ETF | 117.12 | 117.13 | 117.02 | 117.05 | 207246.0 |
| 2010-10-12 04:00:00 | QQQ | ETF | 49.59 | 49.59 | 49.36 | 49.38 | 3674.0 |
| 2010-10-12 04:30:00 | QQQ | ETF | 49.39 | 49.39 | 49.38 | 49.38 | 700.0 |
| 2010-10-12 05:00:00 | QQQ | ETF | 49.44 | 49.44 | 49.44 | 49.44 | 200.0 |
| 2010-10-12 06:00:00 | QQQ | ETF | 49.5 | 49.5 | 49.46 | 49.46 | 5400.0 |
| 2010-10-12 06:30:00 | QQQ | ETF | 49.55 | 49.55 | 49.55 | 49.55 | 300.0 |
| 2010-10-12 07:00:00 | QQQ | ETF | 49.55 | 49.55 | 49.54 | 49.55 | 37400.0 |
| 2010-10-12 07:30:00 | QQQ | ETF | 49.55 | 49.65 | 49.54 | 49.64 | 128842.0 |
| 2010-10-12 08:00:00 | QQQ | ETF | 49.63 | 49.64 | 49.56 | 49.56 | 201990.0 |
| 2010-10-12 08:30:00 | QQQ | ETF | 49.59 | 49.75 | 49.59 | 49.75 | 150127.0 |
| 2010-10-12 09:00:00 | QQQ | ETF | 49.74 | 49.74 | 49.68 | 49.68 | 1222486.0 |
| 2010-10-12 09:30:00 | QQQ | ETF | 49.69 | 49.725 | 49.26 | 49.365 | 17356703.0 |
| 2010-10-12 10:00:00 | QQQ | ETF | 49.36 | 49.725 | 49.34 | 49.655 | 8671748.0 |
| 2010-10-12 10:30:00 | QQQ | ETF | 49.66 | 49.98 | 49.63 | 49.92 | 6608100.0 |
| 2010-10-12 11:00:00 | QQQ | ETF | 49.91 | 49.98 | 49.86 | 49.91 | 4251338.0 |
| 2010-10-12 11:30:00 | QQQ | ETF | 49.91 | 49.96 | 49.84 | 49.8931 | 2048308.0 |
| 2010-10-12 12:00:00 | QQQ | ETF | 49.9 | 49.98 | 49.86 | 49.885 | 3302330.0 |
| 2010-10-12 12:30:00 | QQQ | ETF | 49.88 | 49.91 | 49.86 | 49.88 | 1130222.0 |
| 2010-10-12 13:00:00 | QQQ | ETF | 49.88 | 49.93 | 49.85 | 49.91 | 1052517.0 |
> showing 50 of 8,598 rows — these rows as CSV