PREVIEW / etf_1hour / 2012-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-29.parquet
  size:    180 KB
  rows:    5,602

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-05-29 04:00:00	SPY	ETF	133.28	133.35	132.95	132.95	8077.0
2012-05-29 05:00:00	SPY	ETF	133.08	133.09	132.69	132.69	12258.0
2012-05-29 06:00:00	SPY	ETF	132.79	132.98	132.71	132.98	59147.0
2012-05-29 07:00:00	SPY	ETF	132.98	133.04	132.82	132.95	445739.0
2012-05-29 08:00:00	SPY	ETF	132.94	133.0	132.1	132.9	1077630.0
2012-05-29 09:00:00	SPY	ETF	132.91	133.45	132.84	133.23	16405747.0
2012-05-29 10:00:00	SPY	ETF	133.27	133.93	132.94	133.78	25366084.0
2012-05-29 11:00:00	SPY	ETF	133.78	133.81	132.9199	133.07	26130524.0
2012-05-29 12:00:00	SPY	ETF	133.065	133.14	132.75	132.945	20246306.0
2012-05-29 13:00:00	SPY	ETF	132.94	133.7	132.75	133.099	11553757.0
2012-05-29 14:00:00	SPY	ETF	133.092	133.33	132.93	133.29	10840204.0
2012-05-29 15:00:00	SPY	ETF	133.2905	133.75	133.19	133.689	27980206.0
2012-05-29 16:00:00	SPY	ETF	133.69	133.98	132.1946	133.82	7633966.0
2012-05-29 17:00:00	SPY	ETF	133.84	133.85	133.71	133.75	247128.0
2012-05-29 18:00:00	SPY	ETF	133.75	133.77	133.52	133.57	242100.0
2012-05-29 19:00:00	SPY	ETF	133.57	133.61	133.5	133.56	204407.0
2012-05-29 04:00:00	QQQ	ETF	62.57	62.57	62.57	62.57	100.0
2012-05-29 06:00:00	QQQ	ETF	62.42	62.55	62.42	62.55	17602.0
2012-05-29 07:00:00	QQQ	ETF	62.56	62.57	62.46	62.49	11550.0
2012-05-29 08:00:00	QQQ	ETF	62.52	62.52	62.38	62.48	101200.0
2012-05-29 09:00:00	QQQ	ETF	62.48	62.65	62.4	62.56	6355056.0
2012-05-29 10:00:00	QQQ	ETF	62.56	63.15	62.44	62.98	11453637.0
2012-05-29 11:00:00	QQQ	ETF	62.98	62.99	62.46	62.5201	5598958.0
2012-05-29 12:00:00	QQQ	ETF	62.52	62.56	62.28	62.46	6551720.0
2012-05-29 13:00:00	QQQ	ETF	62.46	62.58	62.35	62.5601	2749317.0
2012-05-29 14:00:00	QQQ	ETF	62.562	62.75	62.51	62.73	2708897.0
2012-05-29 15:00:00	QQQ	ETF	62.725	62.91	62.63	62.83	5250375.0
2012-05-29 16:00:00	QQQ	ETF	62.83	63.02	62.063	62.87	1183921.0
2012-05-29 17:00:00	QQQ	ETF	62.87	62.9	62.84	62.9	38300.0
2012-05-29 18:00:00	QQQ	ETF	62.88	62.88	62.78	62.78	25700.0
2012-05-29 19:00:00	QQQ	ETF	62.84	62.84	62.77	62.79	4175.0
2012-05-29 04:00:00	IWM	ETF	77.34	77.49	77.34	77.49	725.0
2012-05-29 05:00:00	IWM	ETF	77.0	77.0	76.9	76.9	600.0
2012-05-29 06:00:00	IWM	ETF	76.95	77.2	76.95	77.2	3500.0
2012-05-29 07:00:00	IWM	ETF	77.15	77.21	77.07	77.21	5995.0
2012-05-29 08:00:00	IWM	ETF	77.08	77.22	76.97	77.2	75652.0
2012-05-29 09:00:00	IWM	ETF	77.19	77.44	77.08	77.25	5496353.0
2012-05-29 10:00:00	IWM	ETF	77.34	77.91	77.07	77.72	10191951.0
2012-05-29 11:00:00	IWM	ETF	77.7199	77.72	76.9199	77.04	7711105.0
2012-05-29 12:00:00	IWM	ETF	77.04	77.21	76.76	77.02	5153883.0
2012-05-29 13:00:00	IWM	ETF	77.01	77.2701	76.91	77.185	3592817.0
2012-05-29 14:00:00	IWM	ETF	77.18	77.51	77.14	77.469	4718531.0
2012-05-29 15:00:00	IWM	ETF	77.47	77.73	77.25	77.68	7423390.0
2012-05-29 16:00:00	IWM	ETF	77.685	77.86	77.5677	77.76	1037861.0
2012-05-29 17:00:00	IWM	ETF	77.75	77.75	77.72	77.72	17808.0
2012-05-29 18:00:00	IWM	ETF	77.76	77.76	77.51	77.51	20817.0
2012-05-29 19:00:00	IWM	ETF	77.51	77.6	77.51	77.56	800.0
2012-05-29 07:00:00	DIA	ETF	124.97	124.97	124.92	124.92	1400.0
2012-05-29 08:00:00	DIA	ETF	125.07	125.09	124.92	125.05	31200.0
2012-05-29 09:00:00	DIA	ETF	125.02	125.54	125.02	125.35	719089.0

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

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