PREVIEW / etf_30min / 2010-12-03
file: by_date/etf_30min/2010/2010-12-03.parquet size: 274 KB rows: 9,084
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-03 04:00:00 | SPY | ETF | 122.61 | 122.7 | 122.6 | 122.62 | 500.0 |
| 2010-12-03 04:30:00 | SPY | ETF | 122.77 | 122.81 | 122.77 | 122.81 | 200.0 |
| 2010-12-03 05:00:00 | SPY | ETF | 122.85 | 122.85 | 122.81 | 122.84 | 4900.0 |
| 2010-12-03 06:00:00 | SPY | ETF | 122.71 | 122.77 | 122.64 | 122.77 | 3110.0 |
| 2010-12-03 06:30:00 | SPY | ETF | 122.71 | 122.8 | 122.71 | 122.8 | 6400.0 |
| 2010-12-03 07:00:00 | SPY | ETF | 122.84 | 122.85 | 122.67 | 122.7 | 114670.0 |
| 2010-12-03 07:30:00 | SPY | ETF | 122.72 | 122.9 | 122.7 | 122.9 | 301971.0 |
| 2010-12-03 08:00:00 | SPY | ETF | 122.9 | 123.21 | 122.7 | 123.1 | 2133590.0 |
| 2010-12-03 08:30:00 | SPY | ETF | 123.1 | 123.1 | 121.79 | 121.91 | 14347350.0 |
| 2010-12-03 09:00:00 | SPY | ETF | 121.91 | 122.25 | 121.91 | 122.14 | 4645535.0 |
| 2010-12-03 09:30:00 | SPY | ETF | 122.14 | 122.53 | 122.11 | 122.35 | 24678284.0 |
| 2010-12-03 10:00:00 | SPY | ETF | 122.35 | 122.63 | 122.13 | 122.26 | 17447426.0 |
| 2010-12-03 10:30:00 | SPY | ETF | 122.258 | 122.46 | 122.23 | 122.46 | 8483780.0 |
| 2010-12-03 11:00:00 | SPY | ETF | 122.46 | 122.52 | 122.27 | 122.29 | 6240862.0 |
| 2010-12-03 11:30:00 | SPY | ETF | 122.2725 | 122.31 | 122.11 | 122.1899 | 6254470.0 |
| 2010-12-03 12:00:00 | SPY | ETF | 122.18 | 122.31 | 122.17 | 122.23 | 4001874.0 |
| 2010-12-03 12:30:00 | SPY | ETF | 122.23 | 122.37 | 122.2 | 122.34 | 2743940.0 |
| 2010-12-03 13:00:00 | SPY | ETF | 122.33 | 122.47 | 122.33 | 122.3899 | 2980668.0 |
| 2010-12-03 13:30:00 | SPY | ETF | 122.39 | 122.46 | 122.28 | 122.44 | 3176113.0 |
| 2010-12-03 14:00:00 | SPY | ETF | 122.435 | 122.53 | 122.3 | 122.4 | 4757234.0 |
| 2010-12-03 14:30:00 | SPY | ETF | 122.39 | 122.59 | 122.38 | 122.59 | 4367065.0 |
| 2010-12-03 15:00:00 | SPY | ETF | 122.59 | 122.65 | 122.47 | 122.64 | 6492690.0 |
| 2010-12-03 15:30:00 | SPY | ETF | 122.65 | 123.03 | 122.57 | 122.86 | 27598182.0 |
| 2010-12-03 16:00:00 | SPY | ETF | 122.86 | 123.025 | 122.315 | 122.97 | 8482704.0 |
| 2010-12-03 16:30:00 | SPY | ETF | 122.97 | 123.05 | 122.4688 | 123.03 | 1104400.0 |
| 2010-12-03 17:00:00 | SPY | ETF | 123.03 | 123.03 | 122.95 | 123.02 | 313462.0 |
| 2010-12-03 17:30:00 | SPY | ETF | 123.0 | 123.05 | 122.98 | 123.0 | 6100.0 |
| 2010-12-03 18:00:00 | SPY | ETF | 123.02 | 123.04 | 122.99 | 123.0 | 37958.0 |
| 2010-12-03 18:30:00 | SPY | ETF | 123.0 | 123.03 | 122.97 | 122.97 | 13800.0 |
| 2010-12-03 19:00:00 | SPY | ETF | 122.99 | 123.04 | 122.99 | 123.03 | 4600.0 |
| 2010-12-03 19:30:00 | SPY | ETF | 123.03 | 123.06 | 123.0 | 123.01 | 14171.0 |
| 2010-12-03 04:00:00 | QQQ | ETF | 53.74 | 53.74 | 53.74 | 53.74 | 100.0 |
| 2010-12-03 06:00:00 | QQQ | ETF | 53.85 | 53.85 | 53.85 | 53.85 | 5500.0 |
| 2010-12-03 07:00:00 | QQQ | ETF | 53.85 | 53.85 | 53.79 | 53.82 | 15313.0 |
| 2010-12-03 07:30:00 | QQQ | ETF | 53.82 | 53.88 | 53.82 | 53.87 | 24589.0 |
| 2010-12-03 08:00:00 | QQQ | ETF | 53.86 | 53.97 | 53.86 | 53.9 | 166683.0 |
| 2010-12-03 08:30:00 | QQQ | ETF | 53.86 | 53.86 | 53.32 | 53.38 | 3512769.0 |
| 2010-12-03 09:00:00 | QQQ | ETF | 53.39 | 53.53 | 53.39 | 53.5 | 663060.0 |
| 2010-12-03 09:30:00 | QQQ | ETF | 53.5 | 53.81 | 53.5 | 53.73 | 7548138.0 |
| 2010-12-03 10:00:00 | QQQ | ETF | 53.73 | 53.87 | 53.63 | 53.71 | 5200582.0 |
| 2010-12-03 10:30:00 | QQQ | ETF | 53.71 | 53.8 | 53.7 | 53.8 | 3142999.0 |
| 2010-12-03 11:00:00 | QQQ | ETF | 53.8 | 53.82 | 53.69 | 53.7 | 1692943.0 |
| 2010-12-03 11:30:00 | QQQ | ETF | 53.6996 | 53.707 | 53.63 | 53.651 | 1161602.0 |
| 2010-12-03 12:00:00 | QQQ | ETF | 53.66 | 53.72 | 53.65 | 53.68 | 789818.0 |
| 2010-12-03 12:30:00 | QQQ | ETF | 53.6838 | 53.74 | 53.6701 | 53.73 | 510132.0 |
| 2010-12-03 13:00:00 | QQQ | ETF | 53.73 | 53.76 | 53.7099 | 53.71 | 1107115.0 |
| 2010-12-03 13:30:00 | QQQ | ETF | 53.71 | 53.78 | 53.68 | 53.77 | 713108.0 |
| 2010-12-03 14:00:00 | QQQ | ETF | 53.77 | 53.8 | 53.6901 | 53.72 | 852006.0 |
| 2010-12-03 14:30:00 | QQQ | ETF | 53.7162 | 53.8 | 53.715 | 53.79 | 765936.0 |
| 2010-12-03 15:00:00 | QQQ | ETF | 53.79 | 53.83 | 53.724 | 53.82 | 1556643.0 |
> showing 50 of 9,084 rows — these rows as CSV