PREVIEW / etf_1hour / 2011-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-22.parquet
  size:    184 KB
  rows:    5,700

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
2011-12-22 04:00:00	SPY	ETF	124.4	124.75	124.33	124.75	146640.0
2011-12-22 05:00:00	SPY	ETF	124.8	124.88	124.5	124.74	84862.0
2011-12-22 06:00:00	SPY	ETF	124.65	124.76	124.56	124.69	35110.0
2011-12-22 07:00:00	SPY	ETF	124.65	124.83	124.59	124.72	381554.0
2011-12-22 08:00:00	SPY	ETF	124.74	125.0	124.39	124.57	2151306.0
2011-12-22 09:00:00	SPY	ETF	124.57	125.069	124.36	124.96	15366577.0
2011-12-22 10:00:00	SPY	ETF	124.96	125.12	124.59	124.81	17892215.0
2011-12-22 11:00:00	SPY	ETF	124.8	124.979	124.66	124.88	17564557.0
2011-12-22 12:00:00	SPY	ETF	124.88	125.3	124.855	125.21	10316877.0
2011-12-22 13:00:00	SPY	ETF	125.22	125.39	125.13	125.2	9352910.0
2011-12-22 14:00:00	SPY	ETF	125.2	125.36	125.08	125.11	10013338.0
2011-12-22 15:00:00	SPY	ETF	125.1	125.39	125.08	125.31	26842079.0
2011-12-22 16:00:00	SPY	ETF	125.33	125.58	125.0208	125.56	8345472.0
2011-12-22 17:00:00	SPY	ETF	125.55	125.66	125.43	125.62	315120.0
2011-12-22 18:00:00	SPY	ETF	125.6	125.78	125.53	125.75	233397.0
2011-12-22 19:00:00	SPY	ETF	125.75	125.77	125.66	125.7	179165.0
2011-12-22 04:00:00	QQQ	ETF	55.28	55.28	55.28	55.28	190.0
2011-12-22 05:00:00	QQQ	ETF	55.27	55.27	55.23	55.23	450.0
2011-12-22 06:00:00	QQQ	ETF	55.31	55.32	55.27	55.27	8000.0
2011-12-22 07:00:00	QQQ	ETF	55.27	55.32	55.26	55.3	35558.0
2011-12-22 08:00:00	QQQ	ETF	55.31	55.38	55.14	55.21	281084.0
2011-12-22 09:00:00	QQQ	ETF	55.24	55.53	55.17	55.441	4594212.0
2011-12-22 10:00:00	QQQ	ETF	55.444	55.52	55.2601	55.378	4711262.0
2011-12-22 11:00:00	QQQ	ETF	55.37	55.52	55.35	55.489	5525965.0
2011-12-22 12:00:00	QQQ	ETF	55.48	55.6261	55.46	55.58	2922415.0
2011-12-22 13:00:00	QQQ	ETF	55.5799	55.6	55.53	55.54	1842433.0
2011-12-22 14:00:00	QQQ	ETF	55.54	55.59	55.4907	55.5375	3402480.0
2011-12-22 15:00:00	QQQ	ETF	55.53	55.62	55.51	55.59	7083762.0
2011-12-22 16:00:00	QQQ	ETF	55.6	55.64	55.53	55.64	3260938.0
2011-12-22 17:00:00	QQQ	ETF	55.63	55.67	55.62	55.67	26530.0
2011-12-22 18:00:00	QQQ	ETF	55.65	55.72	55.64	55.72	15302.0
2011-12-22 19:00:00	QQQ	ETF	55.72	55.73	55.7	55.71	20082.0
2011-12-22 04:00:00	IWM	ETF	74.08	74.48	74.08	74.41	3387.0
2011-12-22 05:00:00	IWM	ETF	74.42	74.42	74.06	74.06	300.0
2011-12-22 06:00:00	IWM	ETF	74.15	74.15	74.1	74.1	600.0
2011-12-22 07:00:00	IWM	ETF	74.1	74.23	74.08	74.17	97914.0
2011-12-22 08:00:00	IWM	ETF	74.19	74.39	73.89	74.05	407757.0
2011-12-22 09:00:00	IWM	ETF	74.08	74.64	74.01	74.55	6752832.0
2011-12-22 10:00:00	IWM	ETF	74.55	74.65	73.98	74.27	5207349.0
2011-12-22 11:00:00	IWM	ETF	74.27	74.41	73.98	74.22	4302861.0
2011-12-22 12:00:00	IWM	ETF	74.23	74.58	74.19	74.48	3309134.0
2011-12-22 13:00:00	IWM	ETF	74.49	74.67	74.37	74.46	2749994.0
2011-12-22 14:00:00	IWM	ETF	74.46	74.56	74.24	74.3	3381357.0
2011-12-22 15:00:00	IWM	ETF	74.29	74.5	74.14	74.31	6232296.0
2011-12-22 16:00:00	IWM	ETF	74.32	74.42	74.25	74.39	1993673.0
2011-12-22 17:00:00	IWM	ETF	74.36	74.41	74.36	74.41	2800.0
2011-12-22 18:00:00	IWM	ETF	74.43	74.46	74.43	74.46	1500.0
2011-12-22 19:00:00	IWM	ETF	74.5	74.54	74.5	74.52	3000.0
2011-12-22 07:00:00	DIA	ETF	121.47	121.47	121.21	121.21	1300.0
2011-12-22 08:00:00	DIA	ETF	121.15	121.39	120.94	120.95	13045.0

> showing 50 of 5,700 rows — these rows as CSV

> unlock the full archive -- $79 one-time