PREVIEW / etf_30min / 2010-11-30
file: by_date/etf_30min/2010/2010-11-30.parquet size: 271 KB rows: 9,022
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-30 04:00:00 | SPY | ETF | 118.78 | 118.78 | 118.6 | 118.6 | 36200.0 |
| 2010-11-30 04:30:00 | SPY | ETF | 118.74 | 118.88 | 118.65 | 118.88 | 13539.0 |
| 2010-11-30 05:00:00 | SPY | ETF | 118.8 | 118.98 | 118.79 | 118.98 | 850.0 |
| 2010-11-30 05:30:00 | SPY | ETF | 119.11 | 119.24 | 119.05 | 119.15 | 14940.0 |
| 2010-11-30 06:00:00 | SPY | ETF | 119.07 | 119.07 | 118.77 | 118.87 | 33200.0 |
| 2010-11-30 06:30:00 | SPY | ETF | 118.89 | 119.11 | 118.87 | 118.92 | 238100.0 |
| 2010-11-30 07:00:00 | SPY | ETF | 118.92 | 118.98 | 118.42 | 118.47 | 1737262.0 |
| 2010-11-30 07:30:00 | SPY | ETF | 118.46 | 118.67 | 118.35 | 118.35 | 681259.0 |
| 2010-11-30 08:00:00 | SPY | ETF | 118.37 | 118.9 | 118.03 | 118.17 | 3802798.0 |
| 2010-11-30 08:30:00 | SPY | ETF | 118.16 | 118.17 | 117.86 | 118.06 | 2709574.0 |
| 2010-11-30 09:00:00 | SPY | ETF | 118.04 | 119.16 | 117.96 | 117.97 | 1832496.0 |
| 2010-11-30 09:30:00 | SPY | ETF | 117.98 | 118.43 | 117.81 | 118.42 | 29260251.0 |
| 2010-11-30 10:00:00 | SPY | ETF | 118.42 | 118.88 | 118.23 | 118.7931 | 21764657.0 |
| 2010-11-30 10:30:00 | SPY | ETF | 118.7996 | 118.8 | 118.27 | 118.485 | 12025884.0 |
| 2010-11-30 11:00:00 | SPY | ETF | 118.49 | 118.66 | 118.29 | 118.45 | 12222687.0 |
| 2010-11-30 11:30:00 | SPY | ETF | 118.45 | 118.74 | 118.32 | 118.65 | 8915583.0 |
| 2010-11-30 12:00:00 | SPY | ETF | 118.65 | 118.72 | 118.49 | 118.6101 | 8983369.0 |
| 2010-11-30 12:30:00 | SPY | ETF | 118.62 | 118.77 | 118.465 | 118.74 | 11179747.0 |
| 2010-11-30 13:00:00 | SPY | ETF | 118.74 | 119.17 | 118.68 | 119.07 | 14686002.0 |
| 2010-11-30 13:30:00 | SPY | ETF | 119.07 | 119.14 | 118.84 | 118.945 | 11809077.0 |
| 2010-11-30 14:00:00 | SPY | ETF | 118.95 | 119.135 | 118.58 | 118.66 | 12529817.0 |
| 2010-11-30 14:30:00 | SPY | ETF | 118.66 | 118.97 | 118.53 | 118.86 | 16536509.0 |
| 2010-11-30 15:00:00 | SPY | ETF | 118.865 | 119.03 | 118.72 | 118.955 | 12334173.0 |
| 2010-11-30 15:30:00 | SPY | ETF | 118.95 | 119.01 | 118.41 | 118.45 | 28771718.0 |
| 2010-11-30 16:00:00 | SPY | ETF | 118.44 | 119.193 | 118.05 | 118.24 | 13457829.0 |
| 2010-11-30 16:30:00 | SPY | ETF | 118.25 | 118.6004 | 118.22 | 118.31 | 2804291.0 |
| 2010-11-30 17:00:00 | SPY | ETF | 118.3 | 118.36 | 118.26 | 118.36 | 266201.0 |
| 2010-11-30 17:30:00 | SPY | ETF | 118.36 | 118.36 | 118.3 | 118.35 | 22824.0 |
| 2010-11-30 18:00:00 | SPY | ETF | 118.34 | 118.48 | 118.26 | 118.29 | 147953.0 |
| 2010-11-30 18:30:00 | SPY | ETF | 118.31 | 118.31 | 118.16 | 118.18 | 83240.0 |
| 2010-11-30 19:00:00 | SPY | ETF | 118.2 | 118.31 | 118.2 | 118.31 | 70783.0 |
| 2010-11-30 19:30:00 | SPY | ETF | 118.25 | 118.26 | 118.22 | 118.25 | 34420.0 |
| 2010-11-30 04:00:00 | QQQ | ETF | 52.57 | 52.57 | 52.57 | 52.57 | 500.0 |
| 2010-11-30 04:30:00 | QQQ | ETF | 52.54 | 52.63 | 52.54 | 52.63 | 400.0 |
| 2010-11-30 05:00:00 | QQQ | ETF | 52.62 | 52.68 | 52.6 | 52.68 | 11225.0 |
| 2010-11-30 05:30:00 | QQQ | ETF | 52.68 | 52.78 | 52.68 | 52.78 | 7500.0 |
| 2010-11-30 06:00:00 | QQQ | ETF | 52.75 | 52.75 | 52.64 | 52.64 | 5100.0 |
| 2010-11-30 06:30:00 | QQQ | ETF | 52.71 | 52.72 | 52.61 | 52.61 | 253011.0 |
| 2010-11-30 07:00:00 | QQQ | ETF | 52.61 | 52.63 | 52.34 | 52.38 | 1241160.0 |
| 2010-11-30 07:30:00 | QQQ | ETF | 52.41 | 52.45 | 52.32 | 52.32 | 145422.0 |
| 2010-11-30 08:00:00 | QQQ | ETF | 52.33 | 52.5 | 52.21 | 52.25 | 1114736.0 |
| 2010-11-30 08:30:00 | QQQ | ETF | 52.22 | 52.26 | 52.12 | 52.21 | 533604.0 |
| 2010-11-30 09:00:00 | QQQ | ETF | 52.21 | 52.25 | 52.17 | 52.19 | 423010.0 |
| 2010-11-30 09:30:00 | QQQ | ETF | 52.18 | 52.22 | 51.88 | 52.2 | 11803790.0 |
| 2010-11-30 10:00:00 | QQQ | ETF | 52.2 | 52.42 | 52.07 | 52.37 | 8445495.0 |
| 2010-11-30 10:30:00 | QQQ | ETF | 52.38 | 52.38 | 52.155 | 52.2109 | 3620811.0 |
| 2010-11-30 11:00:00 | QQQ | ETF | 52.21 | 52.26 | 52.06 | 52.13 | 4864814.0 |
| 2010-11-30 11:30:00 | QQQ | ETF | 52.13 | 52.19 | 52.03 | 52.14 | 4147993.0 |
| 2010-11-30 12:00:00 | QQQ | ETF | 52.14 | 52.175 | 52.05 | 52.11 | 2924984.0 |
| 2010-11-30 12:30:00 | QQQ | ETF | 52.11 | 52.15 | 52.0273 | 52.11 | 3879923.0 |
> showing 50 of 9,022 rows — these rows as CSV