PREVIEW / etf_30min / 2010-09-22
file: by_date/etf_30min/2010/2010-09-22.parquet size: 259 KB rows: 8,699
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-09-22 04:00:00 | SPY | ETF | 113.67 | 113.67 | 113.49 | 113.58 | 7300.0 |
| 2010-09-22 04:30:00 | SPY | ETF | 113.48 | 113.5 | 113.48 | 113.5 | 1200.0 |
| 2010-09-22 05:00:00 | SPY | ETF | 113.6 | 113.6 | 113.55 | 113.6 | 1000.0 |
| 2010-09-22 05:30:00 | SPY | ETF | 113.68 | 113.75 | 113.63 | 113.63 | 2200.0 |
| 2010-09-22 06:00:00 | SPY | ETF | 113.72 | 113.92 | 113.72 | 113.85 | 1600.0 |
| 2010-09-22 06:30:00 | SPY | ETF | 113.75 | 113.82 | 113.65 | 113.67 | 73900.0 |
| 2010-09-22 07:00:00 | SPY | ETF | 113.71 | 113.71 | 113.47 | 113.51 | 168675.0 |
| 2010-09-22 07:30:00 | SPY | ETF | 113.58 | 113.71 | 113.58 | 113.65 | 352495.0 |
| 2010-09-22 08:00:00 | SPY | ETF | 113.66 | 113.89 | 113.51 | 113.82 | 2052405.0 |
| 2010-09-22 08:30:00 | SPY | ETF | 113.79 | 113.82 | 113.6 | 113.66 | 2183077.0 |
| 2010-09-22 09:00:00 | SPY | ETF | 113.65 | 113.88 | 113.65 | 113.8 | 945189.0 |
| 2010-09-22 09:30:00 | SPY | ETF | 113.8 | 114.44 | 113.76 | 114.12 | 23793614.0 |
| 2010-09-22 10:00:00 | SPY | ETF | 114.12 | 114.135 | 113.69 | 113.71 | 19683041.0 |
| 2010-09-22 10:30:00 | SPY | ETF | 113.7 | 113.79 | 113.5 | 113.75 | 17158679.0 |
| 2010-09-22 11:00:00 | SPY | ETF | 113.75 | 113.82 | 113.12 | 113.3 | 16523598.0 |
| 2010-09-22 11:30:00 | SPY | ETF | 113.3 | 113.59 | 113.19 | 113.437 | 9594263.0 |
| 2010-09-22 12:00:00 | SPY | ETF | 113.4379 | 113.58 | 113.33 | 113.475 | 8488442.0 |
| 2010-09-22 12:30:00 | SPY | ETF | 113.48 | 113.51 | 113.3 | 113.32 | 4929779.0 |
| 2010-09-22 13:00:00 | SPY | ETF | 113.32 | 113.42 | 113.1 | 113.32 | 9330120.0 |
| 2010-09-22 13:30:00 | SPY | ETF | 113.32 | 113.56 | 113.3 | 113.44 | 5922830.0 |
| 2010-09-22 14:00:00 | SPY | ETF | 113.44 | 113.47 | 113.26 | 113.42 | 8209431.0 |
| 2010-09-22 14:30:00 | SPY | ETF | 113.42 | 113.73 | 113.39 | 113.67 | 14711429.0 |
| 2010-09-22 15:00:00 | SPY | ETF | 113.67 | 113.71 | 113.28 | 113.3617 | 13607230.0 |
| 2010-09-22 15:30:00 | SPY | ETF | 113.37 | 113.59 | 113.31 | 113.43 | 21888339.0 |
| 2010-09-22 16:00:00 | SPY | ETF | 113.44 | 114.115 | 113.1848 | 113.48 | 7335592.0 |
| 2010-09-22 16:30:00 | SPY | ETF | 113.48 | 113.61 | 113.48 | 113.61 | 208075.0 |
| 2010-09-22 17:00:00 | SPY | ETF | 113.6 | 113.64 | 113.54 | 113.63 | 47299.0 |
| 2010-09-22 17:30:00 | SPY | ETF | 113.61 | 113.65 | 113.61 | 113.63 | 10600.0 |
| 2010-09-22 18:00:00 | SPY | ETF | 113.63 | 113.71 | 113.43 | 113.67 | 112613.0 |
| 2010-09-22 18:30:00 | SPY | ETF | 113.66 | 113.69 | 113.63 | 113.63 | 18804.0 |
| 2010-09-22 19:00:00 | SPY | ETF | 113.63 | 113.65 | 113.61 | 113.61 | 13652.0 |
| 2010-09-22 19:30:00 | SPY | ETF | 113.6 | 113.64 | 113.57 | 113.62 | 22900.0 |
| 2010-09-22 04:00:00 | QQQ | ETF | 48.61 | 48.61 | 48.61 | 48.61 | 366.0 |
| 2010-09-22 05:30:00 | QQQ | ETF | 48.72 | 48.72 | 48.72 | 48.72 | 23400.0 |
| 2010-09-22 06:00:00 | QQQ | ETF | 48.72 | 48.77 | 48.72 | 48.77 | 1966.0 |
| 2010-09-22 06:30:00 | QQQ | ETF | 48.75 | 48.77 | 48.69 | 48.71 | 12613.0 |
| 2010-09-22 07:00:00 | QQQ | ETF | 48.64 | 48.66 | 48.56 | 48.59 | 276425.0 |
| 2010-09-22 07:30:00 | QQQ | ETF | 48.57 | 48.67 | 48.57 | 48.62 | 62540.0 |
| 2010-09-22 08:00:00 | QQQ | ETF | 48.62 | 48.7 | 48.58 | 48.64 | 790462.0 |
| 2010-09-22 08:30:00 | QQQ | ETF | 48.63 | 48.64 | 48.53 | 48.54 | 1723663.0 |
| 2010-09-22 09:00:00 | QQQ | ETF | 48.54 | 48.61 | 48.53 | 48.6 | 532906.0 |
| 2010-09-22 09:30:00 | QQQ | ETF | 48.61 | 49.021 | 48.58 | 48.84 | 17051104.0 |
| 2010-09-22 10:00:00 | QQQ | ETF | 48.84 | 48.84 | 48.569 | 48.6 | 7250573.0 |
| 2010-09-22 10:30:00 | QQQ | ETF | 48.6 | 48.691 | 48.54 | 48.68 | 4854043.0 |
| 2010-09-22 11:00:00 | QQQ | ETF | 48.68 | 48.71 | 48.44 | 48.5 | 4283723.0 |
| 2010-09-22 11:30:00 | QQQ | ETF | 48.5 | 48.62 | 48.46 | 48.59 | 1883465.0 |
| 2010-09-22 12:00:00 | QQQ | ETF | 48.59 | 48.65 | 48.54 | 48.6 | 3262913.0 |
| 2010-09-22 12:30:00 | QQQ | ETF | 48.6099 | 48.61 | 48.49 | 48.5 | 2720538.0 |
| 2010-09-22 13:00:00 | QQQ | ETF | 48.5 | 48.55 | 48.42 | 48.5 | 3338926.0 |
| 2010-09-22 13:30:00 | QQQ | ETF | 48.51 | 48.61 | 48.5 | 48.56 | 1839198.0 |
> showing 50 of 8,699 rows — these rows as CSV