PREVIEW / etf_1hour / 2012-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-22.parquet
  size:    178 KB
  rows:    5,510

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
2012-06-22 04:00:00	SPY	ETF	132.31	132.94	132.31	132.94	1400.0
2012-06-22 05:00:00	SPY	ETF	132.94	132.98	132.82	132.98	74159.0
2012-06-22 06:00:00	SPY	ETF	132.95	133.05	132.9	133.02	70800.0
2012-06-22 07:00:00	SPY	ETF	132.99	133.05	132.41	132.78	393236.0
2012-06-22 08:00:00	SPY	ETF	132.76	133.01	132.68	132.86	1152128.0
2012-06-22 09:00:00	SPY	ETF	132.86	133.22	132.79	133.02	20872119.0
2012-06-22 10:00:00	SPY	ETF	133.02	133.3	132.62	132.88	25197970.0
2012-06-22 11:00:00	SPY	ETF	132.88	133.119	132.8	133.03	14933140.0
2012-06-22 12:00:00	SPY	ETF	133.03	133.07	132.81	132.91	10267726.0
2012-06-22 13:00:00	SPY	ETF	132.91	133.15	132.81	133.12	8261563.0
2012-06-22 14:00:00	SPY	ETF	133.1199	133.52	133.09	133.51	11178887.0
2012-06-22 15:00:00	SPY	ETF	133.51	133.71	133.29	133.46	25269830.0
2012-06-22 16:00:00	SPY	ETF	133.46	133.65	132.8313	133.05	10880936.0
2012-06-22 17:00:00	SPY	ETF	133.05	133.09	133.01	133.05	267580.0
2012-06-22 18:00:00	SPY	ETF	133.05	133.11	133.03	133.07	126662.0
2012-06-22 19:00:00	SPY	ETF	133.07	133.17	133.06	133.12	54074.0
2012-06-22 06:00:00	QQQ	ETF	63.0	63.0	63.0	63.0	300.0
2012-06-22 07:00:00	QQQ	ETF	62.93	62.95	62.65	62.79	22200.0
2012-06-22 08:00:00	QQQ	ETF	62.79	62.85	62.7	62.85	141550.0
2012-06-22 09:00:00	QQQ	ETF	62.85	62.99	62.731	62.91	4210171.0
2012-06-22 10:00:00	QQQ	ETF	62.91	63.1	62.75	62.89	5852741.0
2012-06-22 11:00:00	QQQ	ETF	62.89	63.05	62.88	63.0	3786633.0
2012-06-22 12:00:00	QQQ	ETF	63.0	63.06	62.91	63.025	2884085.0
2012-06-22 13:00:00	QQQ	ETF	63.02	63.09	62.97	63.07	1300550.0
2012-06-22 14:00:00	QQQ	ETF	63.08	63.28	63.08	63.2701	2603592.0
2012-06-22 15:00:00	QQQ	ETF	63.27	63.43	63.17	63.37	6648759.0
2012-06-22 16:00:00	QQQ	ETF	63.36	63.41	62.74	63.28	1411490.0
2012-06-22 17:00:00	QQQ	ETF	63.28	63.29	63.23	63.23	11196.0
2012-06-22 18:00:00	QQQ	ETF	63.29	63.29	63.24	63.29	1662.0
2012-06-22 19:00:00	QQQ	ETF	63.27	63.3	63.23	63.23	7825.0
2012-06-22 07:00:00	IWM	ETF	77.0	77.0	76.65	76.87	71121.0
2012-06-22 08:00:00	IWM	ETF	76.85	77.09	76.83	76.97	423448.0
2012-06-22 09:00:00	IWM	ETF	76.96	77.15	76.65	76.93	5272066.0
2012-06-22 10:00:00	IWM	ETF	76.93	77.17	76.83	77.05	6658453.0
2012-06-22 11:00:00	IWM	ETF	77.05	77.29	77.025	77.17	4690590.0
2012-06-22 12:00:00	IWM	ETF	77.17	77.21	77.01	77.11	2659443.0
2012-06-22 13:00:00	IWM	ETF	77.11	77.27	77.06	77.24	1987104.0
2012-06-22 14:00:00	IWM	ETF	77.2401	77.56	77.23	77.56	4277215.0
2012-06-22 15:00:00	IWM	ETF	77.5601	77.74	77.42	77.52	10977037.0
2012-06-22 16:00:00	IWM	ETF	77.52	77.6312	77.27	77.37	2552012.0
2012-06-22 17:00:00	IWM	ETF	77.39	77.4	77.26	77.26	105796.0
2012-06-22 19:00:00	IWM	ETF	77.39	77.39	77.3	77.35	1900.0
2012-06-22 08:00:00	DIA	ETF	125.86	125.9	125.83	125.84	1670.0
2012-06-22 09:00:00	DIA	ETF	125.95	126.22	125.88	126.19	577692.0
2012-06-22 10:00:00	DIA	ETF	126.22	126.35	125.78	126.02	1084076.0
2012-06-22 11:00:00	DIA	ETF	126.03	126.15	125.94	126.1255	523004.0
2012-06-22 12:00:00	DIA	ETF	126.13	126.15	125.88	125.9241	425902.0
2012-06-22 13:00:00	DIA	ETF	125.91	126.09	125.81	126.05	235824.0
2012-06-22 14:00:00	DIA	ETF	126.07	126.28	126.0	126.26	331613.0
2012-06-22 15:00:00	DIA	ETF	126.27	126.48	126.08	126.28	931381.0

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

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