PREVIEW / etf_30min / 2011-11-30
file: by_date/etf_30min/2011/2011-11-30.parquet size: 302 KB rows: 10,160
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-30 04:00:00 | SPY | ETF | 119.62 | 119.77 | 119.62 | 119.77 | 900.0 |
| 2011-11-30 04:30:00 | SPY | ETF | 119.65 | 119.69 | 119.41 | 119.69 | 5600.0 |
| 2011-11-30 05:00:00 | SPY | ETF | 119.59 | 119.97 | 119.59 | 119.76 | 3182.0 |
| 2011-11-30 05:30:00 | SPY | ETF | 119.76 | 119.86 | 119.76 | 119.86 | 6700.0 |
| 2011-11-30 06:00:00 | SPY | ETF | 119.69 | 121.17 | 119.69 | 120.92 | 160481.0 |
| 2011-11-30 06:30:00 | SPY | ETF | 120.93 | 121.4 | 120.9 | 121.11 | 132380.0 |
| 2011-11-30 07:00:00 | SPY | ETF | 121.11 | 121.23 | 120.78 | 120.95 | 552109.0 |
| 2011-11-30 07:30:00 | SPY | ETF | 120.91 | 121.15 | 120.86 | 121.1 | 781303.0 |
| 2011-11-30 08:00:00 | SPY | ETF | 120.85 | 123.49 | 119.5 | 123.46 | 14884822.0 |
| 2011-11-30 08:30:00 | SPY | ETF | 123.47 | 124.0 | 120.8 | 123.79 | 6817759.0 |
| 2011-11-30 09:00:00 | SPY | ETF | 123.8 | 123.92 | 123.35 | 123.49 | 4119862.0 |
| 2011-11-30 09:30:00 | SPY | ETF | 123.49 | 124.09 | 123.22 | 123.98 | 40306618.0 |
| 2011-11-30 10:00:00 | SPY | ETF | 123.98 | 124.17 | 123.73 | 124.011 | 21847899.0 |
| 2011-11-30 10:30:00 | SPY | ETF | 124.01 | 124.5 | 123.94 | 124.48 | 19157003.0 |
| 2011-11-30 11:00:00 | SPY | ETF | 124.47 | 124.48 | 124.1 | 124.16 | 13724520.0 |
| 2011-11-30 11:30:00 | SPY | ETF | 124.16 | 124.38 | 124.01 | 124.14 | 12706367.0 |
| 2011-11-30 12:00:00 | SPY | ETF | 124.14 | 124.2 | 124.0 | 124.119 | 8493246.0 |
| 2011-11-30 12:30:00 | SPY | ETF | 124.121 | 124.24 | 124.0 | 124.14 | 8958369.0 |
| 2011-11-30 13:00:00 | SPY | ETF | 124.14 | 124.26 | 123.92 | 123.949 | 10033783.0 |
| 2011-11-30 13:30:00 | SPY | ETF | 123.94 | 124.1 | 123.82 | 123.86 | 13878751.0 |
| 2011-11-30 14:00:00 | SPY | ETF | 123.86 | 124.09 | 123.8 | 123.99 | 14854154.0 |
| 2011-11-30 14:30:00 | SPY | ETF | 123.9984 | 124.18 | 123.82 | 124.06 | 15253044.0 |
| 2011-11-30 15:00:00 | SPY | ETF | 124.06 | 124.42 | 123.98 | 124.345 | 19338364.0 |
| 2011-11-30 15:30:00 | SPY | ETF | 124.34 | 125.22 | 124.29 | 125.0897 | 47659285.0 |
| 2011-11-30 16:00:00 | SPY | ETF | 125.09 | 125.1705 | 124.0831 | 124.95 | 13173149.0 |
| 2011-11-30 16:30:00 | SPY | ETF | 124.95 | 125.1705 | 124.5748 | 125.0 | 4525429.0 |
| 2011-11-30 17:00:00 | SPY | ETF | 125.0 | 125.12 | 124.98 | 125.09 | 20013548.0 |
| 2011-11-30 17:30:00 | SPY | ETF | 125.07 | 125.12 | 125.0 | 125.04 | 1209208.0 |
| 2011-11-30 18:00:00 | SPY | ETF | 125.03 | 125.03 | 124.88 | 124.89 | 245192.0 |
| 2011-11-30 18:30:00 | SPY | ETF | 124.89 | 125.11 | 124.86 | 124.89 | 924858.0 |
| 2011-11-30 19:00:00 | SPY | ETF | 124.89 | 124.93 | 124.78 | 124.84 | 506961.0 |
| 2011-11-30 19:30:00 | SPY | ETF | 124.83 | 124.85 | 124.74 | 124.84 | 406850.0 |
| 2011-11-30 04:30:00 | QQQ | ETF | 54.21 | 54.21 | 54.21 | 54.21 | 107.0 |
| 2011-11-30 05:00:00 | QQQ | ETF | 54.36 | 54.41 | 54.33 | 54.41 | 7700.0 |
| 2011-11-30 05:30:00 | QQQ | ETF | 54.36 | 54.36 | 54.31 | 54.31 | 6680.0 |
| 2011-11-30 06:00:00 | QQQ | ETF | 54.6 | 54.9 | 54.6 | 54.82 | 105890.0 |
| 2011-11-30 06:30:00 | QQQ | ETF | 54.84 | 54.94 | 54.84 | 54.9 | 2300.0 |
| 2011-11-30 07:00:00 | QQQ | ETF | 54.86 | 54.88 | 54.71 | 54.77 | 213441.0 |
| 2011-11-30 07:30:00 | QQQ | ETF | 54.76 | 54.79 | 54.71 | 54.76 | 300577.0 |
| 2011-11-30 08:00:00 | QQQ | ETF | 54.73 | 55.84 | 54.72 | 55.69 | 3887785.0 |
| 2011-11-30 08:30:00 | QQQ | ETF | 55.68 | 55.92 | 55.68 | 55.91 | 937727.0 |
| 2011-11-30 09:00:00 | QQQ | ETF | 55.92 | 55.99 | 55.76 | 55.84 | 1048449.0 |
| 2011-11-30 09:30:00 | QQQ | ETF | 55.84 | 55.98 | 55.67 | 55.93 | 8925361.0 |
| 2011-11-30 10:00:00 | QQQ | ETF | 55.93 | 56.12 | 55.87 | 56.11 | 5810892.0 |
| 2011-11-30 10:30:00 | QQQ | ETF | 56.1 | 56.32 | 56.08 | 56.31 | 6340445.0 |
| 2011-11-30 11:00:00 | QQQ | ETF | 56.31 | 56.315 | 56.18 | 56.22 | 3425495.0 |
| 2011-11-30 11:30:00 | QQQ | ETF | 56.21 | 56.27 | 56.12 | 56.1714 | 2188976.0 |
| 2011-11-30 12:00:00 | QQQ | ETF | 56.18 | 56.23 | 56.13 | 56.2 | 2327603.0 |
| 2011-11-30 12:30:00 | QQQ | ETF | 56.2 | 56.23 | 56.12 | 56.17 | 1218709.0 |
| 2011-11-30 13:00:00 | QQQ | ETF | 56.17 | 56.22 | 56.01 | 56.03 | 2290509.0 |
> showing 50 of 10,160 rows — these rows as CSV