PREVIEW / etf_1hour / 2012-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-28.parquet
  size:    183 KB
  rows:    5,641

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-28 04:00:00	SPY	ETF	141.47	141.6	141.23	141.25	23263.0
2012-03-28 05:00:00	SPY	ETF	141.39	141.39	141.39	141.39	20000.0
2012-03-28 06:00:00	SPY	ETF	141.29	141.42	141.2	141.42	23600.0
2012-03-28 07:00:00	SPY	ETF	141.38	141.52	141.31	141.35	216212.0
2012-03-28 08:00:00	SPY	ETF	141.33	141.46	140.95	140.96	2361055.0
2012-03-28 09:00:00	SPY	ETF	140.95	141.32	140.83	141.02	16231922.0
2012-03-28 10:00:00	SPY	ETF	141.02	141.21	140.51	140.71	20317385.0
2012-03-28 11:00:00	SPY	ETF	140.715	140.73	139.72	140.01	22919947.0
2012-03-28 12:00:00	SPY	ETF	140.02	140.22	139.92	140.03	15133445.0
2012-03-28 13:00:00	SPY	ETF	140.035	140.155	139.83	139.99	13755463.0
2012-03-28 14:00:00	SPY	ETF	139.99	140.18	139.64	140.15	15113552.0
2012-03-28 15:00:00	SPY	ETF	140.16	140.52	140.04	140.47	27913175.0
2012-03-28 16:00:00	SPY	ETF	140.45	141.1866	140.3613	140.38	8003912.0
2012-03-28 17:00:00	SPY	ETF	140.4	140.51	140.4	140.47	172180.0
2012-03-28 18:00:00	SPY	ETF	140.48	140.59	140.47	140.52	120278.0
2012-03-28 19:00:00	SPY	ETF	140.52	140.57	140.44	140.54	37752.0
2012-03-28 04:00:00	QQQ	ETF	68.34	68.34	68.34	68.34	100.0
2012-03-28 07:00:00	QQQ	ETF	68.3	68.38	68.27	68.3	41000.0
2012-03-28 08:00:00	QQQ	ETF	68.27	68.47	68.15	68.15	1852230.0
2012-03-28 09:00:00	QQQ	ETF	68.15	68.51	68.14	68.37	4698470.0
2012-03-28 10:00:00	QQQ	ETF	68.36	68.44	68.052	68.13	7615104.0
2012-03-28 11:00:00	QQQ	ETF	68.14	68.18	67.6601	67.78	6467847.0
2012-03-28 12:00:00	QQQ	ETF	67.77	67.84	67.65	67.76	5250914.0
2012-03-28 13:00:00	QQQ	ETF	67.7699	67.84	67.59	67.705	3160250.0
2012-03-28 14:00:00	QQQ	ETF	67.705	67.87	67.54	67.855	5357541.0
2012-03-28 15:00:00	QQQ	ETF	67.86	68.0	67.81	67.93	7834259.0
2012-03-28 16:00:00	QQQ	ETF	67.93	68.01	67.8854	67.95	1617342.0
2012-03-28 17:00:00	QQQ	ETF	67.96	68.0	67.93	67.96	25550.0
2012-03-28 18:00:00	QQQ	ETF	67.98	68.01	67.98	68.0	22580.0
2012-03-28 19:00:00	QQQ	ETF	67.96	68.0	67.96	67.99	4190.0
2012-03-28 04:00:00	IWM	ETF	84.01	84.15	84.01	84.15	800.0
2012-03-28 06:00:00	IWM	ETF	83.81	84.2	83.81	84.2	200.0
2012-03-28 07:00:00	IWM	ETF	84.19	84.27	84.07	84.14	8780.0
2012-03-28 08:00:00	IWM	ETF	84.1	84.2	83.79	83.79	166133.0
2012-03-28 09:00:00	IWM	ETF	83.79	84.02	83.45	83.74	6950981.0
2012-03-28 10:00:00	IWM	ETF	83.74	83.98	83.07	83.256	8278136.0
2012-03-28 11:00:00	IWM	ETF	83.26	83.37	82.62	82.81	7432675.0
2012-03-28 12:00:00	IWM	ETF	82.81	82.975	82.65	82.81	5024999.0
2012-03-28 13:00:00	IWM	ETF	82.8115	82.89	82.65	82.87	2675810.0
2012-03-28 14:00:00	IWM	ETF	82.86	83.06	82.6099	83.05	4498183.0
2012-03-28 15:00:00	IWM	ETF	83.041	83.33	82.97	83.33	8991611.0
2012-03-28 16:00:00	IWM	ETF	83.33	83.37	83.11	83.15	1831542.0
2012-03-28 17:00:00	IWM	ETF	83.15	83.2	83.15	83.2	10346.0
2012-03-28 18:00:00	IWM	ETF	83.16	83.25	83.16	83.25	3610.0
2012-03-28 19:00:00	IWM	ETF	83.23	83.23	83.15	83.15	2971.0
2012-03-28 07:00:00	DIA	ETF	131.98	131.99	131.93	131.93	3000.0
2012-03-28 08:00:00	DIA	ETF	131.93	132.0	131.75	131.75	5200.0
2012-03-28 09:00:00	DIA	ETF	131.63	131.86	131.49	131.65	885066.0
2012-03-28 10:00:00	DIA	ETF	131.67	131.78	131.19	131.34	837464.0
2012-03-28 11:00:00	DIA	ETF	131.33	131.46	130.55	130.77	1087274.0

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

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