PREVIEW / etf_1hour / 2011-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-21.parquet
  size:    189 KB
  rows:    5,847

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-11-21 04:00:00	SPY	ETF	120.78	120.78	119.92	120.08	153971.0
2011-11-21 05:00:00	SPY	ETF	120.08	120.17	119.93	120.17	7635.0
2011-11-21 06:00:00	SPY	ETF	120.05	120.2	119.79	119.97	108566.0
2011-11-21 07:00:00	SPY	ETF	119.98	120.21	119.79	120.18	819560.0
2011-11-21 08:00:00	SPY	ETF	120.07	120.85	119.92	120.38	2122249.0
2011-11-21 09:00:00	SPY	ETF	120.38	120.51	119.47	119.65	33298165.0
2011-11-21 10:00:00	SPY	ETF	119.64	119.78	118.9	118.95	37219297.0
2011-11-21 11:00:00	SPY	ETF	118.96	119.29	118.65	119.14	36029606.0
2011-11-21 12:00:00	SPY	ETF	119.15	119.26	118.85	119.04	18232213.0
2011-11-21 13:00:00	SPY	ETF	119.03	119.48	118.88	118.93	15915975.0
2011-11-21 14:00:00	SPY	ETF	118.93	119.94	118.85	119.51	28390864.0
2011-11-21 15:00:00	SPY	ETF	119.51	120.26	119.27	119.66	40509790.0
2011-11-21 16:00:00	SPY	ETF	119.65	121.9337	119.1	119.37	11740633.0
2011-11-21 17:00:00	SPY	ETF	119.37	119.42	119.1	119.35	3340088.0
2011-11-21 18:00:00	SPY	ETF	119.39	119.62	119.3	119.57	731108.0
2011-11-21 19:00:00	SPY	ETF	119.57	119.95	119.57	119.95	407535.0
2011-11-21 04:00:00	QQQ	ETF	54.85	54.85	54.64	54.68	4707.0
2011-11-21 05:00:00	QQQ	ETF	54.66	54.75	54.65	54.72	20950.0
2011-11-21 06:00:00	QQQ	ETF	54.68	54.83	54.68	54.71	17600.0
2011-11-21 07:00:00	QQQ	ETF	54.71	54.81	54.66	54.74	71473.0
2011-11-21 08:00:00	QQQ	ETF	54.72	54.97	54.5	54.81	385972.0
2011-11-21 09:00:00	QQQ	ETF	54.81	54.84	54.15	54.208	7817866.0
2011-11-21 10:00:00	QQQ	ETF	54.23	54.26	53.89	53.91	8156403.0
2011-11-21 11:00:00	QQQ	ETF	53.91	54.09	53.78	53.99	7528148.0
2011-11-21 12:00:00	QQQ	ETF	53.99	54.12	53.91	54.04	4503844.0
2011-11-21 13:00:00	QQQ	ETF	54.04	54.27	53.96	53.98	4001198.0
2011-11-21 14:00:00	QQQ	ETF	53.98	54.45	53.94	54.28	5790955.0
2011-11-21 15:00:00	QQQ	ETF	54.27	54.66	54.17	54.34	9011207.0
2011-11-21 16:00:00	QQQ	ETF	54.34	55.4151	54.0175	54.36	3653848.0
2011-11-21 17:00:00	QQQ	ETF	54.36	54.4	54.24	54.35	72302.0
2011-11-21 18:00:00	QQQ	ETF	54.37	55.4151	54.35	54.42	574594.0
2011-11-21 19:00:00	QQQ	ETF	54.44	54.58	54.44	54.58	44725.0
2011-11-21 04:00:00	IWM	ETF	70.95	70.95	70.48	70.48	2720.0
2011-11-21 06:00:00	IWM	ETF	70.6	70.6	70.42	70.46	3759.0
2011-11-21 07:00:00	IWM	ETF	70.44	70.7	70.35	70.56	206167.0
2011-11-21 08:00:00	IWM	ETF	70.59	70.9	70.36	70.81	542488.0
2011-11-21 09:00:00	IWM	ETF	70.8	70.88	70.31	70.46	8116016.0
2011-11-21 10:00:00	IWM	ETF	70.4552	70.6	69.8	69.84	8809316.0
2011-11-21 11:00:00	IWM	ETF	69.83	70.11	69.61	70.05	8250487.0
2011-11-21 12:00:00	IWM	ETF	70.06	70.15	69.82	69.962	3657460.0
2011-11-21 13:00:00	IWM	ETF	69.96	70.26	69.78	69.81	3172976.0
2011-11-21 14:00:00	IWM	ETF	69.795	70.435	69.74	70.19	5782058.0
2011-11-21 15:00:00	IWM	ETF	70.18	70.67	70.02	70.23	12516528.0
2011-11-21 16:00:00	IWM	ETF	70.23	71.9444	70.03	70.07	2409865.0
2011-11-21 17:00:00	IWM	ETF	70.08	70.12	69.95	70.03	12048.0
2011-11-21 18:00:00	IWM	ETF	70.04	70.19	70.0	70.12	15136.0
2011-11-21 19:00:00	IWM	ETF	70.19	70.4	70.0	70.0	4258.0
2011-11-21 04:00:00	DIA	ETF	116.9	116.9	116.4	116.4	325.0
2011-11-21 07:00:00	DIA	ETF	116.2	116.2	116.0	116.15	2100.0
2011-11-21 08:00:00	DIA	ETF	116.1	116.52	116.05	116.4	9602.0

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

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