PREVIEW / etf_30min / 2010-12-08
file: by_date/etf_30min/2010/2010-12-08.parquet size: 273 KB rows: 9,039
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-08 04:00:00 | SPY | ETF | 122.43 | 122.43 | 122.4 | 122.4 | 200.0 |
| 2010-12-08 04:30:00 | SPY | ETF | 122.65 | 122.78 | 122.65 | 122.75 | 1276.0 |
| 2010-12-08 05:30:00 | SPY | ETF | 122.65 | 122.7 | 122.65 | 122.67 | 2850.0 |
| 2010-12-08 06:00:00 | SPY | ETF | 122.67 | 122.73 | 122.66 | 122.66 | 5860.0 |
| 2010-12-08 06:30:00 | SPY | ETF | 122.66 | 122.69 | 122.61 | 122.61 | 800.0 |
| 2010-12-08 07:00:00 | SPY | ETF | 122.59 | 122.86 | 122.56 | 122.86 | 60175.0 |
| 2010-12-08 07:30:00 | SPY | ETF | 122.86 | 122.86 | 122.65 | 122.68 | 105460.0 |
| 2010-12-08 08:00:00 | SPY | ETF | 122.74 | 123.02 | 122.7 | 122.98 | 703751.0 |
| 2010-12-08 08:30:00 | SPY | ETF | 122.98 | 123.15 | 122.92 | 123.06 | 550007.0 |
| 2010-12-08 09:00:00 | SPY | ETF | 123.05 | 123.1 | 122.89 | 122.99 | 1080114.0 |
| 2010-12-08 09:30:00 | SPY | ETF | 122.98 | 123.38 | 122.94 | 123.12 | 14449372.0 |
| 2010-12-08 10:00:00 | SPY | ETF | 123.11 | 123.13 | 122.64 | 122.81 | 15548792.0 |
| 2010-12-08 10:30:00 | SPY | ETF | 122.81 | 122.853 | 122.41 | 122.73 | 18141250.0 |
| 2010-12-08 11:00:00 | SPY | ETF | 122.73 | 122.91 | 122.655 | 122.86 | 7154953.0 |
| 2010-12-08 11:30:00 | SPY | ETF | 122.86 | 123.11 | 122.74 | 123.06 | 6433302.0 |
| 2010-12-08 12:00:00 | SPY | ETF | 123.07 | 123.12 | 123.02 | 123.03 | 4595432.0 |
| 2010-12-08 12:30:00 | SPY | ETF | 123.04 | 123.04 | 122.78 | 122.88 | 5520761.0 |
| 2010-12-08 13:00:00 | SPY | ETF | 122.88 | 123.16 | 122.85 | 122.97 | 7272617.0 |
| 2010-12-08 13:30:00 | SPY | ETF | 122.98 | 123.24 | 122.94 | 123.1 | 5180466.0 |
| 2010-12-08 14:00:00 | SPY | ETF | 123.11 | 123.22 | 123.0 | 123.14 | 5170766.0 |
| 2010-12-08 14:30:00 | SPY | ETF | 123.149 | 123.37 | 123.14 | 123.2 | 7277446.0 |
| 2010-12-08 15:00:00 | SPY | ETF | 123.2 | 123.28 | 122.99 | 123.05 | 10103924.0 |
| 2010-12-08 15:30:00 | SPY | ETF | 123.045 | 123.38 | 122.98 | 123.25 | 16680280.0 |
| 2010-12-08 16:00:00 | SPY | ETF | 123.27 | 123.43 | 122.685 | 123.34 | 6746156.0 |
| 2010-12-08 16:30:00 | SPY | ETF | 123.35 | 123.49 | 123.34 | 123.49 | 545678.0 |
| 2010-12-08 17:00:00 | SPY | ETF | 123.5 | 123.55 | 123.48 | 123.55 | 135563.0 |
| 2010-12-08 17:30:00 | SPY | ETF | 123.55 | 123.55 | 123.47 | 123.48 | 54984.0 |
| 2010-12-08 18:00:00 | SPY | ETF | 123.48 | 123.51 | 123.29 | 123.51 | 79170.0 |
| 2010-12-08 18:30:00 | SPY | ETF | 123.51 | 123.74 | 123.51 | 123.7 | 113914.0 |
| 2010-12-08 19:00:00 | SPY | ETF | 123.7 | 123.74 | 123.65 | 123.71 | 33230.0 |
| 2010-12-08 19:30:00 | SPY | ETF | 123.71 | 123.77 | 123.7 | 123.77 | 42315.0 |
| 2010-12-08 06:00:00 | QQQ | ETF | 53.86 | 53.89 | 53.86 | 53.89 | 1100.0 |
| 2010-12-08 06:30:00 | QQQ | ETF | 53.85 | 53.88 | 53.85 | 53.88 | 3539.0 |
| 2010-12-08 07:00:00 | QQQ | ETF | 53.86 | 53.94 | 53.86 | 53.94 | 4300.0 |
| 2010-12-08 07:30:00 | QQQ | ETF | 53.91 | 53.92 | 53.89 | 53.9 | 25824.0 |
| 2010-12-08 08:00:00 | QQQ | ETF | 53.89 | 54.02 | 53.89 | 54.0 | 96782.0 |
| 2010-12-08 08:30:00 | QQQ | ETF | 54.0 | 54.07 | 53.97 | 54.02 | 76450.0 |
| 2010-12-08 09:00:00 | QQQ | ETF | 54.02 | 54.05 | 53.96 | 54.03 | 262245.0 |
| 2010-12-08 09:30:00 | QQQ | ETF | 54.03 | 54.15 | 53.97 | 54.011 | 6457799.0 |
| 2010-12-08 10:00:00 | QQQ | ETF | 54.01 | 54.015 | 53.82 | 53.91 | 6559853.0 |
| 2010-12-08 10:30:00 | QQQ | ETF | 53.91 | 53.9101 | 53.6899 | 53.83 | 7414189.0 |
| 2010-12-08 11:00:00 | QQQ | ETF | 53.838 | 53.95 | 53.81 | 53.92 | 2537232.0 |
| 2010-12-08 11:30:00 | QQQ | ETF | 53.91 | 54.02 | 53.87 | 53.9877 | 1678113.0 |
| 2010-12-08 12:00:00 | QQQ | ETF | 53.99 | 54.01 | 53.95 | 53.95 | 720006.0 |
| 2010-12-08 12:30:00 | QQQ | ETF | 53.95 | 53.959 | 53.85 | 53.88 | 1663426.0 |
| 2010-12-08 13:00:00 | QQQ | ETF | 53.889 | 53.9899 | 53.87 | 53.9 | 1925088.0 |
| 2010-12-08 13:30:00 | QQQ | ETF | 53.9075 | 54.03 | 53.88 | 53.9801 | 1954711.0 |
| 2010-12-08 14:00:00 | QQQ | ETF | 53.98 | 54.07 | 53.94 | 54.03 | 1497884.0 |
| 2010-12-08 14:30:00 | QQQ | ETF | 54.03 | 54.12 | 54.02 | 54.06 | 2066405.0 |
| 2010-12-08 15:00:00 | QQQ | ETF | 54.05 | 54.1 | 53.97 | 53.9801 | 2186723.0 |
> showing 50 of 9,039 rows — these rows as CSV