PREVIEW / etf_30min / 2010-12-20
file: by_date/etf_30min/2010/2010-12-20.parquet size: 267 KB rows: 8,922
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-20 04:00:00 | SPY | ETF | 124.19 | 124.22 | 124.19 | 124.22 | 5700.0 |
| 2010-12-20 04:30:00 | SPY | ETF | 124.26 | 124.26 | 124.18 | 124.19 | 3800.0 |
| 2010-12-20 05:00:00 | SPY | ETF | 124.19 | 124.23 | 124.18 | 124.23 | 8800.0 |
| 2010-12-20 05:30:00 | SPY | ETF | 124.28 | 124.28 | 124.28 | 124.28 | 100.0 |
| 2010-12-20 06:00:00 | SPY | ETF | 124.35 | 124.49 | 124.35 | 124.48 | 5274.0 |
| 2010-12-20 06:30:00 | SPY | ETF | 124.51 | 124.54 | 124.46 | 124.54 | 11976.0 |
| 2010-12-20 07:00:00 | SPY | ETF | 124.55 | 124.77 | 124.53 | 124.75 | 243897.0 |
| 2010-12-20 07:30:00 | SPY | ETF | 124.75 | 124.77 | 124.64 | 124.64 | 109211.0 |
| 2010-12-20 08:00:00 | SPY | ETF | 124.65 | 124.72 | 124.61 | 124.66 | 439789.0 |
| 2010-12-20 08:30:00 | SPY | ETF | 124.66 | 124.69 | 124.62 | 124.63 | 356432.0 |
| 2010-12-20 09:00:00 | SPY | ETF | 124.63 | 124.7 | 124.61 | 124.65 | 618457.0 |
| 2010-12-20 09:30:00 | SPY | ETF | 124.64 | 124.7 | 124.47 | 124.53 | 10783911.0 |
| 2010-12-20 10:00:00 | SPY | ETF | 124.54 | 124.54 | 124.1 | 124.21 | 10015762.0 |
| 2010-12-20 10:30:00 | SPY | ETF | 124.22 | 124.305 | 124.07 | 124.07 | 11061316.0 |
| 2010-12-20 11:00:00 | SPY | ETF | 124.07 | 124.2 | 123.98 | 124.1962 | 7750822.0 |
| 2010-12-20 11:30:00 | SPY | ETF | 124.2 | 124.36 | 124.17 | 124.33 | 5039682.0 |
| 2010-12-20 12:00:00 | SPY | ETF | 124.32 | 124.44 | 124.27 | 124.4 | 4387635.0 |
| 2010-12-20 12:30:00 | SPY | ETF | 124.39 | 124.6 | 124.34 | 124.6 | 8861053.0 |
| 2010-12-20 13:00:00 | SPY | ETF | 124.6 | 124.64 | 124.57 | 124.585 | 3986167.0 |
| 2010-12-20 13:30:00 | SPY | ETF | 124.585 | 124.63 | 124.57 | 124.595 | 2549401.0 |
| 2010-12-20 14:00:00 | SPY | ETF | 124.59 | 124.9 | 124.59 | 124.809 | 9896928.0 |
| 2010-12-20 14:30:00 | SPY | ETF | 124.81 | 124.835 | 124.725 | 124.73 | 4614844.0 |
| 2010-12-20 15:00:00 | SPY | ETF | 124.7338 | 124.76 | 124.58 | 124.6 | 6129721.0 |
| 2010-12-20 15:30:00 | SPY | ETF | 124.595 | 124.78 | 124.53 | 124.5701 | 12772106.0 |
| 2010-12-20 16:00:00 | SPY | ETF | 124.57 | 124.6226 | 124.015 | 124.44 | 8403142.0 |
| 2010-12-20 16:30:00 | SPY | ETF | 124.44 | 124.5695 | 124.43 | 124.5 | 679969.0 |
| 2010-12-20 17:00:00 | SPY | ETF | 124.5 | 124.53 | 124.48 | 124.52 | 86687.0 |
| 2010-12-20 17:30:00 | SPY | ETF | 124.52 | 124.6 | 124.5 | 124.58 | 271585.0 |
| 2010-12-20 18:00:00 | SPY | ETF | 124.56 | 124.6 | 124.53 | 124.54 | 89783.0 |
| 2010-12-20 18:30:00 | SPY | ETF | 124.53 | 124.55 | 124.47 | 124.48 | 15496.0 |
| 2010-12-20 19:00:00 | SPY | ETF | 124.48 | 124.49 | 124.47 | 124.47 | 2280.0 |
| 2010-12-20 19:30:00 | SPY | ETF | 124.48 | 124.49 | 124.45 | 124.46 | 30432.0 |
| 2010-12-20 04:00:00 | QQQ | ETF | 54.39 | 54.39 | 54.39 | 54.39 | 200.0 |
| 2010-12-20 06:00:00 | QQQ | ETF | 54.51 | 54.51 | 54.51 | 54.51 | 200.0 |
| 2010-12-20 06:30:00 | QQQ | ETF | 54.53 | 54.53 | 54.53 | 54.53 | 2000.0 |
| 2010-12-20 07:00:00 | QQQ | ETF | 54.58 | 54.65 | 54.56 | 54.63 | 63122.0 |
| 2010-12-20 07:30:00 | QQQ | ETF | 54.63 | 54.65 | 54.6 | 54.6 | 17900.0 |
| 2010-12-20 08:00:00 | QQQ | ETF | 54.6 | 54.63 | 54.58 | 54.61 | 82470.0 |
| 2010-12-20 08:30:00 | QQQ | ETF | 54.6 | 54.61 | 54.58 | 54.58 | 31375.0 |
| 2010-12-20 09:00:00 | QQQ | ETF | 54.58 | 54.62 | 54.52 | 54.6 | 256115.0 |
| 2010-12-20 09:30:00 | QQQ | ETF | 54.6 | 54.63 | 54.46 | 54.48 | 4984883.0 |
| 2010-12-20 10:00:00 | QQQ | ETF | 54.48 | 54.48 | 54.16 | 54.25 | 6847411.0 |
| 2010-12-20 10:30:00 | QQQ | ETF | 54.25 | 54.31 | 54.21 | 54.23 | 2316909.0 |
| 2010-12-20 11:00:00 | QQQ | ETF | 54.22 | 54.34 | 54.175 | 54.3319 | 2008609.0 |
| 2010-12-20 11:30:00 | QQQ | ETF | 54.33 | 54.44 | 54.31 | 54.415 | 3461651.0 |
| 2010-12-20 12:00:00 | QQQ | ETF | 54.41 | 54.42 | 54.32 | 54.361 | 2091197.0 |
| 2010-12-20 12:30:00 | QQQ | ETF | 54.37 | 54.54 | 54.34 | 54.54 | 1850377.0 |
| 2010-12-20 13:00:00 | QQQ | ETF | 54.54 | 54.62 | 54.53 | 54.57 | 1479867.0 |
| 2010-12-20 13:30:00 | QQQ | ETF | 54.57 | 54.61 | 54.551 | 54.565 | 730128.0 |
| 2010-12-20 14:00:00 | QQQ | ETF | 54.56 | 54.76 | 54.56 | 54.7 | 3157278.0 |
> showing 50 of 8,922 rows — these rows as CSV