PREVIEW / etf_30min / 2010-12-28
file: by_date/etf_30min/2010/2010-12-28.parquet size: 259 KB rows: 8,739
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-28 04:00:00 | SPY | ETF | 125.9 | 125.9 | 125.84 | 125.85 | 7650.0 |
| 2010-12-28 04:30:00 | SPY | ETF | 125.88 | 125.88 | 125.87 | 125.87 | 500.0 |
| 2010-12-28 06:00:00 | SPY | ETF | 125.98 | 125.98 | 125.98 | 125.98 | 100.0 |
| 2010-12-28 06:30:00 | SPY | ETF | 125.98 | 125.98 | 125.98 | 125.98 | 2600.0 |
| 2010-12-28 07:00:00 | SPY | ETF | 125.95 | 126.01 | 125.93 | 126.01 | 50536.0 |
| 2010-12-28 07:30:00 | SPY | ETF | 125.98 | 125.98 | 125.86 | 125.86 | 40500.0 |
| 2010-12-28 08:00:00 | SPY | ETF | 125.86 | 125.91 | 125.81 | 125.9 | 110675.0 |
| 2010-12-28 08:30:00 | SPY | ETF | 125.88 | 125.96 | 125.88 | 125.88 | 458258.0 |
| 2010-12-28 09:00:00 | SPY | ETF | 125.87 | 125.93 | 125.85 | 125.9 | 229872.0 |
| 2010-12-28 09:30:00 | SPY | ETF | 125.9 | 125.95 | 125.6 | 125.72 | 7424356.0 |
| 2010-12-28 10:00:00 | SPY | ETF | 125.72 | 125.75 | 125.5 | 125.6162 | 6050415.0 |
| 2010-12-28 10:30:00 | SPY | ETF | 125.6198 | 125.67 | 125.55 | 125.55 | 2971932.0 |
| 2010-12-28 11:00:00 | SPY | ETF | 125.55 | 125.65 | 125.54 | 125.61 | 3044337.0 |
| 2010-12-28 11:30:00 | SPY | ETF | 125.62 | 125.64 | 125.55 | 125.57 | 2072830.0 |
| 2010-12-28 12:00:00 | SPY | ETF | 125.57 | 125.65 | 125.53 | 125.62 | 3218280.0 |
| 2010-12-28 12:30:00 | SPY | ETF | 125.62 | 125.66 | 125.59 | 125.6599 | 3720670.0 |
| 2010-12-28 13:00:00 | SPY | ETF | 125.659 | 125.73 | 125.65 | 125.71 | 2736669.0 |
| 2010-12-28 13:30:00 | SPY | ETF | 125.7038 | 125.75 | 125.69 | 125.75 | 1899636.0 |
| 2010-12-28 14:00:00 | SPY | ETF | 125.7489 | 125.82 | 125.71 | 125.79 | 2767853.0 |
| 2010-12-28 14:30:00 | SPY | ETF | 125.79 | 125.89 | 125.76 | 125.8666 | 2488127.0 |
| 2010-12-28 15:00:00 | SPY | ETF | 125.87 | 125.91 | 125.82 | 125.885 | 3599723.0 |
| 2010-12-28 15:30:00 | SPY | ETF | 125.88 | 125.91 | 125.78 | 125.8 | 8743669.0 |
| 2010-12-28 16:00:00 | SPY | ETF | 125.8 | 125.84 | 125.615 | 125.78 | 2954572.0 |
| 2010-12-28 16:30:00 | SPY | ETF | 125.77 | 125.77 | 125.69 | 125.71 | 597141.0 |
| 2010-12-28 17:00:00 | SPY | ETF | 125.72 | 125.75 | 125.68 | 125.68 | 25769.0 |
| 2010-12-28 17:30:00 | SPY | ETF | 125.7 | 125.74 | 125.7 | 125.73 | 2500.0 |
| 2010-12-28 18:00:00 | SPY | ETF | 125.74 | 125.8 | 125.71 | 125.75 | 12664.0 |
| 2010-12-28 18:30:00 | SPY | ETF | 125.77 | 125.78 | 125.73 | 125.74 | 6395.0 |
| 2010-12-28 19:00:00 | SPY | ETF | 125.74 | 125.76 | 125.73 | 125.74 | 6200.0 |
| 2010-12-28 19:30:00 | SPY | ETF | 125.73 | 125.81 | 125.73 | 125.8 | 25694.0 |
| 2010-12-28 04:00:00 | QQQ | ETF | 54.82 | 54.82 | 54.82 | 54.82 | 200.0 |
| 2010-12-28 04:30:00 | QQQ | ETF | 54.78 | 54.78 | 54.78 | 54.78 | 100.0 |
| 2010-12-28 05:00:00 | QQQ | ETF | 54.8 | 54.8 | 54.8 | 54.8 | 200.0 |
| 2010-12-28 06:30:00 | QQQ | ETF | 54.85 | 54.87 | 54.85 | 54.87 | 700.0 |
| 2010-12-28 07:00:00 | QQQ | ETF | 54.85 | 54.88 | 54.85 | 54.88 | 20200.0 |
| 2010-12-28 07:30:00 | QQQ | ETF | 54.87 | 54.87 | 54.81 | 54.82 | 165846.0 |
| 2010-12-28 08:00:00 | QQQ | ETF | 54.82 | 54.83 | 54.81 | 54.83 | 406645.0 |
| 2010-12-28 08:30:00 | QQQ | ETF | 54.83 | 54.84 | 54.82 | 54.83 | 119012.0 |
| 2010-12-28 09:00:00 | QQQ | ETF | 54.82 | 54.89 | 54.82 | 54.88 | 295721.0 |
| 2010-12-28 09:30:00 | QQQ | ETF | 54.88 | 54.92 | 54.66 | 54.71 | 5051295.0 |
| 2010-12-28 10:00:00 | QQQ | ETF | 54.71 | 54.76 | 54.61 | 54.7 | 2387406.0 |
| 2010-12-28 10:30:00 | QQQ | ETF | 54.705 | 54.71 | 54.62 | 54.63 | 1666899.0 |
| 2010-12-28 11:00:00 | QQQ | ETF | 54.63 | 54.68 | 54.62 | 54.65 | 817260.0 |
| 2010-12-28 11:30:00 | QQQ | ETF | 54.65 | 54.67 | 54.61 | 54.62 | 813225.0 |
| 2010-12-28 12:00:00 | QQQ | ETF | 54.615 | 54.615 | 54.55 | 54.609 | 1263032.0 |
| 2010-12-28 12:30:00 | QQQ | ETF | 54.609 | 54.64 | 54.6 | 54.63 | 599451.0 |
| 2010-12-28 13:00:00 | QQQ | ETF | 54.639 | 54.65 | 54.62 | 54.6262 | 730842.0 |
| 2010-12-28 13:30:00 | QQQ | ETF | 54.63 | 54.66 | 54.62 | 54.65 | 637179.0 |
| 2010-12-28 14:00:00 | QQQ | ETF | 54.651 | 54.67 | 54.625 | 54.67 | 819364.0 |
| 2010-12-28 14:30:00 | QQQ | ETF | 54.66 | 54.7 | 54.65 | 54.695 | 570446.0 |
> showing 50 of 8,739 rows — these rows as CSV