PREVIEW / etf_1hour / 2011-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-13.parquet
  size:    180 KB
  rows:    5,527

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-10-13 04:00:00	SPY	ETF	120.45	120.75	119.93	120.04	97195.0
2011-10-13 05:00:00	SPY	ETF	120.15	120.18	119.75	119.77	93225.0
2011-10-13 06:00:00	SPY	ETF	119.92	120.25	119.68	120.11	312005.0
2011-10-13 07:00:00	SPY	ETF	120.18	120.18	119.64	119.76	1357860.0
2011-10-13 08:00:00	SPY	ETF	119.76	120.03	119.56	119.95	3762122.0
2011-10-13 09:00:00	SPY	ETF	119.95	120.1	119.42	119.53	30059824.0
2011-10-13 10:00:00	SPY	ETF	119.561	119.96	119.18	119.18	40907830.0
2011-10-13 11:00:00	SPY	ETF	119.18	119.87	119.12	119.659	30248303.0
2011-10-13 12:00:00	SPY	ETF	119.66	119.83	119.32	119.67	12822195.0
2011-10-13 13:00:00	SPY	ETF	119.66	120.36	119.45	120.14	26135921.0
2011-10-13 14:00:00	SPY	ETF	120.14	120.66	119.91	120.5	19833111.0
2011-10-13 15:00:00	SPY	ETF	120.5	120.87	120.01	120.48	40072002.0
2011-10-13 16:00:00	SPY	ETF	120.48	120.75	119.8802	120.39	4874160.0
2011-10-13 17:00:00	SPY	ETF	120.38	120.54	120.38	120.5	179006.0
2011-10-13 18:00:00	SPY	ETF	120.48	120.54	120.11	120.15	356716.0
2011-10-13 19:00:00	SPY	ETF	120.15	120.31	120.12	120.22	224835.0
2011-10-13 05:00:00	QQQ	ETF	56.38	56.38	56.26	56.3	2460.0
2011-10-13 06:00:00	QQQ	ETF	56.38	56.51	56.3	56.51	70000.0
2011-10-13 07:00:00	QQQ	ETF	56.42	56.49	56.3	56.36	310422.0
2011-10-13 08:00:00	QQQ	ETF	56.35	56.49	56.29	56.46	1245141.0
2011-10-13 09:00:00	QQQ	ETF	56.47	56.68	56.42	56.54	8776008.0
2011-10-13 10:00:00	QQQ	ETF	56.54	56.79	56.47	56.49	11194785.0
2011-10-13 11:00:00	QQQ	ETF	56.5	56.89	56.47	56.8095	8094293.0
2011-10-13 12:00:00	QQQ	ETF	56.8	56.86	56.63	56.73	3890148.0
2011-10-13 13:00:00	QQQ	ETF	56.73	56.97	56.6	56.84	5930083.0
2011-10-13 14:00:00	QQQ	ETF	56.8363	57.08	56.75	57.04	4853047.0
2011-10-13 15:00:00	QQQ	ETF	57.03	57.19	56.86	57.1	10516636.0
2011-10-13 16:00:00	QQQ	ETF	57.11	57.43	57.09	57.24	2847730.0
2011-10-13 17:00:00	QQQ	ETF	57.24	57.36	57.24	57.3	81470.0
2011-10-13 18:00:00	QQQ	ETF	57.29	57.37	56.6063	57.2	1078119.0
2011-10-13 19:00:00	QQQ	ETF	57.19	57.24	57.17	57.18	44500.0
2011-10-13 05:00:00	IWM	ETF	69.29	69.29	69.29	69.29	100.0
2011-10-13 06:00:00	IWM	ETF	69.33	69.52	69.22	69.52	8200.0
2011-10-13 07:00:00	IWM	ETF	69.45	69.51	69.25	69.37	34422.0
2011-10-13 08:00:00	IWM	ETF	69.39	69.45	69.12	69.42	672862.0
2011-10-13 09:00:00	IWM	ETF	69.43	69.65	68.9	69.02	9219011.0
2011-10-13 10:00:00	IWM	ETF	69.02	69.36	68.71	68.72	9141015.0
2011-10-13 11:00:00	IWM	ETF	68.72	69.17	68.58	69.0699	5978316.0
2011-10-13 12:00:00	IWM	ETF	69.07	69.23	68.6795	68.9	3248526.0
2011-10-13 13:00:00	IWM	ETF	68.9185	69.6	68.75	69.38	5774680.0
2011-10-13 14:00:00	IWM	ETF	69.39	69.81	69.21	69.71	5053202.0
2011-10-13 15:00:00	IWM	ETF	69.71	70.12	69.43	69.75	11962091.0
2011-10-13 16:00:00	IWM	ETF	69.74	70.04	68.95	69.6	1747535.0
2011-10-13 17:00:00	IWM	ETF	69.62	69.71	69.62	69.67	23451.0
2011-10-13 18:00:00	IWM	ETF	69.75	69.75	69.57	69.57	9200.0
2011-10-13 19:00:00	IWM	ETF	69.58	69.58	69.54	69.54	1400.0
2011-10-13 04:00:00	DIA	ETF	114.59	114.59	114.52	114.52	200.0
2011-10-13 05:00:00	DIA	ETF	114.26	114.26	114.26	114.26	100.0
2011-10-13 06:00:00	DIA	ETF	114.3	114.36	114.3	114.36	1100.0
2011-10-13 07:00:00	DIA	ETF	114.54	114.57	114.3	114.36	3500.0

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

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