PREVIEW / etf_1hour / 2012-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-15.parquet
  size:    184 KB
  rows:    5,725

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-15 04:00:00	SPY	ETF	140.02	140.2	140.01	140.13	36300.0
2012-03-15 05:00:00	SPY	ETF	140.16	140.37	140.12	140.2	67054.0
2012-03-15 06:00:00	SPY	ETF	140.15	140.15	140.03	140.1	35108.0
2012-03-15 07:00:00	SPY	ETF	140.07	140.32	140.07	140.3	278198.0
2012-03-15 08:00:00	SPY	ETF	140.29	140.38	140.182	140.24	723907.0
2012-03-15 09:00:00	SPY	ETF	140.24	140.269	139.76	140.025	18014753.0
2012-03-15 10:00:00	SPY	ETF	140.02	140.38	139.86	140.15	29919186.0
2012-03-15 11:00:00	SPY	ETF	140.15	140.34	140.02	140.29	15908451.0
2012-03-15 12:00:00	SPY	ETF	140.295	140.74	140.28	140.63	16882737.0
2012-03-15 13:00:00	SPY	ETF	140.63	140.7	140.42	140.4599	15898984.0
2012-03-15 14:00:00	SPY	ETF	140.46	140.68	140.37	140.63	13661380.0
2012-03-15 15:00:00	SPY	ETF	140.63	140.78	140.54	140.68	28212840.0
2012-03-15 16:00:00	SPY	ETF	140.67	140.72	139.9186	140.57	17914432.0
2012-03-15 17:00:00	SPY	ETF	140.57	140.59	140.51	140.59	3233217.0
2012-03-15 18:00:00	SPY	ETF	140.59	140.64	140.52	140.55	93912.0
2012-03-15 19:00:00	SPY	ETF	140.53	140.63	140.53	140.59	142112.0
2012-03-15 05:00:00	QQQ	ETF	66.65	66.65	66.65	66.65	500.0
2012-03-15 07:00:00	QQQ	ETF	66.4	66.68	66.4	66.68	16900.0
2012-03-15 08:00:00	QQQ	ETF	66.68	66.73	66.65	66.7	212500.0
2012-03-15 09:00:00	QQQ	ETF	66.69	66.72	66.48	66.65	5989496.0
2012-03-15 10:00:00	QQQ	ETF	66.65	66.77	66.35	66.5779	11686692.0
2012-03-15 11:00:00	QQQ	ETF	66.575	66.75	66.47	66.67	5171459.0
2012-03-15 12:00:00	QQQ	ETF	66.68	66.82	66.65	66.7221	3772132.0
2012-03-15 13:00:00	QQQ	ETF	66.72	66.77	66.43	66.49	8755543.0
2012-03-15 14:00:00	QQQ	ETF	66.4891	66.72	66.36	66.67	6610082.0
2012-03-15 15:00:00	QQQ	ETF	66.675	66.74	66.555	66.67	11859208.0
2012-03-15 16:00:00	QQQ	ETF	66.67	66.72	66.61	66.64	699627.0
2012-03-15 17:00:00	QQQ	ETF	66.64	66.68	66.64	66.67	8250.0
2012-03-15 18:00:00	QQQ	ETF	66.68	66.68	66.64	66.64	23873.0
2012-03-15 19:00:00	QQQ	ETF	66.64	66.67	66.64	66.66	8210.0
2012-03-15 06:00:00	IWM	ETF	82.5	82.5	82.5	82.5	3000.0
2012-03-15 07:00:00	IWM	ETF	82.26	82.6	82.26	82.55	6335.0
2012-03-15 08:00:00	IWM	ETF	82.58	82.64	82.43	82.45	195513.0
2012-03-15 09:00:00	IWM	ETF	82.39	82.45	82.03	82.36	4927771.0
2012-03-15 10:00:00	IWM	ETF	82.36	82.7	82.11	82.28	9470997.0
2012-03-15 11:00:00	IWM	ETF	82.29	82.66	82.09	82.41	5868715.0
2012-03-15 12:00:00	IWM	ETF	82.42	83.1	82.42	82.97	5960544.0
2012-03-15 13:00:00	IWM	ETF	82.98	83.05	82.68	82.81	3692721.0
2012-03-15 14:00:00	IWM	ETF	82.82	83.08	82.71	83.04	6056782.0
2012-03-15 15:00:00	IWM	ETF	83.04	83.12	82.95	83.1	8414754.0
2012-03-15 16:00:00	IWM	ETF	83.1	83.12	82.3251	82.96	4607409.0
2012-03-15 17:00:00	IWM	ETF	82.96	82.99	82.94	82.99	7955.0
2012-03-15 18:00:00	IWM	ETF	82.98	83.0	82.98	83.0	1800.0
2012-03-15 19:00:00	IWM	ETF	82.95	82.96	82.95	82.96	400.0
2012-03-15 05:00:00	DIA	ETF	132.1	132.1	132.1	132.1	100.0
2012-03-15 08:00:00	DIA	ETF	132.2	132.28	132.12	132.12	9100.0
2012-03-15 09:00:00	DIA	ETF	132.12	132.12	131.67	131.815	882251.0
2012-03-15 10:00:00	DIA	ETF	131.82	132.09	131.71	131.95	1213198.0
2012-03-15 11:00:00	DIA	ETF	131.96	132.08	131.85	132.05	556643.0
2012-03-15 12:00:00	DIA	ETF	132.047	132.35	132.04	132.3	663700.0

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

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