PREVIEW / etf_30min / 2010-12-06
file: by_date/etf_30min/2010/2010-12-06.parquet size: 273 KB rows: 9,151
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-12-06 04:00:00 | SPY | ETF | 122.45 | 122.47 | 122.33 | 122.47 | 4950.0 |
| 2010-12-06 04:30:00 | SPY | ETF | 122.47 | 122.47 | 122.39 | 122.46 | 14800.0 |
| 2010-12-06 05:00:00 | SPY | ETF | 122.49 | 122.53 | 122.46 | 122.48 | 12300.0 |
| 2010-12-06 05:30:00 | SPY | ETF | 122.53 | 122.54 | 122.19 | 122.19 | 3800.0 |
| 2010-12-06 06:00:00 | SPY | ETF | 122.19 | 122.33 | 122.19 | 122.33 | 900.0 |
| 2010-12-06 06:30:00 | SPY | ETF | 122.27 | 122.46 | 122.27 | 122.38 | 58190.0 |
| 2010-12-06 07:00:00 | SPY | ETF | 122.38 | 122.6 | 122.38 | 122.55 | 48725.0 |
| 2010-12-06 07:30:00 | SPY | ETF | 122.58 | 122.59 | 122.43 | 122.51 | 151550.0 |
| 2010-12-06 08:00:00 | SPY | ETF | 122.55 | 122.57 | 122.4 | 122.42 | 720517.0 |
| 2010-12-06 08:30:00 | SPY | ETF | 122.41 | 122.54 | 122.25 | 122.49 | 1108286.0 |
| 2010-12-06 09:00:00 | SPY | ETF | 122.49 | 122.86 | 122.44 | 122.63 | 637078.0 |
| 2010-12-06 09:30:00 | SPY | ETF | 122.63 | 122.78 | 122.5 | 122.595 | 13242031.0 |
| 2010-12-06 10:00:00 | SPY | ETF | 122.6 | 122.87 | 122.585 | 122.87 | 8292366.0 |
| 2010-12-06 10:30:00 | SPY | ETF | 122.87 | 122.9 | 122.59 | 122.68 | 8353069.0 |
| 2010-12-06 11:00:00 | SPY | ETF | 122.685 | 122.83 | 122.54 | 122.64 | 6245681.0 |
| 2010-12-06 11:30:00 | SPY | ETF | 122.65 | 122.7 | 122.51 | 122.64 | 7905502.0 |
| 2010-12-06 12:00:00 | SPY | ETF | 122.65 | 122.73 | 122.53 | 122.6 | 6111769.0 |
| 2010-12-06 12:30:00 | SPY | ETF | 122.591 | 122.73 | 122.591 | 122.72 | 4074754.0 |
| 2010-12-06 13:00:00 | SPY | ETF | 122.72 | 122.79 | 122.67 | 122.785 | 3290203.0 |
| 2010-12-06 13:30:00 | SPY | ETF | 122.79 | 122.89 | 122.76 | 122.84 | 4538867.0 |
| 2010-12-06 14:00:00 | SPY | ETF | 122.84 | 122.88 | 122.77 | 122.78 | 4328812.0 |
| 2010-12-06 14:30:00 | SPY | ETF | 122.78 | 122.96 | 122.77 | 122.9 | 4438960.0 |
| 2010-12-06 15:00:00 | SPY | ETF | 122.9 | 122.99 | 122.88 | 122.8829 | 5009829.0 |
| 2010-12-06 15:30:00 | SPY | ETF | 122.88 | 123.04 | 122.73 | 122.73 | 15377365.0 |
| 2010-12-06 16:00:00 | SPY | ETF | 122.74 | 122.89 | 122.515 | 122.79 | 5461741.0 |
| 2010-12-06 16:30:00 | SPY | ETF | 122.79 | 122.79 | 122.62 | 122.62 | 681558.0 |
| 2010-12-06 17:00:00 | SPY | ETF | 122.64 | 122.64 | 122.5 | 122.52 | 269322.0 |
| 2010-12-06 17:30:00 | SPY | ETF | 122.55 | 122.61 | 122.4 | 122.61 | 486151.0 |
| 2010-12-06 18:00:00 | SPY | ETF | 122.61 | 122.77 | 122.48 | 122.53 | 411063.0 |
| 2010-12-06 18:30:00 | SPY | ETF | 122.53 | 122.8 | 122.53 | 122.72 | 207068.0 |
| 2010-12-06 19:00:00 | SPY | ETF | 122.75 | 122.89 | 122.72 | 122.86 | 124806.0 |
| 2010-12-06 19:30:00 | SPY | ETF | 122.86 | 122.9 | 122.82 | 122.87 | 91019.0 |
| 2010-12-06 04:00:00 | QQQ | ETF | 53.7 | 53.7 | 53.6 | 53.65 | 500.0 |
| 2010-12-06 04:30:00 | QQQ | ETF | 53.65 | 53.65 | 53.65 | 53.65 | 5000.0 |
| 2010-12-06 05:00:00 | QQQ | ETF | 53.68 | 53.68 | 53.68 | 53.68 | 200.0 |
| 2010-12-06 05:30:00 | QQQ | ETF | 53.66 | 53.66 | 53.55 | 53.55 | 800.0 |
| 2010-12-06 06:00:00 | QQQ | ETF | 53.56 | 53.6 | 53.55 | 53.6 | 5300.0 |
| 2010-12-06 06:30:00 | QQQ | ETF | 53.65 | 53.68 | 53.65 | 53.66 | 5400.0 |
| 2010-12-06 07:00:00 | QQQ | ETF | 53.72 | 53.75 | 53.7 | 53.74 | 29013.0 |
| 2010-12-06 07:30:00 | QQQ | ETF | 53.75 | 53.75 | 53.68 | 53.71 | 8086.0 |
| 2010-12-06 08:00:00 | QQQ | ETF | 53.72 | 53.75 | 53.69 | 53.74 | 83305.0 |
| 2010-12-06 08:30:00 | QQQ | ETF | 53.72 | 53.78 | 53.66 | 53.76 | 84105.0 |
| 2010-12-06 09:00:00 | QQQ | ETF | 53.76 | 53.9 | 53.74 | 53.87 | 265907.0 |
| 2010-12-06 09:30:00 | QQQ | ETF | 53.87 | 53.94 | 53.72 | 53.79 | 7116106.0 |
| 2010-12-06 10:00:00 | QQQ | ETF | 53.8 | 53.94 | 53.8 | 53.92 | 3161470.0 |
| 2010-12-06 10:30:00 | QQQ | ETF | 53.92 | 53.94 | 53.77 | 53.8001 | 3089484.0 |
| 2010-12-06 11:00:00 | QQQ | ETF | 53.81 | 53.87 | 53.719 | 53.76 | 2171497.0 |
| 2010-12-06 11:30:00 | QQQ | ETF | 53.76 | 53.79 | 53.68 | 53.755 | 3392359.0 |
| 2010-12-06 12:00:00 | QQQ | ETF | 53.7575 | 53.79 | 53.705 | 53.7481 | 2361407.0 |
| 2010-12-06 12:30:00 | QQQ | ETF | 53.74 | 53.79 | 53.72 | 53.769 | 800556.0 |
> showing 50 of 9,151 rows — these rows as CSV