PREVIEW / etf_30min / 2011-12-13
file: by_date/etf_30min/2011/2011-12-13.parquet size: 284 KB rows: 9,543
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-12-13 04:00:00 | SPY | ETF | 124.21 | 124.21 | 124.0 | 124.2 | 57745.0 |
| 2011-12-13 04:30:00 | SPY | ETF | 124.43 | 124.7 | 124.43 | 124.7 | 900.0 |
| 2011-12-13 05:00:00 | SPY | ETF | 124.74 | 124.75 | 124.62 | 124.73 | 4074.0 |
| 2011-12-13 05:30:00 | SPY | ETF | 124.77 | 124.8 | 124.75 | 124.75 | 550.0 |
| 2011-12-13 06:00:00 | SPY | ETF | 124.74 | 124.97 | 124.74 | 124.87 | 3175.0 |
| 2011-12-13 06:30:00 | SPY | ETF | 124.88 | 125.05 | 124.77 | 124.92 | 53050.0 |
| 2011-12-13 07:00:00 | SPY | ETF | 124.87 | 124.9 | 124.56 | 124.8 | 242331.0 |
| 2011-12-13 07:30:00 | SPY | ETF | 124.78 | 125.02 | 124.78 | 124.98 | 155355.0 |
| 2011-12-13 08:00:00 | SPY | ETF | 124.98 | 125.01 | 124.76 | 124.9 | 2373616.0 |
| 2011-12-13 08:30:00 | SPY | ETF | 124.87 | 125.0 | 124.56 | 124.86 | 1428425.0 |
| 2011-12-13 09:00:00 | SPY | ETF | 124.87 | 124.99 | 124.75 | 124.86 | 2168845.0 |
| 2011-12-13 09:30:00 | SPY | ETF | 124.86 | 125.52 | 124.84 | 125.34 | 20550993.0 |
| 2011-12-13 10:00:00 | SPY | ETF | 125.33 | 125.57 | 125.0 | 125.0 | 16201985.0 |
| 2011-12-13 10:30:00 | SPY | ETF | 125.02 | 125.2 | 124.495 | 124.65 | 18964866.0 |
| 2011-12-13 11:00:00 | SPY | ETF | 124.65 | 125.35 | 124.24 | 124.6275 | 16274992.0 |
| 2011-12-13 11:30:00 | SPY | ETF | 124.63 | 125.42 | 124.54 | 124.85 | 9412255.0 |
| 2011-12-13 12:00:00 | SPY | ETF | 124.85 | 125.51 | 124.62 | 124.66 | 4960015.0 |
| 2011-12-13 12:30:00 | SPY | ETF | 124.6665 | 125.49 | 124.47 | 124.8 | 7786020.0 |
| 2011-12-13 13:00:00 | SPY | ETF | 124.79 | 125.48 | 124.56 | 124.7 | 6564836.0 |
| 2011-12-13 13:30:00 | SPY | ETF | 124.7 | 125.5689 | 124.54 | 124.78 | 4872084.0 |
| 2011-12-13 14:00:00 | SPY | ETF | 124.7846 | 125.49 | 124.16 | 124.55 | 18182301.0 |
| 2011-12-13 14:30:00 | SPY | ETF | 124.56 | 125.5 | 123.59 | 123.87 | 22436191.0 |
| 2011-12-13 15:00:00 | SPY | ETF | 123.87 | 125.41 | 123.0 | 123.11 | 24159552.0 |
| 2011-12-13 15:30:00 | SPY | ETF | 123.11 | 125.435 | 122.45 | 123.09 | 49872038.0 |
| 2011-12-13 16:00:00 | SPY | ETF | 123.09 | 124.1986 | 122.926 | 123.14 | 7822807.0 |
| 2011-12-13 16:30:00 | SPY | ETF | 123.16 | 124.6127 | 123.1299 | 123.25 | 7942417.0 |
| 2011-12-13 17:00:00 | SPY | ETF | 123.25 | 123.27 | 123.19 | 123.2 | 306442.0 |
| 2011-12-13 17:30:00 | SPY | ETF | 123.23 | 123.26 | 123.2 | 123.24 | 27247.0 |
| 2011-12-13 18:00:00 | SPY | ETF | 123.24 | 123.37 | 123.11 | 123.36 | 391925.0 |
| 2011-12-13 18:30:00 | SPY | ETF | 123.37 | 123.37 | 123.2 | 123.23 | 202726.0 |
| 2011-12-13 19:00:00 | SPY | ETF | 123.23 | 123.36 | 123.22 | 123.34 | 92960.0 |
| 2011-12-13 19:30:00 | SPY | ETF | 123.36 | 123.44 | 123.35 | 123.35 | 173966.0 |
| 2011-12-13 04:00:00 | QQQ | ETF | 56.38 | 56.45 | 56.38 | 56.45 | 1400.0 |
| 2011-12-13 05:00:00 | QQQ | ETF | 56.62 | 56.64 | 56.61 | 56.64 | 1549.0 |
| 2011-12-13 05:30:00 | QQQ | ETF | 56.65 | 56.65 | 56.65 | 56.65 | 1200.0 |
| 2011-12-13 06:00:00 | QQQ | ETF | 56.69 | 56.76 | 56.69 | 56.72 | 6650.0 |
| 2011-12-13 06:30:00 | QQQ | ETF | 56.71 | 56.76 | 56.68 | 56.68 | 14100.0 |
| 2011-12-13 07:00:00 | QQQ | ETF | 56.69 | 56.75 | 56.66 | 56.74 | 38375.0 |
| 2011-12-13 07:30:00 | QQQ | ETF | 56.74 | 56.82 | 56.74 | 56.78 | 63380.0 |
| 2011-12-13 08:00:00 | QQQ | ETF | 56.7 | 56.84 | 56.7 | 56.75 | 2173117.0 |
| 2011-12-13 08:30:00 | QQQ | ETF | 56.72 | 56.82 | 56.67 | 56.77 | 208443.0 |
| 2011-12-13 09:00:00 | QQQ | ETF | 56.77 | 56.85 | 56.72 | 56.75 | 1734670.0 |
| 2011-12-13 09:30:00 | QQQ | ETF | 56.76 | 56.98 | 56.74 | 56.78 | 5901584.0 |
| 2011-12-13 10:00:00 | QQQ | ETF | 56.79 | 56.91 | 56.65 | 56.66 | 3365838.0 |
| 2011-12-13 10:30:00 | QQQ | ETF | 56.665 | 56.74 | 56.36 | 56.37 | 4977010.0 |
| 2011-12-13 11:00:00 | QQQ | ETF | 56.37 | 56.38 | 56.17 | 56.28 | 4521819.0 |
| 2011-12-13 11:30:00 | QQQ | ETF | 56.28 | 56.47 | 56.24 | 56.45 | 3221084.0 |
| 2011-12-13 12:00:00 | QQQ | ETF | 56.46 | 56.48 | 56.38 | 56.42 | 1205363.0 |
| 2011-12-13 12:30:00 | QQQ | ETF | 56.42 | 56.47 | 56.301 | 56.45 | 2261372.0 |
| 2011-12-13 13:00:00 | QQQ | ETF | 56.44 | 56.48 | 56.36 | 56.4 | 2203292.0 |
> showing 50 of 9,543 rows — these rows as CSV