PREVIEW / etf_1hour / 2012-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-26.parquet
  size:    189 KB
  rows:    5,819

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-03-26 04:00:00	SPY	ETF	140.03	140.03	139.81	139.81	4140.0
2012-03-26 05:00:00	SPY	ETF	139.81	140.11	139.78	140.11	21390.0
2012-03-26 06:00:00	SPY	ETF	140.07	140.33	140.07	140.2	17715.0
2012-03-26 07:00:00	SPY	ETF	140.2	140.46	140.2	140.28	296916.0
2012-03-26 08:00:00	SPY	ETF	140.28	140.85	140.27	140.71	1764740.0
2012-03-26 09:00:00	SPY	ETF	140.7	140.84	140.6	140.8	13856652.0
2012-03-26 10:00:00	SPY	ETF	140.81	141.11	140.71	141.02	15597122.0
2012-03-26 11:00:00	SPY	ETF	141.015	141.03	140.9	140.93	10715268.0
2012-03-26 12:00:00	SPY	ETF	140.93	140.97	140.79	140.84	7657550.0
2012-03-26 13:00:00	SPY	ETF	140.84	141.06	140.82	141.0	6817451.0
2012-03-26 14:00:00	SPY	ETF	140.999	141.33	140.99	141.251	12056415.0
2012-03-26 15:00:00	SPY	ETF	141.255	141.57	141.21	141.56	34389318.0
2012-03-26 16:00:00	SPY	ETF	141.56	141.99	139.5989	141.91	13291825.0
2012-03-26 17:00:00	SPY	ETF	141.91	142.04	141.89	141.91	372282.0
2012-03-26 18:00:00	SPY	ETF	141.91	142.05	141.91	142.01	414665.0
2012-03-26 19:00:00	SPY	ETF	142.01	142.05	141.96	141.97	284955.0
2012-03-26 06:00:00	QQQ	ETF	67.2	67.28	67.2	67.28	2185.0
2012-03-26 07:00:00	QQQ	ETF	67.3	67.36	67.28	67.28	44126.0
2012-03-26 08:00:00	QQQ	ETF	67.28	67.51	67.27	67.42	321107.0
2012-03-26 09:00:00	QQQ	ETF	67.42	67.47	67.33	67.46	5359812.0
2012-03-26 10:00:00	QQQ	ETF	67.45	67.6	67.4	67.59	5416885.0
2012-03-26 11:00:00	QQQ	ETF	67.58	67.68	67.54	67.64	5025976.0
2012-03-26 12:00:00	QQQ	ETF	67.64	67.67	67.58	67.6333	2903898.0
2012-03-26 13:00:00	QQQ	ETF	67.635	67.82	67.61	67.792	2759872.0
2012-03-26 14:00:00	QQQ	ETF	67.792	67.97	67.79	67.9179	4738642.0
2012-03-26 15:00:00	QQQ	ETF	67.9199	68.11	67.89	68.108	9721548.0
2012-03-26 16:00:00	QQQ	ETF	68.11	68.2	68.0465	68.16	868251.0
2012-03-26 17:00:00	QQQ	ETF	68.19	68.21	68.15	68.2	13321.0
2012-03-26 18:00:00	QQQ	ETF	68.17	68.24	68.17	68.22	23390.0
2012-03-26 19:00:00	QQQ	ETF	68.21	68.23	68.2	68.22	20674.0
2012-03-26 04:00:00	IWM	ETF	83.02	83.02	83.02	83.02	100.0
2012-03-26 05:00:00	IWM	ETF	83.1	83.21	83.1	83.21	200.0
2012-03-26 06:00:00	IWM	ETF	83.25	83.5	83.25	83.5	2000.0
2012-03-26 07:00:00	IWM	ETF	83.49	83.66	83.46	83.47	117500.0
2012-03-26 08:00:00	IWM	ETF	83.46	83.92	83.44	83.79	739949.0
2012-03-26 09:00:00	IWM	ETF	83.8	83.911	83.66	83.79	6804617.0
2012-03-26 10:00:00	IWM	ETF	83.79	84.33	83.62	84.23	7379704.0
2012-03-26 11:00:00	IWM	ETF	84.23	84.35	84.14	84.24	6220197.0
2012-03-26 12:00:00	IWM	ETF	84.24	84.27	83.96	84.04	3682648.0
2012-03-26 13:00:00	IWM	ETF	84.04	84.26	83.96	84.24	2907412.0
2012-03-26 14:00:00	IWM	ETF	84.24	84.38	84.21	84.35	5795190.0
2012-03-26 15:00:00	IWM	ETF	84.36	84.46	84.15	84.36	10167008.0
2012-03-26 16:00:00	IWM	ETF	84.39	84.64	82.7708	84.59	2883081.0
2012-03-26 17:00:00	IWM	ETF	84.55	84.67	84.4	84.4	12837.0
2012-03-26 18:00:00	IWM	ETF	84.55	84.57	84.41	84.48	16800.0
2012-03-26 19:00:00	IWM	ETF	84.48	84.5	84.48	84.5	7500.0
2012-03-26 05:00:00	DIA	ETF	130.88	130.88	130.88	130.88	300.0
2012-03-26 06:00:00	DIA	ETF	130.95	131.17	130.95	131.17	13500.0
2012-03-26 07:00:00	DIA	ETF	131.19	131.42	131.1	131.17	2100.0
2012-03-26 08:00:00	DIA	ETF	131.06	131.56	131.06	131.5	27459.0

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

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