PREVIEW / etf_30min / 2010-12-30
file: by_date/etf_30min/2010/2010-12-30.parquet size: 255 KB rows: 8,706
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-30 04:00:00 | SPY | ETF | 126.01 | 126.01 | 126.01 | 126.01 | 600.0 |
| 2010-12-30 04:30:00 | SPY | ETF | 125.98 | 125.98 | 125.98 | 125.98 | 300.0 |
| 2010-12-30 05:30:00 | SPY | ETF | 126.0 | 126.0 | 125.98 | 125.98 | 600.0 |
| 2010-12-30 06:00:00 | SPY | ETF | 125.9 | 125.9 | 125.83 | 125.83 | 1000.0 |
| 2010-12-30 06:30:00 | SPY | ETF | 125.8 | 125.8 | 125.77 | 125.79 | 5200.0 |
| 2010-12-30 07:00:00 | SPY | ETF | 125.85 | 125.86 | 125.72 | 125.74 | 49037.0 |
| 2010-12-30 07:30:00 | SPY | ETF | 125.74 | 125.84 | 125.72 | 125.8 | 60271.0 |
| 2010-12-30 08:00:00 | SPY | ETF | 125.79 | 125.81 | 125.73 | 125.79 | 282438.0 |
| 2010-12-30 08:30:00 | SPY | ETF | 125.81 | 125.89 | 125.79 | 125.83 | 505816.0 |
| 2010-12-30 09:00:00 | SPY | ETF | 125.84 | 125.87 | 125.77 | 125.79 | 231685.0 |
| 2010-12-30 09:30:00 | SPY | ETF | 125.8 | 126.13 | 125.75 | 125.87 | 9315578.0 |
| 2010-12-30 10:00:00 | SPY | ETF | 125.87 | 125.93 | 125.6 | 125.7399 | 8555136.0 |
| 2010-12-30 10:30:00 | SPY | ETF | 125.73 | 125.83 | 125.71 | 125.76 | 3769694.0 |
| 2010-12-30 11:00:00 | SPY | ETF | 125.77 | 125.82 | 125.65 | 125.68 | 3282060.0 |
| 2010-12-30 11:30:00 | SPY | ETF | 125.68 | 125.8 | 125.53 | 125.59 | 4198763.0 |
| 2010-12-30 12:00:00 | SPY | ETF | 125.585 | 125.69 | 125.58 | 125.67 | 2507273.0 |
| 2010-12-30 12:30:00 | SPY | ETF | 125.67 | 125.69 | 125.64 | 125.65 | 1645738.0 |
| 2010-12-30 13:00:00 | SPY | ETF | 125.66 | 125.69 | 125.6 | 125.64 | 2351921.0 |
| 2010-12-30 13:30:00 | SPY | ETF | 125.645 | 125.73 | 125.64 | 125.72 | 1803197.0 |
| 2010-12-30 14:00:00 | SPY | ETF | 125.7225 | 125.81 | 125.69 | 125.7804 | 5549166.0 |
| 2010-12-30 14:30:00 | SPY | ETF | 125.79 | 125.83 | 125.75 | 125.785 | 3182216.0 |
| 2010-12-30 15:00:00 | SPY | ETF | 125.78 | 125.93 | 125.76 | 125.9283 | 4901498.0 |
| 2010-12-30 15:30:00 | SPY | ETF | 125.93 | 125.95 | 125.71 | 125.76 | 12077349.0 |
| 2010-12-30 16:00:00 | SPY | ETF | 125.76 | 125.93 | 125.705 | 125.79 | 9023317.0 |
| 2010-12-30 16:30:00 | SPY | ETF | 125.79 | 125.85 | 125.72 | 125.81 | 990079.0 |
| 2010-12-30 17:00:00 | SPY | ETF | 125.83 | 125.86 | 125.81 | 125.85 | 17047.0 |
| 2010-12-30 17:30:00 | SPY | ETF | 125.85 | 125.85 | 125.8 | 125.8 | 14435.0 |
| 2010-12-30 18:00:00 | SPY | ETF | 125.83 | 125.83 | 125.81 | 125.81 | 2700.0 |
| 2010-12-30 18:30:00 | SPY | ETF | 125.82 | 125.82 | 125.82 | 125.82 | 1350.0 |
| 2010-12-30 19:00:00 | SPY | ETF | 125.83 | 125.84 | 125.81 | 125.83 | 7550.0 |
| 2010-12-30 19:30:00 | SPY | ETF | 125.83 | 125.89 | 125.8 | 125.89 | 12733.0 |
| 2010-12-30 04:00:00 | QQQ | ETF | 54.8 | 54.8 | 54.8 | 54.8 | 200.0 |
| 2010-12-30 04:30:00 | QQQ | ETF | 54.72 | 54.72 | 54.72 | 54.72 | 200.0 |
| 2010-12-30 05:30:00 | QQQ | ETF | 54.76 | 54.76 | 54.76 | 54.76 | 100.0 |
| 2010-12-30 06:30:00 | QQQ | ETF | 54.72 | 54.72 | 54.72 | 54.72 | 100.0 |
| 2010-12-30 07:00:00 | QQQ | ETF | 54.74 | 54.74 | 54.69 | 54.71 | 2193.0 |
| 2010-12-30 07:30:00 | QQQ | ETF | 54.7 | 54.72 | 54.7 | 54.72 | 587.0 |
| 2010-12-30 08:00:00 | QQQ | ETF | 54.7 | 54.72 | 54.67 | 54.7 | 32132.0 |
| 2010-12-30 08:30:00 | QQQ | ETF | 54.71 | 54.8 | 54.71 | 54.75 | 104541.0 |
| 2010-12-30 09:00:00 | QQQ | ETF | 54.76 | 54.79 | 54.74 | 54.79 | 124270.0 |
| 2010-12-30 09:30:00 | QQQ | ETF | 54.79 | 54.8 | 54.67 | 54.7 | 4047045.0 |
| 2010-12-30 10:00:00 | QQQ | ETF | 54.7 | 54.71 | 54.57 | 54.63 | 4156594.0 |
| 2010-12-30 10:30:00 | QQQ | ETF | 54.62 | 54.655 | 54.62 | 54.63 | 975020.0 |
| 2010-12-30 11:00:00 | QQQ | ETF | 54.63 | 54.65 | 54.58 | 54.59 | 1471929.0 |
| 2010-12-30 11:30:00 | QQQ | ETF | 54.59 | 54.61 | 54.55 | 54.58 | 1655568.0 |
| 2010-12-30 12:00:00 | QQQ | ETF | 54.581 | 54.65 | 54.56 | 54.649 | 1439189.0 |
| 2010-12-30 12:30:00 | QQQ | ETF | 54.64 | 54.649 | 54.6 | 54.61 | 1180736.0 |
| 2010-12-30 13:00:00 | QQQ | ETF | 54.615 | 54.64 | 54.59 | 54.62 | 956293.0 |
| 2010-12-30 13:30:00 | QQQ | ETF | 54.63 | 54.65 | 54.62 | 54.648 | 1201720.0 |
| 2010-12-30 14:00:00 | QQQ | ETF | 54.65 | 54.67 | 54.63 | 54.66 | 1025168.0 |
> showing 50 of 8,706 rows — these rows as CSV