PREVIEW / etf_1hour / 2011-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-18.parquet
  size:    184 KB
  rows:    5,620

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
2011-04-18 04:00:00	SPY	ETF	132.3	132.3	131.48	131.48	104179.0
2011-04-18 05:00:00	SPY	ETF	131.57	131.66	131.47	131.54	29500.0
2011-04-18 06:00:00	SPY	ETF	131.5	131.5	131.3	131.42	145950.0
2011-04-18 07:00:00	SPY	ETF	131.42	131.55	131.35	131.41	452220.0
2011-04-18 08:00:00	SPY	ETF	131.42	132.08	131.37	131.4	1628022.0
2011-04-18 09:00:00	SPY	ETF	131.39	131.45	129.97	130.01	44471315.0
2011-04-18 10:00:00	SPY	ETF	130.01	130.25	129.6	129.69	41199929.0
2011-04-18 11:00:00	SPY	ETF	129.7	130.1	129.51	130.01	25995138.0
2011-04-18 12:00:00	SPY	ETF	130.02	130.12	129.85	129.96	9067214.0
2011-04-18 13:00:00	SPY	ETF	129.96	130.24	129.76	130.2	12309212.0
2011-04-18 14:00:00	SPY	ETF	130.2	132.0301	130.07	130.53	26721735.0
2011-04-18 15:00:00	SPY	ETF	130.53	130.81	130.29	130.55	36384114.0
2011-04-18 16:00:00	SPY	ETF	130.56	132.0301	130.04	130.41	11229570.0
2011-04-18 17:00:00	SPY	ETF	130.4	130.47	130.36	130.41	146570.0
2011-04-18 18:00:00	SPY	ETF	130.43	130.53	130.25	130.3	285577.0
2011-04-18 19:00:00	SPY	ETF	130.28	130.32	130.2	130.3	94002.0
2011-04-18 04:00:00	QQQ	ETF	56.59	56.6	56.55	56.55	600.0
2011-04-18 05:00:00	QQQ	ETF	56.51	56.53	56.48	56.53	41600.0
2011-04-18 06:00:00	QQQ	ETF	56.5	56.5	56.4	56.44	13426.0
2011-04-18 07:00:00	QQQ	ETF	56.45	56.49	56.41	56.41	110656.0
2011-04-18 08:00:00	QQQ	ETF	56.47	56.51	56.44	56.46	305678.0
2011-04-18 09:00:00	QQQ	ETF	56.45	56.47	55.55	55.6	13564114.0
2011-04-18 10:00:00	QQQ	ETF	55.59	55.62	55.32	55.425	11345069.0
2011-04-18 11:00:00	QQQ	ETF	55.41	55.67	55.37	55.63	5425345.0
2011-04-18 12:00:00	QQQ	ETF	55.6384	55.71	55.59	55.66	2746004.0
2011-04-18 13:00:00	QQQ	ETF	55.67	55.9	55.53	55.88	3396202.0
2011-04-18 14:00:00	QQQ	ETF	55.88	56.15	55.8	56.09	5855948.0
2011-04-18 15:00:00	QQQ	ETF	56.08	56.27	55.943	56.25	9848159.0
2011-04-18 16:00:00	QQQ	ETF	56.25	56.6254	55.7741	56.23	7711337.0
2011-04-18 17:00:00	QQQ	ETF	56.23	56.25	56.18	56.18	63227.0
2011-04-18 18:00:00	QQQ	ETF	56.21	56.25	56.18	56.18	39433.0
2011-04-18 19:00:00	QQQ	ETF	56.16	56.18	56.15	56.15	8519.0
2011-04-18 04:00:00	IWM	ETF	83.28	83.28	82.89	83.18	2293.0
2011-04-18 05:00:00	IWM	ETF	83.03	83.03	83.0	83.0	800.0
2011-04-18 06:00:00	IWM	ETF	82.98	82.98	82.8	82.82	6700.0
2011-04-18 07:00:00	IWM	ETF	82.87	82.98	82.85	82.9	31700.0
2011-04-18 08:00:00	IWM	ETF	82.91	83.01	82.88	82.97	220631.0
2011-04-18 09:00:00	IWM	ETF	82.95	82.96	81.74	81.97	10656844.0
2011-04-18 10:00:00	IWM	ETF	81.96	82.15	81.57	81.72	10894103.0
2011-04-18 11:00:00	IWM	ETF	81.72	81.91	81.51	81.77	4839928.0
2011-04-18 12:00:00	IWM	ETF	81.77	81.81	81.57	81.61	3558654.0
2011-04-18 13:00:00	IWM	ETF	81.62	81.79	81.43	81.74	2462429.0
2011-04-18 14:00:00	IWM	ETF	81.73	82.06	81.615	81.96	5405767.0
2011-04-18 15:00:00	IWM	ETF	81.97	82.2	81.76	82.13	10853476.0
2011-04-18 16:00:00	IWM	ETF	82.14	83.3955	82.09	83.3955	4964009.0
2011-04-18 17:00:00	IWM	ETF	82.1	82.1	82.07	82.07	28798.0
2011-04-18 18:00:00	IWM	ETF	82.1	82.1	82.07	82.07	1202.0
2011-04-18 19:00:00	IWM	ETF	82.07	82.07	82.0	82.01	3456.0
2011-04-18 04:00:00	DIA	ETF	122.88	122.88	122.88	122.88	200.0
2011-04-18 05:00:00	DIA	ETF	122.79	122.79	122.65	122.65	13200.0

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

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