PREVIEW / etf_1hour / 2011-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-29.parquet
  size:    175 KB
  rows:    5,312

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-03-29 04:00:00	SPY	ETF	130.9	131.1	130.89	131.07	3800.0
2011-03-29 05:00:00	SPY	ETF	131.09	131.11	130.78	130.86	37500.0
2011-03-29 06:00:00	SPY	ETF	130.86	130.9	130.71	130.71	22150.0
2011-03-29 07:00:00	SPY	ETF	130.79	131.0	130.71	130.99	1010670.0
2011-03-29 08:00:00	SPY	ETF	130.96	131.0	130.68	130.88	1210539.0
2011-03-29 09:00:00	SPY	ETF	130.87	130.97	130.44	130.59	19717064.0
2011-03-29 10:00:00	SPY	ETF	130.62	131.25	130.5	131.17	23788514.0
2011-03-29 11:00:00	SPY	ETF	131.17	131.56	131.12	131.46	16528494.0
2011-03-29 12:00:00	SPY	ETF	131.465	131.56	131.35	131.48	10731483.0
2011-03-29 13:00:00	SPY	ETF	131.482	131.56	131.4	131.5	10410040.0
2011-03-29 14:00:00	SPY	ETF	131.5	131.81	131.48	131.7601	15843985.0
2011-03-29 15:00:00	SPY	ETF	131.77	131.9	131.6408	131.84	19969786.0
2011-03-29 16:00:00	SPY	ETF	131.85	132.29	130.6605	132.13	9227223.0
2011-03-29 17:00:00	SPY	ETF	132.13	132.2	132.08	132.17	201607.0
2011-03-29 18:00:00	SPY	ETF	132.17	132.17	131.86	131.93	440353.0
2011-03-29 19:00:00	SPY	ETF	131.94	131.96	131.88	131.95	165168.0
2011-03-29 20:00:00	SPY	ETF	131.96	131.96	131.96	131.96	100.0
2011-03-29 04:00:00	QQQ	ETF	56.61	56.64	56.58	56.64	1231.0
2011-03-29 06:00:00	QQQ	ETF	56.52	56.52	56.52	56.52	900.0
2011-03-29 07:00:00	QQQ	ETF	56.49	56.58	56.45	56.54	29059.0
2011-03-29 08:00:00	QQQ	ETF	56.55	56.55	56.38	56.41	366588.0
2011-03-29 09:00:00	QQQ	ETF	56.41	56.52	56.23	56.45	5622020.0
2011-03-29 10:00:00	QQQ	ETF	56.45	56.83	56.43	56.79	6791926.0
2011-03-29 11:00:00	QQQ	ETF	56.79	56.985	56.79	56.96	5618145.0
2011-03-29 12:00:00	QQQ	ETF	56.96	56.98	56.83	56.9	3878979.0
2011-03-29 13:00:00	QQQ	ETF	56.9075	56.92	56.79	56.86	3010810.0
2011-03-29 14:00:00	QQQ	ETF	56.85	56.99	56.85	56.96	2845369.0
2011-03-29 15:00:00	QQQ	ETF	56.96	57.06	56.91	57.05	6261038.0
2011-03-29 16:00:00	QQQ	ETF	57.05	57.15	56.953	57.09	1945010.0
2011-03-29 17:00:00	QQQ	ETF	57.09	57.13	57.08	57.11	133110.0
2011-03-29 18:00:00	QQQ	ETF	57.09	57.1	57.0	57.02	204626.0
2011-03-29 19:00:00	QQQ	ETF	57.03	57.04	57.0	57.0	11289.0
2011-03-29 04:00:00	IWM	ETF	81.83	82.21	81.83	82.21	1352.0
2011-03-29 05:00:00	IWM	ETF	82.2	82.2	82.16	82.16	10000.0
2011-03-29 06:00:00	IWM	ETF	82.04	82.04	82.04	82.04	2000.0
2011-03-29 07:00:00	IWM	ETF	82.03	82.23	82.03	82.23	153010.0
2011-03-29 08:00:00	IWM	ETF	82.21	82.23	81.91	82.06	497241.0
2011-03-29 09:00:00	IWM	ETF	82.07	82.17	81.58	81.86	5647441.0
2011-03-29 10:00:00	IWM	ETF	81.86	82.555	81.75	82.42	8781576.0
2011-03-29 11:00:00	IWM	ETF	82.43	82.73	82.425	82.67	4227821.0
2011-03-29 12:00:00	IWM	ETF	82.66	82.6925	82.54	82.59	2144012.0
2011-03-29 13:00:00	IWM	ETF	82.58	82.72	82.57	82.65	1536760.0
2011-03-29 14:00:00	IWM	ETF	82.65	82.82	82.63	82.779	3135728.0
2011-03-29 15:00:00	IWM	ETF	82.78	82.89	82.7	82.8	7092977.0
2011-03-29 16:00:00	IWM	ETF	82.79	82.9997	82.73	82.9	1068203.0
2011-03-29 17:00:00	IWM	ETF	82.87	82.9	82.87	82.9	7700.0
2011-03-29 18:00:00	IWM	ETF	82.9	82.9	82.82	82.82	13500.0
2011-03-29 19:00:00	IWM	ETF	82.83	82.9	82.83	82.86	12775.0
2011-03-29 07:00:00	DIA	ETF	121.77	121.77	121.6	121.6	7900.0
2011-03-29 08:00:00	DIA	ETF	121.79	121.83	121.71	121.74	7200.0

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

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